Hoping someone can help, fairly new to Shopify. I'd like to do some bulk editing of products via CSV, not an app. As an example, I need to filter by 'Type', to see which products need to be deleted etc. The problem I have is that none of the product variants (of which we have many) have a 'Type' in the CSV. So while I can filter by a particular Type and delete dozens of products, in effect I'm only deleting the first listed variant of those products.
If anyone has a CSV-based solution I'd be very grateful.
Solved! Go to the solution
My name is Alison, and I'm the Customer Success Specialist for Ablestar Apps.
Our Bulk Editor app (https://apps.shopify.com/bulk-product-editor) allows you to edit your products using a CSV. The first column in the file needs to be an identifying column, we usually use 'Variant SKU' or 'Handle' for this, but as long as it can identify the product it will work. The app can also generate a spreadsheet for you to use that uses the 'Variant ID' as the matching field for cases where 'SKU' or 'Handle' won't work. You can include as many other columns as necessary for the modifications. After modifying the spreadsheet, you can upload it back into the system to make the modifications. You can read more about the spreadsheet edits here: https://support.ablestar.co/article/23-editing-products-by-spreadsheet.
The app also allows you to schedule both edits and undo's, which is very helpful for setting up and ending sales.
There is a free version available that allows for 5 free in-app edits, and 5 free spreadsheet edits a month. As long as you stay under the edit limit, you will not be charged, and you would be prompted before going over the limit.
If you have any questions please feel free to reach out to us at firstname.lastname@example.org.