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

#   Is there a way to export "Subscriptions" to a external file?

##

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago [\#332912](#332912) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332912 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")* was created by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")*

-- HikaShop version -- : 4.4.2
-- HikaSerial version -- : 3.1.2
-- Joomla version -- : 3.9.26
-- PHP version -- : 5.6.40

Hello,

I want to be able to see a list of my subscriptions with both the "Subscription plan" and "email" present. Is there a way to export "Subscriptions"? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image  [ ![Screenshot2021-05-25at17.25.30.png](/forum/attachment/52805) ](/forum/attachment/52805 "...at17.25.30.png")

- [ ![Screenshot2021-05-25at17.25.30.png](/forum/attachment/52805) ](/forum/attachment/52805 "...at17.25.30.png") [ ](/forum/attachment/52805?download=1 "...at17.25.30.png")

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

5 years 5 months ago [\#332918](#332918) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332918 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hello,

You can use a view override for the backend view "subscription / listing".
In that view, you will find the content Code:

if(!empty($row-&gt;username)) echo $row-&gt;username; else echo '&lt;em&gt;' . $row-&gt;subscription_user_id . '&lt;/em&gt;';

which is dedicated to the display of the user ; you can add the display of the email address (in the same table column or in a new one) thanks to " user_email "

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")

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

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago [\#332924](#332924) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  Replied by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332924 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hi Jerome,

Thanks for the message.

I have found this file and I understand what needs to be done. Sadly I have very little PHP experience so could you please help me put this together? Ideally, I would like to remove the "Username" column and add "Name" and "Email. After this I shouldn't need any more help!

Thanks

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

5 years 5 months ago [\#332937](#332937) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332937 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hello,

So replace the content I mentioned in my previous message with Code:

echo $row-&gt;user_email;

And you will display the user email instead of username.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")

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

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago [\#332959](#332959) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  Replied by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332959 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hi Jerome,

Thanks for this! Works perfectly.

Could you please tell me how to replace "ID" with "Name"?

Thank you

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

5 years 5 months ago [\#332997](#332997) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#332997 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hello,

It depends what you mean by "name". The information can be more complicated to retrieve and could require code modification in order to perform extra SQL queries.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")

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

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago [\#333061](#333061) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  Replied by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#333061 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hi Jerome,

Thanks for your reply.

I have attached the "Name" that I mean.

Thanks,
Josh.

[ ![Screenshot2021-06-01at09.55.08.png](/forum/attachment/52827) ](/forum/attachment/52827 "...at09.55.08.png")

- [ ![Screenshot2021-06-01at09.55.08.png](/forum/attachment/52827) ](/forum/attachment/52827 "...at09.55.08.png") [ ](/forum/attachment/52827?download=1 "...at09.55.08.png")

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

5 years 5 months ago [\#333078](#333078) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#333078 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hello,

So that's the Joomla "name" field that you can display thanks to : Code:

echo $row-&gt;name;

If it would be the lastname from the HikaShop address table, it would be a lot more complicated.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")

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

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago -  5 years 5 months ago [\#333085](#333085) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  Replied by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#333085 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hi Jerome,

Thank you.

Again I'm a PHP noob. What do I replace in subscription/listing to replace Code:

echo $row-&gt;name;

with ID.

Thanks

Last edit: 5 years 5 months ago by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile").

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

5 years 5 months ago [\#333107](#333107) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#333107 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Hi,

Well. You could add that code after the line:
echo $row-&gt;user_email;
that you've added before.
That would add the name after the email address on the listing, in the same column.

The following user(s) said Thank You: [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")

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

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

Less More

- Posts: 220
- Thank you received: 12
-
-

5 years 5 months ago [\#333157](#333157) by [joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")  Replied by *[joshualdouglas](/forum/user/49377-joshualdouglas "View joshualdouglas's Profile")* on topic *[Is there a way to export "Subscriptions" to a external file?](/forum/14-hikaserial/902646-is-there-a-way-to-export-subscriptions-to-a-external-file#333157 "-- HikaShop version -- : 4.4.2 -- HikaSerial version -- : 3.1.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 5.6.40  Hello,  I want to be able to see a list of my subscriptions with both the &quot;Subscription plan&quot; and &quot;email&quot; present. Is there a way to export &quot;Subscriptions&quot;? If not, is it possible to add the user's email address to the subscriptions list? - Please see attached image")*

Perfect. Thank you so much!

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

Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile")

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.066 seconds

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