Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Re: how to delete Variants in Bulk Upload via CSV commands

how to delete Variants in Bulk Upload via CSV commands

paulurshartl
New Member
6 0 0

Dear Community,

I am currently facing an issue when bulk-uploading my products using a CSV file, as a variant is created automatically for each new product in my shop. The challenge arises when I need to enter or edit the barcodes for the Products, as I have to manually remove each variant from every product. Consequently, with 150 products, this process becomes time-consuming. Is there a method within the upload-CSV file to prevent the creation of variants for each product? Alternatively, are there any other approaches or tools within the Shopify web app that would allow me to efficiently bulk delete variants across different products?

Thank you for your assistance.

Replies 10 (10)

Edgywebsites
Shopify Partner
30 2 36

You cannot do this natively in Shopify. I recommend you the app that I have used in past. Works well. Please have a look.
https://apps.shopify.com/excel-export-import

 

Best, 
S

If our response solved your query, please like and accept it as the solution.

Edgy Websites · All things Shopify
Contact us for Expert Shopify Support
paulurshartl
New Member
6 0 0

I apologize for any confusion in my previous explanation. We employ Matrixify to upload our products with a CSV. Could you please specify which cell in the CSV I need to focus on to ensure that Shopify does not add any variants to the uploaded Products? With the multitude of metafields and stuff involved, your guidance will be greatly appreciated 😄

Edgywebsites
Shopify Partner
30 2 36

What I usually do is export the CSV as it is, and then delete the variants from admin panel normally and export the CSV again. This way I can compare the before and after CSV. And then go ahead an make necessary to the CSV as per the 2nd CSV. 😄 Hope that helps!

If our response solved your query, please like and accept it as the solution.

Edgy Websites · All things Shopify
Contact us for Expert Shopify Support
paulurshartl
New Member
6 0 0

I think i understand the point. I will try and will report if it worked out for me or not 🙂

Edgywebsites
Shopify Partner
30 2 36

No problem. Good luck!

If our response solved your query, please like and accept it as the solution.

Edgy Websites · All things Shopify
Contact us for Expert Shopify Support
paulurshartl
New Member
6 0 0

So i exported one with a variant and one without using matrixify but both was the same in the CSV.

Ablestar_Daniel
Shopify Partner
136 23 45

One way to quickly delete the variants would be to use our Ablestar Bulk Product Editor. With the app you can search for the products you want to modify and then select 'Delete Variants' as the field to edit:

 

Screenshot 2023-12-20 at 1.07.01 PM.png

 

A few things to keep in mind when deleting variants:

  • This will delete the variants for a product which has the effect of converting it into a product that doesn't show any variants in the Shopify Admin
  • Deleting variants is permanent so we recommend trying it with a single product first

The app has a 7-day free trial (with unlimited edits) and deleting the variants should just take a couple minutes. If you run into any questions feel free to reach out.

 

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!
paulurshartl
New Member
6 0 0

But can you do this with all Products listed at the same time?

Ablestar_Daniel
Shopify Partner
136 23 45

Yes, when you open up the app you'll see a list of all your products. You can filter this list if you only want to edit some products. Then you click on Edit Products at the top:

 

Screenshot 2023-12-20 at 3.17.08 PM.png

 

One the next screen you configure how you want to modify your products. In your case you can click on the 'Field to Edit' button and choose 'Delete Variants' from the options:

 

Screenshot 2023-12-20 at 3.20.15 PM.png

 

The click on the Delete Variants button on the top of the page and the app will remove the variants for all the products you filtered for:

 

Screenshot 2023-12-20 at 3.21.01 PM.png

 

As I mentioned before, this is a permanent thing (whereas almost every other edit can be undone) so I would test this on one product first to make sure it works as expected. To do that, you would filter for a single product on the first screen and then follow the rest of the steps.

 

I hope this helps and happy to answer any follow up questions.

 

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!

paulurshartl
New Member
6 0 0

@Gabe Hast du zufällig eine Lösung dafür? 🙂