Hi,

Yes, you can import product records with serial numbers and quantities into Odoo using the Import feature. To import serialized products, ensure the following:

• Go to Inventory → Products → Products.
• Enable Serial Number Tracking on the product template (Tracking = "By Unique Serial Number").
• Prepare an import file (CSV or Excel) with:
  • Product
  • Lot/Serial Number (Field: Lot/Serial Number)
  • Other optional fields: Internal Reference, Category, Barcode, etc.

However, Lot/Serial Numbers are not directly created under products—they are usually recorded when receiving products in the warehouse.

Product quantities are managed via Inventory Adjustments, not directly on the product form. To import starting inventory or update stock:

• Go to Inventory → Operations → Inventory Adjustments.
• Create a new adjustment.
• Click Import and use a file with the following fields:
  • Product
  • Lot/Serial Number (if tracked)
  • Location
  • Quantity
  • UoM (optional)

This method updates On-Hand Quantity correctly in the right location and tracks the serial numbers properly.

• Use Developer Mode to see technical field names.

Hi,

Please refer to the following links:

1. https://www.cybrosys.com/blog/how-to-import-opening-stock-and-adjust-them-in-odoo-17-inventory

In this blog, it is explained in detail how to import lots and serial numbers, quantities, etc..

Hope it helps.

Hi Jose,

It seems like you want to import your opening stock.

I would suggest you to check this video