Skip to Content

Availability requirements

The availability requirement offers you additional ways to manage availability of inventory beyond the standard available column described in minimum catalog requirements.

ColumnData typeDescriptionExample
balance_on_handfloatThe approximate number of an item on hand in a particular location.53
in_assortmentbooleanIf an unavailable item is likely to be in stock soon, TRUE. Useful to control seasonal and discontinued stock.TRUE
last_sold_datedate (no timestamp)The last date this item was sold in the store, in the format MM/DD/YYYY.10/20/2017
max_in_cartintegerThe maximum number a customer can purchase at once.

An empty row or 0 allows the customer to buy any amount and removes the max_in_cart function from this item.
• If cost_unit = each then max_in_cart value is by item.
• If cost_unit = lb, kg, and no par_weight, then max_in_cart value is by cost_unit (lb or kg).
• If par_weight is given, the system rounds down to the lowest whole item.
4 [maximum of 4]

0 [No maximum set]

Per lb or kg example:
Steak, $5.00 / lb,
par_weight = 0.5lbs,
max_in_cart = 1.5

A customer can buy a maximum of 1.5 lbs, or a maximum of three steaks (0.5 lbs each):
Steak, $5.00/lb, no par_weight,
max_in_cart =1.5
Last updated on