here was the line you gave me originally:
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
here is what I plugged in
VALUES (NULL,'1','Paid Unconfirmed');
I'll just plug the whole thing as you gave it to me.
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
here is what I plugged in
VALUES (NULL,'1','Paid Unconfirmed');
I'll just plug the whole thing as you gave it to me.
SUCCESS IS ACHIEVED
!
Master Q, you were correct. I was making things a lot more complicated than need be.
the orders go through nicely ... but in my relentless effort to insert the code.
..... when I go to Status (Orders)
I get
Cancelled
Confirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Pending
Processing
Shipped
How would I take out the extra Paid Unconfirmed's about 7 extras

Master Q, you were correct. I was making things a lot more complicated than need be.
the orders go through nicely ... but in my relentless effort to insert the code.
..... when I go to Status (Orders)
I get
Cancelled
Confirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Paid Unconfirmed
Pending
Processing
Shipped
How would I take out the extra Paid Unconfirmed's about 7 extras
lol you ran it too many times 
Go back to the sql entry box again and run:
Then run this again only once!

Go back to the sql entry box again and run:
Code: Select all
delete from order_status where `name` = 'Paid Unconfirmed';
Code: Select all
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
Q, that worked fine.
Now when I get to the final page .... and I click the link below (and it takes the customer back to the shopcart main page. ...
http://www.mysite.com/shopcart/checkout_success
1) Where do I go to edit the checkout_success content that shows up on the page.
( I need to give the client specific instructions)
2) and if I want to change the URL when the client hits CONTINUE, is that okay to do that, or is that going to bugger up paypals confirmation and hence not update to my carts new orders.
I'd like to take them to page at this point .... where they can upload a file or two. I already have that part set up. Just need to link off to it. (it's a basic html file upload form ... not randomfactors contrib.)
Now when I get to the final page .... and I click the link below (and it takes the customer back to the shopcart main page. ...
http://www.mysite.com/shopcart/checkout_success
1) Where do I go to edit the checkout_success content that shows up on the page.
( I need to give the client specific instructions)
2) and if I want to change the URL when the client hits CONTINUE, is that okay to do that, or is that going to bugger up paypals confirmation and hence not update to my carts new orders.
I'd like to take them to page at this point .... where they can upload a file or two. I already have that part set up. Just need to link off to it. (it's a basic html file upload form ... not randomfactors contrib.)
Last edited by SoCal on Sat Nov 15, 2008 2:58 pm, edited 1 time in total.
Easy.SoCal wrote: 1) Where do I go to edit the checkout_success content that shows up on the page.
( I need to give the client specific instructions)
You can edit the catalog/template/default/content/checkout_success.tpl file and add the new content there.
Also Easy.SoCal wrote: 2) and if I want to change the URL when the client hits CONTINUE, is that okay to do that, or is that going to bugger up paypals confirmation and hence not update to my carts new orders.
I'd like to take them to page at this point .... where they can upload a file or two. I already have that part set up. Just need to link off to it. (it's a basic html file upload form ... not randomfactors contrib.)
To change the final page completely, you need to edit catalog/controller/checkout_process.php
CHANGE:
Code: Select all
$response->redirect($url->ssl('checkout_success'));
Code: Select all
$response->redirect($url->ssl('new_page'));
Quote from: SoCal on November 14, 2008, 11:35:44 PM
1) Where do I go to edit the checkout_success content that shows up on the page.
( I need to give the client specific instructions)
Easy.
You can edit the catalog/template/default/content/checkout_success.tpl file
I couldnt find a file named checkout_success.tpl
In that directory I did find checkout_address, checkout_confirm, checkout_email, checkout_payment, and checkout_shipping.
but no checkout_success ?
ps.
also, ... I did find the catalog/controller/checkout_process.php for the other edit I have to do.
thx.
1) Where do I go to edit the checkout_success content that shows up on the page.
( I need to give the client specific instructions)
Easy.
You can edit the catalog/template/default/content/checkout_success.tpl file
I couldnt find a file named checkout_success.tpl
In that directory I did find checkout_address, checkout_confirm, checkout_email, checkout_payment, and checkout_shipping.
but no checkout_success ?
ps.
also, ... I did find the catalog/controller/checkout_process.php for the other edit I have to do.
thx.
Q,
at http://www.mysite.com/shopcart/checkout_success
This is what I am looking for in the file I have to edit…..
Your order has been successfully processed ! Your products will arrive at their destination within 2-5 working days.
You can view your order history by going to the MY ACCOUNT page and click on HISTORY
Pleas direct any question you have to the STORE OWNER.
Thanks for shopping with us online !
But .....
when I go to edit the succes.tpl file as you suggested. the only code I see is
" onclick="location=''">
and I'm looking for the bit about the products arriving to their destination in 2-5 days for your order ...etc. ?
at http://www.mysite.com/shopcart/checkout_success
This is what I am looking for in the file I have to edit…..
Your order has been successfully processed ! Your products will arrive at their destination within 2-5 working days.
You can view your order history by going to the MY ACCOUNT page and click on HISTORY
Pleas direct any question you have to the STORE OWNER.
Thanks for shopping with us online !
But .....
when I go to edit the succes.tpl file as you suggested. the only code I see is
" onclick="location=''">
and I'm looking for the bit about the products arriving to their destination in 2-5 days for your order ...etc. ?
Q, where you say...
TO:
Code:$response->redirect($url->ssl('new_page'));
Change new_page to whatever the actual name of the file is without the extension (.php)
my subject "new_page" destinaation file is called Form2Mail.html
located in a separate directory. (this was from a separate script)
http://www.mysite.com/HDWForm2Mail/Form2Mail.html
.... can I direct the url to this path outside ... or should I move this Form2Mail stuff to the opencart directory.
Could you instruct me how my path should read in the code above.
thx
TO:
Code:$response->redirect($url->ssl('new_page'));
Change new_page to whatever the actual name of the file is without the extension (.php)
my subject "new_page" destinaation file is called Form2Mail.html
located in a separate directory. (this was from a separate script)
http://www.mysite.com/HDWForm2Mail/Form2Mail.html
.... can I direct the url to this path outside ... or should I move this Form2Mail stuff to the opencart directory.
Could you instruct me how my path should read in the code above.
thx
That text comes from the catalog/language/english/controller/checkout_success.php fileSoCal wrote: Q,
at http://www.mysite.com/shopcart/checkout_success
This is what I am looking for in the file I have to edit…..
Your order has been successfully processed ! Your products will arrive at their destination within 2-5 working days.
You can view your order history by going to the MY ACCOUNT page and click on HISTORY
Pleas direct any question you have to the STORE OWNER.
Thanks for shopping with us online !
But .....
when I go to edit the succes.tpl file as you suggested. the only code I see is
" onclick="location=''">
You can change it there or choose to not use the language file and just copy the html from your Form2Mail.html file and stick it right inside this file in place of this line:
Change it to:
or whatever is in your form code. This way you don't really have to redirect to another page.
However, if you do want to redirect to an external link you can do:
$response->redirect('http://www.externalsite.com/form.html');
success.tpl is not just used by checkout_successQphoria wrote: Sorry... looks like someone brainfarted the naming convention here. Apparently the file is just titled "success.tpl"
Please excuse me while i slap some team members.
Ah.. i see now... well thenbruce wrote:success.tpl is not just used by checkout_successQphoria wrote: Sorry... looks like someone brainfarted the naming convention here. Apparently the file is just titled "success.tpl"
Please excuse me while i slap some team members.
::inserts foot into mouth::
http://msn.mess.be/data/thumbnails/39/24.png[/img]
Who is online
Users browsing this forum: No registered users and 5 guests