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

#   Exporting Hikashop information

##

- **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")**
- [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author
- [ Offline](/forum/user/32405-marjoline)

Less More

- Posts: 52
- Thank you received: 0
-
-

12 years 1 day ago [\#179785](#179785) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")  *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179785 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")* was created by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")*

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : any
-- Error-message(debug-mod must be tuned on) -- : No error message, just a question.

Hi,

I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands.
I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality?
So summarizing: at a minimum I need to export from Hikashop our:
- categories
- brands
- customers
in order to link information in MS Access.
That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?

Cheers,
Marjoline

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwMzMtZXhwb3J0aW5nLWhpa2FzaG9wLWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) 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
-
-

12 years 1 day ago [\#179800](#179800) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179800 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

You can export customers, brands and categories using mass action.
Also you can connect to MySQL database directly from MS Access.

The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwMzMtZXhwb3J0aW5nLWhpa2FzaG9wLWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) 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: 86564
- Thank you received: 14311
-
-

12 years 1 day ago [\#179801](#179801) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179801 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

Hi,

You can use mass actions (via the menu System&gt;Mass actions) on categories/users in order to export categories, brands (which are stored as categories) and customers data by using the "Export as CSV" action of your mass actions.
That will get you a CSV file that that then be imported in MS access.

The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")

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

- **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")**
- [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author
- [ Offline](/forum/user/32405-marjoline)

Less More

- Posts: 52
- Thank you received: 0
-
-

12 years 1 day ago [\#179828](#179828) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")  Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179828 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

The connection between a local MS Access and an ISP remote server -MySQL is not so easy, I have been told.
Thanks for sharing the idea, though.
Cheers,
Marjoline

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

- **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")**
- [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author
- [ Offline](/forum/user/32405-marjoline)

Less More

- Posts: 52
- Thank you received: 0
-
-

12 years 1 day ago [\#179829](#179829) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")  Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179829 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

Thanks, that sounds great, I will try. I am really happy that it is possible. I was in fact actually looking for export buttons in the same place as they are from the products maintenance page for products, and in the orders page for orders. And I didn't look in the Ststem/Mass Actions. Silly me. Blond, you know. ![;-)](/media/kunena/emoticons/24.png ";-)")
Thanks for the quick reply. You guys rock!
Cheers,
Marjoline

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

- **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")**
- [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author
- [ Offline](/forum/user/32405-marjoline)

Less More

- Posts: 52
- Thank you received: 0
-
-

12 years 1 day ago [\#179855](#179855) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")  Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179855 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

I have tried to export the tables with all the category fields, but it is not working for me. Exporting the addresses and orders works fine, but not the Categories. All the fields are not exported for the categories. I request for all the fields (see my screen print attached). What I get is a csv file with only the two fields with the name-of-the-category and the name-of-the-parent; no id's, nothing else. See also the screenprint of the file as attached. Nearly all the fields are missing.
What more do I need to do in order to get all the fields for which I have checked the boxes?

Cheers,
Marjoline

- [ ![Hikashop-Cat-fields-not-exporting-2.png](/forum/attachment/20710) ](/forum/attachment/20710 "...xporting-2.png") [ ](/forum/attachment/20710?download=1 "...xporting-2.png")
- [ ![Hikashop-Cat-fields-not-exporting-1.png](/forum/attachment/20711) ](/forum/attachment/20711 "...xporting-1.png") [ ](/forum/attachment/20711?download=1 "...xporting-1.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwMzMtZXhwb3J0aW5nLWhpa2FzaG9wLWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) 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
-
-

12 years 1 day ago [\#179867](#179867) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179867 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

You are right.
There is a bug in latest version. I fixed it in my version and forget to report it.
I will report it and update this this topic with fix later.

The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")

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

- **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")**
- [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author
- [ Offline](/forum/user/32405-marjoline)

Less More

- Posts: 52
- Thank you received: 0
-
-

12 years 1 day ago [\#179873](#179873) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")  Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179873 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

Ok, thanks, Korzo.
Can you let me know when it's fixed?
Cheers,
Marjoline

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwMzMtZXhwb3J0aW5nLWhpa2FzaG9wLWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) 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
-
-

12 years 1 day ago [\#179879](#179879) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Exporting Hikashop information](/forum/37-import-export-csv-xls/873033-exporting-hikashop-information#179879 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : No error message, just a question.  Hi,  I am looking to work with Hikashop data in MS Access, in order to prepare suppliers data for importing to Hikashop, for instance. I need to be able to translate their catagories to the Hikashop categories for instance. Each supplier has his own codes for his categories, so I need to add a translation step. Same goes for brands. I cannot find any information on how to export data like categories and brands, amongst others. Also customer details. Is it possible to export these with Hikashop, or are there any plans in the near future to add this kind of functionality? So summarizing: at a minimum I need to export from Hikashop our: - categories - brands - customers in order to link information in MS Access. That would save me having to type all these details over by hand, which would be good. Is there a way to do this already?  Cheers, Marjoline")*

Follow [ this](https://hikashop.com/forum/3-bug-report/873053-category-mass-action-export-has-only-2-columns.html#179876) for response from developers.
I posted also the fix that worked for me, but I don't guarantee it fix all problems nor has no side effects.

The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwMzMtZXhwb3J0aW5nLWhpa2FzaG9wLWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) 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.068 seconds

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