Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Fatturato nella dashboard
 
TreInnova
Guru
 
Avatar
Total Posts:  465
Joined:  2009-02-20
Fano
 

Buon giorno a tutti,
vorrei condividere una cosa che spesso mi chiedono i clienti. Cosa significa fatturato dall’inizio sulla dashboard?
Come viene eseguito il calcolo?
Questa è la query svolta che viene eseguita:

SELECT SUM((IFNULL(main_table.base_total_invoiced0) -
                    
IFNULL(main_table.base_tax_invoiced0) -
                    
IFNULL(main_table.base_shipping_invoiced0) -
                    (
IFNULL(main_table.base_total_refunded0) -
                    
IFNULL(main_table.base_tax_refunded0) -
                    
IFNULL(main_table.base_shipping_refunded0))) * main_table.base_to_global_rate) AS `lifetime`,
                    
AVG((IFNULL(main_table.base_total_invoiced0) - IFNULL(main_table.base_tax_invoiced0) - IFNULL(main_table.base_shipping_invoiced0) - (IFNULL(main_table.base_total_refunded0) - IFNULL(main_table.base_tax_refunded0) - IFNULL(main_table.base_shipping_refunded0))) * main_table.base_to_global_rate) AS `averageFROM `mag_sales_flat_order` AS `main_tableWHERE (main_table.status NOT IN('canceled')) AND (main_table.state NOT IN('new''pending_payment'))
Tradotto :
il totale riportato è :
(Fatturato - tasse- spedizioni) - (refounded - tasse refounded - refounded spedizioni)
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top