Magento for B2B Commerce, 2.2.x

Magento 2.2.x Notice: As outlined by the Magento Software Lifecycle Policy, Magento 2.2.x has reached the End-of-Support and will no longer receive quality fixes or documentation updates. To maintain your site's performance, security, and PCIPayment Card Industry: Refers to debit and credit cards and their associated businesses. compliance, upgrade to the latest version of Magento.

The online Magento 2.2.x User Guide is scheduled for removal, but will remain available in PDF for Open Source, Commerce, and Commerce for B2B.

Scheduling an Import

The Scheduled Import process is similar to the manual Import process, with respect to the available import file format and types of import entities:

The advantage of using Scheduled Import is that you can import a data file multiple times automatically, after specifying the import parameters, and schedule only once.

Add Scheduled Import

The details of each import operation are not written to a log, but in case of failure you will receive an Import Failed email, with a description of the error. The result of the last scheduled import job is shown in the Last Outcome column on the Scheduled Import/Export page.

After each import operation, a copy of the import file is placed in the var/log/import_export directory on the server where Magento is deployed. The timestamp, the marker of the imported entity (products or customers), and the type of the operation (in this case, import) are added to the import file name.

After each scheduled import job, a reindex operation is performed automatically. On the frontend, changes in the descriptions and other text information are reflected after the updated data goes to the database, and the changes in prices are reflected only after the reindex operation.

  • Field Descriptions



    Import Settings


    The name of the import. Helps you to distinguish it if many different scheduled imports are created.


    (Optional) You can enter an additional description.

    Entity Type

    Defines the data to be imported. Options: Products / Customers.

    Import Behavior

    Defines how complex data is handled if entities, which are being imported, already exist in the database. Complex data for products include categories, websites, custom options, tier prices, related products, up-sells, cross-sells, and associated products data. Complex data for customers include addresses.Options:

    Append Complex Data

    The new complex data will be added to the existing complex data for the already existing entries in the database. This is the default value.

    Replace Existing Complex Data

    The existing complex data for the already-existing entities will be replaced.

    Delete Entities

    If entities which are being imported already exist in the database, they will be deleted from the database.

    Start Time

    Set the start hour, minutes, and seconds of the import.


    Define how often the import will be run. Options: Daily/Weekly/Monthly.

    On Error

    Define the system behavior in case errors are found during file validation. Options:

    Stop Import

    The file is not imported if any errors are found during validation. This is the default value.

    Continue Processing

    In case errors are found during validation, but importing is possible, the file is imported.


    The import is enabled by default. You can suspend it by setting the Status to Disabled.

    Field Separator

    Determines the character that is used to separate fields. Default value: , (comma)

    Multiple Value Separator

    Determines the character that is used to separate multiple values within a field. Default value: , (comma)

    Import File Information

    Server Type

    You can import from a file located on the same server where Magento is deployed (select Local Server) or from the remote FTP server (select Remote FTP). If you select Remote FTP, additional options for credentials and file transfer settings appear.

    File Directory

    Specify the directory where the import file is located. If Server Type is set to Local Server, specify the path relative to the Magento installation directory. For example, var/import.

    File Name

    Specify the name of the import file.

    Images File Directory

    Enter the path to the directory where product images are stored. For a local server, enter a relative path. For example: var/import

    Import Failed Emails

    Failed Email Receiver

    Specify the email address to which an email notification (failed import email) is sent if the import fails.

    Failed Email Sender

    Specify the email address that is used as the sender for the import failed email.

    Failed Email Template

    Select a template for the import failed email. By default, only the Import Failed (Default Template from Locale option is available. Custom templates can be created under System > Transactional Emails.

    Send Failed Email Copy To

    The email address to which a copy of import failed email is sent.

    Send Failed Email Copy Method

    Select the copy sending method for the import failed email.