How to Make a Product Price List

by Kate Bluest; Updated September 26, 2017
...

Presenting a company product list, especially in business-to-business industries, can be the first step in closing a sale with a new customer. Make sure the list is easy to read, highlights information important to your customers and is well organized. Organize the list by types of products, then alphabetically. You can create your list in a word program if you do not have a spreadsheet program. However, a spreadsheet offers many helpful tools that make it a better choice for a list. You can use spreadsheet tools to find duplicates and sort the list to make it ideal for customer viewing.

Step 1

Open a spreadsheet program like Microsoft Excel, OpenOffice Calc or Google Docs Spreadsheet.

Step 2

Click the “Insert” tab and then click the “Header” icon in the “Header & Footer” section of the “Insert” tab to insert a header in Microsoft Excel. In OpenOffice Calc, click “Format” in the top menu and select “Page” to open the “Page Style” dialog box. Click the “Header” tab, then click the “Edit” button to enter your header information. Google Docs Spreadsheet no longer offers a header, so you can enter the header information at the top of the spreadsheet. Style the information according to your preferences. As an alternative to entering the header, print the price list on company letterhead, but be sure to include any necessary information not printed on the letterhead. Items to include in the header for the product list are the company logo, name, address, telephone, fax, website and email address. Include clear instructions on whom to contact to make a purchase.

Step 3

Enter your labels for the data you will include in your price list in the top row after the header. Consider the information your customer will need to buy your products when you create these headers. Recommended headers include “Product ID,” “Product Name,” “Product Description,” “Product Dept.” and “Price.” Also, include columns for information a customer may want to know before making a purchase. For example, if you are selling stoves, people will want to know at a glance if the stove is gas or electric, so include a column for distinctions of that nature. Fill in your product information.

About the Author

Based in New York, Kate Bluest has been writing for various online publications since 2005. She has participated in several writing workshops, including the MIT Writing Workshop. Bluest holds a Bachelor of Science in business administration from SUNY Empire State College.

Photo Credits

  • Jupiterimages/Comstock/Getty Images