< Back
Print

Source data set configuration

A source data set is the basic configuration of your snychronization efforts and can be used for several stations (=satellite systems). The advantage is that you only have to configure basic settings once and can use them multiple times.

Navigate to the SAWSConnector module. You can add a new source data set by clicking on the “station overview” button of a station:

station-overview

The station overview will open up. It displays the chosen source data set on the left handside, all existing jobs in the middle and the station on the right handside of the window:

station-overview2

In order to add a new source data set, click on “Add new source data set” on the upper left handside of the screen:

sourcedataset3

You will be taken to a mask asking you to enter the name of your new source data set. Enter a name and click on the “Save” button:

new-source-data-set

The dialogue will reload and extent by further settings and the additional tab “Mapping tables”:

new-source-data-set2

The mapping table already has a minimal configuration to create categories and products. The shopware keys must be mapped to the corresponding CS attribute, see below.

Configuration of the data source

Now the source data set can be further configured

sourcedataset7

This section lets you configure both workflows and attributes. Select all PIM View workflows you wish to be considered for the synchronization. Any workflow state you do not select will not be synchronized. Following that, choose the attributes or attribute sets (classes) you wish to synchronize to your Shopware shop. If the attribute set class has childs, then you have to select them too! You can use the dialogue chooser for attribute sets or add attributes manually in the field below. Manually added fields must be separated with the pipe sign “|”.

Store View Mapping

StoreViews in Shopware manage different language versions of a shop. The available language versions of products in the CONTENTSERV PIM need to be mapped to the relevant stores to ensure that language-specific data are synchronized to the correct StoreView. The SAWSConnector provides a simple mapping table:

storeviewshopware

Enter the Shopware shop name here as defined in your Shopware backend.  Navigate to System > Configuration > Basic settings > Shop settings > Shops or there is a job for synchronize Shopware setting to CS (see Shopware Jobs further down). This will help you for mapping the right shop here.

Workflow State Mapping

You can also define what CONTENTSERV PIM View workflow status should become what product status in Shopware. The source data set offers another simple mapping table for that purpose:

workflowmapping

Click on the “plus” button to add more lines to the table. Several CS status can be selected for Shopware online or offline.

Attribute mapping

Ultimately, every CONTENTSERV PIM field that contains data that your Magento shop needs must be mapped to its Magento counterpart. We created another mapping table for that. Click on the tab “mapping tables” on the upper left handside of the screen:

sourcedataset11

Standard attribute mapping

You can find the standard attribute mapping in the first section of the mapping table tab:

This section is added automatically to your source data set as soon as you set the desired application (in this case: Shopware). The section contains mandatory fields of Shopware – synchronization without the mapping of these attributes would fail. Additionally, we provide you with the attribute codes for related and similar products. We already provide you with the relevant Shopware attribute code. All you need to do is set the CONTENTSERV counterpart field.

To simplify the configuration, a full preconfigured data map can be imported:

At the top of the menu, select the preconfigured “Shopware datamap full configuration”.

Click on the import button to load the JSON file.

Full attribute mapping table for products an categories.

Notice: There are some more attributes e.g. special price attributes like priceGroupId, priceGroupActive for products or attribute1,  attribute2, for categories, which can also be exported if required.

Additional attribute mapping

Additionally, if you set attributes in the “Configuration of the data source” section on the first tab of the source data set, all selected attributes will be displayed here as well.

Your mapping table could look something like this when you are done:

attribute-mapping2

quelldatenset_1-3

Mapping of related and similar products

For the shopware key “related” and “similar” select the plugin SC::Loop head and click on the gearwheel button for the extended settings.

A new window opens and you can select the “Loop values for CS PIM references”.

Pleas click again on the gearwheel.

Select the attribute for the article number as selected in the standard attribute mapping  for the “number” and select the PdmarticleID as well. Save the settings and go back to the settings for the single values.

Select for the transformation of the source value the plugin SC::Complex – Export several values simultaneously and configure the plugin.

Enter for the output column number and PdmarticleID and select the plugin for the loop values.

Choose the article number in the selectbox and for the formatting of the particular loop value the option “cs formatted value”

Likewise, you configure the second output column for the PdmarticleID

 

Save the settings and see the result in the log file:

 

Help for the mapping table

Help for the default mapping table

help1

Help for mapping of additional attributes

help2

 

Was this article helpful?
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents