Perform data backfill

Perform data backfill

You can perform the following data backfill actions:

• Use Charge Original Created on Date as Booking Date 

  If you became a Zuora customer after 2022, you do not need to perform the Use Charge Original Created on Date as Booking Date action.

• Update Product Rate Plan Charge
• Update Rate Plan Charge
• Update Invoice Item
• Update Credit Memo Detail
• Update Debit Memo Detail
• Update Invoice Item Adjustment

To update the booking date field with the charge's original created-on date, do the following:

1. Go to the Select Data Backfill Action dropdown field, and select the Use Charge Original Create on Date as Booking Date action.
2. Click Generate.

To update the fields other than the booking date, do the following:

1. Go to the Select Data Backfill Action dropdown field, and select the update action that you want to perform, for example, Update Product Rate Plan Charge.

   

2. Click the link below the preceding dropdown field to download the template for the corresponding update action.
3. In the template file, add the necessary values that you want to update in the object records. Also, remove the field columns that you do not want to update. Note the following:
   • Only the field columns predefined in the template can be updated in the data backfill. You cannot add new columns to extend the scope of fields for your data backfill.
   • You can add read-only columns in the template by using a column name starting with #. These read-only columns do not affect the data backfill and are just used as reference fields in the template file. For example, you can add a column called # Product Rate Plan Charge Name to add corresponding product rate plan names for your reference. However, the product rate plan charge names appearing in this column will not be updated in the system's product rate plan charge records. 
   • If you do not want to update the field values for a predefined column in the template, you must remove the column from the template. Otherwise, null values in the predefined column of the template will be updated to the records during the data backfill.
4. In the Upload File section, click the Upload File button to upload the template file.
5. Click Generate.

   As the data backfill starts, you can view the backfill progress and results in the Backfill Logs section. For more information, see View backfill logs.

View backfill logs

In the Backfill Logs section, you can view your backfill progress, results, and other information, as in the following diagram:

As the preceding diagram shows, you can see the following information for a data backfill:

• Backfill Action: the type of backfill action that you perform
• Uploaded File: When the data backfill is completed, you can download the file that you previously uploaded for data backfill. This file now contains the data backfill result for each record in the Success column of the file. For the record that fails to be updated, you can see the reason for failure in the Error Message column of the file. 
• Start Date: the time that a data backfill starts
• End Date: the time that a data backfill ends
• Generated By: the user who performs the data backfill
• Records Processed: the number of records that have been processed in the data backfill
• Status: The result status of the data backfill. See the following table for all the possible statuses for a data backfill:

  Status	Description
  Accepted	The booking date backfill action is triggered and ready for processing.
  Pending	The file that you uploaded for data backfill is being validated.
  Processing	The data backfill is in progress.
  Failed	The data backfill has failed. Contact Zuora Global Support for more information.
  Completed	The data backfill is completed. For a data backfill action for which you uploaded a file, you can now download the file and check the result for the data backfill.

You can also click the Action icon  to open the Backfill log details window and view more detailed information.