Shopify Wholesale Order Management: Importing Your Store Orders Straight Into Open Pantry

Plenty of Australian food producers run a Shopify store alongside their wholesale book. The store might sell gift boxes and pantry lines to the public, take small trade orders from cafés that found you online, or both. Meanwhile the real volume comes through your wholesale channel: restaurants, grocers and caterers ordering on price lists, cut-offs and delivery runs.

The problem is not selling on two channels. It is packing from two systems. Somebody prints the Shopify orders, somebody else prints the wholesale pick list, and the warehouse works from two piles of paper that never quite agree on stock. This guide covers how to approach Shopify wholesale order management so every order reaches the bench through one workflow, and how Open Pantry’s Shopify channel does it in practice.

Two order streams, one warehouse

Shopify is a capable storefront. Its B2B features let a merchant run business-to-business and direct-to-consumer sales from one store, or set up a separate B2B-only store, with company accounts, customer-specific catalogues and pricing (Shopify Help). For a producer selling online, that is a good front door.

But a storefront is not a warehouse workflow. A food supplier’s day is shaped by things a store does not run: the pick list for tomorrow’s delivery run, short picks and substitutions, catch-weight lines, run sheets, draft invoices and the accounting sync. When Shopify orders live in one admin and wholesale orders in another, the same problems turn up in almost every business:

• Double handling. Someone retypes Shopify orders into the wholesale system, or the warehouse picks from two separate lists.
• Stock that is sold twice. The last three cases of olive oil go to a Shopify buyer and a restaurant in the same hour, and nobody finds out until picking.
• Two delivery plans. Parcels and wholesale deliveries are planned in different places, so the delivery run is built without half the picture.

The fix is to decide where the warehouse works from and bring every order to that one place.

What the Shopify channel does

Open Pantry has an Imported Orders tool. It is the same place that emailed orders, AI-read orders and EDI purchase orders land, so the order desk reviews everything in one list. The Shopify channel adds your Shopify store as another source feeding that list.

Once a store is connected, this is what happens:

1. An order is placed in your Shopify store. Shopify sends Open Pantry a notification the moment it happens.
2. The order appears in Imported Orders with a distinct Shopify badge, and you can filter the list to show only Shopify orders.
3. Each line is matched to your Open Pantry catalogue by SKU.
4. If every line matches, the order can be processed automatically. It becomes a normal Open Pantry order with no human review, ready for picking. If any line does not match, the order waits in the review queue for your team.

Updates and cancellations made in Shopify come through the same way, so an order cancelled in your store does not stay on the pick list.

A quick word on those notifications, because they are what makes this reliable. Shopify uses webhooks: instead of another system repeatedly asking "any new orders yet?", Shopify sends a message to that system when something happens, in near real time (Shopify developer docs). Open Pantry listens for new, updated and cancelled orders. As a backstop in case a notification ever goes missing, it also re-checks the last 24 hours of orders every 15 minutes, so a missed message is caught on the next sweep rather than discovered by an unhappy customer.

The Shopify channel is part of Open Pantry’s Enterprise plan.

Connecting your store in a few minutes

Connecting is self-serve. You do not send anyone a password or an API key, and you do not wait for a developer.

In Open Pantry, go to Imported Orders → Settings → Payments tab → Your order channels, find the Shopify row and click Connect Shopify. Enter your store’s domain. You are taken to Shopify’s own approval screen, where Shopify shows you what access is being requested. Approve it and you are sent back to Open Pantry with the store connected.

Because the approval happens on Shopify’s screen, your Shopify login never passes through Open Pantry. You are granting access from inside Shopify, the same way you would for any other app.

If you ever uninstall the app from your Shopify admin, Open Pantry receives that notice, stops using the access it was given and marks the store as paused. Orders already imported stay in Open Pantry with their history intact.

Before connecting, do the preparation in the next section.

Why SKUs decide whether an order auto-processes

A SKU (stock keeping unit) is your own code for a product. In Shopify it is optional, you can use any format you like, and Shopify’s advice is that each SKU should be unique (Shopify Help). Each variant of a product, such as a 500 g jar and a 2 kg tub, can carry its own SKU (Shopify Help).

