Hi Everybody,
I am trying to update all my products from stock=0 unit to stock=10 units.
Instead of doing it one by one using zencart admin I used phpmyadmin as follow:
- I exported "products" data base to my computer via "CSV for MS Excel" exporter
- opened it with Excel and, for the test, I changed the quantity of only one product to "10"
- saved
- imported the new file via phpmyadmin
and then I got the following error message:
"#1054 - Unknown column 'A' in 'field list' "
If I use the same methode but choose the "CSV for MS Excel" exporter i get the following error:
"#1062 - Duplicate entry '1' for key 1"
Would you know some methode to change all products quantities in one time escaping error messages?
Bookmarks