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

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

You might be referring to the shipping location to deliver the box. If the case, which shipping extension are you using?

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

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

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

Do you want this listing be available in the Front- and/oder Admin Section, and
should it be part of the Front Side Product Title, or just listed on the Product Page ?
And should it be listed in the Admin Sales-Listing Pages, or in all Product-related Listings ?

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

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. Image

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.
Image

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??
Last edited by spdavis on Sun Mar 08, 2020 5:47 am, edited 1 time in total.

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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

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

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 :ponder: (??) Does anybody see a way forward?
Last edited by straightlight on Sun Mar 01, 2020 4:43 am, edited 1 time in total.
Reason: Added code tags.

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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) Image
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 Image
3) If I then goto print this Order List, this page lists using the SKU Image

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.
:ponder: 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??
Last edited by spdavis on Sun Mar 08, 2020 5:48 am, edited 1 time in total.

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

How by ANY STANDARDS is my problem RESOLVED??

Where IS THE EVIDENCE it has been RESOLVED; I am no further forward than where I started other than seeing what might have been a solution, NOT being a solution !!

Is this Forum about support or insulting user intelligence??!!

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

Bad moderators :laugh:

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

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

Screenshot_2020-03-01_15-01-56.png

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


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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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 :crazy:

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

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

On 3.x is order_info. twig.
On prevision versions is order_info.tpl

For 2-3 beers donation I can make a vqmod file if you can't fix yourself.

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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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. :crazy:
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 ... :laugh: , 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:
Image

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

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.

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

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

spdavis wrote:
Mon Mar 02, 2020 8:47 pm
Can I get that master stroke Location on Products page to work as well??
On website product page?
Under Product code?

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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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 !!! :choke: Ooookay

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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 ! :laugh:

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

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

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

New member

Posts

Joined
Wed Jan 30, 2013 9:52 am

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

Well, that's, what you are, in OC Terms ! :laugh:
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 ... :laugh: ;)

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: Semrush [Bot] and 79 guests