Orders not being created

  • Posts: 16
  • Thank you received: 1
  • Hikashop Business
4 weeks 1 day ago #366949

-- HikaShop version -- : 5.1.6
-- Joomla version -- : 5.3.0
-- PHP version -- : 8.1.32

Hi

Please help.
Over the last month, several emails have come through from Paypal saying a payment has been received but there are no order details included and no order number. We have contacted PayPal who say that the payment was made through the site however there is no order created in Hikashop.
All of these orders it seems are from email addresses that are not registered on the site so I'm assuming they have checked out as guests.
All I can see from the emails from Paypal is how much the amount paid, by which email address and the date and time of the purchase but no order has been generated in Hikashop..

I am more than happy to provided login details for the site if required.

Many thanks.

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

  • Posts: 83904
  • Thank you received: 13581
  • MODERATOR
4 weeks 1 day ago #366952

Hi,

When PayPal Checkout transmit the order information to PayPal, the email addressand order ID are always provided to PayPal.
The email address of the user might not be associated with a Joomla user account, that's correct. However, the email address will be associated with a user in the Customers menu of HikaShop for guest purchases.
Also, the order is always created before the PayPal Checkout payment plugin does anything. So you will be able to find an order with roughly the same creation date as the transaction date, with the same amount.
And since the order is always created, the plugin transmits the order ID as the "invoice ID" in the PayPal transaction details page.
So you should be able to match the order and the transaction together. Also, in the history of the order, which you can see at the bottom of the page if you open an order, you'll see the PayPal transaction ID recorded. So, that's also a way to match the order in HikaShop and the transaction in PayPal together.

If there is no invoice ID in the transaction, and you can't find any order in HikaShop, then the payment likely didn't went through HikaShop.
Maybe you were using another ecommerce solution in the past and it hasn't been disabled properly ? Or maybe you've installed another extension which can accept payments. Or maybe you've added somewhere a PayPal HTML payment button ? This can be easily done with just a copy/paste in a Joomla article, so it doesn't require any specific extension. However, that means that no information is available on the website. So that would also explain the situation.

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

  • Posts: 16
  • Thank you received: 1
  • Hikashop Business
4 weeks 1 day ago #366957

Hi Nicolas

Thanks for the reply.
The email from PayPal saying a payment has been received shows a transaction ID and an Invoice ID along with an email address.
None of those things are showing in the Customers menu.

There are only two payment plugins currently enabled, Paypal Checkout and Bank Transfer (which as far as I can tell, simply shows bank details for the customer to manually pay with) although there are older plugins that are on there but they are disabled. These are PayPal Pro, PayPal Plus and PayPal Express. These have not been used for a long time.

Hikashop is the only e-commerce solution that has ever been used on the site and I am unaware of any PayPal HTML buttons ever having been put on the site.

Regards

Jim

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

  • Posts: 83904
  • Thank you received: 13581
  • MODERATOR
4 weeks 1 day ago #366958

Hi,

If you have an invoice ID, then, go in the Orders listing of HikaShop. There, you can see the "ID" column on the right side:
www.hikashop.com/support/documentation/i...listing.html#columns
The screenshot has not been updated for more recent versions of Joomla, but the default columns are still the same.
So you can search for an order with the ID matching with the invoice ID.

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

  • Posts: 16
  • Thank you received: 1
  • Hikashop Business
4 weeks 23 hours ago #366961

Hi Nicolas

So I see nothing that matches.
I have attached a screenshot of the info on the email from PayPal (minus private information) and a screenshot of what I see in Orders on the back end of the site.
Still not finding any information regarding the missing orders but I appreciate your time trying to help.

Attachments:

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

  • Posts: 83904
  • Thank you received: 13581
  • MODERATOR
4 weeks 19 hours ago #366962

Hi,

The order ID in HikaShop is incremented by 1 for every order. Based on your screenshots, I can see that the last order has the ID 2448. So you had orders previously from "1" to "2448". On the PayPal screenshot, it says that the "invoice ID" is 19893.
This means the transaction did not originate from HikaShop since it would have had an invoice ID between 1 and 2448.
Also, the description of the product purchased on the PayPal screenshot is "Total price Item #:".
But the PayPal Checkout plugin in HikaShop will either use the name of the product, or the text "Order number: XX" where XX is the order number of the order in HikaShop (when the "send order details" setting is turned off in the payment method). So again, this indicates that the transaction wasn't done through the PayPal Checkout plugin of HikaShop.

So it all indicates that the transaction comes from something else than HikaShop.

If PayPal says that the transaction comes from your website, then it must come from something else. What ? I don't know, but certainly not HikaShop.

Note that PayPal says that it comes from your website. What did they say exactly ? It could be that you have a test website or something, in a subdomain or a subfolder of your website, where you have another ecommerce solution setup (or half setup), or a PayPal, HTML button or something.
In any case, PayPal has all the log necessary to be able to point you at the problem. Normally, the PayPal support should be able to give you the exact URL from which the transaction originated. This should be enough to identify the origin of the problem. Could you check with them ?

The following user(s) said Thank You: askjim

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

  • Posts: 16
  • Thank you received: 1
  • Hikashop Business
4 weeks 18 hours ago #366965

Thank you Nicolas, it makes sense now. There is a subdomain with a copy of the old site on it (which was using Hikashop) as the site owners wanted to have it for reference when the new site went live. It has been live for quite some time and due to a broken back end of Joomla, I was unable to put the site into offline mode.
You are quite correct, all those missing orders were made through that site so I have now managed to disable Hikashop, all payment plugins and shipping methods in the absence of ability to put the site fully into offline mode so hopefully no more problems will occur.

I very much appreciate your time in responding and your information has indeed explained where the problems came from.

The following user(s) said Thank You: nicolas

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

Time to create page: 0.073 seconds
Powered by Kunena Forum