Viewing 15 replies - 1 through 15 (of 23 total)
  • Hi @joyryde

    Thanks for sharing the spreadsheet. When I imported the CSV into my test site I got the confirmation “49 products imported”, but when I view the product it shows no variation options, instead the descriptions of all the variations are showing up on one single product page.

    You’d want to rectify (if required re-build) the CSV in accordance with the guidelines outlined here in the documentation: https://woocommerce.com/document/product-csv-importer-exporter/#how-to-create-the-csv

    Let us know how it goes.

    Thread Starter joyryde

    (@joyryde)

    The spreadsheet was made using an existing product, but simply altering the data, so it’s already formatted properly. That’s why someone needs to look at it.

    Hi there,

    Altering the data using a spreadsheet editor, such as Google Sheets or Excel, might change the data formatting and cause the import to fail.

    If you haven’t done so, please try editing the original CSV file using a simple text editor, like Notepad (Windows) or TextEdit (MacOS).

    If the issue persists, please send us both the original and the altered files using a file sharing platform (www.file.io or wetransfer.com for example), so we can take a look.

    Thread Starter joyryde

    (@joyryde)

    Hello,

    Sorry to hear about this,

    As an alternative, on the parent column you can refer the SKU of the parent.

    You can try first with a feww variations then check if it is working for you, once it is donde you can edit the rest of the file.

    I hope this points you in the right direction.

    Thread Starter joyryde

    (@joyryde)

    I tried. It didn’t work.

    https://docs.google.com/spreadsheets/d/12OrTkz6DdecQ95CB3pt1e_m9u2xjIlIcMhHj1hP5n1Q/edit?usp=sharing

    Changed the parent to have a SKU of F45S and the variations to have a parent of SKUF45S and now it says:

    Import complete! 13 products imported. 1 product updated. 35 products were skipped. View import log. File uploaded: Woocommerce-Import-Sheet1-1.csv
    Product	Reason for failure
    Fiamma F45S Awning for Camper Vans, ID 19901	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19903	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19905	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19906	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19907	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19909	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19910	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19911	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19913	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19914	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19915	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19917	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19918	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19919	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19921	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19922	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19923	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19925	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19926	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19927	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19929	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19930	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19931	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19933	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19934	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19935	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19937	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19938	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19939	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19941	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19942	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19943	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19945	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19946	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans, ID 19947	No matching product exists to update.

    I then deleted everything in the ID column except the parent ID, and it did this:

    Import complete! 14 products updated. 35 products were skipped. View import log. File uploaded: Woocommerce-Import-Sheet1-1-1.csv

    Product	Reason for failure
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    • This reply was modified 4 years, 3 months ago by joyryde.
    • This reply was modified 4 years, 3 months ago by joyryde.
    • This reply was modified 4 years, 3 months ago by joyryde.
    • This reply was modified 4 years, 3 months ago by joyryde.
    • This reply was modified 4 years, 3 months ago by joyryde.

    Hello,

    As an example, your product has an SKU, the variants do not have one, but on the parent column, you can refer to the SKU, in this case, the same as the parent, that way WooCommerce will know how to relate them (Please note I am not showing other columns).

    Example CSV
    Link to image: https://snipboard.io/T6rQOb.jpg

    I hope this helps.

    Thread Starter joyryde

    (@joyryde)

    Thread Starter joyryde

    (@joyryde)

    OK, I did that.

    https://www.awesomescreenshot.com/image/22211614?key=c730d8c5c93ef89cb16b84f5320fc525

    Import complete! 14 products updated. 35 products were skipped. View import log. File uploaded: Woocommerce-Import-Sheet1-2.csv
    Product	Reason for failure
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    Fiamma F45S Awning for Camper Vans	No matching product exists to update.
    • This reply was modified 4 years, 3 months ago by joyryde.
    Mirko P.

    (@rainfallnixfig)

    Hi @joyryde,

    What I would normally do here is create the variations in the backend:

    Save the variable product and export it using the built-in product exporter. It will generate a CSV file that contains all variations. Then, you’ll want to compare to the file that you already have to see what was changed.

    Cheers.

    Thread Starter joyryde

    (@joyryde)

    We already did that long ago, if you scroll up you’d see that. Thanks!

    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    There’s definitely something wrong with that file, as the import tool won’t even accept it now.

    At this point, I would suggest that you:

    • either export your original product CSV again and make your changes gradually in a few variations before importing everything
    • or use the sample-products.csv file located in your WooCommerce plugin folder as a template, to better understand how a properly formatted CSV file looks

    These reference documents might be useful:
    https://woocommerce.com/document/importing-woocommerce-sample-data/
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

    Feel free to write back if after using the sample-products.csv you’re still having issues.

    Thread Starter joyryde

    (@joyryde)

    We already did that. Hence, why we posted this here. Someone needs to look at the CSV and figure out why Woocommerce can’t seem to handle it please. Nobody seems to actually know how to import variable products; everyone here has tried for a week to get this to work, and failed.

    Mirko P.

    (@rainfallnixfig)

    Hi @joyryde,

    Thanks for your patience while we investigate this.

    Upon further checking, I suspect it’s the same issue as described in this Github bug report:

    https://github.com/woocommerce/woocommerce/issues/29700

    Indeed, when the status code is -1 (for Draft) variations are not displayed. A workaround would be using the 0 or 1 codes for the status.

    If it does sound familiar, please go ahead and add your own comment and subscribe to the thread for updates.

    This will give the developers a good idea of the size and impact of the issue and hopefully, it will be resolved within the next releases of WooCommerce.

    I’m going to close this thread now as you can follow up in Github directly. If you have any other questions please do let us know.

    Cheers.

    Thread Starter joyryde

    (@joyryde)

    OK, so I should publish the product first and then attempt to import the variations?

    Or change the status in the CSV first (from draft to published), and then upload it?

Viewing 15 replies - 1 through 15 (of 23 total)

The topic ‘Cannot seem to import a single variable product.’ is closed to new replies.