Skip to main content
Master Data · Odoo 19

How to Prepare Master Data Before Migrating to Odoo: SKUs, Variants, Stock and Logistics

A practical guide to getting your data import-ready before moving to Odoo, so you avoid problems with catalog, stock, purchasing and carriers.

How to prepare master data before migrating to Odoo: SKUs, variants, stock and logistics

Master data is the foundation of any implementation. If the catalog goes in wrong, everything downstream suffers: stock, purchasing, marketplace listings, labels, invoices and reporting.

Key idea: a profitable integration isn't measured just by connecting an API. It's measured by how much manual work it removes, how many errors it prevents, and how much traceability it leaves inside the operational flow.

Product and variant

Every product needs a clear SKU and a consistent variant logic.

Keep trade name, internal reference, EAN or GTIN, brand, category and attributes as separate fields.

Logistics data

Weight, dimensions, packaging type and units per package look like secondary fields, until you actually need to print labels.

If they're missing, the warehouse falls back to manual work.

Initial stock and locations

A single total quantity isn't enough. You need to know where the stock actually sits, and how much of it is available, reserved or on order.

In a multichannel setup, this is critical to avoid selling more than you actually have.

Minimum template

  • SKU
  • Name
  • Variant
  • EAN or GTIN
  • Cost
  • RRP
  • Tax
  • Weight
  • Dimensions
  • Supplier
  • Lead time
  • Initial stock

Useful links within FlexigoTech

Odoo 19 MigrationContinue reading on FlexigoTechEcommerce implementationContinue reading on FlexigoTech

Frequently asked questions

Can I import products without an EAN?

Yes, but some marketplaces or logistics processes may require external identifiers.

What about duplicate SKUs?

They need to be resolved before migrating, since duplicates break mappings and syncs.

Should I import historical data?

It depends. In most cases you import the master data and current balances, and keep the historical records available for reference elsewhere.

Who should review the template?

Warehouse, sales, admin and the technical team, because each area catches different kinds of errors.

What we do about this

Custom integrationsWhat it does, screenshots, versions and price.

More related guides

What the Import Carriers button in Temu Connector for Odoo doesCommon mistakes migrating to Odoo 19 and how to avoid them before go-liveWhat the “Refresh Logistics” button in Temu Connector for Odoo doesThe message «Set a product template before loading lines.» in Temu Connector for OdooThe Select a product template or product variants message in Temu Connector for OdooHow to propose a Temu base price from OdooThe notice Product variants pushed successfully in Shopify ConnectorThe regionId error in the Temu logistics companies query in OdooThe Odoo error “Temu did not return any logistics company for regionId …”

Want us to review your case?

We'll look at your channels, stock, carriers and Odoo version to propose the cleanest path forward.

Talk to an engineer