Closed

Magento extension Tech Spec:

This project received 1 bids from talented freelancers with an average bid price of $150 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$150 USD
Total Bids
1
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 [url removed, login to view]

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,[url removed, login to view]

4. Dataflow profile should parse the CSV from "/var/import/[url removed, login to view]" (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" = "[url removed, login to view]" * "w3i_exchange_rate"

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online