The “Map Magento Websites/Customer Groups with NetSuite Price Levels” setting supports a three-level mapping. If you have set up quantity pricing for your SKUs in NetSuite, this setting allows exporting the quantity pricing in NetSuite as tier pricing in Magento 2. You can provide the mapping between Magento websites, Magento customer groups, and NetSuite price levels to create pricing tiers on a Magento SKU. Depending on how you want to add this info in Magento2, each row is a unique combination of website, customer group & price level or each row can have a single default website.
You can provide the mapping between Magento websites, Magento customer groups, and NetSuite price levels to create pricing tiers on a Magento SKU. Depending on how you want to add this information in Magento, each row could be a unique combination of a website, customer group and price level or each row can have a single default website.
Before you configure tier pricing
Before you configure the “Map Magento Websites/Customer Groups with NetSuite Price Levels” setting, ensure to configure multi-currency price levels and import websites to NetSuite. To understand more about the multi-currency price levels, refer here.
Configure tier pricing
Step 1: Magento2 configuration
To use tier pricing in your Magento2 account, ensure to configure the price at the website level (Stores > configuration > Catalog > Price > Website).
Step 2: NetSuite configuration
While you configure the item in NetSuite, ensure to provide price and quantity for an item.
Limitation: The tier pricing functionality is supported only if the Quantity Pricing checkbox in Setup > Company > Enable features > Transactions is checked.
Step 3: Configure “Map Magento Websites/Customer Groups with NetSuite Price Levels” setting
You can map NetSuite price levels to Magento customer groups of a Magento Website. Or, you can map NetSuite price levels to a Magento Website. The Magento tier pricing should be mapped appropriately in the integration app so that no errors or duplicate products get created during product syncs.
- The values in each row have to be unique.
- A website can’t have multiple default price levels.
- In integrator.io, click the Magento 2 - NetSuite tile.
- Go to Settings > Integration flows > Product > Advanced Settings > Map Magento Website/Customer Groups with NetSuite Price Levels.
- Below the column names, click each Refresh icon. This will fetch values present in NetSuite and Magento2.
- Select either or both of the following.
- Under the "Magento 2 Website" column, select the appropriate Magento Website.
- Under the "Magento 2 Customer Groups" column, select the appropriate Magento customer group.
- Under the "NetSuite Price Levels" column, select the desired price level for the values selected in step 4.
- Under the "Default Price Level" column, select Yes if you want to set the price specified in NetSuite price level for syncing product price as the default price. This would sync the default price if no price is found for the mapped tier pricing.
- Click Save.
Step 4: Run the flow
Run the "NetSuite Item to Magento Product Add/Update" flow.
Results in different scenarios
- When you do not select any Default Price Level then the connector will apply the default price from the NetSuite price level for syncing product price drop-down list.
- If you select Default Price Level as “Yes” for a single website and not for another website, the connector processes prices according to the default price level selected for that website. For other websites, the connector will consider default from the NetSuite price level for syncing product price drop-down list.
- If you select Default Price Level as “Yes” for each website, the connector will process prices according to respective websites and their price levels.
- When you select two default price for the single website, the connector will generate an error.
Support multi-currency price levels
If you have websites with different currencies, you can sync combinations of NetSuite price level and currency. Each combination will be a separate tier pricing row. You can also define a unique price value at the website level per customer group. The currency in Magento2 is managed at the website level and customers and customer groups are managed at the global levels. For the customer groups, you can have a separate tier pricing row.
To understand more about the multi-currency price levels, refer here.
You can ask questions and get tips in our community forum.