| 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