Price Lists:
Price lists are lists of prices of items on sale. They can be used to mass control/modify your item prices for a specific customer/vendor or transaction.
Guide Layout:
- Why price lists?
- Unlocking price lists
- Creating a price list
- Markup/Markdown by Percentage
- Entering Item Rates Individually
- Creating a price list in foreign currency
- Importing a price list
- Get the sample file
- Upload your import file
- Map all fields
- Preview & import
- Editing a price list
- Deleting a price list
- Exporting a price list
- De-activating & Re-activating a price list
Why price lists?
To understand price lists better, lets see an example. Assume that you have 5000 items in your inventory, and you wish to give a 10% discount for Christmas or a summer sale. To do this, it would be unfeasible to edit the prices of all your items every time and overwrite your items.
You can overcome this situation using Price Lists. You can create price lists for each and every situation or case and apply them to your contacts(customer or vendor) or transactions and accordingly have your item prices altered for those customers or orders.
Summing it all up, a price list can be used to:
- Offer products regularly at a lesser price for 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.
- Offer products at a much lesser price for valuable prospects.
- Assign to vendors who provide regular or occasional offer on items.
Areas of Application:
You can associate a price list to:
- a contact - can be a customer or vendor.
- a particular transaction - sales order, invoice, purchase order and even a bill.
Unlocking price lists
To enable price lists,
- Click on the gear icon(Settings) from the top-right corner.
- Select Preferences from the drop-down.
- You will redirected to the Preferences module under settings.
- Select the Items tab under Preferences.
- Under item preferences, check the box adjacent to the Would you like to enable Price Lists?: option.
- Click on the Save button.
- Doing this will cause the app to refresh and will unravel the Price Lists module under the settings.
- Hence forth you can also access the Price Lists module from the gear icon(Settings) drop-down.
- Creating your very first price list, will unlock a Price List field for all your Contacts, Sales Orders, Invoices, Purchase Orders and Bills where you can associate a price list of your choice to that entity.
Creating a price list
To create a new price list:
- Click on the gear wheel(Settings) icon from the top-right corner.
- Select the option called Price Lists in the drop down.
- You will be directed to the Price Lists module under Settings.
- Click on the + New Price List button from the top-right.
- You will be redirected to a new price list page.
- Provide a Name for your price list.
- 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.
- Choose how you want to control the Item rate. You can do so in two ways:
- by percentage
- by entering the rate individually for each item.
Depending on the choice, the price list creation process will differ significantly.
Choice 1 - Markup/Markdown by Percentage:
- On choosing by percentage, proceed to the Percentage field.
- Choose whether you wish to markup or markdown and enter the percentage of the cost that you want to mark up or markdown.
- Configure how your prices must be rounded off to, by entering the round off value.
- Add a Description for your price list.
- To finish, click on the Save button.
Choice - 2 Entering Item Rates Individually:
- On choosing to enter the rate individually for each item, proceed to the Currency field.
- Choose a currency for the price list.
- Add new rates/prices for your preferred items one by one.
- Next, add a Description for your price list.
- Once you are ready, click on the Save button.
Creating a price list in foreign currency
In Zoho Inventory there are two ways in which a price list can be created -
- Option 1 - By percentage - this price list will allow you to markup or markdown the prices of all your items in your base currency.
- Option 2 - By entering item rates individually - this price list will allow you to alter prices at the item level and it also gives you the ability to assign a currency for the prices on this list. Hence if you wish to create price lists in foreign currency, this is the option for you.
Learn how to create price lists.
Importing a 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:
- Click on the gear wheel(Settings) icon from the top-right corner.
- Select the option called Price Lists in the drop down.
- You will be directed to the Price Lists module under Settings.
- Select the other gear wheel icon that is adjacent to the + New Price List button.
- Choose the Import Sales Price List or Import Purchase Price List option from the drop-down.
- 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 on the Choose File button, browse and upload your .CSV or .TSV import file containing your price lists.
- Select the Character Encoding as applicable. By default, the UTF-8 (Unicode) will applied.
- Select the necessary File Delimiter(comma or semicolon).
- Clicking on Next button will take you to the field mapping interface on a new page.
- Zoho Inventory 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 future mapping process.
- Clicking on Next will redirect you to the import preview page.
- Here one can view the status of price lists ready for import, no. of skipped records and unmapped fields.
- If you wish to make any changes, you can bolt back by clicking on the Previous button.
- To complete the import process, click on the Import button.
Editing a price list
To edit a price list:
- Click on the gear wheel(Settings) icon from the top-right corner.
- Select the option called Price Lists in the drop down.
- You will be redirected to the Price Lists module under Settings.
- Hover your cursor over the preferred price list.
- Click on the Edit option to the right of your price list.
- The edit price list window opens up bearing all the fields.
- Update the necessary information and click on the Save button to finish.
Deleting a price list
To delete a price list:
- Click on the gear wheel(Settings) icon from the top-right corner.
- Select the option called Price Lists in the drop down.
- You will be redirected to the Price Lists module under Settings.
- Hover your cursor over the price list that you wish to delete.
- Click on the Trash bin icon to the right of the price list.
- This will be followed by a confirmation pop-up.
- Click on the Ok button to delete the price list.
Please note that this process is irreversible.
Exporting price lists
Similar to import, we have provided separate export options for sales and purchase price list. To export price lists,
- Click on the gear wheel(Settings) icon from the top-right corner.
- Select the option called Price Lists in the drop down.
- You will be redirected to the Price Lists module under Settings.
- On this page, click on the other gear icon that is adjacent to the + New Price List button.
- Choose either the Export Sales Price Lists or Export Purchase Price List option from the drop-down.
- 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 or .CSV using the Export As field.
- To finish, click on the Export button.
- The file will be saved to your default downloads folder.
De-activating & Re-activating a price list
You can make your existing price list active or inactive.
To de-activate a price list,
- Navigate to the Price Lists module under Settings.
- Hover your cursor over an active price list that needs to be de-activated.
- Click on the Mark as Inactive option on the right of your price list.
- Now this price list becomes inactive.
To re-activate an inactive price list,
- Navigate to the Price Lists module under Settings.
- Hover your cursor over the inactive price list.
- Click on the Mark as Active option to the right of the price list.
- Doing this, will reactivate this price list.