.csv import – Variations not showing

  • Resolved mickael1331

    (@mickael1331)


    2 years, 6 months ago

    Hello,

    I have an issue when importing a product in a .csv file.

    So i created all variations (around 800) of my product in woocommerce, then exported it in .csv to modify the prices. All attributes were linked correctly (all of them global).

    After modifying the prices and importing the file (i ONLY modified the prices), there was the issue with the product :

    The variations get imported, but don’t show on the product page, whether i create a new product or update an existing one. I’ve deleted the product, cleaned up my recycle bin and imported again as a new product but same thing, the product is there, the attributes are there (and the “use as variations” box is checked), but the variations themselves are not there.

    When exporting the product to check, i saw that all the variations, with the prices, were in the .csv.

    Thank you for your help.

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

  • Hi @mickael1331

    The variations get imported, but don’t show on the product page, whether i create a new product or update an existing one.

    When exporting the product to check, i saw that all the variations, with the prices, were in the .csv.

    It seems that some field/setting may have got missed.

    We recommend that you first check with a small set of say 2-3 products. Once that works perfectly you can be sure that you are using the correct format for the CSV. You can download a sample CSV file here: https://github.com/woocommerce/woocommerce/tree/master/sample-data

    If you are using the built-in product CSV Importer Exporter, here’s its documentation that you may refer to: https://docs.woocommerce.com/document/product-csv-importer-exporter/

    Should you need us to check further, please share with us the following:

    1. your CSV file (you can use Google Drive/Drobox or any online file-sharing service, and share the link here)

    2. your site’s System Status – You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    We haven’t heard back from you in a while, so I’m marking this thread as resolved – we’ll be here if and/or when you are ready to continue.

    Thread Starter mickael1331

    (@mickael1331)

    Hi, the issue is solved, thank you for your help.

    It seems that exporting variables created directly via the woocommerce interface puts the “attribute visible” value to 0 instead of 1 by default, even when both the “Visible on product page” and “Use for variations” buttons are checked; so using the model you provided is the way to go.

    The issue did not get resolved for me. I followed directions from the link, reuploaded variations in a separate csv, but nothing. The checkmark is on, but the variations were not created.

    Hi @noche70

    Since you’re not the person who originally started this topic then, per the forum guidelines, would you please start your own topic? We’ll be more than happy to help there ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘.csv import – Variations not showing’ is closed to new replies.