# CSV stock import and export

Rack Scanner · Inventory counts · Updated October 10, 2026

> Update stock for a whole location from a two-column CSV file, or download current stock to edit and upload back. Files are processed in the background.

**Stock CSV** in the Shopify app updates or downloads stock for one location at a time. It’s included on every plan; your plan sets how many rows one import can have.

## Step 1: Choose a location

At the top of **Stock CSV**, choose the location under **1. Choose a location**. Imports and exports only touch that location.

If your store has more locations than your plan includes, the page lists the ones that aren’t included. Your default location is always included. See [Plans, free trial and billing](https://help.fleekapps.com/rack-scanner/plans-and-billing/).

## Import stock

The **2a. Import stock** card sets the available quantity at the chosen location.

1. Prepare a CSV file with two columns. Click **Download template** for a starting file:

   ```
   sku_or_barcode,stock
   TEE-ORG-M,24
   0036000291452,12
   ```

2. Drop the file on the card, or click it to browse.
3. Click **Upload & update stock**.

The import runs in the background and appears under **History** with its progress.

### File format

- **First row:** the column names. Rack Scanner looks for an identifier column named `sku_or_barcode`, `sku/barcode`, `sku`, `barcode`, `identifier` or `code`, and a quantity column named `stock`, `quantity`, `qty` or `available`.
- **Separators:** commas, semicolons or tabs all work, so files saved from spreadsheet apps in most regions are fine.
- **Other columns** are ignored, and blank lines are skipped.
- **Quantities** must be whole numbers.

### How rows are matched

Each identifier is matched the same way as a scan: barcode first, then the UPC or EAN equivalents of that barcode, then SKU. SKUs aren’t case-sensitive. See [Barcodes and scanning tips](https://help.fleekapps.com/rack-scanner/barcodes-and-scanning/).

### What gets updated

- Rows whose stock already matches Shopify are skipped and counted as *unchanged*.
- Other rows set Shopify’s available quantity to the number in the file, replacing what’s there.
- Rows that can’t be applied go into a **Problem report**.

> **Important:** An import overwrites stock at that location. Unlike a count from the mobile app, it doesn’t check whether stock changed since you prepared the file. Export, edit and import close together.

### Problem report

When an import finishes, **History** shows the result, such as *120 updated · 30 unchanged · 2 problems*. Click **Problem report** to download the rows that weren’t applied, with the row number and the reason:

| Problem | What to do |
|---|---|
| No product with this SKU or barcode | Check the identifier, or add the barcode or SKU to the product in Shopify |
| Stock must be a whole number | Fix the quantity in that row |
| Product is not stocked at this location | Stock the product at this location in Shopify first |
| Shopify rejected the update | The message shows Shopify’s reason |

If a file has more rows than your plan allows, the upload is refused with a message. Split the file or upgrade.

## Export stock

The **2b. Export stock** card downloads current available stock at the chosen location.

1. Click **Export stock CSV**.
2. When the export shows *Completed* under **History**, click **Download**.

The file uses the same columns as the import template, plus **barcode** and **product** name. Edit the stock column and upload it back. Products without a SKU or barcode aren’t included.

## History

**History** lists your last 30 imports and exports, with the location, status (*Queued*, *Processing*, *Completed* or *Failed*) and result. The page refreshes on its own while a file is processing. Stock files are deleted after 30 days, so download anything you want to keep.

## Related

- [Count stock](https://help.fleekapps.com/rack-scanner/count-stock/) — count with the phone instead of a file.
- [Count sessions and reports](https://help.fleekapps.com/rack-scanner/count-sessions-and-reports/)

---
Source: https://help.fleekapps.com/rack-scanner/csv-import-export/