Awarded

Magento extension Tech Spec

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/[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.

Skills: Magento

See more: magento tech spec, tech data, sql create table price, execution table, exchange currency rates table, currency table rate, currency rate table, currency rates table, call tech, Spec, magento server configuration, magento extension, key value model, it spec, magento create admin, import data csv sql server, sql server import text, text file import sql server, magento indexer, magento extension configuration, magento create table, csv import sql server, import data ftp sql server, email indexer, import sql ftp

About the Employer:
( 0 reviews ) Russian Federation

Project ID: #5080503

1 freelancer is bidding on average $150 for this job

dannv

Hired by the Employer

$150 USD in 4 days
(228 Reviews)
7.1