[Skip to main content](#vessel-content)

#   How can I export a .csv with the categories ids?

##

- **[mici](/forum/user/33257-mici "View mici's Profile")**
- [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author
- [ Offline](/forum/user/33257-mici)

Less More

- Posts: 16
- Thank you received: 0
-
-

11 years 9 months ago -  11 years 9 months ago [\#185719](#185719) by [mici](/forum/user/33257-mici "View mici's Profile")  *[How can I export a .csv with the categories ids?](/forum/37-import-export-csv-xls/874090-how-can-i-export-a-csv-with-the-categories-ids#185719 "-- url of the page with the problem -- : 5.10.105.46/~yamitysb/ -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3&#96; -- PHP version -- : 5.3.28  How can I export a .csv with the categories ids? I was trying to do it through the Mass actions and even when checking the check box &quot;category id&quot; the csv came out with out it. It did not work with the general export option as well. Any idea?  I Have update to the latest stable version of HikaShop Business: 2.3.5 but still I can not export a .csv with the categories ids? via export categories or mass action.  backup of the website -   5.10.105.46/~yamity3c/  Please help")* was created by *[mici](/forum/user/33257-mici "View mici's Profile")*

-- url of the page with the problem -- : 5.10.105.46/~yamitysb/
-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3&#96;
-- PHP version -- : 5.3.28

How can I export a .csv with the categories ids?
I was trying to do it through the Mass actions and even when checking the check box "category id" the csv came out with out it. It did not work with the general export option as well. Any idea?

I Have update to the latest stable version of HikaShop Business: 2.3.5 but still I can not export a .csv with the categories ids? via export categories or mass action.

backup of the website - [ 5.10.105.46/~yamity3c/](http://5.10.105.46/~yamity3c/)
Please help

Last edit: 11 years 9 months ago by [mici](/forum/user/33257-mici "View mici's Profile"). Reason: Updated and that not fix the issue

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQwOTAtaG93LWNhbi1pLWV4cG9ydC1hLWNzdi13aXRoLXRoZS1jYXRlZ29yaWVzLWlkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[korzo](/forum/user/34428-korzo "View korzo's Profile")**
- [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile")
- [ Offline](/forum/user/34428-korzo)

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 9 months ago [\#185738](#185738) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[How can I export a .csv with the categories ids?](/forum/37-import-export-csv-xls/874090-how-can-i-export-a-csv-with-the-categories-ids#185738 "-- url of the page with the problem -- : 5.10.105.46/~yamitysb/ -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3&#96; -- PHP version -- : 5.3.28  How can I export a .csv with the categories ids? I was trying to do it through the Mass actions and even when checking the check box &quot;category id&quot; the csv came out with out it. It did not work with the general export option as well. Any idea?  I Have update to the latest stable version of HikaShop Business: 2.3.5 but still I can not export a .csv with the categories ids? via export categories or mass action.  backup of the website -   5.10.105.46/~yamity3c/  Please help")*

You have very old version of Hikashop. It works in latest version.

If for a reason you can't update, you can export categories ids using phpMyAdmin.

In phpMyAdmin select your database, click on SQL and use this command: Code:

SELECT category_id, category_name FROM &#96;#__hikashop_category&#96; WHERE &#96;category_type&#96; = 'product'

Replace #__ with your database prefix.
Uder the result table, there is "Export" icon.
Click on it and choose "CSV" and click "Go"

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQwOTAtaG93LWNhbi1pLWV4cG9ydC1hLWNzdi13aXRoLXRoZS1jYXRlZ29yaWVzLWlkcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; 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.156 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
