In Progress

Excel Database for Order Processing

Excel Database for Order Processing

Purpose:

We require a custom program to suit our needs as we cannot find one that does exactly what we require. We wish to automate the processing of our orders, based on specific requirements and restraints.

About the Company

We are a subscription-based company that sends randomly awesome socks every month to customers across the US.

Our wishes and constraints:

We have the unique luxury of being able to send our customers random socks each month. This makes business easy when it comes to things like inventory, but makes things much more difficult and time consuming when it comes to processing orders. Therefore, we need a system that can randomly generate new orders for our customer(s). However, there are very specific and important restraints we need built in to this database. The system has to generate new orders based on what we have in stock, gender/size of the customer, and what the customer has received in the past (i.e., no duplicate socks). In addition we need the flexibility to add other restraints/variables in the future (e.g., color, pattern, preference...etc)

You will find more information and examples in the attached document

Basic Requirements:

- The Excel database will consist of 3 essential databases, which will cross reference each other to generate a single order: Inventory database, customer database, and order history database.

- Each customers order (sock) will be restrained by specific variables: Gender/size, stock availability, and order history (what the customer has already received).

- We need to ability to add more variables in the future, as needed. E.g., pattern, style, material...etc

- We will need to be able to export the orders to a csv, in order for us to send to our warehouse for processing.

How the final result should work:

In a nutshell, our employee would begin by uploading and updating the inventory, and adding new customers. They would then indicate which customers are in need of new orders this week (renewals occur at different times each month. Also, subscription begin and end at different times each month). The system would then generate all new orders accurately, and the employee would export a csv to send to our warehouse for processing.

That’s it!

Skills: Data Entry, Data Processing, Database Administration, Excel, SQL

See more: what does data entry consist of, warehouse data entry, order processing work, new order history, need for data processing, need employee for a new business, how to find employee, how to find a data entry based us company, how to automate data entry in excel, company history examples, material data system, customer database in excel, warehouse inventory, order processing, inventory database, excel inventory, excel duplicate, excel automate, csv to excel, awesome business needs you to, database employee, data entry inventory database, socks company business, duplicate inventory, export stock data

About the Employer:
( 4 reviews ) Atlanta, United States

Project ID: #5418369

Awarded to:

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that I can start with the implementation.

$250 USD in 0 days
(207 Reviews)
6.9

29 freelancers are bidding on average $178 for this job

diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a More

$144 USD in 3 days
(116 Reviews)
6.7
zExcel

Hi, Interesting project! My name is Jon and I will be happy to help you with this project. Please feel free to message me

$222 USD in 2 days
(90 Reviews)
6.3
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than More

$194 USD in 7 days
(90 Reviews)
6.2
maverick44000

Hi Stefan. I have read the requirements and I can get you the software made in Excel with a user friendly interface and simple to use mechanism. Kindly discuss so we may proceed with implementation Regards. Usman.

$200 USD in 5 days
(44 Reviews)
6.1
ZeusMan

Looking forward to working with you...Ready to start as soon as you are....Thank you for the opportunity...

$222 USD in 3 days
(73 Reviews)
5.9
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$194 USD in 15 days
(97 Reviews)
5.8
elboukharimu

Hi, I'm very interested helping you creating and designing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to chec More

$231 USD in 10 days
(34 Reviews)
5.4
ethicalboy

Hello, I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. Based on what I realized you need a random generator to generate a random number to be assigned to socks that have spe More

$74 USD in 4 days
(56 Reviews)
5.1
twalters84

Greetings, I can create a Coldfusion application with a MS SQL database that does exactly what you are looking for. I can have an automated process email you a CSV report weekly. Plus, if you hit a button, I can hav More

$150 USD in 3 days
(17 Reviews)
5.0
abupabuya

hi sir.i have a list Email was extracted from their own site. no sales@,info@. etc ------------------------------------ LIST: 750,000 USA EMAIL - all have email PRICE: $250 sample: http://business24seve More

$100 USD in 3 days
(23 Reviews)
4.8
theincredible

Dear sir, I am professional programmer and I am really interested in doing this project for you, I have many solutions that you may choose the one that suits you. please check my profile and my customers feedbacks to More

$150 USD in 2 days
(16 Reviews)
4.6
gokulanand

Hello, I can get this done using excel programming. I had done similar kind of assignments in the past. You can check out my recent projects and reviews. Let me know if you are interested. Thanks

$175 USD in 3 days
(20 Reviews)
4.6
vikas0903

Hi, Approach regarding your project: Following is an example of another Order Management Tool (which I am working currently) to show what can be done. My client runs logistics company, along-with couple of call cente More

$315 USD in 10 days
(11 Reviews)
4.3
Baxter2008

Hello Thank you for a detailed description of your requirements. I gave proposed a longer timeframe of 10 days due to the amount of work involved. The most challenging aspect of this would be randomly generating a More

$200 USD in 10 days
(23 Reviews)
4.2
geogeorge2

Guys, I really think you should consider a database application for this and not excel (MS Access should be fine). You are trying to develop a system in Excel while Excel was never meant to be used as a software platfo More

$155 USD in 10 days
(7 Reviews)
3.8
srdas2012

Hi, We can do the Excel Template with Macro for Automation (We will be able to send you any message or Sample files Only after you send a Message to us as per Freelancer Rules). We are Expert in Excel & Excel bas More

$147 USD in 7 days
(7 Reviews)
3.4
seanmdale

Hi stefanlewinger, thank you for the detailed requirements. I have recently worked on a very similar project for a company in the UK to digitise their purchase order system using SharePoint and MS Excel. I hope More

$160 USD in 3 days
(5 Reviews)
3.2
abhinay18

This is such an easy requirement, not sure how you weren't able to find the perfect guy for it. Everything is clear, I know exactly what to do ! Thanks & Regards, Abhinay

$150 USD in 3 days
(2 Reviews)
2.5
Ambtrek

Hello sir i am interested and clear with requirements, sir. I will provide lowest price and best [url removed, login to view] you are interested please contact me and no need to pay in [url removed, login to view]

$77 USD in 4 days
(5 Reviews)
2.5
bluerain05

Bir öneri henüz sağlanmadı

$250 USD in 3 days
(1 Review)
0.0