BeyondERP.Newsletter
Menu

Page · Retail and Commerce

Assortments

A page where you define assortments, which map channels or organization nodes to the products, categories and variants they can sell, and publish them.

Used by
Retail catalog manager, Retail merchandising manager, Retail operations manager and 3 more roles
Business process
Create assortments in Dynamics 365 Commerce
Menu item
RetailAssortmentGridView
Main table
RetailAssortmentTable
Data entity
RetailAssortmentEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page where you define assortments, which map channels or organization nodes to the products, categories and variants they can sell, and publish them.
What you do hereUse this page to create or copy an assortment, choose its channels, include or exclude products and categories, set its dates and publish it so the products become available in those channels.
ExampleFor example, you define one assortment that includes a base set of products for all stores and another that includes only large sporting equipment for your larger stores.
Assortments 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 > Catalogs and assortments > Assortments.
  2. Create a new assortment, or copy an existing assortment.
  3. Select the channels or the high-level groups of channels that the assortment applies to.
  4. Add product categories, individual products, or product variants, excluding selected products if needed.
  5. Set the start and end dates if the assortment is date-effective.
  6. Publish the assortment; the assortment scheduler runs automatically.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
ChannelsThe channels or organization hierarchy nodes the assortment applies to.Microsoft Learn
ProductsThe categories, products or variants included in the assortment.Microsoft Learn
ExcludeMarks a product or category line as excluded; an excluded product always wins over an included one.Microsoft Learn
Start date / End dateThe dates between which the assortment makes its products available.Microsoft Learn

Test checklist

  1. Create an assortment, add a test store or its organization node, and add one category plus one excluded product from that category.
  2. Publish the assortment and wait for the assortment scheduler to finish.
  3. Open All stores, select the store, and select View channel products.
  4. Check that products from the category are listed and the excluded product is not.
  5. Check that a product that isn't released to the legal entity doesn't appear even though it's in the assortment.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneHard to reverse: You can edit a published assortment or its channels, but nothing changes in the channels until you update the assortment and the assortment scheduler runs again. Products added to an included category join the assortment automatically on the next scheduler run. Microsoft Learn
If you change it laterEditing a published assortment or its channels has no effect until the assortment is updated and reprocessed; dynamic assortments that reference categories or organization nodes change automatically when those groups change. Microsoft Learn
Technical architect

5Technical

Menu itemRetailAssortmentGridView Checked in Dynamics 365
FormRetailAssortmentDetails Checked in Dynamics 365
TableRetailAssortmentTableShown as “ASSORTMENT” in Record infoKey field: AssortmentIDChecked in Dynamics 365
Data entitiesRetailAssortmentEntityAssortment Microsoft data model
Who can open itPrivilegesMaintain retail assortments RetailAssortmentsMaintainView retail assortments RetailAssortmentViewDutiesMaintain retail assortments RetailAssortmentMaintainView retail assortments RetailAssortmentViewMaintain retail product reference data RetailItemReferenceDataMaintain
6 security rolesRetail catalog manager RetailCatalogManagerRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManagerRetail warehouse manager RetailWarehouseManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerRetail catalog manager RetailCatalogManagerTo use itRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerRetail warehouse manager RetailWarehouseManagerGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): New, Configuration status, Publish, Copy assortment, View assortment products, Reset transition statusChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=RetailAssortmentGridView
Integrate withRetailAssortmentEntity data entity Microsoft data model
Data migrationRetailAssortmentEntity (Assortment): shared by all companies, in Microsoft's default template 500 - Retail.Load order: Microsoft's default template 500 - Retail loads Assortment at execution unit 1, level 500, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Costing)Microsoft Learn
Table definitionRetailAssortmentTable columns and relations Microsoft data model
Everyone

7Sources