Woocommerce Import Doesn’t Update Products

Hi @joyryde,

One reason that could happen is the upsells aren’t formatted correctly in the CSV file. They should look like this:

id:171, id:138, id:77

or

SKU-1, SKU-2

You can use either the product ID number or the SKU to specify which products should be linked as cross-sells or upsells. I tried this on my test site just now with IDs and didn’t run into any issues.

https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

This is how I’ve found things work best with CSV imports. First create a product that’s exactly what you want it to be like. Then export it. You can then use that as a template for setting up all of the others.

I hope that gets you pointed in the right direction.

Cheers!

Hi, thanks for the reply!

The way that I did it was to download all of the products in one category. I then copied and pasted the cross-sells from those downloaded products to the new ones that I had already uploaded to the site (I am trying to add cross-sells to new products).

It didn’t work. My site exports cross-sells as SKU’s, and I simply copied and pasted the table cells from the existing products to the new ones…and they remain blank no matter how many times I re-upload the CSV.

Hi @joyryde,

That should work. Could I get you to try making other changes to the products to see if it’s only the cross/upsells that aren’t updating? I’d be curious to know if only they are affected or if the site isn’t updating any products via CSV.

Thanks

I just ran the import again, it said “Import Complete, imported 81 Products”.

I changed the price of one product and it updated via the upload, but I checked 5 of the products to see if the cross-sells populated and not one of them did. All cross-sell fields are blank on all products that didn’t already have them.

I just ran the import 3 more times, it said “Import Complete, imported 81 Products”.

Not one Cross-Sell imported.

Hi @joyryde. Could you upload a copy of your csv file to an online storage space and share the link so that I may take a look? Another thing to check is to make sure that there are no spaces in the SKUs which you add to the Cross-sells column.

Hi,

Here is the test file we have tried 10 times without success.

It is a combination of existing products that have cross-sells, and new products we have added that do not import any cross sells from the spreadsheet.

https://docs.google.com/spreadsheets/d/1IwQGecAz7wNHOYbW1JulfcT5TQ2JBe2R6dedcJ_n-0s/edit?usp=sharing

Hi @joyryde, looking at your spreadsheet, it looks like the cross-sells column is incorrectly populated. You need a column called cross_sell_ids that contains the SKUs of the cross-sell products. Please refer to the schema here shared by Three Sons above for further information – https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

When we export products using Woocommerce, the field title is “Cross-sells”.

The file we provided above is the exported file from Woocommerce.

So you are saying that the export file from Woocommerce has different field headers than the import file requires?

We have exported 3 times, and all 3 times the field is “Cross-sells”

Hi @joyryde. You’re right. I did a test on my site and the title used is cross-sells. (I misread the documentation). However, the column has ids, not the names of the products. That column in your spreadsheet should contain ids or SKUs, not product names.

I mentioned two issues in my last response: the title of the column and its contents. The title of the column is not a problem (sorry for that confusion) but the contents is. When you fix the contents so that the cross-sell products’ ids or SKUs are used instead of the product names, you will be able to do the import again and the cross-sells will show in WooCommerce in your site.

Hello – That is not how Woocommerce exports product fields. It exports them as shown in our example file.

Hi @joyryde. That is unexpected. What version of WooCommerce are you running? I tested with the latest version so it may be a good idea to update WooCommerce if you haven’t yet done so. If that doesn’t help, I recommend conflict testing as explained here – https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Version 4.5.2

Hi @joyryde. Please let me know how the conflict testing goes.

Nothing changed about the export file when deactivating all other plugins.