Bulk import of serial numbers in CSV or XLS file into outgoing picking (Delivery Orders) – Odoo 11.0

Below technique is used on Odoo 11.0 community edition but should work on all versions.

First, we need to make sure that the item we need to put on the delivery order is in stock with serial numbers and everything. Also, don’t forget to click on Check Availability to insure the serials numbers are populated and reserved from stock. Then we head to the Inventory menu, then select Delivery Orders sub-menu, and select the delivery order under Ready status and then export from the Action menu.

We need to choose the below fields to export:

  • Reference
  • Stock Moves/Description
  • Stock Moves/ID
  • Stock Moves/Destination Location/ID
  • Stock Moves/Lots/Lot
  • Stock Moves/Lots/ID
  • Stock Moves/Lots/Lot/Serial Number
  • Stock Moves/Lots/Done
  • Stock Moves/Lots/Unit of Measure

Creating a file similar to the below sample file:

We will delete the rows that has no serial number and work on the ones who has, creating a one similar to the below file, copying the ids and replacing the QTY Done from 0 to 1:

No, we head again to Inventory menu, then select Delivery Orders sub-menu, and select Import.

This should work just fine.

Tags: , ,

Leave a Reply

You must be logged in to post a comment.