Scheduling an Import
- The import file should be in .CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas. format
- You can import product and customer data
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.
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.
|1.||On the Admin sidebar, tap System. Then under Data Transfer, choose Import/Export.|
|2.||In the upper-right corner, tap Add Scheduled Import. Then, do the following:|
|a.||Enter a Name for the scheduled import.|
|b.||Enter a brief Description that explains the purpose of the import, and how it is to be used.|
|c.||Set Entity Type to one of the following:|
|d.||Set Import Behavior to one of the following:|
Append Complex Data
Replace Existing Complex Data
Writes over existing complex for existing entities in the database.
Deletes existing entries in the database.
|e.||Set Start Time to the hour, minute, and second that the import is scheduled to begin.|
|f.||Set Frequency to one of the following:|
|3.||In the Field Separator field, enter the character that is used to separate fields in the import file. The default character is a comma.|
|4.||In the Multiple Value Separator field, enter the character that is used to separate multiple values within a field.|
|5.||To activate the scheduled import, set Status to “Enabled.”|
|1.||Set Server Type to one of the following:|
Imports the data from the same server where Magento is installed.
Imports the data from a remote server.
|2.||Enter the File Directory where the import file originates.|
- For Local Server, enter a relative path in the Magento installation. For example, var/import.
- For Remote FTP server, enter the full URLUniform Resource Locator: The unique address of a page on the internet. and path to the import folder on the remote server.
|3.||Enter the File Name to be imported.|
|4.||In the Images File Directory field, enter the path to the directory where product images are stored. On a local server, enter a relative path such as:
|1.||Set Failed Email Receiver to the store contact who is to receive notification if an error occurs during the import.|
|2.||Set Failed Email Sender to the store contact that appears as the sender of the notification.|
|3.||Set Failed Email Template to the template that is used for the notification.|
|4.||In the Send Failed Email Copy To field, enter the email address of anyone who is to receive a copy of the notification. Separate multiple email addresses with a comma.|
|5.||Set Failed Email Copy Method to one of the following:|
Sends a blind courtesy copy of the failed import notification. The name and address of the recipient is included in the original email distribution, but hidden from view.
Sends a copy of the failed import notification as a separate email.
|6.||When complete, tap Save.|
The new scheduled import job is added to the list on the Scheduled Import/Export page. From this page it can be run immediately for testing and edited. The import file is validated before the execution of each import job.
The name of the import. Helps you to distinguish it if many different scheduled imports are created.
(Optional) You can enter an additional description.
Defines the data to be imported. Options: Products / Customers.
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
Replace Existing Complex Data
The existing complex data for the already-existing entities will be replaced.
If entities which are being imported already exist in the database, they will be deleted from the database.
Set the start hour, minutes, and seconds of the import.
Define how often the import will be run. Options: Daily/Weekly/Monthly.
Define the system behavior in case errors are found during file validation. Options:
The file is not imported if any errors are found during validation. This is the default value.
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.
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)
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.
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.
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:
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.