What can we help with?

QOH stands for Quantity On Hand, and it represents your current inventory level for a product in one of your stores. The QOH field is store-specific and the system tracks it individually for each of your locations. Maintaining an accurate QOH is important because this data will help you maintain good inventory stock levels and avoid over- or under-ordering. This article explains where you can find QOH data for your items and different ways you can adjust or update it. Take a look!

Quantity on Hand and Cost of Goods Sold

QOH is inventory that you have purchased and received into your store and however many of them you have left after sales. These are products that you physically have on hand and don't include quantities that are on order.

COG (Cost of Goods) is the dollar amount in total Unit Cost that you paid for the inventory when you received it. In the eTailPet system, the COGS (Cost of Goods Sold) is calculated by averaging the unit cost of the goods over time for the quantities that sold.

Example:

Purchase 1: 4 bags of cat food at a Cost of $5.00 each = $20

Purchase 2: 3 bags of cat food at a Cost of $6.00 each = $18

Total Purchases: (4 + 3 bags = 7 bags) at ($20 + $18 = $38)

Average Unit Cost: $38 / 7 bags = $5.43

Like the example above, as you continue to purchase more of the item, the Average Unit Cost will continue to adjust. This is important because it helps you track your profit by comparing COGS to Sales.

Whenever you adjust your QOH, you will need to include the Cost that you paid for it so that your COGS continues to be accurate.

View Current QOH in My Products

Follow these steps to see an item's current Quantity on Hand for the store you are currently viewing in the Dashboard:

1. In the eTailPet main menu on the left, click to open the Manage Catalog menu, then click on My Products.
2. Find the item you want using the Search and Filters, and click on the Search button to load matching results.
3. Find the QOH column and the quantity listed for the item(s) you want. Please note, this is the quantity for the store you have active in the Dashboard. See the steps below to view QOH for items you want across all of your store locations.

If you need to view the QOH quantities for all of your stores for the item, use these steps:

1. To quickly view the current QOH for a product, go to Manage Catalog > My Products.
2. Find the item you want using the Search and Filters and click on the Search button to load matching results.
3. Click on the Product's Name to open its Details page.
   
4. Click to open the Inventory tab for the product.
5. You will see quantity amounts for all stores that have the item in their Catalog in the QOH column.

Manually Adjusting QOH

From the same area on the Inventory tab, you are able to make manual adjustments to Quantity on Hand for the item. You have an area for Adding Inventory or Removing Inventory. Here is how to work with these tools:

image needs alt text

Add Inventory — Here is how to work with the Add Inventory area:

• Store* — Select the store location to which you wish to add inventory for the item.
• Quantity In* — Enter the quantity of the item you wish to add to the existing quantity. If you're doing a correction because the QOH for the item at one of your stores currently shows 18, but you actually have 20, you would enter 2 into the Quantity In field.
• Unit Cost — Enter the Cost per unit you paid for the inventory you are adding. While not required, we strongly encourage you to enter this data so the system will be tracking your COGS and can generate your profit margins for the inventory.
• Vendor — Select the Vendor from whom you received the inventory. While not required, we strongly encourage you to make a selection so the system can attribute the inventory history to the proper vendor for you.
• Add Inventory — Click this button when you are ready to add the inventory. You'll see a success notification pop up in the upper right.

*Required item in order to add the inventory.

Remove Inventory — Here is how to work with the Remove Inventory area:

• Store* — Select the store location from which you wish to remove inventory for the item.
• Quantity Out* — Enter the quantity of the item you wish to remove from the existing quantity for the store. If you're doing a correction because the the QOH for the item at one of your store's currently shows 12, but you actually have 9, you would enter 3 into the Quantity Out field.
• Remove Inventory — Click this button when you are ready to remove the inventory. You'll see a success notification pop up in the upper right.

*Required item in order to add the inventory.

Importing Quantity on Hand

You are able to import data for QOH for products in bulk from the My Products page. You can adjust the QOH for multiple products and multiple stores all at once using an import. To get started, go to Manage Catalog > My Products.

⚠️Please Note: The Quantity on Hand import overwrites the existing QOH. It doesn't add or remove units; it simply overwrites the current QOH with the values you import. Double check your values before importing!

Step One: Back Up Your Data

1. Go to Reports > Product Detail Report > Export.
2. Retrieve your backup report from your email.

Step Two: Download the QOH Import Template

Go to Manage Catalog > My Products > Import Product Inventory > Export Sample File.

Step Three: Populate the QOH Import Template

1. Copy and Paste the System ID (column A) or UPC (column B ) into your template.
2. Enter the Store ID into Column C (found above the item data table on the My Products list page).
   
3. Enter your updated QOH TOTAL into column D (quantity). You are basically resetting this field to the quantity you enter.
4. Enter the Unit Cost that you paid for one unit of this item into column E (unit_cost). Important: The system tracks this in the Product History and it will affect the Average Cost of the product (See QOH and COGS above).
5. Enter the Vendor ID in column F (you can export these at Manage Catalog > Product Vendors). You can leave this field blank if you are unsure who the vendor was at the time you purchased the items.

Step Four: Import the Updated Data File

Go to Manage Catalog > My Products > Import Product Inventory > Upload Excel File. You'll be able to select the file and and once it has uploaded, you'll see a success notification pop up. It's a good idea to double check your updates and make sure the data is as you want.

image needs alt text

See the link below for the article on Importing Products Best Practices & Troubleshooting for full details on Importing.

Related Topics

Adding and Importing Products

Importing Products Best Practices and Troubleshooting

My Products Overview

Product Details Page

Private Products

Product Manager

Purchase Orders

The Purchase Order Process

Batch Cost and Price Updates

Frequently Asked Questions

Q: I have a question, but I can't find my answer here. How do I get more assistance?

A: You can ask any question at the number listed here. Contact our support team at: (323) 370-0738 for the U.S., and (888) 370-2363 for Canada.