Proposal summary
The proposal covers the scope of implementing shipping cost calculation. The calculation will be added for customers who purchase using a credit card.
Requirement
Shipping costs will be calculated for credit card-based customers. For any shipment whose total value of the product is $150 or higher, the shopping cost will be 0. Any shipment value less than $150 will be charged shipping cost. The variables and shipping cost will be calculated as per the calculations given in the sheet for the case and non-case items.
Our Solution
- We will enable the feature SCRIPTABLE CART AND CHECKOUT in the website setup.
- A client script will be added for our shipping cost calculation and deployed to sales order.
- The shipping cost will be calculated once an item is added to cart.
- If the total value of the product in cart is $150 or higher, the shopping cost will be 0. If the total value of the product in cart is less than $150 will be charged shipping cost.
- The summary table will be updated with the total shipping cost.
- In the cart page and checkout page, the total shipping cost will be updated.
Shipping Calculation
- Variables Used (Will be predefined in General Preference and customer record)
- Minimum Charge: minimumCharge
- Intercept: intercept
- Zone Coefficient zoneCoef
- Weight Coefficient weightCoef
- Curve Coefficient curveCoef
- Markup%: customerMarkup
- Fuel surcharge%: fuelSurcharge
- Weight Threshold: weightThreshold
- These variables will be used on the formulas to determine the shipping cost of each individual item on the shopping cart. All individual shipping costs added together will be the total shipping cost to charge the customer.
- We will followered the document for calculations of CASE and NON-CASE items.
Assumptions
- The following fields will be created and predefined in Netsuite general preference and customer record.
- Minimum Charge: minimumCharge
- Intercept: intercept
- Zone Coefficient zoneCoef
- Weight Coefficient weightCoef
- Curve Coefficient curveCoef
- Markup%: customerMarkup
- Fuel surcharge%: fuelSurcharge
- Weight Threshold: weightThreshold
- The UI will be developed by matching the existing website theme.
- The shipping cost will be calculated for inventory and non-inventory items.
- Currently there are no client scripts deployed to sales order records(in production). We hope in future if any client scripts are deployed to SALES ORDER, the webstore context will be removed. So SCRIPTABLE CART functionality is not affected.
Risks
- As informed in other proposals, in the production account, the latest deployment occurred on 9/1/2021, but the latest version backup was updated on 12/3/2020.
Budget and Time
Time Required – 48 hours