Making a Pricebook
Results 1 to 14 of 14
  1. #1
    Registered User mcphlips's Avatar
    Join Date
    Feb 2006
    Location
    New York
    Posts
    772
    Post Thanks / WTG / Hug
    Rep Power
    9

    Default Making a Pricebook

    I think I need to start a price book for grocery shopping, and I was wondering if anyone out there does this? If so, how do you set yours up?

    Do you do it by grocery store layout, item or some other way?
    I usually shop at one grocery store that does tend to have the best prices overall. But sometimes I'll find that a few other stores have what I think are good sales, and unless I run into my regular store and check prices, I'm not sure.
    Any suggestions would be appreciated!

    Think spring!

  2. #2
    Founder Sara Noel's Avatar
    Join Date
    Apr 2001
    Location
    Michigan
    Age
    45
    Posts
    19,023
    Post Thanks / WTG / Hug
    Blog Entries
    10
    Rep Power
    10

    Default

    Item:___________________

    <table border="1" cellpadding="0" cellspacing="0" width="85%"> <tbody> <tr> <td class="Normal" width="181">
    Store Name
    </td> <td class="Normal" width="147">
    Brand
    </td> <td class="Normal" width="88">
    Size
    </td> <td class="Normal" width="114">
    Unit Price
    </td> <td class="Normal" width="117">
    Sale Price
    </td> <td class="Normal" width="121">
    Date of Sale
    </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> <tr> <td class="Normal" height="50" width="181"> </td> <td class="Normal" height="50" width="147"> </td> <td class="Normal" height="50" width="88"> </td> <td class="Normal" height="50" width="114"> </td> <td class="Normal" height="50" width="117"> </td> <td class="Normal" height="50" width="121"> </td> </tr> </tbody> </table>
    Follow me on Twitter!


    Follow me on:
    Pinterest


    A monumental event can happen any day." --Peale
    "Leap and the net will appear. --John Burroughs

    Would the child you once were be inspired by the adult you've become?

  3. #3
    Moderator monkeywrangler71's Avatar
    Join Date
    Oct 2006
    Location
    Nova Scotia
    Posts
    3,898
    Post Thanks / WTG / Hug
    Blog Entries
    9
    Rep Power
    26

    Default

    Sara, do you have a separate page for each item?
    I don't want to go to the store with a giant binder. How big is your book?

  4. #4
    Registered User
    Join Date
    Feb 2007
    Posts
    580
    Post Thanks / WTG / Hug
    Rep Power
    8

    Default

    I have a Mead brand ruled index cards booklet (3x5 in) w/ 50 cards in it, cost about $2.50. I only put up items I buy often, like this:

    Milk (organic)

    Costco $2.80
    Giant $--
    Food Lion $--
    Whole Foods $---
    Trader Joe's $---
    Bloom $---

  5. #5
    Founder Sara Noel's Avatar
    Join Date
    Apr 2001
    Location
    Michigan
    Age
    45
    Posts
    19,023
    Post Thanks / WTG / Hug
    Blog Entries
    10
    Rep Power
    10

    Default

    Initially, you need to compare stores and prices. Instead of bringing the binder, just bring index cards or tiny spiral bound notebook. (think address book size) Or, you can start with just your receipts and fill in the name, store, and prices first and fill in the units later if you want to.

    You can use sales fliers for sale prices and see if there's a cycle to when things go on sale too. Most are available online.

    This can take months to get a good price book created.

    I don't use a pricebook anymore. I don't really need to. My grocery list is pretty streamlined and rarely changes unless I choose to add something new. I've been doing my own system long enough that I know which stores are cheaper for the items I use with the exception of sales and if there is a sale, I stock up.

    So, you get your information and can transfer it to your pricebook if you don't feel comfortable carrying anything full sized.

    If you only have 4 stores in your area to choose from, then you can put more items per printable page or create and use a sheet or spreadsheet without as many rows.
    Follow me on Twitter!


    Follow me on:
    Pinterest


    A monumental event can happen any day." --Peale
    "Leap and the net will appear. --John Burroughs

    Would the child you once were be inspired by the adult you've become?

  6. #6
    Moderator IntlMom's Avatar
    Join Date
    Jan 2007
    Location
    I.O.W.A.!!!!!
    Age
    44
    Posts
    3,714
    Post Thanks / WTG / Hug
    Blog Entries
    3
    Rep Power
    25

    Default

    My price book is pretty "old-fashioned" in the way that I do it, but it works just great fo me. I have a small sprial notebook (the pocket size). Every page has a letter on top of it, and I wirte the items that start with the price on that page. I have several P pages, b/c I seprated my produce by type (fruits. veggies) and M pages (different kinds of meat - chicken has a page, as does meatl, produce and various). Anyway, I just write everything in pencil and then if a lower price shows up, just erase and put the new info in. My colums look like this:

    Item Unit size Price Date Store

    I have to write very small, and I realize that this is a very old fashioned way to do this, but it serves its purpose quite nicely for me!
    :

    Traci

    dh 20 years
    ds 14 ~ Russia
    ds 14 ~ Russia
    dd 6 ~ China

  7. #7
    Registered User kaykwilts's Avatar
    Join Date
    Jun 2002
    Location
    Ruston, LA
    Posts
    3,298
    Post Thanks / WTG / Hug
    Rep Power
    16

    Default

    I tried to start one years ago but gave it up. I rely a lot on my memory but would probably do better if I attempted to do the price book again.

  8. #8
    Registered User jinx's Avatar
    Join Date
    Oct 2006
    Location
    massachusetts
    Age
    52
    Posts
    419
    Post Thanks / WTG / Hug
    Rep Power
    8

    Default

    I dont really have a price book. I shop at a market basket supermarket that just about beats all the others in prices. For the most part my list doesnt change that much. especially for basics, so I know the prices from memory.
    What I write the prices for are the sale items that I would like from each of the 3 supermarkets near me. I am not beyond returning something to a supermarket, if I find it cheaper at another. I took back (2) 8 count bounty papertowels that dh bought2 for 10.00 I found a twelve count scott for 2.00 less (2 for 8.00)

  9. #9
    Frugal Expert cara-lynne's Avatar
    Join Date
    Feb 2007
    Location
    southeastern michigan
    Age
    96
    Posts
    52
    Post Thanks / WTG / Hug
    Rep Power
    0

    Default

    i tried to do one years ago also. but it did not work out very well! with these ideas, i think i will try again...

  10. #10
    Registered User mcphlips's Avatar
    Join Date
    Feb 2006
    Location
    New York
    Posts
    772
    Post Thanks / WTG / Hug
    Rep Power
    9

    Default

    Thank you to all for the info.
    I am also pretty streamlined about what I buy, but recently I have noticed that our Price Chopper has had a few items on sale that I would normally buy at Wegmans, and they are cheaper. I may just need to start monitoring Price Choppers sales flyer a little better.
    I think I'm going to use the Price book to write down the sales items and see where I can get a better deal and stock up on some items.

  11. #11
    Moderator monkeywrangler71's Avatar
    Join Date
    Oct 2006
    Location
    Nova Scotia
    Posts
    3,898
    Post Thanks / WTG / Hug
    Blog Entries
    9
    Rep Power
    26

    Default

    I'm going to start one as well, but I don't want to use all that paper. I have a database on my palm pilot, but there is no desktop version for the mac, so if I did it in there I would have to type the whole thing up in the handheld. I was keeping track in a little date book, but it's too mixed up to refer back to. I'm going to have to do some more thinking.

    I was going from memory, but lately I've noticed prices seem to be up and down and all over the place, and I can't keep track anymore.

  12. #12
    Registered User mcphlips's Avatar
    Join Date
    Feb 2006
    Location
    New York
    Posts
    772
    Post Thanks / WTG / Hug
    Rep Power
    9

    Default

    Well I'm disappointed.
    I was going to start this, because the Price Chopper ad looked like it had a few good deals in it, and I had coupons.
    When I got into the store, I discovered that the prices were higher anyway than where I was shopping before.
    They were trying to sell Ken's Salad dressing, which my family loves at 10 for $10... so I'm thinking great!! stock up! But when I got there, they were only the 8oz bottles and I can get a 16oz bottle at Wegmans for $1.59.
    AARRGGH I hate that I wasted that time.
    Maybe I'll try to set something up to compare Walmart and Wegmans.

  13. #13
    Registered User
    Join Date
    Jan 2005
    Location
    Upstate NY ( Central )
    Age
    61
    Posts
    2,117
    Post Thanks / WTG / Hug
    Rep Power
    12

    Default

    My price book is in my head.. And I know when something has gone up without looking. 37 years of experience ( I'm weird that way )

  14. #14
    Registered User shelsmiles's Avatar
    Join Date
    Sep 2005
    Location
    Wyoming
    Age
    42
    Posts
    75
    Post Thanks / WTG / Hug
    Rep Power
    9

    Default

    I made my price book on my computer in Excel and update it regularly. I have spaces that I can write in changes and after a while I update the computer version and reprint. It prints out on a few sheets of paper and I keep a copy folded in my coupon sorter or wallet. When I set it up, I didn't go to the store with a notebook. I just took my receipts out when I got home and filled it out that way.

Similar Threads

  1. Replies: 9
    Last Post: 04-20-2009, 01:41 PM
  2. I have a question about writing a pricebook
    By frugalandsimple in forum Household notebooks and home manuals
    Replies: 7
    Last Post: 05-31-2007, 12:09 AM
  3. Who actually uses a pricebook?
    By acidcookie in forum Household notebooks and home manuals
    Replies: 20
    Last Post: 05-03-2007, 11:38 AM
  4. Pricebook? What?
    By freyadog in forum Question and Answer
    Replies: 3
    Last Post: 02-28-2007, 10:31 PM
  5. Where can I find an example of a pricebook?
    By Jenlee in forum Frugal Living
    Replies: 5
    Last Post: 07-30-2002, 07:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •