Importing Variable Products

  • Resolved supergula

    (@supergula)


    7 years, 11 months ago

    I am trying to import variations of a variable products, it all goes well with the exception of the variation assignment.
    What do I mean?

    If you go to a variable product edit page, on the variation you can see the product’s id and it’s variations. Well, my variations are empty when importing a variation.
    The attribute is created while importing but is not assigned, how can I solve this?

    Thanks a lot!

Viewing 11 replies - 1 through 11 (of 11 total)
  • seank123

    (@seank123)

    7 years, 11 months ago

    There’s a folder called Sample Data in the WooCommerce download zip with a sample_products.csv – is your csv file like that?

    In particular the ‘Parent’ column should have the SKU of the variable product.

    I think you may also need to upload the variable products first – then upload the variations.

    Plugin Support Riaan K.

    (@riaanknoetze)

    7 years, 11 months ago

    Did you set the Global parameters on the attribute? Here’s a list of the schema that’s possible with the importer: https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

    Thread Starter supergula

    (@supergula)

    7 years, 11 months ago

    Thanks for the replays.

    what I did in order to check whether I am doing something wrong was to export variable product and variation products.

    I then edited these attributes:

    • Sku
    • Attribute 1 value
    • Position
    • Name according to the variation

      Then I imported it and was expecting a new variation to be added. A new variation has been added but without it’s attribute.

      Also, if I export a variable product and it’s variations, and then import it right back, the product does get the right amount of variation but none are assigned an attribute.

    seank123

    (@seank123)

    7 years, 11 months ago

    Here’s a sample of the CSV I use: test.csv

    Have you got the Parent field in there?

    Thread Starter supergula

    (@supergula)

    7 years, 11 months ago

    In my file there is a parent field. The variable product is accepting the variation but the variation does not have an attribute though everything seems fine in my CSV file

    con

    (@conschneider)

    Engineer

    7 years, 11 months ago

    Can you provide a screenshot of your attributes column and values inserted so we can take a look.

    Thread Starter supergula

    (@supergula)

    7 years, 11 months ago

    Hey, sorry for the delay..

    Here is a link to the CSV I am using to import:
    https://uploadfiles.io/tgdtc

    Hope it’s helpful

    seank123

    (@seank123)

    7 years, 11 months ago

    Had a quick look – just one thing stands out:

    The ‘Attribute 1 name’ entries – shouldn’t they all have the same name? Eg: size?

    Thread Starter supergula

    (@supergula)

    7 years, 11 months ago

    Yea, seems to work. It is odd though, I just exported the products from the website and it was like that.

    If anything will go wrong again I will write again.

    Thanks for the help!

    seank123

    (@seank123)

    7 years, 11 months ago

    Had similar issues when I was trying to do it with the built in importer – I had been using a 3rd party import plugin that worked really well but has since been abandoned by the developer – took a while to get it working right but once you crack it, then it works very well!

    Plugin Contributor Julia Amosova

    (@jamosova)

    7 years, 11 months ago

    Hi @supergula and @seank123, seems as the issue is resolved for the two of you so we are going to mark this thread as Resolved. Feel free to open a new post for any new issues. Cheers!

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

The topic ‘Importing Variable Products’ is closed to new replies.