Overview
Follow this process to bulk import SKUs and quantities into Luminous using a packing slip from your supplier. This is useful when you receive a large shipment and want to update your inventory in one go.
Step 1: Create a Purchase Order
Go to Inventory in the left-hand menu.
Click Purchase Orders.
Click + New Purchase Order or open an existing one that matches your incoming shipment.
Add the relevant SKUs and quantities.
Save the purchase order (e.g., PO #Test).
Step 2: Prepare Your Import File
Use a spreadsheet with at least these two columns:
SKU
Quantity
Step 3: Create the Shipment
In the Purchase Orders tab, click into the PO you just created.
Scroll down and click Shipments > + Create Shipment.
Fill in the following fields:
Reference Number: e.g.,
POTest-Shipment1Status: Select "Shipped"
Ship Date: Choose the correct date
Destination Warehouse: Select the correct warehouse (e.g., Midtown Umbrella)
Step 4: Import Items from the Packing Slip
Click Import Items on the Shipment screen.
Upload your supplier’s file (Excel or CSV).
Make sure SKUs and quantities are mapped correctly.
If using your own format, select Supplier Packing and map columns.
Click Import, then Confirm Import.
You’ll now see the SKUs and quantities listed on the Shipment screen.
Step 5: Add Estimated Shipping Costs (Optional)
Enter freight costs (e.g.,
$1,000) and duties under Extra costs field.Click Save.
Saving the shipment does not add stock to inventory—it marks it as “in transit.”
Step 6: Receive the Shipment
Go to Inventory > Receiving Reports.
Click + Create Receiving Report.
Fill in:
Received By: Your name or warehouse staff
Received Date
Warehouse Location: Match the destination warehouse
Change Reference Type to “Shipment Reference Number.”
Paste the reference number (e.g.,
POTest-Shipment1).Click Add Shipment Items.
Items from the shipment will appear.
Step 7: Update Final Costs and Submit
Extra costs will autofill from the extra costs that have been added to shipment.
Update extra costs if actual cost has changed.
Add duties or additional landed costs.
Click Submit to finalize.
This will officially add the stock to your inventory, you can view inventory has been moved to onhand by looking at the stock page.
Step 8: Confirm Inventory is Updated
Go to Inventory > Purchase Orders, open PO #Test, and check that received quantities are updated.
Go to Inventory > Stock, filter by your warehouse or SKU to confirm items are now in stock.