Is it possible to use custom XML file structure to import and export data?
All Import and Export modules provide the functionality of creating your own XML file via special XSL editor:
The XLS template configuration depends on the user requirements, however, below provided the example of the XLS template:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:g="http://base.google.com/ns/1.0">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:template match="channel">
<xsl:element name="items">
<xsl:for-each select="item">
<xsl:element name="item">
<xsl:element name="sku"><xsl:value-of select="sku"/></xsl:element>
<xsl:element name="type_id"><xsl:value-of select="type_id"/></xsl:element>
<xsl:element name="attribute_set_id"><xsl:value-of select="attribute_set_id"/></xsl:element>
<xsl:element name="catalog_product_attribute">
<xsl:element name="item">
<xsl:element name="price"><xsl:value-of select="price"/></xsl:element>
<xsl:element name="name"><xsl:value-of select="name"/></xsl:element>
<xsl:element name="description"><xsl:value-of select="description"/></xsl:element>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
Further listed several peculiarities that should be taken into account during the creation of the template:
1. The next piece of code represents the nesting level:
<xsl:element name="items">
<xsl:for-each select="item">
2. Fields from the Root entity can be added without setting the entity name:
But fields from other entities must be added in a separate "element" node:
Related Articles
Is it possible to import data to Magento with a custom file?
It is possible to use a custom import file, but there are a few peculiarities that must be taken into account. Import modules provide features for flexible configuration of the import file like setting custom entity and field names or ...
Is it possible to integrate a third-party system into Magento via the Import & Export solution?
With the Import & Export solution, it is possible to connect Magento to third-party systems; all its modules support automatic import and export of data to external sources via various methods: However, it is important to follow the ...
Is it possible to migrate data from one Magento instance to another with the Import & Export solution?
The Amasty Import and Export modules utilize the same functionality, so it is possible to duplicate the structure from import profiles to the export ones. This allows users to transfer data between Magento instances.
What features are included in each tariff plan of Import and Export?
LITE Features: - one-time manual import/export tasks; - 3 entities: orders, products, customers; - text, numeric, and date field modifiers; - export filters; - 2 file formats: XML, CSV; - 2 file sources: file upload, local directory. PRO Lite plan + ...
How to export refund requests to a CSV file?
At the moment, the Lite tariff plan of the extension provides the functionality to export the archived requests only. 1. Navigate to the Archived Requests grid (Orders → RMA Management → Archived Requests) and tick the needed orders. ...
Announcements
Already Done in Q1'23
New features and improvements Order Attributes v3.8.0 NEW now Order Attributes are placed on the PayPal Review Page; we added compatibility with Hyvä Theme for the module. You can find package for installing in composer suggest (Note: the compatibility
Roadmap | What to expect in Q1'23
New features and improvements Improved Layered Navigation generate SEO-friendly URLs for multi-select Category filter; better speed performance of the Apply filters button; improve Category list load time. Special Promotions Pro optimize data types in
Already Done in Q4'22
New Amasty services Make sure your site is well-performing with our E-commerce QA testing service. Let our specialists check various elements of your website and get the issues fixed. The service is available for any e-commerce platform (Magento, Shopify,
Roadmap | What to expect in Q4'22
New features and improvements Elastic Search better performance of synonyms; REST API support. Product Labels enhanced extension performance with a lot of products on the page. Blog Pro posts migration from one Magento instance to another; email notifications
Already done in Q3'22
New solutions Our new SaaS tool - Website SEO Health Check. Discover the most severe SEO mistakes which can damage your website. Available as part of Pro and Premium SEO Toolkit. New features and improvements Import and Export NEW we added the possibility