How to Sync Shopify Inventory From a Spreadsheet

For a lot of stores, the real inventory numbers don't live in Shopify. They live in a warehouse spreadsheet, a supplier's stock feed, or an export from an ERP. Shopify is just where they're supposed to end up. So every day someone exports a file, imports it, fixes the mismatches — or skips a day and the store starts overselling.

Here's how to make that sync happen automatically, on a schedule.

Part of the BulkEditly tutorial series — ▶ Watch all 15 tutorials on YouTube.

Why doing it by hand doesn't scale

Manually re-importing a stock file means someone has to remember to do it, every day, correctly. Miss a day and your stock levels are wrong. Get a column mapping wrong and you've updated the wrong field. There's no schedule, no record of what changed, and no warning when something looks off.

The fix: BulkEditly's scheduled inventory sync

BulkEditly can auto-sync your inventory from a CSV or Google Sheet on a schedule. It includes:

Column mapping with auto-detect — it figures out which column is SKU, which is quantity
A dry run so you can see what a sync would do before it does it
Live progress while a sync runs
A sync diff / changelog so you have a record of exactly what changed each run
Email alerts so you hear about problems
Pause/resume control

Scheduled inventory sync is available on the Pro plan. Every plan includes a 7-day free trial of all features.

How to set up an inventory sync with BulkEditly

Install BulkEditly from the Shopify App Store and open it from your admin.
Go to the Inventory Sync section.
Connect your source — a CSV file or a Google Sheet where your stock numbers live.
Map the columns — auto-detect handles most of it; confirm which column is the SKU and which is the quantity.
Run a dry run first to see exactly what the sync would change.
Set the schedule — how often the sync should run.
Enable it. From then on, BulkEditly keeps Shopify in sync, logs every run in the changelog, and emails you if something needs attention. Pause or resume any time.

Common scenarios

Daily warehouse sync: Your warehouse team updates a Google Sheet; Shopify follows automatically.
Supplier stock feed: A supplier provides a stock CSV; sync it on a schedule so you never sell what they're out of.
ERP export: Your ERP drops a stock file; BulkEditly picks it up and updates Shopify.

Staying safe

The dry run lets you preview a sync before trusting it, the changelog gives you a record of every change each run made, and email alerts mean you find out about issues instead of discovering them through a customer complaint. You can pause the sync at any time.

FAQ

Can Shopify sync inventory from a Google Sheet automatically? Not on its own — Shopify has no scheduled inventory sync. BulkEditly can auto-sync stock from a CSV or Google Sheet on a schedule.

How does it know which column is which? Column mapping with auto-detect identifies your SKU and quantity columns; you confirm before the sync runs.

Can I see what a sync will do before it runs? Yes — run a dry run first to preview the changes without applying them.

Do I get a record of what changed? Yes — every run is logged in a sync diff / changelog, and email alerts notify you of issues.

Can I pause the sync? Yes — pause and resume the sync whenever you need to.

Ready to keep Shopify in sync automatically? Install BulkEditly free on the Shopify App Store →