I own a DIY equipment rental business and currently, for every order that comes in, I'm manually typing them in and checking the availability of each and every item based on the customer's dates based on printed invoices.
With over 270 different (and growing) products and higher volume of enquiries coming in, this method has proven to be time consuming and inefficient.
I would like to have an excel spreadsheet that would enable me to check the availability of each item automatically as I enter each new order into the system. I've uploaded a template of my existing system and would like it to be improved to a point that the availability of each item is automated.
I've also inserted several notes on the excel sheets that requires a fix and the upgrades that I'd like.
Hi there, I have checked the attached file for you inventory management i can offer you a solution i have a suggestion for you please inbox me so we can talk in detail. Regards Qasim