Skip to Content
This question has been flagged
2 Replies
1388 Views
Avatar
WMSSoft Pty Ltd Sales

Hello everyone, I am trying to import an inventory transfer by using an excel template. The aim is to import multiple transfers (internal transfers) as we have many of them. The template I have used:


Reference (name)     Source Location    Destination Location        Scheduled Date      Product     Initial Demand



When I try to import I get this eroor: 

  • current transaction is aborted, commands ignored until end of transaction block
Avatar
Discard
Avatar
manuel@git3.mx
Best Answer

For Odoo 16, you need to consider this fields.

picking_type_id
location_ids
location_dest_id
scheduled_date
move_ids/date
move_ids/demand
move_ids/name
move_ids/location_dest_id
move_ids/product_id
move_ids/location_id
move_ids/product_uom





Avatar
Discard
Avatar
Waleed Mohsen (CorTex IT Solutions)
Best Answer

I'm using the template in the below link. Hope this will help you.

https://docs.google.com/spreadsheets/d/1iX46k6hobT9vqaFwx1guxK0YOHxIUsVD/edit?usp=sharing&ouid=109717340596476029063&rtpof=true&sd=true

Avatar
Discard
Jason Dueck

Waleed,
Thanks for the help. This helped me along as the native export/import functionality seems to be more difficult than average. I did find that there were some changes from v13 to v15. Here is the list of column headers that worked for me.

External ID
Reference
Operation Type
Source Location
Destination Location
Scheduled Date
Stock Moves/Product
move_lines/name
Stock Moves/Demand
Stock Moves/UoM Stock Moves/Source Location
Stock Moves/Destination Location