I need a database for my small business, currently I use an excel file and a word document for everything from inventory to pricing to producing print documents. It needs to have a really simple UI as my business partner is not computer savvy and uses the iPhone for everything.
The company is a gift basket business so you can imaging many component items going into a few main products for sale - and every product for sale gets a printed sheet with the contents.
Tasks or outcomes I’m looking at.
-Inventory - receiving. # of items, landed price paid, lot # expiration date etc.
-Inventory Alerts - stock alerts 45 and 15 days to sell by date
-Inventory tracking - parent gift basket is sold and all child / component items are reduced in the inventory. This needs confirmation and editing as items are added or subtracted to each sale.
-Pricing out items for sale - using the inventory to add products together and save as an item sold. Once saved and confirmed the inventory would update to reduce stock
-Print materials - Using template A or B (each template has a different # of spots for product information) the form would be populated with a selected gift basket contents (also with option to edit / add / subtract items) - this needs a block field area for personal messages
-Lastly if any of this can work with WooCommerce by zapier or some other extension I’d be happy! If WooCommerce is used I would add into the project shipping labels to be printed.
If you can take this on by tweaking an existing table or creating from scratch please get in touch with me.