< Back
Print

SCMagento::Price from SC Price table

Summary

With the plugin “SCMagento::Price from SC Price table” you can send different prices to Magento.

Example

Magento standard price export

Magento Attribute code: “price”

Insert the attribute “CS::Prices” and select the function “SCMagento::Price from SC Price table” in the dropdown menu.

Click on the red marked button for the extended settings, a new window opens.
Here you set your value that should be transfered to your system.

Click on the button with the gear for the extended settings, a new window opens.
At the field “parameters” insert the pricetype that should be transfered to your system.

In our example the RP pricetype should be exported:

If you want to export a specific customer group price, you can specify the group as a second parameter, pipe separated.

If a valid price exists in the price table he will be exported at Magento. If it exists just more than one valid price then the first founded price will be exported.

Results export “price” to Magento:

This value will be exported from the pricetable for the standard price:

Value Description Example
price Magento price standard  1,234.56

Magento Advanced Pricing

Magento Attribute code: “special_price”

If you export the “special_price” than the “valid from” and the “valid to” date will be exported too:

Results export “special_price” to Magento:

view at Magento2:

Value Description Example
special_price Magento advanced pricing 1,234.56
special_from_date Valid from for special price  2016-10-03
special_to_date Valid to for special price  2018-11-01

Magento Attribute code: “tier_price”

Example for pricetype “EK” and customer group “Euro Sales”:

If you only want to export the pricetype “EK” for the customer group “Euro Sales”,  set in the field parameters the value “EK|Euro Sales”.

 

Notice: Only the prices corresponding to the “Channel” in the language mapping are exported. The export storeview according to this channel results also from the settings in the source data set.

Values from the pricetable that will be exported by the “tier_price”:

Value Description Example
_tier_price_website StoreView according the channel mapped mag1_store1_de
_tier_price_customer_group Customer Group Euro Sales
_tier_price_qty Amount from 10
_tier_price_price Price 9.99

Example settings:

Select “SC::Prices” as the attribute in the first coulumn of the mapping table and select the plugin “SCMagento::Price from SC Price table”

Click on the gearwheeel symbol (see red mark above) to open further settings for this plugin. You can now make further settings and/or set conditions that apply.

You can map your storeviews in the language mapping section of the source data set:

Result for the Magento export:

View from Magento 2

View from Magento 1

Magento Attribute code: “group_price” – only for Magento 1

Notice: If it’s mapped “group_price” in Magento 2 – it will be converted automatically to tier price!

Values from the pricetable that will be exported by the “group_price”:

Value Description Example
_group_price_website StoreView according the channel mapped default
_group_price_customer_group Customer Group all
_group_price_price Price 4.50

Results for “group_price” at Magento 1:

View from Magento 1:

Details/limitations

Group price (group_price) in Magento 2 will be converted to tier price  automatically.

“price” – export: If you set a second price (price-type|customer-group) as parameter then this price will be the fallback for the first:

“tier_price” and/or “group_price”- export 

If you want to export several tier/group – prices, the prices (price-type|price-group) can be added pipe separated.

If the price should apply to all groups, you can leave the price-group field empty: PP||EK|

Notice: Only price scope “website” can be set to a specific website.

Here you find the setting for Magento 2

Here you find the setting for Magento 1

Further information

Attention: You can find the instruction for the configuration of the pricetable at the section 1.1. Getting started -> Price and stock management.

Notice: In 2.5 Use Cases, you can find an example for the configuration of tier prices for different websites and different customer groups Use case: Advanced pricing export.

 

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