BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Mass update worksheet

A worksheet page where you change selected product properties for many retail products at once and then validate and post the changes.

Used by
Retail merchandising manager, Retail service
Business process
Set product prices
Menu item
RetailMassUpdateWorksheet
Main table
RetailMassUpdateWorkshee
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 worksheet page where you change selected product properties for many retail products at once and then validate and post the changes.
What you do hereUse this page to create a worksheet, pick the product properties to change, add products, enter or formula-fill the new values, validate them and post the update.
ExampleFor example, reduce the sales price of all added products by 50 percent with the formula purchase price * .50 and post the result in one batch.
Mass update worksheet 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

Business processIntroduce products › Set product prices
Menu pathRetail and Commerce › Products and categories › Mass update worksheet
Set up firstReleased products (products to update must exist) Microsoft Learn
Used next byPosting batch job (product changes applied) Microsoft Learn
Related pagesApply formula (form) Microsoft Learn
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 > Products and categories > Mass update worksheet.
  2. Select New to create a worksheet and select the product properties to modify.
  3. On the Products FastTab, select Add products and pick the products to update.
  4. Enter the changes per row, or enter them on the first row and select Paste first row.
  5. Optionally select rows and use Apply price formula or Apply date formula.
  6. Select Validate to check the changes.
  7. Select Post to apply the changes to the products.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Worksheet numberThe automatically generated identifier of the worksheet.Microsoft Learn Number
StatusWhere the worksheet is in its life cycle: Open, Validated, Pending or Posted.Microsoft Learn Status
Date/time postedWhen the worksheet was successfully posted.Microsoft Learn DatePosted
Item numberThe product being modified on the worksheet line.Microsoft Learn ItemId
Product nameThe name of the product on the worksheet line.Microsoft Learn
Solution architect

4Design impact

If you change it laterPosting is final: once a worksheet is pending or posted it can no longer be changed, and any edits after validation require re-validation. Microsoft Learn
Technical architect

5Technical

Menu itemRetailMassUpdateWorksheet Checked in Dynamics 365
FormRetailMassUpdateWorksheet Checked in Dynamics 365
TableRetailMassUpdateWorksheeShown as “MASS UPDATE WORKSHEET” in Record infoKey field: NumberChecked in Dynamics 365
Who can open itPrivilegesUtilize the mass update feature RetailMassUpdateUtilize the mass update feature RetailMassUpdateEditDutiesEdit mass update worksheets RetailMassUpdateEditMaintain retail product reference data RetailProductReferenceDataMaintain
2 security rolesRetail merchandising manager RetailMerchandisingManagerRetail service RetailService
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Validate, PostChecked in Dynamics 365
Developer

6Developer

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

7Sources