Magento 1 Extension Order Import

You can import past-purchase information, including complete order history and product details, for more informed and more targeted marketing campaigns.

Before you begin

Important: From June 30, 2020 Adobe will not support Magento 1. The Bronto Magento 1 extension will continue to function, but Oracle NetSuite has discontinued updates and client support. You can read more about Adobe's end of support plan for Magento 1 here.
To import orders you first need to create a REST API ID and Secret in Bronto with Orders Read and Orders Write permissions. After you have created your REST API ID and Secret, go to Advanced API in Magento and enter that information under REST Options.
Note: You can only use the Order Import Module if you are using version 2.6.1 or later of Bronto's Magento Extension.

About this task

The Magento 1 Extension lets you import past-purchase information, including complete order history and product details.

To use the Order Import module:

Procedure

  1. Enable the module:
    1. Go to System > Configuration.
    2. In the left menu, scroll until you see Bronto and click Order Import.
    3. In the section, these are the recommended settings:
      Enable Module: Yes
      Enable REST (Order Service API) Yes
      Use Magento Cron Yes
      Frequency: Minute Intervals
      Interval: 15 minutes
      Start Time: 0:0:0
      Limit: 100
      Sync Limit: 1000
      API Bulk Limit: 100
      Bronto Order Status Processed
      Order Import State: New, Pending Payment, Processing, Complete, Payment Review
      Order Delete Status: Closed, Canceled, On Hold
    4. Click Save Config.
  2. Adjust product attributes:

    The Product Attributes section allows you to customize some of the product data imported to your Bronto account. By default the Display Price with no modification is imported into Bronto. You can decide whether you want the Base Price (Base Currency), include tax, and/or include line item discounts. You can also choose which product description to use.

    1. Go to System > Configuration.
    2. In the left menu, scroll until you see Bronto and click Order Import.
    3. In the Settings section, these are the recommended settings:
      Product Description short_description
      Product Price Display Price
      Include Discounts Yes
      Include Taxes No
      Include Shipping Yes
      Other
  3. Sync orders to queue:

    This process updates Bronto's order processing queue table with the order table in Magento. It does not push the orders to Bronto.

    1. Navigate to System > Configuration.
    2. In the left menu, scroll until you see Bronto and click Order Import.
    3. Click Sync Orders to Queue until you see the message All Orders are synced to the queue.
  4. Check the schedule date and confirm it is today’s date to verify the Cron is running for Scheduled Import.
    Note: The table will remain empty until the Cron has completed its first run.
  5. To test, create an order and import it into Bronto:
    1. Create an order in Magento and complete the checkout process.
    2. Either wait for the Cron to run or Navigate to System > Configuration.
    3. In the left menu, scroll until you see Bronto and click Order Import.
    4. Click in the bottom right of the screen.
  6. Test that the order data is being captured correctly:
    1. After you have completed the previous steps, place a test order on your site.
    2. In Bronto, go to Commerce > Orders.
    3. Click Show Advanced Options.
    4. Use the Order Date fields to search for orders from the current day.
    5. Find your test order in the list and compare the order details in Bronto to the order details on your site.

      If you have successfully performed an order import from Magento but do not see conversions in your account, your Bronto account is likely still using Bronto's Legacy Conversion Tracking (our old version of importing order data). To view historical Magento orders imported using the steps above in Bronto, you will need to work with Bronto support to have your account's order data migrated to Order Service.