Jump to content

Customer Export to CSV with Custom Fields Add-On Information


Recommended Posts

I built a Prestashop site for a client.


The client required a custom sign up form, therefore I purchased and installed an add-on called "Custom Fields". The add-on does exactly what it's supposed too, it adds new custom fields to the sign up form, however unfortunately I can't export the data it collects with the default customer export CSV functionality native to Prestashop.


Does anyone know how I can integrate the information it collects by this add-on, into the default export function in Prestashop (Customers >> Export), or any other option I can explore regarding this request.


I've looked at the SQL manager possibility, but if the client wants to add a new custom field in the future (i.e.  How did you hear about us), then I'd have to go in and modify the SQL query every single time.


Help please!

Link to comment
Share on other sites

Partly found the solution, needed to enable "Show on customers list", however the export to CSV still doesn't work correctly, the fields are overwritten.


If I export with custom fields module checklist, you normally separete data to columns in excel with "Text to Columns" option, the data gets overlapped and erased because the checklist option exports into seperate columns, not into same column.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...