CSV Bulk Editing

Solved
Highlighted
New Member
2 1 0

Hi guys,

 

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.

 

Pete

0 Likes
Tourist
21 0 2

Hi Pete,

 

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 support@ablestar.co.

 

Best,

Alison

 

0 Likes
Shopify Partner
173 25 43
Hi - I do this frequently but I just use the product editor in Shopify. You can filter by type and then select which products you want to delete. It then deletes those products and the associated variants. Would that work for you? Simpler than downloading CSVs.
If helpful then please Like and Accept Solution
0 Likes

Success.

New Member
2 1 0

Hi Jon,

 

Thanks for the reply. We typically edit dozens of products at any one time, using Product Type, as well as multiple tag filters, so CSV is the fastest option.

 

I've gotten around the problem by inserting some formulas filling any blanks with the values in the cells above.

 

Thanks,

 

Pete

0 Likes