If you've had an external stocktaker come in and stocktake your store you can import their CSV file into Shopfront to update your inventory levels.
Note: You'll need the Perform Stocktake permission for your user to access the Stocktaker Import.
The Stocktaker's file can contain the following columns:
|name||The name or description of the product||No|
|barcode||The barcode of the product||Yes|
|cost||The single cost of the product (inclusive of tax)||No|
|quantity||The quantity scanned||Yes|
Note: Column order does not matter but the column name is case sensitive and cost can contain the currency symbol ($ and €)
When you have received the CSV file and are ready to import the stocktake:
- Open the Menu
- Select Stock Management
- Select More
- Select External Stocktake
- Select Import Stocktaker File
- Select Choose File and select the relevant CSV file
- If you have multiple Outlets you will need to select the Outlet the file is for
- Select whether you wish to zero all inventory not counted (by toggling the Zero All Inventory option) if this is not toggled on, any product not counted in the stocktake will be ignored
- Select whether the stocktake should Override or Add to the current stock on hand
- Select Import.
Shopfront will now process the file, follow the steps below to check and apply the stocktake:
- Once the Stocktake has been created in your store, you will receive a notification, click on this to view the results of the stocktake
- Any product not matched will be highlighted in Green which you can then associate with an existing product or create a new product to associate it to (All unassociated products will be created as new products in your store, if ignored this can lead to duplicate products)
- Once you are ready to do so, scroll to the bottom of the page and select Complete
Shopfront will apply the Stocktake in the background and provide a notification once the stocktake has been applied.
Note: If you have basket products with track inventory turned on, the products within the basket may see an inventory decrease when zeroing stock not counted. View the article on Basket Products and refer to the Stocktaking section for more information on the effect that Basket Products have on the inventory of the products inside them.
Please sign in to leave a comment.