Fulfill Orders with Lot Numbers via CSV Import

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:

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.