Post by straightlight » Thu Mar 08, 2012 12:25 am

Countless merchants requested in the past to provide possibility to their customers to show the order invoice as guests with a random generated string from URL without necessarily the need to authenticate since the checkout process allows guests and / or customers to purchase products.

On the attachment is the XML. Then, apply the following query on your PHPMyAdmin under your OC database in the SQL tab:

Code: Select all

ALTER TABLE `oc_order` ADD `order_key` VARCHAR(32) COLLATE utf8_bin NOT NULL;
This will add an order key within each upcoming orders. Passed orders will obviously not have this possibility and even if it were possible to create strings on all the passed orders, better chances the time-to-live on the server to get exceeded which we want to avoid.

Tested on v1.5.2.1 release.

Attachments


The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by bikermunda » Thu Mar 08, 2012 2:09 am

WIll this work for the version 1.5.3 ?

New member

Posts

Joined
Sat Jan 28, 2012 8:58 am

Post by straightlight » Thu Mar 08, 2012 2:13 am

Yes, there's shouldn't be any difference from the lines that the XML should be seeking for between both versions.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by masko » Sat Aug 04, 2012 5:08 am

hi straightlight !

Thank you for this achievement, but you can help me change to suit my OpenCart version? or how to change that?

My opencart Version 1.505

in file catalog / model / checkout / order.php
Line 408

$ text. = $ order_info ['store_url']. 'index.php? route = account / invoice & order_id ='. $ order_id. "\ n \ n";

Instead of the XML file to your other version
Line 89

$ text. = $ order_info ['store_url']. 'index.php? route = account / order / info & order_id ='. $ order_id. "\ n \ n";


Thank you for reading and interest !

Newbie

Posts

Joined
Fri Aug 03, 2012 12:02 am

Post by straightlight » Sat Aug 04, 2012 8:22 am

I don't understand what you'd like to do here ... you wish to remove the order from the url to say account/info&order_id=' . $order_id ? If so, you could make this replacement yourself from the XML ...

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by masko » Sat Aug 04, 2012 10:06 am

can work on 1.5.05 ? and how, would be guided , I really need this vmod
sorry, my english is bad :(
thanks !

Newbie

Posts

Joined
Fri Aug 03, 2012 12:02 am

Post by straightlight » Sat Aug 04, 2012 10:10 am

v1.5.0.5 is a bit old. I would suggest to try it anyway on a test server and simply report the errors you see as long as it goes.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by masko » Sat Aug 04, 2012 11:11 am

---------- Date: 2012-08-04 03:03:02 ~ IP : 113.172.238.206 ----------
REQUEST URI : /index.php?route=checkout/success
MOD DETAILS:
modFile : /home/leesunk/public_html/*****/vqmod/xml/account_order_page_with_key.xml
id : Account Order Page With Key
version : 1.0
vqmver : 2.1.5
author : Straightlight
SEARCH NOT FOUND (ABORTING MOD): $text .= $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id . "\n\n";


The only error in vqmod manage it,: (
I run on version 1.5.05

$ Text. = $ Order_info ['store_url']. 'index.php? route = account / invoice & order_id = '. $ Order_id. "\ N \ n";

instead of you: 1.5.2

$ Text. = $ Order_info ['store_url']. 'index.php? route = account / order / info & order_id = '. $ Order_id. "\ N \ n";

Straightlight, Please help me !

Newbie

Posts

Joined
Fri Aug 03, 2012 12:02 am

Post by straightlight » Sat Aug 04, 2012 12:04 pm

There are no invoice route from customers account by default with OpenCart.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by labeshops » Sat Aug 04, 2012 10:55 pm

Not clear on what this does other than add a keyfield for guests? What is that code used for?

Running Opencart v2.2 with multi-stores from http://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by straightlight » Sat Aug 04, 2012 10:59 pm

Not clear on what this does other than add a keyfield for guests?
It allows guests to see their order confirmation bill on site while the default installation of OpenCart does not have this functionality.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by labeshops » Tue Aug 07, 2012 12:33 am

How do they view it though? I installed to play with it and don't see any way for a guest to see anything.

Running Opencart v2.2 with multi-stores from http://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by straightlight » Tue Aug 07, 2012 12:50 am

Upon a completed checkout, an email is being sent to the customer with a generated URL link to the order.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by labeshops » Tue Aug 07, 2012 1:31 am

Ah okay. I'll have to test it again then since I didnt see any link come thru when I tested it.

Running Opencart v2.2 with multi-stores from http://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by fourgood » Fri Nov 16, 2012 4:56 pm

is this going to work with 1.4.9.1?

Active Member

Posts

Joined
Wed Oct 20, 2010 9:49 pm

Post by straightlight » Fri Nov 16, 2012 10:04 pm

It should. However, it has been tested on v1.5x releases.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by fourgood » Fri Nov 16, 2012 11:16 pm

Ok. So far as i can see it doesnt. Maybe just a small thing. As i was going through the vqmod i realized that there are changes in "catalog/controller/account/order.php". this doesnt exist in 1.4.9.1

Active Member

Posts

Joined
Wed Oct 20, 2010 9:49 pm

Post by straightlight » Fri Nov 16, 2012 11:19 pm

Then my previous reply was correct, only tested on v1.5x so far. ;)

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Post by powershot » Tue Feb 19, 2013 9:07 am

Hi, I did first step upload the attached XML to /vqmod/xml/ no problem.
then second, apply the following query on your PHPMyAdmin under your OC database in the SQL tab: successful!
then I use guest to check out, first email is "Your Store - Order 1 " then no any link at the email.
is any wrong I did? my version is 1.5.4.1
thank you for your great help.

Newbie

Posts

Joined
Sat May 26, 2012 6:35 am

Post by straightlight » Wed Feb 27, 2013 9:16 am

then I use guest to check out, first email is "Your Store - Order 1 " then no any link at the email.
Does this blank link occurs with text email or HTML emails ?

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com contractor officials representative


Administrator

Posts

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

Users browsing this forum: No registered users and 15 guests