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

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

How to import several thousands of new products WITH their initial inventory? V8 Saas

v8 product inventory importing

4 Replies

9029 Views

michel Guénard

My company is about to buy the whole inventory from another company.

The only data that I cannot import thru an external file is - guess what! - the initial quantities for each product.

If anyone from this community could indicate a way to do this import I will thank him/her for ever!

The V7 release was just easy for that. V8 is a regression on this issue.

Mario Arias Badila

Hi,

We created a new inventory, and then imported a csv file similar to this one...

id	Inventory Reference	Inventoried Location/Database Id	Inventories/Location/Database ID	Inventories/Product/External ID	Inventories/Product Unit of Measure/External ID	Inventories/Theoretical Quantity	Inventories/Checked Quantity
__export__.stock_inventory_1	Initial Stock	12	12	product_6799	product.product_uom_unit	1	1
			12	product_6790	product.product_uom_unit	0	0
			12	product_6836	product.product_uom_unit	20	20
			12	product_6864	product.product_uom_unit	20	20
			12	product_6873	product.product_uom_unit	1	1

After importing the file, we had to go into the database and change the "state" of the inventory to "confirm", as rows didn't show up otherwise...

We used the "XML ID" to reference the different products and other items, as this is the easiest way to go...

Hope this helps you.

Malia

I'm missing normal fields in order to import product quantity for adjustment. Could you help me?

Martin Wasala

I did it a similar way for my initial import but it did not work.
Here some details about my way:

1.Imported products into product.product and product template with pictures and variations via API and xmlrpc from a csv, which worked fine. I put our internal unique code into the field "default_code" (I guess, like you did)

2.Stock Import: I added my own field to stock_location "x_location" because our coding of shelves is varchar so I cannot use xpos,ypos,zpos

3.Now, I have a second csv file which has: default_code;warehouse_id;x_location;quantity

4.For each product.product I do: SELECT id,default_code,name_template FROM product_product WHERE default_code='CODE FROM ACTUAL CSV ROW'

5.I write by API xmlrpc into stock.location the following fields: comment>'Initialimport', company_id>5, usage>'internal', x_location>'MYOLDLOCATION'

6.I write into stock.move
     'product_uos_qty' =>new xmlrpcval($value['product_uos_qty'], "string") ,
   'product_uom_qty' =>new xmlrpcval($value['product_uos_qty'], "string") ,
     'warehouse_id' =>new xmlrpcval($value['warehouse_id'], "string"),
     'state' =>new xmlrpcval('done', "string"),
     'name' =>new xmlrpcval($value['name'], "string"),
     'product_id' =>new xmlrpcval($row['id'], "string"),
     'product_uom' =>new xmlrpcval(1, "string"),
     'location_id' =>new xmlrpcval($lid_from, "string"),
     'origin' =>new xmlrpcval('Initialimport', "string"),
     'location_dest_id' =>new xmlrpcval($rowp['id'], "string")

I don´t see any stock on the products view.
What is missing?

Did you manage it for you?

Thanks Martin

michel Guénard

Author

Hi Martin No I haven't yet solved this issue. Below is the guideline given by an Odoo Support's consultant: ....................................... ........................................Just make a new inventory adjustment manually or by importing it. To do that: 1. Create a new inventory for all products (Warehouse>>Inventory adjustments menu) 2. Start it 3. In the list view, select your newly created inventory 4. More -> Export : Select only the field "Inventories" and the sub-fields useful (for instance Checked quantities and product). 5. In the CSV file, modify the quantities 6. Import your new inventory 7. Check your inventory on the form view and, if everything is ok, validate it. The process was not successfull because I had difficulties in mapping the correct stock location that is requested for an import I will resume this process as soon as possible; I will let you informed

michel Guénard

Author

I will do as follows:

first create the product into the database with all the necessary attributes - including an internal sequential reference allowing to easily identify them after the import.

Exporting these newly created product to obtain their id AND their internal reference.

Mapping (spreadsheet) the exported lines with the initial file used to create the products; this file contains both the internal reference for mapping and all the necessary fields for an importation of STOCK MOVES (MENU WAREHOUSE>>MOVES>>IMPORT.

The fields that seem necessary for an importation of a move are:

date	location_dest_id/id	location_id/id (source)	product_uom
Can someones confirm that this protocol will generate the initial inventory that I need?

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
How to increase batch image upload size while importing products ? product importing	1 Apr 25	1313
Issue with Return Location in Transfer product inventory	1 Mar 25	2922
Product Import error product importing	2 Aug 24	3573
How to cancel a completed receipt and delete related products Solved product inventory	1 Feb 25	4421
product name not changed for all users Solved product inventory	2 Feb 25	2848

This question has been flagged

Enjoying the discussion? Don't just read, join in!