Configuring Price Calculations Before Sync in NetSuite Connector
NetSuite Connector discourages performing arithmetic operations with pricing because that causes the pricing in NetSuite to not match with the pricing synced to the storefront. The leading practice is to map price directly from a price level in NetSuite. If that is not possible, perform the additional operations on the prices directly in NetSuite using a custom field.
You can perform arithmetic operations on the price of the item before NetSuite Connector syncs to the storefront. You can perform actions like discount all prices by 10% before syncing and add a $2 to the price to offset credit card processing fees.
In the following procedure, a field value sent from the price is reduced by 10% by multiplying the field value by 90% or .9.
To perform mathematical operations on price before sync:
-
Log in to app.farapp.com.
-
Select the connector and the relevant account.
-
Go to Mappings > Products.
-
Perform one of the following actions:
-
For marketplace connectors like Amazon or Walmart, from the Category list, select the category where your current price mapping resides.
-
For other connectors, from the Select Sync Type field, select Price/Quantity Only or Full Product.
-
-
From the product mappings list, locate the price mapping, click Special Mapping – Click to Edit.
The price Mapping window opens.
Note:If you do not see the price field or the field that storefront uses for price, click Add Mapping and add the field to your mapping.
-
From the Map Price from the Following Price Level list ,select a price level.
-
Click Add Operation Row.
-
From the Operations list, select Multiply.
-
In the Value field, enter .9.
-
(Optional) To add more mathematical operations, repeat steps 7 and 8.
-
Click Save Changes.
-
Click Save.
You can also perform the following additional operations in the price Mapping window: