• Odoo with Inventory app (stock) installed.
• Python package openpyxl installed on the Odoo server:

  pip install openpyxl

• Internal user access (base.group_user).
• If you will assign lots/serials: products must be Storable and Tracking set (Serial or Lot).

1. Upload the module to your addons path (or install from Apps if available).
2. Update Apps List → search for "Internal Transfer: Import Serials" → Install.
3. Make sure openpyxl is installed on the server.

Create an .xlsx file (one row per unit). Required headers (case-insensitive, spaces ignored):

• PRODUCT — product barcode (from the Variant)
• Lot/Serial — lot/serial name (for tracked products)

PRODUCT,Lot/Serial
1234567890123,SN-0001
1234567890123,SN-0002
9876543210987,LOT-2025-09-A
      

1. Go to Inventory → Operations → Transfers and open your Internal Transfer.
2. Click the header button Import Serials.
3. Upload your .xlsx file.
4. Choose options as needed:
   • Create Lots/Serials if Not Found Create missing lots automatically.
   • Clear existing lines Remove current move lines before import.
   • Allow Non-tracked Products Allow products with Tracking=None or Type=Consumable. (Lots are ignored.)
5. Click Import.
6. Review the generated Operations lines (move lines), then proceed with your normal flow (Reserve/Validate).

• Demand: The module increases product_uom_qty to match the number of rows imported per product.
• Serial-tracked: one line per serial with qty_done = 1.
• Lot-tracked: one line per row for simplicity. (Ask us if you prefer a single line per lot with aggregated quantity.)
• Non-tracked: lines created with qty_done = 1 per row; no lot fields set.
• Company on lots: New lots are created under the picking’s company.

• v1.0: Initial release + option to allow consumables/non-tracked products (lots ignored).