Deleting Orders Using Data Loader

You can use Data Loader to remove order data from Bronto. You can delete both pending and processed orders. Once the order data is deleted from Bronto it cannot be recovered.


  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 Delete 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 contact fields in Bronto.

    This let's Bronto know how to appropriately manage your contact 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 Map to list that matches the data shown for the column.

    To delete order data, Customer Order ID needs to be mapped.

  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 data 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 currency type from the Default Currency list.

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

  11. 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.
  12. 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.