Page 1 of 2

[RELEASED] Show order invoice to guests with order key

Posted: Thu Mar 08, 2012 12:25 am
by straightlight
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.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Thu Mar 08, 2012 2:09 am
by bikermunda
WIll this work for the version 1.5.3 ?

Re: [RELEASED] Show order invoice to guests with order key

Posted: Thu Mar 08, 2012 2:13 am
by straightlight
Yes, there's shouldn't be any difference from the lines that the XML should be seeking for between both versions.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 5:08 am
by masko
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 !

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 8:22 am
by straightlight
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 ...

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 10:06 am
by masko
can work on 1.5.05 ? and how, would be guided , I really need this vmod
sorry, my english is bad :(
thanks !

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 10:10 am
by straightlight
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.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 11:11 am
by masko
---------- 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 !

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 12:04 pm
by straightlight
There are no invoice route from customers account by default with OpenCart.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 10:55 pm
by labeshops
Not clear on what this does other than add a keyfield for guests? What is that code used for?

Re: [RELEASED] Show order invoice to guests with order key

Posted: Sat Aug 04, 2012 10:59 pm
by straightlight
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.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Tue Aug 07, 2012 12:33 am
by labeshops
How do they view it though? I installed to play with it and don't see any way for a guest to see anything.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Tue Aug 07, 2012 12:50 am
by straightlight
Upon a completed checkout, an email is being sent to the customer with a generated URL link to the order.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Tue Aug 07, 2012 1:31 am
by labeshops
Ah okay. I'll have to test it again then since I didnt see any link come thru when I tested it.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Fri Nov 16, 2012 4:56 pm
by fourgood
is this going to work with 1.4.9.1?

Re: [RELEASED] Show order invoice to guests with order key

Posted: Fri Nov 16, 2012 10:04 pm
by straightlight
It should. However, it has been tested on v1.5x releases.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Fri Nov 16, 2012 11:16 pm
by fourgood
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

Re: [RELEASED] Show order invoice to guests with order key

Posted: Fri Nov 16, 2012 11:19 pm
by straightlight
Then my previous reply was correct, only tested on v1.5x so far. ;)

Re: [RELEASED] Show order invoice to guests with order key

Posted: Tue Feb 19, 2013 9:07 am
by powershot
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.

Re: [RELEASED] Show order invoice to guests with order key

Posted: Wed Feb 27, 2013 9:16 am
by straightlight
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 ?