No.21
The moment version history saved my inventory sheet
Bulk overwrites, blanked cells, vanished rows. Google Sheets version history turns the unexpected into the recoverable. How to use and restore it.
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 6 of 6
- No.22
From sheet to Shopify: a mental model for your flow of information
Most sync trouble comes from never deciding where the source of truth lives. Sketching inputs, outputs and direction makes operations clear.
- No.23
Sync logs as an audit trail: the moments they pay you back
Logs prove their worth after an incident: who changed what, and when. How to treat Sync Master run logs as an audit trail your team shares.
- No.24
Avoiding 'we sold it but it was out of stock' on Shopify
Overselling is the most awkward inventory failure there is. The root causes — sync lag, thin buffers, missed settings — and how to prevent them.
- No.25
Dedicated warehouse app vs. Google Sheets: which one is right?
Consolidate inventory in a dedicated warehouse app, or run it on Google Sheets? Where each fits, the hybrid approach, and how to decide.
- No.26
Data Hygiene for Shopify Stores — Clean Stores Are Strong
SKU naming, barcode uniqueness, junk product cleanup. Data hygiene sounds dull, but a monthly habit makes sync, search and reporting easier.
- No.27
Tips for Syncing Supplier Sheets 'As-Is'
Supplier sheets always have quirks: mismatched columns, different units, stray line breaks. Use an intermediate sheet, and push back gracefully.
- No.28
Inside the Inventory API — REST vs. GraphQL, in Plain Terms
Shopify inventory APIs come in REST and GraphQL flavours. It sounds like a developer topic, but the choice shows up in what users see.
- No.29
An Inventory Playbook for Small Stores
Turn inventory into a system and incidents drop even on busy days. Routines for small stores: five minutes daily, 20 minutes weekly.
- No.30
Your Pre-Flight Checklist Before Running a Full Sync
A full sync rewrites thousands of rows at once. Pre-flight checks split into sheet-side, Shopify-side, and the last look before you press go.