What is Close at Quantity and how to use it
The "Close at Quantity" is a threshold that, when reached, marks your SKU as sold out on your online stores. For example, if a product's close at quantity is set to 10, Sumtracker will push 0 as the available inventory to your online store when the item's inventory reaches 10 or below 10. This reserves 10 units of the product, which can be useful in various scenarios such as wholesale orders, physical store inventory, creating an artificial scarcity of a product or simply to reserve quantity in stock for fast moving items.
Important Points to Keep in Mind
- The close at quantity has to be set for each warehouse separately
- The close at quantity works independently for each location in Shopify. If a product's inventory at a specific location hits the threshold, that location in Shopify will be marked as out of stock for that product. This does not affect the inventory status at other locations.
- Close at quantity can only be set for normal products.
- For bundles, the close at quantity can be defined for individual components. If a component reaches close at quantity, the bundle will be marked as out of stock.
How Close at Quantity works?
For Normal Products
| SKU | Warehouse | Available Inventory | Close at Quantity | Status on Store |
| BLUE-JEANS-M | Main Location | 15 | 10 | In Stock |
| RED-TSHIRT-L | Main Location | 12 | 5 | In Stock |
| GREEN-SKIRT-S | Main Location | 8 | 8 | Sold Out |
In this example, the "GREEN-SKIRT-S" SKU will be marked as sold out in your online store because its available inventory has reached the close at quantity threshold.
For Bundle Products
Lets say you are selling a bundle with SKU Moisturiser-Serum-Bundle with the following components
Example 1: All Components are above Close at quantity. Bundle SKU will be Available at Main Location
| Component SKU | Warehouse | Available Inventory | Close at Quantity | Status on Store |
| Moisturiser | Main Location | 15 | 10 | In Stock |
| Serum | Main Location | 12 | 5 | In Stock |
Example 2: One of the Component reaches Close at Quantity. Bundle SKU will become sold out at Main Location.
| Component SKU | Warehouse | Available Inventory | Close at Quantity | Status on Store |
| Moisturiser | Main Location | 9 | 10 | Sold out |
| Serum | Main Location | 12 | 5 | In Stock |
How to set up Close at Quantity
From Inventory Page
- Navigate to the Inventory page.
- Verify the Warehouse you are setting the Close at quantity for
- Update the Close at quantity column by clicking on the cell and setting the quantity
Bulk Import Close at Quantity
To bulk import close at quantity follow these steps,
- Navigate to the inventory page
- Click on the More options button > Import Inventory thresholds
- You can download the template sheet from the import workflow
- Close at quantity can be updated in bulk by changing the required quantities in excel and uploading the updated sheet