Maintaining Product Inventory
Each product in your inventory is assigned a Merchant Available QTY, a Groupon Available QTY, and a Sold QTY. Understanding the unique function of each of these fields will help you accurately track sales, adjust inventory and avoid oversells.
Updating Available Product Inventory
Whenever a customer purchases one of your deals on Goods Marketplace, Groupon automatically updates that product's available quantity accordingly.
However, merchants also have the ability to update any product’s available quantity manually. This function is useful when you receive a new shipment that increases the inventory you have in stock, or when transactions outside of Goods Marketplace decrease the amount of inventory you have on-hand.
To adjust your inventory for a product, search for that product on the Product Group page on Gateway. Once you've found the product you’d like to edit, enter your new value in the Merchant Available QTY field, or toggle up and down using the arrows, then click “Save” at the bottom of the page.
Merchant Available QTY
The Merchant Available QTY (MAQ) is the field used by merchants to make inventory updates. The quantity entered here should reflect the number of units you currently have available to sell at that time. Generally, merchants update this field when more inventory is in stock,
The MAQ is the only field that can be edited by the merchant. To adjust your inventory available for a product, enter your new number in this field, then click “Save” or “Update”.
After a new MAQ is applied to a product, the GAQ (see below) will then automatically update to match the new MAQ value.
Once a merchant sets a product’s MAQ in Gateway, that field will remain intact until the merchant updates this number again. It does not automatically decrease when orders are placed.
Groupon Available QTY
Groupon Available QTY (GAQ) is the total number of units currently available for sale on the deal page. This value should never be higher than the amount of inventory you have on-hand for that product.
GAQ is automatically calculated by Groupon. GAQ re-calculates when the MAQ is updated by the merchant, when new orders are placed, or when open orders are canceled.
When new orders are placed by customers, GAQ reduces proportionate to the number of units ordered. When orders get canceled, GAQ increases based on units in the newly canceled orders.
The Sold QTY (SQ) reflects the number of units of that product sold on Groupon across the entire life of the deal. This number cannot be edited, and is simply visible for your record-keeping.
Troubleshooting: Can't Set GAQ to 0?
Occasionally, merchants have encountered a glitch on the Gateway platform where the Groupon Available Quantity remains set to “1”, even after the Merchant Available Quantity is set to “0”.
There is an easy workaround for this issue, explained in the article linked below: