Create a new module for "Magento Community Edition"

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

Magento extension Tech Spec:

1. Create a new module for "Magento Community Edition" 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" is a country code in ISO 3166

- "group" is a free text

- "rate" price in some currency

CSV Example:



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.

Habilidades: Magento

Veja mais: where is community set, sql create table price, execution table, exchange currency rates table, currency table rate, currency rate table, currency rates table, backend module, new fr, magento server configuration, key value model, 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, magento tech spec, import data ftp sql server, email indexer, import sql ftp, create table using, magento install sql

Acerca do Empregador:
( 0 comentários ) Russian Federation

ID do Projeto: #5080491

1 freelancer está oferecendo em média $150 para esse trabalho


Hired by the Employer

$150 USD in 4 dias
(228 Comentários)