Update product data by using the mass update worksheet
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack
You can update the properties of multiple products at the same time by using the Mass update worksheet tool. You can also use this tool to modify product properties at the product category level and then apply the changes to all products that are assigned to the category.
Click Retail > Periodic > Mass update worksheet.
In the Mass update worksheet form, click New to create a new worksheet.
In the Worksheet number form, select the product properties to modify. The appropriate columns are generated in the worksheet.
In Microsoft Dynamics AX 2012 Feature Pack, this form is called Select properties.
To select properties from multiple areas, select the name of an area in the Areas grid. Then select the check box next to each field to include in the worksheet. The areas that appear in the Areas grid correspond to the FastTabs in the Product details form.
On the Products FastTab, click Add products, and then in the Add products form, select the products to update properties for.
After you add the products to the Products FastTab, enter your changes. You can change each product individually, or you can enter the changes on the first product row, and then click Paste first row to copy the changes to one or more rows in the worksheet.
In Microsoft Dynamics AX 2012 R2, you can set a value for a field based on a formula. Do one of the following:
Select one or more rows, and then click Apply price formula to use a formula to enter values in price fields. For example, you can reduce the product price for selected products by a specified percentage.
Select one or more rows, and then click Apply date formula to use a formula to enter values in date fields. For example, you can change the sales date for selected products by adding a specific number of days to the current date.
Click Validate to verify that the changes that you entered are valid. If you enter additional changes after you validate the worksheet, you must revalidate the worksheet before you post the changes.
Click Post to apply the changes that you entered in the worksheet to the products. After a worksheet has been posted, it cannot be modified.