Show VAT in user details

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.5.11

Hello,

I am unable to find the VAT number of registered clients.
Please tell me where i can find it,

Thank you for your quick help

Greeting Kaz

Hello,
If your "VAT number" field is a user custom field,you should probably enable it for your back-end Listing/Form through "Hikashop->Display->Custom fields"

Hello Mr. Thelji,

Thank you for your reply.
I have enabled it on the custom field settings, see Jpeg

Please advice

Hello,
Your problem is coming from the fact that your custom field is a field from the "Address" table, so to edit it you'll just have to edit your user address.

Hello Mr. Thelji,

Thank you for your advise.
You are correct the VAT number is visible when I try to edit the user details.

Is there also a possibilityu to export are user data to an excel file?

Thank you

Hi,

You can use the mass action to export users into a csv or xls file.
Just go in System > Mass actions, and create a mass action on the data "user" in the action part select "Export csv file" and select the desired checkboxes, then click on "process" in the toolbar, and that will export the data in a csv file