Create Custom Magento Report based on Product Option Custom Attribute -- 2
$30-250 USD
Terminado
Publicado hace alrededor de 9 años
$30-250 USD
Pagado a la entrega
We're looking to create a custom report that allows reconciling cost of goods sold with order data - e.g. an order grid that contains the product option's custom attribute "cost" as a sum for each reporting period.
A custom attribute named "cost" has been added to every custom option in our catalog (there is now a "cost" column in the catalog_product_option_type_value table).
Essentially, what I need in the report is as follows:
(a line for each reporting period, based on a custom date range that allows me to show results by day, month, or year)
# of orders during the period (not including canceled/refunded orders)
# of items ordered during the period (not including canceled/refunded items)
total revenue during the period (based on base_row_total, not including canceled/refunded revenue)
total cost during the period (sum of all costs based on all items ordered during the period, not including canceled/refunded cost)
total shipping cost (=[# of orders * $1.50]+[# of items * $4.50], not including canceled/refunded cost)
The report should have a separate link in the adminhtml menu (along with acl permissions listed in config->permissions->roles->resources) so I can give access to specific Magento roles after it is installed.
I need this report to be created on a development server (which you need to provide) and then make it transferable to my live server (which I will do with your instruction). To do this, use any existing installation of Magento and just add the column "cost" to the catalog_product_option_type_value table - then you can put in sample values for cost.
My assumption is that you will need to write custom renderers, as the product_option data in the sales_flat_order_item table is serialized (which is a pain).
This job will not be considered complete until the report is functioning on my live server.
Please feel free to ask questions. Thank you for looking!
Hello,
I am working on magento last 4 years. Over all 10 years on web development experience. you can give me chance to prove myself. I shall give you details in chat.
I shall give you example site in the time of conversion.
Thanks & regards
pradip
$155 USD en 3 días
5,0 (42 comentarios)
5,2
5,2
2 freelancers están ofertando un promedio de $244 USD por este trabajo
Hi,
Hope all is well. We would like to take this opportunity to introduce to our recent start up software company based in India.
"Pure Imagination". Since we have recently started the only thing which we have along with us is our 16 years of experience.
In other way if we summarize we are SMALL company with BIG experience.
We have gone through your requirements and do have few queries which we would like to discuss.
Please suggest good time to connect ?
We have our expertise in Magento, Php & open source platforms. Not only this but we do have Magento Certified Developers in our team.
Our Magento Expertise includes :
--------------------------------------------------------------
1) Reward Points + Referral program , One Step Checkout
2) Magento theming (design and development) & Magento customized extensions.
3) Module development Magento third party integrations ( ERP, inventory systems, email list tools etc ).
4) Magento Version Upgrades & Magento mobile site.
5) Magento store app.
6) Magento performance tuning & optimization.
7) Magento localization ( multi-currency and multi-language implementations)
8) Custom Magento modifications and development.
-------------------------------------------------------------
Note : Budget provided is just an arbitrary estimate. The same could increase/decrease once the scope of work has been fixed after a detail discussion/ analysis.
Thanking You,
Pure Imagination Team.