POS Integrations
Stock file fields

Stock file fields

Fields

The following fields are accepted in your stock.csv or stock.xlsx file:

FieldRequiredDescription
barcoderequiredOne of the supported generic identifiers for the product (see formats).
pricerequired

The price of the product in pounds, using a dot (.) as a decimal separator, without any currency symbol or spacing.
(e.g. 1.00 for a quart of milk).

Note: prices under 0.01 are considered invalid.

quantityrequiredThe number of items of this product that are in stock. Should be between 0 and 999, and should not use decimals or thousands separators.
currencyoptionalThe three-letter ISO 4217 currency code for the price field for the product. Defaults to the main currency in the country in which the shop is located.

File formats

Both CSV and XLSX (Excel 2009+) file formats are accepted.

CSV files can use commas, semicolons or tabs as separators. The first row is assumed to be the header row, and the values of this row will be used as field names for the other rows in the file.

Example contents

Formatted:

barcodepricequantitycurrency
97801413837436.991GBP
97800995465598.994GBP
9781409162988200GBP
08092129.951GBP
08092229.952GBP

Plain text CSV:

barcode,price,quantity,currency
998010033,8.81,4,GBP
002551779,14.26,1,GBP

Example files