How to Let Customers Import a Spreadsheet Order on Shopify

Illustration of a reorder.csv spreadsheet with sku and quantity columns and an Import button, connected by a dashed arrow to a cart with four lines and quantities of 40, 120, 500 and 1000, a Check out button and a green check

Updated September 2026

Wholesale and trade buyers rarely shop the way retail customers do. They already know what they want, often as a spreadsheet of SKUs and quantities, and they order the same things every few weeks. Making them search for forty products one by one is slow for them and a source of errors for you. Letting them import that spreadsheet straight into an order fixes both.

Shopify doesn't let customers upload a spreadsheet to the cart on its own, but it does have tools for faster bulk ordering. Here's what's built in, and how to add spreadsheet import with an app.

What Shopify has built in for bulk orders

Shopify B2B is available on the Basic, Grow, Advanced and Plus plans, with some advanced features, such as unlimited B2B catalogs and deposits, only on Plus. For quick ordering, the useful feature is the quick order list: a table of a product's variants on the product page, where buyers set a quantity for each variant and add them all to the cart at once. It works in Shopify's free themes from version 11.0.0, and it's available on every plan that has B2B.

That's ideal for one product with many sizes or colors, like a T-shirt in six sizes. What it doesn't do is take a list of many different products at once. For a buyer reordering thirty different SKUs, a spreadsheet is still quicker.

What a supply list is

A supply list is a saved list of the items a customer orders regularly, with the quantities they usually need. Instead of rebuilding the order each time, the buyer opens the list, adjusts a few quantities and sends the whole thing to the cart. Add spreadsheet import, and a buyer can build that list from their own purchasing system in seconds.

How to let customers import a spreadsheet with Wishlists

We build Wishlists, a wishlist and supply list app for Shopify. Alongside wishlists and gift registries, it has B2B tools: CSV import and wholesale order forms. Here's how import works:

Importing a spreadsheet order with Wishlists in four steps: the buyer saves a CSV with sku and quantity columns, clicks Import on their wishlist page, the app matches the SKUs to your catalog and adds them to the list, and the buyer adds the list to the cart and checks out SPREADSHEET TO CART 01 · SAVE A CSV Two columns: sku, quantity sku,quantity ABC-123,1 DEF-456,5 02 · IMPORT On their wishlist page The buyer clicks Import and picks the file Import 03 · MATCH SKUs become list items Matched against your catalog, added to the active list × 1 × 5 04 · ORDER Add to cart, check out Review quantities first. The list stays saved for the next reorder.
From a buyer's spreadsheet to a checkout in four steps.
  1. Turn it on. In the app, go to Wishlist → B2B, switch on CSV import (and order forms, if you want them), and click Save. These B2B features are on one of the app's paid plans.
  2. The buyer prepares a CSV with two columns, sku and quantity, one product per row.
  3. They click Import on their wishlist page and choose the file.
  4. The app matches the SKUs against your catalog and adds those products, with quantities, to their active list.
  5. They review the list, add it to the cart and check out. The list stays saved, so next month's reorder starts from it.

If your buyers prefer to type rather than upload, the app's order form shows products in rows with the name, SKU, variant options and a quantity field, a running total, and one Add to cart button for everything. You can see the full setup in the Wishlists B2B help article, and install the app from the Shopify App Store. The free plan includes unlimited wishlists.

Worth knowingImport matches on SKU, so SKUs have to be right. Give every variant a unique SKU in Shopify, send buyers a template exported from your catalog, and tell them to keep the column names exactly as sku and quantity.

Tips for smoother bulk orders

  • Clean up SKUs first. Blank or duplicate SKUs are the main reason a row won't match. Export your products to CSV from the Products page and check the SKU column for blanks and duplicates before you launch import.
  • Set minimums and pack sizes. If you sell in cases of 12, make that the rule rather than a note. Our guide to minimum and maximum order quantities on Shopify shows how.
  • Watch stock on big orders. A single import can ask for more than you have. Decide in advance whether you'll backorder, and say so; see handling backordered items.
  • Keep lists for repeat buyers. The more a customer reorders, the more a saved list saves them.

If you're setting up wholesale on Shopify and want a hand with catalogs, pricing or ordering, talk to us.