THE IMPORTMENDER FIELD GUIDE
Before you import,
check these five things.
Bulk CSV uploads can save hours — and cause expensive mistakes when a column moves or a row disappears. Here's a practical safety pass for small online stores.
01. Keep an untouched original
Export a fresh backup and keep it separate. A cleaned CSV should always be saved under a new filename, never replace the only copy.
02. Match the platform's exact template
Header names, required fields and variant rules differ between platforms and import types. Shopify product CSVs and inventory CSVs are not interchangeable. Use your platform's current sample before bulk importing.
03. Preserve product relationships
Repeated handles, rows for variants and rows for images may be intentional. Do not blindly remove duplicates or sort a sheet without understanding its structure. The free cleaner's duplicate-removal option is best used only when you understand the rows.
04. Protect identifiers
Long SKUs, UPCs and IDs may be automatically converted by spreadsheet programs. Open a CSV using explicit text columns when possible and inspect leading zeros and long identifiers before re-saving.
05. Test a tiny batch first
Upload a handful of rows to a test or development store before updating your full catalog. Review prices, image links and variants; then import the rest only when the result matches expectations.
Useful official references: Shopify's product CSV documentation, importing products, and common import issues. ImportMender is not affiliated with Shopify.
Open the free CSV cleaner ↗