CartDocs

Update prices and stock from a file

Export the prices and stock of every variant, change them in a spreadsheet or take your supplier's list, and import them back by SKU or barcode.

In the admin: CatalogImport and export

On this page

A prices and stock file changes only the prices, stock counts and stock rules of products you already have. It never makes new products and never touches texts or pictures. Use it after a stock count, for a supplier's new price list, or to set many stock levels at once.

The quick way: export, change, import back

  1. Open Catalog > Import and export and click the Export tab.
  2. Choose Prices and stock: "SKU, prices and stock of every variant, to change and import back."
  3. Choose the File type and click Export. The file appears on the History tab when it is ready. Click Download.
  4. Change the prices and stock in the file. Leave the variant_sku and variant_id columns as they are: they find each variant again.
  5. On the Import tab, choose Prices and stock, upload the file and click Upload and match columns. The columns are matched by themselves.
  6. Click Check the file, look at what will change, then click Import.

The on_hand column of an export is the stock at your default location.

Your own file or a supplier's file

Any file with a SKU (or barcode) column and the values to change works. Our template for Prices and stock has these columns: variant_sku, barcode, price, compare_at, currency, on_hand, location, track_inventory and allow_backorder. You only need the ones you change. What each holds is in Import file columns explained.

In Match columns:

  • Find variants by: SKU or Barcode.
  • Choose the column that is the SKU under Import as (or the Barcode when you find variants by barcode). Every row needs it to find its variant.
  • Open File settings to set the Characters and the Decimal mark if values look wrong.

Tick Save these matches for the next file like this if the same supplier file comes every month.

What each value does

  • Price and Compare at price replace the variant's prices. A compare-at price must stay above the price.
  • Currency must be your shop's currency. Leave the column out or empty to use it.
  • Stock sets the count to the number in the file. It does not add to it. The stock history shows the change as Import.
  • Stock location: leave it empty for your default location. For another location, write its code.
  • Track stock (yes / no) and Allow backorders (yes / no) switch the stock rules of the variant. See Low stock, out of stock and backorders.
  • An empty cell leaves that value as it is.

Rows that do not go in

The Check step lists every row with a problem before anything changes. Common reasons:

  • No variant has this SKU or barcode. A prices and stock file never creates products: use a products import for new ones.
  • More than one product has this barcode, so the shop cannot tell which one to update.
  • The price is not a number written with the decimal mark you chose, or has more decimals than the currency takes.
  • This currency is not the shop's currency.
  • The stock is not a whole number.
  • No stock location has this code.
  • Track stock or Allow backorders is not yes or no.

Click Download these rows, fix them and import them later. The other rows can go in now.

Updated 13 November 2026