Senior .Net Developer / Strong MS SQL Skills

Senior .Net Developer / Strong MS SQL Skills is project number 267668 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Project expired)
Selected Providers:	-
Budget:	$1500-3000
Created:	05/28/2008 at 12:02 EDT
Bidding Ends:	07/27/2008 at 12:02 EDT
Project Creator:	developmentinc   Buyer Rating: (No Feedback Yet)
Description:	Order Automation System Vendor Assignment Changes We are looking for a programmer to make modifications to our order processing application. The application is written in VB.NET and utilizes a database running under Microsoft SQL Server 2005. The application pulls orders from ecommerce websites and processes the orders through to completion. The process uses complex sets of user defined rules to move each order through the various stages of processing. The modifications we would like to have done involve the initial stages of an order when it is first uploaded into the application. The orders are placed into our form of a purchase order for various suppliers to fulfill and we need to modify how that process works as well as add some additional functions to support it. We have described the modifications below for review and if you are interested in the project we will provide additional details as they are required. This job can be done remotely, please make a detailed list with the final cost for the project. If you need more information don't hesitate to ask us. Vendor Assignment Changes Phase 1 Change current product file so the date is captured when a new cost entered for a product/vendor combination. Any time a cost is updated for a vendor the system currently shows that date for all vendors that have a cost for the product so we can’t tell when each vendors individual cost was put in. Remove the “By State” and “SKU by State” options from assign the assign vendors screen and change the get orders routine as required to eliminate these options. Modify the Current Order Screen for vendor “Unassigned” to display all vendor costs that are on file. Create check boxes on Current Order Screen for vendor “Unassigned” to select which Vendor-Cost the order should be reassign to and a submit button to perform reassignment of any checked items. This way the user does not have to reassign each order individually. Vendor Assignment Changes Phase 2 Add a module to allow vendors to enter and maintain their own product pricing information when logged in. Not all vendors will create and maintain their own product/pricing data so the vendor table will need to be used to set a flag to determine if they use this new option. Will need to create screens for vendors to enter, maintain and view their product costs and product stocking status information. Add a radio button to the current vendor database records to turn the use of a product file on or off by individual vendor. Database records for any products in the vendors current order queue can not be changed. When the vendor initially enters or changes the cost for a product the following steps should take place. Get current product sell from Swimming Pools Etc ShopSite database. Calculate a shipping charge for the product to a zone 8 address from the vendor. Combine the product and shipping costs and use it to calculate the products gross profit. If the gross profit margin is below the specified percent an email warning should be generated and sent to the support email addresses in the WWW Development Inc. Vendor. The email should also list the combined cost and shipping estimate for all other vendors that have the product in the database. Create a master record with a place to set the profit margin threshold for this. Each product should also have a field added that an administrator can use to set a specific minimum profit margin for that individual product. If entered this will over-ride the universal setting. Database records for any products in the vendors “Current Order Queue” can not be changed. Create a screen for administrator use that allows them to view, modify or delete any vendor-product cost. Add a section in the vendors cost screens for “Product Update Requests”. Set this up so anytime a product comes into this section the vendor will be sent an email notification to inform them (add to email templates). When the get orders process assigns an order to “Unassigned’ check each product to determine which vendors that have online cost management enabled but DO NOT have cost entered for that product. Display “Product Update Requests” section of any vendors without a cost already on file. Keep it on the screen until the vendor updates it even if the order that created is reassigned. On the Current Order Screen for “Unassigned”, display the notification date and time for any vendors that were sent an email notification and have not updated their cost. These should be listed just below the vendors that already have a cost on file. Use FedEx API to get a shipping quote for each product on the Current Order Screen for “Unassigned”. Set this up so anytime an administrator goes to the Current Order Screen for “unassigned” or the screen is refreshed that the product database is re-checked for matches and the API gets all new shipping quotes. Display the product cost, shipping cost and total in separate columns and have the check box for the vendor with the lowest total already checked. Capture product cost, shipping quote amount, date and time with every order-product combination when accepted by a vendor and moved out of their current order section. Vendor Assignment Changes Phase 3 Capture product cost, shipping quote amount, date and time with every order-product combination when accepted by a vendor and moved out of their current order section
Job Type:	.NET ASP Visual Basic Windows
Database:	MS SQL
Operating system:	MS Windows
Bid count:	51
Average bid:	$ 2200