Configuring Product Automatic Import Settings

About this task

The Product Configuration page is where you can set the automatic import settings for your data feed. When you specify a URL or FTP location, Bronto scans the location specified once per day for your product data feed. If a newer version of the previously imported feed is detected, the contents of the feed are imported. It's important to note that imports are progressive. During import, the data feed is compared to the product data stored in Bronto and any existing data that does not match the new product data feed is changed. This means that you cannot upload partial files or the previously imported product data that is not included in the new file will be archived.

The automatic import process will not occur again until the next day. If you encounter an issue with the data in the automatic import that needs to be corrected before then, you can use the manual import process to import a new data feed with your corrections.

Note: When using FTPS for nightly automated pulls of the feed file, the FTPS site must be set to Explicit. If it is set to Implicit, the connection will fail.
Because Bronto needs access to your FTP or HTTP site to perform the nightly scan, you may need to configure your server to give us access. If so, the following are the specific IP address ranges that may attempt to connect:
  • 216.27.63.0/24

Procedure

  1. Go to Commerce > Products.
  2. Click Configure Import Feed.
  3. Select FTP or HTTP from the Do you want Bronto to automatically look for a new feed file nightly? list.
  4. Select the time you want the import to run by selecting:
    1. An hour of day from the Import Hour list.
    2. AM or PM from the Import AM/PM list.
  5. If using HTTP, enter the location where the product data feed is stored in the Feed URL box.
    HTTP Import Configuration
  6. Note: If you are using FTP, you have the option of using ftp.bronto.com with the FTP credentials associated with Data Loader for storing your product data feed file(s). If you use ftp.bronto.com, your file name should not match any pattern used by Data Loader for imports.
    To get started with FTP:
    1. Enter the location where the product data feed is stored in the FTP Server Address box.
      You need to specify the port number at the end of the server address, You can do this by following the server address with a colon and the port number. For example: ftps://ftp.bronto.com:4021.
    2. Enter the login credentials in the FTP Username box.
    3. Enter the login password in the FTP Password box.
    4. Enter the login password again in the Confirm Password box.
    5. Enter the product data feed file name, or partial file name, in the Filename Matching Pattern box.

      The Filename Matching Pattern is how you define the file name for your product data feed. When Bronto scans the FTP site it looks for files that match this file name format. This value is case sensitive. If you only want to provide a partial file name, use a * to represent the rest of the name.

    FTP Import Configuration
  7. Click
    • Save Changes to save your changes and stay on the page.
    • Save and Close to save your changes and return to the Products Overview page.

What to do next

For FTP and FTPS imports, Bronto checks for the existence of a file that matches the file name pattern. If one is found, the file is imported only when the data feed's time stamp is later than the time stamp of the last successful file import.
Note: The file time stamp is based on the FTP site’s time zone. If that time zone is different from the your site's time zone, the comparison might incorrectly believe the file is newer or older than the last successful import and process it accordingly. To avoid this issue, make sure the FTP time zone and your site's time zone is set to the same value.

For HTTP and HTTPS imports, Bronto checks for the last modified date in the response header. The import is completed only if that date and time is later than the date and time of the last successful import. If no last modified date appears in the response header, Bronto assumes the file is the most current and completes the import.