order total/ order detail

In order to make the merchant's job easier, I would like to know how to make at least one of the following possible:

I want to know how to add a coloum in the order tab table and shows the product that each costumer orders. (add a coloum in the table as shown with the attachments.)

or a function that shows the total number of order for each product.

Thank you

Hello,
You forgot to attach your screenshot , if you want to edit your back-end order listing, you'll have to edit the code of the "listing" file of the "order" view of your back-end template via "Hikashop->Display->Views". If you want to edit your back-end product listing, you'll have to edit the code of the "listing" file of the "product" view of your back-end template via "Hikashop->Display->Views".
Note that some development skills will be required.

sorry heres the attachment.

I was able to change the heading "date modified" in to "product". (heres a screenshot for you to compare)

Now I need to know what function to call to replace the data modified function so it can show the product each customer has ordered and the quantity of each product..

I end up finding the code for date modified and delete them. (heres a screenshot for comparison )

Also, is it possible to shows the total amount of each product that is ordered.

For example:
customer A order product A x1, product B x2
customer B order product A x2, product B x2


so adding it up, I will have to prepare the amount of product A x3 and product B x 4.

Is there away to do this and display it under order tab?

Hello,
If you want to edit your back-end order listing, you'll have to edit the code of the "listing" file of the "order" view of your back-end template via "Hikashop->Display->Views", also it will be possible to display the total amount of each porduct that your customer ordered but it will require to :
- do some SQL request to your database to know how many products of each type your customer have bought and to know the price of the product
- calculate each total prices
- display them.

Hi,

I need help on the coding so the amount of ordered product by each customer will be display under the order tab.

hikashop.com/forum/reports-statistics/86...r-detail.html#165357

Hi, Xavier

is it the right link?

it redirect me to my post lol

So I finally put the product name and the quantity under order tab.

Hi,

Yes it is possible, it's just your code which must be adapted as you want.
The foreach for the product display must be in the order "PRODUCT(QUANTITY)" <td>.

I tried the foreach, but nothing comes up.

what should I put in the foreach()

I tried

foreach($row->order_product_name as $product_name)

echo $product_name ,' ( ',$row->order_product_quantity,' )' ;



originally I didnt use foreach, just
echo $row->order_product_name ,' ( ',$row->order_product_quantity,' )' ;




Thank you

Hi,

It require to load all the products in the listing, so use the function "loadProducts()" of the order class.
Then do a foreach on "$row->products" and display all the products of the order in the listing.

Example:

<td>
<?php
$orderClass = hikashop_get('class.order');
$orderClass->loadProducts($row);
foreach($row->products as $product){
   echo $product->order_product_name.'('.$product->order_product_quantity.')';
}
?>
</td>

loadProducts();

is the function I been looking for.

which file contains all the functions? where can I find a documentation that states all the functions for me to use?

I actually went in to the view.html.php and change the sql code in order to display the product each by each.

Your code makes it much simpler.

Thanks

Hi,

All the functions related on the orders are in the file "administrator/components/com_hikashop/classes/order.php".

What about the function like hikashop_xxxxx

where is it located?

for example:
hikashop_config
hikashop_get

Thank you