OPERATIONS.

TECH SUPPORT.

DEVELOPER.

FINANCE.

Food Inventory

June 20, 2020 by Ray Sanchez

The Problem: Opening and digging through a smaller chest freezer. Also, need a way to keep track of food inventory for quarantine.
The Solution: A database accessible from my phone to add, remove, update, or delete items. At the grocery I can see what I have or don’t have at home.

Total Records Found: 93, showing 20 per page
Count	Item	Brand	Ounces	Category	Location	Updated
3	Burger	Rastelli	5	Meat	Downstairs Freezer	November 29, 2020
2	Steak Ribeye	Giant	16	Meat	Downstairs Freezer	November 5, 2020
4	Chicken Pot Pie	Marie Callenders	10	Meat	Downstairs Freezer	November 5, 2020
1	Turkey Ground	Natures Promise	16	Meat	Downstairs Freezer	November 5, 2020
1	Sausage Turkey Breakfast	Applegate	7	Meat	Downstairs Freezer	November 5, 2020
5	Ice Cream Cookie Sandwich	Nestle	4	Snack	Downstairs Freezer	November 5, 2020
2	Beef Ground	Generic	20	Meat	Downstairs Freezer	October 13, 2020
1	Broccoli Cheese Nuggets	Earths Best	8	Vegetable	Downstairs Freezer	October 10, 2020
1	French Fries Crinkle Cut	Market Pantry	32	Vegetable	Downstairs Freezer	October 10, 2020
1	Ice Cream Mint Chocolate Chip	Hersheys	48	Snack	Downstairs Freezer	September 30, 2020
1	Broccoli Florets	Generic	32	Vegetable	Downstairs Freezer	September 30, 2020
1	Cauliflower	Giant	16	Vegetable	Downstairs Freezer	September 30, 2020
1	Veggie Tots	McCain	12	Vegetable	Upstairs Freezer	September 28, 2020
2	Chicken Cordon Bleu	Barber Foods	5	Meat	Downstairs Freezer	September 28, 2020
1	Bacon Classic Cut	Hatfield	16	Meat	Downstairs Freezer	September 22, 2020
1	Chicken Breast BBQ Cook In Bag	Giant	32	Meat	Downstairs Freezer	September 22, 2020
1	Chicken Thighs Carnitas Cook In Bag	Giant	32	Meat	Downstairs Freezer	September 22, 2020
2	Ravioli Cheese	Tallutos	15	Dairy	Downstairs Freezer	September 22, 2020
1	Veggie Tots	Green Giant	14	Vegetable	Downstairs Freezer	September 22, 2020
1	Chocolate Creme Pie	Edwards	1	Snack	Downstairs Freezer	September 22, 2020

1
2
3
4
5

OUT OF STOCK:

Total Records Found: 30, showing 20 per page
Count	Item	Brand	Ounces	Category	Location	Updated
0	Ice Cream Philadelphia Vanilla	Greens	48	Snack	Downstairs Freezer	August 26, 2020
0	Broccoli Cauliflower Carrots	Generic	16	Vegetable	Downstairs Freezer	August 26, 2020
0	Chicken Breast Adobo Marinated	Generic	16	Meat	Downstairs Freezer	August 16, 2020
0	Steak Filet Mignon	Generic	9	Meat	Downstairs Freezer	August 13, 2020
0	Steak Sirloin	Generic	11	Meat	Downstairs Freezer	July 30, 2020
0	Sausage Sweet Italian	Generic	4	Meat	Downstairs Freezer	July 27, 2020
0	Burger	Omaha Steaks	4	Meat	Downstairs Freezer	July 18, 2020
0	Pork Chops	Generic	21	Meat	Downstairs Freezer	July 16, 2020
0	Shrimp Calypso Coconut	Margaritaville	10	Fish	Downstairs Freezer	July 9, 2020
0	Peas Carrots	Generic	16	Vegetable	Downstairs Freezer	June 26, 2020

1
2

Add Food Item
Item
Brand
Count
Category
Location
Ounces

I customized the WordPress plugin “Participants Database” to Create, Read, Update, and Delete food items. Anyone can add items but a WordPress login is required to update or delete food items.