Adding or Updating Order Data Using Data Loader

You can use Data Loader to add order data to Bronto or update order data that is already in Bronto.

About this task

You can use Data Loaders Add or Update Order option to add orders, update orders, or do both at once. Adding orders using Data Loader allows you to directly import order data without needing to configure commerce settings in the platform. Once the Data Loader import is configured, order data is added or updated every time a file matching the import settings is found on the FTP server when the import is run. You can use a delimiter to offset each line item in your file and specify which delimiter was used in Data Loader.

Once the import has run, you can go to Commerce > Orders to view your orders or changes to your orders. For more information see Orders Page.


  1. Go to Settings > Data Loader.
  2. Click Create Import.
  3. Enter the relevant information in the Create Import Job window.
    1. Enter a name for the import in the Name box.
    2. Enter a description for the import in the Description box.

      The description is a good way to distinguish between similar imports.

    3. Select Add or Update Orders from the Type list.
    4. Click Create Import Job.
  4. Click Upload Sample File To Begin Mapping to map the categories in your file to fields in Bronto.

    This lets Bronto know how to appropriately manage your order data as it is imported.

  5. In the Upload Sample File window, select the delimiter used in your file from the Delimiter list.
    The delimiter is the character that is used to offset, or indicate, unique pieces of information in your file. For example, if there is a comma between the fields in your file, then your file uses a comma as a delimiter. Data Loader supports the following characters:
    • Pipe (|)
    • Comma (,)
    • Semicolon (;)
    • Tab
  6. If you have not transferred your file to the server, upload the file as a sample file so you can use it to complete the import mapping:
    1. In the Upload Sample File window, select Upload a file.
    2. Click Choose File, and select your file.
    3. Click Open.
    4. Click Upload Sample File.

    If the file upload is successful, the mapping page will be displayed.

    Note: The file is not uploaded to the FTP server, nor imported to Bronto. To transfer the file and import to Bronto, you need to configure your Data Loader import.
  7. If you have transferred a file to the server that you want to map data for:
    1. In the Upload Sample File window, click Select one of the files in your account.
    2. Select your file from the Files list.
    3. Click Upload Sample File.

    If the file upload is successful, the mapping page will be displayed.

  8. Select the Bronto order field from the Mapped to list that matches the data shown for the column.

    Mapping helps the platform manage data as it is imported. For example, in the image below you would select Email for Column #1 and Order ID for Column #2.

    The available Bronto order fields are set; you cannot create new order fields.

    Note: The enhanced order attribution model currently only considers orders where the Source field is equal to WEBSITE.

  9. On the Configuration tab in the General area, configure the general settings for your import:
    1. Select Yes or No in the Skip First Row Header list.
    2. Select the method you want Bronto to use for file name matching from the Filename Matching Scheme list
      • Ends with will match files based on the extension specified for the Filename Matching Pattern. Only use Ends with when this your only import that uses this file type and you are only submitting one type of file for this import. If you have multiple Data Loader import jobs and want the file extension taken into consideration, Custom Glob is the best choice.
      • Starts with will match files based on the characters specified for the Filename Matching Pattern starting with the first character. For example, if you have contact for the Filename Matching Pattern then all files on the FTP server that start with the word contact will attempt to be imported.
      • Custom Glob will match files based on the characters and the extension specified for the Filename Matching Pattern. This allows you to use wild cards in order to build more complex import queries.
    3. Enter a full or partial file name in the Filename Matching Pattern box.

      This is used in conjunction with the Filename Matching Scheme to recognize what files on the FTP server should be imported using this import job. If you use the Custom Glob option for Filename Matching Scheme you can use wild cards. Make sure the information you include here is specific enough that the import job won't attempt to import files on your FTP server location that are intended for other import jobs you may have configured. But also keep the file name general enough that the import will be able to import multiple files with slightly different names if your import requires using multiple files.

    4. If you want to receive an email notification when your imports complete, enter an email address in the Confirmation Email box.

      The notification email contains high-level information about the import and provides instructions to download a run log that contains any errors the import may have.

  10. In the Expected Data Format area, configure how you want the data in your file to be managed as it is imported:
    1. Select a delimiter from the Delimiter list.
    2. If you plan to import date-based data, click the calendar icon under Date Format and fill in the options in the Date Format Builder window.

      You must map a date-based field before you can configure Date Format. In the Date Format Builder, select a date from the Example Date & Time list, click Go, then click on each number in the date to select whether it is a Day, Month, or Year, and then click Done.

    3. Select a default shipping status to apply to orders during the import from the Default Shipping Status list.

      This is only applied to orders where the shipping status is not provided. The default is Not Shipped, but you can change this to Shipped.

    4. Select an order status to apply to orders during the import from the Default Order Status list.

      This is only applies to orders where the order status is not provided. Pending orders are orders that have not been completed and Processed orders have been completed.

      Note: An order with a Processed status that has already shipped cannot be changed to Pending. Therefore, data associated with a shipped order with a Pending status will not be imported.
    5. If you want workflows that are triggered by the Order Is Added or Order Is Shipped trigger nodes to recognize and trigger on changes to order and shipping statuses made by the import, set Trigger Workflows on Status Update to Yes.

      When set to No, imported orders with a change to either the shipping status or the order status will not trigger these workflows even if the status change typically would.

    6. Select a currency type from the Default Currency list.

      The currency should match the currency you have set for your Bronto account.

  11. In Bronto Settings, configure any Bronto-specific settings.
    If you want to add contacts to a list as they are imported, enter the list name in Add Contacts to Specified Lists.
  12. When you have finished import configuration, click Save & Close.

    A window that asks you to confirm that you understand and have correctly configured whether your orders should be imported as pending or processed.

    1. Select the I Agree box.
    2. Click Continue.
  13. Find the import you just configured and Perform a Test Run to ensure that the files are valid.

    Based on the results of the test run, fix any issues as necessary.

What to do next

After the import has run, you can Data Loader Reports to see details about your import.