## Zoho Billing - Product, solutions, integrations, support, and resources Index Access the complete documentation index at: https://www.zoho.com/qa/billing/llms.txt Use this file to discover all available documentation pages before proceeding. # Price Lists A simple analogy to understand price lists is to think of them as coupons that only you can apply to a specific set of customers or a set of items to either increase or decrease the price of the items. On applying them to a transaction or customer, the rate of the item changes. Let’s look at how price lists help David in his business. **Scenario:** David sees 10x growth in his business. He decides to celebrate it by giving 10% discount to all his new customers. He creates a price list with 10% markdown in Zoho Billing and applies it to the contact he creates for new customers. Whenever he creates an invoice for the new customers, the prices are slashed by 10% automatically and his customers enjoy the discount. **Scenario:** During the festive season, David wants to offer a 25% mark-down on all the services. So, he creates a festive offer price list with 25% markdown on services. He applies them to invoices and provides services at a lower price which boosts customer satisfaction. Price list is a list containing a set of different prices for the items you sell. The prices in the price list can be higher or lower to the normal price lists based on your preference and you can create multiple price lists. Also, you can associate the price lists to transactions or customers and the different pricing will be applied to them. If you do not associate any price list, then the normal price would be charged. In other words, price lists allow you to change the prices of the items in bulk by a certain percentage or change them item-wise. Also, you can sell items to your customers with item rates in their local currency by creating price lists in a foreign currency. ## Enable Price Lists Before you can use price lists in Zoho Billing, you need to enable them in **Item Preferences**. To enable price lists: * Go to **Settings** from the top-right corner. * Select **Products** under _Product Catalog_. * Mark **Enable Price Lists**. * Click **Save**. ![Enable Price Lists](/billing/images/help/images/product-catalog/enable-pricelists.png) Now you’d have enabled the price lists feature in Zoho Billing. This allows you to create and apply them to transactions and customers. ## Add Price Lists There are two ways to add price lists: * [Creating New Price Lists](/qa/billing/help/product-catalog/price-lists.html#creating-price-lists) * [Importing New Price Lists](/qa/billing/help/product-catalog/price-lists.html#importing-price-lists) ### Creating New Price Lists To create new price lists: * Go to the _Price Lists_ module in the left sidebar. * Click the **+** in the module name or the **\+ New Price List** button in the top-right corner. * Enter a name for the price list. * Choose if you want to change the item rates by a percentage or individually for each item: * Select [**Markup or Markdown the item rates by a percentage**](/qa/billing/help/product-catalog/price-lists.html#markup-markdown-item-rates) to change the item rates by a percentage. * Select [**Enter the rate individually for each item**](/qa/billing/help/product-catalog/price-lists.html#enter-rate-individually) to enter the item rates individually. Also, using this option, you can add item rates in a foreign currency to sell subscription items to overseas customers in their local currency. ### If you’ve selected to markup or markdown by a percentage: * Select if its **Markup** or **Markdown**. * Enter the percentage at which you want to increase or reduce the rate of the items. * Choose how you want to round off the item rate from the **Round Off To** dropdown. * Enter a description about the price list for internal use. * Click **Save**. ### If you’ve selected to enter the rate individually for each item: * Select the currency in which you want the new item rates to be. * Enter the item rate for each item in the table below. * Enter a description about the price list for internal use. * Click **Save**. ![New Price List](/billing/images/help/images/product-catalog/new-price-list.png) ### Importing New Price Lists Zoho Billing allows you to import price lists from your previous system so you don’t have to create each price list separately. To import price lists: * Go to the _Price Lists_ module in the left sidebar. * Click the **Hamburger** icon in the top-right corner and select **Import Sales Price Lists**. ![Import Sales Price Lists](/billing/images/help/images/product-catalog/import-price-lists.png) * Download the sample file and compare it with your file. Make sure that the format in your file is similar to the sample file.  * Click the **Choose File** button and select the import file from your device.  * Choose whether to skip or overwrite duplicate items.  * Select the **Character Encoding** based on your import file. By default, UTF-8 (Unicode) is selected.  * Choose the appropriate **File Delimiter**.  **Insight:** File Delimiter refers to the character that is used to separate the values in the import file.  * Click **Next**.  ![Import-Select File](/billing/images/help/images/product-catalog/import-select-file.png) * The field names of Zoho Billing Price List are listed on the left side and the field names in the import file are listed on the right side.  * Match the field names appropriately.  * Check the **Save these selections for use during future imports.** option if you wish to use the same mapping of fields in future imports.  * Click **Next**.  ![Import-Map Fields](/billing/images/help/images/product-catalog/item-pricelists-map-fields.png) * You can see the status of the **sales price lists that are ready to be imported**, **skipped** and the **Unmapped Fields**. If there are items that are being skipped, edit the import file and repeat the above steps.   * Click **Import**. ![Import-Preview](/billing/images/help/images/product-catalog/item-pricelists-preview.png) Now, the sales price lists in the import file will be imported into the **Price Lists** module of Zoho Billing. You can [associate the imported price lists to customers](/qa/billing/help/product-catalog/price-lists.html#associate-contact) or [associate them to transactions](/qa/billing/help/product-catalog/price-lists.html#associate-transaction). ## Set Volume Pricing Volume Pricing is a type of pricing scheme where you can define a unit price for an item based on the quantity sold. That is, you can set price breaks for items depending on their quantity. This is mostly used to offer discounts for bulk purchases. For example, if a customer purchases only 10 units of product A, you can set each item’s price at $15; but if they purchase over 11 units, then you can set the price at $13 each, and so on. This method also helps you sell slow-moving or excess stock quickly. In Zoho Billing, you can set custom rates for the different quantity brackets. Here’s how: * Go to the _Price Lists_ module in the left sidebar. * Click the **\+ New Price List** button on the top-right corner. * Enter an appropriate name for the price list. * Select **Enter the rate individually for each item**. * Select **Volume Pricing** as the Pricing Scheme. * 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 range per item. * Click **Save**. ![Set Volume Pricing](/billing/images/help/images/product-catalog/volumepricing-pricelist.png) ## Edit Price Lists You can edit and update the price lists you’ve added to the **Price Lists** module. If you’ve already associated a price list and it is used in a transaction, you can still edit it. However, the previous transactions will not be affected by the change. To edit a price list: * Go to the _Price Lists_ module in the left sidebar. * Hover the mouse cursor over the price list you want to edit and click **Edit** that appears on the right side. ![Edit Button](/billing/images/help/images/product-catalog/edit-button-pricelists.png) * Edit the price list. ![Edit Price Lists](/billing/images/help/images/product-catalog/edit-price-lists.png) * Click **Save** to save the changes. ## Associate Price Lists After you add price lists, you can associate them to transactions and customers. Associating price lists can be very useful in many scenarios. Let’s look at how it helps David. **Scenario:** As David's business grew, customers from the neighbouring country reached out to him to purchase his subscription items. And David realises that it'll make his customers happy if he can invoice them with item rates in their local currency. Immediately, he creates a price list with item rates in his customer's local currency. He associates the price list to his customers in the neighbouring country and every time he creates a transaction for them and adds the items, the item rates are in their local currency. Thus, David's customers are happy doing business with him and his business grows.  * [Associating a Price List to a Customer](/qa/billing/help/product-catalog/price-lists.html#associate-contact) * [Associating a Price List to a Transaction](/qa/billing/help/product-catalog/price-lists.html#associate-transaction) ### Associating a Price List to a Customer You can associate a price list to a customer while creating a customer or later by editing them. To associate a price list to a customer: * Go to the _Customers_ module in the left sidebar. * Select the customer to which you want to associate a price list. * Click the **Edit** button in the top-right corner of the window. ![Associating Price List to Customer](/billing/images/help/images/product-catalog/associate-pricelists-customer.png) * Scroll down, select the **Price List** dropdown under the **Other Details** tab and select the price list that you want to associate with the customer. **Insight:** Make sure that you've enabled Price Lists feature in Item Preferences to see the \*\*Price List\*\* dropdown for the customer. Also, make sure that you've created price lists before you can associate them to a customer. * Click **Save**. Now, whenever you create a transaction for this customer, this price list will be automatically applied. However, you can change the price list while creating a transaction, if you want to. ### Associating a Price List to a Transaction You can associate a price list to an estimate or an invoice while creating them or while editing them. To associate a price list to a transaction: * Go to the _Estimates_ or _Invoices_ module. * Click the **\+ New button** to create a new transaction or select an already existing transaction and click the **Edit** icon. * Click the **Price List** dropdown above the item table on the left side and select a price list. The rates of the items will be updated as per the rates of the price list. * Fill in the other details and click **Save as Draft** or **Save and Send**. ![Associating Price List to Transactions](/billing/images/help/images/product-catalog/associate-pricelists-transaction.png) ## Manage Price Lists You would have created price lists for a festive season and wouldn’t need it after the season has passed. In similar circumstances, when you don’t need price lists for a particular season, you can mark them as inactive. Also, you can delete price lists if you wouldn’t need them any more. * [Mark Price Lists as Inactive](/qa/billing/help/product-catalog/price-lists.html#marking-inactive) * [Delete Price Lists](/qa/billing/help/product-catalog/price-lists.html#deleting-pricelists) * [Export Price Lists](/qa/billing/help/product-catalog/price-lists.html#exporting-pricelists) ### Mark Price Lists as Inactive * Go to _Price Lists_ module in the left sidebar. * Hover your mouse cursor over the price list that you want to mark as inactive and click the **Mark as Inactive** text. ![Mark Price List Inactive](/billing/images/help/images/product-catalog/mark-inactive.png) Now, the price list will be marked as inactive and will not show up in transactions or contacts when you want to associate a price list. After you’ve marked a price list as inactive, you can mark it as active again. To mark an inactive price list as active: * Go to the _Price Lists_ module in the left sidebar. * Hover your mouse cursor over the price list that is inactive and click the **Mark as Active** text. ![Mark Price List Active](/billing/images/help/images/product-catalog/mark-active.png) The inactive price list will be marked as active and the price list will be available when you want to associate it to a customer or a transaction. ### Delete Price Lists You can delete the unnecessary price lists in Zoho Billing easily. However, once you delete a price list, it will no longer be available and it cannot be retrieved again. To delete a price list: * Go to the _Price Lists_ module in the left sidebar. * Hover your mouse cursor over the price list that you want to delete and click the **Trash** icon. ![Delete Price Lists](/billing/images/help/images/product-catalog/delete-pricelists.png) * Click **OK** to confirm the delete. ![Delete Price Lists Confirmation](/billing/images/help/images/product-catalog/delete-pricelists-confirm.png) **Insight:** You cannot delete a price list if it is already associated with a customer or a transaction. ### Export Price Lists You can export the price lists that are present in Zoho Billing in CSV _(Comma Separated Values)_ or XLS _(eXceL Spreadsheet)_ formats. To export price lists: * Go to the _Price Lists_ module in the left sidebar. * Click the **Hamburger** icon and select **Export Sales Price Lists**. ![Export Sales Price Lists](/billing/images/help/images/product-catalog/export-sales-pricelists.png) * If you want only specific fields of the price lists to be exported, you can specify them by clicking the dropdown under **Fields in Export File** and selecting **\+ Add New** to create a new template. * Enter a **Template Name**. * Click **Add a New Field** to select the fields that you want in the export file. * Also, you can edit the **Field Name** that will be displayed in the export file. * Click **Save and Select**. ![New Export Template](/billing/images/help/images/product-catalog/export-pl-template.png) * Select the format in which you want the price lists to be exported: **CSV** or **XLS**. * Click **Export** and save the file in your device. ![Export Price Lists Confirmation](/billing/images/help/images/product-catalog/export-pl-confirm.png) **Insight:** You can export a maximum of only 25,000 rows at a time. If there are more than 25,000 rows of price lists, you can export them with mutiple attempts. ## Disable Price Lists At any point in time, you do not want to use price lists in Zoho Billing, you can disable the price lists feature. To disable the price list feature: * Click the **Gear** icon in the top-right corner of the window and select **Preferences**. * Select the **Items** tab. * Uncheck the **Eable Price Lists** option under **Price Lists**. * Click **Save**. ![Disable Price Lists in Preferences](/billing/images/help/images/product-catalog/disable-prefernces.png) Alternatively, if you’re in the **Price Lists** module: * Click the **Hamburger** icon and select the **Disable Price Lists** option. ![Disable Price Lists Option](/billing/images/help/images/product-catalog/disable-pricelist.png) * * *