Small Shop Utility (for mid-sized shops)
This is a small utility to speed up the process of buying and selling between a Shopkeeper and a Customer. There are two sections (excel files) of it - Shopkeeper and Customer.
The Shopkeeper file as shown below remains with the shopkeeper where he can add/delete/modify items (Click Manage Items) and prices in the stock.
The Update Customer copy button allows you to choose the other customer copy provided to be updated with the updated items and prices. This updated customer copy is then emailed/sent to the customer.
The customer file (updated by the shopkeeper) as shown below remains with the customer. This file should be sent to the customer as and when new items are added in stock/list or if there is any price change. The customer clicks on the Create...button to generate his purchase order. The Customer then should update his contact details in the space provided, save the file and email it to the shopkeeper to supply his order. There is also an option for the customers to save their list of favourite items.
I request you to send in your feedbacks or improvement requests.