You Asked for It: Upgrades to PYP’s Price Book

April 9, 2010 Update: The download links should be active. Let me know if there are any problems.

If you’re new to price books, watch this video to learn what they are and how to use them.

There have been even more requests for changes and updates to the PYP price book, so here’s another upgrade. I won’t post any more individual posts on this topic, so for future additions or upgrades, subscribe to the comments on this post or bookmark this post to see what’s new.

Option 1: Full-Sized Price Book (Click here to download the most recently updated version.)
The original price book prints pages that look like this:
Option 2: Half-Sized Price Book (Brand new. Click here to download.)
The new miniature version prints only half-sized pages. This means that you can either print them on half sheets, or print them on full-sized sheets and use the second half to print another price book page. This allows users to carry smaller price books instead of full-sized three-ring binders. All of the updated pages listed below are included in this first version of the half-sized price book.
Important Upgrade: Master price list. At your request, we’ve also added a master price list which lists the basic prices of all the individual sheets in the price book. This is for folks who don’t want to record their own prices, but would still like some base reference points to carry in their purse or pocket. It’s included in both of the books above, or you can download it individually from the upgrade list below.

Additional Pages: These pages have been added to the price book since its original publication. They’re included in the price books above, but if you don’t want to re-download the entire price book, you can download the individual pages below.

Related Products from Amazon


  1. Comment here with any requests.

    • I came back to PYP to get a new download of the pricebooks. All the links take me to the master price list. Does that mean the others are no longer available?

  2. I am not sure why, but the link for the Master Price List does not work. I will check back. Thanks!

  3. Aly: Thanks for the heads-up! I had them uploaded as .xml files, which apparently blogger doesn’t like. I changed them to .xls, and they should all work beautifully now.

  4. Hi! I’m new to couponing. This price list looks great.

    I have one question. When preparing to go to a store, do you suggest going to several stores to find the good deals, or do you suggest picking one store and going there most of the time?

    Thank you!

  5. Just forgot to subscribe to see your follow-up comments.

  6. Kris:

    Ah, the great debate! The answer is: do what works for YOU given your time, number of kids, location of your stores, and how much you like or dislike shopping.

    Here’s an example: When I first began couponing, I had no kids and was in grad school, which meant that I had a lot of spare time. The stores in my area are pretty much all dotted in a straight shot up and down Main Street, so I would just start at one end of it and hit Albertsons, Walgreens, Fred Meyer, Wal-Mart, another Walgreens, and Smiths. I’d sometimes take a half-mile leg to hit Rite-Aid and Winco as well. It took very little time, and no additional gas, and I hit all the deals.

    Now, however, I have a massive stockpile and two kids. This means that I have both the luxury and the necessity of picking just one or two stores with the most absurdly hot deals, grabbing those, and filling in my produce/meat needs at whatever store has the best deals on those.

    So although I can’t suggest a particular shopping style, I will recommend these guidelines.

    1. Don’t get stressed and frantic. If your shopping list makes you feel overwhelmed, just start cutting out stores. The other deals will come around again.

    2. Don’t make your kids suffer. I have to learn to cut shopping trips short if my babies don’t have the stamina for it. Sometimes they’re in a great mood and I can Walgreens it up all I want, but most of the time I pick the hottest deals and just go in and out with them quickly.

    3. Don’t spend so much time that your spouse or kids get resentful or sad about the time you spend couponing. When I first started, I got such a kick out of it that I was gone a lot. At the time it was just me and my husband, so there were no lonely kids at home, but after a while my poor hubby objected to missing me all the time, so I scaled it back.

    Within those three parameters, do whatever works for you. If you only do two or even just one store a week, you’ll still see significant savings.

  7. Thanks for all the work on this template. It looks very good and I can’t wait to “take it up a notch” with this new tool!
    I’m going to give it a try on my Palm Treo. I have Documents to Go software and I want to see if the excel file works ok for this application.
    (Geez sometimes that inner nerd in me gets a little carried away and just starts talking and talking!!) LOL! Thanks again for putting this together.

  8. You can search and search and search the internet and you guys are the only one generous enough to share your list! Thank you so much!

    I wonder if there are any updates with all the prices going up! It is getting crazy!

  9. Thanks for sharing your work – unfortunately, I can't get anything to open 🙁

  10. I am trying to down load the Master Price List and I receive an error message saying that the link is broken and does not exist. can you help me please.

  11. Also couldn't download the file… I noticed on a post that there was a problem possibly with the hosting… Do you have it available as an excel file? Thanks!

  12. I just want the master price list, and I can't get the link to work.

  13. Hmm, where within the price book (half- or full-sized) is the master list located?

  14. Taikero: It's been so long since I posted these that I had to re-download the book in order to remember. I don't see the master page in the book, but you should be able to download it from the link in the post.

  15. Heidi: I appreciate the response, but I'm still a bit befuddled. Neither of the price books, as far as I can tell, contain the master list, and the "Master Price Page" link is directed to the full-page price list, PriceBook.xls. Either I'm missing something obvious here, or the master list has been accidentally omitted. Furthermore, the blank template, sunscreen, and shampoo links are all broken. Not important to me, but considering you link to this page from your Coupons 101 hub page, it might be worth maintaining the links.

    I apologize for the persistence, but I'm looking to set up my own spreadsheet, and your price list would be an invaluable start in my beginning couponing endeavors. 😀 I suspect I'll compile the individual pages if the master list remains elusive.

    I appreciate all of your efforts. <3

  16. Hi there! I'm with the person above–I can't get the master price list to open. It's telling me the link is broken.

    Thanks for your help! 🙂

  17. Beth and Taikero:

    I've reuploaded the master price page. I tested it and it works for me. Give it another shot. Hope it works!

Comments are now closed for this post.

Lost Password