Create a module for Magento based store

Our client needs to create a simple module/extension for Magento-based store that will extract data from DB and generate CSV file from it.

Functional requirements:

(F1) The module shall extract order/shipment/customer data from the DB i.e. specific fields from sales_flat_order, sales_flat_shipment tables etc.

(F2) The data fields extracted in F1 shall be used to generate rows in the CSV file (each row will have approximately 12 columns)

(F3) Additional values should be written to the same CSV file based on a set of few simple rules

e.g. $product = Mage::getModel('catalog/product');

if ($product->getWeight () == someValue)

// set value in Column B of CSV file to 0.5

We will provide the rules.

(F4) The module shall be accessible from the admin interface. Specifically, the module should be available via Actions provided on the Orders page, and as the section on the New Shipment page.

(F4.1) New Shipment page:

(F4.1.1) On the New Shipment page, a new section should be added (e.g. under Shipment Comments section) that will show the values, generated in F2 and F3, to be written to the CSV file.

(F4.1.2) All values shown in the new section from (F4.1.1) should be editable by the user via Textboxes/checkboxes/drop downs depending on the specific field.

(F4.1.3) Once the "Submit Shipment" button clicked the values shown in the new section from should be written to a temporary DB table.

(F4.2) Orders page:

(F4.2.1) New Action should be added to the Orders page, call it "Generate Shipment CSV". Once the user clicks on this Action, all values from the temporary DB table from (F4.1.3) shall be written to the CSV file. The file should be named according to the current date i.e. "[login to view URL]"

(F4.2.2) Once (F4.2.1) is completed, the "File Save" dialog shall be displayed so that the user can download the CSV file locally.

(F4.2.3) Once (F4.2.2) is completed the temporary table should be emptied.

Non-Functional requirements:

(NF1) The module should not change any of the base/core files.

(NF2) The module should be portable so it can be utilized in Magento 1.9 (we are planning to upgrade the store to 1.9 very soon, so if we are happy with your work, we will use you for the upgrade, and will also hire you to perform a number of functional changes / updates).

(NF3) We won't be providing access to our backend i.e. Magento system. Instead, you will have to develop and test the module on your testing server. This is the only way we can insure that requirements NF1 and NF2 are satisfied.

(NF4) You will have to sign off the copyright and IP of the produced source code to us as per request of our client.

Magento MySQL PHP

Project ID: #6598294

About the project