Import CSV

General General Questions
1

I am having a strange problem. I have been trying since last several days to resolve this but not luck. I have a sandbox where I was able to upload 200 prouducts as test without any problem.



I then tried to upload 620 products into my live version but it only imports 29 products. I even tried 50 products, 100 products but its always same. I then deleted all products but still when I go to Manager Categories, I can still see some products are showing under my different categories but when I go to those subcategories to display what those products are I do not see any thing. I even tried to find them in storefront but they don’t exist but when I click on the main category, on strore front, it shows subcategory counts but no real product exists.



I will be very happy if someone can give some light here.



Thank you.

2

Can you import the 620 items into your sandbox company?



Have you tried deleting the products via phpmyadmin? That is, go straight to the db to delete the products and see if that does anything.



I’m no expert, but it sounds like something has been corrupted somehow.

j

3

[quote]I even tried to find them in storefront but they don’t exist but when I click on the main category, on strore front, it shows subcategory counts but no real product exists.[/quote]



I agree there is sonething not right with the product count in the manage categories area when you have been importing/exporting and basically mucking around with product categorisation. I’ve noted the discrepancies but haven’t pursued it as it hasn’t been crucial…



I’ve imported almost 2000 products pretty regularly over the last few weeks without the other problems you mentioned though. Have you always used the product_id field in your file? It’s the key unique field when importing updates to product data into cscart. Product_code you can do without or leave blank if you want.



Can you give more specifics about your file? Look at 2 or 3 items and track what happened?

4

Thanks guys. I have figured it out. There was a tiny error in my csv file. I had a little space in one of my column which was causing me to load only first 29 items and discarding the rest. Its silly mistake. Thanks a lot again.