Pular para o conteúdo
Esta pergunta foi sinalizada
2 Respostas
414 Visualizações
Avatar
CHIOZZA GIOVANNI

Hello,
I've a connector that transfers automatically sales order from WooCommerce to Odoo.
I would like to understand which is the best way to import the Product column content into sales order because later I have to run the sales orders into production and I need that sales orders are formatted well without any further re-coding.

For products with variants (each variant has a internal ref) the sales row receive codes like this:
[INTERNAL_REFERENCE] Product name

For products without variants but with internal reference 
[INTERNAL_REFERENCE] Product name

Is this the right way ?  Any active working experience in this topic ?

Thanks

Avatar
Cancelar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Melhor resposta

Hi,

A reliable way to handle this is to match the WooCommerce product SKU with Odoo’s default_code (internal reference). This ensures Odoo can always identify the correct product or variant automatically during order import, without relying on the product name format.

In addition, it’s good practice to add a custom field in Odoo (e.g., x_woocommerce_product_id) to store the WooCommerce product ID. This gives you a permanent, direct link to the original WooCommerce product, which is helpful for troubleshooting, syncing updates, or re-importing products later without ambiguity.

Having both SKU matching and WooCommerce product ID stored makes the sales order import flow smoother, avoids mismatches, and ensures production orders run without needing manual corrections.


Hope it helps

Avatar
Cancelar
Avatar
Jordan
Melhor resposta

Hi Giovanni,

Yes, [INTERNAL_REFERENCE] Product Name is a good format — it ensures Odoo matches the right product/variant and keeps things clear for your team. Just make sure your connector sets the correct product_id.

If you need a done-for-you solution, check out odooflow.co.

Avatar
Cancelar