[Skip to main content](#vessel-content) # Report--Orders missing address\_xxx fields sometimes ## - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 6 years 7 months ago [\#317505](#317505) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317505 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* was created by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* -- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 6 years 6 months ago [\#317524](#317524) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317524 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* Hi, We would fix need a screenshot of the settings of your report to better understand the situation. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 6 years 6 months ago [\#317575](#317575) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317575 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* Here is a screen shot, but it doesn't explain why the export output (csv) is different if the only thing we do is change the product filter. Why would one product not have the address_ fields show up, when it does for all of the others? Strange. https://next.stratacorps.com/index.php/s/dNgSHp74t63a6yT [ ![hikashop_report_problem.png](/forum/attachment/49078) ](/forum/attachment/49078 "...rt_problem.png") - [ ![hikashop_report_problem.png](/forum/attachment/49078) ](/forum/attachment/49078 "...rt_problem.png") [ ](/forum/attachment/49078?download=1 "...rt_problem.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 6 years 6 months ago [\#317604](#317604) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317604 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* Hi, Could you double check ? I tested it on my end and it worked all the time. I also looked at the code and as far as I can see the address data is automatically loaded if the report system is doing an export and that the content displayed is either "orders" or "sales". There is no check on the products or categories which could influence that as far as I could see. If you really have the problem, I'm afraid we'll need you to provide a backend access and a FTP access so that we can look into the situation more in depth. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 6 years 6 months ago [\#317613](#317613) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317613 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* Yes, here are two products, in the same category, one Export is generated for product id=1925 and it stops at the column for "order_parent_id" If you change the filter to product id=1941 you get the address_* fields. If you select a number of products, but include the 1925, the address fields are gone. Remove 1925 and they're back. I've emailed the current access instructions and referencing this thread. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 6 years 6 months ago [\#317903](#317903) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317903 "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.")* I had emailed private access and steps to reproduce, but the account wasn’t accessed in over 5 days and was disabled. If you still need access to resolve this bug, please send me an email/pm (the forums don’t always notify of responses). Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk1NTUtcmVwb3J0LW9yZGVycy1taXNzaW5nLWFkZHJlc3MteHh4LWZpZWxkcy1zb21ldGltZXM/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.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)