[Skip to main content](#vessel-content) # Getting the price\_value for a particular access\_level ## - **[Genr8r](/forum/user/44235-genr8r "View Genr8r's Profile")** - [![Genr8r's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/44235-genr8r "View Genr8r's Profile") Topic Author - [ Offline](/forum/user/44235-genr8r) Less More - Posts: 43 - Thank you received: 5 - - 4 years 7 months ago - 4 years 7 months ago [\#340697](#340697) by [Genr8r](/forum/user/44235-genr8r "View Genr8r's Profile") *[Getting the price\_value for a particular access\_level](/forum/44-mass-actions/904225-getting-the-price-value-for-a-particular-access-level#340697 "-- HikaShop version -- : 4.5.0 -- Joomla version -- : 3.10.6 -- PHP version -- : 8.1.4 -- Browser(s) name and version -- : Brave 1.37.111 -- Error-message(debug-mod must be tuned on) -- : no error msg Greetings, I am trying to create a CSV export that shows me the price_value for a particular access_level. I have filters set to show me all published products for Super Users (access_level 8 ) The resulting CSV correctly filters for the needed products. I can see in the database table _hikashop_price that each access level has a unique record to display its price_value and then uses the product_id to JOIN all the price_values to the appropriate record in the _hikashop_product table. However, when I generate the CSV for export it combines all the price rows into a single row for the product in the CSV and then pipe | separates all the values for access_level. This is fine but it gives me ONLY the price for the lowest access level for price_value. I need the price_value for each access_level. I need the price_value of all the Super Users (access_level = 8 ). This price is not listed in the price_value field. I used to be able to generate this report with all the price_values pipe separated for all the access_level's.")* was created by *[Genr8r](/forum/user/44235-genr8r "View Genr8r's Profile")* -- HikaShop version -- : 4.5.0 -- Joomla version -- : 3.10.6 -- PHP version -- : 8.1.4 -- Browser(s) name and version -- : Brave 1.37.111 -- Error-message(debug-mod must be tuned on) -- : no error msg Greetings, I am trying to create a CSV export that shows me the price_value for a particular access_level. I have filters set to show me all published products for Super Users (access_level 8 ) The resulting CSV correctly filters for the needed products. I can see in the database table _hikashop_price that each access level has a unique record to display its price_value and then uses the product_id to JOIN all the price_values to the appropriate record in the _hikashop_product table. However, when I generate the CSV for export it combines all the price rows into a single row for the product in the CSV and then pipe | separates all the values for access_level. This is fine but **it gives me ONLY the price for the lowest access level for price\_value. I need the price\_value for each access\_level.** I need the price_value of all the Super Users (access_level = 8 ). This price is not listed in the price_value field. I used to be able to generate this report with all the price_values pipe separated for all the access_level's. Last edit: 4 years 7 months ago by [Genr8r](/forum/user/44235-genr8r "View Genr8r's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDQyMjUtZ2V0dGluZy10aGUtcHJpY2UtdmFsdWUtZm9yLWEtcGFydGljdWxhci1hY2Nlc3MtbGV2ZWw/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: 86357 - Thank you received: 14289 - - 4 years 7 months ago [\#340723](#340723) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Getting the price\_value for a particular access\_level](/forum/44-mass-actions/904225-getting-the-price-value-for-a-particular-access-level#340723 "-- HikaShop version -- : 4.5.0 -- Joomla version -- : 3.10.6 -- PHP version -- : 8.1.4 -- Browser(s) name and version -- : Brave 1.37.111 -- Error-message(debug-mod must be tuned on) -- : no error msg Greetings, I am trying to create a CSV export that shows me the price_value for a particular access_level. I have filters set to show me all published products for Super Users (access_level 8 ) The resulting CSV correctly filters for the needed products. I can see in the database table _hikashop_price that each access level has a unique record to display its price_value and then uses the product_id to JOIN all the price_values to the appropriate record in the _hikashop_product table. However, when I generate the CSV for export it combines all the price rows into a single row for the product in the CSV and then pipe | separates all the values for access_level. This is fine but it gives me ONLY the price for the lowest access level for price_value. I need the price_value for each access_level. I need the price_value of all the Super Users (access_level = 8 ). This price is not listed in the price_value field. I used to be able to generate this report with all the price_values pipe separated for all the access_level's.")* Hi, Thank you for your feedback. I was able to reproduce the problem on my end. It comes from improvments we had made to the export system to auto detect the type of the column based on the type of the column in the database. This lead to the system using the type of the database column even for merged data from several rows (like it is the case for the price columns for products with multiple prices ) instead of handling it as a text. I've made a patch for it. Download the install package of HikaShop on our website and install it on yours and you'll get the patch. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDQyMjUtZ2V0dGluZy10aGUtcHJpY2UtdmFsdWUtZm9yLWEtcGFydGljdWxhci1hY2Nlc3MtbGV2ZWw/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.047 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)