Creating an intelligent Handling fee on site

Requirement 

Creating an intelligent Handling fee on site 

Handling fee should be implemented at the item level, based off of vendor, and item cost (not selling price) 

Example:  

1. SKU Cost Value $10 

2. SKU with vendor (vendor name: Coilhose) needs a handling fee of $15 on any order below $100.  

3. Person purchases said SKU with units = 1 . Handling fee is $15 

4. Person purchases 10 units of the same SKU and handling fee goes to zero. 

5. Person purchases 5 units of same sku and 6 units of another Coilhose sku (total value of order is over $100) handling fee goes to zero. 

6. Person purchases 5 units of same sku and 6 units of a different vendors product which is over $100 value is over $100 handling fee stays at $15 didn’t meet vendor/Coilhose min of $100. 

7. Handling fee appears in cart level when checking out.  (possible note: you are X dollars away from no handling fee) 

8. Handling fee also appears as an additional fee on the PDP (possible note: you are X dollars away from no handling fee) 

Our solution 

As per the requirement we need to add handling price to the items of vendors “Coilhose”. 

So, for that we need to identify the items to which the “handling fee” is enabled. In order to get the items having handling fee we have to do any of the following method. 

1. Create a checkbox for all the items and for the items having handling cost the checkbox need to be enabled. The checkbox has to be checked by the client. So, by checking that checkbox value we can Identify the items. 

2. We have a standard field for handling rate in the item record. If the field is having a value, then we can understand that the item is having handling fee. 

For each customer we have to check the cart and need to verify is there any item in the cart having handling cost. If any of the items have handling cost enabled then by using a saved search, we can categorise the items based on the vendors. 

We have several criteria that need to be considered. 

1.If the items belong to the “Coilhose” vendor, then item cost of these items needs to be added and if the sum is greater than 100 then handling cost of $15 has to added to the total amount. The sum value also needs to be updated in the NetSuite sales order by using a client script. Otherwise, there will be mismatch and it may lead to error. 

Note: Currently we are considering the vendor “Coilhose” only.   

2. If customer purchases a particular item of “Coilhose” vendor, then the handling rate of $15 will be added. 

3. if the customer purchases 10 units of the same SKU and handling fee goes to zero. 

4. If the customer is having some items in the cart and again trying to add items belonging to “Coilhose” vendor, then in the PDP page while clicking “add to cart” a message can be displayed by comparing the items of the cart. The message will be as follows “you are X dollars away from no handling fee”. For that, we need to create an extension. We can make changes in the messages by giving the message content in the configuration record. If any “Coilhose” item is not in the cart then no message will be displayed. 

 5. In the cart we have an option of “proceed to checkout”, while clicking the button we can do one more functionality. while clicking the button we can check the total amount of items belonging to “Coilhose” vendor and if the sum is less than 100$, a message can be displayed as you are X dollars away from no handling fee”. We can make changes in the messages by giving the message content in the configuration record. 

6. We have an option to show the same message in the minicart page as shown in the cart page. For that we need to make changes in the extension and need to do more customization.