Use two price levels in item export – Celigo Help Center

This is in reference to Shopify 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.
In the integration, Celigo will be pulling information on prices from NetSuite to Shopify. 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 'Multicase Price Website' and 'Website RFP' fields are populated via script with values for Multi-case Price and RFP price levels, respectively.
Any updates on the 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	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.

Related articles