[Skip to main content](#vessel-content) # Stock manager not updating product\_sales ## - **[Menno](/forum/user/35011-menno "View Menno's Profile")** - [![Menno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35011-menno "View Menno's Profile") Topic Author - [ Offline](/forum/user/35011-menno) Less More - Posts: 6 - Thank you received: 0 - - 2 years 1 month ago [\#363165](#363165) by [Menno](/forum/user/35011-menno "View Menno's Profile") *[Stock manager not updating product\_sales](/forum/30-integrations/908610-stock-manager-not-updating-product-sales#363165 "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2 Hello I'm using the Barcode Stock Manager and it is a great extension for Hikashop. But what is missing is that it does not update the product-sales field in the product table. Is this not implemented, or is it a matter of configuration that I am not aware of? Any help appreciated. menno")* was created by *[Menno](/forum/user/35011-menno "View Menno's Profile")* -- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2 Hello I'm using the Barcode Stock Manager and it is a great extension for Hikashop. But what is missing is that it does not update the product-sales field in the product table. Is this not implemented, or is it a matter of configuration that I am not aware of? Any help appreciated. menno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy85MDg2MTAtc3RvY2stbWFuYWdlci1ub3QtdXBkYXRpbmctcHJvZHVjdC1zYWxlcz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 2 years 1 month ago - 2 years 1 month ago [\#363166](#363166) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Stock manager not updating product\_sales](/forum/30-integrations/908610-stock-manager-not-updating-product-sales#363166 "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2 Hello I'm using the Barcode Stock Manager and it is a great extension for Hikashop. But what is missing is that it does not update the product-sales field in the product table. Is this not implemented, or is it a matter of configuration that I am not aware of? Any help appreciated. menno")* Hi, The product_sales column is there so that you can have a listing of products for the best seller products. So this field is incremented each time a sale of a product is done. The stock of the product is not relevant to this field. I'm feeling you're using the product_sales column for something else ? Last edit: 2 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy85MDg2MTAtc3RvY2stbWFuYWdlci1ub3QtdXBkYXRpbmctcHJvZHVjdC1zYWxlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Menno](/forum/user/35011-menno "View Menno's Profile")** - [![Menno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35011-menno "View Menno's Profile") Topic Author - [ Offline](/forum/user/35011-menno) Less More - Posts: 6 - Thank you received: 0 - - 2 years 1 month ago [\#363178](#363178) by [Menno](/forum/user/35011-menno "View Menno's Profile") Replied by *[Menno](/forum/user/35011-menno "View Menno's Profile")* on topic *[Stock manager not updating product\_sales](/forum/30-integrations/908610-stock-manager-not-updating-product-sales#363178 "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2 Hello I'm using the Barcode Stock Manager and it is a great extension for Hikashop. But what is missing is that it does not update the product-sales field in the product table. Is this not implemented, or is it a matter of configuration that I am not aware of? Any help appreciated. menno")* But selling a product on location (instead of online) is also relevant for the product_sales column. And I use the Stock Manager to update the stock of course but it should also update the product_sales. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy85MDg2MTAtc3RvY2stbWFuYWdlci1ub3QtdXBkYXRpbmctcHJvZHVjdC1zYWxlcz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 2 years 1 month ago [\#363180](#363180) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Stock manager not updating product\_sales](/forum/30-integrations/908610-stock-manager-not-updating-product-sales#363180 "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2 Hello I'm using the Barcode Stock Manager and it is a great extension for Hikashop. But what is missing is that it does not update the product-sales field in the product table. Is this not implemented, or is it a matter of configuration that I am not aware of? Any help appreciated. menno")* Hi, Usually, the Stock manager is there to restock products (when you get a bunch of stock for a product, you increment the stock of the product of that amount). And usually, when merchants get on location sales, they create orders in the backend, which update the stock and the product_sales automatically. Doing it like this, it also means that you can keep a more consistent accounting (you can have the taxes calculated for the on location sales too, so that when you look at your taxes via the "manage tax rates" button of the System>Taxes menu, you get these on location sales' tax taken into account, and when you export your orders data to import in an accounting software these on location sales are also in there), and edit invoices for your customers, if necessary. If you use the Stock manager to correct the stock with on location sales, you don't get all this. So that's why it's currently like this. Now, there are two ways to go about this: - The Stock manager plugin has its own events ( onAfterStockCreate and onAfterStockUpdate ), so it's possible to update the product_sales of a product based on how the stock is being changed via the development of a small plugin implementing these events. - I'm not necessarily against adding an extra option to the Stock manager plugin in order to handle this. But I would first need to better understand the situation on your end. Why are you adding on location sales through the Stock manager ? Could you elaborate on this ? Do you not use the Stock manager when you restock products ? Only for on location sales ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy85MDg2MTAtc3RvY2stbWFuYWdlci1ub3QtdXBkYXRpbmctcHJvZHVjdC1zYWxlcz90bXBsPW1hcmtkb3du) 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.180 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)