Price Lists

A Price List is a convenient way of customising item rates in Zoho ERP. It can be used to mass control/modify your item prices for a specific customer/vendor or transaction.

To sum it all up, a price list can be used to:

• Offer products regularly at a lower price to a loyal customer.
• Offer products at a higher price for new or one-time customers.
• Offer products at a different price to businesses in a particular country.
• Assign to vendors who provide regular or occasional offers on items.

Enable Price List

To enable price lists:

• Click the Gear icon in the top right corner.
• Scroll down to Module Settings.
• Click Items under General.
• Under the Price Lists section, check the Enable Price Lists option.
• You can also enable additional options such as:
  • Apply price list at line item level – Assign a price list to each item separately within a transaction.
  • Enable Pricing Method - By enabling thisyou can create price lists and apply pricing rules directly at the line-item level in transactions.
• Click Save.

Create Price List  

To create a new price list:

• Go to Items in the left sidebar.

• Click Price lists in the top Module bar.

• Click +New in the top right corner of the page.

• Provide a Name for your price list.

• Choose the Transaction Type of your price list,

  • Sales - Your price list will be available for sales transactions.
  • Purchases - Your price list will be available for purchase transactions.

• Select your Price List Type

  • All Items
  • Individual Items

• If you select the All Items option, enter the following details,

  • Add Description for the price list, if needed.
  • Choose Markup (Increases the price by the given percentage) or Markdown (Decreases the price by the given percentage) in the dropdown and enter the Percentage.
  • Select your Round Off To method for the pricelist.
    • Never mind – No rounding is applied; the value stays exactly as entered.
    • Nearest whole number – Rounds the value to the closest whole number.
    • 0.99 – Always rounds the value up to the next whole number.
    • 0.50 – Rounds the value up when the decimal part is 0.50 or higher.
    • 0.49 – Rounds the value down when the decimal part is 0.49 or lower.
    • Decimal Places – Enter the number of decimal places to which the value should be rounded.

• If you have selected the Individual Items option, enter the following details,

  • Choose the Currency for the price list.
  • Select the Round Off To method.

    • To apply the pricelist for items, navigate to Items tab,

    • Choose your Pricing Scheme.

      • If you have selected Unit Pricing,
        • Select the Pricing Method Markup, Markdown or Custom Rate.
        • If you have selected Markup or Markdown you can enter Percentage
      • If you have selected Volume Pricing, you can set the Custom Rate based on the quantity range.
        • Enter the Start Quantity, End Quantity, and Custom Rate across the required item. You can also search for an item from the list by clicking the Magnifier icon next to Item Details.
        • Click +Add New Range to add another range. You can only add up to 10 price ranges per item.

    • Check I want to include discount percentage for the items, if you wish to provide a discount for the items.

• Click Save

Update Volume Pricing in Bulk  

Alternatively, you can also enter the price range for several items simultaneously using the bulk update option. To do so:

• Go to Items in the left sidebar.
• Click Price lists in the top Module bar.
• Click +New in the top right corner.
• Provide the required details.
• Select Individual Items in Price List Type.
• Click the Update Ranges in Bulk option in the top right side of the items table.
• Mark the checkbox near the items to select them.
• Click the Update Ranges in Bulk button at the top of the item table.
• Enter the Start Quantity, End Quantity, and the markup or markdown percentage.
• Click + Add New Range to add another range. You can only add up to 50 price ranges.
• Click Update, then click Save.

When this price list is applied to a transaction, the item’s rate will be adjusted based on the quantity. If the quantity does not fall under any of the price ranges, the default price will be applied.

Pricing Method

A Pricing Method defines how an item’s price is calculated in a price list. You can apply a markup or markdown on the selling price, purchase cost, or MRP, or set a custom rate for individual items.

Create Price List Using Pricing Method

To create a new price list:

• Go to Items in the left sidebar.

• Click Price lists in the top Module bar.

• Click +New in the top right corner of the page.

• Provide a Name for your price list.

• Choose the Transaction Type of your price list,

  • Sales - Your price list will be available for sales transactions.
  • Purchases - Your price list will be available for purchase transactions.

• Select your Price List Type

  • All Items
  • Individual Items

• If you select the All Items option, enter the following details,

  • Add Description for the price list, if needed.
  • In the Pricing Rule,
    • Select either Markup(Increases the price by the given percentage) or Markdown (Decreases the price by the given percentage) in the first dropdown.
    • If you have selected transaction type as Sales, you can select either of these options in the second dropdown,
      • Sales Price – Uses the selling price set for the item during creation.
      • Purchase Price – Uses the purchase cost entered for the item during creation.
    • Enter the Percentage. Use the (%) dropdown to switch to your base currency. This allows you to increase or decrease the item price by a percentage or a fixed amount in your currency.
  • Select your Round Off To method for the pricelist.
    • Never mind – No rounding is applied; the value stays exactly as entered.
    • Nearest whole number – Rounds the value to the closest whole number.
    • 0.99 – Always rounds the value up to the next whole number.
    • 0.50 – Rounds the value up when the decimal part is 0.50 or higher.
    • 0.49 – Rounds the value down when the decimal part is 0.49 or lower.
    • Decimal Places – Enter the number of decimal places to which the value should be rounded.

