Add a column to Sales View in Backend

I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up all the time, and they usually don't have their invoice number.

I tried editing the sales view file in the views menu

Even when I fully deleted that file, the sales view was unchanged. How can I add a column to the sales view in the backend?

Thanks!
Jesse
RageHats.com

Hi RageHats,

You can d oit by editing the view order / listing.php in HikaShop > Display > Views.

Then add:
After:
And add a column with the value:

how I can replace the column "method of payment" for "product code" and that at the top:


echo $ this-> payment-> display ("filter_payment", $ this-> PageInfo-> filter-> filter_payment, false);


To output the filter by "Product Code" instead of "payment method".

thanks

Hi dvddvd,

Can you explain in more details what you need ?

A sale have many products, so we can't add a filter on the product code in the listing of the sales.

Sorry, in my case only allows one product per order

Ok so in your case, you can edit the file: "yourSite/administrator/components/com_hikashop/views/order/show.html.php

And add the line: Just before:
Then in HikaShop > Display > Views, edit the view "order / listing"
And replace the title "Payment method" by "Product code", and replace: By:

Hello Xavier thank you very much for your help

I made ​​the following changes

1) add the following code:



Just before of:

Being the "/ administrator / components / com_hikashop / views / order / view.html.php" so:

and also by changing the title and replacing the code that you show me, being so "listing.php"

But I only get the code column empty and the upper flange as before.



Thanks

Sorry for paste entire files.

Oh I forgot one thing, , you need to add ",d.*" like this: in the file: "yourSite/administrator/components/com_hikashop/views/order/view.html.php and in the function listing().

Add "d.order_product_code" in the searchmap:
And then you can filter by product code in the filter field on the left.

thank you very much now all right !!!!

Hello again,

I'm trying to replace the 'id column' by 'telephone', following the steps you've RageHats indicated earlier in this post, but I just get the blank column.

thnaks

Hi dvddvd,

You need to display "echo $order->name->address_telephone;" instead of "echo $order->name->address_lastname" like I said to RageHats.

ok operates correctly. Thank you very much

Hello Xavier,
We use HikaShop for university courses. We deleted all the orders last year and since then, the field added to order / listing is blank.
I was using "echo $ order-> name-> address_telephone;?".
What is the new command I use to take that data table address and field address_telephone ?

It's still the same.
Are you sure that it's not because the address_telephone has been unpublished or something like that ?

Thanks Xavier. I see that to enlist new orders from the administration and assign a customer, goes blank the form to the right which is where the data takes. Because if I put the phone there, if it appears

I'm not following you. Could you maybe give more information on the problem ? Maybe screenshots ?

In the screenshot I show you what I mean:

1. - I have assigned the customer Dulce Pascual.
2. - Load data into Student form
3. - Form STUDENT DATA - Billing, left blank

I think in this last form, in the field where it takes the data phone address_telephone.

So I do not go out, to call it from <td class="hikashop_order_id_value">
             <? php echo $ order-> name-> address_telephone;?>
           </ td>

I only needed to change $ address_id = $ row-> order_shipping_address_id, for $ address_id = $ row-> order_billing_address_id, in <? php
         $ target ='';
         if ($ this-> popup)
           $ target = "" target = "_top";
         $ k = 0;
         for ($ i = 0, $ a = count ($ this-> rows); $ i <$ a, $ i + +) {
           $ row = & $ this-> rows [$ i];
        $ address_id = $ row-> order_billing_address_id;
        $ fieldClass = hikashop_get ('class.field');
        $ AddressClass = hikashop_get ('class.address');
        $ order-> fields = $ fieldClass-> getData ('backend', 'address');
        if (! empty ($ address_id)) {
        $ order-> name = $ AddressClass-> get ($ address_id);
        }
       ?>

Thank very much Xavier

Hi Xavier,
I just upgrade to HikaShop bussiness. This modification we do not work anymore.
In the country where the product code was to appear, is now blank.
It could appear again in the updated version of the product code in this field.
Thank You