DataSmith Kits

Clean up duplicate SKU records across your product and supplier CSVs, and prepare a cleaned Shopify-format CSV you can review before you import anything. Exact duplicates merge; detected conflicts are flagged for your decision — never guessed at.

• See duplicates where they hide: run one or more product or supplier CSVs through together — duplicates are caught between files, not just inside one.
• Each kept SKU appears once: exact duplicates merge; a gap in the kept row is filled only by copying a value a duplicate row actually has (logged in the report).
• Conflicts are flagged, not guessed: two prices, two stock counts, a reused SKU — every conflicting row is held back in a report for your decision.
• Variant problems caught too: the same variant under two SKUs, and rows breaking the product’s option pattern, are flagged for review.
• Offline, no subscription: a plain Python tool on your own computer. No account, no upload of your store data.

Inside: cleanup tool, 30-minute guide, checklist, samples with real outputs. Needs Python 3.8+ (Windows/Mac/Linux). Never touches your live store; no guarantee Shopify accepts any file. Sample test: 28 rows in → 7 products, 9 kept SKUs, 15 held back, 3 merged; 35 checks passed; re-run byte-identical.