Update item prices using Worksheet 351

This topic describes how to use Worksheet 351: Update Inventory - Item Prices Cost (Regular).

You can use Worksheet 351 to update item prices in the Central Manager database and for specified stores. Worksheet 351 creates one worksheet for all selected stores, and is recommended if the stores you are managing with Central Manager have the same pricing and cost information for items.

You can configure Central Manager so item prices are not changed in the central database when you process Worksheet 351. To do this, go to File | Configuration and select the Style 351 worksheet (Update Inventory - Change Item Prices, Cost (Regular)) does not change Central data option.

1. Click Worksheets.

2. Expand Worksheets.

3. Click 351: Update Inventory - Item Prices Cost (Regular).

4. Do one of the following:

• Select specific stores from the list

• Click All to select all stores

1. Click Next.

2. (Optional) Enter a different Worksheet Title.

3. (Optional) Enter an Effective date / time if you want the changes to come into effect at a future date and time.

The best practice is to select a date and time that does not interfere with the operations of an open store.

1. Click Next.

2. Select one of the following:

• Use items in these departments

• Use items in these categories

• Use items in these suppliers

• Add items manually

• Item filter

1. If you selected Use items in these departments, categories, or suppliers:

• Select specific departments, categories, or suppliers

• Click All to select all

1. If you selected Item filter:

   1. Click Filter.

   2. Use the Filter dialog options to identify the items.

   3. Click OK.

2. Select Exclude inactive to exclude inactive items.

3. Click Next.

4. Click Finish.

5. Click OK to confirm that the worksheet(s) are created.

6. Double-click a worksheet or select a worksheet and click Properties.

7. On the General tab, confirm the Effective date / time and add any applicable Notes.

8. On the Contents tab, confirm that the list of items is accurate. If necessary, use Add Row and Delete Row to add or delete items from the list.

9. Do one of the following:

   • For each item, update item pricing information in the appropriate column. To apply the same value to all rows in a column, right-click the value, select Copy, and then right-click anywhere in the column and select Paste to All Rows.

   • Select a cell in an editable column and click Formula to set values based on a formula that you define. You can apply the formula to a cell or to an entire column.

   • Import pricing information from an Excel spreadsheet. Refer to Use file export and import to update worksheets for more information.

10. Do one of the following:

    • Click OK. Your changes to the worksheet are saved but not approved.

    • Click Approve. The worksheet is approved. The changes will be synchronized to the stores and the changes will come into effect on the effective date and time.

11. To check the worksheet processing status:

    1. Click Worksheets.

    2. Expand Worksheets Status.

    3. Click 351: Update Inventory - Item Prices Cost (Regular).

Worksheet processing time depends on the size of the worksheet. However, if you think the worksheet is taking too long to process, check that the worksheet processing service is running. To do this, click Start and type Services in the search field. In the Services window, scroll down to RMH Worksheet Process and click Start Service if the service is not running.

1. To acknowledge processed worksheets:

   1. Click Worksheets.

   2. Click Acknowledge Worksheets.

   3. Select a worksheet and click Acknowledge.