Skip to content

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.


Bulk Import modal on the storefront: drop zone for .xlsx, .xls or .csv up to 2 MB, Download Example File, Cancel and Add all variants to cart

  1. Upload the file(s): Buyers drag and drop one or more spreadsheet files (.xlsx, .xls or .csv, up to 2 MB and 1,000 rows each) into the bulk import modal.
  2. 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.
  3. Interactive Results Table: Displays verified active products with images, titles, SKUs, prices, and editable quantity fields.
  4. 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.

Instead of silently dumping products into the cart, the system displays a clear Results Summary Table:

  • 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.

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.

Bulk Import pop-up with one imported product and the Cancel, Add all to quote and Add all variants to cart buttons

Items added to Quote Request List message with a View Quote Request List button

Bulk Import pop-up: message that 1 SKU(s) can’t be added to a quote and will be skipped, listing the SKU


The pop-up explains every row or file it could not import, so buyers can fix the source 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.

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.

Bulk Import pop-up: 3 row(s) skipped across 1 file(s), details open with the row number and reason for each skipped row


To ensure seamless importing, uploaded files must adhere to standard CSV formatting:

  • File type: .xlsx, .xls or .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,quantity
TSHIRT-BLK-S,50
TSHIRT-BLK-M,100
TSHIRT-BLK-L,75
HOODIE-GRY-XL,20

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.