Configuring Price Calculations in NetSuite Connector

The NetSuite Connector allows you to adjust item prices before they sync to your storefront, enabling operations like applying discounts or adding fees. To ensure accurate pricing across platforms, it's recommended to map prices directly from a price level in NetSuite. However, if this approach isn't feasible, you can perform arithmetic operations directly within the connector.

Why Adjust Prices Before Syncing?

Changing item prices before syncing can help maintain competitive pricing or accommodate processing fees. The following example demonstrates how to reduce an item's price by 10%:

• Multiply the current price by 0.9 to apply a 10% discount.

Steps to Adjust Prices in NetSuite Connector

1. Log in to the application at the specified URL.
2. Choose the connector and the relevant account details.
3. Navigate to Mappings > Products.
4. Select your sync options:
   • For marketplace connectors (like Amazon or Walmart), choose the correct category from the Category list.
   • For other connectors, select either Price/Quantity Only or Full Product in the Select Sync Type field.
5. In the product mappings list, find the price mapping and click Special Mapping - Click to Edit.
6. If the price field isn't visible, click Add Mapping to add it to your mapping.
7. From the Map Price from the Following Price Level list, select an appropriate price level.
8. Click Add Operation Row.
9. Choose Multiply from the Operations list.
10. In the Value field, enter 0.9 for a 10% discount.
11. Optionally, you can add more operations by repeating steps 7 and 8.
12. Click Save Changes, then click Save to finalize your operations.

Using these steps, you can easily manage pricing adjustments within NetSuite Connector, ensuring that your storefront reflects the desired pricing strategy.

Key Considerations

• Always map prices from a defined price level when possible to prevent discrepancies.
• Perform additional operations directly in NetSuite using custom fields if necessary.

Additional Operations Available

In the price Mapping window, you may also perform several additional operations to customize how prices are calculated before synchronization.

Key Takeaways

• Adjusting prices pre-sync ensures price consistency across platforms.
• Directly map prices from NetSuite to avoid discrepancies and erroneous calculations.
• Follow a structured process to implement price changes in NetSuite Connector efficiently.

Source: This article is based on Oracle's official NetSuite documentation.