Mobile app version of vmapp.org
Login or Join
Dunderdale272

: Magento Bulk Product Import + Modules Nightmare Have 5,000 products in CSV file File has been re-saved as UT8 file in google documents and exported to CSV from excel File loads perfectly with

@Dunderdale272

Posted in: #Magento

Have 5,000 products in CSV file
File has been re-saved as UT8 file in google documents and exported to CSV from excel
File loads perfectly with all fields in demo of magento store manager (except we dont want to buy it:)
When trying to upload in regular Magento..keep getting error messages on column duplicates....yes we have hundreds of duplicates as the titles of products in fields correspond with different sizes, etc...no way around it
Any solutions around this or any open source software similar to store manager that can do the trick. Ready to give up and go to paid solution such as Big Commerce
Also, Uploaded a bunch of free modules/keys...of open source bulk import products from magentocommerce but I cant find them anywhere in the main admin panel to use...there is no menu item for them anywhere??

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Dunderdale272

2 Comments

Sorted by latest first Latest Oldest Best

 

@Tiffany637

Duplicate products can be caused when SKU from the file you import do not match to the SKU in your store.
If the SKU not defined or path is not valid there should be wrong characters in the import file. So check your title and all fields which contain text.

10% popularity Vote Up Vote Down


 

@Jennifer507

Bit hard to answer without seeing your csv, however the only duplicate values that Magento should care about is the SKU, so make sure these are unique.

Is your csv file formatted correctly? ie; correct headers? Did you create the csv from an export of Magento data?

Magento will also complain about any extended ascii characters in your data, such as MS Word apostrophes, quotes, elipses, etc. so make sure you replace these with ascii variants

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme