- This topic has 3 replies, 2 voices, and was last updated 6 years, 5 months ago by
.
-
Posts
-
-
I wanted a simple way to remove all the defaults for my variable products (i.e. so when going into the product no variant is pre-selected). I have several hundred variable products and did not want to make the change manually on every single one.
To that end I used this plugin to export all products, removed all columns except for ‘ID’ and any column beginning ‘attribute_default’, deleted all data (obviously except for ID column), saved as CSV UTF-8 then imported back (after checking ‘update existing products’)
However, I got error ‘failed to import’ on every row
I then deleted ID column and replaced with SKU column, checked both ‘update existing products’ and ‘skip new products’ and imported again. This time I got message saying ‘skipped new product’ for every row
-
Hi Phil,
For the problem of ‘skipped new products’, you are getting this because, you already selected option “skip new products”.
Regarding the “Failed to import” error can you please provide us the csv via google drive so that we can check it and let you know about this?
Ideally this error comes when ;
– The CSV file is not UTF-8 encoded.
– If the CSV is correct encoded , then check at least post_title ( product name ) is mapped in import mapping section.If these two options are there, then please share with us the csv. We will immediately check and let you know the cause.
-
Solved this myself now.
Although I had exported the file initially using the program (which creates an ID column), the import to mapped all the other columns I was using from the export correctly, but not ID.
Once I created the mapping myself of ‘Product ID’ to create column mappings.
-
Hi Phil,
Great to know that your issue is resolved.
Thank you for your suggestions. We will surely see the possibility of tying the export columns into mapping for import.This seems a logical solution for the future.
-
- You must be logged in to reply to this topic.