Product Export/Import

Hello @cshinkin,

Thank you for reaching out.

I understand that you’re experiencing issues with the product IDs not matching after importing them into your rebuilt site. This could be due to several reasons. One common issue is that the import/export process might not be capturing all the necessary data, or there could be an encoding issue.

To troubleshoot this, could you please ensure you’re using the latest version of WooCommerce and any plugins you have installed. Also, try exporting and importing your data again, ensuring that all fields are included, and the file is in the correct format.

You may find more details on this from our guide here: https://woo.com/document/product-csv-importer-exporter/

Let us know if this helps.

All plugins are up to date yes. I am reading that any Product export in WordPress will not copy over the original product IDs however well you do it. Thus far it is my experience however I would like to know if this is correct or there is a way please.

Hey, @cshinkin!

I am reading that any Product export in WordPress will not copy over the original product IDs however well you do it. Thus far it is my experience however I would like to know if this is correct or there is a way please

You are correct.

It is not possible to assign a specific post ID to product on import. Products will always use the next available ID, regardless of the ID included in the imported CSV.

https://woo.com/document/product-csv-importer-exporter/#general-guidelines

Do you mind sharing more details about the issue you are facing with the IDs so we can assist you further?

Furthermore, I’d like to understand your site properly. Please share with us the System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.

You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Looking forward to your reply.

Have a wonderful day!

Link – https://github.com/shinx1951/woo/blob/main/rebuild

I was hoping to import all products via CSV with original IDs as these are linked to Customer Reviews. However without the original Product IDs the reviews generate as incorrect and become useless.

Hey @cshinkin,

As you already know, WordPress assigns new IDs to the products during the import process and doesn’t use the original ones from the CSV file.

However, there’s a workaround you may consider. You can link the reviews to the products using the SKU instead of the product ID. In your CSV file for reviews, you can use the product_sku column to link the review to the product. This way, even if the product IDs change during import, the reviews will still be linked correctly to the products.

More info: https://woo.com/document/product-csv-importer-exporter/#update-existing-products

Please give this a try and let us know how that goes.

That’s a very good solution however CusRev export doesn’t include SKUs. I will think on if their is a practical way I can add the SKUs to the export.

Hi there @cshinkin

I will think on if their is a practical way I can add the SKUs to the export.

This sounds like a good idea, let us know how it goes.