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;
Tested on v1.5.2.1 release.
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:
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.
On the attachment is the XML. Then, apply the following query on your PHPMyAdmin under your OC database in the SQL tab:
Tested on v1.5.2.1 release.
Attachments
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Yes, there's shouldn't be any difference from the lines that the XML should be seeking for between both versions.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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 !
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 !
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 ...
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
---------- 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 !
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 !
There are no invoice route from customers account by default with OpenCart.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Not clear on what this does other than add a keyfield for guests? What is that code used for?
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
It allows guests to see their order confirmation bill on site while the default installation of OpenCart does not have this functionality.Not clear on what this does other than add a keyfield for guests?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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 v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
Upon a completed checkout, an email is being sent to the customer with a generated URL link to the order.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Ah okay. I'll have to test it again then since I didnt see any link come thru when I tested it.
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
It should. However, it has been tested on v1.5x releases.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Then my previous reply was correct, only tested on v1.5x so far. 
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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.
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.
Does this blank link occurs with text email or HTML emails ?then I use guest to check out, first email is "Your Store - Order 1 " then no any link at the email.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 47 guests
