Back to Blog
ecommerce

Importing Products from Shopify to Odoo

Nikola R.2022-08-034 min read
Importing Products from Shopify to Odoo

You import products from Shopify to Odoo through the Simplify-ERP connector's bulk import feature, which pulls your entire catalog - product details, variants, pricing, images, stock levels, and categories - into Odoo in a single mapped operation instead of creating each product record by hand. This is usually the first step merchants take before connecting order and customer sync, since orders and stock movements need product records to attach to.

Why Import in Bulk Instead of Recreating Products by Hand?

Recreating a catalog of any real size by hand in a second system invites two kinds of errors: typos that create mismatches between what a product is called in Shopify versus Odoo, and the sheer time cost of re-entering variants, images, and pricing one product at a time. Bulk import treats the whole catalog as a single, mapped, repeatable operation, so the mapping rules you set up once apply consistently across every product instead of depending on whoever happens to be typing.

What Actually Gets Imported?

  • Product details
  • Variants
  • Pricing
  • Images
  • Inventory levels
  • Categories

Variants deserve particular attention here. A single Shopify product with size and color options maps to an Odoo product template with variant attributes, and getting that structure right on import matters, because it determines how the product behaves in Odoo's inventory and sales flows afterward - not just how it looks.

Why Keep the Catalog Centralized in Odoo?

  • Time Savings - Bulk imports save hours
  • Centralized Tracking - All inventory in Odoo
  • Automatic Sync - Keep data synchronized
  • Feature Access - Use Shopify product features

Once the catalog lives in Odoo, it becomes the reference point for other systems and processes - purchasing, warehouse operations, financial reporting - that were never designed to read directly from Shopify. Centralizing avoids a situation where two systems each claim to be the source of truth for the same product.

How Do You Run the Import?

  1. Connect Shopify to Odoo through the Simplify-ERP connector.
  2. Select which products to import, or import the full catalog in one pass.
  3. Map product fields (title, SKU, price, variant attributes, categories) between the two systems.
  4. Execute the bulk import.
  5. Verify the result in Odoo, checking variants and pricing against the Shopify source.

Frequently asked questions

What happens if a product already exists in Odoo under a different name?

Without a matching identifier (typically SKU), the import can create a duplicate rather than updating the existing record, which is why establishing a consistent SKU convention before importing matters.

Do product images transfer during import, or do I need to re-upload them?

Images are part of the bulk import and transfer along with product details, so re-uploading manually is not necessary for a standard import.

Can I re-run the import later to catch new products?

Yes. Product import does not have to be a one-time event - running it again picks up new products added in Shopify since the last import, provided your field mapping is still set up correctly.

What Should You Verify Before Trusting the Import?

Before relying on the imported catalog for daily operations, spot-check pricing across a sample of products (including any variant-specific pricing), confirm category assignments match what customers expect to find when browsing, and check that inventory levels reported in Odoo line up with what was actually on hand in Shopify at the time of import. Catching a mapping error here, before orders start flowing against incorrect stock levels, is far less work than untangling it afterward.

Who Should Run This Import?

Merchants launching a Shopify-Odoo integration, or those consolidating a catalog that has grown organically in Shopify without a matching Odoo record, both need this step done correctly before order and stock sync will work as expected. If you are planning a product catalog migration, talk to Simplify-ERP about mapping your variants and categories correctly from the start.

Have questions about this topic? Our experts are happy to help.

Enjoying the read?

Get articles like this in your inbox, once a month.