< Back
Print

FAQ

FAQs related to all SAWSConnectors

How do I export prices from my SC Price table?

Please read our wiki site on how to configure SC Price tables first!
In your attribute mapping, add a new line and type “SC”. The autofill will show you the “SC:PriceTable” attribute:

 

SCPrices1

 

Add the key of your target system. In the above screenshot, we used the Excelconnector as an example.

 

As the format, select “SCExcel::Unformatted Price from SCPrice table” if you are working with the Excel Connector. You should find a similiar version for other connectors. For example, the format plugin for Magento is called “SC:Magento::Unformatted price from SCPrice table”. If your connector version does not offer its own format plugin, choose the “formatted values” plugin.

 

Set the checkbox for “DeliverIfEmptiy” to active!

 

Now add the desired price list and currency to the params column. The following nomencalture applies (underlined= mandatory):

 

{external key of price list};{external key of currency}|{external key of fallback price}{external key of fallback currency}

 

 

 

How can I find the external keys of my price type and my currency?

 

Check your value range settings for SC Price tables! For currencies:

 

SCPrices3

 

 

For price types:

SCPrices4

 

 

How do I export stock values from my SC Stock table?

Please read our wiki site on how to configure SC stock tables first!
In your attribute mapping, add a new line and type “SC”. The autofill will show you the “SC:Stocktable” attribute:

SCPrices5

Add the key of your target system. In the above screenshot, we used the Excelconnector as an example.

As the format, select “Stock values from SC Stock table”.

Set the checkbox for “DeliverIfEmptiy” to active!

Now add the desired price list and currency to the params column. The following nomencalture applies (underlined= mandatory):

{stock ID}|{ID of fallback stock}

How can I find the ID of my stock?

Check the PIM objects that your stock tables reference to:

SCPrices6

 

The job will not start

Make sure the application URLs in the station are correct. Make sure the settings of the source data set are correct – have all parameters been set? Are they correct?
 
station22

The plugin SAWSConnector is not visible

1.) Make sure the module is activated in the settings.

Go to 1.1. Activations -> SAWSConnector Activation

2.) Acitvate the CS plugin cache temporarily.

The stock management module is not visible

1.) Make sure the module is activated in the settings.

Go to 1.1. Activations -> SAWSConnector Activation -> SAWS Stock Management Module Activation

2.) Acitvate the CS plugin cache temporarily.

The price module is not visible

1.) Make sure the module is activated in the settings.

Go to 1.1. Activations -> SAWSConnector Activation -> SAWS Price Module Activation

2.) Acitvate the CS plugin cache temporarily.

FAQs related to the SAWSConnector for Magento

Where can I find Magento Website codes?

Log in to the Magento backend. You can find the Website codes in System ⇒ Manage Stores:
 
indexphp2

The plugin SAWSMagentoRestService is not visible

Make sure the module is activated in the settings. Acitvate the CS plugin cache temporarily.
 
plugin

Error messages in the CS Magento log

You can find the error log on the Magento server in
 

 «magento –-installation»/var/logs/sawsconnector/<YYYYY>/<YYYY-MM>/<YYYY-MM-DD>.log 

 

