[Skip to main content](#vessel-content) # Products have dissappeared from orders ## - **[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")** - [![PFflyer's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28324-pfflyer "View PFflyer's Profile") Topic Author - [ Offline](/forum/user/28324-pfflyer) Less More - Posts: 7 - Thank you received: 0 - - 12 years 11 months ago [\#130637](#130637) by [PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile") *[Products have dissappeared from orders](/forum/35-orders-management/863313-products-have-dissappeared-from-orders#130637 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help.")* was created by *[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")* -- url of the page with the problem -- : [ mywebsite.com/mypage](http://mywebsite.com/mypage) -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg2MzMxMy1wcm9kdWN0cy1oYXZlLWRpc3NhcHBlYXJlZC1mcm9tLW9yZGVycz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86309 - Thank you received: 14274 - - 12 years 11 months ago [\#130649](#130649) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products have dissappeared from orders](/forum/35-orders-management/863313-products-have-dissappeared-from-orders#130649 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help.")* Hi, There are two possibilities: 1. The data is still there, but there is a query crashing which prevent the system to load the data. Turn on the debug mode of the joomla configuration and try again. If you get a MySQL error, then it means that you are in that case and knowing the MySQL error should allow us to tell you what to do to fix it. 2. One of the mass actions you run deleted the data in the database. Unfortunately, the only way to get it back will be to restore the data from a backup of your website. Mass actions are powerful but can be dangerous. It's best to first try them on a copy of your website before setting them up on your live website. The following user(s) said Thank You: [PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg2MzMxMy1wcm9kdWN0cy1oYXZlLWRpc3NhcHBlYXJlZC1mcm9tLW9yZGVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")** - [![PFflyer's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28324-pfflyer "View PFflyer's Profile") Topic Author - [ Offline](/forum/user/28324-pfflyer) Less More - Posts: 7 - Thank you received: 0 - - 12 years 11 months ago [\#130773](#130773) by [PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile") Replied by *[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")* on topic *[Products have dissappeared from orders](/forum/35-orders-management/863313-products-have-dissappeared-from-orders#130773 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help.")* I don't believe that I deleted the database as I am able to run reports showing the sales. I just don't see products listed on individual orders/invoices. I believe the mistake that I made was in Mass Actions and that I clicked on new, set nothing for either trigger or filter. Under actions I set "update the values" / "product name" = INT. / Save. Is there a way to reverse this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg2MzMxMy1wcm9kdWN0cy1oYXZlLWRpc3NhcHBlYXJlZC1mcm9tLW9yZGVycz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86309 - Thank you received: 14274 - - 12 years 11 months ago [\#130843](#130843) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products have dissappeared from orders](/forum/35-orders-management/863313-products-have-dissappeared-from-orders#130843 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help.")* These means that you removed all the product names of all the products. You can't reverse that. The only solution is to restore the data from a backup of your website. The following user(s) said Thank You: [PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg2MzMxMy1wcm9kdWN0cy1oYXZlLWRpc3NhcHBlYXJlZC1mcm9tLW9yZGVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")** - [![PFflyer's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28324-pfflyer "View PFflyer's Profile") Topic Author - [ Offline](/forum/user/28324-pfflyer) Less More - Posts: 7 - Thank you received: 0 - - 12 years 11 months ago [\#130891](#130891) by [PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile") Replied by *[PFflyer](/forum/user/28324-pfflyer "View PFflyer's Profile")* on topic *[Products have dissappeared from orders](/forum/35-orders-management/863313-products-have-dissappeared-from-orders#130891 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.0.4 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox 24 -- Error-message(debug-mod must be tuned on) -- : Error_message The product information on individual orders has gone missing. I also lost sales totals in Main Statistics. I don't know what I did. I was trying to set up and run reports via mass actions. I can still get product totals, so I believe the information is in the database but no longer showing on orders. If I create a new order the product shows up and Main statistics is updated. Please Help.")* I was able to restore from a back-up and am back to business. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg2MzMxMy1wcm9kdWN0cy1oYXZlLWRpc3NhcHBlYXJlZC1mcm9tLW9yZGVycz90bXBsPW1hcmtkb3du) 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.092 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)