{"id":345,"date":"2012-10-25T14:56:41","date_gmt":"2012-10-25T12:56:41","guid":{"rendered":"http:\/\/www.h-hennes.fr\/blog\/?p=345"},"modified":"2013-07-24T21:09:08","modified_gmt":"2013-07-24T19:09:08","slug":"magento-erreurs-dans-les-rapports-multisites-multidevises","status":"publish","type":"post","link":"https:\/\/www.h-hennes.fr\/blog\/2012\/10\/25\/magento-erreurs-dans-les-rapports-multisites-multidevises\/","title":{"rendered":"Magento : Erreurs dans les rapports Multisites \/ Multidevises"},"content":{"rendered":"<p>J&rsquo;ai r\u00e9cemment \u00e9t\u00e9 confront\u00e9 \u00e0 un probl\u00e8me dans les rapports Magento pour une boutique\u00a0 comportant plusieurs sites.<br \/>\nPour le site Anglais utilisant la livre sterling (\u00a3) les montants des rapports \u00e9taient toujours \u00e9gal \u00e0 0, comme vous pouvez le voir sur la capture suivante.<br \/>\n( Aucun probl\u00e8me pour les autres sites, car la monnaie par d\u00e9faut est l&rsquo;Euro (\u20ac) )<\/p>\n<p><a href=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/export-0.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-346\" title=\"Erreur Export Magento Montant 0\" src=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/export-0.png\" alt=\"Erreur Export Magento Montant 0\" width=\"640\" height=\"408\" srcset=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/export-0.png 640w, https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/export-0-300x191.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Apr\u00e8s pas mal de recherches j&rsquo;ai trouv\u00e9 que le probl\u00e8me \u00e9tait li\u00e9 au fait que les taux de devises n&rsquo;\u00e9taient pas d\u00e9finis dans \u00ab\u00a0Syst\u00e8me \/ Gestion des taux des devises\u00a0\u00bb, comme vous pouvez le voir sur la capture ci-dessous :<\/p>\n<p><a href=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/gestion-devises1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348\" title=\"gestion-devises\" src=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/gestion-devises1.png\" alt=\"Gestion des taux de devises Magento\" width=\"600\" height=\"86\" srcset=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/gestion-devises1.png 600w, https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/gestion-devises1-300x43.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>Pour que les donn\u00e9es des prochaines commandes soient correctes, il faut renseigner un taux entre ces 2 devises.<br \/>\nDans mon cas je vais partir du postulat 1\u20ac = 1\u00a3 et renseigner les champs en cons\u00e9quence.<\/p>\n<p>A pr\u00e9sent il va falloir r\u00e9gler le cas de toutes les commandes d\u00e9j\u00e0 pass\u00e9es.<br \/>\nPour r\u00e9aliser ses rapports, magento utilise le champ \u00ab\u00a0base_to_global_rate\u00a0\u00bb dans la table \u00ab\u00a0sales_flat_order\u00a0\u00bb.<br \/>\nPour toutes nos anciennes commandes celui-ci a la valeur \u00ab\u00a00.0000\u00a0\u00bb comme aucun taux n&rsquo;\u00e9tait d\u00e9fini.<\/p>\n<p>Ce champ n&rsquo;est malheureusement pas \u00e9ditable directement depuis l&rsquo;administration.<br \/>\nNous allons donc mettre \u00e0 jour la table avec les bonnes valeurs via la requ\u00eate SQL suivante :<\/p>\n<p>(Remplacer les valeurs en italique par les valeurs de votre table)<\/p>\n<p>UPDATE\u00a0 <span style=\"color: #ff0000;\"><em>prefix<\/em><\/span>_sales_flat_order SET base_to_global_rate = &lsquo;<span style=\"color: #ff0000;\"><em>your RateValue<\/em><\/span>&lsquo;\u00a0 WHERE store_id= <span style=\"color: #ff0000;\"><em>store_id<\/em><\/span><\/p>\n<p>Dans mon cas la requ\u00eate est donc la suivante :<\/p>\n<pre lang=\"SQL\">\r\nUPDATE mag_sales_flat_order SET base_to_global_rate = '1.0000' WHERE store_id=2\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Une fois la requ\u00eate effectu\u00e9e, il faut maintenant rafraichir les statistiques de magento :<\/p>\n<p>Cocher l&rsquo;ensemble des rapports et s\u00e9lectionner l&rsquo;action \u00ab\u00a0<span style=\"text-decoration: underline;\">Rafra\u00eechir les statistiques depuis le d\u00e9but<\/span>\u00a0\u00bb<\/p>\n<p><a href=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rafraichir-stats.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-349\" title=\"rafraichir-stats\" src=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rafraichir-stats.png\" alt=\"Rafraichier Statistiques Magento\" width=\"600\" height=\"170\" srcset=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rafraichir-stats.png 600w, https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rafraichir-stats-300x85.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Vous pouvez \u00e0 pr\u00e9sent relancer vos rapports et les donn\u00e9es seront bien affich\u00e9es !<\/p>\n<p><a href=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rapports-ok.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-350\" title=\"rapports-ok\" src=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rapports-ok.png\" alt=\"Rapports Magento OK\" width=\"600\" height=\"398\" srcset=\"https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rapports-ok.png 600w, https:\/\/www.h-hennes.fr\/blog\/wp-content\/uploads\/2012\/10\/rapports-ok-300x199.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>J&rsquo;ai r\u00e9cemment \u00e9t\u00e9 confront\u00e9 \u00e0 un probl\u00e8me dans les rapports Magento pour une boutique\u00a0 comportant plusieurs sites. Pour le site Anglais utilisant la livre sterling (\u00a3) les montants des rapports \u00e9taient toujours \u00e9gal \u00e0 0, comme vous pouvez le voir sur la capture suivante. ( Aucun probl\u00e8me pour les autres sites, car la monnaie par [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[246,6],"tags":[150,221],"class_list":["post-345","post","type-post","status-publish","format-standard","hentry","category-magento-2","category-trucs-et-astuces","tag-magento","tag-rapports-specifiques"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":3,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/345\/revisions"}],"predecessor-version":[{"id":480,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/345\/revisions\/480"}],"wp:attachment":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/media?parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/categories?post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/tags?post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}