/
Copy of Various SFCC Order related fields

Copy of Various SFCC Order related fields

Field name

Calculation Logic

Related sfcc logic

Field name

Calculation Logic

Related sfcc logic

isCod

if paymentMethodId is COD

paymentMethodId

totalCredits

summation of all the CREDIT amount

 

totalAmt

summation of all the COD amount

 

totalCODFee

summation of OrderPriceAdjustment when promotionId equals to codFee

OrderPriceAdjustment.price

requiredByTime

currentTime + standard sla days ( with time as 18:00:00

 

isOnHold

if it is an exchange order then yes, else no

isExchange

shippingCharge

order’s shippingTotal - summation of
extraCustomisationPrice for every item.

shippingTotal
extraCustomisationPrice

totalBasePrice

summation of base_price * quantity for each item

base_price, quantity

isGiftOrder

if gift is true for any of the item , then that suborder is being treated as giftOrder

gift

perItemDiscount

summation of order_price_adjustments .price with an exception of ( promotionId equals “Personalized_Jersey_Charge" ) divides by total no. of items

order_price_adjustments

giftCharge

item.c_myCustomizationCost / item.quantity

c_myCustomizationCost

codFeeShare per subOrder

((item.base_price * item.quantity) / totalBasePrice) * totalCODFee

 

sellingPrice(item level)

if (isGiftOrder)
item.price_after_item_discount - CODFeeShare / item.quantity -perItemDiscount


else

item.price_after_item_discount - CODFeeShare / item.quantity

price_after_item_discount

orderDiscount

(item.price - item.price_after_item_discount) /

item.quantity

 

 

itemDiscount

if(isGiftOrder)

perItemDiscount + (CODFeeShare / item.quantity)

else

item.price_after_item_discount - item.price_after_order_discount +(CODFeeShare / item.quantity)