Excel data based inventroy, capable of multiple stock locations count

I need a simple solution to input the orders form excel spreadsheets, that would automatically update stock levels, allow por manual update of daily sales and could spread stock to various locations. I would need it to be capable of producing reports of stock level for monthly inventories and where I could upload lists of new products and new orders from excel rather than manually, one by one. Since it is meant to be used with only one supplier and their product codes I would need it to clasify items accordingly. The main difficulty with that is that the product i.e. 2814 100 and 2814 222 are the same product of different colour and 9900R and 9900G would also mean the same. I would need to overcome this problem that excel sees them differently, and be also able to quickly check i.e. how many 2814 and 9900 are in total and have them in correct order by their first 4 digits only (i.e. 2813, 2814 100, 2814 222, 2815G, 2815R, 2816)...

It should also be able to populate fields with item description/purchase cost/suggested retail/ wholsale price/ retail price and allow to appy discounts when typing in codes of sold products and to be able to chose wholsale/ retail sale price depending on location of the stock.

Skills: Data Entry, Data Processing, Excel, Inventory Management

See more: retail stock sales data excel, stock location excel, stock count excel, excel stock count, multiple stock excel, the data supplier, purchase order form excel, typing in excel, stock update, sales excel, locations, excel reports, excel data input, excel 2013, data upload from excel, form update excel, excel colour, update stock, supplier purchase order, excel monthly daily, excel count, daily stock excel, stock excel, multiple fields, upload sales orders

About the Employer:
( 1 review ) Panama city, Panama

Project ID: #4184857

7 freelancers are bidding on average $168 for this job


Hi , I can help you. If you need me contact me!

$200 USD in 3 days
(6 Reviews)

Ready to start immediately.

$175 USD in 10 days
(1 Review)

I can solve the coding issue you have mentioned. this can be completed in 2 to 3 days, if I am given the full requirements. I placed 15 days, but I will actually support this project for a month or as long as it takes More

$30 USD in 15 days
(2 Reviews)

Hi, I can help you. To identify product using first four digit we can use macro, and I am experienced in building macro in Excel.

$350 USD in 3 days
(0 Reviews)

I have done a lot of work with spreadsheets.

$200 USD in 4 days
(0 Reviews)

I would gladly accept working on this project.

$100 USD in 2 days
(0 Reviews)

Hi. I'm a planning and inventory control manager. I manage my work through erp system, excel and custom made VBA macros. Will be happy to help you. See attached some code i wrote, we can also fo for only formulas wi More

$120 USD in 3 days
(0 Reviews)