Squarespace Import - Remove Duplicate Orders

Highlighted
Shopify Partner
2 0 0

I imported the squarespace data in my migration from Import Orders app but I have duplicate and triple orders now in Shopify. How do I remove the duplicates/triplets of the imported orders?

0 Likes
Highlighted
Explorer
38 4 17

Hi there !

You can use the excelify app to get rid of your duplicate orders. Follow these steps

1. First you have to download it from the Shopify app store. Then, go to your Shopify store back-end. Navigate Apps -> choose excelify -> export.

2. Choose Orders to export to Excel file.

3. Sort your exported file by Title and Handle

4. Make the formula that shows duplicated row of the same title

5. Filter Excel rows to show only the duplicate rows

6. Copy the columns ID, Handle and Command to the new sheet

7. Import the file with Excelify

Best regards, 

LitExtension team

 

LitExtension - Shopping Cart Migration Expert
If our answer is helpful then please accept as solution
Get in touch with us at:
Website: https://litextension.com/
Youtube: https://www.youtube.com/channel/UC0lUo_DSlg5NVg3vTxeaHpw?sub_confirmation=1
Twitter: https://twitter.com/litextension
0 Likes