Out of stock alerts for items that are unlimited

  • Posts: 136
  • Thank you received: 19
  • Hikashop Business
1 month 4 days ago #368706

-- HikaShop version -- : 6.1.0 [2509232312]
-- Joomla version -- : 5.3.3
-- PHP version -- : 8.2.29

We are chasing down random issues with out of stock messages with stock that is unlimited availability and no limits on order sizes.
Nothing happening in the logs that is untoward
Our J! session was 50 minutes and has been shortened to 10, in case that was an issue. No change.

Anything I should be immediately looking for?



Random thought that may be related or totally not.
When viewing Orders, while chasing things done, I discovered there are specific customers who have multiple "Order Created" before an order "Completed" happens.

A couple look like

Customer 1
Created
2025-07-30 14:44
2025-07-30 14:50

Confirmed
2025-07-30 16:13

Customer 2
Created
2025-07-12 22:20
2025-07-12 22:22

Confirmed
2025-07-13 12:35

Spoken to bother of them and they experienced nothing strange.
I began thinking it was they added an item to the cart and then another so two created events.
Can't see that is what's happening, as some people add multiple items from different groups and that's not happening.

Oh and the site has cache turned off.

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

  • Posts: 84585
  • Thank you received: 13753
  • MODERATOR
1 month 4 days ago #368707

Hi,

Regarding the orders, it's probably just the user going back and forth between the payment gateway and the checkout.
An order is created each time the user clicks on the "finish" button at the end of the checkout.

Regarding the out of stock alerts, I could see this happening if the stock of the product is not correct in the database.
In the product_quantity column of the hikashop_product table in your database, -1 indicates "unlimited". And then it goes above 0.

For the out of stock alerts, the HikaShop out of stock plugin checks for products with a product_quantity lower than the "stock limit" configured in the plugin settings, and different from -1.
So, if the value is -2 instead of -1, other parts of HikaShop might still consider the product as "unlimited", but this plugin will notify you of the product being out of stock.
Normally, a value below -1 should never happen.
So, I would recommend checking the settings of the plugin and the value of the product_quantity in the hikashop_product table for the products with the issue via your PHPMyAdmin.

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

  • Posts: 136
  • Thank you received: 19
  • Hikashop Business
1 month 3 days ago #368725

Regarding the orders, it's probably just the user going back and forth between the payment gateway and the checkout.
An order is created each time the user clicks on the "finish" button at the end of the checkout.

I'm chasing that down given it's 2 customers that have 90% of the duplicate errors

Regarding the out of stock alerts, I could see this happening if the stock of the product is not correct in the database.
In the product_quantity column of the hikashop_product table in your database, -1 indicates "unlimited". And then it goes above 0.

Checked that previously and all items in the table are -1
:(

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

  • Posts: 84585
  • Thank you received: 13753
  • MODERATOR
1 month 3 days ago #368726

Hi,

Then I dont see how that's possible. I would need to dive deep into it, with a backend access, a FTP access, and the names of the products with the issue in order to look into the out of stock alerts issue.
Could you provide that via our contact form ?
www.hikashop.com/support/contact-us.html

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

  • Posts: 136
  • Thank you received: 19
  • Hikashop Business
1 month 21 hours ago #368744

Just been back into the database and all product quantities are -1

Checked in with the customers with multiple "Order Created". Yes they go to the cart and then go back and reorder. Sometimes multiple times.

Checking in today all items to be ordered for collection "tomorrow" are 0.

Will send you coordinates on contact form as suggested

Thanks

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

  • Posts: 84585
  • Thank you received: 13753
  • MODERATOR
3 weeks 6 days ago #368848

Hi,

Thanks and sorry for the late reply.

So first, I understood that you were using the "out of stock" plugin included in HikaShop in order to receive an email that products were out of stock because the stock of these products was changed from unlimited to zero at some point. That's because you talked about "alerts".

However, checking your website now, I don't see any "out of stock" notification emails in the Customers>Emails history.

Now, when I check your backend the stock of all the products is unlimited.

Looking at the code of the extension from Brainforge via the FTP access, it seems that it manages stock per delivery dates and allow the customers to select their delivery date.

So Im not sure what to conclude as I don't know what the exact problem is.
Could you provide a screenshot of the "out of stock alert" ? Is it an alert sent by Brainforge's extension ?
You're saying that the problem is only with products with a particular collection date. However, HikaShop doesn't have a collection date, that's added by Brainforge's extension, and thus the stock management in HikaShop doesn't do anything different based on the collection date. It doesn't even know it exists.
This feels to me that the issue is linked to that extension and not in HikaShop.
I dont know exactly how that extension work. I've spent an hour today looking at it, and figured some things, but it would be difficult for me to find the issue if it comes from that extension.

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

  • Posts: 136
  • Thank you received: 19
  • Hikashop Business
3 weeks 5 days ago #368857

Brief as Im on the phone here…

The “Out of Stock” was the customers view of things
Place an order for tomorrow and “out of stock” alert/ popup appears

Brainforge component works for us as we have limits on individual products orders per customer and limited availability on specific days to match in with our staffing limitations and trading days as well. We are a boutique bakery not industrial sized so production of our range varies.

This one has got me miffed ….
“Out of stock plugn” i turned on to see if it made any difference. I don’t see why it would be required given we have unlimited numbers.
Since i turned it on the error has gone away. Why? How? It makes no sense and I’m not going to sweat on it.

The multiple order created message in the admin orders sounds like it tied in with the above. Customer said if i get an out of order i go to the cart and then go back and try again and the order goes through.

We’ll keep a watch on that and see what transpires

Thanks so much for your support, and time delay is all ok

The following user(s) said Thank You: nicolas

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

Time to create page: 0.054 seconds
Powered by Kunena Forum