VP of operations for new athletic apparel brand wants to scan and keep track of store inventory #'s

"I am the VP of Operations for a new athletic apparel brand.

We sell our gear online and in mom and pop stores around the east coast.

A problem we face is that all of the inventory that goes to the mom and pop stores is there on consignment . We have to manually keep track of each store in a separate excel sheet, while managing our master inventory spreadsheet list. We looked into using Quickbooks, but it does not allow us to audit different stores and manage the inventory the way we need it to do.

In an ideal world, we would have software that we could use anywhere that had internet connection where we could scan and keep track of store #'s instead of having to go into their stores and manually audit, and would then pull that information into a document that we could give to that retailer as an invoice. Right now I do all of that manually and have not found a software that can do what I need it to do.

I would pay alot of money for something like this if I could find it because it takes up so much of my time to have to do these things and literally manage dozens and dozens of excel sheets with hundreds of tabs and thousands of UPC numbers. I would be interested in talking to someone about this, but ultimately it would be the decision of my boss to decide if he wanted to pay someone to do figure out how to do it. He writes the checks, so it would be up to him!"