CSV Upload (Bulk Import)
The CSV Upload (Bulk Import) feature empowers B2B buyers to upload spreadsheets containing product SKUs and quantities to quickly populate massive orders in seconds. It bridges the gap between buyers’ internal ERP/purchasing software and your Shopify store.
1. How the Bulk Import Flow Works
Section titled “1. How the Bulk Import Flow Works”
- Upload the file(s): Buyers drag and drop one or more spreadsheet files (
.xlsx,.xlsor.csv, up to 2 MB and 1,000 rows each) into the bulk import modal. - Batch Validation & Stock Lookup: The app checks each row, the SKUs and inventory levels in real time. Rows with a problem are skipped and listed, the other rows are kept.
- Interactive Results Table: Displays verified active products with images, titles, SKUs, prices, and editable quantity fields.
- Add to cart or to a quote: Buyers review the list and click Add all variants to cart, or Add all to quote to request a quote for the whole list. See Add all to quote.
2. Interactive Product Results Summary
Section titled “2. Interactive Product Results Summary”Instead of silently dumping products into the cart, the system displays a clear Results Summary Table:
Key Summary Features:
Section titled “Key Summary Features:”- Product Rows: Each row displays the product thumbnail, title, brand, SKU, real-time unit price, and an editable quantity input box ($\ge 1$).
- Total Variants Counter: Displays the consolidated variant count cleanly in the footer.
- Duplicate SKUs: If the same SKU appears more than once, in one file or across several files, the quantities are summed into one row.
- Smart Inventory Handling: Out-of-stock variants are left out of the cart list and listed in a Some items were removed pop-up. In-stock variants are kept.
- Skipped rows: Rows that cannot be imported are skipped without failing the rest of the import. See Error messages.
3. Add all to quote
Section titled “3. Add all to quote”When a Quick Order page has Integrated with Request for Quote ticked (see Full Setup Guide), the Bulk Import pop-up shows an Add all to quote button next to Add all variants to cart.
- Clicking it adds every imported product that matches one of your quote logics to the buyer’s Quote Request List, with the quantities from the file. Products that match no quote logic are left out, and a message lists their SKUs, for example “2 SKU(s) can’t be added to a quote and will be skipped: SKU-01, SKU-02”.
- Out-of-stock variants are added to the quote, because a quote request is not limited by stock. They are still left out of the cart.
- The button only appears when at least one imported product matches a quote logic.
- A message confirms the items were added, with a View Quote Request List button.



4. Error messages
Section titled “4. Error messages”The pop-up explains every row or file it could not import, so buyers can fix the source file.
4.1 Problems with a whole file
Section titled “4.1 Problems with a whole file”The file is not added, and a message names the file:
| Problem | What to do |
|---|---|
| The file cannot be read | Upload a valid .csv, .xlsx or .xls file. |
| The file is larger than 2 MB | Split it into smaller files. |
| The file has more than 1,000 rows | Split it into files of up to 1,000 rows. Empty rows are not counted. |
| No SKU or Quantity column | Add both columns. Use Download Example File as a guide. |
| The file has no data rows | Add at least one row below the headers. |
| More than 250 different SKUs in the import | Split the list into smaller files. |
| The file could not be checked | Try again. This happens when the store cannot be reached for a moment. |
4.2 Problems with a single row
Section titled “4.2 Problems with a single row”The row is skipped and the other rows are imported. A banner shows how many rows were skipped, for example “3 row(s) skipped across 1 file(s)”. Click Show details to see the file name, row number and reason:
- SKU is missing: the SKU cell is empty.
- Quantity must be a whole number greater than 0: the quantity is empty, zero, negative, a decimal or text.
- SKU not found: no variant in the store has this SKU.
- Product is not available: the product exists but cannot be sold to this buyer.

5. Required CSV Format
Section titled “5. Required CSV Format”To ensure seamless importing, uploaded files must adhere to standard CSV formatting:
5.1 File Rules
Section titled “5.1 File Rules”- File type:
.xlsx,.xlsor.csv, maximum 2 MB per file. For CSV, use UTF-8 encoding. - Size: up to 1,000 data rows per file (empty rows are not counted) and 250 different SKUs per import.
- Headers: one column for the SKU and one for the quantity. Headers are not case-sensitive, and common names are recognised:
- SKU column:
sku,variant sku,sku code,product sku,variant code,item sku,item code - Quantity column:
quantity,qty,amount,order qty,order quantity,qty ordered,quantity ordered
- SKU column:
5.2 Sample CSV Structure
Section titled “5.2 Sample CSV Structure”sku,quantityTSHIRT-BLK-S,50TSHIRT-BLK-M,100TSHIRT-BLK-L,75HOODIE-GRY-XL,206. Common Business Scenarios
Section titled “6. Common Business Scenarios”| Scenario | Business Outcome |
|---|---|
| Weekly Warehouse Restock | A retailer exports 200 low-stock SKUs from their POS system and uploads the file directly to Quick Order. |
| Sales Agent Field Orders | Sales agents maintain client Excel order sheets and upload them on the road in 1 click. |
| Purchase Order Reordering | Corporate buyers import purchase order spreadsheets directly to populate their cart for streamlined invoicing. |
- Create Quick Order PageBuild a Quick Order page: choose who can see it and which products it lists, set the layout, filters and search, then publish it.
- Create Universal PageShare one Quick Order link with every customer group: the universal page sends each customer to the Quick Order pages they can use.
- Custom CSS for Quick Order PagesAdd your own CSS to a Quick Order page from your theme: how to add it, which bss-qo-* class names are stable.
- FavouritesLet signed-in B2B customers save products to a personal My Favourites list from Quick Order and Reorder, and publish the Favourites page.