One of the most common migration shortcuts is exporting a product CSV from Wix and uploading it directly into Shopify. In practice, this often leads to import failures or incorrectly structured product data because Wix and Shopify use different CSV schemas.
The underlying problem is that Shopify expects its own specific product CSV structure. A raw Wix export doesn't automatically match Shopify's required columns, field names or data relationships. As a result, the Wix data needs to be reviewed, mapped and cleaned before it is imported into Shopify.
The exact Shopify product CSV structure should always be checked against Shopify's current product CSV template before starting the migration.
For example, Shopify's current product CSV format includes fields such as Inventory tracker to identify whether Shopify or another service tracks inventory, and Inventory quantity for available inventory on stores using a single inventory location.
Stores with multiple inventory locations should manage inventory quantities through Shopify's dedicated inventory CSV workflow rather than relying on the standard product CSV quantity field.
The same principle applies across the entire file: Wix fields should be mapped deliberately to Shopify's current CSV schema rather than relying on historical Shopify column names or assuming that similar-looking fields will be interpreted automatically.
Beyond column mapping, the data inside the CSV also needs to be sanitized before import.
One of the most common problems is inconsistent variant and option values. A catalog might contain the same size written as:
Although these may represent the same size internally, Shopify can treat them as separate option values. This can create inconsistent product selectors, fragmented filtering and unnecessary complexity when managing product data.
Before importing, normalize repeated option values into a single canonical format across the catalog.
The same cleanup should be applied to:
- Sizes
- Colors
- Materials
- Product types
- Vendors
- Option names
- SKUs
- Inventory values
SKU consistency also needs to be audited carefully. Shopify recommends using unique SKUs for each product variant, and duplicate SKUs can cause problems with inventory management, reporting, fulfillment systems and third-party integrations.
Vendor values should also be standardized. For example, variations such as Nike, NIKE and Nike Inc. can create inconsistent product data if they are intended to represent the same vendor.
Product images need separate validation as well. Any image URLs included in the migration file should be publicly accessible when Shopify attempts to retrieve them. Broken, inaccessible or temporary image URLs can result in products importing without their intended images.
Before running the complete migration, we recommend importing a small test batch first and validating:
- Product titles
- Handles
- SKUs
- Prices
- Inventory
- Options
- Variants
- Vendors
- Images
- Product status
Once the mapping and data structure have been confirmed, the remaining catalog can be imported using the same validated format.
File size constraints should also be considered before import. Shopify currently limits product CSV imports to 15MB per file, and customer CSV imports are also limited to 15MB per file. Larger datasets should therefore be divided into smaller CSV files and imported in controlled batches.
The important point is that CSV migration should be treated as a data transformation process, not simply an export-and-upload task. Cleaning and validating the data before import significantly reduces the risk of incorrect product structures, inventory issues and unnecessary cleanup after launch.