Orders = No product attached

  • Posts: 241
  • Thank you received: 5
11 years 1 month ago #125689

-- HikaShop version -- : 2.2.1
-- Joomla version -- : 2.5.14
-- Browser(s) name and version -- : N/A

Hi guys,

I have been having the strangest thing happening over the past few months. Orders will come in with NO product attached. Screenshots:





I have spoken with users and they mention that after they select their payment option and are to be directed to payment (authorize.net or PayPal) that their browser just "hangs or something".

I initially thought this might be related to the "cart retaining period" which is set for a relatively short 15 minutes but i notice users creating a account and having the "no product orders" well within a 15 minute span, so that is likely not the issue.

Can you let me know any thoughts?

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 1 month ago #125690

Topic moved
Not an HikaMarket topic.

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: cberry1971

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

  • Posts: 12953
  • Thank you received: 1778
11 years 1 month ago #125702

Hi,
Did you edited the Emails through "Hikashop->System->Emails" ? If yes can you test it without your customization (don't forget to save your customization before any tests) ?
Thanks.

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

  • Posts: 241
  • Thank you received: 5
11 years 1 month ago #125703

Huh. I copied you on the email just so you can see that the cart is being emptied before they process the transaction.

This does not have to do with the emails. I have never edited Hikashop > System > Emails.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 1 month ago #125781

Hi,

It sounds like there was a SQL error when the products of the order were saved in the database.
Are you able to reproduce the issue ? If not, could you ask a user what steps he did to get that empty order ?
Once you can reproduce the issue, turn on the "debug mode" of the joomla configuration and do the test again. Hopefully, it should display an error message regarding a MySQL query at the end of the checkout which will help us understand what's going on.

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

  • Posts: 241
  • Thank you received: 5
11 years 1 month ago #126049

I am not able to create the issue on my end, but it is specific to a few events (products) on my end. I am wondering if it is due to product names / or code or something in one of the tables associated with a variant of those products.

again of dozens of items sold, only two have had this "glitch"

Thanks.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 1 month ago #126067

The question then is what is the difference between these two products and the others ? Do they have options/characteristics/custom fields/etc that the others don't ?

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

  • Posts: 241
  • Thank you received: 5
11 years 1 month ago #126110

still searching for something. One thing i have learned is that users are given a "this product is no longer sold" error when clicking the activation link.

I also notice that the main product has a "maximum quantity" = 1 but the variants have a "maximum quantity" = "unlimited" (screenshots)

Main Product:



Variants:


I am wondering if this might somehow clear the cart upon clicking the activation link.

What is strangest is that it clears the cart for some orders and not others. NOT a consistent bug.

Attachments:

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

  • Posts: 12953
  • Thank you received: 1778
11 years 1 month ago #126319

Hi,

So can you test it without any "Maximum quantity per order" restriction for your main product ?

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

Time to create page: 0.109 seconds
Powered by Kunena Forum