Open Pantry matches Shopify lines to your catalogue on an exact SKU match only. It does not guess from product titles and does not fuzzy-match codes that are nearly right. That is deliberate: when the order goes straight to picking with no human looking at it, a confident wrong match is worse than no match.

Two rules follow from that:

• Auto-processing is all or nothing. Every line in the order has to match a product for it to be converted automatically. If one line out of eight does not match, the whole order goes to the review queue. You never get half an order on the pick list.
• A line with no SKU can never auto-process. Custom line items added by hand in Shopify, and any product saved without a SKU, will always send the order to review.

So the setup work is SKU hygiene. A practical checklist:

1. Export your Shopify products and your Open Pantry catalogue and line them up side by side.
2. Give every Shopify variant a SKU, including the small lines everyone forgets: sample packs, gift boxes, seasonal specials.
3. Make the codes identical in both systems. "OIL-500" and "OIL500" are different SKUs. Watch spaces, dashes, leading zeros and letter case.
4. Keep SKUs unique. Two products sharing a code in Shopify is a problem for your own reporting before it is a problem for any integration.
5. Decide who owns new products, so every new Shopify SKU also exists in Open Pantry.

Orders that do stop at review are not lost. They sit in Imported Orders with the Shopify badge until someone on the order desk sorts out the line. The review queue is also the quickest way to spot a product that was added in one system and not the other.

What happens to the customer, the address and the payment

A Shopify buyer is often someone you have never dealt with before.

Which customer does the order belong to? Open Pantry first tries to match the buyer to an existing customer in your account. If it cannot do that confidently, the order is assigned to the single catch-all customer set up for that store. Open Pantry never creates a new customer account automatically from a Shopify order, so your customer list does not fill up with one-off buyers.

Where does it get delivered? The catch-all customer is for accounting and admin tidiness, not for delivery. The buyer’s real delivery address from Shopify is still attached to the order and used for routing, so the parcel or delivery goes to the person who ordered it.

What about payment? The buyer has already paid through Shopify checkout and received Shopify’s confirmation email. So for Shopify orders, Open Pantry suppresses its own order-placement email and does not attempt a card charge. The buyer is not emailed or charged twice.

On Open Pantry’s side, Shopify orders are charged at the same lower flat per-order rate as EDI orders rather than the rate for AI-read orders, because no AI reading is needed. A store still in testing is not charged for its orders. Current plan details are on the pricing page.

Where Shopify fits beside email, SMS and EDI orders

Shopify is one channel among several. Most wholesale suppliers take orders in whatever form customers prefer: emails and PDF purchase orders from restaurants, text messages from chefs at 10pm, and EDI purchase orders from larger buyers. Imported Orders is built to receive all of them in one list. Emailed and PDF orders are read by AI, WhatsApp, SMS and voicemail orders come in through a dedicated number, EDI orders arrive in a structured format, and Shopify orders arrive through the store connection.

The difference is how much interpretation each needs. An email saying "2 bx brocc, usual lemons" has to be read and matched to products, which is what AI order entry does. A Shopify order is already structured: exact products, quantities and a delivery address. That is why SKU matching is enough, and why a clean catalogue lets those orders skip review entirely.

For the warehouse, the source stops mattering. Every approved order becomes a normal Open Pantry order and joins the same pick, pack, deliver and invoice flow. If you are still working out where manual order handling is costing you time, our guide to reducing manual order entry covers the wider picture.

Getting set up

1. Tidy your SKUs first, using the checklist above.
2. Confirm your plan. The Shopify channel is on the Enterprise plan.
3. Connect the store from Imported Orders → Settings → Payments → Your order channels.
4. Watch the first week of orders in Imported Orders using the Shopify filter. Anything in review usually points to a SKU gap; fix it at the source.
5. Brief the warehouse. Shopify orders will now appear on the same pick lists as wholesale orders.

How Open Pantry helps with Shopify wholesale order management

Open Pantry brings your Shopify store orders into the same place as every other order, so Shopify wholesale order management stops being a second system. Orders arrive automatically, match to your catalogue by SKU, and go straight to picking when every line matches, with anything uncertain held for review. Emailed, texted and PDF orders land in the same Imported Orders list through AI order capture, and every approved order flows into digital pick and pack and on to automatic invoicing. One order desk, one pick list and one set of numbers, whichever channel the order came from.