Utilizing Two Price levels for BigCommerce Item Export – Celigo Help Center

This is in reference to BigCommerce trying to pull two price levels into a single Item Export Saved search. The use case is that BigCommerce has 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 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 BigCommerce. 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.

Related articles