BeyondERP.Newsletter
Menu

Page · Retail and Commerce

Populate product attributes with inventory level

A periodic job that writes inventory availability into a dedicated product attribute, used by inventory-aware product listing pages on e-commerce sites.

Business process
Create B2C eCommerce sales channel in Dynamics 365 Commerce
Menu item
RetailInventoryAvailabilityPropertyBatchDisplay
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that writes inventory availability into a dedicated product attribute, used by inventory-aware product listing pages on e-commerce sites.
What you do hereUse this page to create and refresh the inventory availability attribute so that category and search results pages can show stock labels, hide or move out-of-stock products, and filter by inventory.
ExampleFor example, run the job in batch and schedule the 1150 (Catalog) job at the same frequency so that online search results show Out of stock labels.
Populate product attributes with inventory level page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Retail and Commerce IT > Products and inventory > Populate product attributes with inventory level.
  2. In Product attribute and type name, enter a name for the inventory attribute.
  3. In Inventory availability based on, select Available physical or Total available.
  4. Set Batch processing to Yes.
  5. Select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Product attribute and type nameThe name of the dedicated product attribute that holds inventory data.Microsoft Learn
Inventory availability based onThe quantity type used to calculate the inventory level: Available physical or Total available.Microsoft Learn
Batch processingRuns the job as a batch job.Microsoft Learn

Test checklist

  1. Run the job with a product attribute name, Inventory availability based on = the same quantity type as site builder, and Batch processing = Yes.
  2. Add the new attribute to an attribute group of the online channel in Channel categories and product attributes.
  3. Run the 1150 (Catalog) job and schedule it at the same frequency as this job.
  4. On a category page, check stock labels show and that a product whose variants are all out of stock shows Out of stock.
  5. Check the refiners include an inventory filter.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Feature management and licence

Feature to turn onEnhanced e-commerce product discovery to be inventory-aware (Mandatory, on by default)

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: Each run rewrites the inventory attribute. A change to Inventory availability based on takes effect after the next run and the next 1150 (Catalog) job. Keep it the same as Inventory level based on in Commerce site builder, or site pages will calculate inventory levels differently. Microsoft Learn
If you change it laterUse the same quantity type here and in Commerce site builder, or inventory levels will be calculated inconsistently across site pages. Microsoft Learn
Technical architect

6Technical

Menu itemRetailInventoryAvailabilityPropertyBatchDisplay Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailInventoryAvailabilityPropertyBatchDisplay
Everyone

8Sources