WordPress.org

Ready to get started?Download WordPress

Forums

Woocommerce CSV importer
[resolved] [closed] About how to use Variable products add-on (14 posts)

  1. RobinL
    Member
    Posted 1 year ago #

    Dear Allaerd,

    First of all, thanks so much for your plugin! It's gonna be a enormous time saver for loads of people ;)

    Well, I'm new with your plugin since I installed it last week. Since the main part of my products are variable, I've also bought this add-on on your shop. And something is missing: documentation!

    I tried to implement the "variable" file to your plugin, but it doesn't seem to work. I've created a .CSV following your instructions, but nothing has imported! Then today I've updated to 1.0.8, tried to import a .CSV with 2 simple products (.CSV formatted just like in your video), and it is working. So I guess I've probably missed something with the add-on...

    Then, I would need some help with variations. Could you just send me a sample .CSV file to help (or give some Dropbox link or so)? To be sure mine is correctly formatted... And also if you can, some information about how to install the variation file onto your plugin.

    I think these informations could help more people than only one ;) Thanks in advance, and thanks again for your great work!

    Robin.

    http://wordpress.org/extend/plugins/woocommerce-csvimport/

  2. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hi there,

    I'll fix my site.....there was an example of there.....here it is:

    To import variable products you have to set up the attributes you want to use in advance.

    Now think of the following example, you have pants and shirts in different sizes and colors. You have to setup 2 attributes, color (blue,red,green) and size(l,m,xxl). The following CSV file would reassemble that how an import could look like:

    sku;product_type;post_title;price;stock;post_parent;variation;var_color;var_size
    1;variation_master;pants;10;5;;size|color;;
    2;product_variation;pants;10;6;1;;blue;l
    3;product_variation;pants;10;7;1;;red;m
    4;product_variation;pants;10;8;1;;green;xxl
    5;variation_master;t-shirt;10;1;;size|color;;
    6;product_variation;t-shirt;10;2;5;;blue;l
    7;product_variation;t-shirt;10;3;5;;red;m
    8;product_variation;t-shirt;10;4;5;;green;xxl

    First set up the attributes you want to use, put them in your CSV file and you can upload them all!

  3. ebasanez
    Member
    Posted 1 year ago #

    Hello

    I have succesfully loaded products and images via csv (tons of hours saved).

    Now, I have been trying to upload variations, but it has been impossible to me.

    Is it necessary to upgradde to 1.0 version to use the add-ons?

    I think I have not added the add-on correctly...

    Enrique.

  4. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hi there,

    Yes, you need at least 1+ but i recommend 1.1.- or higher

  5. RobinL
    Member
    Posted 1 year ago #

    Hello Allaerd,

    I've well uploaded to 1.1.0. Then I added the "variation" php file (downloaded from your website) to the "include" folder into the plugin folder. And I added a code line to "woocommerce-csvimport.php" to "include the [new] function", in line 19:

    include dirname( __FILE__ ) . '/include/woocommerce-csvimport-variations.php';

    Is it all good so far?

    Then I created a new CSV file following your example. You can find it here:
    https://dl.dropboxusercontent.com/u/36410835/ProductsImport1.csv

    As you can see, I've replaced your "size & color" attributes by mines, in French: "taille" & "couleur". Hope I've done it right.

    Still ok so far?

    I guess no, 'cause when I try to import this file, it works well 'til the last step, then when I hit "Run", nothing happens, and I only get a screen like that:
    https://dl.dropboxusercontent.com/u/36410835/Screenshot-1206.png

    Could you help me now, and tell me where the mistake is?

    Thanks so much in advance Allaerd!

    Robin.

  6. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hi there,

    You don;t have to include the plugin, better to delete the line you added, delete the add-on and goto the plugins->add new->upload zip section of wordpress and load the zip file.

    Second step is to make the attributes you want to use. In your case "taille" & "couleur". You can do this in products->attributes. And add the values they could have.

    Than goto to my plugin csvimport-settings. Check them and to be sure!
    Than goto to my plugin csvimport->header. Upload you file and map the right fields to the right columns.

    Now you are ready to import. Most important step is to create the attributes you want to use in advance and set up the right header!

  7. RobinL
    Member
    Posted 1 year ago #

    Thanks Allaerd,

    But I had already done what you recommend hereabove. Indeed, my attributes were already created before installing the plugin.

    But well, I tried what you said: delete the "modified" version of my plugin, install again 1.1.0 without add-on, and try again. Then the import works, but: without the add-on, there is no possibility to select the right things for the header (where post_parent, variation, var_couleur & var_taille are replaced by "skip"), so the import is done as for simple products.

    Instead of creating just one product with different variations, the import creates several single products. Which is not what I want.

    That's why I was asking you how to use the add-on, and you actually didn't reply to this question! What am I supposed to do with the .php file I downloaded on your website?

    I can make your plugin work for single product, it is quite easy; I'm now in trouble, just like other users I guess, to make your plugin work for variable product.

    Thank you for helping me.

  8. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    could you please drop me a mail, with credentials to your site and the CSV you use.

    I'll check it out and see what is wrong! and come back to you on how to set it right!

    Sounds like a plan?

  9. RobinL
    Member
    Posted 1 year ago #

    Problem resolved!

    I'll give some explanations after this short exchange of emails with Allaerd; they could be useful in case of another user would face the same issue.

    I actually didn't install the add-on in the right way. I tried to add its file to the "basic" plugin folder using my FTP client. Wrong!

    To install the add-on, you simply have to upload a zip file (containing only the .php file of the add-on) with the WP plugin installer, just like when you want to install any other plugin. Activate it, and follow the Allaerd's instructions to build the right CSV file.

    Good luck! And thanks Allaerd for your help!!

  10. asikhatali
    Member
    Posted 1 year ago #

    I have the same problem, I cant get it to work. I have installed the plugin like Robinl says one should.

    I am not sure where to start checking. I have gone thru this thread again and I am pretty sure I have covered these bases.

    Could you help me please?

  11. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Drop me a mail and i'll help you out!

  12. valoros
    Member
    Posted 11 months ago #

    Allaerd, why dont you post your the solutions to the issues people are having. That way if we have the same issue we can find the solution in the forum. The problem is many people are having that same issue, but can't find the solution because you fix it in private!

  13. Photoboy19
    Member
    Posted 10 months ago #

    Same question (or maybe better: COMPLAINT) as Valoros:

    I purchased the "Variations" import add-on. And it doesn't work. I've tried everything, even with the included sample CSV...

    I have set up the product attributes before – it doesn't work.

    Alleard:
    Why don't you post the solution you gave to RobinL here in the forum??
    Unless you do that, I can not recommend this product! And I would really like to recommend it, but.... documentation & support here in the forum is very bad!!

  14. esmi
    Forum Moderator
    Posted 10 months ago #

    These forums do not support commercial products. Only the free plugins downloaded from http://wordpress.org/plugins/. Please contact the plugin's vendor directly with any questions about commercial products.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic