Find Jobs
Hire Freelancers

Inventory/Distribution system

$300-1500 USD

Cancelled
Posted over 17 years ago

$300-1500 USD

Paid on delivery
Software application, preferably written in C# 2.0 (Visual Studio .NET 2005). If you wish, you may use .NET 3.0 (workflows, etc) although this would be exceed my expectations. The database must be MS SQL 2005 Express Edition. Code will be reviewed for performance and potential to be scaled. An API should be exposed, and use of a simple middle-tier library for data persistence is expected. You may use third party products and applications, so long as the costs either fall within the estimate or are otherwise approved by myself. This may prove to be a good idea - anything that would make the project simple and quick would be preferred. The use of freely available and popular libraries and frameworks is suggested. I was personally not able to find a reasonably-priced software package that does the following with in an intuitive user interface: (In my opinion, this should be fairly straightforward and inexpensive to develop) 1. An application (exe) with no user interface that, when run, will process the text file(s) in a directory specified as a command line argument or config setting. The files will be processed in order of date modified, and each will be an EDI/CSV text file containing a batch of orders to be fulfilled (we will provide you with the text file's layout/schema). 1.1 Each file contains any number of orders. An order will contain a customer's name and address, shipping method and any number of line items that should correspond by UPC to an item in the inventory (stored in a table in the database). 1.2 Each order is saved to a record in a database with an OrderState field. 1.3 There are two cases: 1.3.1 For any order that can be fulfilled immediately (where the actual product stock level minus the reserved level is greater than 0 for all ordered products), the order state should be marked as being in the "picking" state, the reserve level should be increased by one and a pick ticket should automatically be printed in real-time. The pick ticket (aka packing slip) is simply the order details (what was ordered, by whom, etc) with a barcode for the order number. All orders should be held until they are ready to ship complete. 1.3.2 If for any product in the order the actual stock level minus reserved level is 0 or less, the backorder count will be increased. A corresponding purchase order (PO) record will be created, or if one already exists it will be updated to reflect the backorder. 1.4 The application should summarize it's actions, any errors, etc to a log file that is stored on disk and emailed 2. A purchase order generator, which compiles a list of items on backorder grouped by item and vendor. A user can select a vendor and generate/print the corresponding PO, which is simply a a human readable report. There should also be the ability to have a plugin (or be able to call out to another application) to do additional work with the PO data (e.g., generate and transmit CSV file). 3. (This application can be saved for a 2nd release and possibly in separate work order) An application that regularly monitors backorders and uses an intelligent algorithm that uses common practices of supply chain management to suggest intelligent purchase orders (POs) based on historical order volumes and other factors. You must be able to define and change the characteristics that are used to determine when a PO is automatically generated (min/max levels, supplier volume discounts, etc.). I am not very familiar with distribution systems and everything that this entails, so I'd appreciate if the person working on this project could provide some guidance in this area. 4. A front end to 4.1 Import products in batch via CSV files to a database table. This CSV will be provided. There are approximately 500,000 items to be imported. 4.2 Allow user entry of a new product using a form 4.3 Search. Any field should be searchable, however, there will be a combination of several specific fields that will almost always be used to find products. We will explain how these fields combine to give the product ID that the products table is keyed on. Search results should display matching products as well as their inventory counts and a link to any open orders that are requesting the searched item. 4.4 Receiving screen, which adds items to inventory by physically scanning UPC barcodes. This operates in one of two modes: 4.4.1 One-by-one (each item scanned increases stock level by one) 4.4.2 Barcode scan followed by quantity entering (e.g., item is scanned, user enters 25 [Enter] and stock level is increased by 25). 4.4.3 The mode could be toggled to allow for removing items from inventory rather than adding 4.4.5 You should be able to optionally select a purchase order. Once a load of items have been scanned, you would be shown the products that did not match the PO. 5. Shipping application. We would like to use the application remotely, away from a computer screen by using a cordless barcode scanner (therefore, there should be no prompts or dialog boxes during the shipping process). We would take a printed pick ticket, scan it's pick ticket barcode, then scan the UPCs of the ordered products from the inventory in any order. If a product was scanned that was not in the pick ticket or too many items were scanned, an error beep should occur. If all items were successfully scanned, there should be a confirmation sound and the order should be marked as complete and archived in the system. The actual and reserved stock counts should be decreased accordingly. When done, the user will return to the computer and click a "Finish" button that will create a CSV file (sample will be given) and optionally run a specified program. *I would expect that there is already software that does the above but unfortunately I was unable to find an application that did exactly what I wanted. If you are familiar with a program that meets all my requirements or can be made to meet them, I will be more than happy to pay a fee for the configuration. If you will be configuring existing software versus creating a custom piece, please factor that into your bid. If you create the software, I would be purchasing the rights to the code and the ability to resell it. Thank you!
Project ID: 106680

About the project

59 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
59 freelancers are bidding on average $1,214 USD for this job
User Avatar
plz checl my PMB
$1,500 USD in 30 days
4.9 (71 reviews)
8.1
8.1
User Avatar
hi plz see pm
$1,400 USD in 30 days
5.0 (62 reviews)
7.1
7.1
User Avatar
Please see PMB for detail. Thanks.
$1,500 USD in 35 days
5.0 (2 reviews)
6.6
6.6
User Avatar
pl check pmb.
$1,250 USD in 30 days
5.0 (20 reviews)
6.5
6.5
User Avatar
We are really confident to do that.. Please check our PMB for portfolio
$1,500 USD in 35 days
5.0 (6 reviews)
6.3
6.3
User Avatar
Please check PMB.
$1,250 USD in 30 days
5.0 (6 reviews)
5.7
5.7
User Avatar
Dear Sir / Madam, We would like to do this project. Please see PMB for Details. Thanks and regards, Team - Kumaran HI
$1,200 USD in 20 days
5.0 (10 reviews)
5.6
5.6
User Avatar
Dear Sir , We have all necessary skills in this area. We use most advanced technologies and offer qualified technical assistance. Quality and satisfaction are guaranteed. If there are any questions, we have 24x7 support service. The best regards, Gorasoft
$1,450 USD in 33 days
5.0 (1 review)
4.8
4.8
User Avatar
Contact me in PMB.
$1,000 USD in 25 days
4.5 (2 reviews)
3.3
3.3
User Avatar
Looking Forward To Work With You. Thanks & Regards, WebDezers Inc.
$1,200 USD in 60 days
1.8 (2 reviews)
3.9
3.9
User Avatar
We have something similar ready and working for several clients but written in VB6.0. If VB6.0 is acceptable to you, we can give you a tried and tested software. Let me know through PMB. Regards
$1,350 USD in 10 days
5.0 (1 review)
3.0
3.0
User Avatar
Please check PMB.
$1,500 USD in 1 day
4.3 (2 reviews)
2.6
2.6
User Avatar
Dear Sir/Madam Thank you for allowing us to bid your project. We are a Professional Web Development Company having experience in Web Design and Development. We also do software development and customized application. Ours is a properly equipped team to handle projects of special nature like yours. Our deliveries have been on time and every time. We have expertise in using technologies such as Microsoft, Java, J2EE, VB, C++/C, PHP, ASP, Flash, AJAX, MAMBO, Joomla, Oracle, MySQL etc. For further details, Please refer PM. Regards VCanss
$1,300 USD in 32 days
0.5 (1 review)
4.2
4.2
User Avatar
Please check your PMB! Regards, ZedEx Inc.
$1,500 USD in 59 days
5.0 (1 review)
1.0
1.0
User Avatar
Dear Sir! Please check your PMB. Regards Hadi
$1,400 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! My name is Dmitriy. I'm "Deimand Co" GAF project manager. We are sofware development company from Russia, Taganrog. Our timezone is Moscow (GMT+3). Our English web-site is www.deimand.ru. Please visit if you are interested. The English language skills of most part of our team is good enough to have efficient communication in IM and if it will be strongly neccessary we will be able to communicate via Skype or phone. We are very interested in your project because we have a good C#/.Net developers here. They are experienced in Win32 as well in .Net platform development. Also they have strong SQL skills and experience of MS-SQL server, MS-Access and MySQL. They confirmed their qualification by passing brainbench professional tests. Also, our company prefer serious orders and long-term relationships with the customers. We guarantee good responsibility, job quality and fast turn-around. Please feel free to contact me if you need more info. Looking forward for feedback from you and hope for good cooperation. Best regards, Dmitriy, "Deimand co" manager.
$1,500 USD in 30 days
0.0 (0 reviews)
3.9
3.9
User Avatar
hi...Please check PMB for more details.
$1,000 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day! We are ukrainian software firm. We can do your project as you want. We have big expirience in CRM systems.
$1,500 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi. will deliver a apprecialble proj. Trust me ...and provide me a good result thnx
$1,000 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are focus on this similar Inventory/Distribution system project for many years. Our company is a professional software foundry. In our software foundry automation process and a relentless drive to lower cost and faster response time for your project. I think we can meet your request and get project ready based on your specification. Please also see the PM for my some detail message. Thanks for your information. Bruce
$1,200 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
RICHMOND HILL, Canada
0.0
0
Member since Nov 13, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.