Documentation
Bulk fix spreadsheet errors
Replace slow Excel find-and-replace with bulk edits across your entire inventory import — fix thousands of SKU, quantity, and min/max errors in one pass.
Fixing inventory import errors in Excel or Google Sheets does not scale. Find-and-replace helps for one column and one value, but real supplier files need bulk fixes across the whole dataset — including rows you have not opened yet.
Where Excel breaks down
| Task | Excel approach | Problem |
|---|---|---|
| Fix 200 rows with empty brand | Filter + fill down | Easy to miss unfiltered rows |
| Normalize quantity format | Find & replace | Breaks valid text fields |
| Remove duplicate SKUs | Remove duplicates tool | Hides which row to keep |
| Fix min/max on one store | Pivot + manual edits | Slow, not repeatable |
| Validate before import | Custom formulas | Fragile, file-specific |
Spreadsheets are great for analysis. They are a poor import validation and repair tool when files grow past a few thousand rows or update weekly from multiple sources.
What "bulk fix" should mean
Effective bulk fixing for inventory imports means:
- See all issues in one list (not hunt cell by cell)
- Filter rows by error type, column, or SKU
- Apply one change to every matching row in the file
- Revalidate immediately and see the error count drop
- Export a clean CSV without manual copy-paste
That is exactly what Import Ready's bulk edit is for.
Bulk edit workflow in Import Ready
1. Upload and validate
Upload your CSV or Excel file and match columns. Open import preview and review validation issues.
2. Identify a repeated error
Examples that bulk edit handles well:
- Empty brand on 340 rows
- Stock quantity entered as text ("12") instead of a number
- Wrong min value copied from an old template
- Trailing spaces in SKU breaking uniqueness checks
3. Open bulk edit
From import preview, open the bulk edit panel. Choose:
- Which column to change
- A filter (e.g. only rows with a specific error, or rows where column X is empty)
- The new value or transformation to apply
4. Apply and revalidate
Apply the bulk change. Import Ready updates all matching rows in the dataset, not only visible grid rows. Save and check the issues panel — the error count should fall.
Repeat for the next error type until errors reach zero.
Bulk edit vs single-cell edit
| Situation | Use |
|---|---|
| One odd row from a supplier | Edit rows |
| Same mistake on 50+ rows | Bulk edit |
| Remove bad lines entirely | Delete rows |
| Add missing products | Add a row |
Export after bulk fixes
When validation passes, save and download Standard CSV or Shopify product CSV. Your file is ready for the next system — without another round in Excel.
Compare: spreadsheet vs Import Ready
| Excel / Sheets | Import Ready | |
|---|---|---|
| See all errors | Manual | Built-in issues panel |
| Fix off-screen rows | Risky | Bulk edit applies globally |
| Shopify-ready export | Manual column work | One-click Shopify CSV |
| Repeatable weekly process | New formulas each time | Same upload → fix → export flow |