Shopify

Your Shopify Inventory and Fulfillment Workflow, Fixed

Order numbers get retyped, labels get hand filled, and stock counts drift by Friday. Here's where those handoffs break and what's worth fixing first.

A store owner tapes shut a shipping box at a stockroom packing bench with inventory shelves behind them.

The store side looks fine. Orders come in, money lands, nobody complains. The back room is where it gets ugly: a printed packing slip on the bench, an order number typed by hand into a shipping tool, a tracking number copied back into an email, and a stock count that somebody fixes in a spreadsheet on Friday. By the next Friday the spreadsheet and the store disagree, and nobody's sure which one is right.

That's not a store problem. It's the same problem a trade shop has when a tech writes a job on paper and the office retypes it to bill it. Your Shopify inventory and fulfillment workflow is a chain of handoffs, and every handoff is somebody retyping what a system already knows.

By the end of this page you'll know which of those handoffs is costing you, and whether it's worth connecting or worth leaving alone.

From a paid order to a packed box and lower stock levels

The money's already in. Now someone has to move a physical thing.

Orders land in Shopify. Somebody reads them, walks to a shelf, and picks the items. Somebody packs the box, prints a label, and hands it to a carrier. Tracking goes out to the customer. Stock counts drop.

Five steps, three of them done by a person. That's the whole fulfillment loop, and each step passes information to the next.

An order lands in the Shopify admin and someone picks it

The notification hits, and someone opens the Shopify admin to see what sold. Two items, one customer, a shipping address in another state. Fine so far.

Then the picking starts. Most small shops print the packing slip, or write the order number and the SKUs on a scrap of paper, or just remember it. Someone walks the shelves and pulls the items.

Here's the first place a system hands information to a human and hopes for the best. The order number exists in Shopify already. The moment it gets copied onto paper, into a whiteboard column, or typed into a shipping tool by hand, there are now two versions of it, and only one of them is right.

Transposed digits on an order number send the wrong box to the wrong customer. You find out when they email you.

Someone packs the box and a shipping app prints the label

Packing is the one step that genuinely needs hands. Someone boxes the items, adds padding, tapes it shut, weighs it.

Then the label. This is where a second system enters the picture, and it almost never knows what the first one knows. Shipping apps and carrier tools ask for a name, a street address, a city, a zip, a weight, a service level. Shopify already holds most of that. Someone types it again anyway, or copies it over field by field with the order open in another tab.

An address typed from a screen is an address that can lose an apartment number. A weight guessed instead of read costs you on the carrier bill, every box, quietly.

The label prints. The box goes on the pile.

Tracking goes out and stock counts move

The carrier hands back a tracking number the moment the label prints. Somebody has to get it to the customer. Often that means copying it out of the shipping tool and pasting it into an email, or into a text, one order at a time. Paste the wrong row and a customer watches someone else's box cross the country.

Then the stock. The item left the shelf, so the count has to come down. If the order was marked fulfilled in Shopify, inventory levels drop on their own. If the picking happened off a printed list and the fulfillment got marked later, or in a batch at the end of the day, your stock count is wrong for however many hours sit in between.

Plenty of shops close the gap by hand, in a spreadsheet, after dinner.

Where the retyping happens, and what it costs you

Count the places a person types something the system already knows.

  • The order number, copied from Shopify into the shipping tool.
  • The customer's address, re-keyed or checked against the packing slip.
  • The weight and box size, entered again even though the same item ships the same way every time.
  • The tracking number, copied out of the label software and pasted into an email or a text.
  • The fulfillment, marked in Shopify after the box is already on the truck.
  • The stock count, adjusted by hand in a spreadsheet so somebody's number matches reality.

Six touches on one order. Each one is fast. None of them is free.

The cost shows up three ways. There's the time, which is real but boring. There's the error rate, which is the expensive part — a wrong tracking number means a support email, a refund request, sometimes a reshipped box. And there's the lag. Every minute between the item leaving the shelf and the count coming down in your store is a minute you could sell something you don't have.

Errors also cluster. They happen at the end of a long day, during a rush, when the person doing the packing is covering the phone too. That's exactly when you can least afford to go back and fix them.

We say the same thing to a plumbing shop that we'd say to a store owner. Nobody should retype a job to bill it. Nobody should retype an order to ship it. The job already has the address, the parts, and the hours in it. The order already has the customer, the item, and the quantity in it. Automation here means one thing: the data gets entered once and the rest of the steps read from it, including your inventory.

Why your stock count in Shopify and your spreadsheet don't agree

Two records of the same thing will always drift apart. The only question is how fast.

