Select Sidearea

Populate the sidearea with useful widgets. It’s simple to add images, categories, latest post, social media icon links, tag clouds, and more.

Spify Shop by Brand
Shopify duplicate product: How to create and delete it from Shopify store.

Shopify duplicate product: How to create and delete it from Shopify store.

With the advent of the development of cutting-edge technology, every citizen can easily run their own online business. Furthermore, high technology enables store owners to save a large amount of time. For instance, if you want to save your time in adding new products on Shopify, you can duplicate your product. More specifically, based on the duplicated products, you can change some details to generate a new product on Shopify. In this blogpost, I will suggest a detailed instruction to create a Shopify duplicate product as well as remove it from your Shopify store.

Shopify duplicate product

At first, do you have a Shopify eCommerce website? If not, let’s read these following instructions to make an distinctive online website:

Shopify is one of the most outstanding platforms in the eCommerce market. It helps you to build your own online store without too much technical knowledge. Besides that, you can customize your brand in your own style. Moreover, it also provides a convenient interface for both sellers and customers. Particularly, it is suitable for all types of online stores. I guarantee it is one of the most functional eCommerce platforms. Let’s be creative to be the best one.

Furthermore, Shopify developers offer a wide range of customized apps and themes. In particular, two Shopify apps are totally free. It will assist shop owners who are not good at technology. Let’s explore Shopify and be unique.

Now I will tell you how to generate a Shopify duplicate product and remove it from the Shopify system.

Shopify duplicate product

How to create Shopify duplicate product:

Step #1: 

Firstly, you have to log into your Shopify account to arrive at the Shopify admin page. And then press the Products section.

Step #2: 

Then you must navigate the Product list button and press it.

Step #3:

Please find out the product that you want to duplicate in order to press on its name.

Step #4:

Now you have to choose the Duplicate button on the top right of the product page.

Step #5:

After that, a pop-up dialog will appear immediately. And then you have to type a new name for the product that you want to duplicate.

Step #6:

Finally, you have to press the Duplicate button to confirm your action. The Shopify duplicate product has a new name yet the same details with original products.

How to remove Shopify duplicate product from Shopify store:

Step #1: Export your Shopify products to an Excel file:

This action will display one product in a separate row.

Firstly, you have to log into your Shopify account to arrive at the Shopify admin page. And then press the Apps tab in the right panel of your page. 

In particular, you have to ensure that you have an Export Shopify App. If yes, to export products to Excel file, you have to tick the box next to Products then press the Export button.

Step #2: Sorted you Excel file by Title and Handle:

You have to apply the Sort feature in Excel in order to sort both Title and Handle at the same time.

After using the Sort feature of Excel, the same title will stand together followed by the other groups. The same also occurs in the column of Handle variables. In this way, your correct product is always the first one.

If you have some problems in finding out equal titles, please sort all factors in your table to ensure that your correct product is always the first one.

Shopify duplicate product

(Reproduced from Excelify.io)

Step #3: Make the formula that shows duplicated row of the same title:

Now you receive your duplicated rows sorted together in the correct order. And then you have to consider which one you want to keep and which one you want to remove.

You have to create a new column, namely Dupilcate?. In the second row of this column, please put this formula:

=IF(D2=D1,TRUE,FALSE)

And you must use this formula for other rows in Dupilcate? column.

Shopify duplicate product

(Reproduced from Excelify.io)

Step #4: Filter Excel rows to show only the duplicate rows:

Use the Filter feature to keep the Duplicate? row which is TRUE.

(Reproduced from Excelify.io)

Step #5: Copy the columns ID, Handle and Command to the new sheet:

Please copy the A, B, C columns containing filtered value to a new file and rename it to Products.

And then change the value of the Command column to DELETE. After these steps, you will receive a file like this following image:

 (Reproduced from Excelify.io)

Step #6: Import the file with your export/import Shopify app:

Finally, to remove a list of Shopify duplicate products from your Shopify store, you have to import your Products file that you just created into the Shopify app.

Now your mission is to wait for the result. Your Shopify only contains one copy of each product. 

To conclude: 

Here is my step-by-step instruction for you to create a Shopify duplicate product as well as remove it to your Shopify store. I hope it will be useful for you to easily add new products.  

Please remember ArrowHiTech always offers a wide range of excellent Shopify themes and apps.

If you have any problem in setting up your online store from scratch, do not hesitate to meet ArrowHitech. Our 12-year experience staff in Shopify development and outsourcing will help you set up your dream online store.

Write a comment