Before you import a Shopify product CSV
Use these six checks on a copy of your export. They help catch data issues while your live catalogue stays untouched.
- Save an untouched export. Keep the original file with a date in its name. Make changes in a separate working copy.
- Preserve SKU identifiers as text. In Excel, import the CSV and set the SKU column to Text before loading. Check a value such as
0007still shows its four characters. Formatting7after opening cannot recover the original identifier. - Check handles and variants together. Rows for different variants can share a product handle. Review option names and values in the same row and verify that each variant still belongs to the intended product.
- Compare price changes with the source. Review empty, negative and text values. Use the format in a current Shopify export and check international prices separately if you use them.
- Read Shopify's update and overwrite rules. An omitted column and a supplied blank field can behave differently. Include any columns required by the fields you intend to update.
- Test a small representative batch first. Save as UTF-8 CSV and review Shopify's import preview. If you proceed with an import, verify the resulting products and variants before expanding the batch.
Important: this is an educational checklist, not a file validator. A missing or duplicate SKU is not always a Shopify import error. Follow the current official field requirements for your operation.