Scheduling an Export
Scheduled Export is similar to manual Export, with respect to the available export file format and types of entities that can be exported:
- You can export to .CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas. format
- You can export product and customer data
The advantage of using Scheduled Export is that you can export data multiple times automatically, after specifying the export parameters, and schedule only once
The details of each export are not written to a log, but in case of failure you will receive an Export Failed email, which contains the error description. The result of the last export job appears in the Last Outcome column on the Scheduled Import/Export page.
After each export, the export file is placed in the user-defined location, and a copy of the file is placed in the
var/log/import_exportdirectory on the server where Magento is deployed. The timestamp and the marker of the exported entity (products or customers) and type of the operation (in this case, export) are added to the export file name.
|1.||On the Admin sidebar, tap System. Then under Data Transfer, choose Scheduled Import/Export.|
|2.||In the upper-right corner, tap Add Scheduled Export. Then, do the following:|
|a.||Enter a Name for the scheduled export.|
|b.||Enter a brief Description that explains the purpose of the export, and how it is to be used.|
|c.||Set Entity Type to one of the following:|
The Entity Attributes section at the bottom of the page is updated to reflect the selected Entity Type.
|d.||Set Start Time to the hour, minute, and second that the export is scheduled to begin.|
|e.||Set Frequency to one of the following:|
|f.||To activate the scheduled export, set Status to “Enabled.”|
|g.||Accept “CSV” as the default File Format.|
|1.||Set Server Type to one of the following:|
To save the export file on the same server where Magento is installed.
To save the export file on a remote server.
|2.||Enter the File Directory where the export file is to be saved as follow:.|
- For Local Server, enter a relative path within the Magento installation. For example, var/export.
- For Remote FTP server, enter the full URLUniform Resource Locator: The unique address of a page on the internet. and path to the target folder on the destination server.
|1.||Set Failed Email Receiver to the store contact who is to receive notification if an error occurs during the export.|
|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. The name and address of the recipient is included in the original email distribution, but is hidden from view.
Sends the copy as a separate email.
|1.||In the Entity Attributes section, choose the attributes that you want to include in the export data.|
- To filter export data by attributes value, enter the attributeA characteristic or property of a product; anything that describes a product. Examples of product attributes include color, size, weight, and price. value in the Filter column.
- To exclude products or customers with certain attribute values, enter the values of the attributes that you want to exclude, and select the checkbox in the Skip column.
|2.||When complete, tap Save.|
The new scheduled export 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 name of the export. Helps you to distinguish it if many different scheduled exports are created.
(Optional) A description of the scheduled export.
Identifies the data to be exported. After the selection is made, the Entity Attributes appear below. Options include: Products /Customers.
Set the start hour, minutes, and seconds of the export.
Define how often the export job will be executed. Options include:Daily/Weekly/Monthly.
A new scheduled export is enabled by default. You can suspend it by setting Status to Disabled. Options include: Enabled/Disabled.
Select the format of the export file. Currently only the .CSV option is available.
Determines the location of the export file. Options include:
Places the export file on the same server where Magento is deployed.
Places the export file on a remote server. Additional options for credentials and file transfer settings appear.
Specify the directory where the export file is placed. In case Server Type is set to Local Server, specify the relative to Magento installation path. For example, var/export.
Failed Email Receiver
Specify the email address to which an email notification (export failed email) is sent if the export fails.
Failed Email Sender
Specify the email address that is used as export failed email sender.
Failed Email Template
Select a template for the failed export email. By default, only the Export Failed (Default Template from Locale) option is available.
Send Failed Email Copy To
The email address to which a copy of the failed export email is sent.
Send Failed Email Copy Method
Specify the copy sending method for the export failed email.