[Skip to main content](#vessel-content)

Board Categories Reports & Statistics

##

#  [Reports & Statistics](/forum/36-reports-statistics "View Category 'Reports & Statistics'")  341 topics

| All there is to know about reports and statisctics |
|---|

##

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post |
|---|---|---|---|
| [](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields) | [Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1  Because we rent out items, we cannot run reports by &quot;order date&quot;. I created a custom field with a calendar for the customer to advise the event date.  1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 3 months ago, by [BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")       [Last Post](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247311 "Hi,  Reading your other thread   www.hikashop.com/forum/product-category-...r-date-of-event.html  I now understand what you want and why you want it. But I don't see how you'll be able to have what you want with what is already available. What you can do with mass actions is to create several mass actions, one for each date of event, with something like that:   take.ms/OFPrF  And that will give you a listing of the products bought for a specific day with the quantities purchased, and you would have to manually sum the quantities to know the amount ordered for each product. So it's not really practical for what you want to do with it.") 10 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5  Views:1881 | [Last Post](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247311 "Hi,  Reading your other thread   www.hikashop.com/forum/product-category-...r-date-of-event.html  I now understand what you want and why you want it. But I don't see how you'll be able to have what you want with what is already available. What you can do with mass actions is to create several mass actions, one for each date of event, with something like that:   take.ms/OFPrF  And that will give you a listing of the products bought for a specific day with the quantities purchased, and you would have to manually sum the quantities to know the amount ordered for each product. So it's not really practical for what you want to do with it.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/885867-paypal-sandbox-test) | [paypal sandbox test](/forum/36-reports-statistics/885867-paypal-sandbox-test "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.6.21  Bonjour,  Je viens de faire des tests avec la sandbox de paypal afin de savoir si avec les mises à jours prévu par Paypal je ne vais pas me retrouver avec des problèmes de paiement. Sur mon site j'utilise une boutique hikashop mais également sur des pages specifiques non liées à hikashop des boutons d'achat immédiat générés par paypal.  J'ai donc fait des tests avec la sandbox de paypal et pour les boutons achats immédiats tout fonctionne bien en revanche pour la commande passée par hikashop je n'obtiens pas de confirmation de paiement. La commande est bien créee sur hikashop mais le paiement ne passe pas en mode confirmation alors que le paiement est validé.  J'ai voulu regardé mes logs de paiement mais rien ne s'affiche dedans la dernière ligne du fichiers logs date d'avant la mise à jour vers 2.6.3 et indique  alors que j'ai eu d'autres commandes depuis cette date du 28 Mai  Selon vous : 1 - Pourquoi le message de confirmation de paiement n'est pas transmis à hikashop par la sandbox ? est ce que cela signifie que lorsque les changements seront officiels sur paypal (sh4-256 et G5) je ne serais plus en mesure d'avoir des commandes payées par paypal ?  2- Pourquoi je n'ai plus d'info sur mes logs de paiements dans le fichier alors que tout semblait bien fonctionner jusque là ? pour info le mode debug est bien activé que cela soit pour paypal normal ou paypal en mode sandbox.  Merci d'avance pour votre aide")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 3 months ago, by [webme](/forum/user/30777-webme "View webme's Profile")       [Last Post](/forum/36-reports-statistics/885867-paypal-sandbox-test#247273 "Bonjour,  Vous dites que la seule chose différente entre les deux, c'est l'URL de la méthode de paiement. Mais je pense qu'il y a une autre différence dont vous n'avez pas parlé. Si vous regardez les deux logs d'accès, il y a deux différences: L'une ne fonctionne pas avec une erreur 403 et le paramètre Itemid 245, et l'autre fonctionne avec le paramètre Itemid 778 Ce paramètre Itemid correspond à l'id d'un élément de menu de votre site web. HikaShop fourni l'id correspondant à l'Itemid courant durant le passage en caisse. Et les erreurs 403 arrivent le plus souvent quand l'URL est pour un composant différent du composant du type d'élément de menu de l'Itemid de l'URL. En clair, il est probable que l'élément de menu avec l'id 245 ne soit pas d'un type d'élément de menu HikaShop. Et cela, le système SEF de Joomla n'aime pas. Il y a d'autres possibilités, qui font qu'il y ait un problème avec cet élément de menu 245, par exemple, un problème avec le niveau d'accès de votre élément de menu 245:   www.hikashop.com/support/documentation/i...or.html#notification  Mais de toute façon, durant le passage en caisse, que vous utilisiez la sandbox ou pas, l'id du menu courant devrait normalement être le même. Donc je suppose que vous accédez à un élément de menu particulier pour vos tests sandbox par rapport aux achats live sur votre site et c'est cela qui fait que la notification ne fonctionne pas car il y a un problème avec cet élément de menu. Le plus simple dans ce cas est de sélectionner l'élément de menu avec l'id 778 dans l'option &quot;force menu on checkout&quot; de la configuration HikaShop. Ainsi, le même élément de menu sera utilisé durant le passage en caisse, peu importe d'où arrive le client sur votre site et ainsi, vous aurez exactement la même URL de notification dans les deux cas, et la notification sera correctement passée à HikaShop dans les deux cas.") 10 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9  Views:2072 | [Last Post](/forum/36-reports-statistics/885867-paypal-sandbox-test#247273 "Bonjour,  Vous dites que la seule chose différente entre les deux, c'est l'URL de la méthode de paiement. Mais je pense qu'il y a une autre différence dont vous n'avez pas parlé. Si vous regardez les deux logs d'accès, il y a deux différences: L'une ne fonctionne pas avec une erreur 403 et le paramètre Itemid 245, et l'autre fonctionne avec le paramètre Itemid 778 Ce paramètre Itemid correspond à l'id d'un élément de menu de votre site web. HikaShop fourni l'id correspondant à l'Itemid courant durant le passage en caisse. Et les erreurs 403 arrivent le plus souvent quand l'URL est pour un composant différent du composant du type d'élément de menu de l'Itemid de l'URL. En clair, il est probable que l'élément de menu avec l'id 245 ne soit pas d'un type d'élément de menu HikaShop. Et cela, le système SEF de Joomla n'aime pas. Il y a d'autres possibilités, qui font qu'il y ait un problème avec cet élément de menu 245, par exemple, un problème avec le niveau d'accès de votre élément de menu 245:   www.hikashop.com/support/documentation/i...or.html#notification  Mais de toute façon, durant le passage en caisse, que vous utilisiez la sandbox ou pas, l'id du menu courant devrait normalement être le même. Donc je suppose que vous accédez à un élément de menu particulier pour vos tests sandbox par rapport aux achats live sur votre site et c'est cela qui fait que la notification ne fonctionne pas car il y a un problème avec cet élément de menu. Le plus simple dans ce cas est de sélectionner l'élément de menu avec l'id 778 dans l'option &quot;force menu on checkout&quot; de la configuration HikaShop. Ainsi, le même élément de menu sera utilisé durant le passage en caisse, peu importe d'où arrive le client sur votre site et ainsi, vous aurez exactement la même URL de notification dans les deux cas, et la notification sera correctement passée à HikaShop dans les deux cas.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/885904-hikashop-google-dynamic-remarketing-conversion-tr) | [HikaShop Google Dynamic Remarketing (conversion tr](/forum/36-reports-statistics/885904-hikashop-google-dynamic-remarketing-conversion-tr "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3,6  Maybe I'm slow, but how does the &quot;HikaShop Google Dynamic Remarketing (conversion tracking)&quot; plugin work ? and what is it actually for ?  I know Google adwords remarketing work, but how this it work with this plugin, and what is the advantage of using it ?  Tnx")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 3 months ago, by [river](/forum/user/9591-river "View river's Profile")       [Last Post](/forum/36-reports-statistics/885904-hikashop-google-dynamic-remarketing-conversion-tr#247112 "Hi,  I think that if the plugin wasn't working, it would be removed from HikaShop packages :) You can find users who are using it :   www.hikashop.com/forum/product-category-...arketing-plugin.html  Now the goal of the plugin is to find HTML input in the webpage and to extract the product ids of them. Then it will add some javascript at the end of the webpage to include the google remarketing code and gave him the list of the products displayed in that page.  If you're website have some cache and the plugin cannot access to the webpage content on the trigger &quot;onAfterRender&quot;, it could explain why you do not have any javascript at the end of your page. Also, if you have some javascript errors in your website, the script added at the bottom might not be executed.  Regards,") 10 years 3 months ago     by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:1  Views:2125 | [Last Post](/forum/36-reports-statistics/885904-hikashop-google-dynamic-remarketing-conversion-tr#247112 "Hi,  I think that if the plugin wasn't working, it would be removed from HikaShop packages :) You can find users who are using it :   www.hikashop.com/forum/product-category-...arketing-plugin.html  Now the goal of the plugin is to find HTML input in the webpage and to extract the product ids of them. Then it will add some javascript at the end of the webpage to include the google remarketing code and gave him the list of the products displayed in that page.  If you're website have some cache and the plugin cannot access to the webpage content on the trigger &quot;onAfterRender&quot;, it could explain why you do not have any javascript at the end of your page. Also, if you have some javascript errors in your website, the script added at the bottom might not be executed.  Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/885472-numbers-in-checkout-align-decimal-tab) | [Numbers in checkout &gt;align decimal tab](/forum/36-reports-statistics/885472-numbers-in-checkout-align-decimal-tab "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.5 -- Browser(s) name and version -- : FIREFOX 46.0.1  Hi,  I'd like to get some order on shopping list when checking out, as well in invoice. What di I have to do to align numbers an currency symbol in decimal tab &gt; see attachment. Thanks a lot or any suppport.  Walter")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 4 months ago, by [walter53\_2](/forum/user/34023-walter53-2 "View walter53&#95;2's Profile")       [Last Post](/forum/36-reports-statistics/885472-numbers-in-checkout-align-decimal-tab#246731 "Hi,  1. If you don't need the affiliation feature, turn off the HikaShop affiliate plugin via the Joomla plugins manager and that will remove that button.  2. There is no option for that. You'll have to edit the file &quot;notice&quot; of the view &quot;checkout&quot; via the menu Display&gt;Views and change the link there. Here is a topic which talks in length about that:   www.hikashop.com/forum/3-bug-report/1135...ot-workig.html#11364") 10 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:14  Views:2265 | [Last Post](/forum/36-reports-statistics/885472-numbers-in-checkout-align-decimal-tab#246731 "Hi,  1. If you don't need the affiliation feature, turn off the HikaShop affiliate plugin via the Joomla plugins manager and that will remove that button.  2. There is no option for that. You'll have to edit the file &quot;notice&quot; of the view &quot;checkout&quot; via the menu Display&gt;Views and change the link there. Here is a topic which talks in length about that:   www.hikashop.com/forum/3-bug-report/1135...ot-workig.html#11364") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/870084-export-order-information) | [export order information](/forum/36-reports-statistics/870084-export-order-information "I only need a few, such as order number, customer, date, product and quantity, order status, total, and order id (basically the same column as you see in the screenshot) so the CSV file will only...")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 12 years 3 months ago, by [jonathan.lee](/forum/user/33479-jonathan-lee "View jonathan.lee's Profile")       [Last Post](/forum/36-reports-statistics/870084-export-order-information?start=20#246104 "Hi,  It will require loading the brand name from the database with a left join query between the product and category table as the data isn't stored in the $rows array coming from the order in the database. You'll need a developer to help you with that.") 10 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")   - [1](/forum/36-reports-statistics/870084-export-order-information?start=0 "Page:1") - [2](/forum/36-reports-statistics/870084-export-order-information?start=20 "Page:2") | Replies:21  Views:7660 | [Last Post](/forum/36-reports-statistics/870084-export-order-information?start=20#246104 "Hi,  It will require loading the brand name from the database with a left join query between the product and category table as the data isn't stored in the $rows array coming from the order in the database. You'll need a developer to help you with that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/885647-move-postal-code-in-shipping-invoice) | [Move postal code in shipping invoice](/forum/36-reports-statistics/885647-move-postal-code-in-shipping-invoice "-- HikaShop version -- : 2.6.3  I want to move the zip/postal code of the customer on my shipping invoices. The line currently reads &quot;24450 Lexington Virginia&quot;, but I want it to read &quot;Lexington Virginia 24450&quot;. How would this be done?")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 3 months ago, by [hsojhsoj](/forum/user/1921-hsojhsoj "View hsojhsoj's Profile")       [Last Post](/forum/36-reports-statistics/885647-move-postal-code-in-shipping-invoice#245891 "Hi,  You want to edit the file &quot;address&#95;template&quot; for both your frontend and backend template via the menu Display&gt;Views.") 10 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:1567 | [Last Post](/forum/36-reports-statistics/885647-move-postal-code-in-shipping-invoice#245891 "Hi,  You want to edit the file &quot;address&#95;template&quot; for both your frontend and backend template via the menu Display&gt;Views.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 3 months ago |
| [](/forum/36-reports-statistics/885287-customer-report-returns-sql-error) | [Customer Report Returns SQL Error](/forum/36-reports-statistics/885287-customer-report-returns-sql-error "-- url of the page with the problem -- :   offeringsjewelry.com  -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.8 -- PHP version -- : 5.4 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'cat.category&#95;id' in 'where clause' SQL=SELECT &#42;, SUM( case when o.order&#95;currency&#95;id = '2' then o.order&#95;full&#95;price end ) AS Total, COUNT(o.order&#95;id) AS order&#95;number FROM #&#95;&#95;hikashop&#95;order as o LEFT JOIN #&#95;&#95;hikashop&#95;user as a ON o.order&#95;user&#95;id=a.user&#95;id LEFT JOIN #&#95;&#95;users as u ON u.id=a.user&#95;cms&#95;id WHERE a.user&#95;partner&#95;activated=0 AND cat.category&#95;id IN ('0','2','34','88','35','13','15','16','17','18','23','24','25','26','27','28','30','31','32','85','33','36','37','38') AND a.user&#95;created &gt; 1435509022 AND a.user&#95;created  Hello,  I am trying to create a report that lists the best customers by total Sales.  Here's the screenshot of my configuration:  Here's the error I get: 1054 Unknown column 'cat.category&#95;id' in 'where clause' SQL=SELECT &#42;, SUM( case when o.order&#95;currency&#95;id = '2' then o.order&#95;full&#95;price end ) AS Total, COUNT(o.order&#95;id) AS order&#95;number FROM #&#95;&#95;hikashop&#95;order as o LEFT JOIN #&#95;&#95;hikashop&#95;user as a ON o.order&#95;user&#95;id=a.user&#95;id LEFT JOIN #&#95;&#95;users as u ON u.id=a.user&#95;cms&#95;id WHERE a.user&#95;partner&#95;activated=0 AND cat.category&#95;id IN ('0','2','34','88','35','13','15','16','17','18','23','24','25','26','27','28','30','31','32','85','33','36','37','38') AND a.user&#95;created &gt; 1435509022 AND a.user&#95;created ")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 4 months ago, by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")       [Last Post](/forum/36-reports-statistics/885287-customer-report-returns-sql-error#244481 "Great! Thank you so much for all the help.") 10 years 4 months ago     by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile") | Replies:6  Views:1317 | [Last Post](/forum/36-reports-statistics/885287-customer-report-returns-sql-error#244481 "Great! Thank you so much for all the help.") by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")      10 years 4 months ago |
| [](/forum/36-reports-statistics/884706-wrong-sales-statistics-in-google-analytics) | [Wrong sales statistics in Google Analytics](/forum/36-reports-statistics/884706-wrong-sales-statistics-in-google-analytics "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.5 -- PHP version -- : 5.3.29  Hello, I have enabled HikaShop Google Analytics plugin, but I see wrong statistics in GA. See attached examples. I understand that Orders page in Hikashop doesn't include shipping. Let me choose one of the orders and show detailed view. Let's choose order number 138. I attached screenshot for this order. As you can see from screenshot - user paid 184.4 AUD. But I see 319.5 AUD for this order in GA. I also attached my plugin confuguration.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 5 months ago, by [mypetfly](/forum/user/39734-mypetfly "View mypetfly's Profile")       [Last Post](/forum/36-reports-statistics/884706-wrong-sales-statistics-in-google-analytics#243906 "Hi,  Cf :   developers.google.com/analytics/devguide...nalyticsjs/ecommerce  Your order have 10% taxes. Total : 18.05 (16.41 + 1.64)  So we can see how the different parts are composed (with a little approximation due to some rouding). Subtotal: $12.00 (10.90 + 1.1) Shipping: $6.05 (5.5 + 0.55)  The 11.46 you have in Google Analytics reports can be processed like that : 12 + 1.1 - 1.64 = 11.46 Which does not have any logical sense.  What you can do is activate the &quot;debug&quot; mode in the Google Analytics plugin so you will have some trace in the HikaShop payment log for the calls made to the analytics plateform. There you will be able to see what content has been processed for the tax.  Regards,") 10 years 4 months ago     by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:8  Views:1699 | [Last Post](/forum/36-reports-statistics/884706-wrong-sales-statistics-in-google-analytics#243906 "Hi,  Cf :   developers.google.com/analytics/devguide...nalyticsjs/ecommerce  Your order have 10% taxes. Total : 18.05 (16.41 + 1.64)  So we can see how the different parts are composed (with a little approximation due to some rouding). Subtotal: $12.00 (10.90 + 1.1) Shipping: $6.05 (5.5 + 0.55)  The 11.46 you have in Google Analytics reports can be processed like that : 12 + 1.1 - 1.64 = 11.46 Which does not have any logical sense.  What you can do is activate the &quot;debug&quot; mode in the Google Analytics plugin so you will have some trace in the HikaShop payment log for the calls made to the analytics plateform. There you will be able to see what content has been processed for the tax.  Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile")      10 years 4 months ago |
| [](/forum/36-reports-statistics/885014-create-user-groups-with-admin-to-see-reports) | [Create user groups with Admin to see reports](/forum/36-reports-statistics/885014-create-user-groups-with-admin-to-see-reports "-- HikaShop version -- : HikaShop Business 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 7.0.7 -- Browser(s) name and version -- : Firefox 46.0.1  Hey,  Is it possible to create groups of users that can make purchases and assign an Admin to each group that will have the ability to see reports of all the orders made by users in the group?  Thanks")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 5 months ago, by [tariaki](/forum/user/43507-tariaki "View tariaki's Profile")       [Last Post](/forum/36-reports-statistics/885014-create-user-groups-with-admin-to-see-reports#242775 "Hi,  You can contact our partners for such custom work:   www.hikashop.com/home/our-partners.html") 10 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:1315 | [Last Post](/forum/36-reports-statistics/885014-create-user-groups-with-admin-to-see-reports#242775 "Hi,  You can contact our partners for such custom work:   www.hikashop.com/home/our-partners.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 5 months ago |
| [](/forum/36-reports-statistics/885002-the-statistics-on-my-hikashop-dashboard) | [The statistics on my hikashop dashboard](/forum/36-reports-statistics/885002-the-statistics-on-my-hikashop-dashboard "-- url of the page with the problem -- :   www.librishop.eu  -- Joomla version -- : 3.5.1  Hi, in hikashop dashboard don't show the plugin of statistics...i don't undestand why?, because yesterday i saw it. what is the plugin to be activated?  Have a nice day")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 5 months ago, by [marcoboni](/forum/user/31727-marcoboni "View marcoboni's Profile")       [Last Post](/forum/36-reports-statistics/885002-the-statistics-on-my-hikashop-dashboard#242618 "Hi,  It's the Flash plugin. It must be deactivated or uninstalled from your browser.") 10 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:1317 | [Last Post](/forum/36-reports-statistics/885002-the-statistics-on-my-hikashop-dashboard#242618 "Hi,  It's the Flash plugin. It must be deactivated or uninstalled from your browser.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 5 months ago |
| [](/forum/36-reports-statistics/884770-customize-orders-export) | [Customize Orders Export](/forum/36-reports-statistics/884770-customize-orders-export "-- HikaShop version -- : 2.6.2 -- Joomla version -- : 3.5.2  Through another post I was able to figure out how to only pull the data I need for the Orders Export (Mass action does not work for what I need!). I have 4 issues:  1) I need to export the subtotal before tax (same as appears under the individual order Additional Information box). 2) I need to rearrange column order. 3) Change column headers. 4) I also need to pull in coupons and I can't find the variable name for that.  (I am NOT a php programmer, but I understand it a little). Here's my updated export code:  I've attached a screen cap of what it's outputting. Thanks!")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 5 months ago, by [midnites](/forum/user/32921-midnites "View midnites's Profile")       [Last Post](/forum/36-reports-statistics/884770-customize-orders-export#241390 "Hi,  Please note that we offer user support here, not free custom development services. So we can answer questions about how to use HikaShop, and fix issues, but such work ought to be given to a developer you'd hire for that. As I'm nice, I'll give you hints to what you want to do.  1. You would have to manually calculate it out of the product prices similarily to was is done for the calculation of the order&#95;full&#95;tax in the export function of the file administrator/components/com&#95;hikashop/views/order/view.html.php  2. and 3. You want to change your code for the creation of the $new&#95;row and do the foreach on your array of column names (with them in the order you want). Something like that:  And you want to change $first to contain the array of the column names you want in the order you want them.  4. The coupon code is stored in order&#95;discount&#95;code") 10 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:1650 | [Last Post](/forum/36-reports-statistics/884770-customize-orders-export#241390 "Hi,  Please note that we offer user support here, not free custom development services. So we can answer questions about how to use HikaShop, and fix issues, but such work ought to be given to a developer you'd hire for that. As I'm nice, I'll give you hints to what you want to do.  1. You would have to manually calculate it out of the product prices similarily to was is done for the calculation of the order&#95;full&#95;tax in the export function of the file administrator/components/com&#95;hikashop/views/order/view.html.php  2. and 3. You want to change your code for the creation of the $new&#95;row and do the foreach on your array of column names (with them in the order you want). Something like that:  And you want to change $first to contain the array of the column names you want in the order you want them.  4. The coupon code is stored in order&#95;discount&#95;code") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 5 months ago |
| [](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working) | [Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages  We have a report that stopped working and we can't figure out why.  The report will not show products in the top-level category and its sub-categories.  It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters.  Before, we just had the top-level category selected and Yes to Include sub categories.  But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results.  I have tried rebuilding the categories, have even created a new report.  If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with.  Here is what we had before:  Here is the screen shot before we make the change to remove the top level category:  And if we remove the top-level category, and just select the sub levels, we get:  Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up.  Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 6 months ago, by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")       [Last Post](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240291 "Hi,  I've checked on our end but that code has always been like that. I suppose that the difference doesn't come from the version of HikaShop, but from the fact that you've added more categories, no?  That fix will be included in the next version so there will be nothing to do on your end for that.") 10 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5  Views:1776 | [Last Post](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240291 "Hi,  I've checked on our end but that code has always been like that. I suppose that the difference doesn't come from the version of HikaShop, but from the fact that you've added more categories, no?  That fix will be included in the next version so there will be nothing to do on your end for that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 5 months ago |
| [](/forum/36-reports-statistics/884407-ga-track-manual-payment) | [GA track manual payment](/forum/36-reports-statistics/884407-ga-track-manual-payment "Hello,  Is it possible with the analytics plugin to track orders that are not immediatly paid ?  Thanks")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 6 months ago, by [inetis](/forum/user/7157-inetis "View inetis's Profile")       [Last Post](/forum/36-reports-statistics/884407-ga-track-manual-payment#239630 "Merci Nicolas") 10 years 6 months ago     by [inetis](/forum/user/7157-inetis "View inetis's Profile") | Replies:2  Views:1188 | [Last Post](/forum/36-reports-statistics/884407-ga-track-manual-payment#239630 "Merci Nicolas") by [inetis](/forum/user/7157-inetis "View inetis's Profile")      10 years 6 months ago |
| [](/forum/36-reports-statistics/882805-item-description-in-paypal) | [Item description in PayPal](/forum/36-reports-statistics/882805-item-description-in-paypal "-- url of the page with the problem -- : travelsat.com.au -- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 41.0.2 -- Error-message(debug-mod must be tuned on) -- : no message  Hello, For some reason, on most transactions, the item description is missing from the PayPal receipt. The only order where is has actually displayed the product name in the description section is order number 50. In every other order there has been no information in the description section where the product name should be displayed. I have attached a copy of the receipt for order 50 and 1 another order where description is missing.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 8 months ago, by [mypetfly](/forum/user/39734-mypetfly "View mypetfly's Profile")       [Last Post](/forum/36-reports-statistics/882805-item-description-in-paypal?start=20#238821 "The problem with receipts is solved, thanks!") 10 years 6 months ago     by [mypetfly](/forum/user/39734-mypetfly "View mypetfly's Profile")   - [1](/forum/36-reports-statistics/882805-item-description-in-paypal?start=0 "Page:1") - [2](/forum/36-reports-statistics/882805-item-description-in-paypal?start=20 "Page:2") | Replies:31  Views:7619 | [Last Post](/forum/36-reports-statistics/882805-item-description-in-paypal?start=20#238821 "The problem with receipts is solved, thanks!") by [mypetfly](/forum/user/39734-mypetfly "View mypetfly's Profile")      10 years 6 months ago |
| [](/forum/36-reports-statistics/883921-create-cart-conversion-widget) | [Create cart conversion widget](/forum/36-reports-statistics/883921-create-cart-conversion-widget "-- HikaShop version -- : 2.5.1 -- Joomla version -- : 3.5.0 -- PHP version -- : 5.3.24  I would like to be able to have a dashboard widget that would report on and chart time periods the percentage of carts converting to orders. How would I go about doing this?")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 6 months ago, by [deuce4884](/forum/user/38332-deuce4884 "View deuce4884's Profile")       [Last Post](/forum/36-reports-statistics/883921-create-cart-conversion-widget#237126 "Hi,  Sorry, yes. I meant to say &quot;dashboard&quot;.") 10 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:1261 | [Last Post](/forum/36-reports-statistics/883921-create-cart-conversion-widget#237126 "Hi,  Sorry, yes. I meant to say &quot;dashboard&quot;.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 6 months ago |
| [](/forum/36-reports-statistics/872457-low-stock-notification) | [Low stock notification](/forum/36-reports-statistics/872457-low-stock-notification "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 2.5.9 -- PHP version -- : 5.5.37 -- Browser(s) name and version -- : Google Chrome  Is there a way to add a product low stock number so instead of the cron report only showing what had reached a qty of 0, it would send a notification when the stock level reaches i.e. 5")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 12 years 3 weeks ago, by [barkingmoonbat](/forum/user/8080-barkingmoonbat "View barkingmoonbat's Profile")       [Last Post](/forum/36-reports-statistics/872457-low-stock-notification#236583 "Hi,  Like all the emails, you can edit them via the menu System&gt;Emails. And if you want to change the text, you can also use translation overrides:   www.hikashop.com/download/languages.html#modify  The last update option contains the number of seconds from the first january of 1970 to the last time the plugin process was run. That is updated automatically by the plugin to know when to run each time the cron system calls it.") 10 years 7 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:1961 | [Last Post](/forum/36-reports-statistics/872457-low-stock-notification#236583 "Hi,  Like all the emails, you can edit them via the menu System&gt;Emails. And if you want to change the text, you can also use translation overrides:   www.hikashop.com/download/languages.html#modify  The last update option contains the number of seconds from the first january of 1970 to the last time the plugin process was run. That is updated automatically by the plugin to know when to run each time the cron system calls it.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 7 months ago |
| [](/forum/36-reports-statistics/883262-google-analyics-e-commerce-tracking-does-not-work) | [Google Analyics e-commerce tracking does not work](/forum/36-reports-statistics/883262-google-analyics-e-commerce-tracking-does-not-work "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : No error  I am using Hikashop but without a pay button. Customers can order products and the webshop-owner can set an order to 'confirmed' At that time I want GA tracking this orer. But it does not do. The Hikashop GA plugin is activated and also is a javascript with GA-code placed in the template. What to do to get tracking of confirmed orders?")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 7 months ago, by [appletree](/forum/user/35813-appletree "View appletree's Profile")       [Last Post](/forum/36-reports-statistics/883262-google-analyics-e-commerce-tracking-does-not-work#235010 "Yes, this is the solution. Tracking in GA is working.") 10 years 7 months ago     by [appletree](/forum/user/35813-appletree "View appletree's Profile") | Replies:4  Views:1377 | [Last Post](/forum/36-reports-statistics/883262-google-analyics-e-commerce-tracking-does-not-work#235010 "Yes, this is the solution. Tracking in GA is working.") by [appletree](/forum/user/35813-appletree "View appletree's Profile")      10 years 7 months ago |
| [](/forum/36-reports-statistics/883110-problem-with-the-pdd-invoice) | [Problem with the .pdd invoice](/forum/36-reports-statistics/883110-problem-with-the-pdd-invoice "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5  Hello everyone. I installed the plugin .pdf invoices and when I order , the invoice is attached. That 's what I'm doing wrong? Thank you very much")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 7 months ago, by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile")       [Last Post](/forum/36-reports-statistics/883110-problem-with-the-pdd-invoice#233462 "I reinstalled the plugin and have changed the configuration of the states and it works. Thank you so much for everything.") 10 years 7 months ago     by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile") | Replies:3  Views:1374 | [Last Post](/forum/36-reports-statistics/883110-problem-with-the-pdd-invoice#233462 "I reinstalled the plugin and have changed the configuration of the states and it works. Thank you so much for everything.") by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile")      10 years 7 months ago |
| [](/forum/36-reports-statistics/870107-options-to-customize-email-templates) | [Options to customize email templates](/forum/36-reports-statistics/870107-options-to-customize-email-templates "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 2.5.24 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : Chrome  What are our options to customize email templates/autoresponders that we get during customer purchasing and/or backing out of orders?  We'd like to add images and such to the email confirmations customers get so we can point out specific text/copy on the emails to make these areas more obvious.  thank you!")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 12 years 3 months ago, by [solwebsolutions](/forum/user/16564-solwebsolutions "View solwebsolutions's Profile")       [Last Post](/forum/36-reports-statistics/870107-options-to-customize-email-templates#232220 "Hi,  You have to edit the HTML version of the email as Xavier explained in his message:   www.hikashop.com/forum/reports-statistic...emplates.html#166080  There, add the HTML tag for your logo image and modify the CSS code the way you want.") 10 years 8 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5  Views:5835 | [Last Post](/forum/36-reports-statistics/870107-options-to-customize-email-templates#232220 "Hi,  You have to edit the HTML version of the email as Xavier explained in his message:   www.hikashop.com/forum/reports-statistic...emplates.html#166080  There, add the HTML tag for your logo image and modify the CSS code the way you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 8 months ago |
| [](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat) | [Report that filters by country and VAT](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8  Hi,  Is there a way to produce a report on sales by country? Also a report that shows the orders placed in a month and if they were charged VAT or no?  Many thanks.")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 10 years 8 months ago, by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")       [Last Post](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#231044 "Hi,  In that case, you want to export your orders as a CSV either on the orders listing or via the mass action system") 10 years 8 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5  Views:1243 | [Last Post](/forum/36-reports-statistics/882348-report-that-filters-by-country-and-vat#231044 "Hi,  In that case, you want to export your orders as a CSV either on the orders listing or via the mass action system") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      10 years 8 months ago |
| <a id="forumbottom"> </a> [   ](#forumtop) |  |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.050 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)