Error message
Meaning
Parent Category is not found, add parent first
Localise the category using the reference ID and synchronize the paretn category before. Or you chose a sub tree as the root node that does not yet have a parent node in Magento.
Invalid value for Attribute Set column (set does not exists?)
There is a missing or misconfigured attribute set. Please see the chapter on starting and monitoring jobs to help with this problem.
Errors occured during import (SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘24090-2272-1-15538’ for key ‘PRIMARY’, query was: INSERT INTO `catalog_product_index_eav_tmp` (`entity_id`,`attribute_id`,`store_id`,`value`) VALUES (?, ?, ?, ?),..
This message means that an external key has been found twice within the system. External keys must always be unique.

The job will no start

Make sure the application URLs in the station are correct. Make sure the settings of the source data set are correct – have all parameters been set? Are they correct?
 
station22

How to create Log Entries in field plugin

– use addError Method
 

 try{
   //To something
 }catch(Exception $e){
      $this->addError(SCLogDetail::SCLOGDETAIL_STATE_ERROR, $e->getMessage()."-FieldID:".$this->getID()."-A error occoured");
    }

Which fieldnames can I not use as a magento attribute key

entity_id
label
csid
csclass
SortOrder
ParentID
PdmarticleID

Required attribute ‘tax_class_id’ has an empty value

If you get the message “Required attribute ‘tax_class_id’ has an empty value” during your import, you have to configure the tax_class attribute in your rest service or easily set the default tax class in the Magento/Configurations/AvS Fast and Simple Import/Product Import.
 
default_tax_class
 

How to export custom values for each website

– create a new FieldPlugin and use
 

$this->addWebsiteValue($websiteCode, $strKey, $strValue);

How to export grouped products to Magento

A grouped product is a composite of several single “Simple Products”. You can configure it as shown here:

Please navigate to the CS-PIM backend and select the “grouped product” – Magento type in the tab “Application”.
 
grouped-product
 
Go to the CS-backend and navigate to the SAWS Connector. Add the corresponding attribute for the “Grouped Product” in Magento, the name is
 

_associated_sku

 
like shown below.
 
addgroupedattribute
 
You find the attributes name/id in the CS-PIM here:
 
cs-pim-groupedproduct
 
Now please click the mapping button and choose the correct attribute (for example 4095) for the Grouped Products.
 
addattribute
 

A new window pops up and with the ID of the attribute it is easy to find the attribute as shown:
 
referenz
 
There are some default settings for “Grouped Products”:
If there is no
 

_associated_position

 
set, it will be set to the sort order like in the PIM.
If there is no
 

_associated_default_qty

 
set, it will be set to 1.
 
Now you can also import Grouped Products. Please do not forget that all the single “Simple Products” of the “Grouped Product” have to be visible Magento Products.
 

Get no Values Range Values aduring export!

If you get no values in export array for magento, make sure, the field is set to “unformatted”. Since the export uses the external key it must be loaded by ID. And the ID is defined in the unformatted value.

 
faq_valuerangevalues
 

Wrong Export (value):
[cs_color] => Array
  (
    [0] => 
  )
  
Correct Export (unformatted value):
Wrong Export:
[cs_color] => Array
  (
    [0] => green
  )

 

How to export configurable products to Magento?

A configureable product in Magento is a product which has a variation in one or more attributes. For example a T-Shirt which comes in several different sizes and colors. In Magento all variations of the T-Shirts are simple products and has its own SKU.

The basic step for creating a configurable product is to create the configurable attribute. Now we want to create two configurable attributes for our T-Shirt.

Navigate to the PIM attribute definition site.
 
createattrc
 
Create the new attribute and set the options like shown:
 
attribute-conf
 
Important: The attribute type must be a simple selection field!

Scroll to the bottom an set the attribute type in Magento:
 
global-attribute-3
 
Create a second or more attributes, if necessary similar.

In Magento there have to be also these attributes. The very important properties are
 

"Geltungsbereich" -> Global
"Katalog Eingabe-Typ für den Shopbetreiber" -> Drop Down
"Für das Anlegen von konfigurierbaren Artikeln verwenden" -> Ja

 
You can export the attributes to Magenta or create them by yourself.
 

magento-confatt
 
Back in the PIM, assign the new attributes to the products and create simple products.
 
simple
 
Set the configurable attributes as necessary and save the product.
 
simple-1
 
Now create the view of your new products and check the correct workflow state. Be sure the right websites are selected in the category folder.
 
view-websites
 
Before you export the products to Magento, the new attribute of your products have to be mapped. Navigate to the SAWSConnector Rest Service and find the attribute sets. Click the “+” and add new attribute set like shown.
 
include-att
 
Save the setting an check the values in the reloaded list.
 
magento-confatt-check
 
Now it’s possible to export also the configureable products.
 

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