product_variation with var_attribute AND pa_attribute

  • Resolved whoaloic

    (@whoaloic)


    10 years, 5 months ago

    I meet an issue for months and I don”t manage to succeed.
    I thank Allaerd for his help, and I think this post may be useful for everybody.

    I need to use product_variation with var_attribute AND pa_attribute.
    The “variation” AND “attributes” columns does not seem to work together because “attributes” column overwrites “variation” column so I had to check manually attribute checkbox “use for variation” to make work the variation dropdown list.

    I have to use multiple values as attribute but not as variable attribute.
    For example: I have variable products with different sizes but with same colors (The product might have multiple colors (so I use the pipe: |).

    ID;product_type;product_parent;variation;default_attributes;var_size;var_color;attributes;pa_size;pa_color
    var1;variation_master; ;size->1->1;size->XL; ; ; ;color->1; ;
    var2;product_variation;var1; ; ;XL; ; ; ;blue|red;
    var2;product_variation;var1; ; ;XL; ; ; ;orange|green;

    Any clue?
    whoaloic

    P.S: there might be a solution is to import the CSV file twice.
    Upload the CSV file with “variation” AND “attributes” and “var_attribute” AND “pa_attribute”
    Delete the “attributes” column in the CSV file
    Save a new header (without “attributes” column)
    Reupload the new CSV file

    But I guess, there is something better to achieve this.

    https://www.ads-software.com/plugins/woocommerce-csvimport/

Viewing 12 replies - 1 through 12 (of 12 total)

  • HI!
    Happens to me as well and I have no solution, as I both serve Whoaloic support has been kind enough to tell us a solution that works.
    Thanks Whoaloic

    Hi!
    Happens to me as well and I have no solution, as I both serve Whoaloic support has been kind enough to tell us a solution that works.
    Thanks Whoaloic

    Thread Starter whoaloic

    (@whoaloic)

    Hello,
    If you bought the add ons, ask Allaerd for last upgrades.
    He sent me last files and it works well.

    Plugin Author allaerd

    (@allaerd)

    to have it clear:

    * all recent add-ons work work with pa_xxxxxxx
    * attributes come in two type, regular attributes and variable attributes
    * regular attributes are attached to products in the attributes column separated by |
    * variable attributes are attached to products in the variation column of the variation master and every variation has his own row.

    Allaerd I must confirm Attributes and Variations don’t work together, I have exactly the same issue as described above.

    Screenshot of my csv structure is here: https://dl.dropboxusercontent.com/u/52841224/structure.png
    And here is my csv file:
    https://dl.dropboxusercontent.com/u/52841224/test.csv

    If there are “attributes” and “pa_gluten” columns present in CSV, variations don’t import and only imported attribute is “Gluten”. If I remove these two columns, or unbind them in header, attribute “Amount” is loaded correctly and used for variations.

    Is there anything I am missing or is it a bug? I would need having this fixed as soon as possible, please let me know.

    Just solved a similar issue with our setup, in this case the attributes plugin isn’t really needed if my hunch is right.
    We use pa_size and pa_colour, with each variation listing their own values (make sure your masters are empty from pa_x columns).
    With attributes plugin enabled, we found it’d read the colour/sizes and add them as values under attributes.
    With it disabled, it Variations went in and it added the spare colours/sizes we didn’t add to the CSV the first time round.
    For your one Jan, try ignoring the attribute column, or just disable the import attributes plugin,re set-up header and putting amount|gluten->1->0 in your variables column.

    DeaJae:
    Thanks for your tip, I have removed the attributes column and added |gluten->1->0 to variations column. Now the attribute is created together with amount, which is good, but the attribute is empty, it is not filled by the value from “pa_gluten” column. So I still cannot use it. See my actualised structure here:

    https://dl.dropboxusercontent.com/u/52841224/structure2.png

    I’ve been pondering it overnight, only difference I can see between my csv and yours, is the master row for PA values.. mine are empty and seem to drag the values below in.
    I suspect pa_x only works on product_variations unless its a specified attribute import (ie dummy product sku/name with the attributes to import).
    as with everyone else, learning the quirks and tricks of this and noting them down to see if they’ll help to improve documentation.
    Here’s an example

    DeaJae: once again thanks for your help but unfortunatelly it doesn’t work. I tried importing your example, and there are no attributes imported on the attributes tab, and on variation tabs there is some unattached “Any Pa_UC101” value. See the screens after importing your example CSV.

    https://dl.dropboxusercontent.com/u/52841224/example-import1.png
    https://dl.dropboxusercontent.com/u/52841224/example-import2.png

    I don’t have more time to spend on this, as my client will not pay for time spend on bugfixing something that should work, we chose the plugin because we needed quick working solution and not to spend hours trying to figure out why attibutes and variations don’t work together.

    Anyway, if someone has similar problems, I recommend dividing the import to two files, where the first file imports variations only, and then second file assigns attributes based on sku. It is important for this to work to have set Merge products: YES in import settings:

    https://dl.dropboxusercontent.com/u/52841224/import-file-1.png
    https://dl.dropboxusercontent.com/u/52841224/import-file-2.png

    I hope the author will address this, or at least write an article about how to set import of attributes and variations correctly together, as this was quite frustrating. Cheers

    The author will not. He has gone dark!

    Plugin Author allaerd

    (@allaerd)

    like i said, please mail me with questions about the add-ons. WordPress forums is only for the free importer

    Plugin Author allaerd

    (@allaerd)

    to be clear….like it is in the documentation….

    attributes are either in the variation column or in the attribute column, never in both!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘product_variation with var_attribute AND pa_attribute’ is closed to new replies.