跳至內容
此問題已被標幟
2 回覆
406 瀏覽次數
頭像
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

頭像
捨棄
頭像
Cybrosys Techno Solutions Pvt.Ltd
最佳答案

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

頭像
捨棄
頭像
Jordan
最佳答案

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.

頭像
捨棄