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.
We created a new inventory, and then imported a csv file similar to this one...
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.
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?
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:
Can someones confirm that this protocol will generate the initial inventory that I need?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/22/15, 5:14 PM|
|Seen: 774 times|
|Last updated: 4/30/15, 9:55 PM|