Issues importing variables and their variations

  • Resolved Miesjelangelo

    (@miesjel12)


    4 months, 2 weeks ago

    Hi all,

    I’m creating a new topic on this but i’ve seen loads of other people having issues with importing variables and the variations for those variables.

    Importing goes wel, all variable products are created and the Attribute is created. When importing the attached CSV file it returns 2 products imported and 10 variations created. But the check for “used for variations” is not checked. And all variations are not created either.

    I tried adding screenshots but they would not upload.

    I’ve been trying a lot with the layout of my CSV file, here is a short list:

    • Add 1 to the global attribute colom
    • made sure to add stock
    • made sure to add pricing
    • made sure to include SKU
    • cleared the complete woocommerce database after each attempt
    • Disabled all plugins except Woocommerce
    • Created a template product, exported it and used that to import the others
    • The currently attached CSV does not contain all possible columns but I did try with an export of existing product and keeping all columns, but it did not help.
    • Tried following this Product CSV Importer and Exporter Documentation – WooCommerce
    • Not using the importer suite, just the default built in importer, which should do the trick since i’ve seen some people having results.

    But nothing helped, all result in the same issue. Any suggestions on what to try? I’ve read a lot of topics, but none of them provided a solutions.

    Here is the CSV i’m using (keep in mind that due to other computer language settings, i do not use , but ; as a seperator): personal/WC-Example.csv at main · Miesjelangelo/personal (github.com)

    • This topic was modified 4 months, 2 weeks ago by Miesjelangelo.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @miesjel12

    I appreciate your effort in trying different solutions and sharing detailed information.

    The issue you’re experiencing might be due to a few factors, especially your CSV file format doesn’t look correct:

    Here are some potential solutions:

    1. Ensure your CSV file is correctly formatted. The delimiter should be a comma (,) and not a semicolon (;). If your computer language settings are causing the delimiter to change, try changing your settings or using a different program to create the CSV file, such as Google Sheets. More info: https://woocommerce.com/document/product-csv-importer-exporter/#what-csv-editors-do-you-recommend
    2. Make sure you’ve added the correct columns for attributes. There should be two columns for each attribute: one for the name (e.g., “pa_color”) and one for the values (e.g., “red, green, blue”). The “used for variations” option is determined by whether an attribute has been added to the “Attributes” column.
    3. Each variation should have its own row in the CSV file, with the “Type” column set to “variation” and the “Parent” column set to the SKU of the parent variable product.
    4. Make sure you’ve followed all the steps correctly. Pay special attention to the sections about importing variable products and variations. More info:

    Additionally, for screenshots, I recommend https://snipboard.io/ for easily sharing screenshots – please follow the instructions on the page, then paste the URL(s) in your reply.

    I hope this helps! Please let us know how it goes or if you need further assistance.

    Thread Starter Miesjelangelo

    (@miesjel12)

    Hi @shameemreza , thanks for responding!

    All things you said have been done, even using comma’s in stead of semicolons. It did not change the issue.

    I was able to work around it by first importing the variables, performing an export to get the correct ID’s of each product and then making all variabels with their parent ID’s. This worked, and everything has been imported now.

    But there are a few things Woocommerce should look into:

    • Somehow, importing all at once in one sheet does not work. Variables are created, some return errors even though there is nothing wrong with their configuraiton because if I import those seperatly, it works.
    • As you might understand, it took a lot of extra work to match the variables to the correct parent ID, there should be an easier way if you support an import function
    • Importing in batches did not work. I had three categories of products and did not want to do them all at once in case something went wrong. The first upload of Variables and variations worked flawlessy. The second batch, with the exact same values just different names, went okay. 85% imported correctly, the others returned errors about pictures not being present (the URL of pictures is the same for all categories, nothing has changed) and some other issues. The third batch failed completly. I combined all files into one bulk variables file and one bulk variations file and had no issues importing them. Sounds like a bug in my opinion.

    Thanks for trying to help, i’m just happy to have the product imported in woocommerce.

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @miesjel12,

    I’m glad to hear that you were able to import your products, though with some workarounds.

    I understand your frustrations and appreciate your detailed feedback. However, I would humbly request that you open a Bug Report here and shared a detailed description so that our developers can look into the issue further.

    Please be sure to include a correct CSV format for our developers to replicate the issue.

    Thank you for your patience and understanding.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @miesjel12

    I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.