Skip to main content

Adjust Inventory Counts Individually or in Bulk

Adjust the QTY of items available in inventory by individual SKU or in bulk

Updated over 9 months ago

Adjust Individual SKU Inventory

Important: Batch code tracking is an important part of how Coldcart manages inventory and allocates it to orders. If you are adjusting inventory for a product that is tracked by batch code, it is important to always include the batch you are adjusting in any adjustments made.

To see current inventory details by fulfillment center (including batches and quantities), navigate to Product Catalog, click the Inbound Receipt button, and select Export Inventory:

Adjust Inventory Individually

Navigate to our Product Catalog and click the SKU you'd like to update from either the Items or Shipping Boxes headers. In the below illustration, we'll update SKU FM-001 after being informed in a recent hardcount from the warehouse that there are actually 26 units available vs. the 21 shown in the below example:

After clicking the SKU in question, from the resulting righthand sidebar click the Set Inventory button:

The following fields will appear and once you've entered their respective info, click the Record Inventory button:

Note: under Type in the screenshot above, ManualAddition or ManualSubtraction would be the best option to select if adjusting inventory based on a recent hardcount.

The revised quantity will now be listed on the Product Catalog:

Adjust Inventory Across Multiple Items in Bulk

From the Product Catalog, under the Items header, click the dropdown next to the Inbound Receipt button in the right corner. Then click Import Inventory:

Download the .csv template provided on the resulting righthand sidebar where it says: Sample .csv file is available here:

Provide the SKU IDs you'd like updated (ex. FM-001) not the SKU Name (ex. Family Meal Tray), as well as the Quantity and the Batch Code if applicable. Notes is optional here:

Save your .csv and upload it or drag/drop into the File field while also selecting the Fulfillment Center and transaction Type you'd like to execute:

Click the Update Inventory button to finalize the bulk updating and see your changes in the Product Catalog.

Tip for Upload errors: If your CSV won't upload, check for blank rows at the end of your file. Delete any empty lines below your data, save the file, and try uploading again. Hidden blank rows are a common cause of upload failures.

Did this answer your question?