Importing Products and Combinations with csv's



  • PS 1.6.1.11

    How can I create products with combinations and upload them via CSV? I have images uploaded and online for these products.

    Thanks!



  • We used the built in features in PS plus bought a cheap but VERY good module called mass combination updater. We created combination of furniture, in all over 3000 combinations. I tested SC but I cant see any time difference really. The combination generator in PS do a very good job



  • @Havouza Can you please tell me the exact name of that module or its link? I keep searching for mass combination updater and get many results. Do you mean this one?

    Prestashop Mass product combinations editor:

    https://mypresta.eu/modules/administration-tools/mass-product-combinations-editor.html

    Thank you very much for your reply!





  • Thank you, @Havouza It has a back office demo which I will try. It’s currently under maintenance. :) Story of my life. lol


  • administrators

    There’s a massive security problem in the back office at the moment. Most back office demos have therefore been disabled. It might take a while before most are back. PrestaShop has yet to provide a security patch.


  • administrators

    The problem only occurs when you expose your back office for demo accounts. It seems like you can install modules, even with a test account.



  • Do you suggest that we not buy any add-ons for now, either?


  • administrators

    I have no idea what is going on. PrestaShop does not communicate.



  • @alwayspaws said in Learning curve for Product Combinations with Store Commander?:

    How much of a learning curve is there for creating products with combinations with Store Commander?

    If you are doing a mass .csv import of say 30 products at a time with combinations, images, features, etc. it can be fairly daunting.

    If you want to create products one at a time and then add the images, features, etc. using the SC interface it’s very very easy.



  • Michael, I’m sorry about that.

    @crosscut01 Thanks for clarifying this. I hoped to do a mass .csv import of a huge amount of products but I find it’s too complicated because I don’t want to manually create product references codes with all the colors and sizes, which is what the PS combinations spreadsheet example looks like to me, so I’m going to add products with combinations and images one at a time.

    Since SC and PS admin both seem to have similar techniques, I’ll just use PS combinations generator. It’s easy enough and I already have all the data in spreadsheet form and all my images are already on the server. I’ll just have to copy and paste. I’m not at all happy about this situation, but it is what it is.

    One last comment is that I did not create my website from the open source PrestaShop. I bought the template and additional services from TemplateMonster



  • If you upload your products with a csv file, why don’t you just use the same file to upload the combinations? I have about 10,000 products and almost every one has size/colour combinations. Here’s what I do:

    I create a spreadsheet with every field I need, which in my case is this:

    ID Reference # Combination Reference Name Combination Name Combination Value Supplier Code Combination Supplier Code EAN Combinations EAN Quantity Combination Quantity Categories RRP inc Tax Tax ID Cost Price Our price Discount Amount Supplier Manufacturer In Stock Text Out Stock Text Image URLs Feature Name:Value ASM Warehouse ShopID Description Weight

    I fill that in for every new product, then use the CSV import tool under Advanced Parameters to import the new products (save the fields relevant to the new product, excluding the combinations).

    Then import the combinations using the same file, again saving the relevant fields but this time only the ones related to the combinations.

    Using this method I can import hundreds of new products a day with thousands of combinations.



  • @spidawebs said in Learning curve for Product Combinations with Store Commander?:

    If you upload your products with a csv file, why don’t you just use the same file to upload the combinations? I have about 10,000 products and almost every one has size/colour combinations. Here’s what I do:

    I create a spreadsheet with every field I need, which in my case is this:

    ID Reference # Combination Reference Name Combination Name Combination Value Supplier Code Combination Supplier Code EAN Combinations EAN Quantity Combination Quantity Categories RRP inc Tax Tax ID Cost Price Our price Discount Amount Supplier Manufacturer In Stock Text Out Stock Text Image URLs Feature Name:Value ASM Warehouse ShopID Description Weight

    I fill that in for every new product, then use the CSV import tool under Advanced Parameters to import the new products (save the fields relevant to the new product, excluding the combinations).

    Then import the combinations using the same file, again saving the relevant fields but this time only the ones related to the combinations.

    Using this method I can import hundreds of new products a day with thousands of combinations.
    Spidawebs have you tested the csv import in TB? its very buggy. Not from 1.6 it seems. From 1.7
    I would be cautious



  • 0_1488524146618_New Product Import.csv

    Attached is an example of the csv file I use incase it is of use. Just open in Excel and edit. The columns in white are the fields I import using the products csv import, the ones in yellow I import using the combinations csv import. When importing the combination just made sure you use the ID field so the products are matched.



  • @Havouza No, I haven’t tested this in TB yet. Thanks for the tip - I thought TB was supposed to be less buggy than PS! The CSV import is one of the few things that actually works fine in PS!!!



  • @spidawebs I have only tested category import and it flips out totally so I have given up


  • administrators

    Uh oh. It was not a good idea to pick the 1.7 importer?

    We’ll focus some more on the importer then before 1.0.1 is released.



  • @spidawebs I will download your spreadsheet and try it out when I get back to the office. Thank you very much. It’s good to know it works in PS 1.6. Products are my only concern right now.

    @Havouza have you tried to import a product with @spidawebs spreadsheet?
    This may help @mdekker figure out which importer is better.



  • @alwayspaws No I turned to xml instead and that works for now



  • @spidawebs said in Learning curve for Product Combinations with Store Commander?:

    0_1488524146618_New Product Import.csv

    Attached is an example of the csv file I use incase it is of use. Just open in Excel and edit. The columns in white are the fields I import using the products csv import, the ones in yellow I import using the combinations csv import. When importing the combination just made sure you use the ID field so the products are matched.

    @spidawebs - Your file is precisely what I’ve been hoping for! Although the file shows as .csv in your post, it downloads like this: 1488524135738-new-product-import.bin

    I downloaded it twice and once renamed it with an .xls file extension and once with .csv extension, but there’s no highlighting and some data is moved to the wrong columns. I really want to use this file. What other format will open it, please? I’m on a Mac and use openoffice calc but I also have MS Office for Mac.

    Thank you very much!



Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.