Skip to content

Import Products to Magento

This task imports product data to Magento, creating products which don't exist and updating those that already exist. The product inventory information is also updated on Magento if provided in the product data.

The input file should be in Magento XML format. If a product with matching sku is found in Magento, the existing product will be updated in Magento, otherwise a new product will be created.

Settings

Connection

Required
The Magento connection to use. See the Connecting to Magento v1 article if you require more information on how to create/manage connections.

Fail File

Required
An absolute or relative file path on the local computer or network to save Product records that fail to import to Magento.

See the Zynk Objects article if you require more information on how the Zynk Object file value works.

Defaulted to magento_import_products_fail.xml in the current working directory.

Input File

Required
The absolute or relative file path to the XML file containing the Magento Products to import.
This can also be inline XML, e.g. by generating the data using a razor script or by providing a URI to a script generating the data and specifying 'Read contents of file'.

See the Zynk Objects article if you require more information on how the Zynk Object file value works.

Defaulted to Output from the previous task

Success File

Required
An absolute or relative file path on the local computer or network to save Product records that are successfully imported to Magento.

See the Zynk Objects article if you require more information on how the Zynk Object file value works.

Defaulted to magento_import_products_success.xml in the current working directory.

Prevent Reprocessing

Required
Set to true if you would only like to import each Product to Magento the first time it is processed by Zynk.

This setting relies on the <external_id> element being provided in the Product XML data.

Defaulted to False.

Import Categories - Case Sensitive Category

Required
Set to true if you would like to perform a case sensitive match when importing Categories.

Upload Categories - Enabled must be set to true for the Import Categories functionality to be enabled.

Defaulted to False.

Import Categories - Category Field Name

Required
The Name of the Field(s) in the Product data that contain the Category structures to import.

Upload Categories - Enabled must be set to true for the Import Categories functionality to be enabled.

Defaulted to category_structure.

<Fields>
  <Field Name="category_structure" Value="Category Name" />
</Fields>

Import Categories - Category Field Separator

Required
The separator character used between Categories to infer the Category nesting.

Upload Categories - Enabled must be set to true for the Import Categories functionality to be enabled.

Defaulted to ;.

<Fields>
  <Field Name="category_structure" Value="Category Top Level;Category Sub Level" />
</Fields>

Import Categories - Create Categories - Enabled

Required
Set to true if you would like to automatically create Categories on Magento that are provided in the Product data but do not exist yet on Magento.

Upload Categories - Enabled must be set to true for the Import Categories functionality to be enabled.

Defaulted to False.

Import Categories - Create Categories - New Category Available Sort By Value

Required
The <available_sort_by> value to use for automatically created Categories.

Upload Categories - Enabled and Upload Categories - Create Categories - Enabled must be set to true for the Create Categories functionality to be enabled.

Defaulted to position, name, sku, price.

Import Categories - Create Categories - New Category Default Sort By Value

Required
The <default_sort_by> value to use for automatically created Categories.

Upload Categories - Enabled and Upload Categories - Create Categories - Enabled must be set to true for the Create Categories functionality to be enabled.

Defaulted to price.

Import Categories - Create Categories - Include In Menu Value

Required
The <include_in_menu> value to use for automatically created Categories.

Upload Categories - Enabled and Upload Categories - Create Categories - Enabled must be set to true for the Create Categories functionality to be enabled.

Defaulted to True.

Import Categories - Create Categories - Is Active Value

Required
The <is_active> value to use for automatically created Categories.

Upload Categories - Enabled and Upload Categories - Create Categories - Enabled must be set to true for the Create Categories functionality to be enabled.

Defaulted to True.

Import Categories - Enabled

Required
Set to true if you would like to lookup Categories on Magento based on Field(s) that are provided in the Product data.

Defaulted to True.

Zynk Settings

See Common Task Settings.

Examples

Sample input file:

<?xml version="1.0"?>
<ArrayOfProduct>
  <Product>
    <type>simple</type>
    <status>1</status>
    <options_container>container2</options_container>
    <category_ids />
    <description>test</description>
    <visibility>4</visibility>
    <short_description>test</short_description>
    <required_options>0</required_options>
    <websites>
      <string>1</string>
    </websites>
    <tax_class_id>2</tax_class_id>
    <type_id>simple</type_id>
    <set>4</set>
    <categories />
    <sku>PROD001</sku>
    <name>test</name>
    <weight>2.0000</weight>
    <price>10.0000</price>
    <group_price />
  </Product>
</ArrayOfProduct>