[Skip to main content](#vessel-content) # Stock Report ## - **[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")** - [![BasketBox's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11810-basketbox "View BasketBox's Profile") Topic Author - [ Offline](/forum/user/11810-basketbox) Less More - Posts: 69 - Thank you received: 1 - - 13 years 6 months ago [\#99344](#99344) by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") *[Stock Report](/forum/2-general-talk-about-hikashop/80470-stock-report#99344 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* was created by *[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")* Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 6 months ago [\#99391](#99391) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Stock Report](/forum/2-general-talk-about-hikashop/80470-stock-report#99391 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* There is no options for the stock report. We are developping a mass action feature which will allow you to have what you want on where you want. By creating a plugin a report for the product stock will be possible. If you don't receive the mail for the out of stock products, it's probably because your cron is not configured correctly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")** - [![BasketBox's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11810-basketbox "View BasketBox's Profile") Topic Author - [ Offline](/forum/user/11810-basketbox) Less More - Posts: 69 - Thank you received: 1 - - 13 years 6 months ago [\#99430](#99430) by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") Replied by *[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99430 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Okay, thanks about stock report. Regarding cron: Checked my cron and it appears to be configured correctly using the hikashop cron setup. I have several out of stock products with 0 quantity including 0 in some variants. I also have a waitlist test email, but I'm not getting the email. I've set the cron url to SEF url because we are using sh404. When I manually trigger the cron tasks, it appears to check and confirm but no email. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 13 years 6 months ago [\#99550](#99550) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99550 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Hi, Does your plugin "out of stock" is right published ? What is his configuration ? Do you have the message "Products quantity checked" when calling manually the cron task ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")** - [![BasketBox's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11810-basketbox "View BasketBox's Profile") Topic Author - [ Offline](/forum/user/11810-basketbox) Less More - Posts: 69 - Thank you received: 1 - - 13 years 6 months ago [\#99571](#99571) by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") Replied by *[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99571 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* The out of stock plugin is enabled and the period is 3600 and stock limit is 0. Attached is the manual cron task confirmation. [ ![cron.png](/forum/attachment/9701) ](/forum/attachment/9701 "cron.png") - [ ![cron.png](/forum/attachment/9701) ](/forum/attachment/9701 "cron.png") [ ](/forum/attachment/9701?download=1 "cron.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 13 years 6 months ago [\#99626](#99626) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99626 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Hi, The plugin work with "exclusive". I mean, it check products which have a quantity lesser than... 0 I have modified the plugin on our side to be "inclusive", it is more logical. You have to edit the hikashop plugin "out_of_stock" and change this SQL query from Code: $query='SELECT * FROM '.hikashop_table('product').' WHERE product_quantity<'.(int)$this->stock_limit.' AND product_quantity!=-1'; To: Code: $query='SELECT * FROM '.hikashop_table('product').' WHERE product_quantity<='.(int)$this->stock_limit.' AND product_quantity!=-1'; And it would check products which have a stock of 0. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")** - [![BasketBox's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11810-basketbox "View BasketBox's Profile") Topic Author - [ Offline](/forum/user/11810-basketbox) Less More - Posts: 69 - Thank you received: 1 - - 13 years 6 months ago - 13 years 6 months ago [\#99647](#99647) by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") Replied by *[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99647 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Yes, now it is working; however, the cron report is being sent automatically every hour, which I understand you can change to 15 mins, etc, but I only want the report once per week. I have the plugin set this way but it still sends every hour. Cron job for waitlist: The problem with waitlist is that if your main product qty is 0 and your variants for the main product have qty in stock, the email will not go out until you change the main product qty to more than 0. Why is that? Some of my products main qty will always be 0 because they have qty in variants. Am I wrong on this? Last edit: 13 years 6 months ago by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 13 years 6 months ago [\#99844](#99844) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99844 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Hi, Each cron plugin have his own "frequency" option. The cron plugin could be called every hour but each plugin would be independent. So the "low stock" notification could be triggered once a week if you set the right frequency value. About waitlist notification, the plugin has been updated not so far (in a recent release, the 2.1.1 or the 2.1.2) and the SQL query has been improved. > (b.product\_quantity > 0) OR (b.product\_quantity = -1 AND b.product\_type = '.$db->Quote('main').') OR (b.product\_type = '.$db->Quote('variant').' AND b.product\_quantity = -1 AND (c.product\_quantity > 0 OR c.product\_quantity = -1)) It reads values of the variant but if the variant stock is "unlimited" (-1), it reads the value of the main product. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")** - [![BasketBox's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11810-basketbox "View BasketBox's Profile") Topic Author - [ Offline](/forum/user/11810-basketbox) Less More - Posts: 69 - Thank you received: 1 - - 13 years 6 months ago - 13 years 6 months ago [\#99846](#99846) by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") Replied by *[BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#99846 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* I have the low stock plugin set for weekly (604800) but I'm getting an email every hour. Not sure why? For waitlist, I will get the update in the next release, I have 2.1.2 now. Also, I understand that variant qty will be updated in the future to tie with other products that use the same variant. So all that will work for me. Last edit: 13 years 6 months ago by [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 13 years 6 months ago [\#100049](#100049) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Cron Email](/forum/2-general-talk-about-hikashop/80470-stock-report#100049 "Is it possible to make a stock report? I don't see the options to do this in the reports area. Also, I don't get an email of out of stock products. The plugin is enabled. All other system emails work.")* Good point. I checked the plugin's code and the period is not taken into account and thus it does the check at each cron beat. I've uploaded a new package of HikaShop with a patch for that. If you download again the latest version and install it on your website you will get that fixed. The following user(s) said Thank You: [BasketBox](/forum/user/11810-basketbox "View BasketBox's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDcwLXN0b2NrLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)