Here's how it goes. Shopify decrements a count the second an order is paid. Your spreadsheet doesn't know that happened, so somebody has to open it and type the new number. Most days they do. Then a return comes in and gets put back on the shelf, and the person who shelved it fixes the sheet but not the Shopify admin. A damaged unit gets tossed and nobody writes it down anywhere. A pallet arrives and gets counted into the spreadsheet on Friday, entered into the store on Monday.

None of those are mistakes exactly. They're just two systems being touched by different people at different times.

Within a week, your inventory levels in the sheet and your stock count in Shopify are telling you different things, and neither one matches what's on the shelf. Now the sheet is worse than useless, because people still trust it.

The honest fix is to pick one record as the truth and make everything else read from it. For a store, that's almost always Shopify, because it's the only system that updates the moment money changes hands. Keep the spreadsheet if you like, but as a report pulled out of the store, not as a second place people type numbers into.

What Available, Committed, and On Hand really mean once you have more than one location

Three numbers, three different jobs.

On hand is what's physically sitting at a location. If you walked in and counted, that's the number.

Committed is stock that's spoken for. A customer has ordered it, it hasn't shipped yet, so it's still on the shelf but it isn't yours to sell again.

Available is what's left to sell. On hand minus committed, minus anything you've marked as damaged or held back.

Here's where owners get tripped up. Say you keep 20 of a part in the shop and 8 at a second yard. Two online orders come in for one each, both routed to the shop.

  • Shop: 20 on hand, 2 committed, 18 available
  • Yard: 8 on hand, 0 committed, 8 available
  • Store total: 28 on hand, 2 committed, 26 available

Your storefront says 26 can be sold. But if a customer picks up locally at the yard, only 8 of those are actually reachable. The total is correct and still misleading, because availability is a per-location fact and the store shows you a sum.

That's also why a picker can find an empty shelf on a product the store swears is in stock. The inventory lives at the other address.

So when you check stock levels, check them by location, not in total. In Shopify you can filter inventory by location and see the three numbers side by side for each one. If committed sits high for days at a single location, orders are landing there and nobody is picking them, and your available count has quietly dropped on a product you could still sell from somewhere else.

Running a warehouse, a 3PL, and a storefront without double-counting stock

The same box gets counted twice when two systems both think they own it. Your warehouse shelf says twelve. The 3PL's portal says twelve. Nobody moved anything; the pallet just got recorded in both places, and now your store is selling twenty-four units of something you have twelve of.

This is the common failure in a hybrid setup. One product, three places it can ship from: your own warehouse, an outside fulfillment service, and the counter where walk-ins buy it off the rack.

A few rules keep the counts honest.

  • Each physical place gets exactly one location in Shopify. If the 3PL holds stock, it's a location, and only the 3PL's feed writes to it.
  • One system owns each location's inventory levels. If your fulfillment service updates its own numbers, stop adjusting that location by hand, even when you're sure it's wrong. Fix the source instead.
  • Transfers get recorded when the stock physically moves, not when the pallet gets ordered. Stock in a truck belongs to the location it left until it arrives.
  • The retail counter is a location too. A product sold off the shelf has to come out of that count, or the store keeps promising units the rack already gave away.

Walk-in sales are usually where this breaks. The warehouse and the 3PL both report automatically, and the counter gets written down on a pad and entered on Friday. By Friday the store has already sold it.

Overselling, split shipments, and holds are the three ways orders stall

An order that can't ship is worse than no order. The customer already paid, and now someone has to explain.

Overselling usually comes from a sync delay. Your store, your marketplace listing, and your counter all think they have the last unit. One of them sells it. The others find out minutes or hours later, and by then two customers are holding a confirmation email. Check how often each sales channel pulls stock, and look at what happens when a product is down to its last few units. Many shops set a buffer so the last unit or two never shows as available online. It costs a little revenue and saves a lot of apology.

Split shipments stall on the paperwork, not the packing. Part of the order goes out of the warehouse, the rest is on backorder or sitting at a second location. If the first shipment closes the order in your shipping tool but the second half never gets marked, the customer sees one tracking number and assumes something is lost. They call. Someone digs. Make partial fulfillment an explicit step with its own status, and make sure both halves get their own tracking.

Holds are fraud flags and bad addresses. Both are quiet. The order sits in a queue nobody opens because it isn't in the normal flow. Give held orders a daily look, the same way you'd check voicemail. Bad addresses that ship anyway come back as returns, and a return costs you twice — the outbound shipping and the inbound.

How to tell if your fulfillment workflow is actually working

Open Shopify's order list, sort by date, and look at what's still unfulfilled. How old is the oldest one? That single number tells you more than any dashboard. If orders from three days ago are still sitting there and nobody knows why, your Shopify inventory and fulfilment workflow has a hole in it.

