Skip to content

Export Companies from Magento V2

This task will export companies from Magento in an XML format. The results can be filtered if required. See below for an example output file.

GET /V1/company

Settings

Export Settings > Export Company Credit

Optional
Optionally enable this task setting to export the credit information related to each company.

Exporty Settings > Export Customer

Optional
Optionally export the related customer record to the record.

Filter Groups

Optional
The filtering to apply to the records. Only records which match the criteria specified will be exported.

Filters are arranged into groups. The individual filters within a group will be combined using the OR operator. Groups of filters are combined using the AND operator.

Filter Groups > Filter > Condition

Optional
The following types of filter are available:

  • Equal - Returns records where the field matches the specified value.
  • NotEqual - Returns records where the field does not match the specified value.
  • Like - Returns records where the field contains the specified value.
  • In - Returns records where the field matches one of the specified values.
  • NotIn - Returns records where the field does not match one of the specified values.
  • Null - Returns records where the field does not have a value.
  • NotNull - Returns records where the field has a value.
  • GreaterThan - Returns records where the field is greater than the specified value.
  • LessThan - Returns records where the field is less than the specified value.
  • GreaterThanOrEqual - Returns records where the field is greater than or equal to the specified value.
  • LessThanOrEqual - Returns records where the field is less than or equal to the specified value.

Filter Groups > Filter > Field

Optional
The name of the field the filter is to be based upon. The name should match the API field name, as seen in the output file.

Filter Groups > Filter > Value

Optional
The value the filter is to be based upon. This is not required when using the 'Null' or 'NotNull' condition type.

Page Size

Required
The number of records to include in each page of results. Defaults to 50. Increasing this value will increase the speed of the export, but will consume more memory.

Store View Code

Required
The magento store view code to perform the API calls against. Default value of 'default'.

Output File

Required
The name of the file to export the companies to.

Zynk Settings

See Common Task Settings.

Examples

A sample output file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfCompany xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Company>
    <external_id>ZYNK0001</external_id>
    <company_name>Zynk Software</company_name>
    <company_email>[email protected]</company_email>
    <street>
        <string>6 Charlotte Square</string>
    </street>
    <city>Newcastle</city>
    <postcode>NE1 4XF</postcode>
    <country_id>GB</country_id>
    <telephone>0191 820 1484</telephone>
    <customer_email>[email protected]</customer_email>
    <customer_group_code>Trade</customer_group_code>
    <credit>
        <currency_code>GBP</currency_code>
        <credit_limit>100</credit_limit>
        <exceed_limit>true</exceed_limit>
    </credit>
  </Company>
</ArrayOfCompany>