ATG Commerce uses the following tables to store information about users’ abandoned orders:
See the Using Abandoned Order Services chapter for information on the Abandoned Order Services module.
dcspp_ord_abandon
This table contains information about abandoned orders.
Column | Data Type | Constraint | ||
---|---|---|---|---|
| VARCHAR(40) | NOT NULL | ||
(primary key) | The unique identifier associated with the | |||
| INTEGER | NOT NULL | ||
The | ||||
| VARCHAR(40) | NOT NULL | ||
The ID of the order for which the | ||||
| DATE | NULL | ||
The date and time that the order was most recently modified. This property is used to detect activity on abandoned orders. | ||||
| VARCHAR(40) | NULL | ||
The abandonment state of the associated order. | ||||
| INTEGER | NULL | ||
The number of times the associated order has been identified as ABANDONED. | ||||
| DATE | NULL | ||
The date and time the associated order was most recently identified as ABANDONED. | ||||
| DATE | NULL | ||
The date and time the associated order was most recently identified as REANIMATED. | ||||
| DATE | NULL | ||
The date and time the associated order was identified as CONVERTED. | ||||
| DATE | NULL | ||
The date and time the associated order was most recently identified as LOST. |
dcs_user_abandoned
This table contains information about users’ abandoned orders.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | |
(primary key) | The ID of this | ||
| VARCHAR(40) | NOT NULL | |
The ID of the order. | |||
| VARCHAR(40) | NOT NULL | |
The profile ID of the user associated with the abandoned order. |
drpt_conv_order
This table contains information about users’ converted orders, that is, previously abandoned, reanimated, or lost orders that subsequently have been checked out.
Column | Data Type | Constraint | ||
---|---|---|---|---|
| VARCHAR(40) | NOT NULL | ||
(primary key) | The ID of the converted order. | |||
| DATE | NOT NULL | ||
The date and time that the order was converted. | ||||
| DOUBLE | NOT NULL | ||
The total price of the converted order. | ||||
| INTEGER | NULL | ||
The number of promotions that were applied to the converted order. | ||||
| DOUBLE | NULL | ||
The total value of the promotions that were applied to the converted order. |
drpt_session_ord
This table tracks information about orders that have not been checked out at the end of a session.
Column | Data Type | Constraint | ||
---|---|---|---|---|
| VARCHAR(40) | NOT NULL | ||
(primary key) | The ID of the submitted order. | |||
| VARCHAR(40) | NOT NULL | ||
The ID of the dataset. | ||||
| DATE timestamp | NOT NULL | ||
The date and time that the order was converted. | ||||
| DOUBLE | NOT NULL | ||
The total price of the submitted order. | ||||
| INTEGER | NULL | ||
The number of promotions that were applied to the converted order. | ||||
| VARCHAR(40) | NULL | ||
The total value of the promotions that were applied to the converted order. | ||||
| VARCHAR(40) | NULL | ||
The total value of the promotions that were applied to the converted order. | ||||
| NUMERIC | NULL | ||
A value of 1 indicates that the order is persistent. |