Shopify product import cleanup
A Shopify product CSV (Products → Export), before you import it again.
Processed locally in your browser. File contents are not uploaded. No account needed.
Before and after
Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.
Original
| Row | Handle | Option1 Value | Variant Price |
|---|---|---|---|
| 2 | Ceramic Mug (has spaces at its edges) | Sage | $18.00 |
| 3 | Ceramic Mug | Charcoal | $18.00 |
| 4 | Ceramic Mug | Sand | $19.50 |
| 5 (removed) | |||
| 6 | Linen Apron | Regular | $42.00 |
| 7 | linen apron | Large | $45.00 |
| 8 (removed) | Linen Apron | Large | $45.00 |
| 9 | Copper Cookware Set | 5 | $1,249.00 |
Result
| Row | Handle | Option1 Value | Variant Price |
|---|---|---|---|
| 2 | ceramic-mug (changed) | Sage | 18.00 (changed) |
| 3 | ceramic-mug (changed) | Charcoal | 18.00 (changed) |
| 4 | ceramic-mug (changed) | Sand | 19.50 (changed) |
| 6 | linen-apron (changed) | Regular | 42.00 (changed) |
| 7 | linen-apron (changed) | Large | 45.00 (changed) |
| 9 | copper-cookware-set (changed) | 5 | 1249.00 (changed) |
6 rows × 11 columns after the fixes · was 8 × 11 · 21 cells changed
8 more columns are not shown; they pass through unchanged.
· marks a space at the start or end of a value. The dots are not in the data; they show spaces you would otherwise not see.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Trim spaces in every columnOn the sample: 1 cell changed
- lower-case "Handle"On the sample: 6 cells changed
- Replace every " " with "-" in "Handle"On the sample: 7 cells changed
- Remove the characters "$" "," from "Variant Price"On the sample: 7 cells changed
- Remove rows that repeat an earlier row (matching every column), keeping the firstOn the sample: 1 row removed
Your file needs these columns, spelled exactly: Handle, Variant Price. If one is missing or renamed, the workflow tells you which step it breaks and does not run.
How to use it
Download the workflow
A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).
Open your export
In the Data Workspace, choose your file. It is processed in your browser, not uploaded.
Import, review, run
Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.