Magento extension Tech Spec:

AWARDED
Project Budget (USD)
$150

Project Description:

Could you please estimate the work described in this email below?


Magento extension Tech Spec:

1. Create a new module for "Magento Community Edition 1.8.0.0" under "local" namespace and call it "W3i_ImportRates".

2. Create a configuration var "w3i/w3i_rates/w3i_exchange_rate" under "System -> Configuration -> W3i -> Rates -> Exchange Rate" with default value set to 0.45

3. The new module should create an "Advanced Dataflow Profile" using the data install interface. Name for the profile is "Import Custom Rates".

Created profile will be used by an admin to import a CSV file located on the server into a new table, that has to be created using sql install interface.

The table should be called "w3i_rates" and should have 3 fields:
- "country" - varchar(32) NULL
- "group" - varchar(32) NULL
- "rate" - decimal(12,4) NOT NULL
- PRIMARY KEY ("country", "group")

CSV format:
"country,group,rate"

where:
- "country" is a country code in ISO 3166
- "group" is a free text
- "rate" price in some currency

CSV Example:
country,group,rate
FR,ven123,25.00

4. Dataflow profile should parse the CSV from "/var/import/w3irates.csv" (will be uploaded manually over the FTP) and populate "w3i_rates" table.
Table should be truncated before the import.

5. It is also required to create a Custom Indexer Model that will populate an index table called "w3i_rates_idx", once dataflow profile execution is over or the "w3i_exchange_rate" value is changed. Also the index can be rebuilt manually from "System -> Index Management".
Index Name in the backend: Custom Rates Index

"w3i_rates_idx" table should have 3 fields:
- "country" - varchar(32) NULL
- "group" - varchar(32) NULL
- "final_rate" - decimal(12,4) NOT NULL
- PRIMARY KEY ("country", "group")

where "final_rate" value is a "rate" value taken from "w3i_rates" table and multiplied by "w3i_exchange_rate".

So, "w3i_rates_idx.final_rate" = "w3i_rates.rate" * "w3i_exchange_rate"

6. The final module should be packaged using "System -> Magento Connect -> Package Extensions" and sent back as a single file.

Skills required:
Magento
Hire snorch
Project offered by:
snorch Russian Federation
Verified
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 4 days