Still Having Paypal Transactions Cancelled

  • Posts: 4
  • Thank you received: 0
11 years 9 months ago #58002

We're still having most, but not all, of our transactions cancelled.

We upgraded to Joomla 2.5.8 and reinstalled HikaShop. Payments are through Paypal.

We thought this might be due to duplicate invoice numbers. We could not implement the advice to reset invoice numbers because our numbers had letters as well as numbers and we were using the free version of HIkashop.

We purchased HIkashop Essential and set the configuration to create new, unique invoice numbers.

One new membership went through.

However, we received email from a second person who said:

When I was directed to paypal the site said the invoice
was already paid and directed me back to the xxxxx site. The xxxxx
site said that I canceled my order.

I checked in our paypal account and there is no indication this payment was submitted.

We had several other previous attempts to make purchases which did not work and which also are not listed as cancelled in paypal.

This cannot be caused by duplicate invoices because we are definitely not using duplicate invoice numbers.

What can we do?

Please Log in or Create an account to join the conversation.

  • Posts: 81604
  • Thank you received: 13082
  • MODERATOR
11 years 9 months ago #58074

The order number format option will change the order number.
But it won't change the order id which is what PayPal is revering to in order to check the unicity of the orders.
So it can still be a problem of duplicates.

Please change the auto_increment value of the hikashop_order table to a big number like 50000 and see if that helps.
For that, you need to run the query
ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 50000;

(and change jos_ by your table prefix) via phpmyadmin.

Please Log in or Create an account to join the conversation.

Time to create page: 0.054 seconds
Powered by Kunena Forum