Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Website (website)
• eCommerce (website_sale) • Invoicing (account) • Discuss (mail) |
Lines of code | 891 |
Technical Name |
import_product_or_pricelist |
License | LGPL-3 |
Website | https://www.onoo.com.cn |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Website (website)
• eCommerce (website_sale) • Invoicing (account) • Discuss (mail) |
Lines of code | 891 |
Technical Name |
import_product_or_pricelist |
License | LGPL-3 |
Website | https://www.onoo.com.cn |
Product Information Import Super Tool
1.Import product variants
2.Import product pricelist(USD,CNY)
Support language:English,Chinese,Japanese


The import screens


The excel import template


The features of import variants
Product Name | Have double check in excel |
Can be Sold | True or False |
Can be Purchased | True or False |
Product Type | Choose one of [product,service,consu] |
Category | will create it if not exist in system |
Unit of measurment | language Name of it must exist in system model uom.uom |
Purchase unit of Measure | language Name of it must exist in system model uom.uom |
Customer Taxes | language Name of type sale must exist in system model account.tax |
Vendor Taxes | language Name of type purchase must exist in system model account.tax |
Description for customer | anything |
Invoicing Policy | order or delivery |
Sales Price | float value |
Cost | float value |
Variant Attributes | Separate multiple values with a comma |
Attribute Values | Separate multiple values with a comma |
Internal reference | Empty |
Barcode | Empty |
Weight | float value |
Volume | float value |
Qty On Hand | float value |
Image path/url | the full path in odoo server;it also display in variants |
Media Images path/url | the full path in odoo server;separate multiple values with a comma |
Reset Media Images? | True or empty;if True,will update Media images in update mode |
Reset Attributes? | True or empty;if True,will update variants in update mode |

The features of import no variants

Product Name | Have double check in excel |
Can be Sold | True or False |
Can be Purchased | True or False |
Product Type | Choose one of [product,service,consu] |
Category | will create it if not exist in system |
Unit of measurment | language Name of it must exist in system model uom.uom |
Purchase unit of Measure | language Name of it must exist in system model uom.uom |
Customer Taxes | language Name of type sale must exist in system model account.tax |
Vendor Taxes | language Name of type purchase must exist in system model account.tax |
Description for customer | anything |
Invoicing Policy | order or delivery |
Sales Price | float value |
Cost | float value |
Variant Attributes | Empty |
Attribute Values | Empty |
Internal reference | Have double check in both excel and system(only create mode) |
Barcode | Have double check in both excel and system(only create mode) |
Weight | float value |
Volume | float value |
Qty On Hand | float value |
Image path/url | the full path in odoo server;it also display in variants |
Media Images path/url | the full path in odoo server;separate multiple values with a comma |
Reset Media Images? | True or empty;if True,will update Media images in update mode |
Reset Attributes? | True or empty;if True,will update variants in update mode |
The features of import pricelist
Product Id | id in system model product.template |
Product barcode | the barcode in system |
Product Name | the name in system |
Category | full name of Category in system |
----- | you can use one of id,barcode,product name+category to find product |
Display website | the website name in system;if this is empty,it will set the pricelist of empty website |
Website Category | will create it if not exist in system;separate multiple values with a comma |
USD | add price of prodcut to usd currency pricelist in the website |
CNY | add price of prodcut to cny currency pricelist in the website |



Please log in to comment on this module