PD Mass Maintenance Entry - Excel Import overview

Pricing and Discounting > Entry > Mass Maintenance

Use this page to import price and discounting data from an Excel file.

When you import pricing data from an Excel file, data and labels are imported from the first worksheet only. You can include region data as part of the detail level, but the import does not currently support the import of region data. If the column label is Warehouse/Region, the data is validated for Warehouse only.

You can use the export grid option in PD Mass Maintenance Entry to create a template for an import file. If you use the export feature to generate a template all of the column labels are complete words, not abbreviations, meaning that it is easier to read the import file data in the Excel file.

On this page you can perform these actions:

  • Specify the type of records to import and the import file.
  • Create and maintain pricing sets.

To access this page, click the Import Excel with New Records button on the main page.