Setting up your products

When you first start using Bar Cop, you need to setup your products (*we can help get your products setup for free). Products are broken down into 6 main categories: liquor, wine, bottle beer, draft, beer, non-alcohol, and food. *If you do not sell a specific type of product, then you will not use that category. To start, click "Products" from the main menu.

IMPORTANT - We highly recommend putting products in alphabetical order in product setup.

There are two main reasons do this:

1) The order that your products are placed in product setup, is the same order your products will be listed in most of the program: reports, purchases, orders, pricing, data entry forms, etc. It is much easier to find products in these places when they are entered alphabetically.

2) The storage areas and inventory locations are setup independently. In these areas you can put your products in the exact order that they are on the shelves. To do this, you will use drop-down lists that are populated with the products exactly as they are entered in product setup. It is much easier to find products in the drop-down list when in alphabetical order.

Let's start setting up your products.

When you first go to "Product Setup", your product category sections will be blank. You can add product rows to each category section as needed (see adding and deleting rows).

Bar Cop adding new products 1

For Bar Cop to function correctly, it needs to know basic information about the products you will be selling. Columns you enter information into will be light grey in color. White columns are automatically populated by the software. At the top of each column is the column header ie. "Liquor Products", "Bottle Cost", "Pour Size", etc. To find out what data to enter into each column, click the column header and an information box will open with a description and example.

Bar Cop add products 2

Continue from one column to the next entering your product information. You can enter information by manually typing it in, using voice command to enter any numerical data, and simply copy/paste your product data into Bar Cop from an outside source like text file, CSV file, or Excel spreadsheet (see how to copy and paste data).

Bar Cop adding products 3

Data populated in quick drop-down lists like vendor names, bottle sizes, and pour sizes can be added and deleted to the drop-downs by clicking on the gear icon. For example: If you only carry two liquor bottle sizes - 750 ML and Liter, under bottle sizes enter 25.4 in the first space, 33.8 in the second space and delete all other sizes. The bottle size drop-down list will not only give those two size options. *Note: Only enter numerical values for sizes.

Bar Cop setting up products 4

When you are finished setting up your products, the program will look like this.

Bar Cop setting products 8

Once you have setup your products setup in each main category that you are using, you need to do a quick customization of your inventory locations (see inventory locations setup).

Things to know:

1) A product name can only be entered into product setup one time. If you carry the same product brand in different sizes, the product names need to be entered with a slight variation. For example: If you carry 750 ML and 1.75 Liter bottles of the same product, enter one product name as "Brand Name 750" and the other product name as "Brand Name 1.75".

2) When you add or delete products in the future, this is done in product setup (see adding and deleting products).

3) Inventory locations are setup independently from product setup. However, the product setup lists are used in these sections through drop-down menus to arrange your products exactly like they are on the shelves (see inventory locations setup).

4) You can enter your product setup data using voice command (see using voice command), with the exception of product names. For example: Using voice command to enter Dewars will input "doers" in the cell. So if you are using voice command, expect that you will need to type in product names or paste them from an outside source and then the rest of the product information can be entered using your voice.

5) When setting up your products, remember to save regularly (see saving inventory files).

Have any questions? Comment below or contact us.
Ready for better inventory management?
  Get Started Free