QuickBooks HelpQuickBooksHelpIntuit

Adjust stock levels of your existing products

SOLVEDby QuickBooksQuickBooks Online9Updated November 03, 2022

Learn how to do stock control by adjusting your stock levels in QuickBooks Commerce.

QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.
QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.

After you set up your inventory, customers, and price lists, manage your stock levels to avoid over and understocking of products. It also helps you track the products that are more sellable than others, making it easier to know which ones to stock more.

If you have new products, you can let QuickBooks manage your stock levels.

Receive a purchase order or fulfill a sales order

When you receive a purchase order or fulfill a sales order, the stock levels of your products adjust accordingly. This affects financial info like moving average costs and stock on hand values

Create a stock adjustment

If you want to increase or decrease your stock quantity, create a stock adjustment. This affects financial info like moving average costs and stock on hand values.

Use Stocktakes

If the stock on hand quantities are incorrect after you import your stock levels and inventory, do a stocktake to update them.

Note: Using a stocktake won’t affect your inventory’s moving average costs.

If you want to update a few stocks only, do a manual stocktake.

  1. Go to Stock Control, then select Stocktakes.
  2. From the Create New ▼ dropdown menu, select New Stocktake.
    Note: If this is your first time to perform a stocktake, select Authorize before you select a location.
  3. In the Stocktake Tool page, select a location where you want to perform a stocktake from the dropdown ▼ menu, then select Begin Stocktake.
  4. Select Manual Stocktake.
  5. In the NEW QUANTITY column, enter the updated variant quantity. This voids the current stock on hand value.
    Note: The stock on hand value includes the amount of stock available and stock committed.
  6. Select View Summary > to view the changes you made.
  7. If you still need to make changes, select Edit Values. If everything looks good, select Finalize Stocktake.

Once you're done, you still have the option to View Stock Adjustment or Make Another Stock Adjustment.

If you have a barcode scanner and your products use UPC barcodes, use the barcode scanning method to speed up your process.

  1. Connect your barcode scanner to your computer first and make sure it’s working.
  2. Go to Stock Control, then select Stocktakes.
  3. From the Create New ▼ dropdown menu, select New Stocktake.
  4. In the Stocktake Tool page, select a location where you want to perform a stocktake from the dropdown ▼ menu, then select Begin Stocktake.
    Note: If this is your first time to perform a stocktake, select Authorize before you select a location.
  5. Select Barcode Scanning.
  6. Scan the barcode on your product variants.
    Note:
    • If you want to switch to manual stocktake mode, you can select Manual Stocktake.
    • If you want to increase the quantity of your stocks, you can scan the same product multiple times or enter it manually.
    • If the barcode doesn’t exist in QuickBooks, an error message  “Barcode is not found” will appear.
  7. If the quantities are accurate, select Finalize Stocktake.

Once you're done, you can select VIEW SUMMARY to check the edits you made.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Commerce Core

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this