7.5 and paypal

Well the good news...  paypal will take the money and return the payee to the store with no error... 

BUT... there is no record of the order...

still broke......

Go on MSN. Did you have subtract stock option on or off?

I am having the same problem, I tried with and without the Subtract Stock Option.

Going to do a release tonight that solves this problem.

Daniel wrote: Going to do a release tonight that solves this problem.

I just installed and downloaded 0.7.6, but I am still receiving this problem with orders not showing up. I had this problem before with osCommerce. The problem was resolved by storing the order, before the user was sent to paypal to make the payment. Before the order goes to paypal it is assigned a status "Paypal Pending", once it returns from paypal, the order status is updated to just "Pending". I hope this helps.

Thanks, tchemis

tchemis wrote:

Daniel wrote: Going to do a release tonight that solves this problem.

I just installed and downloaded 0.7.6, but I am still receiving this problem with orders not showing up. I had this problem before with osCommerce. The problem was resolved by storing the order, before the user was sent to paypal to make the payment. Before the order goes to paypal it is assigned a status "Paypal Pending", once it returns from paypal, the order status is updated to just "Pending". I hope this helps.

Thanks, tchemis

The process you described above is how it works. I have found that it can take up to 7 hours before the callback is made by PayPal. Can you do some more testing?

Hi Daniel, I am open to any suggestions in regards to testing. When I say orders are not showing up I mean, in OpenCart, payment is being made correctly on paypal side.

And When I attempt to do COD, I receive this error.

Error: Unknown column 'sort_order' in 'field list'
Error No: 1054
insert into order_total set order_id = '8', title = 'Subtotal:', text = '$1.00', `value` = '1', sort_order = '0'

tchemis wrote: Hi Daniel, I am open to any suggestions in regards to testing. When I say orders are not showing up I mean, in OpenCart, payment is being made correctly on paypal side.

And When I attempt to do COD, I receive this error.

Error: Unknown column 'sort_order' in 'field list'
Error No: 1054
insert into order_total set order_id = '8', title = 'Subtotal:', text = '$1.00', `value` = '1', sort_order = '0'

Did you install from scratch?

If not you need to create a field called sort_order in the order_total table.

Sorry about that I forgot to add that instruction for upgrading.

Daniel the same happens with v7.6, i don't need this persay but i tried to check out and I got a similar error and I did install this from scratch.

Tokai wrote: Daniel the same happens with v7.6, i don't need this persay but i tried to check out and I got a similar error and I did install this from scratch.

Just doing a bug / fix update release now!

Daniel wrote:

tchemis wrote:

Daniel wrote: Going to do a release tonight that solves this problem.

I just installed and downloaded 0.7.6, but I am still receiving this problem with orders not showing up. I had this problem before with osCommerce. The problem was resolved by storing the order, before the user was sent to paypal to make the payment. Before the order goes to paypal it is assigned a status "Paypal Pending", once it returns from paypal, the order status is updated to just "Pending". I hope this helps.

Thanks, tchemis

The process you described above is how it works. I have found that it can take up to 7 hours before the callback is made by PayPal. Can you do some more testing?

Hi Daniel, Thanks for the clarification, I did install from scratch (I noticed you did an upgrade for the database issue), When I logged into the store now the orders where there, so you are correct in paypal taking a little long to do the callback.

I am not sure since the previous post I have done 2 other orders and waited over 12 hours and they still do not show up in the admin orders.

As for my previous post, what happened was I noticed the code by "luvz2drv" to alter the table so that COD can work, I opened phpmyadmin, and applied the code to insert the missing field in the table, when I returned to the admin panel, I noticed the 2 original paypal orders where now there.

However I have not been able to have the orders show up again after this. But COD is now working correctly. Only paypal is the issue right now.

I am going to try and move my testing cart to another hosting later today and see if this fixes the issue.

Daniel, if you would like to debug this on my end let me know I will give you information to check it out.

what does the paypal accounts showing?  that payment was made ... or status there

-=Luvz2drv=-

-=luvz2drv=- wrote: what does the paypal accounts showing?  that payment was made ... or status there

-=Luvz2drv=-

http://i8.tinypic.com/4zk5a43.jpg[/img]

The Personal Account (used to send the money).. The status is "Pending" the reason for this is because, I have to log into the second account, and click on "Capture" then the status would change to Completed. I am not sure if these are settings in Paypal, or how OpenCart sends the request (if someone knows please let me know). I don't personally like this way of handling the payments, because I have to manually go into Paypal, capture the funds, then return to OpenCart. This is a huge problem with a lot of orders, as you have to manually match up the paypal payment to the orders in your store.

I would prefer to know the orders that are in OpenCart, have successfully been completed in paypal. And not have to worry about the above issues.

Hopes this makes sense.

UPDATE: I have managed to successfully have the orders show up in OpenCart when using Paypal, but I had to move to another web host (I was with Godaddy). Although the errors I have reported to Daniel have been official "Bugs",.. I don't think anyone else is experiencing them with their web hosts. So I will begin developing my website on this new web host.   

One of the problems I experianced was that PayPal was not making the call back on port 80 and instead used port 43. It is possible godaddy bocks other ports.

PayPal is a real pain.