-
General
-
Releases
-
Owl Cloud Services
-
Base connector
-
- Beginner's Guide
- SAWSConnector settings
- Overview
- Station Overview
- Station configuration
- Datamaps
- Importing templates
- Format plugins explained
- Chaining format plugins
- Setting conditions
- Placeholders in format plugins
- Notes for field settings
- Jobs
- Testing exports and the development editor
- Job related tasks
- Job filter function
- How to create backups
- Running and Monitoring Jobs
- Start jobs automatically
- Import/Export & copy of data map rows
- Synchronizing references that are not contained in views
- Get the preconfigured "Source data set - Template"
- Configuring categories and products
- Fill Bundle and Variant tables from children
- Create View tree automatically
- Configuring the price & stock modules
- Configuring the price/stock value ranges
- Configuring volume discounts/scale prices
- How to export prices
- How to export stock values from certain storage units
- Use of Contentserv Credentials
- Rename export.zip Archives
- Connector & Station User Limitation
- Show all articles ( 18 ) Collapse Articles
-
- Importing data to our price tables
- SAWSConnector Usages
- Variant Articles
- Grouped products
- Virtual products
- Assignment of articles to complex articles
- SC::Channel Management
- Searching for SC::Prices / SC::Stocks
- Searching for SC::Channels
- Setup a transformation list for CSTypes
- Context-Sensitive Product Value Export
-
- Working with placeholder in conditions
- Improve usability of SC::Tables
- Placeholder for SC::Price, SC::Channel, SC::Stock
- REST Service API for SAWS Tables (Prices, Stock, Channels & Complex Articles)
- Dataflow import of SC::Tables
- Dataflow export of SC::Tables
- The datamap summary - Creating an automated documentation
- Export images as a ZIP file
- Image export with direct access to the CONTENTSERV platform
- Image export with no access to the CONTENTSERV platform
- Image export from a third party system
- How to configure CS Dashboard
- Setup a transformation list for CSTypes
- FAQ
- Transfer final result files to remote server by using FTP, sFTP, WebDAV or Azure Blob Storage
- Export Smart Document via Active Script and assign output to product
- Format Macros
- Controlling Connector Jobs via the REST API
- Basic Placeholders
- Job Parameters
- Input Types
- Sales Channel Maintenance via Excel Cross-Reference
- Show all articles ( 7 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for CS type reference
- Loop values for a CS table
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
GenericJSON / DynamicJSON Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
GenericXML Connector
-
- All Tutorials for creating XMLs
- SAWSConnector settings
- Station configuration
- Example station configuration
- Source data set configuration
- Example source data set mappings for the XML export
- Job configuration
- Simple XML Tags
- Images
- References
- SC::Prices
- SC::Stock
- SC::Channel
- Specials
- BMECat 1.2 Template
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
SimpleExcel Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Magento Connector
-
- Magento 2.x configuration
- Creating views
- Configuring categories and products
- Stations
- Add and configure a new source data set
- Assigning a Magento website
- Advanced pricing export
- Configurable products
- Bundle products
- country_of_manufacture
- max_sale_qty
- meta_description
- meta_keyword
- min_sale_qty
- msrp
- msrp_display_actual_price_type
- msrp_enabled
- news_from_date
- news_to_date
- special_from_date
- special_price
- special_to_date
- _links_crosssell_sku
- _links_related_sku
- _links_upsell_sku
- _media_image
- available_sort_by
- default_sort_by
- image
- include_in_menu
- is_active
- is_anchor
- is_in_stock
- meta_title
- name
- price
- small_image
- status
- tax_class_id
- thumbnail
- visibility
- weight
- description
- qty
- short_description
- sku
- Adding Jobs
- Show all articles ( 32 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Shopware 5 Connector
-
- Configuration Shopware
- Configuration PIM
- Shopware attribute setting
- Configuration SAWSConnector
- Station configuration
- Source data set configuration
- Configuring categories and products
- Price table configuration for Shopware
- Result in Shopware
- Subshops and the SAWSConnector Shopware
- ean
- Custom Fields (attribute)
- highlight
- purchaseSteps
- stockMin
- supplierNumber
- notification
- shippingFree
- length
- height
- width
- weight
- shippingTime
- metaKeywords
- added
- blog
- descriptionLong
- hidefilter
- hideTop
- inStock
- keywords
- lastStock
- maxPurchase
- metaDescription
- minPurchase
- noViewSelect
- pseudoSales
- related
- releaseDate
- showFilterGroups
- similar
- tax
- template
- cmsHeadline
- cmsText
- description
- metaTitle
- name
- number
- supplier
- Show all articles ( 35 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Shopware 6 Connector
-
- Tutorial Video
- First steps
- Import Shopware settings
- Export categories
- Export media files
- Export simple products
- Export multiple languages
- Export variant products
- Export product properties
- Export custom fields
- Export product cross-selling relationships
- Export prices
- Export stocks
- Export into any other Shopware field
- How to address multiple Shopware 6 websites
- How to address different Shopware 6 Sale-Channels from one Contentserv System
- Useful Links
- Export via RabbitMQ
- Sales Channel Maintenance via Excel Cross-Reference
- Show all articles ( 4 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
OXID Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Typo3 Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
WooCommerce Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Other connectors
Setting conditions
Please note: the following information is optimized for SAWSConnector versions 1.7.x and higher! Version 1.6 also contains the possibility to set conditions but not to the extend versions 1.7.x and higher do, so some of the following options may not be available to you if you work with a version below 1.7.x.
General information
Sometimes it may be neccessary to only synchronize products, objects or information if a certain condition is met. For example, many customers only want to synchronize products that contain an SKU. Other use cases may be that if attribute A is empty for a product, the contents of attribute B should be used. There are many other use cases. The following information offer an overview how conditions can be used in the connector.
Plugin premise
Conditions can be set for any plugin that is available. Conditions can be set by clicking on the gear wheel symbol of the line in your mapping table that you wish to set a condition for.
If a condition is set for a line in your mapping table, the gear wheel will appear bright green. If no condition is set (but other settings have been configured for a certain formatting option), the gear wheel will appear dark green:
Setting conditions
After the click on the gear wheel, the condition settings are available. Click on the “plus” icon to add a condition:
Condition actions
There are several actions available that are carried out once a condition is met. The action is what you need to define first. After clicking on the plus icon, the following actions will be available:
Action | Description |
Ignore entire data map row if… | The entire row of the data map you add this condition to will be ignored if your condition is met. Example: |
Ignore all target key entries of the data map if… | The target key you set for your data map row will be ignored even if there are multiple occurences of that key. Example: |
Skip product/object if… | The product or object will be completely ignored if this condition is met. None of the rows in your data map will be considered for a product or object that does not complay with the condition, no data for this product will be synchronized.
|
Use alternative formatting if… | If you set this option, the editor will reload and display the additional setting “alternative formatting” which in turn allows you to set another formatting option:
|
Return placeholder value if… | This option is designed for more complex conditions. You can define a placeholder in the placeholder map below (see red mark in the screenshot below) and define a condition that allows you to dynamically return that value. For further description, please read further down. |
Operators
Once you have selected an action, you need to select an operator:
The operator can be set to either AND or OR if you work with ONE condition only. If you work with several conditions, you need to select the operator that will give you the desired result:
If ALL conditions must be met in order to carry out the action you selected, the operator “AND” must be set. If ONE of the conditions must apply but not the others, set the “OR” operator.
Condition groups
The “group” option is where you set the actual condition. You can select between different conditions OR a condition group (the latter is recommended if you work with more complex conditions):
Condition | Description |
Condition group | This setting will make the editor reload and allow you to combine conditions groups (click Screenshot to enlarge!). |
Condition for values from channel | This setting will allow you to set conditions for each column from your SC::Channel tables, including non-standard attributes you defined in the SC::Channels settings: |
Condition for attribute classes | This option allows you to set conditions for certain attribute classes:
Enter the option “contain”/”does not contain” and for the “value” select the class you wish your condition to apply for (only a comma-separated list of class IDs will de displayed!). |
Condition for values from job (e.g. root node) | This option will allow you to set conditions relating to the job you run your data map with. You can select JobID, Name, ExternalKey of the Job, Root Node or Mode: |
Set condition for language map | This option will allow you to set conditions relating to the language settings in your data map:
You can find the language settings of your data map in the tab “Settings”, section “Language mapping”:
|
Set condition for placeholder values | For a more detailed description, please read further down (“Condition for placeholder values”) |
Condition for property of the source attribute | This option allows you to set a condition relating to properties of the attribute you mapped in the data map row for which you are about to set the condition: |
Set condition for unformatted source value | This option allows you to set a condition depending on the value a certain attribute has (does not have to be the source attribute of the data map row). Use the “plus” icon to select an attribute: |
Set condition for result value | This plugin lets you set conditions for the result value of the data map row you are using the condition for. “Result value” refers to the attribute you mapped and the formatting plugin you set. The result of this configuration will be used to compare it to your condition: |
Set condition for result value with PHP | This option allows you to set conditions using PHP code. Enter your code in the text area: |
“Check value” and “value”
The “check value” options allows you to define if you would like to apply your condition for a firmly set check value that you can define here or if you would like to use whatever value the data map row returns for your attribute.
Set “firmly set check value” if you need to enter your own value (e.g. for all operators that demand an entry, such as “does not contain”, “is less than”, “char length less than”…) and enter the value in the text field below. Example:
This example condition would apply for all values of the attribute ArticleNR that are less than 5 characters long.
Set “use result value” if no value must be set (operators “is empty” or “is not empty”) and/or if the result value of the condition can be used as comparison. . Example:
This example condition would apply for all empty values of the attribute ArticleNR.
Working with placeholders in conditions
You can use placeholders in conditions as well. You can use them to dynamically define a value your condition is compared to or you can define them as a return value if your condition is met/not met.
UseCase #1: Using placeholders as comparison value
If the value you need your condition to be compared to is dynamic, you can use placeholders to define that dynamic value.
Example configuration:
Use the option “firmly set check value” and enter your placeholder name in brackets in the corresponding “Value” text area. In the placeholder map below, define the placeholder. Please note that in order for this to work the placeholder name and the name of the placeholder in the “Value” text area MUST match (see red arrow above).
In example above, the placeholder is derived from the attribute “EAN code” which we formatted using the “format strings” plugin, for example because we need to skip the first 3 characters from the EAN code and compare that value to our condition.
UseCase #2: Using several placeholders as comparison values
Another way to use placeholders (espescially if you need to compare several values) is to use the condition group option “Set condition for placeholder values”
Example configuration (click to enlarge):
In this case the Connector will compare placeholder3 (=firmly set check value) with placeholder1 first and – if that value is empty – compare it with placeholder 2. Placeholder2 will not be used for comparison if placeholder1 contains a value. Again, placeholders must be dedined in the placeholder map and names must match!
Please note: the nomenclature {placeholder1|placeholder2} (that is, several placeholders separated by the pipe sign) always means an “OR” connection. The placeholder set first will be used if it has a value, if not, the placeholder following the pipe will be used next. The order in which you indicate placeholders within brackets defines the order in which they will be used for comparison (if used within a condition) or as a return value (if used with the “Return placeholder” action of conditions).
UseCase#3: Returning placeholder values as a result
Using conditions and placeholders also allows you to return a placeholder if a certain condition applies.
Example configuration:
Set the action “Return placeholder value if…” and apply your condition. Define placeholders and their formatting options and in the text area “return of a placeholder value as defined in the placeholder map”, define the return value using the placeholders.
Our example above will return the placeholder values as defined if the text attribute teaser is empty. Placeholder1 will be returned separated by the static ” abc ” and placeholder3 IF placeholder1 has a value. If placeholder1 has NO value, placeholder2 will be returned.
Please note: the nomenclature {placeholder1|placeholder2} (that is, several placeholders separated by the pipe sign) always means an “OR” connection. The placeholder set first will be used if it has a value, if not, the placeholder following the pipe will be used next. The order in which you indicate placeholders within brackets defines the order in which they will be used for comparison (if used within a condition) or as a return value (if used with the “Return placeholder” action of conditions).