> This page is for Product Documentation.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.navipartner.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.navipartner.com/_mcp/server.

# Set up price worksheet

> If you want to update prices for multiple items without having to change settings in each Item Card individually, you can create a Default Price List in Price Worksheet.

If you want to update prices for multiple items without having to change settings in each **Item Card** individually, you can create a **Default Price List** in the **Price Worksheet** administrative section.

1. Search for **Price Worksheet** and open the related link.
2. Populate the following fields in the **General** section:

| Field Name                      | Description                                                                                                                                                  |
| ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Price Type**                  | Specifies a filter which determines whether the sale or purchase prices are displayed.                                                                       |
| **Defaults**                    | Specifies the fields of the price list header that are used as defaults for new lines created in the worksheet. You can set different filters at this level. |
| **Assign-to Group**             | Specifies a filter for which group the prices apply to.                                                                                                      |
| **Update Multiple Price Lists** | Specifies whether users can add new lines and modify the existing lines in the worksheet suggested by the **Copy Lines** action.                             |

3. Populate the following fields in the **Worksheet** section.

| Field Name                 | Description                                                                                                                                                                                                                                                  |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Manage**                 | You can select 1 line or multiple line & then apply the delete function to clear the lines from the worksheet.                                                                                                                                               |
| **Suggest Lines**          | Create a list of items, based on defined criteria and at the same time establish a **Default Price List**, using adjustment factors on the unit price of the items. When the worksheet is filled, the price list can be also manually modified if necessary. |
| **Copy Lines**             | Lines can be copied from an existing **Price List**.                                                                                                                                                                                                         |
| **Implement Price Change** | Update the **Price List** with the one provided in the worksheet.                                                                                                                                                                                            |
| **Open Price List**        | If a price list is already assigned to the worksheet, you will see the **Price List Code** on the first column in the details.                                                                                                                               |

### Example

If you create a default sales price for the item 1150 using the unit price of 500.00 and applying a factor of 1.20 on it, the new sales price will be 600.00. Then, you can run the **Implement Price Change** action to update the sales price list for the item.

#### See also

* [<ins>Create an item worksheet line</ins>](/product/retail-item-worksheet-create)
* [<ins>Adding variety values to the worksheet</ins>](/product/retail-item-worksheet-add-variety)
* [<ins>Item worksheet template</ins>](/product/retail-item-worksheet-template-ref)