Record Mapping in Oracle NetSuite

Chargebee provides you with a user-friendly interface for managing Object-to-Record mapping. This feature streamlines tasks such as migration and correcting mapping errors, reducing your dependency on Chargebee support and significantly speeding up your processes. This enhancement alleviates bottlenecks, ensuring smoother transitions and error resolutions. Consequently, you may experience increased satisfaction, and your support requests will be minimized, fostering a more seamless user experience.

This feature addresses your daily needs and pain points by managing record mapping through an intuitive user interface.

Key benefits include:

• Migrating smaller data batches at your convenience.
• Correcting incorrect record mappings post-migration.
• Reducing your dependency on support for routine mapping tasks.

Setting Up the Record Mapping Feature

Step 1: Set up the Integration

1. Log into your Chargebee site.
2. Navigate to Apps > Oracle NetSuite.
3. Go to the Manage NetSuite Integration page and click the Manage Record Mapping button on the right side of the navigation bar.

Step 2: Map objects between Chargebee and NetSuite

1. Once you click the Manage Record Mapping button, the system redirects you to this page.

2. Select the object type (customers, invoices, credit notes, or transactions) for mapping from the drop-down menu.

   

3. Click Download CSV to download a CSV template for the selected record type.

4. The CSV has the following headers. For each row, enter either the NetSuite Internal ID or the NetSuite record ID. You do not need to enter both.

   • Chargebee ID - Add the Chargebee Customer, Invoice, Credit Note, or Transaction ID.

   • NetSuite Internal ID (recommended) - Add the internal ID for the NetSuite customer, invoice, credit memo, payment, or refund.

   • NetSuite ID - Add the NetSuite record ID or number visible in NetSuite for the customer, invoice, credit memo, payment, or refund.

     

Step 3: Upload Record Mapping

You can upload the mapping changes to perform the following operations:

• Basic validation of the data uploaded to the CSV file.

Step 4: Mapping Completion

After completing the mapping process:

• You receive a confirmation.

• The system displays the number of records successfully mapped, indicating the completion and success of the process.

  

• The system will include any errors in the provided data in a new CSV, which you can download by clicking the Download Errors button.