Adding Location information into Customers Order List

Post by spdavis » Sat Feb 29, 2020 3:17 am

Hi

I am running OC 1.5.4 with view to upgrade at some point. BUT.. Until then I have to live with what I have

What I would like to be able to do, is input into Catalogue > Products > [Edit] a product > Data > LOCATION and to have this information available after A stock item listed. The idea simply, this product to be found located as written into LOCATION ie: DRESS-Red PICKING-BOX-27 <- Where this is the location

Does anyone have a suggestion on this

Any help appreciated

Post by straightlight » Sat Feb 29, 2020 5:45 am

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

Post by IP_CAM » Sat Feb 29, 2020 9:11 am

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by spdavis » Sat Feb 29, 2020 11:38 am

My bad. Should have shown visually what I asking..

The image here is the reference to LOCATION as mentioned in the initial post. This seems to be a common form input to OC.

The customers ORDERS page listing items of purchase, also seems uniform in whats provided. On my site, I add only a bar code in attempt to maintain a stock control point.


What I am wanting to do, is enter (say) Row 2 Box 6 and for this reference be included after the SKU (model number). And since this page in OC is printable. It makes sense to have the page used as a picking list - hence my asking how to do...

I shall be attempting to sort out the absurd duplication of SKU details as part of this mod...

I hope that at least goes some way to better detail??

Post by xxvirusxx » Sat Feb 29, 2020 2:39 pm

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by spdavis » Sun Mar 01, 2020 4:22 am

@ xxvirusxx That link was a potential solution. Thank you .

Of the 3 pages listed
- admin/view/template/sale/order_view.tpl (or order_form.tpl if older than v1.4.4)
- admin/view/template/sale/order_invoice.tpl
- admin/view/template/sale/order_invoices.tpl

I only have order_invoice.tpl that has

Code: Select all

<?php echo $product['model']; ?>

order_form.tpl has no reference

And I am not sure what the ('s are doing around the PHP..

Code: Select all

<?php echo $product['model']; ?> (<?php echo $product['location']; ?>)

But I see nothing on any listing page

But assuming this mod works for 1.4.4, it surely can't be far from working on 1.5.4 (??) Does anybody see a way forward?

Post by spdavis » Sun Mar 01, 2020 5:24 am

Okay.. Some odd research around my OC 1.5.4. One or two things I had not noticed.
1) When I enter into Catalogue > Products > [Edit] a product > Data > Then input Model and SKU information I have (like everyone else)
2) When I goto Dashboard and select to View a Customers completed Order > Products . I get the 2 ('s from the mod suggested NO other information between. BUT noticed this page lists the products Model number
3) If I then goto print this Order List, this page lists using the SKU

So this is clearly a situation where to create a 'Picking' list using Order list 'almost works (??) as a visual list, but fails outright if invoice Printed to be my Picking list.
Is this the PHP looking at the database, but in the wrong location (or simply totally wrong for OC 1.5.4) . Or the PHP not showing the database reference because its simply NOT linked to the form input Location??

Post by spdavis » Sun Mar 01, 2020 8:45 pm

Post by xxvirusxx » Sun Mar 01, 2020 9:02 pm

Bad moderators

For info you can use this 3.x version extension, to change and make for 1.5.x.x..
https://www.opencart.com/index.php?rout ... n_id=21106

Or you can contact me on PM to discuss.

Attachments

Screenshot_2020-03-01_15-05-30.png (42.42 KiB) Viewed 12002 times

Screenshot_2020-03-01_15-01-56.png (34.86 KiB) Viewed 12009 times

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by spdavis » Sun Mar 01, 2020 10:13 pm

Over keen admin.. Blimming

@xxvirusxx Thats looking like a potential and brilliant solution. Great find... Thank you

However, I have no idea IF OC3 uses the same Database headers or references or even recognize a page/file called order_info.twig

