Variations not imported

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

  • Hello,

    If they are new products you can move them to trash before importing them again, be sure to match the variation to the parent product with the SKU instead of the ID.


    Link to image: https://snipboard.io/0MaE5c.jpg

    As an example, you can refer to this sample CSV file: https://github.com/woocommerce/woocommerce/blob/master/sample-data/sample_products.csv

    I hope this helps!

    Thread Starter quedao

    (@quedao)

    Dear Igor,

    Thank you very much for you reply. it is truly appreciated!

    If I understand correctly the problem is that in my file the parent field is populated with the ids of the parent product, and these are lost in the import process because the newly created product come with a new id.

    You stated that the solution is to use the sku to match parents and variations, and looking at your screenshot I can see you that were able to do so with my data.

    Did you manually edited the file? or you were able to use the file as it is changing the set up in the column mapping screen?

    Thank you very much

    Thread Starter quedao

    (@quedao)

    After some trial I have figured that with the original file is not possible to match parents and variations just by changing the field mapping.

    I went ahead and edited the file, I copied the original id to the sku field. then I changed the parent field of each variation from “id:30314” to “sku:30314”. It didnt work.

    Then I changed the parent field of the variations to just “30314”, that would match teh new sku. It also didnt work.

    This is how the file looks now:
    https://docs.google.com/spreadsheets/d/1uNjlXbjuSGyq4t7ExJkg1lU4EAOAmQIOKf_FQCBY4Bo/edit#gid=642459215

    Any help apreciated

    Hello there,

    I could not open your last file, is not public ??

    Did you manually edited the file? or you were able to use the file as it is changing the set up in the column mapping screen?

    Yes, correct. You can add a SKU:
    Add SKUs
    Link to image: https://snipboard.io/NMFxTt.jpg

    And you can refer the SKU for the variants:

    Link to image: https://snipboard.io/sxr28W.jpg

    I hope this leads you in the right direction.

    Thread Starter quedao

    (@quedao)

    Igor,

    Thank you again for your help!

    Your reply is exactly what I was thinking would be the solution, I did similar changes to my file, but still is not importing.

    I here is the file (public this time!)

    https://docs.google.com/spreadsheets/d/1uNjlXbjuSGyq4t7ExJkg1lU4EAOAmQIOKf_FQCBY4Bo/edit?usp=sharing

    Thanks again!

    Hello,

    Sorry to hear that, my recommendation is to try first with a smaller file, with 2 or 3 products, be sure to use Google Suite instead of MS Ex*el to create your CSV file. Be sure to check if there is a special character or space added that is affecting your file.


    Link to image: https://snipboard.io/mM5c4j.jpg

    I hope this helps.

    Thread Starter quedao

    (@quedao)

    Igor,

    I fixed the problem.

    Turns out, having the name of attibute in Japanese (double bit char) caused it.
    Just change the name of the attribute in double bit language for the equivalent in English and all products and variations import flawlessly.

    I didnt neeed to edit the file, nor needed to change the parents to the SKu instead of the ID.

    After import the new parent products have different ids that the originals, but the variations were updated accordingly by woocommerce without any action on my side!

    Igor, do you not know that woocommerce does update the ids and the parents when importing ?

    Hi @quedao!

    I’m glad to hear that you figured it out, and thanks for sharing what you did with the community! It’s awesome!

    Also, you can tick the box to update existing products handled by SKU’s and/or IDs while uploading a CSV file!

    You can read more details here:

    https://woocommerce.com/document/product-csv-importer-exporter/#update-existing-products

    I am marking this as resolved, but please, don’t hesitate to contact us if you have other questions!

    My very best,

    Thread Starter quedao

    (@quedao)

    Andre,

    Thanks for reply.

    After importing the products with the default field mapping, they import flawlessly, so that solves the problem. Just they import with the SKU empty (same as original file).

    If I try to map the original id to the imported SKU then the variations fail to import again.

    What would be a good way to import the variations and keeping the original IDs as SKUs?

    Thank you in advance

    • This reply was modified 2 years, 9 months ago by quedao.
    • This reply was modified 2 years, 9 months ago by quedao.

    Hi @quedao

    If I understood you correctly when you’re updating a product, it’s important to provide the correct product ID, and if it’s not automatically matched, you can match it to the ID field.

    If the product has a Stock Keeping Unit (SKU) value, you’ll also need to provide this information in your CSV file.

    And then, since we’re updating existing products, make sure you select the Update Existing Products checkbox.

    https://snipboard.io/3x4fK2.jpg

    If you have lots of products, you can create a simple CSV import file, with a single product for testing purposes.

    Let us know if you have questions! All the best!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Variations not imported’ is closed to new replies.