| Cart ID | id_cart (NUMBER) | * select = 'c.`id_cart`'; |
| Guest ID | id_guest (NUMBER) | * select = 'c.`id_guest`'; |
| Customer ID | id_customer (NUMBER) | * select = 'c.`id_customer`'; |
| Customer name | customer (TEXT) | * select = 'CONCAT(
IFNULL(`customer`.firstname, ''), ' ', IFNULL(`customer`.lastname, '') ) as `customer`'; * join = 'LEFT JOIN `ps_customer` `customer` ON (`customer`.id_customer = c.id_customer)'; |
| Currency | currency (TEXT) | * select = 'COALESCE(`currency`.name, '') as `currency`';
* join = 'LEFT JOIN `ps_currency` `currency` ON `currency`.id_currency = c.id_currency'; |
| Currency code | currency_code (TEXT) | * select = 'COALESCE(`currency_code`.iso_code as, '') `currency_code`';
* join = 'LEFT JOIN `ps_currency` `currency_code` ON `currency_code`.id_currency = c.id_currency'; |
| Shipping | shipping (TEXT) | * select = 'COALESCE(`carrier_shipping`.name, '') as `shipping`';
* join = 'LEFT JOIN `ps_carrier` `carrier_shipping` ON (`carrier_shipping`.id_carrier = c.id_carrier)'; |
| Gift | gift (BOOLEAN) | * select = 'IF (c.gift > 0, 'true', 'false') as `gift`';
|
| Cart date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(c.date_add, '%Y%m%d%H') as date_add';
|
| Last modification | date_upd (YEAR_MONTH_DAY_HOUR) | * select = 'c.`date_upd`'; |
| Abandonned cart | abandonned (BOOLEAN) | * select = 'IF (`orders2`.id_order > 0, 'false', 'true') as `abandonned`';
* join = 'LEFT JOIN `ps_orders` `orders2` ON (`orders2`.id_cart = c.id_cart)'; |
| Order reference | reference (TEXT) | * select = 'COALESCE(`orders`.reference, 0) as `reference`';
* join = 'LEFT JOIN `ps_orders` `orders` ON (`orders`.id_cart = c.id_cart)'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = c.id_shop'; |