Connectors mailing list archives
connectors@odoo-community.org
Browse archives
Import of Magento sales order fails
Reference in Odoo Magento connector in v8 (or v9) - Multiple sites
Changing core magento connector functionality for products
by
OpusVL, Peter Alabaster
Hi Community
I've got a question about reworking the Odoo-Magento connector for a specific use case.
Our client has a set up in Magento where they have multiple duplicated products with different SKUs (or Lots) - with the only differences being price and delivery date.
We are importing their products via a csv initially with a script to create a more logical separated set of products. Our data sets as it currently stands are in this format:
Magento --> Product Variant A with SKU 1,
--> Product Variant A with SKU 2,
--> Product Variant A with SKU 3,
--> Product Variant B with SKU 1,
--> Product Variant B with SKU 2,
Odoo --> Product Variant A (product.product)
|--> SKU 1 (stock.production.lot)
|--> SKU 2 (stock.production.lot)
|--> SKU 3 (stock.production.lot)
--> Product Variant B (product.product)
|--> SKU 1 (stock.production.lot)
|--> SKU 2 (stock.production.lot)
This essentially means that the product 'binding' is done at the SKU level.
All 'product' defined attributes could be pushed up to the product, with the price and delivery date being written to the SKU record.
We need to bind the SKUs in Odoo to the products in Magento (maybe with the use of a Magento binding table like on product.product) so that when we synchronize their sales orders - the product from 'product_id' in stock.production.lot is used on the order line, with the bound lot id also being selected on the order line (We would extend sale.order.line to include a lot id field)
How easy would you say this is to accomplish using the Odoo-Magento connector?
Could you give any pointers as to what we would need to change to get this working?
Many thanks in advance for your help.
Regards,
Peter
I've got a question about reworking the Odoo-Magento connector for a specific use case.
Our client has a set up in Magento where they have multiple duplicated products with different SKUs (or Lots) - with the only differences being price and delivery date.
We are importing their products via a csv initially with a script to create a more logical separated set of products. Our data sets as it currently stands are in this format:
Magento --> Product Variant A with SKU 1,
--> Product Variant A with SKU 2,
--> Product Variant A with SKU 3,
--> Product Variant B with SKU 1,
--> Product Variant B with SKU 2,
Odoo --> Product Variant A (product.product)
|--> SKU 1 (stock.production.lot)
|--> SKU 2 (stock.production.lot)
|--> SKU 3 (stock.production.lot)
--> Product Variant B (product.product)
|--> SKU 1 (stock.production.lot)
|--> SKU 2 (stock.production.lot)
This essentially means that the product 'binding' is done at the SKU level.
All 'product' defined attributes could be pushed up to the product, with the price and delivery date being written to the SKU record.
We need to bind the SKUs in Odoo to the products in Magento (maybe with the use of a Magento binding table like on product.product) so that when we synchronize their sales orders - the product from 'product_id' in stock.production.lot is used on the order line, with the bound lot id also being selected on the order line (We would extend sale.order.line to include a lot id field)
How easy would you say this is to accomplish using the Odoo-Magento connector?
Could you give any pointers as to what we would need to change to get this working?
Many thanks in advance for your help.
Regards,
Peter
-- Peter Alabaster Software Developer OpusVL