dbeezer99 Posted November 20, 2013 Share Posted November 20, 2013 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! Link to comment Share on other sites More sharing options...
dbeezer99 Posted November 21, 2013 Author Share Posted November 21, 2013 Well I did guessing and uploaded and it said file uploaded successfully but nothing took in database. weird BUT PLEASE PLEASE can someone help me im desperate Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted November 21, 2013 Share Posted November 21, 2013 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now