Hi Odooers!
Does anyone have any experience of importing an Inventory Internal Transfer on Odoo Online v19?
I have a spreadsheet which shows the internal reference of the product, the from and to destinations and the demand qty but I cannot seem to find any matching field on import to identify the product.
Any help would be greatly appreciated!
Thanks
Jamie
This should be straightforward.
You can set the product and quantity using the following format in the column header
| Stock
Moves/Product Stock Moves/Demand |
Either you can use the internal reference
Or the internal reference plus the product name:
The product isn't a field on the transfer header, it sits on the move lines, which is why you don't see it at the top level. That's the usual snag.
Most reliable fix: create one internal transfer manually, then export it with the operation lines included, and use that file as your import template. It gives you the exact headers Odoo expects (source location, destination, product, demand qty) and shows how the lines link back to a single transfer, so you won't accidentally end up with one transfer per row.
To match your products: map your reference column to the Product field. Odoo's product lookup already searches internal reference and barcode, not just the name, so codes like FURN_001 resolve fine as long as each one is unique.
Replenishment Internal transfer and split buy is plus point of 'niyu_smart_stock' module listed free on Odoo App Store
Hello,
Yes, importing Internal Transfers is possible in Odoo Online, but the product field is usually located on the transfer line (stock move) rather than the transfer header itself.
When importing, try looking for fields such as Product, Product/External ID, or Product/Internal Reference (Default Code) depending on the import model available in your database. In many cases, using the product's Internal Reference (Default Code) is the most reliable approach.
If you're importing directly into Internal Transfers and cannot see any product-related fields, you may need to export a sample transfer first and use that file as a template to identify the correct field mappings.
Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.
Regards,
Zehntech Technologies Inc.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Hello
You didn't find the product based on internal reference while importing in odoo, right?
That's right