[Skip to main content](#vessel-content) # Mass Actions - Export to xls issue ## - **[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")** - [![ponygirl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5710-ponygirl "View ponygirl's Profile") Topic Author - [ Offline](/forum/user/5710-ponygirl) Less More - Posts: 46 - Thank you received: 1 - - 13 years 1 month ago [\#123741](#123741) by [ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile") *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#123741 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* was created by *[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")* Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please ![:)](/media/kunena/emoticons/3.png ":)") Thanks - [ ![h54e2af4_2013-09-16.png](/forum/attachment/12290) ](/forum/attachment/12290 "...2013-09-16.png") [ ](/forum/attachment/12290?download=1 "...2013-09-16.png") - [ ![h68ab2e1.jpg](/forum/attachment/12291) ](/forum/attachment/12291 "h68ab2e1.jpg") [ ](/forum/attachment/12291?download=1 "h68ab2e1.jpg") - [ ![h259f181.jpg](/forum/attachment/12292) ](/forum/attachment/12292 "h259f181.jpg") [ ](/forum/attachment/12292?download=1 "h259f181.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) 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 1 month ago [\#123823](#123823) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#123823 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Hi, As I can see, the quantities are correct, but some variants are missing. Are these variants specifics in some parameters, or they are like the other one ? Can you try to add a filter on the product column code, and add a contains "stgl" to see if all the variants are exported ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")** - [![ponygirl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5710-ponygirl "View ponygirl's Profile") Topic Author - [ Offline](/forum/user/5710-ponygirl) Less More - Posts: 46 - Thank you received: 1 - - 13 years 1 month ago [\#124116](#124116) by [ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile") Replied by *[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#124116 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Yes i did that and applied the filter and still they do not all show.. Please see the attached two files I really need help with this ... many thanks - [ ![hf500560.jpg](/forum/attachment/12335) ](/forum/attachment/12335 "hf500560.jpg") [ ](/forum/attachment/12335?download=1 "hf500560.jpg") - [ ![h090383b.jpg](/forum/attachment/12336) ](/forum/attachment/12336 "h090383b.jpg") [ ](/forum/attachment/12336?download=1 "h090383b.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) 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 1 month ago [\#124197](#124197) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#124197 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Hi, Could you provide a backend and FTP access to your website via our contact form so that we can look at the problem directly there as we don't have the problem on our end ? Please include a link to this thread in your message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) 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 1 month ago [\#124662](#124662) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#124662 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Hi, I just tried the following parameters: [ ![hbc32da9.png](/forum/attachment/12409) ](/forum/attachment/12409 "hbc32da9.png") And all the variants are exported well. I think the problem is that you have too many products to export in one csv, thanks to try to use the limits in the filters and make 2 or 3 export. We will improve this part of the code nearly. - [ ![hbc32da9.png](/forum/attachment/12409) ](/forum/attachment/12409 "hbc32da9.png") [ ](/forum/attachment/12409?download=1 "hbc32da9.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")** - [![ponygirl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5710-ponygirl "View ponygirl's Profile") Topic Author - [ Offline](/forum/user/5710-ponygirl) Less More - Posts: 46 - Thank you received: 1 - - 13 years 4 weeks ago [\#128326](#128326) by [ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile") Replied by *[ponygirl](/forum/user/5710-ponygirl "View ponygirl's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#128326 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Hi I see that some bug fixes where released recently. can you tell me if this issue is now fixed? Many thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) 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 3 weeks ago [\#128376](#128376) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass Actions - Export to xls issue](/forum/3-bug-report/862048-mass-actions-export-to-xls-issue#128376 "Hi I have set up a mass action report to export all my products and sub item products to a excel report. However when i run the action it does not reflect the current levels of quantity in the my products within Hikashop. I have attached 3 images One showing the settings (no filters applied) One showing the xls result not showing the correct quantities or missing variants The last one showing the quantities view within Hikashop It is not a sorting issue btw in the s/sheet HELP please :) Thanks")* Hi, It has not been released yet. We can't actually give a date of the next release. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjIwNDgtbWFzcy1hY3Rpb25zLWV4cG9ydC10by14bHMtaXNzdWU/dG1wbD1tYXJrZG93bg==) 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.090 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)