You can import and export stock by clicking Import/export in the shop management panel menu.
The import and export functions will only affect products with codes. If you have products without codes and want them to be included in the import and export, you can either edit the products to give them product codes of your choosing, or click Create product codes. After clicking Create product codes each product will be assigned a code of the form PRODUCT-n, where n is a number.
To export your existing stock, click Export stock. If there are no products in your shop with stock control enabled, this will produce a minimal template file that you can use. Alternatively, download one of the template files:
If you are using Microsoft Excel, please read the note on the Import/export help page.
The stock file consists of a row of column headers, followed by a row for each product variant. Some columns are optional or may occur multiple times, as detailed below. The columns are:
If a product does not have variants that have separate stock levels, the variant group and variant columns should be left blank. If a product does have variants that have separate stock levels, the variant group and variant columns should specify a variant for each variant group that has separate stock levels.
To import your stock file, use the File field to select the file, choose an action using the Action field, and click Import stock. There are three actions available: