Stock

Stock CSV Import

Stock CSV Import is ONLY intended for initial setup. This is due to the fact that the Ka-ching system is built around traceability, and all stock modifications are logged with detailed information about the reasons for the stock change (e.g. sales, returns, reception of goods or resets due to a stock inventory count).

The CSV Import is logged as 'stock import reset' event, so it basically overwrites the existing stock counts and does not provide a lot of detailed information as to the reason.

For this reason it should be used very sparingly - ideally only when the system is initially configured.

The format is very simple:

Format description:

Products without variants:

product_id,quantity
0001,11
0002,20
1234,1

Download sample

Products with variants:

product_id,variant_id,quantity
0001,blue,11
0001,red,2
0002,medium,20
0002,large,32
0003,,10

Note that it is ok to leave out the variant id for products without variants in the latter form.

Download sample

Taking products out of stock

You can use a dash (-) in place of the quantity in order to remove the product from stock.

Taking a product out of stock means that it will no more be a part of the stock reports or the stock counts.

Taking a product out of stock is often performed together with removing the product from the product catalog.

Example:

product_id,variant_id,quantity
0001,blue,-
0001,red,-
0002,medium,20
0002,large,32
0003,,10

Here both variants of the product with id '0001' are taken out of stock.

Performing stock adjustments

You can also use the CSV import to make adjustments rather than setting the new stock value.

To do just that, replace the quantity column with an adjustment column.

Note that adjustments can be both positive and negative.

product_id,variant_id,adjustment
0001,blue,11
0001,red,-2
0002,medium,20
0002,large,-32
0003,,10