This article details the process of running a stocktake.
Stock-taking is the physical verification of the quantities and condition of items held in an inventory or warehouse. This may be done to provide an audit of existing stock or to update online sale channels with the correct inventory levels to ensure customers do not order items which aren’t available. Stock-taking may be performed as an intensive annual, end of a fiscal year, procedure or may be done continuously by means of a cycle count.
How to do a stock take within Stock&Buy
The stocktaking procedure is comprised of three steps:
- Download the location inventory for which you want to run a stock take
- Change the downloaded file to reflect your physical inventory changes
- Upload the file back
Download location inventory
Stocktaking in Stock&Buy is performed for each location separately. To download your location inventory, follow the steps below:
- Go to Stock Control page
- Click on Adjustments
- On the right-hand side of the screen click on the Run a stock take button
- A wizard will pop up. Select the location for which you want to run a stock take.
- Click on Export my location inventory.
- Your stocktake file should automatically download.
Perform changes to the CSV file
The downloaded file has the following format:
|Id||The product variant ID. This is a mandatory field that cannot be omitted. Note: This is a mandatory column, please do not remove it.|
|ProductName||Your product name. Note: This field is read-only. Changing the product name will have no effect.|
|SKU||Stock Keeping Unit for each variant.|
|SupplierSku||Your supplier Stock Keeping Unit for each variant.|
|Weight||The product variant weight|
|Cost||The MAC / initial cost for a single unit for this variant. You don’t need to update this, it is here just for your reference|
|PurchasePrice||The price you pay for your products (per unit)|
|Quantity||The current inventory levels in Stock&Buy.|
|WholesalePrice||The product variant wholesale price (in your base currency) – Ignore this column if you are not using the wholesale price list|
|WholesaleComparePrice||The product variant wholesale compare price (in your base currency) – Ignore this column if you are not using the wholesale price list|
|RetailPrice||The product variant retail price (in your base currency)|
|RetailComparePrice||The product variant retail compare price (in your base currency)|
|Tags||The product tags|
|ProductType||The product type|
|Barcode||The product variant barcode|
|IsBundle||Determines whether the product variant is a bundle or not. Note: This field is read-only. Changing this property has no effect.|
We highly recommend you change your CSV file using Google Sheets. Changing the downloaded file in Excel, Numbers or other spreadsheet software can have unexpected effects and in some situations might result in data corruption/loss. Check out the following article for a few tips and tricks in dealing with CSV files.
Upload the modified CSV file back
Once you are done with the previous step, you can upload the CSV file back to Stock&Buy for the changes to take effect.
- Open the stock take wizard
- Click Next
- Click Next to skip the “download your inventory” section as you already completed this step.
- Upload the file
- Click on Refresh inventory
Stock&Buy will automatically create stock adjustments to record the stock take changes. Adjusted stock levels and other changes will automatically sync to your connected stores such as Shopify if you have any.