Zoho Inventory

Help Docs

Price Lists

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

Scenario: Peter wishes to provide a 10% discount to his loyal customers on every purchase. However, it would be unfeasible to edit the prices of the items every time. To overcome this situation, he creates price lists and applies them to his contacts (customer or vendor) or transactions. The item prices will then be altered for those customers or orders automatically.

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


Enable Price List

To enable price lists:

  1. Go to Settings > Preferences > Items.
  2. Under the Price Lists section, select Enable Price Lists option.

    Pro Tip: Enable the Apply price list to each item in a transaction option to assign price list to each item separately in a transaction.

  3. Click Save.

    Price lists enable
  4. You’ll be able to access the Price Lists module under the Items module in the sidebar.

    Price lists module under Items

Create Price List

To create a new price list:

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Click the + New Price List button in the top-right corner of the page.

    Image showing the new price list button
  3. Provide a Name for your price list.

  4. Choose the Type of your price list. If you choose Sales, your price list will be available for sales transactions, and if you choose Purchases your price list will be available for purchase transactions.

  5. Choose how you want to control the Item rate. You can do so in two ways:

Depending on the choice, the price list creation process will differ significantly.

Markup/Markdown by Percentage

  1. Choose whether you wish to markup or markdown the rates.
  2. Enter the percentage of the cost that you want to mark up or markdown.
  3. Configure how your prices must be rounded off to, by entering the round off value.
  4. Add a Description for your price list.
  5. Click Save.

    Image of the new price list page

Entering Item Rates Individually

  1. Choose a currency for the price list.
  2. Add new rates/prices for your preferred items one by one.
  3. Add a Description for your price list.
  4. Click Save.

    image of the new price list page - entering item rates individually

Volume Pricing

Volume Pricing allows you to define a unit price for an item based on the quantity sold or purchased. That is, you can set price breaks for items depending on their quantity. For example, if a customer purchases only 10 units of product A, each unit will cost $15; but if they purchase over 11 units, then the cost of each unit will drop to $13, and so on. This method helps you sell slow-moving or excess stock quickly.

To set the volume price for an item:

  1. Go to Items in the sidebar, then Price Lists.
  2. Click the + New Price List button on the top-right corner.
  3. Enter an appropriate name for the price list.
  4. Choose the Enter the rate individually for each item option.
  5. Under Pricing Scheme, choose Volume Pricing.
  6. 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.
  7. Click + Add New Range to add another range. You can only add up to 10 price range per item.
  8. Click Save.

    Volume Pricing

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:

  1. Click the Update Ranges in Bulk option on the top right side of the items table.

    Update ranges option
  2. Mark the checkbox near the items to select them.

  3. Click the Update Ranges in Bulk button at the top of the item table.

    Update ranges button
  4. Enter the Start Quantity, End Quantity, and the markup or markdown percentage.

  5. Click + Add New Range to add another range. You can only add up to 10 price ranges.

  6. Click Update, then click Save.

    Update button

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 range, the default price will be applied.


Apply Price List

You can associate a price list to:

Apply Price List to a Customer or Vendor

To associate a price list to a customer or vendor:

  1. Go to the Customers/Vendors module in the sidebar.
  2. Create a new contact or edit an existing contact.
  3. Go to the Other Details tab.
  4. Choose a price list to apply to the customer or vendor.
  5. Click Save.

    Associate price list to a customer

Apply Price List on a Transaction

To apply price list on a transaction:

  1. Create or edit a transaction (SO, PO, Invoice, Bill).
  2. Click the Price List dropdown located above the Item Details section.
  3. Choose a price list to apply to this transaction.
  4. Select a price list to apply it to the entire transaction or to each item in a transaction.
  5. Click Save

    Note: Default rates will be applied for the items that are not present in the price list.

    Associate price list to a transaction

Apply Price List to an Item in a Transaction

To access the option to apply price lists to individual items in a transaction, you must first enable it under Settings > Preferences > Items.

After enabling the option:

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

Import Price List

Since we support two kinds of price lists- one for sales and one for purchase transactions, we have also provided separate import options for both. To import a price list:

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Click the Hamburger icon in the top-right corner of the page.
  3. Choose the Import Sales Price List or Import Purchase Price List option from the drop-down.

    image of accessing a price list import option

  4. You will be redirected to the price list import page.

  5. To help you prepare your import file, please download the Sample File from this page and arrange your data according to this file.

  6. Click on the Choose File button, browse and upload your .CSV or .TSV import file containing your price lists.

  7. Select the Character Encoding as applicable. By default, the UTF-8 (Unicode) will applied.

  8. Select the necessary File Delimiter(comma or semicolon).

    price lists import page
  9. Clicking on Next button will take you to the field mapping interface on a new page.

    price lists mapping fields page
  10. Zoho Inventory automatically matches similar fields between the app and the file.

  11. If needed, you can also manually match and map them.

  12. Check the option Save these selections for use during future imports to automate future mapping process.

  13. Click Next to proceed.

    price lists import preview
  14. In the preview page, you can view the status of price lists ready for import, no. of skipped records and unmapped fields.

    • If you wish to make any changes, click the Previous button.
    • To complete the import process, click Import.

Edit Price List

To edit a price list:

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Hover your cursor over the preferred price list.
  3. Click the Edit option.

    image of price list edit icon
  4. Update the necessary information and click the Save button to finish.


Delete Price List

To delete a price list:

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Hover your cursor over the price list that you wish to delete.
  3. Click the Trash bin icon. This will be followed by a confirmation pop-up.

    Image of deleteing a pricelist
  4. Click Ok to delete the price list. Please note that this process is irreversible.


Export Price Lists

To export price lists,

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Click the Hamburger icon in the top-right corner of the page.

    image of accessing a price list export option

  3. Choose either the Export Sales Price Lists or Export Purchase Price List option from the drop-down.

  4. This will trigger an export price lists pop-up bearing all the necessary fields.

    image of the price lists export page

  5. The Entity field will by default be Sales Price Lists or Purchase Price List based on your selection.

  6. Select the export file format accordingly - as .XLS or .CSV using the Export As field.

  7. To finish, click on the Export button.

  8. The file will be saved to your default downloads folder.


De-activate Price List

You can make your existing price list active or inactive.

To de-activate a price list:

  1. Expand the Items module in the sidebar and go to Price Lists.
  2. Hover your cursor over an active price list that needs to be de-activated.
  3. Click on the Mark as Inactive option on the right of your price list.
  4. Now this price list becomes inactive.

    image of deactivating an active price list

To re-activate an inactive price list,

  1. Navigate to the Price Lists module under Settings.
  2. Hover your cursor over the inactive price list.
  3. Click on the Mark as Active option to the right of the price list.
  4. Doing this, will reactivate this price list.

Configure Access Permissions

  1. Go to Settings > Users & Roles > Roles.
  2. Edit an existing role or create a new role.
  3. Go to Items.
  4. Next to the Price List label, select the permissions you’d like to provide the users associated with this role.
  5. Click Save at the bottom.

    Zoho Inventory web page

Create customized pricing for your best customers and vendors with price list
TOP