Import your product list from a distributor or POS file.
Your distributor emails you a full product list every week, with your costs and pack sizes on it. Drop that file in and Bar Cop builds your product list from it automatically. Drop file, review, add, and done.
How to import your products.
One file can hold your kegs, your cases and any other product type at once, and Bar Cop sorts them out on the way in. The category you start on only tells it what to expect, it does not lock the file. You see every product, and the category it is going to, before adding a single one.
Start with any category.
Pick the category closest to what you are bringing in and hit its upload list button, then drag the file and drop it on the file zone or browse to upload it. Selecting a product category only tells Bar Cop what to expect. It does not lock the file to one category, so an order guide with kegs and cases in it can still be uploaded, reviewed and added in.
It reads your column headings.
Item Description lands on Product Name, Supplier on Primary Vendor, Std Pour on Pour Size. You only see the fields it actually found in your file, and if there is a column not read, it names that column instead of leaving you to spot it. The preview shows you the first 3 rows of the file being imported so you can see how the columns are mapped.
Check it all before anything saves.
One beer order guide came in as nine bottles and eight kegs, sorted by reading the pack column, without you choosing anything. You open a group to check it, select and move anything to another category if needed, and remove the rows that are not products. Nothing is saved into a category until you press the Add button.
Products land in the right category.
Each product goes onto the tab for its own category with the fields that category needs. Anything still missing, a location, a cost or a size is marked in red, so nothing sits there half finished. You can click edit in a product row to add missing information one at a time or bulk edit products all together that share the same missing data.
No template to match.
There is no template to conform to and no file to clean up first. These are real headings off a distributor order guide, and where each one lands in Bar Cop. Bring whatever else your file has and anything Bar Cop needs will be imported from it.
| The heading in your file | Where it lands in Bar Cop |
|---|---|
| Item Description | Product Name |
| Supplier | Primary Vendor |
| Case Cost | Cost per Case |
| Std Pour | Pour Size |
| Retail | Menu Price |
| Par Stock | Par Level |
| Bottles Per Case | Case Size |
| Keg Size | Keg Size (oz) |
A 750 ml or a 1.75 L in your size column comes across as ounces, so your pours per bottle and your pour cost are right the moment the list lands. A size it cannot convert is left empty rather than guessed at, because a wrong number that looks right is worse than a blank.
Every file drop works this way.
Every place Bar Cop takes a file works exactly like this one: the same box to drop it on, the same reading of your column headings, and the same review before anything is saved. Once you have imported your products, you already know how to import sales, hours and tips.
Your POS Sales
Drop the sales report your POS already exports and the week's numbers land, down to the item and the server. Works with your POS.
Your Menu
Build and cost your drinks and dishes off a POS item list instead of typing a few hundred menu items in one at a time.
Your Staff And Hours
Bring your roster over in one drop, then drop your weekly timeclock export to log the hours you actually paid for.
Your Vendors And Bills
Your vendor list comes across the same way, and so does an expense file, so your operating costs are not a retyping job either.
Your Voids And Comps
Drop your POS voids and comps export instead of keying them in, and they land in the log your loss review reads.
Your Cash Drawers
Drop the cash or drawer report your POS prints and the day lines up against what it says you should have taken.
Drop your own list in.
Questions about importing files.
What operators ask before they put their product list into something new.