Foundation · 2 min
What you need to know
How do I migrate ecommerce products?
Export products with stable identifiers, map every required field and relationship, transform the data repeatably and import in controlled batches. Validate the live catalog rather than accepting a successful import message as proof.
How should SKUs be migrated?
Preserve each SKU exactly when it remains the business identifier used by inventory, orders and integrations. Detect duplicates, blanks and formatting changes before import because SKU changes can break reconciliation.
How should product descriptions be migrated?
Map descriptions to the correct destination fields while preserving meaningful formatting, links, and accessibility. Review samples on desktop and mobile for missing text, unsafe markup or broken layout.
How should product attributes be mapped?
Create a source-to-destination map for every attribute, including data type, allowed values, units, and whether it drives filtering or variants. Normalize values deliberately and keep an exception list for records that cannot map cleanly.
How should variants be migrated?
Preserve the parent product, option combination, SKU, price, inventory identity, media, and status for every variant. Reconcile variant counts per product and test representative option selections on the storefront.
How should product options be migrated?
Map option names and values consistently, including order, spelling and localization. Confirm that each option combination resolves to the intended variant without creating impossible or duplicate combinations.
How should product status be migrated?
Translate source states such as active, draft, archived or discontinued into explicit destination states. Prevent hidden or retired products from becoming publicly sellable during import.
How do I validate migrated product data?
Compare product and variant counts, required fields, SKUs, prices, relationships and publication states. Then sample live search, category, product-page, and add-to-cart behavior for high-risk products.
A quick store check
Trace one complex product from export through the live product page and cart. Compare every variant, required field and relationship.
Foundation · 2 min
Frequently asked questions
Should product cleanup happen inside the import file?
No. Approve cleanup rules separately, so changes are repeatable, reviewable, and distinguishable from migration errors.
Can matching product counts prove success?
No. Counts can match while SKUs, prices, variants or publication states are wrong.