Availability for Active Data

Availability is the normalized ratio between the Allocation attribute and the Available To Sell (ATS) attribute of a product inventory record. Special rules apply for variation products, product sets, and potentially product bundles. Availability is the same for all sites that share an Inventory list, so it's basically a site-specific value.

Availability:

Standard Product

Example: Standard Product and Bundled Products Within an Inventory List

Allocation(p: 50)

ATS(p: 10)

Availability(p: 10 / 50 = 0.20)

Master Product and Variations

If the number of online variations is zero, then the availability of the master product is zero.

Otherwise, the availability of a master product is equal to the sum of the availability of each variant divided by the total number of variants. Availability is calculated using the following formula:

Availability(mp) = SUM(Availability(vpX)) / X)

Where:

mp is a master product

vpX are online variants of the master

X is the number of online variants

Example: Master Product Within an Inventory List

Variation product 1

Allocation: 50

ATS: 10

Availability: 0.20

Variation product 2

Allocation: 100

ATS: 10

Availability: 0.10

Master Product

Availability: (0.20 + 0.10) / 2 = 0.15

Product Bundle

The availability of a product bundle is the availability of the least available product in the bundle. This is because products in a bundle can't be purchased separately and must be purchased together. Availability is calculated using the following formula:

Availability(bp) = MIN(Availability(cpX))

Product Set

The availability of a product set is the availability of the most available product in the set. This is because products are purchased individually, but promoted through a set. So customers should be able to purchase any item in a set if it's still available. Availability is calculated using the following formula:

Availability(sp) = MAX(Availability(cpX))

Where

sp is a product set

cpX are online products in the set

Example: Product Set Within an Inventory List

Product 1 in set

Allocation: 50

ATS: 10

Availability: 0.20

Product 2 in set

Allocation: 100

ATS: 10

Availability: 0.10

Product set

Availability: MAX(0.20, 0.10) = 0.20