Importing in Lot/Serial Numbers

Import Lot/Serial Numbers

To import in Lot/Serial numbers, create an Excel spreadsheet with your column headings for each field name you wish to import. Using Import Data, map the file location for your spreadsheet to the Filename, choose the correct worksheet if you have multiple sheets in your Excel file, name your import, then use the Columns tab in order to map each Column to its corresponding field. Keep in mind that using this import does not add lot numbers to existing inventory, it brings in new inventory with the lot numbers listed assigned to the new inventory.

In order to import in Lot/Serial numbers, go to File > Import Data > Product > Lot/Serial Number.

  • Required fields:
    • Lot/Serial Number
    • Product (ID)
    • Quantity
    • Unit Cost
    • Warehouse.

For a general guide on importing in data, please check out our docs page.

For a list of our Lot/Serial import specifications, please refer to this table.