Bulk Delete Discounts from Shopify

Bulk Delete Discounts Tutorial

So you need to bulk delete Discounts from your Shopify store.

Here’s how you delete any Shopify Discount with Excelify.io app:

1. Export your existing Discounts from Shopify to Excel

Just click the checkbox for the Discounts and all your Shopify store Discounts will be exported to Excel.

Export Discounts

2. Edit exported Excel file to mark discounts you need to delete

Delete from that Excel file all the discounts which you want to keep in your store – so that your file contains only Shopify Discounts you want to delete.

Then set the values for “Command” column to “DELETE”.

Like this:

Discounts Delete Command
3. Import prepared file to delete those Discounts

Import Deleted Discounts
That’s it – those Discounts will be deleted from your Shopify store permanently.

Good to know

  • You can delete any other items from your Shopify store the same way.
  • Before deleting Discounts, you might want to do the full export of all Discounts details to Excel file. You can keep that file for reference, or even restore deleted discounts later to your Shopify store if you need to.

 

Bulk Delete Collections from Shopify

Bulk Delete Collections from Shopify Tutorial

So you would like to bulk delete Collections from your Shopify store.

You can do it with Excelify.io app like that:

1. Export all your existing Collections

Because there are two kinds of collections in Shopify: Smart and Custom, you can delete Collections of just one kind or both.

In the Export section, click the Smart Collections/Custom Collections or both checkboxes to Export needed Collections.

Export Collections from Shopify

2. Leave in Excel file only the collections you want to delete

Make sure to remove all those Collections rows from that Excel file, which you want to still keep in your store. So that your file contains only Collections you want to delete.

And then set the “Command” column to “DELETE” for all of them.

Like this:

Delete Shopify Smart Collections

If you need to delete Collections of both kinds, pay attention, that there are two sheets in the Excel and add set the “Command” column to “DELETE” on both sheets.

Delete Shopify Custom Collections

3. Import that file with the app to delete collections

Bulk Delete Collections from Shopify with import

That’s it – those collections will be deleted now.

Good to know

  • You can bulk delete any other Shopify items the same way, like Products, Discounts, Pages, Orders, etc.
  • Before you delete Shopify Collections, you might want to do the full export of all Collections with the app. You can keep that Excel file for reference, or even restore deleted collections later to your Shopify store if you need to.
  • You can combine commands for the same import – delete some collections, but update other collections, and even create new collections, all at the same time.

How to update Product by SKU?

Update Shopify Variants by SKU

Quite often, when getting Product data for updating from suppliers or other data sources, you have just the product SKU, but not the Product ID or Handle to identify it.

That’s ok – now the Excelify.io app can identify your Product by only the SKU number, and do all the same advanced updates and with it.

You can:

  • Update existing Product base fields (like Tags, Published, and so on) by having just the Variant SKU;
  • Update existing Product Variant fields (like Variant Inventory Qty, Variant Price, and so on) by having just the Variant SKU;
  • Update existing Product Metafields by just the Variant SKU;
  • Import Product Images by identifying products by Variant SKU;
  • Delete Variant from the Product by having just the Variant SKU;
  • Delete the Product itself by having just the Variant SKU.

SKU number column is called “Variant SKU” (even if your product doesn’t have variants).

Here are examples of all the mentioned scenarios.

Update existing Product base fields by SKU

For example, to update product Tags for each SKU, import columns like this:

Variant SKU Tags
SKU-1001 Tag1, Tag2, Tag3
SKU-1002 Another Tag1, Tag2, Tag3
SKU-1003 And Another Tag1, Tag2, Tag3

Update existing Product Variant fields by SKU

For example, to update product price and inventory quantity for each SKU, import columns like this:

Variant SKU Variant Inventory Qty Variant Price
SKU-1001 1000 9.99
SKU-1002 2000 19.99
SKU-1003 3000 99.99
4000 109.99

You can add additional columns to this import, to update them all at once.

Notice the empty Variant SKU value – that will update all Variants that don’t have a SKU number.

Update existing Product Metafields by SKU

For example, to update product Tags, inventory quantity, and Metafields, you would import columns like this:

Variant SKU Tags Variant Inventory Qty Metafield: your.metafield_name
SKU-1001 Tag1, Tag2 1000 value1
SKU-1002 Tag1, Tag2 2000 value2
SKU-1003 Tag1, Tag2 3000 value3

If the several SKU will belong to the same product, then the Tags and Metafields for that product will be set only from the first SKU that belongs to that product.

Import Product Images by identifying products by Variant SKU

If you need to add images to Products, but you only have the Variant SKU, you can do import like this:

Variant SKU Image Src Image Position Image Alt Text
SKU-1001 https://images.com/image1.png 1 Image about first thing
SKU-1001 https://images.com/image2.png 2 Image about second thing
SKU-1001 https://images.com/image3.png 3 Image about third thing

All the products that will have this SKU, will get those images imported.

Delete Variant from the Product by SKU

If products have several variants, and you just need to delete specific variants and keep the other variants of those products unchanged, import table like this:

Variant SKU Variant Command
SKU-1001 DELETE
SKU-1002 DELETE
SKU-1003 DELETE
DELETE

Also notice here the empty Variant SKU value. That will delete all variants that don’t have the SKU number.

Delete Product by SKU

Notice the difference from the previous example where you deleted just one variant from that product – here you will delete the whole product. In this case, even if the Product will have 100 variants, if just one of its SKU will be found, the whole product with all its variants will get deleted:

Variant SKU Command
SKU-1001 DELETE
SKU-1002 DELETE
SKU-1003 DELETE

Typically. you would want to use this method to delete products which have just one variant. But you can see how you can go beyond that, too.

