Adding Customers to the database

Andy K's Avatar

Andy K

23 Apr, 2014 03:53 PM

We would like to add several hundred customers to the database using SQL.

Could you provide a list of tables we need to update (contact, contact_map etc.) ?

The fields in the contact table are pretty self explanatory but it would be helpful if you could elaborate further on those in the contact_map table.

Many thanks.


  1. 1 Posted by Musaddique on 14 Nov, 2014 05:48 AM

    Musaddique's Avatar

    basically there are two table in jbilling where customer data is added.

    base_user and customer

    iI you want to add meta_field so there is mapping of customer_meta_field_map with meta_field_value and meta_field_name.

  2. Support Staff 2 Posted by Technical Suppo... on 08 Jan, 2015 05:59 AM

    Technical Support's Avatar

    Hello Andy K,

    Please let us know if you need further assistance on this issue.

    Thank you,
    Technical Support Team

  3. Technical Support closed this discussion on 08 Jan, 2015 05:59 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac