.CSV import category's

[aardwrok]

Hello all.

New to prestashop and I like it very much. I have about 3000 products to import to my site so I am using a .csv. All is working fine so far (haven't tried all the fields) but the products wont drop into their appropriate category's. In my .csv file I have tried to use the category ID, no luck. Tried to use the category name in caps, no luck. In lowercase, no luck. as exact match to my category's, No luck. Instead each time they all just drop in the HOME category. I dont really want to go into 3000 individual products and drop them into the correct category. 

Any help with this would be great. Any need for Screen shots or my File to check Let me know and I can attach

[aardwrok]

Ok the principle i understand, in example 1 product 100 & product 101 both drop into category 3 by means of using category ID & category name. so either will work.

 

Now I have tried using only category name, then I tried using only category ID. Finally I have tried using a mixture on the top few items of my .csv and still no joy.

 

Maybe it is in the settings I select prior to allocating columns;

 

 

Delete all products before import?           checked box yes

Use product key as reference?                 left unchecked... not sure what this does

Force all ID during import                         checked yes. 

 

These are my errors

 

30 errors 

1. Name (ID: ID) cannot be saved
2. Property Product->available_for_order is not valid
3. BATTERY KIT - OC1 (receiver)� (ID: 209) cannot be saved
4. Property Product->name is not valid
5. (ID: ) cannot be saved
6. Property Product->name is empty
7. (ID: ) cannot be saved
8. Property Product->name is empty
9. (ID: ) cannot be saved
10. Property Product->name is empty
11. (ID: ) cannot be saved
12. Property Product->name is empty
13. (ID: ) cannot be saved
14. Property Product->name is empty
15. (ID: ) cannot be saved
16. Property Product->name is empty
17. (ID: ) cannot be saved
18. Property Product->name is empty
19. (ID: ) cannot be saved
20. Property Product->name is empty
21. (ID: ) cannot be saved
22. Property Product->name is empty
23. (ID: ) cannot be saved
24. Property Product->name is empty
25. (ID: ) cannot be saved
26. Property Product->name is empty
27. (ID: ) cannot be saved
28. Property Product->name is empty
29. (ID: null) cannot be saved
30. Property Product->name is empty

Think that all these last ones are just empty slots. that should matter should it>?