History: Shopping Cart Trackers

Source of version: 8 (current)

{DIV(float=right)}%%%%%%{DIV}
!Shopping Cart Trackers

These tracker definitions (which can be imported) are used for the advanced ((Shopping Cart)) feature.

In order to record orders in trackers, the minimum you need is the Orders and Order Items trackers. There are additional ones that you will need if you are using more features.

These are here for reference. Profile under development.

^NOTE: For now, FIELD NAMES cannot be changed. The code depends on it.

NOTE: You will need to change the specifications of the item link and item list fields to match the Tracker IDs on your system.^

!!Orders
{CODE()}
[FIELD14]
name = Order ID
position = 10
type = q
options = ,,,itemId
isMain = y
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersOrderId
[FIELD15]
name = User
position = 20
type = u
options = 
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersUser
[FIELD16]
name = Time
position = 30
type = f
options = datetime
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersTime
[FIELD17]
name = Order Total
position = 40
type = b
options = 0,10
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersOrderTotal
[FIELD18]
name = Tiki Payment ID
position = 50
type = t
options = 0,4
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersTikiPaymentId
[FIELD113]
name = Gift Certificate ID
position = 60
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersGiftCertificateId
[FIELD114]
name = Gift Certificate Amount Applied
position = 70
type = b
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = ordersGiftCertificateAmountApplied
{CODE}

!!Order Items
{CODE()}
[FIELD19]
name = Order Item ID
position = 10
type = q
options = 1,,,itemId
isMain = y
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsOrderItemId
[FIELD20]
name = Order ID
position = 20
type = r
options = 4,14,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsOrderId
[FIELD21]
name = Product ID
position = 30
type = r
options = 3,4,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsProductId
[FIELD22]
name = Price Paid
position = 40
type = b
options = 0,8
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsPricePaid
[FIELD23]
name = Amount Bought
position = 50
type = n
options = 0,4
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAmountBought
[FIELD39]
name = Product Type
position = 60
type = l
options = 3,4,21,3,0
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsProductType
[FIELD40]
name = User
position = 70
type = u
options = 1
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsUser
[FIELD43]
name = Associated Event ID
position = 80
type = l
options = 3,4,21,9,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAssociatedEventId
[FIELD44]
name = Product Name
position = 90
type = l
options = 3,4,21,5,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsProductName
[FIELD45]
name = When Bought
position = 100
type = l
options = 4,14,20,16,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsWhenBought
[FIELD49]
name = User Info ID
position = 110
type = l
options = 1,41,40,48,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsUserInfoId
[FIELD52]
name = Real Associated Event ID
position = 120
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsRealAssociatedEventId
[FIELD95]
name = Associated Product Class ID
position = 130
type = l
options = 3,4,21,98,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAssociatedProductClassId
[FIELD101]
name = Exchange - Current Order ID
position = 140
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsExchangeCurrentOrderId
[FIELD102]
name = Exchange - Desired Product ID
position = 150
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsExchangeDesiredProductId
[FIELD103]
name = Exchange Expiry
position = 160
type = l
options = 3,4,21,94
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsExchangeExpiry
[FIELD158]
name = Associated Event Start Date
position = 170
type = f
options = d
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAssociatedEventStartDate
[FIELD159]
name = Associated Event End Date
position = 180
type = f
options = d
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAssociatedEventEndDate
[FIELD161]
name = Associated Tiki Payments ID
position = 190
type = l
options = 4,14,20,18
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsAssociatedTikiPaymentsId
[FIELD216]
name = Original Price
position = 200
type = b
options = 0,8
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsOriginalPrice
[FIELD226]
name = Inputed Price From Gift Cert
position = 210
type = b
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsInputedPriceFromGiftCert
[FIELD227]
name = Inputed Price From Bundle
position = 220
type = b
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsInputedPriceFromBundle
[FIELD228]
name = Parent Code
position = 230
type = n
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsParentCode
[FIELD231]
name = Bought By
position = 240
type = l
options = 4,14,20,15,0
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = orderitemsBoughtBy
{CODE}

!!Product Classes
__Needed for product exchanges, collect additional user information when buying certain products, and gift certificates features__
{CODE()}
[FIELD92]
name = Class Name
position = 10
type = t
options = 
isMain = y
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesClassName
[FIELD96]
name = Product Class ID
position = 20
type = q
options = ,,,itemId
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesProductClassId
[FIELD136]
name = Associated Required Form
position = 30
type = k
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesAssociatedRequiredForm
[FIELD137]
name = Required Field IDs
position = 40
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = Comma-delimited integer field Ids
descriptionIsParsed = n
permName = productclassesRequiredFieldIds
[FIELD160]
name = Skip Required Form if Filled
position = 45
type = d
options = Yes,No
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesSkipRequiredFormIfFilled
[FIELD154]
name = Email Template ID
position = 50
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesEmailTemplateId
[FIELD155]
name = Associated Postpurchase Form
position = 60
type = k
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesAssociatedPostpurchaseForm
[FIELD156]
name = Postpurchase Field IDs
position = 70
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = productclassesPostpurchaseFieldIds
{CODE}

!!Gift Certificate
__This is needed for the Gift Certificates feature__
{CODE()}
[FIELD105]
name = Gift Certificate ID
position = 1
type = q
options = ,,,itemId
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateGiftCertificateId
[FIELD106]
name = Name
position = 5
type = t
options = 0,60
isMain = y
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = y
description = 
descriptionIsParsed = n
permName = giftcertificateName
[FIELD107]
name = Type
position = 10
type = d
options = Cash,Product,Product Class,Product Bundle,Bundle Class
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = y
description = 
descriptionIsParsed = n
permName = giftcertificateType
[FIELD115]
name = Type Reference
position = 15
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateTypeReference
[FIELD108]
name = Original Balance or Percentage
position = 20
type = n
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = y
description = 
descriptionIsParsed = n
permName = giftcertificateOriginalBalanceOrPercentage
[FIELD109]
name = Current Balance or Percentage
position = 30
type = n
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = y
description = 
descriptionIsParsed = n
permName = giftcertificateCurrentBalanceOrPercentage
[FIELD110]
name = Origination
position = 40
type = d
options = Order,Employee
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateOrigination
[FIELD112]
name = Redeem Code
position = 70
type = t
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateRedeemCode
[FIELD116]
name = Mode
position = 80
type = d
options = Regular,Percentage,Coupon,Coupon Percentage
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = y
description = 
descriptionIsParsed = n
permName = giftcertificateMode
[FIELD117]
name = One Line Description
position = 90
type = t
options = 0,60
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateOneLineDescription
[FIELD118]
name = Admin Notes
position = 100
type = a
options = 0,50,5
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateAdminNotes
[FIELD157]
name = Long Description
position = 110
type = a
options = 0,50,3
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateLongDescription
[FIELD224]
name = Gift Certificate Inputed Price
position = 120
type = b
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateGiftCertificateInputedPrice
[FIELD225]
name = Order Item ID
position = 130
type = n
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateOrderItemId
[FIELD230]
name = Order ID
position = 140
type = n
options = 
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
description = 
descriptionIsParsed = n
permName = giftcertificateOrderId
{CODE}