Woocommerce product import issue

  • Resolved clingendael

    (@clingendael)


    6 years, 1 month ago

    Hi,

    I tried to import some products through the import/export option in woocommerce. Unfortunately this did not go successful. The import itself works but the product that I wrote in the file do not show up. The products that show up are created by itself and goes into some kind of loop.

    Here is a screenshot of the result of the import: https://imgur.com/a/X4vQ0

    FYI: I use a CSV file and Before importing I first export the products to see what data I can adjust. After exporting I adjust the data and import back which leads to the loop result.

    Thanks in advance!

    • This topic was modified 6 years, 1 month ago by clingendael.
Viewing 9 replies - 1 through 9 (of 9 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    6 years, 1 month ago

    Are you checking the setting the merge with existing products?

    Try exporting, then importing the same, un-edited file. Does this same problem happen in that test?

    Sounds/looks like a possible theme or plugin conflicts. So I would rule that out by trying with only the WooCommerce plugin active and a default WP theme in use: https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4

    Thread Starter clingendael

    (@clingendael)

    6 years ago

    Hi Caleb,

    Thanks for your reply, I will try it to see if it works!

    Thanks

    Thread Starter clingendael

    (@clingendael)

    6 years ago

    Hi Caleb,

    It tried disabling every plugin instead woocommerce and switched to a basic theme (seventeen eleven) and did a export of my current products and then a import. That went successful, nothing weird got imported. So I tried this whith new products. I kept every plugin disabled and kept the basic theme. But after import I again got the weird automatic products loop.

    Do you know by any change why this is so?

    Thanks in advance!

    Mikey (a11n)

    (@mikeyarce)

    6 years ago

    Hi @clingendael,

    It tried disabling every plugin instead woocommerce and switched to a basic theme (seventeen eleven) and did a export of my current products and then a import. That went successful, nothing weird got imported. So I tried this whith new products. I kept every plugin disabled and kept the basic theme. But after import I again got the weird automatic products loop.

    I haven’t seen that before! What version of PHP and MySQL are you on? I would make sure you’re on PHP 5.6 at least, 7 would be ideal.

    I would also suggest saving your CSV file only with Google Docs and not using Excel to see if that helps.

    Thread Starter clingendael

    (@clingendael)

    6 years ago

    Hi Mikey,

    Alright. I am using PHP 7.1.

    Thanks!

    Thread Starter clingendael

    (@clingendael)

    6 years ago

    Hi Mikey,

    There is also something weird that I don’t understand. When exporting my existing products, the products ID don’t have a logic order. I made a screenshot to show you. Do you have any idea why this is so? Because when adding products I’m not sure what ID to give them.

    View post on imgur.com

    Thanks

    Mikey (a11n)

    (@mikeyarce)

    6 years ago

    Hi @clingendael,

    There is also something weird that I don’t understand. When exporting my existing products, the products ID don’t have a logic order. I made a screenshot to show you. Do you have any idea why this is so? Because when adding products I’m not sure what ID to give them.

    Good question!

    So, WordPress assigns Post IDs to everything that is a Post. So, Posts, Pages, Products, Images, Attachments, etc all get their own ID. It starts at 1, and then goes up. If you see a gap it might mean that you uploaded images in between, or made new blog posts. OR imported 100 products, deleted 100 products, etc.

    Basically, it’s perfectly normal to have IDs that are random. IDs are not used in anything except for the database to find what that is. You do not want to assign IDs on import either. Because you don’t know what IDs are already taken and so you might have a problem that way. Best to leave IDs blank when making new products.

    Thread Starter clingendael

    (@clingendael)

    6 years ago

    Hi Mikey,

    Thanks for the fast reply! You were right about the IDs! That was the problem of the loop, because I assigned them IDs. Now that problem has been solved I have run into something else. I’m not sure if I can continue in this request or make another one.

    Thanks again!

    Mikey (a11n)

    (@mikeyarce)

    6 years ago

    Hi @clingendael,

    Glad we figured it out!
    Best to make a new request for sure.

    Cheers,

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Woocommerce product import issue’ is closed to new replies.