Setting up inventory products
When you first start using Bar Cop, you need to setup your products. Products are broken down into 6 main categories: liquor, wine, bottle beer, draft, beer, food, and miscellaneous. *If you do not want to track a specific type of product, then you will not use that category.
There are two main reasons do this:
1) The order that your products are placed in product setup will be the same order they are 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) Your inventory locations are setup independently. In these areas you can put your products in the exact order that they are placed on 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 easier to find products in the drop-down list when they are 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).
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.
Continue from one column to the next entering your product information. You can enter information by manually typing it in, using voice command (see voice command data entry) to enter any numerical data only, and paste your product data into Bar Cop from an outside Excel spreadsheet (see how to copy and paste data). *If copying product names from Excel, sort them into alphabetical order in your Excel spreadsheet before pasting the data into Bar Cop.
Product vendor names are added to the drop-down list by clicking on the gear icon.
Vendor names, product sizes (ie. bottle size, keg size, case size), and density are entered by selecting the correct option from the drop-down menus. *You can use copy and paste (see how to copy and paste data) to quickly enter duplicate data entries.
Note: Each product can only be entered into setup one time with a standard pour (or serving) size and regular price. If you have pour size variations and they are cost out correctly based on the size and regular price entered in setup, then theoretical sales and variance data will be calculated accurately. If size variations are not cost out correctly, then sales adjustments (see entering sales adjustments) should be made to avoid getting inflated variance and theoretical sales numbers. To cost out pour size variations, drink mixes, and food plates correctly, use the pricing tool (see using the pricing tool).
When you are finished setting up your products, you product setup will look similar to this. *Setup will look slightly different if you are not weighing products and/or depending on what product section you are setting up.
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 setting up inventory locations).Have any questions? Contact us.