Hello, I'm working on the importation of products in a a CSV file. I hava almost imported all except the stock information that I don't find in the material import tool. Idea?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
4
Replies
12841
Views
below the name of columns of my CSV import file for products' inventory default_code Name list_price inventory qty Cost
Beware that Name is the second one in the list of fields proposed by the import tool
Sorry but I can't find this collumn. What is your version of openERP.
V7 online. I suggest you to create a first product with the information that fit your needs (Name, Quantity); then you export it as a test csv file; this will give you the csv format. Then your reuse the column names from the test file with your definitive file with all products.
It's exactly that I do, but none column contain the stock information and I take them all. But I find a semi-solution in importing an inventory. It works for qty_available but not for virtual_available. I hope that It will adapt the virtual_available when I will import the purchase.
Virtual quantity is the result of calculation made by the system when a new order is recorded; it can not be imported; neither be "searchable" and this last point is an "issue"
In V7 I suggest you to import the products first, then there is a form Physical Inventory under the Warehouse menu, Use this form to updating the stock. so you have to create the new inventory and export the necessary fields from the same and also export the products which you have already imported the DB. Then enter the stock details for each products in the csv file and import the same.
video reference here:
Hi,
You can refer to the shared BLOG for "import products and product stock quantity" in Odoo ERP. The blog is based on v12 and I think the same operation can follow in v10 versions also.
Thank you.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Jun 24
|
8966 | ||
|
2
May 25
|
265 | ||
|
1
May 25
|
200 | ||
|
Import from Winbooks
Solved
|
|
4
May 25
|
3677 | |
|
2
Apr 25
|
552 |
