Duplicate Draft Orders Detection

Identify and remove duplicate draft order records from the database
How This Tool Works: When you fix duplicates, the tool will:
  1. Delete ALL duplicate database records for that Shopify order
  2. Fetch the current draft order data from Shopify API
  3. Save the fresh Shopify data as a single clean record
This ensures you have the most up-to-date data directly from Shopify, not from cached copies.
Total Draft Orders
833
Orders with Duplicates
3
Total Duplicate Records
6
Records to Remove
3
Bulk Actions: Delete all duplicate records and fetch fresh data from Shopify for each order.
Shopify Order ID: 1216344031516
2 copies found
DB Record ID Order Name Customer Line Items Tags Created At Updated At Action
1216344031516 #D1174 Portal Orders 4 items c_dm_approved_Design_Afrika, N... 2025-09-22 11:06:11 (most recent) DELETE
1216344031516 #D1174 Portal Orders 4 items c_dm_approved_Design_Afrika, N... 2025-09-22 11:06:11 DELETE
↓ After deletion, will fetch fresh data from Shopify and save as single record ↓
Shopify Order ID: 1228209062172
2 copies found
DB Record ID Order Name Customer Line Items Tags Created At Updated At Action
1228209062172 #D1272 Elizabeth Joubert 4 items c_dm_approved_Neil_Grantham_St... 2025-10-08 14:49:35 (most recent) DELETE
1228209062172 #D1272 Elizabeth Joubert 4 items c_dm_approved_Neil_Grantham_St... 2025-10-08 14:49:35 DELETE
↓ After deletion, will fetch fresh data from Shopify and save as single record ↓
Shopify Order ID: 1291299488028
2 copies found
DB Record ID Order Name Customer Line Items Tags Created At Updated At Action
1291299488028 #D1412 Anissa Colaco 19 items id_rdy_approve_Wolkberg_Castin... 2026-01-22 13:26:46 (most recent) DELETE
1291299488028 #D1412 Anissa Colaco 19 items id_rdy_approve_Wolkberg_Castin... 2026-01-22 13:26:46 DELETE
↓ After deletion, will fetch fresh data from Shopify and save as single record ↓