Skip to main content

Can I import serial numbers from a spreadsheet or in bulk?

How to add serial numbers to SKUs and import serial numbers in bulk

Updated over 11 months ago

Importing Serial Numbers in Bulk

Quickly import serial numbers in bulk via CSV using the receive items stock import on the Imports/Exports page.
​
Your CSV should be include the following columns:

  • SKU

  • Quantity

  • Warehouse

  • Serial #

And can be formatted for multiple serials on the same SKU per row:

Or per entry in the Serial # column separated by a comma:

Adding Serials to individual SKUs

Within an Item's details page:

1. Open an item's details and scroll to the Serial / Lot Numbers panel

2. Click the "Add serial / lot #s" button, then scan, enter, or copy & paste serials directly into the field.

Receiving a Purchase Order

  1. Open a PO, and Scan an item to being receiving it.

  2. Scan, enter, or copy & paste or enter the serials directly to the Serial / Lot #s field.

Using the Receive Tab

1. Scan an items barcode to begin receiving it.
2. Edit the entry, then scan, enter, or copy & paste or enter the serials directly to the field.

Related Resources

Did this answer your question?