How to Import Shopify Product Tables into OpenCart Engine

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

Replatforming to OpenCart 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 OpenCart's relational database requires matching columns to align with OpenCart's database layout.

OpenCart Data Mapping Rules

Map your columns to match OpenCart's required fields:

• `model`: Map from the Shopify `Variant SKU` column.
• `name`: Map from the Shopify `Title` column.
• `price`: Map from `Variant Price`.
• `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 OpenCart to build your store catalog.