"How many minutes should I set between inventory syncs?" is a question we hear often. The short answer: the right answer varies hugely by business type. Syncing every minute is not automatically safer; some stores genuinely only need to sync once a day. Cranking the frequency blindly has downsides too — a sync may fire mid-edit and unexpectedly overwrite a Google Sheet, or unnecessary processing eats into your API quota.
This article organizes guidelines for "the right sync frequency" by business type. Treat them as a starting point and fine-tune to your store's situation.
Breaking down how to decide on sync frequency
The axes for deciding frequency are actually simple. Multiply two things together — "how fast inventory changes" and "how big the risk is when it drifts" — and the direction becomes clear in most cases.
- Fast inventory change = frequent orders and shipments
- Big drift risk = overselling that turns directly into customer-support cost
- Stores high on both: lean toward higher sync frequency
- If only one is high, throttle frequency and prioritize sheet ergonomics
There's another angle people overlook: "when the sheet is being edited." If a sync fires while someone has the sheet open and is editing it, there is a risk of capturing half-written values. At a minimum, during peak editing hours (such as business hours), it's safer to either keep the frequency low or switch to manual sync while editing is in progress.
EC-only stores
Stores that have no physical location and operate solely through Shopify's online sales. This type sees inventory move almost in one direction — order to shipment — and stock only grows when new inventory comes in. They tend to work fine with relatively modest frequencies.
Small catalog (up to 500 SKUs)
For stores with 500 SKUs or fewer, syncing once or twice a day is often plenty. For example, "once each morning at 9 AM and once at 5 PM." The reason: at this scale, inventory movement usually stays in a range you can see with your eyes, and any drift is noticed quickly. Push frequency too high, and a sync firing during picking causes "wait, the count just changed from a second ago" confusion.
Large catalog (500 SKUs and up)
As the catalog grows, your sensitivity to drift drops. For stores over 1,000 SKUs, a guideline is to switch to one automatic sync every one to several hours. Sync Master lets you set scheduled runs every 2 or 4 hours and so on. It's also useful to fine-tune by season — for example, only during sales periods when orders spike, raising the frequency to every hour.
Stores with a physical location
Stores combining EC with a physical location (POS) need higher frequency by one step. If a sale in the store isn't reflected on the EC side the moment it happens, you risk overselling — "the last in-store unit was just sold but someone is still buying it on EC."
As a guideline, the ideal is to schedule automatic syncs every hour during business hours, preferably every 30 minutes. That said, if you use Shopify POS, sales on the POS are automatically deducted from Shopify inventory, so what you manage in Google Sheets is only the human-touched information: replenishment, cycle counts, incoming stock, and the like. To keep that information fresh, raising the frequency during hours when EC and the physical store run simultaneously gives you peace of mind.
Stores that also run wholesale
Stores that operate B2B wholesale on a separate channel in parallel with B2C Shopify add another layer of complexity. A single large wholesale order can drop inventory steeply. "At the moment we shipped 100 units, EC was supposed to show three left, but it was actually out of stock" is a case this type runs into.
For this type, we recommend running an immediate "manual sync" the moment you process a wholesale order, in combination with a scheduled sync every 30 to 60 minutes. Wholesale orders are less frequent than EC, so an event-driven idea — "sync right when it happens" — really works.
- 01When a wholesale order is confirmed, first deduct the inventory in the Google Sheet
- 02Visually confirm the deduction was correct in the sheet
- 03Run a manual sync to reflect it into Shopify
- 04A few minutes later, check that the EC page shows the updated inventory correctly
Making these four steps a habit, as the "proper way to process a wholesale order," significantly reduces incidents where EC and wholesale stock drift apart.
Summary: timing design matters more than frequency
Conversations about sync frequency easily devolve into "every how many minutes?" — a numbers game. But what really matters is the design of timing: "when, by whom, and for what purpose do we sync?" Think of auto-sync as the regular bus that gives you peace of mind, and manual sync as the booster you fire right after an important event. Keep that role split in mind and you won't need excessive frequency.
Start with a modest frequency and adjust as you operate. If it feels insufficient, raise it; there's no need to start at maximum frequency.