LinkyFlow — autonomous agents and live business data in Excel or on the webLinkyFlow
Shopify products edited in bulk in Excel with LinkyFlow, each change listed in the pane before publishing

Bulk edit your Shopify catalog in Excel, then publish it back

LinkyFlow loads your Shopify products, variants and stock levels into a sheet — in Excel through the add-in, or in the browser in the LinkyFlow web app. You filter the rows, change the cells you mean to change, see every change listed beside its old value, and click Publish to write them to your store. Nothing reaches Shopify before that click, and Refresh reads back what Shopify holds. It never changes your store on its own: keeping a second store in step is the job of an agent (last section).

The screenshots below come from the LinkyFlow web app on a demo data set (a lighting store, Maison Lumen) and from the Excel add-in on our demo Shopify store, Alder & Pine. The web app and the add-in have the same Query panel and the same list of changes, so every step works in both.

What you need

Which table holds what

To changeLoad in WHATEdit these columns
Titles, tags, product types, statusesProductTitle, Tags, Product Type, Status
Prices and compare-at pricesProduct VariantPrice, Compare At Price
Stock at a locationInventory Levelthe available quantity

A variant's stock is not edited on Product Variant: Shopify keeps stock per location, and that is what an Inventory Level row is.

1. Load the catalog

In the Query panel, FROM is your store and WHAT is Product (or Product Variant). Under FIELDS, keep the columns you need; Add a field searches every field Shopify offers, nested ones included. Click Load.

Shopify products loaded in the LinkyFlow web app: title, status, vendor, product type and tags, 22 rows (demo data)

In Excel, the same panel sits in the LinkyFlow pane and Load writes the rows into the sheet. From the web app, Export sends the table to Excel as a workbook that stays connected, so Refresh keeps working there (Export and sync to Excel).

2. Filter down to the rows you mean to change

Filters run at Shopify, so only the matching rows come back:

  • on Product: Status, Vendor, Product Type, Tag and Tag Not, Inventory Total, Is Price Reduced;
  • on Product Variant: Sku, Product Type, Vendor, Tag, Product Status, Inventory Quantity.

Example: to reprice the pendants, load Product Variant with Product Type = Pendants and Product Status = active, and keep Display Name, Sku, Price and Compare At Price.

Save the query from its name's menu (Save as new query…): it comes back in that menu next time, and in Excel each sheet keeps its own query.

Saved Shopify queries: active catalog, low stock, prices and compare-at prices, last week's orders, unfulfilled orders (demo data)

3. Edit in the sheet

Click Edit (in Excel, Edit on the LinkyFlow tab of the ribbon). Type, paste a whole column, or compute new values in a free column and paste them into Price — =ROUND(C2*0.9,2) is 10 % off the price in C2. The Changes panel lists every edit by its record, the old value struck through beside the new one.

Three edits waiting in the Changes panel: two prices lowered and a compare-at price added, nothing sent to Shopify yet (demo data)

Three rules that save a failed publish:

  • Decimals take a dot. A price is an exact decimal: 179 or 12.90. 12,9 € is turned down where you type it, with Must be a number (use a dot for decimals: 12.9). A comma is never guessed as a decimal point.
  • An emptied cell is a value. Empty a compare-at price and publish: Shopify removes it. A Tags cell is the whole list, so keep the tags you want to keep.
  • A value Shopify would refuse is refused as you type it. The cell keeps its value and the message says what is allowed — here, a status that is not ACTIVE, ARCHIVED, DRAFT or UNLISTED.

A status Shopify does not accept, turned down with the allowed values in the message (demo data)

In Excel it is the same edit in the cells of the sheet, the same list in the LinkyFlow pane:

Products edited in Excel on the demo store Alder & Pine: a title, a product type and tags changed, five changes listed in the LinkyFlow pane before Publish

4. Stock, one location at a time

Load Inventory Level: one row per item stocked at a location — the store's primary location, or the one you pick in Location Id — with its SKU and its available quantity. Click Edit, type the new quantities, then publish.

A published quantity is set, not added: Shopify takes the number you typed. A sale made between your Load and your Publish is overwritten by that number, so load the stock right before you count or type it.

5. Publish, then check

Click Publish (on the web, the button says how many changes it sends). Then check:

  • Stock: on a publish of up to ten rows, each row comes back with the quantity Shopify now holds. A larger publish runs as one bulk operation at Shopify and is not read back row by row: Refresh shows the result.
  • Everything else: Refresh reads the rows from Shopify again. What the sheet then shows is what your store holds.
  • Changed your mind before publishing? Exit edit discards every change not yet published.

Creating products instead of editing them

New products start from the catalog template: in the pane, Create, then Load template. One row per variant; the rows that share the same Product make one product with its options and variants. Title, description, vendor, type, tags, status and image come from a product's first row; Status is draft unless you type active; Stock goes to the store's first location, or to the one named in Location.

A catalog sheet in Excel: one row per variant, the rows of each Product grouped into one product, ready to publish (demo store Alder & Pine)

Publish creates them. Each row then shows its product, or what to fix: fix those rows and publish again, and what was already created is not sent twice. Step by step: Create your catalog from Excel.

What it does not do

  • Nothing changes on its own. Every change is a cell you typed and a Publish you clicked.
  • One location per Inventory Level sheet. Quantities of several locations are never added up.
  • A load has a size. One load reads up to 2,000 rows on the Free plan, 25,000 on Starter and 100,000 on Pro.
  • Discount codes, collections and the rest are other tables. A full seasonal run — tags, sale prices, a discount code and the clean-up — is in Black Friday on Shopify, prepared in one sheet.

Keep another store in step

If the same products sell on a second store, typing the same quantities twice is what the Inventory Stock Sync agent does for you: every hour, by exact SKU, in a mode you choose. The walkthrough is Sync stock between Shopify and WooCommerce. For list prices, the Price Sync agent does the same.

FAQ

Does anything change in my store before I click Publish? No. Edits stay in the sheet and in the Changes panel until you publish; Exit edit throws them away.

Do I need Excel? No. The LinkyFlow web app loads, edits and publishes the same way, and Export gives you a connected Excel workbook whenever you want one.

Can I compute prices with Excel formulas? Yes: compute them in a free column, then paste the values into Price or Compare At Price.

How many products can I change at once? As many as one load reads on your plan (2,000 rows on Free, 25,000 on Starter, 100,000 on Pro). A large stock publish runs as one bulk operation at Shopify; Refresh shows the result.

What happens to a value Shopify would refuse? It is turned down as you type it, with the reason, and never sent.

Get started

LinkyFlow for Shopify opens on a 53-second tutorial filmed on a real store: products loaded, a price changed and published, a stock change brought back with Refresh. Install LinkyFlow from the Shopify App Store, then install the Excel add-in.