Sync inventory from a Google Sheet

If you track inventory in a Google Sheet, connect it once and SeaChange keeps your catalog and stock in step automatically — ideal for refill and by-weight shops that manage counts in a spreadsheet rather than a POS. Go to Store settings → Integrations and find the “Google Sheets — inventory sync” card.

1. Click Connect Google Sheets and sign in with Google (you approve access to just the one sheet you pick).
2. Choose your spreadsheet in the Google picker.
3. Add a configuration: tick one or more tabs that share the same columns, then map your columns once — a product-ID column and a quantity column are required; name, price, UPC, unit, and category are optional.
4. Choose which store location that configuration’s counts belong to, then Save.

After that, SeaChange checks your sheet about every 15 minutes and updates stock to match — set a quantity to 0 when something sells out and it stops showing to shoppers; raise it when you restock. New rows create new products automatically, and you can press Sync now on the card any time.

Multiple tabs and layouts

• Keep separate tabs (say, one per department) that all use the same column layout? Select them together in one configuration and map the columns once — it applies to every tab you tick.
• Have a tab with a different column layout? Add another configuration for it. You can add as many configurations as you need, each with its own columns and store location.
• Each tab is checked for changes on its own, so editing one tab only re-syncs that tab.

What your sheet needs

• A product-ID column — a SKU / internal code is best (a UPC/barcode also works). This is how SeaChange matches each row to a product. Keep this value stable: renaming a product means changing the NAME column, not this one.
• A quantity column — whole numbers or decimals (e.g. 9.5) for by-weight stock.
• A header row with clear column names (any rows above the header are ignored).

Your product name vs the SeaChange catalog name

When you map a name column, that becomes YOUR store’s name for the product — you can rename it in the sheet any time and it updates in SeaChange (no duplicate), as long as the product-ID column stays the same. Your name is what shoppers see on your store page and in search results. Separately, every product has a shared “SeaChange catalog name” used across the marketplace; your sheet never changes that, so your wording never affects other stores. You can see both on the product’s page under Inventory.

The sheet manages your name, quantity, price, and unit. Product photos and descriptions are managed in SeaChange (add them under Inventory) — they’re included when you export, but the sync never overwrites them.

💡 The connection is read-only — SeaChange never edits your sheet. Rows missing a product ID or a quantity are skipped and reported, not counted as zero. If the same product ID shows up in more than one synced tab, only the first is applied and the rest are noted in the sync log — keep each product on a single tab. Disconnect anytime from the same card; your inventory data stays. Prefer a one-time upload instead of a live link? Use CSV import.