[Skip to main content](#vessel-content)
# Profile for maartenxbosmans@gmail.com
##
[](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile")
**[ Offline](/forum/user/60008-maartenxbosmans-gmail-com)**
- **User Type:** User
- **Register Date:** 19 Sep 2020
- **Last login:** 2 years 1 month ago
- **Time Zone:** UTC +0:00
- **Local Time:** 00:28
- **Posts:** 3
- **Profile views:** 36
- **Thank you received:** 1
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# maartenxbosmans@gmail.com's recent posts (3 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346629) | [Unbale to export orders with amount of products per order](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346629 "-- HikaShop version -- : 4.6.2 -- Joomla version -- : 4.2.5 -- PHP version -- : 8.1.11 I am trying to look for a way to perform an export of our orders which shows per order, how many of each product was chosen. I am currently doing this with a Mass Action, using "order" as the datasource and only exporting order_id, order_product_code and order_product_quantity Let's say I am only selling 4 items: Coke, Sprite, Milk and Juice. The first customer places an order for 3 cokes The next customer orders 1 juice and 1 sprite The next customer orders 4 times milk The next customer orders 1 Sprite + 1 Coke + 2 Juices and 5 times Milk The last customer orders 2 times Sprite and 1 Milk In an ideal world, I would have an export showing the following: (see attached screenshot 1) With Hikashop, the best I seem to get is: (see attached screenshot 2) ID 1 only has data for the fields relating to item1 since the customer ordered 1 product ID 2 has data for the fields item1 and item2 since the customer ordered 2 products ... ID 4 has data for all the fields since the customer ordered 4 products Hikashop uses the order in which a customer adds products to his cart to populate the fields item1_productcode, item2_productcode etc.. Item1_productcode can, in my example, contain 4 possible values.. Since the amount of columns is different per row and since the values in the productcode or set based on the ordere a product is added, it is impossible with Excel to transform the data into my example above 'for the ideal world'. What I would need is the 4 possible values (Coke, Sprite, Milk, Juice) as the column header and per order (row) the amount of articles that was chosen for that product. Does anybody have an idea on how to create this export which seems to be rather logical functionality... Any help would be much appreciated!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 11 months ago, by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") [Last Post](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346635 "Hi, I don't see a way to do that inside HikaShop. It's possible to generate a report to get the number of sales of each products (one per row) like this: But there is no option to keep it split by order. That would require a complex MySQL query like this: where XX, YY, ZZ and AA would be the id of the products Coke, Sprite, Milk and Juice, and #__ the prefix of your tables (setting in the joomla configuration). You could run that MySQL query in your PHPMyAdmin to get the export you want.") 3 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:921 | [Last Post](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346635 "Hi, I don't see a way to do that inside HikaShop. It's possible to generate a report to get the number of sales of each products (one per row) like this: But there is no option to keep it split by order. That would require a complex MySQL query like this: where XX, YY, ZZ and AA would be the id of the products Coke, Sprite, Milk and Juice, and #__ the prefix of your tables (setting in the joomla configuration). You could run that MySQL query in your PHPMyAdmin to get the export you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 11 months ago |
| [](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585) | [Unable to display shipping name in email notification](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.14 -- PHP version -- : 7.4.26 In my shop I have setup a few shipping methods which users can select during checkout. As soon as payment is completed, the customer receives an email with a summary of the purchase. I would like this email to display the shipping method that was selected. In the email editor, I can include a number of tags but I cannot seem to find the tag that will display the name of the selected shipping method. I can find {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} but the values behind these are 1-2-3-4 etc for the ID and "manual" for the method. Does anybody know which tag I can use to display the NAME of the shipping method which was selected? (for example in the screenshot below, the second option 'Afhalen op school voor 09.30' will give the value 2 with VAR:order.order_shipping_id and will give the value 'manual' with VAR:order.order_shipping_method but I would like to retrieve 'Afhalen op school voor 09.30' )") Category: [Shipping Methods](/forum/28-shipping-methods "Discussions about the different shipping methods for Hikashop") Topic started 4 years 10 months ago, by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") [Last Post](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585 "Hi, I did not think about removing my HTML customizations and having a look at the default mail. You are absolutely right: the info is there by default. After removing my custom HTML code, and using the default code, the info I needed was there. To be specific: the NAME of the selected shipping method can be obtained with the HTML tag {VAR:SHIPPING} I was incorrectly looking at the tags {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} Thanks for your reply.. Got it working now with {VAR:SHIPPING}") 4 years 10 months ago by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") | Replies:2 Views:1003 | [Last Post](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585 "Hi, I did not think about removing my HTML customizations and having a look at the default mail. You are absolutely right: the info is there by default. After removing my custom HTML code, and using the default code, the info I needed was there. To be specific: the NAME of the selected shipping method can be obtained with the HTML tag {VAR:SHIPPING} I was incorrectly looking at the tags {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} Thanks for your reply.. Got it working now with {VAR:SHIPPING}") by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") 4 years 10 months ago |
| [](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338563) | [Unable to display shipping name in email notification](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338563 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.14 -- PHP version -- : 7.4.26 In my shop I have setup a few shipping methods which users can select during checkout. As soon as payment is completed, the customer receives an email with a summary of the purchase. I would like this email to display the shipping method that was selected. In the email editor, I can include a number of tags but I cannot seem to find the tag that will display the name of the selected shipping method. I can find {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} but the values behind these are 1-2-3-4 etc for the ID and "manual" for the method. Does anybody know which tag I can use to display the NAME of the shipping method which was selected? (for example in the screenshot below, the second option 'Afhalen op school voor 09.30' will give the value 2 with VAR:order.order_shipping_id and will give the value 'manual' with VAR:order.order_shipping_method but I would like to retrieve 'Afhalen op school voor 09.30' )") Category: [Shipping Methods](/forum/28-shipping-methods "Discussions about the different shipping methods for Hikashop") Topic started 4 years 10 months ago, by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") [Last Post](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585 "Hi, I did not think about removing my HTML customizations and having a look at the default mail. You are absolutely right: the info is there by default. After removing my custom HTML code, and using the default code, the info I needed was there. To be specific: the NAME of the selected shipping method can be obtained with the HTML tag {VAR:SHIPPING} I was incorrectly looking at the tags {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} Thanks for your reply.. Got it working now with {VAR:SHIPPING}") 4 years 10 months ago by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") | Replies:2 Views:1003 | [Last Post](/forum/28-shipping-methods/903799-unable-to-display-shipping-name-in-email-notification#338585 "Hi, I did not think about removing my HTML customizations and having a look at the default mail. You are absolutely right: the info is there by default. After removing my custom HTML code, and using the default code, the info I needed was there. To be specific: the NAME of the selected shipping method can be obtained with the HTML tag {VAR:SHIPPING} I was incorrectly looking at the tags {VAR:order.order_shipping_id} and {VAR:order.order_shipping_method} Thanks for your reply.. Got it working now with {VAR:SHIPPING}") by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") 4 years 10 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.055 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)