The SKU Order block lets your wholesale buyers build an entire order from a list of SKUs and quantities. Instead of searching for each product and adding it line by line, buyers paste rows from Excel, Google Sheets or a CSV, or upload the file itself. The app matches each SKU to a product, checks the quantities, and adds the whole order to the cart in one click.
This is useful for buyers who manage their stock in an ERP or spreadsheet and reorder by SKU. They can export a reorder list from their own system and drop it straight into your store without reformatting it.
This feature is available on the Professional and Enterprise plans of your WSH Order Form, ReOrder & RFQ app.
Before you start
- WSH Order Form is installed on your store.
- The products you want buyers to order this way have SKUs set on their variants in Shopify. The block matches on SKU, so products without one cannot be found.
- Your theme supports app blocks (an Online Store 2.0 theme). The block is placed through the Shopify theme editor.
Step 1: Open the SKU Order page and check availability
- In your Shopify admin, open WSH Order Form.
- Go to SKU Order.
- In the Availability section, check that the status shows Enabled.
The SKU Order block is always available to add in the theme editor. The availability switch controls whether a placed block actually shows on your storefront:
- Enabled: the block renders afor buyers wherever you placed it.
- Disabled: the block stays in your theme but shows nothing to buyers. Use Disable block to hide it temporarily without removing it from your theme.
Step 2: Add the block to your storefront
All of these steps happen in the Shopify theme editor.
1. Add the block to your theme
Click Add block to your theme. This opens the theme editor with the SKU Order block ready to place. If you would rather do it yourself, click Open theme editor and follow steps 2 to 4.
2. Choose the page buyers will order from
In the theme editor, pick the page or template where you want the block. Common choices are:
- A dedicated bulk order page
- The cart page
- A product page
You can place the block on more than one page.
3. Drop the block onto the page
Go to Add section > Apps > SKU Order. Shopify places the block as soon as you select it.
4. Save
Click Save in the theme editor. The block is now live on that page.
Note: To use a dedicated bulk order page, first create a page in Online Store > Pages, then select it (or its template) in the theme editor before adding the block.
How buyers use the SKU Order block
Option A: Paste rows
- Copy SKUs and quantities from a spreadsheet, email or internal sheet.
- Paste them into the box, one product per row, with the SKU first and the quantity second. For example: ABC-123, 6
- Click Parse & Review.
If the buyer's list has the quantity before the SKU, they can tick Columns are [Qty][SKU] before clicking Parse & Review.
Option B: Upload a file
- Click Download template to get a file in the right format (optional, but recommended the first time).
- Fill in SKUs and quantities.
- Click Or upload an Excel / CSV file and choose the file.
Supported file types: (.csv, .xlsx, .xls)
Review and add to cart
After parsing, the block shows a review table so buyers can check what matched before anything goes into the cart.
| Column | What it shows |
| Line(s) | The row number(s) from the pasted list or file that this item came from. |
| SKU / UPC | The code the buyer entered. |
| Product | The product the code matched to in your store. |
| Requested | The quantity the buyer asked for. Buyers can edit it here. |
| Final Qty | The quantity that will be added to the cart after your rules and stock are applied. |
| Status | Whether the line is ready to add, was adjusted, or needs review. |
A summary next to the buttons counts how many lines are ready, adjusted and to review. When everything looks right, the buyer clicks Add All Valid Items to Cart. Clear empties the box and the table so they can start again.
Line statuses
| Status | What it means |
| Ready | The SKU matched and the requested quantity meets your rules and is in stock. It will be added as requested. |
| Adjusted | The SKU matched, but the quantity was changed to meet your minimum, maximum or increment rules, or to fit available stock. Final Qty shows the new amount. |
| To review | The line could not be added as is, for example because the SKU was not found or the product is unavailable. It is not added to the cart. |
How quantities are checked
Before anything is added to the cart, each quantity is checked against:
- Your minimum, maximum and increment (pack size) rules for the product
- Available stock
If a requested quantity does not fit, the block adjusts it and marks the line as adjusted, so buyers see the change before they add to cart.
Frequently asked questions
The block is not showing on my storefront
Check that availability is Enabled on the SKU Order page in the app, and that you saved the theme after placing the block. Also confirm you are viewing the same page or template you added it to.
A buyer says a SKU was not found
Make sure the SKU on the product variant in Shopify matches exactly what the buyer entered, including dashes and spacing. Products without a SKU cannot be matched.
Why did the quantity change after parsing?
The requested quantity did not meet your minimum, maximum or increment rules, or there was not enough stock. The Final Qty column shows what will be added.
Do wholesale prices apply to items added this way?
Yes. Items go into the regular Shopify cart, so the same pricing and discounts apply as when buyers add products one by one.
Can only logged-in or tagged wholesale buyers see the block?
The block shows to anyone who visits the page where it is placed. To keep it for wholesale buyers only, place it on a page that only they can access.
Can I hide the block without removing it from my theme?
Yes. Click Disable block on the SKU Order page in the app. The block stays in your theme but shows nothing to buyers until you enable it again.