Not sure why I am not getting updated rows. I have a simple two-column spreadsheet with Category ID in column 0 and Picture URL in Column 1. I have it mapped like that too. I verified the URL is good by pasting in a browser and image displays. Checked the debugging output and I see it is reading the name of the categories which I do not provide in the spreadsheet. It reports a correct row count but 0 updated. Is there something I am missing? Worked fine for products when I did those a few weeks ago.
Job Output
Import file 'C:\Inetpub\vhosts\**redacted**\httpdocs\import\idsubcat.xlsx'
- The file has 60 rows.
- Success Updated 0 rows.
Samples from the debug log
ReadOneRowItemsFromList. step 3. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, row.Count=2, rowNumber=62
2018.11.08 07:19:18:5237*******
ReadCategoryValue. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, rowCount=62, value=http://**redacted**/products/6x26IWRC.gif, columnDestination=Picture
2018.11.08 07:19:18:5863*******
ImportManagerProcessing.XML. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, byteArray.count()=11487
- MemoryStream was created
- step 1
- rowNumber=1
- rowNumber=2
ImportImportTemplate. Start update product using data from the file 'C:\inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx'
2018.11.08 07:19:18:6487*******
ImportCategoryService. ImportEntity. Id=3, Name=Binder Chains
2018.11.08 07:19:18:6487*******