# CSV Upload

Use this screen to import and export files to schedule pricing updates.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/scaled-1680-/SVximage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/SVximage.png)

## Import

To import a file simply use the controls and map your data appropriately. You will also need to enter an activation date for your price changes.

<p class="callout info">The Label is optional, and is used to find your price changes once they have been uploaded; these are visible in the [Timed Pricing](https://bookstack.iconography.co.uk/books/other-reports/page/timed-pricing "Timed Pricing") report</p>

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/scaled-1680-/vaqimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/vaqimage.png)

## Export

To export prices via a CSV, use the search and filters to locate the Products and Unique Stock Records that you need to edit. You can then export

### Filters

This screen can be filtered by:

- Product Search (SKU Code/Name)
- Category
- Supplier
- Brand
- Collection
- Include Unique Stock Records (see below)

### Unique Stock Records

If checked, Unique Stock Records will be shown, and pricing may be updated.

<p class="callout info">To be shown a Unique Stock Record must be enabled for POS or Web</p>

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/scaled-1680-/QdNimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/QdNimage.png)

### Price Management File

Use this file to adjust prices on your selected Products and Unique Stock Records.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/scaled-1680-/VhTimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/VhTimage.png)

<table border="1" id="bkmrk-field-purpose-sku-sk" style="border-collapse: collapse; width: 100%; height: 385.848px;"><colgroup><col style="width: 50.053%;"></col><col style="width: 50.053%;"></col></colgroup><thead><tr style="height: 29.6806px;"><td style="height: 29.6806px;">Field</td><td style="height: 29.6806px;">Purpose</td></tr></thead><tbody><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px; width: 48pt;" width="64">sku</td><td style="height: 29.6806px;">SKU Code of the Product</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">barcode</td><td style="height: 29.6806px;">Barcode of the Product/Unique Stock Record (for Unique Stock Records, this will take precedence on import)</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">price</td><td style="height: 29.6806px;">*The selling price of the Variant*

*Defaults to 0*

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">specialprice</td><td style="height: 29.6806px;">*A retail offer price for the [Variant](https://bookstack.iconography.co.uk/books/categories/page/variants "Variants") (this will supersede the Retail field), if enabled by the Offer Start/Expiry*

*Defaults to 0*

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">rrp</td><td>*The RRP of the [Variant](https://bookstack.iconography.co.uk/books/categories/page/variants "Variants"), to show on the website*

*Defaults to 0*

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">costprice</td><td style="height: 29.6806px;">*The cost price of the [Variant](https://bookstack.iconography.co.uk/books/categories/page/variants "Variants")*

*Defaults to 0*

*May be set per [Supplier](https://bookstack.iconography.co.uk/books/categories/page/suppliers "Suppliers") enabled for this Product*

<p class="callout info">*This may only be used if the Product is linked to a single Supplier. If there are multiple Suppliers, you will need to use the [Cost Price](https://bookstack.iconography.co.uk/books/import-export/page/cost-price "Cost Price") import.* </p>

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">trade\_price</td><td style="height: 29.6806px;">*The trade selling price of the Variant*

*Defaults to 0*

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">trade\_specialprice</td><td style="height: 29.6806px;">*A trade offer price for the [Variant](https://bookstack.iconography.co.uk/books/categories/page/variants "Variants") (this will supersede the Retail field), if enabled by the Offer Start/Expiry*

*Defaults to 0*

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">qtytier</td><td style="height: 29.6806px;">Use to enter and control tiered pricing linked to quantity sold</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">productname</td><td style="height: 29.6806px;">Shows the Product Name

<p class="callout info">Not editable via in this import/export</p>

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">variant</td><td style="height: 29.6806px;">Shows the Product Variant Options

<p class="callout info">Not editable via in this import/export</p>

</td></tr><tr style="height: 29.6806px;"><td height="19" style="height: 29.6806px;">options</td><td style="height: 29.6806px;">Shows the Customisations linked to a specific Unique Atock Record

<p class="callout info">Not editable via in this import/export</p>

</td></tr></tbody></table>