• If you have selected the Individual Items option as your Price List type enter the following details,

  • In the Items tab, choose your Pricing Scheme
    • Unit Pricing – Set the Pricing Rule Markup or Markdown and Sales or Purchase Price for each item. You can also set a Custom Rate for each item.
    • Volume Pricing – You can set the Custom Rate based on the quantity range.
      • You can also det the Pricing Rule Markup or Markdown and Sales or Purchase Price for each item.
      • You can view all the item’s Sales and Purchase price.
      • Enter the Start Quantity, End Quantity, and Custom Rate across the required item. You can also search for an item from the list by clicking the Magnifier icon next to Item Details.
      • Click +Add New Range to add another range. You can only add up to 10 price ranges per item.

• Click Save.

Apply Price List

You can associate a price list to:

• Customer or Vendor
• Transaction
• Transaction-level Item

Apply Price List to a Customer or Vendor

To associate a price list to a customer or vendor:

• Go to the Customers or Vendors module under Sales or Purchases.
• Create a new contact or Edit an existing contact.
• Go to the Other Details tab.
• Choose a price list to apply to the customer or vendor.
• Click Save.

Apply Price List to a Transaction  

To apply the price list to a transaction:

• Create or Edit a transaction (SO, PO, Invoice, Bill).
• Click the Select Price List dropdown located above the Item Table.
• Choose the price list to apply to this transaction.
• Select a price list to apply it to the entire transaction or to each item in a transaction.
• Click Save

Apply Price List to an Item in a Transaction  

To apply the price list to the in a transaction:

• Create or edit a transaction (SO, PO, Invoice, Bill).
• Select an item under the Item Details section.
• Under the Rates column, click Apply Price List you want to apply to the item. This will override the price list you have applied commonly for all the items in the transaction.

Other Actions

Import Price List

You can import two types of price lists,

• Sales Price Lists
• Purchase Price Lists

To import any of these price lists,

• Go to Items in the left sidebar.
• Navigate Price Lists in the top Module bar.
• Click the More icon in the top right corner and select Import.
• Choose the Import Sales Price List or Import Purchase Price List option in the dropdown.
• You will be redirected to the price list import page.
• To help you prepare your import file, please download the Sample File from this page and arrange your data according to this file.
• Click Choose File and upload your .CSV, XLS or .TSV import file containing your price lists.
• Select the Character Encoding as applicable. By default, the UTF-8 (Unicode) will be applied.
• Select the necessary File Delimiter(comma or semicolon).
• Click Next to the field mapping interface on a new page.
• Zoho ERP automatically matches similar fields between the app and the file.
• If needed, you can also manually match and map them.
• Check the option Save these selections for use during future imports to automate the future mapping process.
• Click Next to proceed.
• In the preview page, you can view the status of price lists ready for import, the number of skipped records, and unmapped fields.
• If you wish to make any changes, click Previous to edit.
• To complete the import process, click Import.

Edit

Update the details of an existing price list, such as the name, currency, pricing rules, or item prices.

To edit a price list:

• Go to Items in the left sidebar.
• Navigate Price Lists in the top Module bar.
• Hover your cursor over the preferred price list.
• Click the Edit option.
• Update the necessary information and click the Save button to finish.

Delete

Permanently remove a price list that is no longer required. Once deleted, it cannot be recovered. To delete a price list:

• Go to Items in the left sidebar.
• Navigate Price Lists in the top Module bar.
• Hover your cursor over the price list that you wish to delete.
• Click the Trash icon. This will be followed by a confirmation pop-up.
• Click Ok to delete the price list. Please note that this process is irreversible.

Export

Similar to import, you can export two types of price lists,

• Sales Price Lists
• Purchase Price Lists

To export price lists,

• Go to Items in the left sidebar.
• Navigate Price Lists in the top Module bar.
• Click the More icon in the top right corner of the page.
• Choose either the Export Sales Price Lists or Export Purchase Price List option in the dropdown.
• This will trigger an export price lists pop-up bearing all the necessary fields.
• The Entity field will by default be Sales Price Lists or Purchase Price List based on your selection.
• Select the export file format accordingly - as .XLS, XLSX, or .CSV using the Export As field.
• To finish, click on the Export button.
• The file will be saved to your default downloads folder.

Mark Price List as Inactive

You can make your existing price list active or inactive.

To mark a pricelist as inactive,

• Go to Items in the left sidebar.
• Navigate Price Lists in the top Module bar.
• Hover your cursor over an active price list that needs to be deactivated.
• Click Mark as Inactive on the right of your price list.
• Now this price list becomes inactive.

Configure Access Permissions

• Click the Gear icon in the top right corner.
• Navigate to Organization Settings.
• Click Roles under Users & Roles.
• Edit an existing role or create a new role.
• Go to Items.
• Next to the Price List label, select the permissions you’d like to provide the users associated with this role.
• Click Save at the bottom.