Overview
This article describes how promotions (discounts) in NetSuite are calculated in Pacejet. These promotions can be at the order level or the item level. This article also explains how we calculate the sales price for components of kits. The examples below show how the promotions are calculated and applied for each component price based on the same calculations for NetSuite promotions.
Item-Level Rate Calculations
An item-level promotion subtracts a specific amount from the item(s).
Rate of Each Line for Item-level Promotions
The rate of each line for item-level promotions is calculated by summing the amount for each item and corresponding line promotions and then dividing by the order quantity.
Item |
Quantity |
Rate |
Amount |
New Rate |
Civil War Chess Set |
3 |
$100.00 |
$300.00 |
$100.00 |
Travel Bag |
2 |
$20.00 |
$40.00 |
$18.00 |
Competition Clock |
2 |
$25.00 |
$50.00 |
$12.50 |
Order Level Rate Calculations
Rate of Each Line for Order-Level Promotions
An order-level promotion reduces the total amount by a percentage or a dollar amount.
Order-Level promotions will not reflect the calculated values within NetSuite.
Example Order without Promotions
Item |
Quantity |
Rate |
Amount |
Civil War Chess Set |
3 |
$100.00 |
$300.00 |
Travel Bag |
2 |
$20.00 |
$40.00 |
Competition Clock |
2 |
$25.00 |
$50.00 |
Total = $390.00 | |||
Example Order with a Percent Promotion
Item |
Quantity |
Rate |
Promotion (%) |
Promotion Rate |
Amount |
Civil War Chess Set |
3 |
$100.00 |
10% |
$90 |
$270.00 |
Travel Bag |
2 |
$18.00 |
10% |
$16.20 |
$32.40 |
Competition Clock |
2 |
$12.50 |
10% |
$11.25 |
$22.50 |
Total = $324.90 | |||||
Example Order with a Flat-Rate Promotion of $25.00
Item |
Quantity |
Rate |
Promotion (%) |
Promotion Rate |
Amount |
Civil War Chess Set |
3 |
$100.00 |
6.95% |
$93.08 |
$279.24 |
Travel Bag |
2 |
$18.00 |
6.95% |
$16.75 |
$33.50 |
Competition Clock |
2 |
$12.50 |
6.95% |
$11.63 |
$23.26 |
Total = $336.00 | |||||
Example Order with Two Item-Level Promotions and an Order-Level Percent Promotion
Promotion Items/Order |
Quantity |
Promotion Code and Description |
Rate |
Amount |
Civil War Chess Set |
3 |
$100 |
$300 |
|
Travel Bag |
2 |
TRAVEL: 10% off from each item (each travel bag) |
$20 |
$40 -$4.00 |
Competition Clock |
2 |
BOGO: 100% off from 2nd item |
$25.00 |
$50.00 -$25.00 |
|
Sub-total = $361.00 (The sub-total = 3*100 + 2*18 + 2*12.50 = $361.00) | ||||
Order Promotion |
1 |
BEGIN: 10% off from the entire order.
|
$361.00 |
$361.00 -$36.10 |
Total = $324.90 | ||||
Kit/Assembly Rate Calculations
When using NetSuite to sell kits, the default behavior is to show just the kit item itself on the sales order and item fulfillment. If this is the case, Pacejet will only see the kit item, not any of the components. However, when NetSuite is set up to track inventory in Bins or by Lot/Serial, the appearance of the item fulfillment changes to include the kit items (parents) and the components (members). This is a typical configuration for Pacejet customers, so most kit item fulfillments we see will include the parent and the members. When the kit parent and the kit members are on the item fulfillment, Pacejet shows both types of items by default.
For information about using NetSuite kits, refer to How to Use NetSuite Kits in Pacejet.
Rate Calculation of Kit Components
To determine the rate of the components of a kit, you'll need to determine the total value of all the components, as well as the weight of the kit.
Example
Determine the total value of all components (Field: Total Component Value). The Total Component Value is calculated by adding each component's Base Price for QTY 0 and multiplying that by the quantity. Refer to the table below.
-
Determine the value of the Kit Rate (verify term in NetSuite) versus the Total Component Value.
The value is calculated by dividing the kit rate by the total component value.
In the example shown in the table below: $129.50/$185.00 = 70%
Determine the Rate of Components.
The rate for each component is calculated by the Base Price for QTY 0 multiplied by the weight (refer to step 2).
Example: In the table below, the rate for the Walnut Board is: $60.00 * 70% = $42.00.
Example of Kit Calculations
Component |
Quantity |
Base Price |
Extended Base Price |
Calculated Rate (70%) |
Walnut Board |
1 |
$60.00 |
$60.00 |
$42.00 |
Black Travel Bag |
1 |
$25.00 |
$25.00 |
$17.50 |
Marble White Pawns |
8 |
$2.00 |
$16.00 |
$1.4 |
Marble White Queen |
1 |
$5.00 |
$5.00 |
$3.5 |
Marble White King |
1 |
$5.00 |
$5.00 |
$3.5 |
Marble White Knight |
2 |
$4.00 |
$8.00 |
$2.80 |
Marble White Bishop |
2 |
$4.00 |
$8.00 |
$2.80 |
Marble White Rook |
2 |
$4.00 |
$8.00 |
$2.80 |
Marble Red Pawns |
8 |
$2.00 |
$16.00 |
$1.40 |
Marble Red Queen |
1 |
$5.00 |
$5.00 |
$3.5 |
Marble Red King |
1 |
$5.00 |
$5.00 |
$3.5 |
Marble Red Knight |
2 |
$4.00 |
$8.00 |
$2.80 |
Marble Red Bishop |
2 |
$4.00 |
$8.00 |
$2.80 |
Marble Red Rook |
2 |
$4.00 |
$8.00 |
$2.80 |
Total |
$185.00 |
$129.50 |
||