Project Overview

Hestia is a large company working in the area of building supply and construction products. They sell a lot of various products. The business area relevant to this application is selling steel pipes on the commodity market. Products are steel pipes, which can be very different in their types, sizes and characteristics. The customer sells those products within the USA through their branches. The country is geographically divided between several branches, and actual sales are performed through Distribution Centers (DC's) of those branches. It means the customer has a wide distribution network over the country, so they can sell and deliver the same products from various geographical places. The product price will vary significantly on the geographical locations of the branch and vendors producing those products.

Competition Task Overview

For this challenge, competitors need to make changes to support uploading datum(Topcoder Cost File 2-6-14.xlsx) provided by clients to the application. During unploading, it will do the following things:

 

1. Update initialListPrice and initialMultiplier columns in CWPricingRecord table as per new datum in "Topcoder Cost File 2-6-14.xlsx"("WheatlandBase (1)" and "Multiplier" columns)

2. Update initialPPT column in PricingRecord table as per new datum in "Topcoder Cost File 2-6-14.xlsx"

In "Domestic ERW Cost", "Domestic SMLS Cost" and "Import Cost" tab of "Topcoder Cost File 2-6-14.xlsx", The products are on the rows and identified by either product code or alt code, and the ship point# are on the columns. For example, in "Domestic SMLS Cost" tab of "Topcoder Cost File 2-6-14.xlsx", these numbers "32,21,22,23,19,24" are ship point#.

Please ask questions in the contest forum if you feel anything confusing.

3. The tool must be generic and fast to handle the coming new datum provided by clients. For example, there might be more ship point# and the row number of ship point# might change.

4. Add a button named "Update Prices" on the product admin page. check the attached screen.

Technology Overview

• JAVA
• POI

Final Submission Guidelines

Submission Deliverables

A complete list of deliverables can be viewed in the TopCoder Assembly competition Tutorial at: http://apps.topcoder.com/wiki/display/tc/Assembly+Competition+Tutorials
Below is an overview of the deliverables:

• Updated Source Codes
• Deployment Guide