Jump to content

rawad00

Members
  • Posts

    6
  • Joined

  • Last visited

1 Follower

Profile Information

  • Activity
    User/Merchant

rawad00's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Yes there's an Aramex module for prestashop: http://addons.prestashop.com/en/shipping-logistics-delivery-prestashop-modules/18815-aramex-shipping-module.html
  2. This bug is also reported: http://forge.prestashop.com/plugins/servlet/mobile#issue/PNM-2956
  3. Hello, could you help please? I set prestashop 1.6 and having a problem in the stats dashboard, the total sales doesn't take in consideration returns & refunds. Calculations for my customer are all wrong. Total Sales = all sales and not all sales - refunds Have you provided any fix for this? Do you have an idea how and where I can fix it? Thank you in advance
  4. Merci pour ta reponse, j'ai cherche dans mon prestashop version 1.6. J'ai trouve un controlleur different, AdminHomeController.php n'existant plus dans la 1.6, a la place j'ai trouve AdminStatsController.php contenant la methode suivante : public static function getTotalSales($date_from, $date_to, $granularity = false) { if ($granularity == 'day') { $sales = array(); $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT LEFT(`invoice_date`, 10) as date, SUM(total_paid_tax_excl / o.conversion_rate) as sales FROM `'._DB_PREFIX_.'orders` o WHERE `invoice_date` BETWEEN "'.pSQL($date_from).' 00:00:00" AND "'.pSQL($date_to).' 23:59:59" '.Shop::addSqlRestriction(false, 'o').' GROUP BY LEFT(`invoice_date`, 10)'); foreach ($result as $row) $sales[strtotime($row['date'])] = $row['sales']; return $sales; } elseif ($granularity == 'month') { $sales = array(); $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT LEFT(`invoice_date`, 7) as date, SUM(total_paid_tax_excl / o.conversion_rate) as sales FROM `'._DB_PREFIX_.'orders` o WHERE `invoice_date` BETWEEN "'.pSQL($date_from).' 00:00:00" AND "'.pSQL($date_to).' 23:59:59" '.Shop::addSqlRestriction(false, 'o').' GROUP BY LEFT(`invoice_date`, 7)'); foreach ($result as $row) $sales[strtotime($row['date'].'-01')] = $row['sales']; return $sales; } else return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT SUM(total_paid_tax_excl / o.conversion_rate) FROM `'._DB_PREFIX_.'orders` o WHERE `invoice_date` BETWEEN "'.pSQL($date_from).' 00:00:00" AND "'.pSQL($date_to).' 23:59:59" '.Shop::addSqlRestriction(false, 'o')); } Par contre, une boucle for est utilise, je ne vois comment deduire les retour marchandise du calcul. Vous vous baser sur la table credit-slips? ca veut dire peut importe le moyen de payment utiliser (remboursement direct, remboursement par coupon, ...) ca suffira? Vous avez une idee comment mettre a jour cette version afin de corriger ce bug? Merci d'avance
  5. Bonjour, Vos idees sont les bienvenues.. Je rencontre un bug/processus incomplet de la reprise de marchandise. Apres une reprise de marchandise (RMA Return Merchandise) et un remboursement total au client (Refund) le tableau de bord indiquant les statistiques des ventes ne se met pas a jour et ne deduit pas le prix des produits retournes (Dashboard Sales total not updating total price after a complete refund) Any ideas? Des idees? Merci
  6. Hello, I am using Prestashop 1.6. Upon an RMA and after completing the return process and submitting a Refund of the total amount, the dashboard stats are not deducting the refunded amount from the total Sales amount stats. The stock is updated but not the Dashboard stats total amount. Any ideas to fix that? Are there any fixes? Am I missing something? Thank you in advance for your help
×
×
  • Create New...