Workflow · Stock and products · Opening soon

Shopify vs ShipBob inventory

Compare your Shopify stock levels to ShipBob warehouse on hand by SKU. You get one row per SKU with a status and the difference.

Book a demo

Someone typed

“compare shopify inventory to shipbob on hand by sku and show every sku with a status: Agrees when they match, Shortage when shopify is lower, Missing warehouse when shipbob is zero; include the difference”

The agent read it as

compare Shopify inventory export to ShipBob warehouse on hand by SKU by sku and show every sku with a status: Agrees when they match, Shortage when shopify is lower, Missing warehouse when shipbob is zero; include the difference

What the agent built

2 steps, each one an ordinary Mammoth step you can open and change.

File

Shopify inventory export

CSV export · 12 rows

File

ShipBob warehouse on hand by SKU

CSV export · 12 rows

Join

Bring in ShipBob counts

12 of 12 paired

Step

Compare stock

Step 2

Result

Inventory status check

12 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Shopify inventory export
CSV export · 12 rows
File
ShipBob warehouse on hand by SKU
CSV export · 12 rows
Join
Bring in ShipBob counts
12 of 12 paired
Step
Compare stock
Step 2
Result
Inventory status check
12 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out, and the join paired 12 of 12 rows.

Download Shopify inventory export sample (12 rows)Shopify admin: Products > Inventory > Export
Download ShipBob warehouse on hand by SKU sample (12 rows)ShipBob dashboard: Inventory > Export inventory by SKU

What you get back

The result of that run, the rows to look at first.

Inventory status checkSample data12 rows

10 agrees1 shortage1 missing warehouse

SKU	Shopify Available	ShipBob On Hand	Difference	Status
IVY-900	8	0	8	Missing warehouse
BLD-210	9	16	-7	Shortage
AUR-100	42	42	0	Agrees
AUR-110	18	18	0	Agrees
BLD-200	31	31	0	Agrees
CRW-300	24	24	0	Agrees
DWN-400	56	56	0	Agrees
ECO-500	14	14	0	Agrees
FLS-600	27	27	0	Agrees
GLO-700	11	11	0	Agrees
HZN-800	33	33	0	Agrees
JDE-010	19	19	0	Agrees

12 rows in the result. Sample data: illustrative figures, not business results.

How do you compare Shopify inventory to ShipBob stock by SKU?

Export your Shopify inventory and your ShipBob warehouse on hand by SKU, then load both files. Match rows on SKU, compare the counts, and list every SKU with a status: Agrees, Shortage, or Missing warehouse. Show the difference for each mismatch so you can review it quickly.

How it works

How to use the Inventory status check workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Inventory status check: questions

Which exports should you use?

Use a Shopify inventory export and a ShipBob warehouse on hand by SKU export. The rows need a SKU column and a stock count column in each file.

What happens when a SKU does not match?

If the SKU is in both files, the workflow compares the counts and labels the row Agrees, Shortage, or Missing warehouse. If a SKU appears in only one file, it still shows up as a mismatch based on the rules you set.

How do you change the comparison rules?

Edit the written steps for the match and status rules. You can change which columns are compared, what counts as a mismatch, and how the status labels are assigned.