Jump to content

CSV File Format help!


Recommended Posts

Okay so I have done alot of researching and reading on how to do a bulk upload via csv file and i think I know PART of what i need to do but I want to make sure before I pains takingly do it.. Attached is the screen shot of the excel file my supplier gave me. There are alot more categories and i tried but could upload the actual excel file. Okay so so I need to create a new 1st row and rename the row to the preset import category like "quantity" instead of stock etc.  And then I should create category ID column and since these are boots all in the same category i just use same category ID that was assigned in PS? And there are categories that arent in PS well dont think they are like color, boot height and boot heel so where does that data go? This the first time Ive ever uploaded csv and if i can just learn this then i wont need help doing this for my other suppliers. I cant image having to enter this all one at a time! PLEASE someone help..heck if someone could do some remote assistance and show me i will paypal them lil $ lol!

post-728665-0-81496300-1384987163_thumb.png

Link to comment
Share on other sites

First if you have not read the docs you should:

 

http://doc.prestashop.com/display/PS14/Exploring+PrestaShop's+Tools

 

This link shows how to create products & combinations with a CSV:

 

http://www.prestashop.com/forums/topic/275497-complete-csv-example-to-import-product-combinations-in-ps-15/

 

You don't need to change the column names and you don't need to add another line 1 - That is taken care of during the import where you tell it how many lines to skip (1 in your case) and then it lets you assign each data file column to the correct data type.

 

When you have different sizes or colors of a product they are called "combinations" and each combination is created as a separate CSV line (in the combination CSV).

 

So for your products you need one file that imports the "base" products such as "cowboy boots" and sets the base price then another file which imports all the combinations for the products like color - brown, size - 10. Just look at the two files in the thread at the second link and I think you'll see what's going on.

 

If you need me to do this for you I can do it for around $100 per supplier. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...