Post by SoCal » Fri Nov 14, 2008 11:03 pm

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.

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by SoCal » Sat Nov 15, 2008 1:37 am

SUCCESS IS ACHIEVED  :o  !

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

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by Qphoria » Sat Nov 15, 2008 3:19 am

lol  you ran it too many times :)

Go back to the sql entry box again and run:

Code: Select all

delete from order_status where `name` = 'Paid Unconfirmed';
Then run this again only once!

Code: Select all

INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by SoCal » Sat Nov 15, 2008 3:48 am

Thanks,

I'll give it a shot.  thanks for the support.... I'll make a donation to the opencart kitty this weekend.

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by SoCal » Sat Nov 15, 2008 6:35 am

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.)
Last edited by SoCal on Sat Nov 15, 2008 2:58 pm, edited 1 time in total.

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by Qphoria » Sat Nov 15, 2008 7:29 am

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)
Easy.
You can edit the catalog/template/default/content/checkout_success.tpl file and add the new content there.
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.)
Also Easy.
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'));
TO:

Code: Select all

$response->redirect($url->ssl('new_page'));
Change new_page to whatever the actual name of the file is without the extension (.php)

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by SoCal » Sun Nov 16, 2008 2:23 am

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.

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by Qphoria » Sun Nov 16, 2008 2:28 am

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.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by SoCal » Sun Nov 16, 2008 2:46 am

found it ... thx !

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by SoCal » Sun Nov 16, 2008 3:17 am

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

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by SoCal » Sun Nov 16, 2008 4:06 am

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

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm

Post by Qphoria » Sun Nov 16, 2008 5:24 am

SoCal 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=''">
   
 
That text comes from the catalog/language/english/controller/checkout_success.php file
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');

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bruce » Sun Nov 16, 2008 9:28 am

Qphoria 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.
success.tpl is not just used by checkout_success

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Qphoria » Sun Nov 16, 2008 10:15 am

bruce wrote:
Qphoria 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.
success.tpl is not just used by checkout_success
Ah.. i see now... well then
::inserts foot into mouth::
http://msn.mess.be/data/thumbnails/39/24.png[/img]

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by SoCal » Mon Nov 17, 2008 12:31 pm

Got it working gents. thank you very much.

Couple other minor issues I hope.  I'll submit as a separate topic/s.

New member

Posts

Joined
Fri Nov 07, 2008 3:23 pm
Who is online

Users browsing this forum: No registered users and 2 guests