dadecasdev

ERP ↔ WooCommerce integration

Synchronisation between ERP and multilingual WooCommerce stores, including catalogue migration.

PythonTrytonREST APIWooCommerceopenpyxl

The problem

The shop was not one shop but several: one per language, each with its own identifiers for the same product. Without a reliable mapping between both systems, synchronising meant duplicating the catalogue.

The solution

Two-way integration between the ERP and WooCommerce, with a mapping layer resolving which ERP product corresponds to which product in each store. Before touching real data, purpose-built simulation tooling shows exactly what the migration would do.

What it includes

  • Product synchronisation and order download
  • Customer and address import
  • Independent stores per language (Spanish, French, German)
  • Mapping of different identifiers per store
  • Excel correspondence sheets generated for manual review beforehand
  • Shipping product, payment method and order status configuration
  • Diagnosis of API credentials and permissions

Outcome

Catalogue migrated without duplicates across stores in different languages, with a prior simulation phase that allowed the mappings to be reviewed and corrected before anything irreversible ran.

Working on a similar challenge?

Tell me about your project ↗