Closed

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

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: Copy Typing, Data Entry, Excel, Photoshop, Word

See more: excel inventory input, purchase order form excel, levels 2, sales excel, programme , locations, input, input products, excel reports, excel inventory, excel 2013, data upload excel, correct main, form update excel, excel colour, update stock, supplier purchase order, excel monthly daily, total product price, daily stock excel, product item price list, purchase sale inventory, stock excel, inventory update, excel product supplier list

About the Employer:
( 0 reviews ) Dhaka, Bangladesh

Project ID: #4186303

17 freelancers are bidding on average Rp238647/hour for this job

tamrakar81

Hi, I have gone through your requirement and I am glad that I am best fit in your requirement , Please give me opportunity to work with you. Thanks,

Rp150000 IDR / hour
(86 Reviews)
5.6
irfanarab

I have over 10 years experience in the typing and data entry jobs.

Rp155000 IDR / hour
(7 Reviews)
2.3
swssouvik

Dear Nafizkakan, We've gone through your project description & are confident of a top-quality, fully-customized and time-bound delivery for your project. Please check your PMB! -Sketch Web Solutions.

Rp150000 IDR / hour
(1 Review)
1.9
Alex4u

Hi please check your inbox, Thanks...

Rp200000 IDR / hour
(2 Reviews)
0.6
tigermax

hi I am expert in Excel,Word,Photoshop & also expert in data entry etc waiting for reply thanks

Rp150000 IDR / hour
(1 Review)
1.0
uniqueautomation

Hello, We can have this spread sheet created for you , it may take a few iterations untill we achieve your desired output. We have done many similar projects and can also find the solutions to the same product - diff More

Rp150000 IDR / hour
(0 Reviews)
0.0
Tina601

Dear Sir, I have already work on Inventory management system. Allow me to give proper solution. Thanks & Regards, Tina.

Rp150000 IDR / hour
(0 Reviews)
0.0
Emelsa

Please send me the details as I am willing to start right away.

Rp1500000 IDR / hour
(0 Reviews)
0.0
mwitibernard12

hello, i have an experienced person on data entry and writing.i deliver you work within your time frame,if given this work

Rp160000 IDR / hour
(0 Reviews)
0.0
Bhavashakti

I can do your job easily.

Rp150000 IDR / hour
(0 Reviews)
0.0
adedaponaf

Hi, I have gone through your requirement and i can assure you that i can handle the job with my proficient skills in MS-Office packages and Data entry from my previous job employer, Please give me opportunity to work w More

Rp210000 IDR / hour
(0 Reviews)
0.0
Shreyatyagi

hi,i am in new in freelancing doesn't mean that i don't have experience in data entry.have a good knowledge in excel,msword..i assured YOU 100% ACCURACY AND 100 SATISFACTION...

Rp150000 IDR / hour
(0 Reviews)
0.0
RahmanReen

Just take me and I`ll do it. Just dont lie.

Rp150000 IDR / hour
(0 Reviews)
0.0
mnobinm

sir i can do this work plz consider me.

Rp160000 IDR / hour
(0 Reviews)
0.0
kamran4urwork

i am very interested in this bid... please select me

Rp152000 IDR / hour
(0 Reviews)
0.0
hiroshangk12457

I'm up for it. Thank You

Rp155000 IDR / hour
(0 Reviews)
0.0
srinidotca

Hi, I am well versed with this kind of work and have a strong knowledge on Excel and Inventory Management. Hope to get this opportunity Thanks Srinivasan

Rp165000 IDR / hour
(0 Reviews)
0.0
damthuyquynh

I understand what you want. I familiar with inventory management. Can I do this task. Thanks.

Rp150000 IDR / hour
(0 Reviews)
0.0
rlicaret

Hi! I have done quite a few very complex MS Access databases. I am willing to provide You some samples of VB, SQL, etc programming. I am very sure I can provide You either an MS Access database or a MS Excel workbook w More

Rp230000 IDR / hour
(0 Reviews)
0.0