已关闭

very simple stock system in excel

I am looking for a really simple stock management system. Nothing complex at all – this is what we do on paper which we need converting to excel. Needs to look like a Windows package with a load of drop down boxes.

1. Date stock arrived, who owns the stock (we have several customers), description of the stock, Image of the stock (optional), cost of the stock, quantity of the stock, location of the stock (we have 100 bays where we store stock so, if a member of staff needs to find a stock item, they should be able to input the description and the system will tell them where it is). When we enter a product we don’t want to add a retail price as many items are sold on ebay and we will never know what they sell for.

2. We should be able to search on product code, description, stock type (sofa, table, chest etc etc – we are a furniture company) or similar. It should be able to find items on the database if we don’t know the full product code – ie – if we search on table belonging to customer A – it should show all tables they have in stock so we can select the one we are looking for.

3. When we sell a stock item – we need to be able to put a buyers reference (ie name and address, telephone number, ebay name), what sold and how much it sold for. We need to be able to add the delivery element. For instance an items sells for £50 with £20 delivery – the invoice should show £70. We will need to report on delivery separate from furniture – see below.

4. When an items sells – we also have to record payment type (cash, cheque, paypal, credit/debit card, transfer)

5. When we sell an item – we have a few processes before its finished. IE – when an item sells it goes into pending until its paid, once paid it moves to processing, when its delivered it goes into completed. I need to be able to move live orders through the process

6. When an item books in – we need to show the item as Paid For or On Account – we have to be able to select from a dropdown list – the account name we owe for the stock. We can set all of these up manually.

7. We also have a delivery company – when we have a delivery job where there is no stock involved – we have to be able to create an invoice for the that and report on it.

8. There are items we sell for other people where we get 25% of te selling price and 100% of the delivery fee. I need to be able to show this and it needs to be separate from the general sales as otherwise it will reduce my margin. The delivery element will go to the delivery report though.

Reports

These are a sample of the reports we need top product

1. Value and quantity of all stock in warehouse

2. Value and quantity of stock per customer

3. Value and quantity of stock per type

4. Sales per date range

5. Sales per customer

6. Graphs to show stock levels broken down per customer

7. Graphs to show sales broken down per product type

8. Run a payment report so we can analysise how people pay

9. We should be able to search on jobs in pending and processing – it should show us customer names, postcodes, product types and tel numbers.

10. 10. Report on people we owe for stock – see 7 above.

11. Show the revenue for delivery see section 8 above.

12. We need to be able to backup to a flash drive at the touch of a button.

13. Once backed up – I would like to take the flash home and update the system I will be running at home.

14. Whenever invoices are produced we should be able to select print or pdf. When we print we need to be asked how many copies we need.

15. I need a running GP%, stock figure per customer, sales per month showing on the front screen so I can always track the performance

the best process is to adapt an ebay [package you already have. i will need to add stock to see if it will work in my business.

技能: 数据输入, Excel

查看更多: stock card excel, stock card sample excel, stock system excel, sample stock card excel, excel stock system, simple stock system excel, excel stock card, simple stock system, stock card excel sample, simple stock card sample excel, excel system stock account, excel stock database, simple stock database excel, simple stock excel, create stock card excel, excel product stock system, simple stock management system excel, stock card system excel, simple excel system, work in retail

关于此雇主:
( 2个评论 ) stockton, United Kingdom

项目ID: #2365106

18 威客就此工作平均出价 £145

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

£250 GBP 在7天内
(23条评论)
5.5
Teloquence

Consider it done. Check your PM for my bid details.

£250 GBP 在4天内
(49条评论)
5.2
NSExpert

Hi. I can get this done for you with excellence. Ready to start. Thanks Neha

£75 GBP 在7天内
(17条评论)
5.2
binaryromel

##### Excel expert here! Please check PM. #####

£220 GBP 在5天内
(42条评论)
5.1
MDavidCrompton

Hi, I have worked on conversion, manipulation and analysis of Excel for 30 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, on GMT time, available on skype and 更多

£200 GBP 在14天内
(23条评论)
4.9
srinichal

Ready to discuss more details

£250 GBP 在5天内
(10条评论)
4.7
naveenvarthaan

Hi, I already did a similar project for ROCKBOTTOMRETIAL UK. Its a kind of stock management tool. I have attached the file. Please give a trial at it and I will modify it with all features you expect. Waiting 更多

£100 GBP 在3天内
(13条评论)
4.2
Rampage4Services

Hi, I'm interested in working on this project. I have a strong experience working on excel and have created a few such reports and tools using Excel in my professional work as well as for other freelance custo 更多

£250 GBP 在10天内
(2条评论)
3.5
Naumaan

Please check the details in PM

£20GBP 在1天里
(6条评论)
3.4
rohitpithisaria

HI I WOULD LIKE TO APPLY FOR THE JOB POSTED BY YOU. THANKS YOU ROHIT

£125 GBP 在7天内
(5条评论)
3.3
premiumjobs001r

more details

£250 GBP 在10天内
(0条评论)
0.0
devsupport22

I have done many similar projects in my professional career

£60 GBP 在5天内
(0条评论)
0.0
sureshbabur

I have 10+ years of experience in building Utility tools using Excel vba and Access. So kindly do consider me for this project. I am ready work for this.

£100 GBP 在3天内
(0条评论)
0.0
pareshpaul234

I intend to perform such suitable kind of job which I like best. I am sure to accomplish accurately. With Regards.

£75 GBP 在3天内
(0条评论)
0.0
masifnawaz

Dear Sir, I have all the solutions you require. I have 7+ years experience of Computer applications. I guess that I am very much suitable person for this job. I can show you my previous work if 更多

£100 GBP 在3天内
(1条评论)
0.0
meghavilekar26

New freelancer, have 19 years experience / sound knowledge of excel.

£30 GBP 在7天内
(0条评论)
0.0
yveakp

Hello. I am interested by this job.

£180 GBP 在10天内
(0条评论)
0.0
mtchinthaka

Dear Sir, Did similar projects. please check PMB.

£75 GBP 在7天内
(0条评论)
0.0