Your original suggestion gave me on a list the SKUNUMBER(), it has brackets in at least one correct location. So is potentially the solution. I need to figure out (lol yeah right) what database reference for products SKU is to be looked for. And then (I think) ensure this referance is passed forward correctly, since I want this to be hard wired into OC. I can cut and past whatever code into place until resolved

Post by xxvirusxx » Sun Mar 01, 2020 10:35 pm

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by IP_CAM » Mon Mar 02, 2020 1:36 am

You could try something like this one. The only thing still missing is, to display it on the Admin Invoice as well, that '$currloc' Variable is new to me, and I wasted hours, without any success, to make it show up on the Invoice as well.
But make sure FIRST, that the 'ANCHOR' lines in the OC Files correspond with those 'shown' in the Extension, one single 'difference' woud disable Function.
Someone, familiar with coding OC, would probably be able, to add the Routine to the Admin Invoice as well ... , but it's getting hard lately, because most 1.5.x Coders obviously already passed away, or then just lost their spirit ....
Good Luck!
Ernie

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<modification>
<id><![CDATA[Admin View Order Product Location]]></id>
<version><![CDATA[OC 1.5.6.5 - OC2 Themes]]></version>
<vqmver><![CDATA[2.6.1]]></vqmver>
<author><![CDATA[Ernie - IP_CAM]]></author>
<email><![CDATA[webmaster@opencart.li]]></email>
<link><![CDATA[http://www.opencart.li]]></link>

<file name="admin/controller/sale/order.php">
<operation error="log">
<search position="before"><![CDATA[$this->data['products'][] = array(]]></search>
<add><![CDATA[
	$this->load->model('catalog/product');
	$this->model_catalog_product->getProduct($product['product_id']);
	$currloc = $this->model_catalog_product->getProduct($product['product_id']);
]]></add>
</operation>

<operation error="log">
<search position="after"><![CDATA['model'    		   => $product['model'],]]></search>
<add><![CDATA['location'    		   => $currloc['location'],]]></add>
</operation>
</file>

<file name="admin/view/template/sale/order_info.tpl">
<operation error="log">
<search position="after"><![CDATA[<td class="center"><?php echo $column_model; ?></td>]]></search>
<add><![CDATA[<td class="center">Location</td>]]></add>
</operation>

<operation error="log">
<search position="after"><![CDATA[<td class="center"><?php echo $product['model']; ?></td>]]></search>
<add><![CDATA[<td class="center"><?php echo $product['location']; ?></td>]]></add>
</operation>
</file>
</modification>

---
My Solutions, placed in different Sections:

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by spdavis » Mon Mar 02, 2020 8:47 pm

@ IP_CAM Thats a brilliant step forward.. BIG THANK YOU - A diamond in a rough platform.
@ xxvirusXX MASSIVE SHOUT OUT to you Sir. Off site support and solution support - 2nd to none.

Can I get that master stroke Location on Products page to work as well??

Post by xxvirusxx » Mon Mar 02, 2020 10:32 pm

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by spdavis » Tue Mar 03, 2020 4:53 am

I'm looking at the 3rd image on IP_CAMs posting.. The Poduct page.. There!

Joined 2013 - Tagged NEW MEMBER !!! Ooookay

Post by xxvirusxx » Tue Mar 03, 2020 5:13 am

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by IP_CAM » Tue Mar 03, 2020 6:52 am

Joined 2013 - Tagged NEW MEMBER

That Value is based on the number of Postings, not on the Registration Date !

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by spdavis » Tue Mar 03, 2020 6:55 am

@ IP_CAM okay so that makes me a total novice !! Great

Post by IP_CAM » Tue Mar 03, 2020 8:15 am

Well, that's, what you are, in OC Terms !
But it's not meant personally, it's just reflects the intensity of wisdom,
required, to keep an OC Baby work as planned. And your Version did
not need additional Wisdom so far, as it looks, so, you rather belong
to the 'Winners ', strictly from an OC - User point of view ...

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.