A stock adjustment is used to alter stock level for reasons such as write-offs, stock-takes, donations etc. You can also use it to adjust the value of a product.
Important: This article requires the
Maropost Commerce Cloud Inventory add-on. If you are not using Maropost Commerce Cloud inventory, please refer to the
standard instructions.
In this Article
Create a Stock Adjustment
To alter your stock levels with a stock adjustment:
-
In your Maropost Commerce control panel navigate to Stock Control > Stock Adjustment.
-
From the Stock Adjustments page click Add Stock Adjustment.
-
Select the Location you wish to create a stock adjustment for, and the Reason for the adjustment.
-
Add products to your stock adjustment by typing or scanning the product SKU, name or barcode. Continue to do this for all the products that you would like to add to your stock adjustment
-
You can adjust quantity and prices on each stock adjustments lines. As you adjust the stock, the line adjustment values and total adjustment values will calculate.
It’s important to remember the following:
- Cost prices will default to that products ACOG (Average Cost of Goods).
- The quantity change will default to 1 and cannot equal 0.
- Stock adjustments cannot be changed once they have been saved.
- Cost prices can accommodate values up to 4 decimal places.
-
Add a comment to the stocktake for future reference. Click the Save button.
Your stock adjustment will be recorded, and stock levels updated.
Create a Stock Adjustment from the Product Page
Rather than adding each product individually to a stock adjustment, they can be added in bulk from the product page:
-
In your Maropost Commerce control panel navigate to Products > View products
-
Filter your product selection to the products that you would like to Stock Adjustment, bulk select products and click With selected > Create New Stock Adjustment.
-
This will load the create Stock Adjustment page with the products you have selected pre-populated.
-
Once you hit save, the Stock Adjustment will be actioned and Stock/ACOG changes applied.
Adjust Stock in Bulk
Stock adjustments can be performed in bulk by importing a CSV file. To add the products in bulk:
-
In your Maropost Commerce control panel navigate to Stock Control > Add Stock Adjustment.
-
Click on the Populate via CSV button to view the instructions on how to create and upload a stock adjustment file.
Please Note: The maximum number of adjustments per file is limited to 250 records.
-
Click the Download Template button to save a blank CSV template file to your computer.
-
Open the file and populate it with your data. Save the file once complete.
-
In your Maropost Commerce control panel click the Choose File button and browse to the file where you saved your data, and click the Open button.
-
Click the Populate Stock Adjustment button to upload your file, and adjust your stock levels.
Stock levels of imported products will be adjusted as per the file you've uploaded.
Stock Transfers
Please refer to our specific documentation to perform a stock transfer.
Revalue Stock
You can also use stock adjustments to revalue your stock:
-
Create a new Stock Adjustment.
-
Add your products.
-
Enter a negative value for the SOH (Stock On Hand) at ACOG (Average Cost Of Goods) to bring the quantity of the item to zero.
-
Enter a positive value for the SOH (Stock On Hand) and a new ACOG (Average Cost of Goods) to bring the quantity back to it's original value.
Repeat these steps for each warehouse.
Related Articles