Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
templatesimporting
1 Odgovori
4163 Prikazi
Avatar
Morticia Morris

Desperate for assistance, can't even seem to buy it. We're using Enterprise Cloud V16.

Mainly using for manufacturing and inventory which is great but need to capture sales to decrement inventory. Can't use an app as we are cloud based. Tried to find someone to create csv template for best case delivery order, worse case sales order. We have tried many times and failed. Would be great if Odoo had basic template for imports available. Anyone know of anyone, hints, tips tricks. etc. This is the only thing causing us issues.

Thanks in advance.

Avatar
Opusti
TTN SOLUTION

I don't understand why importing sales orders is causing you so much difficulty, especially when odoo supports excellent Excel file importing. Furthermore, modifying an import template is not too difficult, and you can also create orders from any platform through the API.

Avatar
Yaroslav Lyusikov
Best Answer

Hi Morticia.
Find template for stock picking import below:

Operation Type/Database IDContact/Database IDSource Location/Database IDDestination Location/Database IDStock Moves/DescriptionStock Moves/DemandStock Moves/ProductStock Moves/Unit PriceStock Moves/Source Location/Database IDStock Moves/Destination Location/Database IDStock Moves/UoM
1.007.004.008.00placeholder11.002.0010.004.008.00Units
placeholder22.003.0015.004.008.00Units
placeholder33.004.0020.004.008.00Units
2.007.008.005.00placeholder2.002.0010.008.005.00Units
placeholder2.003.0015.008.005.00Units
placeholder2.004.0020.008.005.00Units
placeholder2.003.00208.005.00Units
placeholder2.004.00208.005.00Units

Pay attention, first 4 columns represent stock.picking and other columns are their stock.moves.

Actually, you can put any identifier instead of Database IDs, this is only my habit.

Pay attention that you must put partner_id (Contact) for outgoing and incoming pickings AND you always must put Stock Moves/Description in stock moves (it's mandatory)

Also pay attention to the Stock Moves/Unit Price field if you maintain automated costing method (FIFO or AVCO)

So 

  1. Replace my ids of the operation types, locations, product variant and contact.
  2. Go to the Inventory - Operations - Transfers, and import your file in this stock.picking model

  3. As a result, you will have the classic transfers in the system



    ______________________
    I hope it is not a big issue for you to match the necessary identifiers; if it is, I suggest creating another issue.


Avatar
Opusti
Morticia Morris
Avtor

Thanks really appreciate it!

Related Posts Odgovori Prikazi Aktivnost
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'
importing
Avatar
Avatar
Avatar
3
jul. 25
3376
Odoo journal entry modification after posting by import
importing
Avatar
Avatar
1
apr. 25
2528
Import mehrerer Artikel mit Varianten
importing
Avatar
0
okt. 24
1957
"harmonised" template for various use cases
templates
Avatar
0
jul. 24
2313
Importing Excel/CSV using custom unique field instead of XML ID
importing
Avatar
Avatar
Avatar
2
maj 24
5131