Woocommerce Import Doesn’t Update Products

This issue is still not resolved.

Today I exported from Woocommerce (yet again). I then modified the CSV to update the cross-sells and imported the file.

It erased over 8,000 woocommerce product cross-sells. My website now has NO cross sells because of this issue.

Here are the first 5 examples from he spreadsheet. If you export them from Woocommerce, this is how they look. If you import them, they vanish completely from the website.

ID	Regular price	Cross-sells
11385	10.75	1-year-extended-service-plan-for-products-priced-0-100, 2-year-extended-service-plan-for-products-priced-0-100, 4-year-extended-service-plan-for-products-priced-0-100
11344	11.94	1-year-extended-service-plan-for-products-priced-0-100, 2-year-extended-service-plan-for-products-priced-0-100, 4-year-extended-service-plan-for-products-priced-0-100
11354	11.94	1-year-extended-service-plan-for-products-priced-0-100, 2-year-extended-service-plan-for-products-priced-0-100, 4-year-extended-service-plan-for-products-priced-0-100
4151	11.94	1-year-extended-service-plan-for-products-priced-0-100, 2-year-extended-service-plan-for-products-priced-0-100, 4-year-extended-service-plan-for-products-priced-0-100
11453	12.28	1-year-extended-service-plan-for-products-priced-0-100, 2-year-extended-service-plan-for-products-priced-0-100, 4-year-extended-service-plan-for-products-priced-0-100

Today we disabled all plugins except for Woocommerce.

We imported every single product and not one of them correctly imported the Cross -sells.

On 90% of them, it erased all cross sells from the entire website. On 10% of them, it randomly picked one of the 3 cross sells and added it, and left out the other two that all products have.

Here is the screenshot:

https://pasteboard.co/JMFHC7p.png

Did you manage to get this problem solved? Encountering the same issue myself.

Nope. And Woocommerce refuses to respond or fix it. We’ve tried to upload probably 30 times. Doesn’t work. We are now paying developers to write code to solve our problem since the import feature doesn’t work.

Hi @joyryde,

If you do find a bug, please report it on GitHub. The developers monitor GitHub issues to look for any bugs to fix. You’ll want to verify that this happens on a clean installation of WooCommerce with only WooCommerce and a default theme active (like Twenty Twenty-one).

Report the exact steps they’ll need to experience the bug for themselves in an issue and they’ll be happy to take a look at it for you.

https://github.com/woocommerce/woocommerce/issues/new/choose

Got it figured out from my end – although, I use WP Import. Not sure if that makes a difference.

Export format was: SKU|SKU|SKU e.g. 1033|1044|1055
This format didn’t work on import.

Through trial and error, successful import format was; Title,Title,Title. e.g. Maintenance Oil,Spray Cleaner,Mop.

maintenance-oil,spray-cleaner,mop format worked too. Although, I see you have tried this format.

Specified the id field upon import;
_crosssell_ids & _upsell_ids

Same problem, importing CSV doesn’t update product details, but no errors shown.

Any solutions yet?

We import daily to update tens of thousands of prices and the import works great, it just cannot import Cross-Sells.

Umm, ok, we have a bit different problem then.

Made api request to supplier, converter to csv, imported products.
Now same request, same conversion but doesn’t add or update any kind of product info, main problem is stock. No errors. Importing new products works fine.

How this thread can be marked as resolved when it’s not?

I’m having import issues also.
whether I enable or disable the tickbox to update existing products on import, in either case the udpated content does not import and I receive an error log say “id already exists, skipping product” for each product in the csv.
I’m trying to include different images and changes to descriptions but I cannot get them to update. Any ideas?

Hi @auxjoel,

Please create a new thread here so that your issue can be looked at separately – https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0.

* This is in line with the forum guidelines on posting on related threads..

Thanks.