Creating a Products CSV File Help

[Aaron Healey]

Hi i have managed to create a Category CSV just for the categories but now how do i create a new CSV file for the products just for example the category "Arts & Crafts"

The things i need in the csv is

ID, Active, Reference, Product Name, Category Name, Wholesale Price, Quantity

Regards,
Aaron

[rocky]

You are using the same product ID for every product, which will not work. You need to number the product IDs sequentially (1, 2, 3, etc). Also, although you can specify the category as a name, which should work if you only have one category called "Adult", it is better to use the category ID instead, so you can be sure that you are linking the product to the right category.

[Aaron Healey]

Ok So what i have done is correct just need change IDS etc

[rocky]

Yes, as long as you only have one "Adult" category. If you have multiple "Adult" categories, you'll need to use category ID instead of category name.

[Aaron Healey]

Ok i have done that, what does the Reference # have to have in it can i put like the reference of say 2465903 etc ?

Aaron

[rocky]

Yes, the reference can be anything you want as long as it doesn't contain any of the following characters: <>;={}

[Aaron Healey]

Ok thanks i have done it added my first 4 haha, but not got to do like another 300 CSV lmao which shouldnt be hold once i get the headers correct then it be all done lol

Cheers for all your help and quick replys

Aaron