Setup

You will need the Warehouses module turned on in your workspace. If you do not see this in your main menu, reach out to [email protected].

You will also need the following permissions in your security group: Can create and manage warehouses, submit stock adjustments and transfers.

To enable the stock adjustments approval workflow, ensure only relevant users have the permission Can approve stock adjustments.

Click here to learn about permissions and security groups.

Best Practices for Stock Management and Inventory Adjustments in Uptick

Managing stock and inventory in Uptick requires a strategic approach to ensure accuracy and efficiency. Below, we outline the key practices and methods for handling stock adjustments, preventing discrepancies, performing bulk inventory tasks, and running stock takes effectively.

If you see this arrow, click to expand for more information!

We will add additional information and images under these arrows.

How to submit a stock adjustment

Via Warehouse

1. Navigate to Billing > Warehouses and click View on a warehouse.

2. Click New Adjustments.

3. Provide the Comment for the audit trail, search for the relevant product, enter the New Count and click Create.

The products can be searched by Name, Supplier Ref, Internal Ref, Supplier or Category.

Video

Via CSV Data Importer

For precise adjustments, avoid resetting all quantities to zero. Instead, download the current stock data, update the quantities in a spreadsheet, and re-upload the updated spreadsheet back into Uptick. This practice prevents data loss and ensures accurate inventory tracking.

Download Stock adjustment template in Import Templates in Tools > Data Importer. Complete the required fields:

Quantity: The current stock level of the product.
Product Identifier: Only one of the following columns needs to be filled to match the product in the system: product_name, product_code, product_id, or a combination of supplier_name and product_sku.
Warehouse Identifier: Only one of the following columns needs to be filled to match the warehouse: warehouse_name or warehouse_id.

Then follow the steps in How to update existing data via Uptick CSV Data Importer to import the Stock adjustment.

The following CSV files can assist with completing the Stock Adjustment template:

To download the current stock levels for each product in the warehouse: view the warehouse, open the Download dropdown and click Download All Stock.

To download the list of all warehouses and their IDs, navigate to Billing > Warehouses and click Download.

How to approve a stock adjustment

1. Go to Billing > Warehouses and Click on the Stock Adjustment.

This functionality is also available on the warehouse page when clicking Review Pending.

2. Click Review on the stock adjustment.

3. Click Delete, Edit (to change Comment, New Count or Unit Cost) or Approve.

Recommended Steps

Bulk Transferring Inventory Without CSV Import

You can move inventory between warehouses using Uptick’s Bulk Transfer feature without relying on data imports. Follow these steps:

Select the Target Warehouse: Navigate to the warehouse from which stock will be transferred.
Initiate Bulk Transfer: Use the Bulk Transfer option, enter the quantities to be transferred.
Choose the Destination Warehouse: Specify the receiving warehouse.
Confirm the Transfer: Complete the process to move the stock. This workflow simplifies stock transfers by eliminating the need for external tools.

Performing a Stock Take

Conducting a stock take ensures that physical inventory aligns with the records in Uptick. Here’s the recommended workflow:

Prepare an Exported Stock List: Download the current stock list from the Warehouse to use as a reference.
Perform a Physical Count: Compare the listed quantities to the actual counts in the warehouse. Treat items with no count as having zero quantity.
Adjust Quantities Directly in Uptick:
- In the Warehouse, select New Adjustment to access the product list.
- Enter the final counts for each product (use absolute numbers rather than increments or decrements).
Add New Items: For items not currently in the system, use Add Stock to input them before adjusting counts. This process ensures accuracy by combining systematic physical counts and targeted system updates.