Importing Woocommerce-Product From Csv

Closed

Import WP Addon - WooCommerce Updated 6 months ago 11 Replies

Nicolas asked 7 months ago on November 3, 2023 at 10:24 am

Hello,

I can’t import products with more variations. For example, the product has a size and a color and each should be selectable on the product page?

I followed your procedure via

Import WooCommerce Products from CSV / XML

but I’m still getting an error message for my product import with color and size variations on the same parent product.

I’ve attached my test file and my import configuration.

Can you please tell me where I’m going wrong?

Thank you for your help.

Nicolas

J

James replied Support Agent

7 months ago on November 3, 2023 at 9:01 pm

Hi Nicolas,

The parent product with sku: 195242649626 , should be type "variable" not "simple".

And from the screenshot showing your Advanced > Parent should be {1} instead of {6}.

If you need to send your importer settings again, this can be done by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

James

 

NB

Nicolas replied

6 months ago on November 4, 2023 at 8:51 am

Hi James,

I made the changes (see image)

But I still have import errors

1 Invalid product.

2 The variation cannot be imported: the parent ID is missing or the parent does not yet exist.

 

Thanks for your help

 

J

James replied Support Agent

6 months ago on November 4, 2023 at 9:22 am

Hi Nicolas,

Can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

James

NB

Nicolas replied

6 months ago on November 4, 2023 at 10:30 am

Hi James

 

Here it is attached

 

Nicolas

J

James replied Support Agent

6 months ago on November 4, 2023 at 10:49 am

Sorry, can you send me your latest csv file

NB

Nicolas replied

6 months ago on November 4, 2023 at 10:55 am

J

James replied Support Agent

6 months ago on November 4, 2023 at 11:06 am

I have imported your importer and csv file.

Can you make sure you have deleted the existing product, and emptied the trash before running the import.

Upon running the importer i get the following attached screenshot.

The reson for the 2nd record having an error is that the sku and its parent sku (e.g. record 1 and record 2 have the same sku's)

James

J

James replied Support Agent

6 months ago on November 4, 2023 at 11:07 am

To make sure we have the same version of importwp-woocommerce installed could you install the attached version.

NB

Nicolas replied

6 months ago on November 4, 2023 at 5:27 pm

Hi James

I updated the wp-woocommerce import plugin

And I created a new test file with another product

No import problem.

Thanks for your help

Nicolas

 

J

James replied Support Agent

6 months ago on November 7, 2023 at 3:37 pm

Hi Nicolas,

Just checking in to see how you are getting on with the importer? before i close the ticket.

To help support the plugin i would be very grateful if you could leave a rating/review only if you want to https://wordpress.org/support/plugin/jc-importer/reviews/

James

NB

Nicolas replied

6 months ago on November 7, 2023 at 7:48 pm

Hi James

 

Ok to close the ticket

 

Thank Nicolas