Importing Variations Via CSV File

  • Resolved rigwald

    (@rigwald)


    4 years, 4 months ago

    I am playing around with a test store before setting up a store for our nonprofit. I’ve read pages and pages of info on importing variations, but for some reason, my variations all import as simple products and don’t link and don’t show anything other than “simply” when I go into the product.

    Everything is based on SKU numbers. Originally, I didn’t have the parent SKU in the “parent” column for the parent (example: KIT-1003 in the Parent column for item KIT-1003, as well as in the parent column for KIT-1003-1 (one of the variations). Then one document made it seem that I needed it, even though the parent column would be pointing to itself. That is why the current csv file includes that. It didn’t help.

    I’m at a loss. I have tried many combinations and still can’t figure out what the issue is.

    CSV File: Click Here

    I’m sure it is something really basic that I am missing, but I am so frustrated right now, I can’t figure it out. Any help would be appreciated.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    Can you share the links of the docs you’ve followed to date? The reason I’m asking is that official documentation for the CSV importer functionality that comes with the core WooCommerce plugin itself is located at https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    Thread Starter rigwald

    (@rigwald)

    Hi @riaanknoetze,

    I can’t, because I have read so many in the forum and on www.ads-software.com, not github, specific for importing products (specifically variable products).

    I’m sorry, but I don’t see how that matters for my question. I know the CSV file has extra columns in it, since it is based on an export from our POS system. I exported from a demo site to compare columns for products and made sure to either rename or add them to the import csv. When importing, WooCommerce allows me to map the columns to the import data and to ignore the columns not needed. Everything imports properly EXCEPT the type(simple, variable, variation) and that is what I am trying to figure out is wrong. If I export the same imported items, change the values in the type and import as an update to existing products, the type changes. It just doesn’t work on the initial import, so I am trying to figure out what is happening, so I don’t have to import the same products twice just to get the type correct.

    • This reply was modified 4 years, 4 months ago by rigwald.
    Thread Starter rigwald

    (@rigwald)

    Updated page: https://storetest.rigwald.com/?cmp_bypass=test

    Thread Starter rigwald

    (@rigwald)

    I still haven’t been able to figure out what is happening and I have consulted the input formatting page.

    It is identifying the type properly now (variable and variation). I have the parent info there and the attributes are there. The attributes are created in the store.

    It is not, however, associating the attribute/variation to the parent variable.

    Here is the latest csv file with only essential columns.

    When I export the products, it shows all the information correctly as imported, but in WooCommerce, the attributes are not associated with the parent and the variations are not associated with the parent.

    Can someone look at the csv file and give me some insight. I want to fix this now, so that when I go to import all our products, it will work. I’m currently just playing with a test site.

    Thanks,

    Brian Rigwald

    Thread Starter rigwald

    (@rigwald)

    Ok, through testing and trial & error, I discovered the issue.

    Even if you have your global attributes (names/values) set-up on your site, you still need to include the attribute values for EVERY parent item. I had figured that since the value was assigned to the variation and all the values were associated with the attribute name, that I wouldn’t have to include all the attribute values for every parent. I had just included the attribute name for the parent and the attribute name and specific value for each variation.

    I hope this helps some people

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Importing Variations Via CSV File’ is closed to new replies.