Commit Options for Item Mass Changes

Commit options let you specify whether to apply changes directly to the database or export the data to a spreadsheet for further review or modification.

Data that is applied to the database is always validated prior to saving it to the database. After you select the items and specify the changes, then you select the commit operations. If you make changes to a spreadsheet, then the data is uploaded to an item batch, validated and saved to the database through a scheduled process.

Commit options are available for the following item mass change activities:

  • Assign items to organizations

  • Assign items to supplier site organizations

  • Assign items to catalog categories

  • Reassign items to catalog categories

Apply Changes to Database

Changes will be applied to the database after running the validations to ensure the integrity of the changes.

Specify item batch options including, scheduling and change order details in those cases where business rules require approval for any of the changes made.

Note: If you schedule the item batch to be processed at a later time, then it will be available as an internal item batch through Manage Item Batches user interface.

Manage in Spreadsheet

You can review and make further changes to the items through the downloaded spreadsheet and then apply the changes to the database by selecting Upload from within the spreadsheet.

When you click Upload, you must specify batch options including scheduling information. Also specify change order details in those cases where business rules require approval for any of the changes made.

Note: In order to use this feature you must have Microsoft Excel 2007 or later Standard Edition license.