Skip to checklist

← Back to MERCEFRAME tools

MERCEFRAME / FREE FIELD GUIDE

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.

  1. Save an untouched export. Keep the original file with a date in its name. Make changes in a separate working copy.
  2. Preserve SKU identifiers as text. In Excel, import the CSV and set the SKU column to Text before loading. Check a value such as 0007 still shows its four characters. Formatting 7 after opening cannot recover the original identifier.
  3. 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.
  4. 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.
  5. 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.
  6. 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.