[SOLVED] How do i add the name in the shipping information behind to the customer’s name on the order history page?

mobarez wrote: ↑

Fri Aug 07, 2020 2:58 am

How did the name in the shipping information behind to the customer’s name on the order history page?

letxobnav wrote: ↑

Fri Aug 07, 2020 9:43 pm

He wants the name on the shipping address to be listed as a column between the order id column and the customer name column.
Probably for when the person who the shipment is send to is not the same as the customer.

letxobnav wrote: ↑

Sat Aug 08, 2020 3:21 pm

so which OC version are you using, which template and which extension in admin?
I do not recognize that screen so I suspect you already have a modification running.

letxobnav wrote: ↑

Sat Aug 08, 2020 3:56 pm

then I am afraid you need to contact journal.
I can tell you how to do it default but I think journal does not use those functions so it would be no use to you.

letxobnav wrote: ↑

Sat Aug 08, 2020 8:51 pm

OK,

1) in admin/model/sale/order.php - function getOrders
change the query:

Code: Select all

		$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";

to:

Code: Select all

		$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, CONCAT(o.shipping_firstname, ' ', o.shipping_lastname) AS ship_to, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";

that will make sure those fields are retrieved as well.

2) in admin/controller/sale/order.php - function getList
change the array assignment:

Code: Select all

			$data['orders'][] = array(
				'order_id'      => $result['order_id'],
				'customer'      => $result['customer'],
				'order_status'  => $result['order_status'] ? $result['order_status'] : $this->language->get('text_missing'),
				'total'         => $this->currency->format($result['total'], $result['currency_code'], $result['currency_value']),
				'date_added'    => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
				'date_modified' => date($this->language->get('date_format_short'), strtotime($result['date_modified'])),
				'shipping_code' => $result['shipping_code'],
				'view'          => $this->url->link('sale/order/info', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true),
				'edit'          => $this->url->link('sale/order/edit', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true)
			);

to:

Code: Select all

			$data['orders'][] = array(
				'order_id'      => $result['order_id'],
				'customer'      => $result['customer'],
				'ship_to'       => $result['ship_to'],
				'order_status'  => $result['order_status'] ? $result['order_status'] : $this->language->get('text_missing'),
				'total'         => $this->currency->format($result['total'], $result['currency_code'], $result['currency_value']),
				'date_added'    => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
				'date_modified' => date($this->language->get('date_format_short'), strtotime($result['date_modified'])),
				'shipping_code' => $result['shipping_code'],
				'view'          => $this->url->link('sale/order/info', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true),
				'edit'          => $this->url->link('sale/order/edit', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true)
			);

3) in admin/view/template/sale/order_list.twig
before:

Code: Select all

<td class="text-left">{% if sort == 'customer' %} <a href="{{ sort_customer }}" class="{{ order|lower }}">{{ column_customer }}</a> {% else %} <a href="{{ sort_customer }}">{{ column_customer }}</a> {% endif %}</td>

add:

Code: Select all

<td class="text-left">{{ column_ship_to }}</td>

before:

Code: Select all

<td class="text-left">{{ order.customer }}</td>

add:

Code: Select all

<td class="text-left">{{ order.ship_to }}</td>

4) in your admin/language/xx-xx/sale/order.php
add:

Code: Select all

$_['column_ship_to']            = 'Ship To';

That's called help without any expectation of return.

by mona wrote: ↑

Sat Aug 08, 2020 9:34 pm

That's called help without any expectation of return.

and that is called calling out people who CHOOSE not to offer their knowledge for free, on the most part, their knowledge is their paid income and we are all entitled to make a living with our skills

I do not see many people offering their products for free

On that point, I would actually like to say thank you to the very kind Scot who offered me candy and you know what that is what is I call give and receive ..

You can not force people to help you. I am not here to help everyone that I can .. I choose who I want to help .. We each have our own reasons ... and this may surprise you, but we are entitled to do that

letxobnav is great - instead of your comment dragging others down ..
letxobnav

and he might not EXPECT anything in return, but he sure deserves to receive something in return ..

letxobnav wrote: ↑

Sat Aug 08, 2020 8:51 pm

OK,

1) in admin/model/sale/order.php - function getOrders
change the query:

Code: Select all

		$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";

to:

Code: Select all

		$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, CONCAT(o.shipping_firstname, ' ', o.shipping_lastname) AS ship_to, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";

that will make sure those fields are retrieved as well.

2) in admin/controller/sale/order.php - function getList
change the array assignment:

Code: Select all

			$data['orders'][] = array(
				'order_id'      => $result['order_id'],
				'customer'      => $result['customer'],
				'order_status'  => $result['order_status'] ? $result['order_status'] : $this->language->get('text_missing'),
				'total'         => $this->currency->format($result['total'], $result['currency_code'], $result['currency_value']),
				'date_added'    => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
				'date_modified' => date($this->language->get('date_format_short'), strtotime($result['date_modified'])),
				'shipping_code' => $result['shipping_code'],
				'view'          => $this->url->link('sale/order/info', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true),
				'edit'          => $this->url->link('sale/order/edit', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true)
			);

to:

Code: Select all

			$data['orders'][] = array(
				'order_id'      => $result['order_id'],
				'customer'      => $result['customer'],
				'ship_to'       => $result['ship_to'],
				'order_status'  => $result['order_status'] ? $result['order_status'] : $this->language->get('text_missing'),
				'total'         => $this->currency->format($result['total'], $result['currency_code'], $result['currency_value']),
				'date_added'    => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
				'date_modified' => date($this->language->get('date_format_short'), strtotime($result['date_modified'])),
				'shipping_code' => $result['shipping_code'],
				'view'          => $this->url->link('sale/order/info', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true),
				'edit'          => $this->url->link('sale/order/edit', 'user_token=' . $this->session->data['user_token'] . '&order_id=' . $result['order_id'] . $url, true)
			);

3) in admin/view/template/sale/order_list.twig
before:

Code: Select all

<td class="text-left">{% if sort == 'customer' %} <a href="{{ sort_customer }}" class="{{ order|lower }}">{{ column_customer }}</a> {% else %} <a href="{{ sort_customer }}">{{ column_customer }}</a> {% endif %}</td>

add:

Code: Select all

<td class="text-left">{{ column_ship_to }}</td>

before:

Code: Select all

<td class="text-left">{{ order.customer }}</td>

add:

Code: Select all

<td class="text-left">{{ order.ship_to }}</td>

4) in your admin/language/xx-xx/sale/order.php
add:

Code: Select all

$_['column_ship_to']            = 'Ship To';

letxobnav wrote: ↑

Mon Aug 10, 2020 10:44 am

I do not know what your order history page is.
Default OC has an order list and an order detail page (including a history part which is just a blockchain-line order status/comment record).

Your original image shows the order list named as order history (though it lists the number of products which is not default).
The changes you applied are for the order list so I assume you have another order history page which is journal specific?
order-history.jpg

Better state what the route of the page is instead of the name like sale/order or sale/order/info, you find this in the address bar.
Then it is more clear what page you are talking about as people can always change the name but not the route.