Bulk delete product variants in your Shopify store
To delete product variants in bulk in your Shopify store, work in a Products (with variants) worksheet, where each row is one variant. Select the rows of the variants you’d like to delete, just like you would in Excel: click the first row number and drag the mouse over the other row numbers. Then:
- To delete one product variant, right-click its row number and choose Delete product variant in Shopify…. To delete several at once, select their rows, then right-click one of the selected row numbers (or open the Row menu) and choose the option, which shows the count, for example Delete 3 product variants in Shopify…
- In the Delete Shopify Objects window, check the list of what will be deleted. This cannot be undone
- Click Delete, then click Are you sure?? to confirm
- Mixtable asks Shopify to delete the product variant. Once Shopify has deleted it, Mixtable clears the row and leaves it empty. To tidy up, choose Worksheet > Remove Empty Rows
Only the spreadsheet's owner can delete in Shopify, and only on rows linked to Shopify. Deleting also needs Mixtable Spreadsheet Editor installed in your store: if your store has only Mixtable Analytics Spreadsheet or Mixtable Export: Excel & CSV, the window says "Deleting in Shopify needs Mixtable Spreadsheet Editor" and nothing is deleted. If the worksheet is filtered, hidden rows are left alone.
Mixtable deletes only the variants you selected, not the products they belong to. The Delete Shopify Objects window reminds you of this before you confirm.
If you only want to take rows out of your worksheet and leave the variants in Shopify, right-click one of the selected row numbers and choose Remove 3 rows from sheet instead (the number matches your selection).
