No.11
Inventory sheet design: get the first columns right and save yourself months of pain
Column layout decides whether your inventory sheet still works in three months. A three-layer design: required, helper and memo columns.
Blog
Shopify Inventory Sync
Everything about keeping Shopify inventory in sync — locations, on-hand quantities, scheduling and multi-warehouse operations, explained for the people who actually run the stock.
Page 5 of 6
- No.12
Running a connection test lets you sleep through the night
Run a connection test before writing to your live store and check the column mapping first. What it verifies, plus a pre-sync review list.
- No.13
You always notice duplicate SKUs at the worst possible moment
Duplicate SKUs grow quietly, then surface as sync errors or wrong stock. Why they happen, how to detect them, and how to stop them recurring.
- No.14
On inventory buffers: why holding back five units saves your operation
A buffer shows slightly less stock than you hold. It prevents overselling and absorbs count errors — how much to hold back, and how to sheet it.
- No.15
Physical count day: run your sheet sync this way and incidents drop
On count day, carve out time when neither the sheet nor the sync moves. Prep the day before, running the count, and resyncing afterwards.
- No.16
Seasonal Product Inventory: Think in Ramp-Up, Peak, and Tail-End Phases
Seasonal stock behaves differently by phase. Managing your sheet and tuning your sync schedule across ramp-up, peak and tail-end.
- No.17
Sharing a Sheet with Your Team: Permissions and Rules That Keep It from Breaking
A sheet everyone can edit will eventually break. Splitting permissions, protecting ranges, and writing down rules your team can rely on.
- No.18
Should Missing Rows Count as Zero Inventory? A Sync Setting You Should Think Carefully About
Should a row missing from your sheet be zeroed on Shopify, or left alone? Get it wrong and discontinued products can come back to life.
- No.19
How to Think About Deducting Unfulfilled Orders from Your Sheet Inventory
Want to subtract unfulfilled orders from sheet inventory? First understand how Shopify available and committed quantities relate.
- No.20
5 Google Sheets Functions Worth Knowing (Inventory Edition)
Five Google Sheets functions that make inventory work far lighter: ARRAYFORMULA, XLOOKUP, IMPORTRANGE, QUERY and the UNIQUE/COUNTIF combo.