Data Director: Export BMEcat
reviewed
last reviewed: 30.09.2021
Export/Import
DetailsData Director: Export BMEcat
Export/Import
Zusammenfassung
Readme
BMEcat Export & Marketplace Add-on for Pimcore Data Director
This bundle adds result callback function templates to Data Director's attribute mapping to create BMEcat export feeds.
As it uses Data Director's export capabilities, your BMEcat exports profit by:
- everything is configurable in Pimcore backend user interface - no creation of PHP files or anything similar necessary
- access any data which is connected to exported products, for example you can easily access assigned categories, price information, manufacturers, product features, images etc.
- full flexibility in setting up a transformation pipeline to change values to the desired format (e.g. some BMEcat-processing applications have restrictions on length of some fields)
- supported BMEcat versions: 1.2, 2005.1
- automatically execute exports whenever a product object gets saved whose data gets exported to:
- prepare export once the data changes, so that the data does not have to be generated in the moment when the export is requested -> very fast exports because the export document is already available in the moment of request -> you will have an always up-to-date BMEcat export
- upload exports automatically to a target system to always have up-to-date data there
- automatically send data the other APIs
- intelligent checks whether anything changed since the last export. If nothing changed, export document gets delivered from cache
- access exports via URL, for example to pull BMEcat export into an external system instead of pushing it
Importing ETIM classes / groups / features to Pimcore classification store
Advantages of classification systems like ETIM
Using classification systems like ETIM has several advantages:
-
You do not have to reinvent which technical attributes products of certain categories have.
-
You simplify the process of providing your product data to resellsers and sales partners by exporting a product's category and technical data in the standardized ETIM format.
For example if your sales partner buys products from multiple suppliers beside you, every manufacturer might invent its own system of categories and technical data attributes. The reseller how faces the challenge of putting all this data from the suppliers / manufacturers to its own category / attribute system. For example one supplier uses a category
Clothes > Shoes > For him
and another one usesClothes > Men > Shoes > Sneakers
. Now the supplier has to map those supplier categories to its own category system. ETIM simplifies this because it has standardized classes. As soon as a reseller has mapped the ETIM classes to his own category system, he can from now automatically assign supplier products to his own categories - so this mapping effort has only to be done once compared to once per supplier when not using a classification standard like ETIM.The same problems arise for technical data. One supplier has t-shirt sizes
M, L, XL, 2XL
while another one hasM, L, XL, XXL
and a third one hasMedium, Large, Extra Large, Extra-Extra large
. When a reseller wants to provide a size filter on its website he has to map these different sizes to an own size system. But when the suppliers provide technical data as ETIM features, the whole mapping gets a lot easier because it only needs to be done once for all suppliers which support ETIM. -
You can still keep your categories and technical data in other fields than a classification store because the Data Director bundle can be used to automatically copy the values from your fields to the classification store fields as soon as a product gets saved.
Import ETIM groups and attributes
By calling http://your-pimcore.org/classification/etim.xml you can access all ETIM groups as an XML file. Internally the underlying code accesses the ETIM API and converts it to an XML feed:
<?xml version="1.0"?>
<etim release="ETIM-8.0">
<group id="EC000001">
<category id="EG000017">
<name language="de">Niederspannungsschaltgeräte</name>
<name language="en">Low-voltage industrial components</name>
...
</category>
<name language="de">Sammelschienenklemme</name>
<name language="en">Busbar terminal</name>
...
<synonyms>
<synonym language="de">Abzweigklemme</synonym>
<synonym language="de">Anschlussklemme</synonym>
<synonym language="en">Busbar terminal</synonym>
<synonym language="en">Cable clamp</synonym>
...
</synonyms>
<attributes>
<attribute id="EF007220">
<name language="de">Sammelschienendicke</name>
<name language="en">Busbar thickness</name>
<allowed_values>
<value id="EU570448" abbreviation="mm">
<name language="de">Millimeter</name>
<name language="en">Millimetre</name>
...
</value>
<value id="EU000051" abbreviation="inch">
<name language="de">Inch</name>
<name language="en">Inch</name>
...
</value>
</allowed_values>
</attribute>
<attribute id="EF000073">
<name language="de">Geeignet für</name>
<name language="en">Suitable for</name>
...
<allowed_values>
<value id="EV009241">
<name language="de">Flachschiene</name>
<name language="en">Flat rail</name>
...
</value>
<value id="EV009472">
<name language="de">T-Schiene</name>
<name language="en">T-rail</name>
...
</value>
...
</allowed_values>
</attribute>
...
</attributes>
</group>
...
</etim>
This can be used for creating ETIM groups and features and Pimcore data objects via Data Director.
This URL supports parameters:
release
, e.g. http://your-pimcore.org/classification/etim.xml?release=ETIM-9.0 to retrieve all ETIM 9.0 data. By default ETIM-8.0 data gets loaded.filters
: e.g. http://your-pimcore.org/classification/etim.xml?filters[]=EC004082 to retrieve only data for a certain group. It is a fulltext filter, so you will get a certain group even if the filter term only matches for a certain attribute.
Create ETIM classifiation store
This bundle provides a command to automatically create and update Pimcore classification stores based on the ETIM classification system. This import command can be triggered with
bin/console classification-store-import:etim
It will automatically create classification stores based on ETIM releases, group collections based on ETIM groups, groups based on ETIM classes and key definitions / fields based on ETIM features.
You can also filter the classes and fields to be created:
bin/console classification-store-import:etim EC004082 shoe
This will only import classes and fields which have anywhere in their names, descriptions etc. the term "EC004082" (ETIM class "shelf") or "shoe". It is better to filter by ETIM IDs because with words like "shoe" you will also import classes like "cable shoes".
All matching fields get updated with the current data from the ETIM API when you rerun the command again.
If you want to clear the corresponding classification stores before importing again, you can use the --rm
flag:
bin/console classification-store-import:etim EC004082
This will search for the class "EC004082", truncate matching classification stores for all found ETIM releases and afterwards import the class and its fields.
After executing the classification-store-import:etim
you will have a classification store with all the available fields, correct field types, available options, quantity value units (incl. conversion factors) and translations:
And in object editing you can enter the data:
Import Ebay categories
Via http://your-pimcore.org/classification/ebay.xml the Ebay categories get fetched from the Ebay taxonomy API and provided as XML. This can be used to import Ebay categories as data objects into Pimcore.
Installation
This bundle is an add-on bundle for Pimcore Data Director. You can buy this BMEcat add-on bundle in the Blackbit Shop or write an email to info@blackbit.de.
After you have installed Pimcore Data Director you can proceed with the BMEcat bundle installation.
Please contact us to get access to the bundle's Bitbucket repository or you get the plugin code as a zip file.
When we permit your account to access our repository, please add the repository to the composer.json
in your Pimcore root folder (see Composer manual about repositories):
"repositories": [
{
"type": "vcs",
"url": "https://bitbucket.org/blackbitwerbung/pimcore-plugins-data-director-bmecat"
}
],
Alternatively if you received the plugin code as zip file, please upload the zip file to your server (e.g. to the Pimcore root folder) and add the following to your composer.json
:
"repositories": [
{
"type": "artifact",
"url": "path/to/directory/with/zip-file/"
}
]
Then you should be able to execute composer require blackbit/data-director-bmecat
(or composer update blackbit/data-director-bmecat --with-dependencies
for updates if you already have this bundle installed) from CLI.
You can always access the latest version by executing composer update blackbit/data-director-bmecat
on CLI.
Setup export
Select BMEcat Export
from the list of templates for the Result Callback function
in data director's attribute mapping.
Then the fields which the BMEcat standard defines will appear as virtual fields in attribute mapping. To those fields you can map your data object class fields via drag & drop (and additional callback functions if necessary). Afterwards you can access the export either via manual export or via URL (via Data Director's REST API).