Tutorial

Deleting Products from Google Sheets

Learn how to delete Shopify products in bulk using Google Sheets and eCommix.

Hernán Demczuk
Hernán Demczuk
Author
2 min read

This tutorial assumes you already know what Two-Way Sync is and how to configure it. If not, please review the How Two-Way Sync Works tutorial first.

1. Choose the Products template

From the home page, select the Update Products category in the template filter bar and click Create on the Products template. If you are configuring a spreadsheet from scratch, click New Spreadsheet, select Two-Way Sync as the sync direction, and then choose the Products template.

Home page showing the Products template with Update Products category selected
Select the Update Products category to find the Products template quickly

2. Delete Existing Products

To delete a product, keep the Id (Product) value but clear the Title (Product) cell completely; leave it blank. When eCommix sees an ID with an empty title it treats the row as a delete. This permanently removes the product and all of its variants and images from Shopify.

Google Sheet showing rows with Id filled but Title cleared, highlighted in light red to indicate deletion
Rows with an ID but no title turn light red after validation; they will be deleted on import

After validation, rows with a cleared title turn light red to indicate they will be permanently deleted from Shopify on import. Go back to eCommix, click Sync, then Validate to preview the changes, and Import to apply them. The full flow is covered in the How Two-Way Sync Works tutorial.

If you need to delete individual variants instead of the whole product, see the Deleting Product Variants from Google Sheets tutorial.

Related articles

More guides in this category if you want to keep going deeper on the same workflow.

Ready to manage your Shopify store with Google Sheets?

Install eCommix free and start syncing your products, orders, and inventory in minutes.

Install Free on Shopify →