SKSolveKit

Neither file is uploaded

Shopify · Prices + stock

Shopify Price & Stock Update

Needs two files: your Shopify products export and the supplier's CSV or XLSX. Download a safe update file — prices and stock only, nothing else touched.

Versión en español

Runs on this device

You need two files

  1. Your Shopify products export

    CSV or XLSX, exported from your store admin.

  2. The supplier's file

    Any CSV or Excel layout, read as it comes.

Your store export

Supplier price list

Preparing the local workbench: it reads both files in this tab, matches them by SKU or barcode and writes a Shopify update file for prices and stock.

Nothing is uploaded — both files are open only in this tab.

Before you import it

Exactly which columns reach your store.

The file contains

Handle · Options · Variant SKU
Identity only — Shopify matches the row by them.
Variant Price
The new price from your rules; untouched variants repeat their exported value.
Variant Inventory Qty
Only when you confirm a single inventory location.

Shopify keeps every value whose column is absent from the file, and all variants of each touched product are included so none can be dropped on import.

It never touches

  • Titles and descriptions
  • Images
  • SEO, URLs and handles
  • Collections and tags
  • Publication status
  • Products and variants: none created or deleted

Every change is reviewed on screen before a file exists.

How it decides

The method, in three steps.

  1. 01Your store export and the supplier's file are matched by SKU or barcode with configurable normalization (case, leading zeros, dashes, spaces), and the match rate is shown live before anything else happens.
  2. 02New prices come from your rules — cost × markup or cost + amount, with .95/.99 endings always rounded up so the price never falls below cost × margin, plus an optional floor.
  3. 03The update file contains only identity columns plus Variant Price (and Variant Inventory Qty when you enable stock): Shopify keeps every value whose column is not in the file, and all variants of each touched product are included so none can be dropped.

What it assumes

Said before you upload, not after.

  • 01

    Prices and file contents are processed on this device and never uploaded; supplier cost lists are confidential business data and stay that way.

  • 02

    The inventory quantity column applies to single-location stores; the stock option therefore requires an explicit confirmation, and variants without inventory tracking are skipped and listed in the report.

  • 03

    The store export should be fresh: the file copies unchanged values verbatim from it, so an old export would write back old data for untouched cells.

A real run

The weekly price list, applied in minutes

Goes in

A Shopify export (1,200 products) and the distributor's weekly Excel with 2,500 references and new costs.

Comes out

A review of 312 increases and 48 decreases, the discontinued and new-item lists, and an update CSV that changes prices and stock — and nothing else.

Same engine, different job

If this is not the one you needed.

Questions people ask

Before trusting it with a catalog.

01How does the Shopify Price & Stock Update work?

Your store export and the supplier's file are matched by SKU or barcode with configurable normalization (case, leading zeros, dashes, spaces), and the match rate is shown live before anything else happens. New prices come from your rules — cost × markup or cost + amount, with .95/.99 endings always rounded up so the price never falls below cost × margin, plus an optional floor. The update file contains only identity columns plus Variant Price (and Variant Inventory Qty when you enable stock): Shopify keeps every value whose column is not in the file, and all variants of each touched product are included so none can be dropped.

02What should I check before using the result?

Prices and file contents are processed on this device and never uploaded; supplier cost lists are confidential business data and stay that way. The inventory quantity column applies to single-location stores; the stock option therefore requires an explicit confirmation, and variants without inventory tracking are skipped and listed in the report. The store export should be fresh: the file copies unchanged values verbatim from it, so an old export would write back old data for untouched cells.

03How current is this page?

The methodology and source notes were reviewed on 2026-07-25. Editable rates and inputs should still be checked against the provider or authority linked below.

Where the rules come from

Checked against the importer's own documentation.

Reviewed

Share this tool

Referencing this tool on a website?

Copy an attribution link. It is optional and does not change free access.

Useful next stepImage CompressorCompress JPEG, PNG, or WebP images locally with adjustable quality.