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

A product bundle’s availability is the availability of its least available product, because products in a bundle can't be purchased separately. Availability is calculated using the following formula:

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

Product Set

A product set’s availability is the availability of its most available product, because products are purchased individually, but are promoted through a set. So customers can purchase any item in a set that’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

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.