BigCommerce product CSV cleanup
A BigCommerce product export made with the Bulk Edit template (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 | Product Name | Product Code/SKU | Price | Cost Price | Retail Price | Sale Price |
|---|---|---|---|---|---|---|
| 2 | Trail Backpack 28L (has spaces at its edges) | bp-trail-28 | $129.00 | $52.00 | $149.00 | $109.00 |
| 3 (removed) | ||||||
| 4 | Down Jacket | JKT-DOWN-M | $1,149.00 | $410.00 | $1,299.00 | $999.00 |
| 5 | Merino Beanie | hat-merino | $34.00 | $9.50 | $39.00 | $29.00 |
Result
| Row | Product Name | Product Code/SKU | Price | Cost Price | Retail Price | Sale Price |
|---|---|---|---|---|---|---|
| 2 | Trail Backpack 28L (changed) | BP-TRAIL-28 (changed) | 129.00 (changed) | 52.00 (changed) | 149.00 (changed) | 109.00 (changed) |
| 4 | Down Jacket | JKT-DOWN-M | 1149.00 (changed) | 410.00 (changed) | 1299.00 (changed) | 999.00 (changed) |
| 5 | Merino Beanie | HAT-MERINO (changed) | 34.00 (changed) | 9.50 (changed) | 39.00 (changed) | 29.00 (changed) |
3 rows × 11 columns after the fixes · was 4 × 11 · 15 cells changed
5 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
- UPPER-case "Product Code/SKU"On the sample: 2 cells changed
- Read "Price", "Cost Price", "Retail Price", "Sale Price" as numbers (decimal mark: dot, 1,234.56); values that are not numbers are left as they areOn the sample: 12 cells changed
Your file needs these columns, spelled exactly: Product Code/SKU, Price, Cost Price, Retail Price, Sale 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.