Bingo. I just untoggled the test box and put in an order for $1 and it's taking me to the https/paypal/us
with my banking merchant account name.
sweet ! ..... ooops
just got this error after everything seemed to be checking out just fine. ( I was expecting it to take me back to my home page or order page ... ?
Configuration error: You MUST have created an order status for "Paid Unconfirmed" for every installed language. The following sql statement returned no rows select `order_status_id` from `order_status` where `name` = 'Paid Unconfirmed' and `language_id` = '1'
with my banking merchant account name.
sweet ! ..... ooops
just got this error after everything seemed to be checking out just fine. ( I was expecting it to take me back to my home page or order page ... ?
Configuration error: You MUST have created an order status for "Paid Unconfirmed" for every installed language. The following sql statement returned no rows select `order_status_id` from `order_status` where `name` = 'Paid Unconfirmed' and `language_id` = '1'
Thats fixed in the latest SVN version and future versions.
You can fix it on your version by entering this line in your phpmyadmin sql
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
You can fix it on your version by entering this line in your phpmyadmin sql
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
Last edited by Qphoria on Thu Nov 13, 2008 9:09 am, edited 1 time in total.
OpenCart 0.7.9 and later will have the PayPal Improved module instead of the old PayPal module included in the software bundle by default.but it's not really asking anything that would setup or refer to my specific paypal account ... or is it merely the email address ? I thought that was just for forwarding the orders.
As regards PayPal configuration: The only settings it needs is the e-mail address of your PayPal account, and whether you use the test mode or not. This PayPal module has a better workflow behind the scenes, making better use of the callback function to verify that PayPal has actually processed the payment. Even if PayPal doesn't call back, OpenCart keeps the 'Paid Unconfirmed' order status, giving the store owner the chance to log into his PayPal account to see whether PayPal processed the payment or not.
Last edited by JNeuhoff on Thu Nov 13, 2008 5:07 pm, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Ok, looking at the paypal.php this is how I understand the workflow to be:with paypal improved, is the order supposed to be saved to the main order table "before" going to the external site? because that isn't happening for my site.
The order is submitted to the PayPal payment gateway at 'https://www.sandbox.paypal.com/cgi-bin/webscr'. As part of this form submission with the order details, it also submits the POST variable named notify_url with a the value of a call back function: /index.php?controller=checkout_process&payment=paypal&action=callback. The user is transfered to the PayPal's payment gateway. PayPal calls the PaymentPayPal.callback function which in turns sends a _notify-validate message to PayPal to verify the payment, and when the callback function gets an VERIFIED, the order status is set to pending.
... which means: I can't see it anywhere calling the PaymentPayPal.process function, hence the cart won't be cleared? Now I am confused too .......
... few minutes later scratching my head ...
I think the PaymentPayPal.process does get called after all, because when PayPal is initially called the payment module also submits a variable named return with a value pointing to the URL of the PaymentPayPal.process function. That means the order is processed, permanently stored in the database. Not sure whether the shopping cart is cleared, can't see it anywhere doing it in the code.
Last edited by JNeuhoff on Fri Nov 14, 2008 1:17 am, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Gents, I set up my email as Q instructed (apparently I set myself up with a PayPal merchant account ...which does enable non paypal members to submit VIsa or MC. that part works great.
Changes the PayPal from /uk to /us as I was hoping.
I ran through two tests. One as a paypal member logging in, etc. and the other bypassing the paypal member and going to the visa/mc option.
Both orders went through successfully (debited one account and credited the other, etc ... I checked this later)
I'll try to insert the code I got from Q above and see if it solves my problem on returning me to my homecart
upon successful check out.
I have another queston which I will address in a separate post.
Changes the PayPal from /uk to /us as I was hoping.
I ran through two tests. One as a paypal member logging in, etc. and the other bypassing the paypal member and going to the visa/mc option.
Both orders went through successfully (debited one account and credited the other, etc ... I checked this later)
I'll try to insert the code I got from Q above and see if it solves my problem on returning me to my homecart
upon successful check out.
I have another queston which I will address in a separate post.
Last edited by SoCal on Fri Nov 14, 2008 5:39 am, edited 1 time in total.
Following up on the two test orders I placed through Paypal.
- Neither shows up on my order file in the admin interface.
I see them on paypal and charging my card. But the opencart interface does not reflect that I sold something and received an order ?
Sales show up fine if I choose COD.
I am almost there.
.... an hour later ... I still have to input Q's code for checkout process to fix the pop up error upon "checkout confirmation/return to shop" button .
Perhaps that will fix my other problem below. No sales reflected in my sales/order history on open cart.
- Neither shows up on my order file in the admin interface.
I see them on paypal and charging my card. But the opencart interface does not reflect that I sold something and received an order ?
Sales show up fine if I choose COD.
I am almost there.
.... an hour later ... I still have to input Q's code for checkout process to fix the pop up error upon "checkout confirmation/return to shop" button .
Perhaps that will fix my other problem below. No sales reflected in my sales/order history on open cart.
Last edited by SoCal on Fri Nov 14, 2008 5:50 am, edited 1 time in total.
Qphoria wrote: Thats fixed in the latest SVN version and future versions.
You can fix it on your version by entering this line in your phpmyadmin sql
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
What is the path for this ? Or do I do this on my servers control panel ?
Q, I'm looking every where for this phpmyadmin sqlQphoria wrote: Thats fixed in the latest SVN version and future versions.
You can fix it on your version by entering this line in your phpmyadmin sql
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
where exactly do I find this ?
Last edited by SoCal on Fri Nov 14, 2008 10:09 am, edited 1 time in total.
when opened up my panel , I clicked the link for oc database and it opened up a tabular looking
page. as I scroll down I see order_status and to the right are four ACTION choices.
BROWSE | STRUCTURE | INSERT | EMPTY | DROP
when I click the insert
(Id paste you a screen shot but thats not working for me in this post.)
a bunch of drop down field choices are displayed for
field type function null value
there are fields here and I can input data.
how do I post you a screen shot ?
page. as I scroll down I see order_status and to the right are four ACTION choices.
BROWSE | STRUCTURE | INSERT | EMPTY | DROP
when I click the insert
(Id paste you a screen shot but thats not working for me in this post.)
a bunch of drop down field choices are displayed for
field type function null value
there are fields here and I can input data.
how do I post you a screen shot ?
I went to their site. wow
I think I've almost got it.
When you say
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
I found the SQL tab and when I open the table tab for the order_status .... it it says
Run SQL query/queries on database imageart_opc01:
`order_status`
Fields
order_status_id`
`language_id`
`name`
? #1) you want me to insert this line right ?
VALUES (NULL,'1','Paid Unconfirmed');
?#2) QUESTION
Where I see this
Run SQL query/queries on database imageart_opc01:
Followed by a text box where in the box it says.
SELECT * FROM `order_status` WHERE 1
Is this where I insert the line .
VALUES (NULL,'1','Paid Unconfirmed')
( if so do I replace what’s there or add it to it. if I add to it can you give me the string exactly the way I should want it.)
I think I've almost got it.
When you say
INSERT INTO `order_status` (`order_status_id`, `language_id`,`name`) VALUES (NULL,'1','Paid Unconfirmed');
I found the SQL tab and when I open the table tab for the order_status .... it it says
Run SQL query/queries on database imageart_opc01:
`order_status`
Fields
order_status_id`
`language_id`
`name`
? #1) you want me to insert this line right ?
VALUES (NULL,'1','Paid Unconfirmed');
?#2) QUESTION
Where I see this
Run SQL query/queries on database imageart_opc01:
Followed by a text box where in the box it says.
SELECT * FROM `order_status` WHERE 1
Is this where I insert the line .
VALUES (NULL,'1','Paid Unconfirmed')
( if so do I replace what’s there or add it to it. if I add to it can you give me the string exactly the way I should want it.)
Last edited by SoCal on Fri Nov 14, 2008 2:25 pm, edited 1 time in total.
I humbly apologize for my ongoing newbie questions ... but I am almost through this part.Qphoria wrote: LOL the sql file was designed to make things easy.. you've sure complicated it
See attachment.
thanks for your photo insert that helps. now just to confirm.
I am going to paste over the existing line in the box that reads.
[ SELECT * FROM `order_status` WHERE 1 ]
and replace with ...
[ VALUES (NULL,'1','Paid Unconfirmed') ]
is this correct? I anxioulsy await your response so I can give it a try.
well....Qphoria wrote: yes
I pasted in this exact text.
VALUES (NULL,'1','Paid Unconfirmed')
and I received this error message.
Error
SQL query:
VALUES (NULL , '1', 'Paid Unconfirmed' )
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES (NULL,'1','Paid Unconfirmed')' at line 1
I'm pretty sure that's not the line i gave you.
Try the correct one from the original reply:
http://forum.opencart.com/index.php/top ... l#msg11201
Try the correct one from the original reply:
http://forum.opencart.com/index.php/top ... l#msg11201
Who is online
Users browsing this forum: No registered users and 10 guests