Exporting Products from EKM
This task will export products from EKM, and output them to an XML file.
Settings
Connection
Required
The EKM connection to use. See the Connecting to EKM article if you require more information on how to create/manage connections.
Export Settings > Date Modified
Required
When the task is set to export modified records, this is the date modified records will be exported from. The value for this setting will update automatically when the task is ran.
Export Settings > Export Modified or All Records
Required
Select which records should be included in the export. The following options are available:
- Modified - Only records created or updated since the date shown in the Date Modified setting will be exported.
- All - All records will be exported.
Page Size
Required
The number of records to export on each page of data requested from EKM. The maximum value is 20.
Query
Optional
Specify a custom filter to apply to the export. Only records meeting the criteria specified will be exported. The query must be specified using OData filter syntax. Please note that EKM only supports a subset of the OData filter syntax.
For example, you can use product_code eq 'TEST001'
to export the product with code 'TEST001'.
Record IDs
Optional
Specify a list of comma separated record IDs to export specific records from EKM. Using this setting will override the Query and Export Settings.
Output File
Required
The name of the file to output the exported data to.
Zynk Settings
Samples
Sample output file:
<?xml version="1.0" encoding="utf-8"?>
<Products xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Product>
<Id>1</Id>
<Name>Pen</Name>
<CategoryId>0</CategoryId>
<Description>Blue pen</Description>
<ShortDescription />
<NumberInStock>1</NumberInStock>
<Price>2.5</Price>
<Rrp>0</Rrp>
<ProductCode>PEN001</ProductCode>
<ChargeDelivery>true</ChargeDelivery>
<SpecialOffer>false</SpecialOffer>
<Brand />
<Condition>NotApplicable</Condition>
<Gtin />
<Mpn />
<ProductWeight>0</ProductWeight>
<CanBeAddedToCart>true</CanBeAddedToCart>
<TaxApplicable>true</TaxApplicable>
<TaxRateId>1</TaxRateId>
<Live>true</Live>
<OrderNote />
<RedirectUrl />
<LastModified>2019-10-31T12:24:00Z</LastModified>
<MetaDescription>[EKM-AUTOGENERATED]Blue</MetaDescription>
<MetaKeywords>[EKM-AUTOGENERATED]blue,</MetaKeywords>
<MetaTitle />
<TotalProductStock>1</TotalProductStock>
<ParentProductId>0</ParentProductId>
<Options />
<Variants />
<Categories>
<Category>
<CategoryId>0</CategoryId>
<IsCategoryManaged>false</IsCategoryManaged>
</Category>
</Categories>
<AttributeItems />
<OrderLocation>99999</OrderLocation>
<SeoFriendlyUrl>pen-1-p.asp</SeoFriendlyUrl>
</Product>
</Products>