Import Product from Excel File || Import Stock Inventory from Excel File
by OMAX Informatics http://www.omaxinformatics.com$ 15.09
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Inventory Management (stock)
• Point of Sale (point_of_sale) • Purchase Management (purchase) • Discuss (mail) • Sales Management (sale) • Invoicing (account) |
Technical Name |
import_product_with_qty_on_hand |
License | AGPL-3 |
Website | http://www.omaxinformatics.com |
Versions | 8.0 9.0 10.0 16.0 15.0 17.0 11.0 12.0 |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Inventory Management (stock)
• Point of Sale (point_of_sale) • Purchase Management (purchase) • Discuss (mail) • Sales Management (sale) • Invoicing (account) |
Technical Name |
import_product_with_qty_on_hand |
License | AGPL-3 |
Website | http://www.omaxinformatics.com |
Versions | 8.0 9.0 10.0 16.0 15.0 17.0 11.0 12.0 |
Import Products/Inventory
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/omax.png?762a3f4)
Overview
This module helps to import products/inventory from excel file.
Feature
- This module allows user to import products/product variants with Quantity on hand and Image via XLS or XLSX file.
- User can Add new products/product variant in POS directly. For that user should check Available in the Point of Sale check box in wizard.
- User need to select Product variant with qty on hand option in order to import products with qty on hand.
- All Basic version of image is supported.
- Easy to install. No more configuration needed for this.
How It Works
Import Products or Product Variants with qty on hand Wizard.
Upload your file with .xls or .xlsx extension.
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/2.png?762a3f4)
Xls File
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/3.png?762a3f4)
Follow the below instruction to prepare Product File.
- First row contains Title of Columns.
- First column contains as Product Name.
- Second column contains as Internal Reference(Optional).
- Third column contains as Product List Price(Optional).
- Fourth column contains as Product Cost Price(Optional).
- Fifth column contains as Product Type(Optional).
Product Type must be from below opitions.
1. Stockable Product.
2. Consumable.
3. Service.
- Sixth column contains as Product Image with Url or File Path.(Optional).
- All Basic version of image is supported, like(.jpg,.jpeg,.png).
- Seventh column contains as POS Category.
- User define POS Category in xls file if it is not exist in system, then user have to create POS Product Category ('Point Of Sale -> Configuration -> Products -> Pos Categories -> Create') and upload again (Optional).
- Eighth column contains as Product Stock Location.
- Ninth column contains as Product Qty on Hand .
- Tenth column contains as Product Serial No.(Optional).
- Eleventh column contains as Product UOM Category(Optional).
- Twelfth column contains as Product UOM.
(when user select Product Variants with Qty on Hand then, Columns 8th to 12th used.)
Product Variants which imported from file
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/4.png?762a3f4)
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/5.png?762a3f4)
Manage Location and Quantity on hand.
Create Inventory adjustment via xls data file when, user select Product Variants with Qty on Hand.
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/new_1.png?762a3f4)
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/new_2.png?762a3f4)
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/new_3.png?762a3f4)
Products which imported from file Display in POS
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/pos_products.png?762a3f4)
Free Support
Get In Touch
![](http://apps.odoocdn.com/apps/assets/9.0/import_product_with_qty_on_hand/omax.png?762a3f4)
Our Odoo Services |
For support, query and question contact us. |
Please log in to comment on this module