You have no items in your shopping cart.

Profile: jmhpickpro

Avatar
Statistics

    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*******


    6 years ago

    Powered by nopCommerce

    Copyright © 2023 FoxNetSoft. All rights reserved