Moving To Open-Source: Shopify to Zen Cart Databases

Migrate Shopify to Zen Cart is the database migration process of exporting product lists and variations from Shopify and restructuring them to match Zen Cart's relational tables.

Replatforming to Zen Cart is a popular way to gain more control over your store's hosting and configuration. Shifting your catalog from Shopify's flat data structure to Zen Cart's relational database requires matching columns to align with Zen Cart's database layout.

Zen Cart Data Mapping Rules

Map your columns to match Zen Cart's required fields:

• `products_model`: Map from the Shopify `Variant SKU` column.
• `products_name`: Map from the Shopify `Title` column.
• `products_price`: Map from `Variant Price`.
• `products_quantity`: Map from `Variant Inventory Qty`.

Executing the Migration

First, use a local browser tool to export shopify products to csv cleanly. Clean up formatting anomalies in your editor, and import the file to Zen Cart to build your store catalog.