> ## Documentation Index > Fetch the complete documentation index at: https://help.jetpack3pl.com/llms.txt > Use this file to discover all available pages before exploring further. # WRO Bulk Product Upload > Streamline WRO creation with bulk CSV uploads for large product catalogs, saving time and reducing errors when managing extensive inventory shipments.

Creating WROs with dozens or hundreds of products can be time-consuming when adding items one by one. Jetpack's bulk product upload feature lets you use a CSV template to quickly add multiple products, quantities, and lot information to your WROs.

## When to Use Bulk Upload Bulk upload is ideal for: **Large Product Lists**: WROs with many different SKUs **Complex Lot Management**: Products with varying lot numbers and expiration dates **Regular Shipments**: Recurring inventory patterns you can template **Time Efficiency**: Reducing manual data entry for extensive catalogs The bulk upload template supports up to 100 products per WRO. For larger shipments, create multiple WROs (e.g., products 1-100, 101-200, etc.). *** ## Bulk Upload Process Navigate to **Receiving > Receiving Orders** in your dashboard

Import button location in WRO creation showing Step 2 of 6 with search bar and Import button

On the WRO creation page, select your destination fulfillment center from the dropdown, optionally add your PO number, then click **Save & Continue** to proceed to Step 2 of the WRO process. Import popup dialog showing download CSV template link and drag-and-drop upload area

Instead of searching for products individually, click the **Import** button located at the far right of the search bar. CSV template spreadsheet showing columns: InventoryId, SKU, ItemName, IsLot, QuantityToSend, LotNumber, ExpirationDate

CSV template spreadsheet showing columns: InventoryId, SKU, ItemName, IsLot, QuantityToSend, LotNumber, ExpirationDate

You don't need to search for products one by one before using bulk import. The import feature replaces manual product selection entirely. In the bulk import popup, click the hyperlinked text **"Download a CSV template with your inventory to upload"**. A `.csv` file will automatically download to your computer containing your active and non-digital products. Import dialog with drag-and-drop upload area and browse button, showing 'Allowed Files: CSV'

Import dialog with drag-and-drop upload area and browse button, showing 'Allowed Files: CSV'

The downloaded CSV contains these pre-populated columns: | Column | Description | Editable | | ------------------ | -------------------------------------- | -------- | | **InventoryID** | Internal Jetpack product identifier | ❌ No | | **SKU** | Your product SKU | ❌ No | | **ItemNames** | Product display names | ❌ No | | **QuantityToSend** | Units to include in WRO | ✅ Yes | | **LotNumber** | Product lot identifier (if applicable) | ✅ Yes | | **ExpirationDate** | Product expiration (MM/DD/YYYY) | ✅ Yes | Never change the InventoryID, SKU, or ItemNames columns. Alterations will cause validation errors and prevent upload. Edit your downloaded CSV template to match the products and quantities in your shipment: | Task | Instructions | | ------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Remove Unwanted Products** |

**Delete Rows:** Remove entire rows for products not included in this WRO
**Keep Headers:** Always preserve the column header row

| | **Add Quantities** |

**QuantityToSend Column:** Enter the number of units for each product
**Required Field:** Every product row must have a quantity value
**Zero Quantities:** Delete the entire row instead of entering "0"

| | **Lot Information (When Applicable)** |

**LotNumber:** Enter the specific lot identifier from your inventory
**ExpirationDate:** Use MM/DD/YYYY format (e.g., 10/01/2024)
**Month/Year Format:** If you only have MM/YYYY, use the first day (e.g., 10/01/2024)

| | **Best Practices for CSV Editing** |

**Spreadsheet Software:** Use Excel, Google Sheets, or similar applications
**Save as CSV:** Maintain `.csv` format when saving changes
**No Extra Columns:** Don't add new columns or modify headers
**Clean Data:** Remove any extra spaces or special characters

| Return to the WRO creation page in your Jetpack dashboard. On the import popup, either drag and drop your edited CSV file onto the upload area, or click the **browse** button to select the file from your computer. Validation error display showing 'CSV could not be imported' with View All link to see detailed error list

Validation error display showing 'CSV could not be imported' with View All link to see detailed error list

Jetpack automatically validates your CSV and displays results: | Validation Check | What Happens | | ------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Automated Validation** |

**Correct Formatting:** Proper CSV structure and encoding
**Column Headers:** Exact match to required field names
**Data Integrity:** Valid product IDs and quantity formats
**File Size:** Maximum 100 products per upload

| | **Successful Validation** |

**Automatic Close:** Import window closes automatically
**Products Loaded:** Your WRO workflow populates with CSV data
**Continue Process:** Proceed with remaining WRO creation steps

| | **Validation Errors** |

**Error Display:** Detailed error messages appear
**Cannot Proceed:** Upload is blocked until issues are resolved
**View All Link:** Click to see complete error list

| *** ## Troubleshooting Common CSV Errors When validation errors occur, they will be displayed in the import window. Click the **View All** hyperlink within the error message to see a detailed list of issues. Common validation errors and how to resolve them: | Error Type | Problem | Solution | | ---------------------------- | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Column Name Issues** | Column headers don't match expected values | Ensure exact spelling and capitalization:

`InventoryID` (not `Inventory ID` or `inventoryid`)
`SKU` (not `sku` or `Sku`)
`ItemNames` (not `Item Names` or `Product Names`)
`QuantityToSend` (not `Quantity to Send` or `Qty`)
`LotNumber` (not `Lot Number` or `Lot`)
`ExpirationDate` (not `Expiration Date` or `Exp Date`)

| | **Data Modification Errors** | Pre-populated data has been changed | Revert InventoryID, SKU, and ItemNames to exactly match your Product Catalog | | **Row Limit Exceeded** | File contains more than 100 products | Split products across multiple WROs and CSV files | | **Date Format Issues** | Expiration dates in wrong format | Use MM/DD/YYYY format exclusively (e.g., 03/15/2025) | | **Missing Quantities** | Empty QuantityToSend values | Enter quantities for all products or delete rows for products not being sent | **File Won't Upload**: Ensure file is saved as `.csv` format, not Excel `.xlsx` **Special Characters**: Remove any special characters, extra spaces, or non-standard formatting **Encoding Issues**: Save CSV with UTF-8 encoding if international characters are causing problems **Large File Size**: Even with under 100 products, very long product names might cause file size issues *** ## Continuing the WRO Process After successful CSV upload, verify that all intended products are loaded with correct quantities and lot information before proceeding. Continue through the remaining WRO creation steps, including box configuration, shipping details, and final review before submission. You can still modify product information after CSV upload but before submitting the WRO. Use the standard WRO editing interface for any last-minute changes. *** ## Support and Additional Help If you encounter persistent CSV formatting errors, capture a screenshot of the error message and contact Jetpack Care via Slack. Include your WRO ID, CSV file, and error details. For immediate needs, consider using manual product entry as an alternative. *** ## Let's Dive Deeper Back to the main guide on our receiving process and how to send inventory Learn the complete WRO creation process to send your inventory Track and monitor your WROs with real-time status updates Update WRO details after creation before shipment arrives Resolve shipments that don't match WROs to avoid processing delays Prevent the seven most common WRO errors that cause delays

Questions? Contact Jetpack Care.

If you have any questions or run into issues, you can always contact Jetpack Care for help. Our team is always here to assist via Slack, phone, or email!