In the DataSource DW panel you can find the dwzShoppingCart list of available Cart field that you can use in your pages:
You can find 3 different type of icons:
This are the field you define in the dwzShoppingCart config panel.
In this list of calcultaed field you will find all the cart columns you set like SUM and some others calculated items.
(see below for the complete list)
This is a value the cart get from the DataBase after you insert the order into the DataBase. Return the Record ID of the order
Use the Drag-and-Drop to add this value into your page like the standard DWdatasource value.
List of calculate fields:
Count(NumItems)
Return the number of items in the cart, not the quantity!
Order Weight
The total cart weight calculate the sum of item quantity x item weight
Discount On Items
With this shopping cart you can define a discount for each items and a discount for the order and you can also use the 2 types together. So this field return the amount of the items discount without the order discount.
Sub Total
The amount of the order calculate for the items price before any other amount like VAT,Shipping,etc..
Order Discount
With this shopping cart you can define a discount for each items and a discount for the order and you can also use the 2 types together. So this field return the amount of the order discount without the items discount. In this value you don't find the items discount because the final price for each items is calculate without the item discount.
Discount Percentage
When you define a disount you can setup it's value like a percentage on the order amount or like an absolute value. In the first case this field return the percentage so the percentage can be displayed to the buyers.
TotalNet
Return the order amount without the order discount. The amount used to calculate all the other value like, VAT,Shipping,etc..
Shipping Amount
The amount of the shipping cost
Shipping Percentage
When you define a shipping you can setup it's value like a percentage on the order amount or weight or like an absolute value. In the first case this field return the percentage so the percentage can be displayed to the buyers.
Other Taxes Amount
Other Taxes Percentage
When you define a OtherTaxes you can setup it's value like a percentage on the order amount or weight or like an absolute value. In the first case this field return the percentage so the percentage can be displayed to the buyers.
Taxable Amount
The order amount with the shipping and the Other taxes amount.
VAT Amount
The amount of the VAT
VAT percentage
The percentage of the VAT
GrandTotal
The Order Amount the buyers must pay
