Excel input inventory programme, based on product list and for multiple locations

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: excel inventory input, excel based product list, product stock input, product stock excel, product stock list excel, purchase order form excel, typing in excel, sales excel, programme, locations, input, input products, excel reports, excel inventory, excel 2013, data upload from excel, correct and main, form update excel, excel colour, update stock, supplier purchase order, excel monthly daily, total product price, daily stock excel, product item price list

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

Project ID: #4184845

6 freelancers are bidding on average $147 for this job


Hey you put this project twice. Like I said in the other , I can help you. Best regards!

$200 USD in 3 days
(6 Reviews)

I would like to work on this for you. this is my first month on so I am offering VERY low INTRODUCTORY rates to get a few projects under my belt. I already finished my first project, you will be my 2nd, More

$30 USD in 7 days
(2 Reviews)

Hi. I'm a planning & control man. for a global company. What you need is what i do and use every day, utilizing excel and VBA. I'll be happy to do the work. BR, Yosi.

$250 USD in 7 days
(0 Reviews)

I would gladly accept working on this project.

$100 USD in 3 days
(0 Reviews)

Hi sir, I can do u project. I did sent a similar work sample on u PM.

$100 USD in 1 day
(0 Reviews)

This can easily be done by Macro and I am experienced in Macro programming on Excel.

$200 USD in 3 days
(0 Reviews)