CSM Listings - Inventory Availability
CSM can calculate the availability of a listing's Business Central item and send that quantity to the sales channel.
Channel-wide defaults are set on the sales channel's Listing Management FastTab (see CSM Sales Channels - Listing Management) and are copied to each new listing, where they can be overridden.
Prerequisites
This applies to Amazon, Shopify, BigCommerce, WooCommerce and Magento:
- External Inventory ID on the listing's Inventory Information FastTab must be populated with the channel's inventory/variant ID. CSM retrieves this automatically when the listing is first linked to the channel product.
- Channel Inv. Location ID on the sales channel identifies the channel location that receives the quantity. One or more Business Central locations can be mapped to it; CSM aggregates availability across all mapped locations.
Availability FastTab
| Field | Purpose |
|---|---|
| Send Availability | Enables availability for this listing (defaults from the channel) |
| Availability Basis | Options are: Available to Promise, On Hand Less Reservations, On Hand Less Sales Orders, Total Stock, Channel-Defined |
| Compare Availability To | Last Value Sent compares the calculation to the last quantity sent. External Inventory on Hand is not supported at this time. |
| Available Channel Percent | Percentage of Business Central availability to send (use to hold back safety stock) |
| Available Min Qty Threshold | Minimum quantity to send. Below this, CSM sends zero. |
| Subtract Threshold From Availability | Also subtracts the threshold from the calculated quantity |
| Available Last Qty Calc | Result of the last calculation |
| Available Last Qty Sent | Last quantity sent to the channel |
| Availability Requires Update | Flags the listing for the next automation run |
Availability Formula Example
Available Channel Percent 90, Min Qty Threshold 15, Subtract Threshold = Yes, on-hand 600: (600 × 90%) − 15 = 525
Calculating and Sending
- Choose Actions > Calculate Channel Availability. The result is written to Available Last Qty Calc.
- If the result differs from the comparison value, choose Actions > Send to Channel > Availability.
Both steps normally run through CSM automation rather than manually. Configurable items are handled the same way as simple listings.
Advanced Availability Operation
This applies to Shopify and Magento:
When Advanced Availability Operation is enabled on the sales channel, availability is tracked per location using CSM Inventory Availability records, shown in the Advanced Availability part of the listing.