I exported products to CSV. A field was updated for each product, and I am trying to use the CSV Data Upload, but it is not working. If I select "IMPORT new objects, UPDATE existing objects" all products get duplicated. If I select "Only UPDATE existing objects" nothing gets updated. The ProductIDs in the CSV match what is in the ac_Products table, but the importer doesn't seem to be making the connection.
Is this broken?
Date Port not working
Re: Date Port not working
Could you please post the CSV in question here with some entries that are being imported instead of being updated?
Also have a look at following thread
viewtopic.php?f=61&t=11578
and may you are having a similar issue.
Also have a look at following thread
viewtopic.php?f=61&t=11578
and may you are having a similar issue.
Re: Date Port not working
I PM'd you a link to the file.mazhar wrote:Could you please post the CSV in question here with some entries that are being imported instead of being updated?
Also have a look at following thread
viewtopic.php?f=61&t=11578
and may you are having a similar issue.
Re: Date Port not working
Your CSV is not properly formated. In the very start it got an invalid character
the correct should be
Update your CSV header line with second one and try again.
Code: Select all
"""ProductId""",StoreId,Name,Price,CostOfGoods,MSRP,Weight,Length,Width,Height,Manufacturer,Sku,ModelNumber,DisplayPage,TaxCode,Shippable,WarehouseId,Warehouse,InventoryModeId,InStock,InStockWarningLevel,ThumbnailUrl,ThumbnailAltText,ImageUrl,ImageAltText,Summary,Description,ExtendedDescription,Vendor,CreatedDate,LastModifiedDate,ProductTemplate,IsFeatured,IsProhibited,AllowReviews,AllowBackorder,WrapGroup,ExcludeFromFeed,HtmlHead,DisablePurchase,MinQuantity,MaxQuantity,VisibilityId,Theme,IconUrl,IconAltText,IsGiftCertificate,Categories,UseVariablePrice,MinimumPrice,MaximumPrice,SearchKeywords,HidePrice,MSExcelWorkAround
Code: Select all
"ProductId",StoreId,Name,Price,CostOfGoods,MSRP,Weight,Length,Width,Height,Manufacturer,Sku,ModelNumber,DisplayPage,TaxCode,Shippable,WarehouseId,Warehouse,InventoryModeId,InStock,InStockWarningLevel,ThumbnailUrl,ThumbnailAltText,ImageUrl,ImageAltText,Summary,Description,ExtendedDescription,Vendor,CreatedDate,LastModifiedDate,ProductTemplate,IsFeatured,IsProhibited,AllowReviews,AllowBackorder,WrapGroup,ExcludeFromFeed,HtmlHead,DisablePurchase,MinQuantity,MaxQuantity,VisibilityId,Theme,IconUrl,IconAltText,IsGiftCertificate,Categories,UseVariablePrice,MinimumPrice,MaximumPrice,SearchKeywords,HidePrice,MSExcelWorkAround