Partial import of variable products in woocommerce from a csv file

  • Resolved BigBlack

    (@bigblack)


    2 years, 6 months ago

    I’m having a problem importing a csv file into woocommerce. The file contains about 400 variable products with 4000 variations inside.
    The first part of products is imported regularly. The second part, approximately in the middle of the sheet, is imported without the tick on “use for variations”. The file is generated by a VBA script, so all lines are generated identically, from top to bottom.
    Checking the wp_wc_order_product_lookup table, in the is_variation column, for correctly imported products there is a 1, for those imported badly there is 0.
    Is there any solution to this problem? I have seen that several people have a similar problem, but it involves all lines. Instead in my case the bad import affects only half of them. Cells from lines 1482 to 2760 are skipped. Each time the import is done, they are always the same. But there is nothing different from the others. I also tried to change the Is_variation column from 0 to 1 from SQL for badly imported products, but after a while the values ??return to 0. What to do?

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

  • Hi @bigblack

    Thanks for reaching out!

    I understand that there are some variable products on the CSV file that are not being imported.

    Can you please share how are you importing these variable products? Is it thru the built-in Product CSV Importer and Exporter? If so, can you please provide us a copy of the CSV file which includes the skipped lines during import so that we could test it on our end as well?

    Otherwise, kindly share if you are using any third-party plugin in doing the import.

    Thanks!

    Thread Starter BigBlack

    (@bigblack)

    Yes, I’m using built in import.
    This is the csv link https://fromsmash.com/CSV-File
    Line not imported are from 1482 to 2760.
    Variable products are imported but without variation. If I check thoso products, the don’t have the “use for variation” checked.
    Thank you!

    Hello,

    Thanks for sending the sample file.

    Can you please make sure all the columns have their headers? For example the columns I, and J are empty without headers. There are other columns having the same issue, this might confuse the importer.

    Example:

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

    Then you can split the file into smaller pieces and try again to check if it works this way.

    More info to import the file on our documentation:
    https://woocommerce.com/document/product-csv-importer-exporter/

    Let us know how it goes.

    Thread Starter BigBlack

    (@bigblack)

    Ok I’ll try to delete empty columns. Regarding the split, yet tried and not solve the problem. I’ll come back after done. Thank you for now

    Thread Starter BigBlack

    (@bigblack)

    I’ve tryed. I don’t had time before. I think the problem is the products limits on woocommerce. I’ve more than 3600 products. I have 3870 product and i need to add many more. It’s a complete price list. So i think i need to change ecommerce platform to do that. Or there’s something else to try?

    Hi,

    Sorry to hear that the issue persists, since some time has passed, may I have a new copy of the CSV file, please? You can include 1-2 products that are not working.

    Looking forward to hearing from you.

    Thread Starter BigBlack

    (@bigblack)

    After 1 year searching I found the solution. It was only a damn space difference between product COD and Parent code. Some product have the space before the code… Finally solved! Thank you for your support

    HI @bigblack

    I’m glad you were able to find a solution to your inquiry here and thanks for sharing it with the community too! ??

    Meanwhile, if you have a moment to spare, we would love it if you could share your thoughts with us by leaving a review or feedback. Your experience and feedback are important to help us improve and ensure we’re always providing the best possible support.

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Partial import of variable products in woocommerce from a csv file’ is closed to new replies.