One of the best ways you can save on your weekly grocery bill is to use a pricebook. A pricebook is essentially a listing of historical prices for the items you buy at the grocery store. Using this listing you can compare the current price to what you have paid in the past.
The idea is that you will know what the lowest price you paid for any particular item is. If you then shop with the mindset that you will not pay any more than the lowest price you have paid in the past, you will save.
I find this particularly useful in timing sales on meats, I know that the lowest price I have paid for Pork Loin is $1.99/lb and regularly goes on sale at that price. I don’t buy it unless it is that price and when I buy it I purchase enough to last until the next sale.
You will want to make sure you determine the price per unit and bring a calculator to the market as you will want to compare the unit price, not the overall price.
A typical price book looks like the following:
| Date | Product | Store | Price | Size | Price per unit |
| 02/27/2009 | Apple Juice | Wal-Mart | $2.40 | 48oz | .05 per oz |
| 03/01/2009 | Apple Juice | Kroger | $2.90 | 48oz | .06 per oz |
You could use an excel spreadsheet to track this information, or you could just use an old fashioned notepad. There are several resources where you can print pricebook pages, just do a google search for printable pages.
I have taken this one step further and created a shopping database for tracking all shopping costs as well as coupons. I have provided my database, while it is not feature complete it works. You can enter you prices as well as prices from local ads. You can also input your coupons and shopping list to generate a shopping list which shows the lowest price for each item, the store, and any available coupons. I have not been able to complete it maybe if I get enough interest I will do a little more work on it to make it complete.
SuburbanDollarPricebook.mdb.zip
MD5Sum(ba3da8a20ae09303cef1600f064e4f12)
You will have to enable macro’s to get it to work, so you are going to have to trust me. Let me know what you think or any improvements you would like to see and I will work on making the updates.
Please feel free to adapt this and use it but you may not sell it or use it for profit. Also be a chum and give me some credit.
Photo: (ralphbijker)
{ 2 trackbacks }
{ 5 comments… read them below or add one }
I’ve never heard of a pricebook before. My method was to simply take pictures of products with my iPhone to compare prices. I’m not disciplined enough to keep a pad and paper with me when I go grocery shopping,but as soon as I figure out how to edit spreadsheets on my phone I’ll start doing this. Thanks for the tip!
Hey cool! I tried to do this for a while and then ran out of energy for it…. I’ll have to take this as inspiration to start again. Thanks for the resource!
I’m sending this post to my wife to see if she’s up to it since she does most of our grocery shopping
Thanks! This is great. I’m not super savvy with Databases, but I’ll give it a try–if it works on my smartphone that would be PERFECT.
Thanks again,
Jessica
couldn’t figure out how to look at your data :{