Where can you update your inventory?
Inventory Page
Used for fast inventory updates.
Adjust stock directly by searching for a product by name or SKU.
Choose the adjustment type (Add, Subtract, or Set), enter the quantity, and save.
Option to add comments or reasons for adjustments.
Stock Adjustment Forms
Used for bulk inventory adjustments and tracking changes.
Allows selection of a warehouse, adjustment type, and reason.
Supports bulk inventory updates through CSV uploads.
Adjustment types
There are three types of adjustments that can be made to the In stock inventory:
Add: This is the default option. Adds a specified amount to the In stock inventory. If the In stock is 15, and you Add 3, it will make the In stock inventory as 18.
Subtract: Subtract a specified amount from the In stock inventory. If the In stock is 15, and you Sub 3, it will make the In stock inventory as 12.
Set: Set the value of the In stock inventory to a specified number, replacing the current value. If the In stock is 15, and you Set 3, it will make the In stock inventory as 3.
When using "Add" as an adjustment type, you have the flexibility to add a negative quantity, which will be treated as a "Subtract" adjustment. Here's an example to illustrate this:
If you are selecting "Add" as the adjustment type and have quantities as follows:
SKU1: 10
SKU2: -10
In this case, the adjustment will add 10 units to SKU1, increasing its quantity, and subtract 10 units from SKU2, decreasing its quantity. So, the final result will be an addition of 10 units to SKU1 and a subtraction of 10 units from SKU2.
Adjust stock via Inventory page
Navigate to the Inventory Page from the menu.
Select the location and search for the product by name/SKU.
Choose adjustment type (Add, Subtract, or Set).
Enter the quantity and click Save.
Adjust stock via Stock Adjustment Forms
Go to Stock Adjustment page from the navigation menu and follow the steps below:
Click on the Create Stock Adjustment button.
Fill in the necessary details in the form and Click on Add Products: Provide information such as the reason, adjustment type (addition, subtraction or set), and add the products.
Warehouse: This field allows you to specify the specific warehouse where the stock adjustment will take place.
Adjustment type: You can choose between Add, Subtract or Set
Reason: In this field, you can specify the reason for the stock adjustment. You also have the option to add new reasons. These reasons are displayed in the stock adjustment page and serve as a useful way to track inventory adjustments.
Notes: This field allows you to add any additional notes that can help them identify or distinguish this particular adjustment. It can be used to provide any relevant information or context for the adjustment.
Add Products: Click on Add Products button and add the products to the form
Click on Mark as Complete to apply changes to the inventory values.
To add and subtract inventory in the same form, you can select adjustment type as Add, and enter negative values to subtract inventory and positive values to add inventory.
Video guide
If you need to make adjustments across multiple warehouses, you will need to create separate stock adjustment forms for each warehouse.
Bulk Uploading Inventory via CSV file
Bulk upload using SKU and quantity
Import sample: Download the import stock sample file by clicking the button.
To update your stock using SKUs, follow these steps:
Prepare the downloaded spreadsheet sample with two columns: one for SKUs and one for quantities. Fill in the SKUs and corresponding quantities in the spreadsheet. Save the spreadsheet in CSV.
Follow the first two steps as per adjust stock via stock adjustment forms.
Click on CSV upload. The adjustment form should be empty for the CSV file upload.
Click on Mark as Complete to process the changes
You can only upload 5000 products in a single import. If you have more than 5000 products, you could split the number of products into multiple CSV files and upload them.
Video guide
Bulk upload using barcode and quantity
Import sample: Download the import stock sample file by clicking the button.
To update your stock using barcodes, follow these steps:
Navigate to the Stock Adjustment section and select +New Adjust Stock Form
Rest of the steps remain same as per the bulk uploading inventory using csv file.
Handling errors in bulk uploading
The correct SKUs in the file will get imported into the form. If any errors exist, a file containing all the error descriptions will get downloaded. The errors will be displayed in each row where the error exists.
List of common errors:
Most common error: Wrong column headers: Please ensure that the column headers are correct. The correct column headers should be "sku" and "quantity".
Other common errors:
Non-existent SKUs: Please ensure that all SKUs listed in the upload file actually exist in Sumtracker.
Blank SKU field: Please make sure that the SKU field is not left blank.
Updating bundle inventory: Please note that the inventory for bundles cannot be edited.
Other Points to Note:
Blank quantity field: If the quantity field is left blank for any SKU, the inventory for that SKU will not be affected in Sumtracker.
Extra columns: If any extra columns are included with different column headers, they will be ignored by Sumtracker. This allows you the flexibility to include additional information without the need to remove any extra columns from the sheet.
Adding products that don’t exist in Sumtracker yet: It is not possible to add inventory for new or uncreated products through bulk upload. Before adding inventory, you must first create the new products or synchronize them through their preferred store channels. The bulk upload feature is designed to only update inventory for already existing SKUs.