Time to Out of Stock
Time to out of Stock (TTOOS) is the estimated time before a product goes out of stock.
TTOOS (Time to out of Stock) is the estimated time before a product goes out of stock. Specifically, it's the ratio between the Available To Sell (ATS) attribute and the Sales Velocity attribute value for the most recent day. Special rules apply for variation products, product sets, and potentially product bundles. TTOOS is the same for all sites that share an Inventory list, so it's a site-specific value.
TTOOS:
- Is computed in real time in Salesforce B2C Commerce
- Cannot be imported or exported
- Is not staged, so its value is specific to an instance
Standard Product
Where product (p) is a standard product or product bundle for a site that uses an inventory list
- If out of stock, TTOOS = 0.0
- If perpetual available, TTOOS(p) = 1.0
- If Sales Velocity Day(p) not available, TTOOS(p) = 0.0
- If ATS(p) not available, TTOOS(p) = 0.0
- Otherwise, TTOOS(p) = ATS(p) / Sales Velocity Day(p)
Normal Product or Bundle with Inventory List Example
Product 1 - not in stock
InStock: false
TTOOS: 0.0
Product 2 - perpetual
IsPerpetual: true
TTOOS: 1.0
Product 3 - no sales velocity information
Sales Velocity: n/a
TTOOS: 0.0
Product 4 - no ATS information
ATS: n/a
TTOOS: 0.0
Product 5
ATS: 5000
Sales Velocity: 10.5 (per hour)
TTOOS: 5000 / 10.5 = 476.19
Base Product
TTOOS(mp) =
MAX(TTOOS(vpX))
- mp is a base product,
- vpX are online variations of the base product
Example 1
Variation product 1
ATS: 4800
Sales Velocity: 30 (per hour)
TTOOS: 4800 / 30 = 160.0
Variation product 2
ATS: 15
Sales Velocity: 1 (per hour)
TTOOS: 15 / 1 = 15.0
Base product
TTOOS: MAX(160.0, 15.0) = 160.0
Product Bundle
TTOOS for a product bundle is the least amount of time to out of stock for any product in the bundle.
TTOOS(bp) = MIN(TTOOS(cpX ))
Where:
- bp is a product bundle
- cpX are online products in the bundle for a site that doesn't use an inventory list
Product Bundle Examples If Site Does Not Use Inventory List
Product 1 in bundle
ATS: 550
Sales Velocity: 10 (per hour)
TTOOS: 550 / 10 = 55.0
Product 2 in bundle
ATS: 250
Sales Velocity: 10 (per hour)
TTOOS: 250 / 10 = 25.0
Product bundle
TTOOS: MIN(55.0, 25.0) = 25.0
Product Set
TTOOS for a product set the longest time to out of stock of any product in the set.
TTOOS(sp) = MAX(TTOOS(cpX))
Where:
- sp is a product set
- cpX are online products in the set
Example 1
Product 1 in set
ATS: 240
Sales Velocity: 20 (per hour)
TTOOS: 240 / 20 = 12.0
Product 2 in set
ATS: 100
Sales Velocity: 100 (per hour)
TTOOS: 100 / 100 = 1.0
Product set
TTOOS: MAX(12.0, 1.0) = 12.0