How the import by SKU works?

In Shopify, the SKU is the attribute of the Variant. That means that each Product can have one or many variants, each having its own SKU number.

First, the app will index all SKUs in your import file – grouping rows by SKU value. Then the app will go through your whole store and update all the products/variants which will match the SKUs from your import file. It will not change any other variants or products.

On your store, SKUs don’t have to be unique. The app will update all SKUs that will match SKUs from your import file.

Logically, if you import table of many SKU numbers, then some of SKUs might belong to the same Product. Before making any changes to that product, the app is taking all that into account and is grouping together SKUs that belong to the same product. That will ensure the consistency of data in all product variants and will improve import speed because each product will be updated just once.

Import Results

After the import, in your Import Results file, you will see the additional columns “ID”, “Handle” and “Variant ID” added from your store, so that you see, which products and variants actually were updated.

Good to know

  • If you need to make your SKU numbers unique across your whole store, you can do the full export of Products with their Variants, and create the Pivot Table in Excel, where you put “Variant SKU” as Rows, and count Variant SKU values. Then you can see, which Variant SKUs count is more than 1 – then you can fix those in your store manually, or using the Excelify.io app to do that in bulk.
  • If you need to get the list of Products which have certain SKUs, you can just import the file with one column “Variant SKU”. In the Import Results file you will see all the products, their ID, Handle and Variant ID – which has which of your SKUs from your table. Then you can update their Titles or even Handles.
  • You can add additional columns to this import, to update them all at once. You can combine base columns, Variant columns, and even image columns in the same import.
  • Column order doesn’t matter.
  • You can update Product by knowing the Barcode or Options of Variants, but then you need to have Product ID or Handle too. This is how to do it.

Read more about all the Products columns.

 

Bulk Delete Orders from Shopify

So you need to bulk delete Orders from your Shopify store because you created those orders while testing or those are just unneeded for some reason.

Through Shopify Admin you might not be able to delete them because they are already archived, or there is just too much of them that deleting them one by one is just too time-consuming.

Here’s how you delete any Shopify Order with Excelify.io app:

1. Export your existing Orders from Shopify to Excel

You might even not need to export any other details about those orders – that way your exported Excel file will have just one row per Order, which will be convenient in this situation.

Export Shopify Orders to Excel2. Edit exported Excel file to mark orders you need to delete

Delete from that Excel file all the orders which you want to keep in your store – so that your file contains only Shopify Orders you want to delete.

Then set the values for “Command” column to “DELETE”.

Like this:

Mark Shopify Orders as deleted in Excel file3. Import prepared file to delete those Orders

Status of deleted Shopify OrdersThat’s it – those Orders will be deleted from your Shopify store permanently.

Good to know

  • You can delete any other items from your Shopify store the same way.
  • Before deleting orders, you might want to do the full export of all Order details to Excel file. You can keep that file for reference, or even restore deleted orders later to your Shopify store, if you need to.

 

Bulk Delete Customers from Shopify

Shopify bulk delete Customers featured

So you are in this situation when you need to bulk delete Customers from your Shopify store.

You can do it with Excelify.io app like that:

1. Export all your existing Customers

In the Export section, click the Customers checkbox to export Customers. You can also include their addresses if you will need that data to select, which customers you need to delete.

Export Shopify Customers to Delete

2. Edit the Excel file to keep customers you need to delete

Make sure to remove all those customer rows from that Excel file, which you want to still keep in your store. So that your file contains only Customers you want to delete.

And then set the “Command” column to “DELETE” for all of them.

Like this:

Shopify Customer Delete command3. Import that file with the app

Shopify bulk delete customers result

That’s it – those customers will be deleted now.

Good to know

  • If any customer deletion will fail, then most likely that customer has an Order, and Shopify doesn’t allow to delete customers which have orders. To delete that customer, first, you need to delete their Order. You can bulk delete Shopify orders the same way too.
  • You can bulk delete any other Shopify items the same way, like: Products, Discounts, Pages, Orders, etc.

 

Bulk Delete Products

Shopify bulk delete is tricky, and if you had serious need to delete selected products, and lots of them, you know how tricky.

But there is a better way to bulk delete Products from Shopify Admin, especially in cases, when you need to delete several products on several pages by criteria which are not available in search.

Step 1: Export Products to Excel

Export all products into Excel file with Bulk Import Export Update with Excel app.

Step 2: Change the “Command” column values to “DELETE”

In the export file, you will notice the column “Command”. Change the value of this column to “DELETE” for those products you want to delete in bulk.

Remove all the other rows from the file, which you don’t want to delete so that your file remains only with products you really want to delete.Shopify bulk delete products

Step 3: Import updated Excel file back to ShopifyShopify bulk delete products from store

Useful To Know About Shopify Bulk Delete

  • You can delete Products by ID, by Handle, by Variant SKU, by Handle that is calculated from Title.
  • This method is very useful if you need to delete a lot of products that are located on the several sheets in Shopify product list. There is no need to browse from page to page.
  • You can filter products in Excel spreadsheet by any parameter you need and set Command to DELETE.
  • You can have in the rows with a different command for each product, in the same import file. For example, with the same import, you can delete all products that are out of stock, and update all products inventory quantity, that is still in the stock. Just set the UPDATE or DELETE command for each product respectively.
  • You can use the same method to delete any items: Collections, Customers, Orders, Discounts, Pages…

Where To Go From Here?

  1. Install the “Bulk Import Export Update with Excel” app from AppStore and do your Shopify Product price update.
  2. Read the Field Descriptions about the Excel file columns that can be exported and imported to Shopify.
  3. Ask our Support to help you prepare the import file, report an issue or ask for a new feature you desperately need.