[Skip to main content](#vessel-content) # product\_sales not lining up with number of orders ## - **[dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile")** - [![dustinjc's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31466.jpg)](/forum/user/31466-dustinjc "View dustinjc's Profile") Topic Author - [ Offline](/forum/user/31466-dustinjc) Less More - Posts: 176 - Thank you received: 5 - - 3 years 5 months ago [\#351818](#351818) by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") *[product\_sales not lining up with number of orders](/forum/35-orders-management/906414-product-sales-not-lining-up-with-number-of-orders#351818 "We've created some custom reports via massactions, reports, and also a third party tool (ROCSVI). I've noticed that in the products table, the product_sales value for parent product and variants does...")* was created by *[dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile")* We've created some custom reports via massactions, reports, and also a third party tool (ROCSVI). I've noticed that in the products table, the product_sales value for parent product and variants does not seem to match the actual number of orders placed for the products. Can you tell me what the product_sales value actually reflects and why this may generate a different total? Thank you, Dustin Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjQxNC1wcm9kdWN0LXNhbGVzLW5vdC1saW5pbmctdXAtd2l0aC1udW1iZXItb2Ytb3JkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14285 - - 3 years 5 months ago [\#351822](#351822) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[product\_sales not lining up with number of orders](/forum/35-orders-management/906414-product-sales-not-lining-up-with-number-of-orders#351822 "We've created some custom reports via massactions, reports, and also a third party tool (ROCSVI). I've noticed that in the products table, the product_sales value for parent product and variants does...")* Hi, This number is incremented each time an order is created. And it is not updated when orders are cancelled / deleted. It is a column of data you can user to roughly sort the products based on the sales on the frontend, to be able to get a "best sellers" products listing. But you can't use it as an accurate source of reporting. Mass actions and the reports in Orders>Reports on the other end base themselves on the actual orders, based on the statuses, etc so they provide accurate data. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjQxNC1wcm9kdWN0LXNhbGVzLW5vdC1saW5pbmctdXAtd2l0aC1udW1iZXItb2Ytb3JkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.047 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)