pricing mechanisms in Netsuite and Magento

🛒 In Magento 2:

Magento offers several pricing mechanisms that can work individually or together depending on the catalog setup.

1. Tier Price

• Definition: Discounted prices based on quantity breaks.
• Example:
• Buy 1–4: $100
• Buy 5–9: $90
• Buy 10+: $80
• Set for: Specific customer groups or all groups.
• Where Set: Product Edit → Advanced Pricing → Tier Price.

2. Special Price

• Definition: A promotional or temporary discount on the regular price.
• Example:
• Regular price: $120
• Special price: $99 (valid from July 1 to July 15)
• Overrides: Base price (unless tier price gives a better discount).
• Where Set: Product Edit → Advanced Pricing → Special Price.

3. Non-Discountable

• Definition: A custom product attribute (boolean: Yes/No) that determines whether discount rules or pricing logic should skip the product.
• Used In: Custom modules to exclude specific products from promotions or tier pricing logic.
• How Used: You need to create and handle this programmatically (e.g., via observer or plugin).

4. Quantity-Based Pricing / Tiered Logic

• Defined via: Tier Prices, Catalog Price Rules, or custom pricing logic.
• Use Cases:
• B2B bulk discounts
• Wholesale/retail pricing structures

💼 In NetSuite:

NetSuite uses Pricing Schedules and Price Levels to handle similar concepts.

1. Quantity Pricing (Tier Price Equivalent)

• Definition: Discounted price based on quantity brackets.
• Set Using: Quantity Pricing Schedule
• Example:
• Qty 1–4: $100
• Qty 5–9: $90
• Qty 10+: $80
• Linked To: Items and Customers (via Pricing subtab)

2. Price Levels

• Definition: Alternate pricing levels for different customer types (e.g., Wholesale, Retail, Distributor)
• Example:
• Base Price: $120
• Wholesale: $100
• VIP: $95
• Where Set: Setup > Accounting > Price Levels

3. Promotional Pricing (Special Price Equivalent)

• Definition: Temporarily override the base price using promotional discounts or sales campaigns.
• Managed Using: Discounts, coupon codes, or price overrides.

4. Non-Discountable Items

• Definition: A custom field or flag used to prevent discounts.
• How Set:
• Custom checkbox field like “Non-Discountable” on the item.
• Then validated via SuiteScript or workflows before applying discounts.

🔁 Summary Table

ConceptMagento TermNetSuite EquivalentTier PriceTier PriceQuantity Pricing ScheduleSpecial PriceSpecial PricePromotional Discounts / OverrideCustomer Group PricingCustomer GroupsPrice LevelsNon-Discountable FlagCustom AttributeCustom Field + SuiteScriptQuantity-Based PricingTier/Catalog RulesQuantity Pricing

🔧 Example Use Case:

A B2B customer logs in and orders 10 units of a non-discountable product.

• Magento:
• Tier pricing would normally apply, but your custom observer logic (e.g., checking non_discountable == 'Yes') skips setting the discount.
• NetSuite:
• Item has a custom field Non-Discountable set to true.
• A SuiteScript validation script or workflow skips applying quantity discount from the pricing schedule.