Fulfill Orders with Lot Numbers via CSV Import

Written by Macklein Reyes | Aug 6, 2025 1:30:00 PM

Need to fulfill sales orders that use lot-numbered inventory—and do it in bulk? NetSuite makes this easy using CSV import, even when items are split across multiple lot numbers.

This guide walks through the exact steps for creating a fulfillment using a CSV file—whether your items require one lot or many.

Use Case

Use CSV Import to fulfill sales orders that contain lot-numbered inventory. Supports:

Items fulfilled with a single lot number
Items fulfilled with multiple lot numbers

Prerequisites

Make sure you meet the following before getting started:

You understand the CSV Import process in NetSuite.
Your role has permission to create Item Fulfillments and run imports.

Example Scenario

You're fulfilling Sales Order SO3615 (Internal ID: 64074) with the following items:

Item A00001: Uses multiple lot numbers
Item A00002: Uses a single lot number

Step 1: Prepare the CSV File

Include the following fields in your CSV file:

Field	Description
External ID	Unique ID that groups lines into one fulfillment
Created From	Internal ID of the Sales Order (e.g., 64074)
Date	Fulfillment date
Memo	(Optional) Any internal note or comment
Item	Item name or SKU
Order Line ID	Line ID from the sales order (use a Saved Search)
Quantity	Total quantity to fulfill
Location	Inventory location from which the item will be pulled
Lot Number	Specific lot number to use
Lot Quantity	Quantity from that specific lot

Important: If you're using multiple lots for a single item, each lot must have its own row in the CSV file - but share the same External ID.

Step 2: Create the CSV Import

Navigate to:
Setup > Import/Export > Import CSV Records
Then choose:

Import Type: Transactions
Record Type: Item Fulfillment
Action: Add (not Update)

Step 3: Map Your CSV Fields

Match each column in your CSV to the corresponding NetSuite field using the import wizard.

Double-check field names - especially:

Order Line ID
Lot Number
Lot Quantity

You can save this mapping for future re-use.

Step 4: Run the Import

Once everything’s mapped correctly, run your import.

If there are no errors, NetSuite will:

Generate an Item Fulfillment record
Assign lot numbers exactly as specified - even when split across multiple rows

Results Recap

Multiple Lot Numbers are supported for a single item
(e.g., Item A00001 fulfilled using Lot123 + Lot124)

Single Lot Number works seamlessly as well
(e.g., Item A00002 fulfilled using Lot200)

By using this method, you can efficiently fulfill complex orders - without clicking into every record manually. CSV imports save time, reduce manual errors, and give you total control over lot allocation.

View full post