I decided at the beginning of the year to put my entire grocery shopping in a database and see if I can improve my experience. It just two weeks and I already learned a lot about not only how I shop, but the whole system of grocery shopping and how to optimize it. I was just doing this out of curiosity and will discuss some of my findings. I wrote a previous article about grocery shopping is one of the biggest opportunity cats are sleep on. I realized my habit is to jot down stuff on list and run aisle by aisle on what I need. Then at times, I’m picking up stuff on my list and when I get to the checkout line, the cost of my grocery bill it just really out there or it can be a lot better. I wanted to improve this process and decided to use a database. In addition and this is why I’m sharing this information with you cats on this from the entrepreneurial angle. I want to study the science of inventory and buying and looking for optimization when it comes to us brothas and sistas launching retail operations in the hood. We cannot afford “clearance sales” on unwanted goods and marking down stuff as a loss in the hood – we need to make sure we are able to sell exactly what we bought wholesale and make profit. I hope you cats are learning from what I’m bringing your way in 2012 – you can do things around your everyday life in an entrepreneurial fashion to get your skills up. I’m buying my grocery just like a cat in a restaurant or bar or retail have to buy stuff and make sure it is used up so they can get value out of it. I know this from running the Liquiditi Beverage stand last year in downtown Atlanta, I was stuck with stuff I spent money on but it did not sell and I had to offset the loss against the profitable sellers. The Database I’m using Microsoft Access however cats can use Open Office Base that is open source if they cannot afford Microsoft Office. Now the first thing I quickly realized is how time consuming and tedious the data entry can be which is something the average cat probably don’t want to do. I’m recording all the food I’m buying and have them in categories and the price and when I purchased it. However, and this is a future article I’m working on, the first data entry is going to be hard because you have to enter everything for the first time and you are entering some serious rows in your database for the first time. I believe it took about an hour to enter the first grocery receipt into my database and I’m an expert. However, the goal is for me to make it easier. So let’s look at the process where I go to the grocery store, put the stuff in my cart, purchase it and get the receipt and go home. Now after I put all of the groceries in their bag on the table, I have to put them up in the refrigerator and stuff like that. Then I have to take the receipt and sit down and enter every line item into the database system. That is where I ran into my first major pain point. For each new item, I had to create a new category and subcategory in the database before putting the item in and that was some tedious work. What I realize is I need a better way and that is just entering the items and then add a “tag” to the item and then at a later time, arrange all of the tags into categories. This was important for me to understand because this is how it would make it easier to enter data for the regular cat out there. So I’m going to update this database. Now, that is another issue, I already enter all this data into the database and when I do my rearrangement or rewrite that is going to take some time. This is why in technology development or in entrepreneurial hustles, you have to write things down and put real thought into them and prototype and simulate. You don’t want to launch your hustle and realize until after the fact you have to redesign or rebuild because that is twice the cost of your original effort and investment. My Data Patterns Now I learned some patterns about me where I created plans to optimize my grocery shopping. At first, I noticed that I would make multiple trips to the store where I “pick up something” and got receipts totaling $27 about twice a week. First of all, I got a lot of ish to do and don’t understand why I’m making multiple trips like that in a week. This probably comes from my big city upbringing where you bring a bag of grocery home after you get off the train every other day. I set it up where I would only make one trip to the grocery store and make sure I get everything for that week. Second thing I did with the database was able to put my own notes and ratings on the products I buy. I bought some store-branded chicken patties and that was the worst ish I ate in a long time. So I was able to put notes in and make sure I don’t ever buy that stuff again. But I also write other notes such as what kind of seasoning to add to a generic store brand like frozen chicken to make it taste better than the more expensive brands like Tyson or Perdue. One more thing I noticed was $2.39 and $2.69 – that’s how much the stuff be costing per item and what I realize is this is probably the price point the grocery store put on things. So with that said, this is my benchmark of assuming everything is $2.60 and I see what cost more than that and the goal is to find things less than that amount and that is my savings. Real talk, have you notice that hot dogs are $2.69 and Doritos are $2.69 and a whole bunch of other stuff is $2.69 on your list? Optimization After I done two shopping trips, I was able to buy exactly what I need. But here is where the most important thing about grocery shopping and what we have to learn as entrepreneurs – can we consume it in the time period we buy it? For example, there are cases when I try to buy a diversity of meats and vegetables but two or three weeks later, I still got frozen cauliflower in the frig and realize I’m not going to eat that ish and why did I buy cauliflower the first place? See, the reason why I bought it because I was buying diversity and selection and not utilization. I was just buying stuff saying this was nice to have instead of having a strategy of knowing what I’m doing to eat each day for the next several days and pad in the snacks and other goods. This is also a major problem in entrepreneurial like retailing where we buy stuff wholesale just to have a diverse selection but some stuff don’t sell. At Liquiditi, I bought sparkling water but realize no one drinks that bubble water ish except New York cats and I’m down here in Atlanta selling it. That was one of the products that killed my profits early on buying that Perrier stuff that I don’t even drink. Summary I also went to the dollar store and bought some play money so I can run some simulations in my household on how money is spent and bought wholesale. The goal is to make sure I get the discipline of buying low and selling high down to a science and use that experience in my software development practices. See, some of you cats want to wish so badly these other cats like Wayne Sutton can outdo this brotha from the West Side of Chicago but I’m just too real life and real world for those cats who ain’t even close to the level I’m at in this tech game. I already realize for inventory that the average cat is going to have a tedious time if they just enter data using strict categories they have to assign under, like how they got it in the store. I think adding tags is going to be a better strategy and I already created this section for the upcoming point of sale for the hood project. The reason why I’m doing tags for the point of sale for the hood so you can quickly identify not only sunglasses as eyewear but also tag it as summer items to be able to quickly identify it when you create your summer product mix section when cats walk in your store during the summer. I’m saving money as a result but my investment time also went up also. However, I’m learning and improving and I’m pretty sure when I give you cats the next update, I will have more improvements and optimization to tell you on my experience.