This is in reference to Magento2 trying to pull two price levels into a single Item Export Saved search. The use case is that there are 3 price levels (Base, Retail, Sale) and the Customer wanted to use price levels instead of using a Custom Field to populate the other price levels (as we only support a single price level in the saved search).
This is a starting point if you want to utilize two price levels in the Saved Search to affect two prices in the 3rd party system. You will need to adjust the formula for your specific use case.
*********************************************************************************************************************
Response from NetSuite outlining this specific customer request:
- Customer's Items are sold online using three price levels:
- RFP
- Bottle Price
- Multi-case Price
- The company is moving to a new E-Commerce platform with Magento.
- In the integration, Celigo will be pulling information on prices from NetSuite to Magento. The main concern is that Celigo can only pass one price level at a time.
- Although Celigo can only get one price level, it supports custom fields.
- The 'Mulitcase Price Website' and 'Website RFP' fields are populated via script with values for Multi-case Price and RFP price levels, respectively.
- Any updates on Multi-case price and RFP price levels should also be reflected real-time on the custom fields.
- This case was particularly raised to create a saved search that would return each item with each price level showing as a single column.
The requested saved search can be achieved by following these steps:
- Navigate to Lists > Search > Saved Searches > New
- Select Item.
- Add Criteria, if any.
- Under the Results tab, click 'Remove All', and add the following fields:
Field
Summary Type Formula When Ordered By Field Custom Label Summary Label Name Group Formula (Currency) Maximum case when {pricing.currency} = 'AUD' and {pricing.pricelevel} = 'RRP' then {pricing.unitprice} end RFP RFP Formula (Currency) Maximum case when {pricing.currency} = 'AUD' and {pricing.pricelevel} = 'Bottle Price' then {pricing.unitprice} end Bottle Price Bottle Price Formula (Currency) Maximum case when {pricing.currency} = 'AUD' and {pricing.pricelevel} = 'Multi Case Price' then {pricing.unitprice} end Multi Case Price Multi Case Price
- Enter a Search title.
- Click 'Save' and 'Run'.
In this circumstance, the customer is also pulling different price levels from the search and wanted to add some logic to the mapping so that when one price level is 0, it will pick from another price level. This formula would provide a solution:
{{#compare variants[*].[OnLine (Variant)] ">" "0.00"}}{{variants[*].[OnLine (Variant)]}}{{else}}{{ variants[*].[Price (Variant)]}}{{/compare}}
The logic here is that if the Online Price is 0, then it retrieves the Compare At price (Price (Variant)), so that the price never goes to zero.
Comments
Please sign in to leave a comment.