A few more questions worth pulling from your own data:

  • How long does an order sit between paid and fulfilled? Shopify timestamps both. Pick a normal week, not your busiest, and look at the spread between the fastest and the slowest.
  • How often does a pick or a label come back wrong? Count the reship requests and the address corrections for a month. You don't need a system for this. A note on the packing bench works.
  • How often does something oversell? Every time you have to email a customer to say an item isn't actually available, that's a count that drifted.
  • How many tracking numbers went out late, or not at all? Check how many "where is my order" messages you got against how many orders shipped.

Write the answers down somewhere you'll see them again. Do it the same way next month. The point isn't the number on any single day, it's whether the gap is widening while your order volume grows. That's the signal that a person with a printer has stopped being enough.

When connecting the steps is worth it, and when it isn't

There's a volume below which a person with a printer beats any integration. One or two orders an hour, a packing bench, a label printer, a browser tab open to the store. That person is fast, they catch the odd wrong address, and they cost you nothing to set up. Buying apps to connect steps that a human handles in ten seconds just adds a thing that can break at 7am.

The math changes when the retyping stops being occasional and starts being the job. Signs you've crossed over:

  • Someone's whole morning is order numbers going into a shipping tool and tracking numbers coming back out.
  • You hired a second person mostly to keep up with packing and typing, not with anything a customer would notice.
  • Stock levels drift far enough that you're emailing customers about items you thought you had.
  • Orders sit overnight because the one person who knows the process was out.

Below that, fix the process. Above it, automation starts paying for itself in hours you stop buying.

We haven't put a hard order-per-week number on this, and we won't guess at one in public. The honest way to find yours: time one week of order handling, work out what that time costs you, and compare it against what connecting the steps would cost to build and keep running. If the build pays back inside a year, it's worth doing. If it doesn't, buy a better label printer and revisit it next quarter.

Same rule we apply to field service work. Nobody should retype a job to bill it, and nobody should retype an order to ship it — but only once the retyping is costing more than the fix.

What it looks like when the data moves once

An order number gets created once, by Shopify, when the customer pays. Nobody types it again. It travels to whatever packs and ships the order, and it comes back carrying a tracking number that lands on the order and goes out to the customer without anyone opening an email window.

The stock count works the same way. One pick, one deduction, in one place. The spreadsheet either disappears or becomes a report that reads from the store instead of arguing with it.

That's the whole shape of it. Order routing decides where each item ships from based on rules you set, not on someone remembering that the heavy stuff lives at the second location. Apps and shipping tools talk to the store directly instead of through a person with two browser tabs and a clipboard. Automation handles the handoffs between steps, which is the part people are worst at and software is good at.

We build the same thing for trade shops. A technician writes job notes once, and those notes become the invoice. The invoice goes out on its own and chases itself if nobody pays. The office manager stops being the bridge between two systems that should have been talking already.

An order is a job. Ship it the same way you'd bill it.

Common questions about Shopify inventory and fulfillment

What are the steps in a fulfillment process?

Seven, in most small operations. An order comes in. Someone reviews it and confirms the stock is really there. Someone picks the items. Someone packs them. A label gets printed. The package goes out with the carrier. Tracking goes to the customer and the stock count drops. Shops with returns add an eighth step, and shops with a 3PL hand off steps three through six. The steps don't change much as you grow. What changes is how many of them a person has to type.

Does Shopify have inventory management built in?

Yes. You can track quantities per variant, set up multiple locations, see Available and Committed and On Hand, and let the store stop selling an item when it hits zero. For a single location and a manageable order count, that's enough. The gaps show up when stock lives in more than one place, when a 3PL holds some of it, or when you're also selling somewhere Shopify doesn't see. That's when inventory starts living in a spreadsheet, and the spreadsheet starts drifting.

At what order volume is an integration worth building?

Below a certain point, a person with a printer beats any integration you could buy. Count the minutes your packing step actually takes in a normal week, then count how many of those minutes are retyping. If retyping is a small slice, leave it alone. If it's most of the work, and the volume is still climbing, connecting the steps pays for itself. We'd rather tell you to wait than sell you something you don't need yet.

If you want a second opinion on which of your steps should be connected, book a New Project Consultation.

More onshopifytradesfield service software

Chris Hobbick

About the author

Chris Hobbick

I build and fix websites, Shopify stores and business software. I work directly with business owners to understand the problem and agree on the work and price.

Meet Chris →

The Newsletter

One useful idea. Once a week.

Practical notes on websites, online stores and the daily work software can help with.

Unsubscribe whenever you want.