Bulk edit your Shopify catalog in a spreadsheet

Pull products into a Google Sheet. Change prices, SKUs, tags and metafields the way you change anything else in a spreadsheet. Push back — and have every row checked against your store afterwards.

Shopify's admin makes you edit one product at a time. CSV export and re-import makes you edit blind, then tells you nothing until it fails. Storesheet puts the catalog where fill-down, find-and-replace and formulas already work, and keeps a record of what it wrote.

How it works

1. Pull. Products and variants land in a sheet called Catalog, and a hidden snapshot records what the store looked like at that moment.
2. Edit. Paste a supplier column, run a formula, find and replace across three thousand rows.
3. Preview. Storesheet compares the sheet against the snapshot and shows exactly which cells it is about to write, and the value each one replaces. Nothing has been sent yet.
4. Push. Only changed cells are written. Old values are recorded first.
5. Verify. The affected products are read back from Shopify and compared to what you asked for. Each row gets a timestamp if it matched, or the exact mismatch if it did not.

Why this one

The person editing does not need a Shopify account

Your store credentials live in your Google account, never inside the spreadsheet file. Share the sheet with a supplier, a translator, a VA or a seasonal hire — they can edit rows and still cannot reach your admin. Sharing a spreadsheet is not sharing your store.

Your catalog never touches our servers, because we do not have any

Storesheet runs inside Google Apps Script, in your own Google account, and talks to Shopify directly. There is no middleman database holding your products, prices or costs.

Push, then verify — not push and hope

Writing to an API returns "OK" far more often than the data is actually correct. Storesheet re-reads every product it touched and compares field by field, so a silent failure shows up in the sheet instead of on your storefront.

Three permissions, on purpose

The current spreadsheet only, outbound requests, and the sidebar. Storesheet cannot see your other files in Drive. Read the permission screen — that is the whole list.

What you can edit

Jobs people use it for

• Run a sale across 3,000 products, then put every price back afterwards.
• Apply a supplier price list as a column of formulas.
• Fix a SKU scheme that three different people built three different ways.
• Hand title and tag translation to someone who must not have admin access.
• Fill in Google Shopping metafields before a feed goes out.
• Clean up vendor and product-type values that drifted over two years.

Pricing

If your store has 200 products or fewer, the free plan is the whole product. Not a trial, not a preview, no countdown — every feature, unlimited pushes, forever. We would rather a small shop use this properly for free than pay $9 for something they only half-need.

The limit is a size boundary, not a speed bump: above 200 products, the sheet holds the first 200 and the rest of your catalog is not pulled in. That is the honest line, because the work of managing a 3,000-product catalog is a genuinely different job from managing 150 — and it is the job worth paying for.

Agency exists because one person often runs a dozen storefronts for clients, and charging per store punishes exactly the people the spreadsheet workflow is built for.

Guides

• Your Shopify plan gives you zero staff accounts. Now what? — every way to let someone else edit your products, and what each one really costs.
• Shopify stopped letting you create custom apps. Here is what replaced it — the Dev Dashboard flow, step by step.

Setup

You create a Shopify app inside your own store and paste its Client ID and Client secret into the sidebar. Storesheet exchanges them for a 24-hour access token and refreshes it when it expires. No redirect, no callback, no account to create with us. Step-by-step instructions are on the support page.

What it does not do yet