Oscommerce website problem
Bajet $30-250 USD
Oscommerce website using Paypal for payment
Symptoms
1. There are no orders showing on the website for which we have received payments on PayPal
1. There are orders showing on the website as an ORDER, are showing as NOT paid on the website, and we have received a PAYMENT on PayPal
2. There are orders showing on the website as an ORDER, are showing as NOT paid, and we have NOT received a payment on PayPal
3. There are orders showing on the website as an ORDER, are showing as paid on the website, and we have received a PAYMENT on PayPal
4. Most of payments received on PayPal don’t have invoice number
5. All payments received on PayPal have a customer number
6. Orders paid on PayPal and not showing on the website are also not showing in customers order table in the database
Observations
Customer 103 shows product A in their basket, when refreshed the basket is empty on refreshing again the basket is still empty
Customer 102 shows product A in their basket, when refreshed the basket contains A, on refreshing again product A is still there
It would seem that baskets are not being upgraded or cleared when a new customer arrives
Opinion
The problem seems to be due to the change from MySQL 4 to 5 (also PHP 4 to 5)
Further
Orders through the website:
- those marked pending – payment received on PayPal
- some marked preparing – payment received on PayPal
- some marked preparing – payment NOT received on PayPal
EMAIL: Order Process - received from website, in some cases only
We receive a few of the orders through an email for others we don’t receive emails.
EMAIL: Notification of Payment – received from PayPal
We receive some payment notifications by an email, for others we don’t receive payment notification emails.
We are not receiving copies of orders for which we received payment, neither via the website, nor via Order process email.
If you have any other suggestions which cover ALL the options provided, let us know