SKSolveKit

Neither file is uploaded

WooCommerce · Prices + stock

WooCommerce Price & Stock Update

Needs two files: your WooCommerce products export and the supplier's CSV or XLSX. Review price and stock changes and download a minimum update CSV for existing products only.

Versión en español

Runs on this device

You need two files

  1. Your WooCommerce 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 WooCommerce 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

ID · SKU
Identity only — used to find the row, never rewritten.
Regular price
Only for matched rows whose price your rules changed.
Stock · In stock?
Only when you confirm stock updating and the supplier covers the row.

Nothing else is emitted at all: a row that does not match an existing ID or SKU never reaches the file, so the importer cannot create or overwrite anything you did not review.

It never touches

  • Titles and descriptions
  • Images
  • SEO, URLs and handles
  • Categories and attributes
  • 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. 01A current native WooCommerce product export is matched with the supplier CSV or Excel file by SKU or product ID. Case, spaces, dashes, and leading zeros can be normalized, and the match rate appears before rules are applied.
  2. 02Price rules support cost multiplication, a fixed addition, or true target margin. Stock can copy the supplier quantity after a safety buffer and optional maximum, while a supplier zero follows the explicit zero-stock choice.
  3. 03The generated CSV contains only ID, SKU, and the fields actually changed: Regular price, Stock, and In stock?. Rows absent from the supplier file are reported but never set to zero, and new supplier references are never created.
  4. 04A separate workbook lists changes, extreme prices, disappeared references, supplier novelties, unreadable costs, and import notes before the store file is used.

What it assumes

Said before you upload, not after.

  • 01

    The store export must come from WooCommerce's native product exporter and should be fresh. The supplier file may be CSV, TSV, TXT, or Excel.

  • 02

    WooCommerce's importer must be run with Update existing products selected. Back up the store or test a small first batch on staging before a large update.

  • 03

    Variations are matched by their own ID or SKU. The tool does not change product type, parent relationships, names, descriptions, categories, attributes, images, SEO, or publication status.

  • 04

    Missing or unreadable costs are skipped rather than treated as zero. Products absent from the supplier file remain unchanged and appear only in the review report.

A real run

Apply the distributor's Monday price and stock file

Goes in

A fresh WooCommerce export with 1,800 product and variation rows plus a 2,400-row supplier workbook containing reference, cost, and quantity.

Comes out

A reviewed list of matched updates, disappeared and new references, a minimum WooCommerce CSV split into safe batches when necessary, and an Excel audit report.

Same engine, different job

If this is not the one you needed.

Questions people ask

Before trusting it with a catalog.

01Can WooCommerce update existing products by SKU from a CSV?

Yes. WooCommerce's native product importer can update existing products using ID or SKU. SolveKit keeps both identity columns in the output and emits only matched store rows, but you must select Update existing products during import.

02Will this CSV overwrite product names, images, descriptions, or SEO?

No. Those columns are deliberately absent. The update file is limited to ID, SKU, and whichever of Regular price, Stock, and In stock? you chose to change, so catalog content and publication fields are outside the operation.

03What happens to a WooCommerce product missing from the supplier CSV?

It is listed as disappeared for review and receives no update row. Absence does not prove the supplier has zero stock, so the tool never silently sets missing products to zero or unpublishes them.

04Does the tool update WooCommerce product variations safely?

Each native export row, including a variation, keeps its own ID and SKU. A matched variation is updated as that row; the tool does not convert simple and variable products or alter parent and attribute fields.

05Are supplier costs and stock uploaded to SolveKit?

No. Parsing, matching, calculations, reports, and CSV generation run in the browser tab. The files and their commercial values are not sent to SolveKit's servers.

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.