| Order ID | id_order (NUMBER) | * select = 'od.`id_order`'; |
| Order line ID | id_order_detail (NUMBER) | * select = 'od.`id_order_detail`'; |
| Product ID | id_product (NUMBER) | * select = 'od.`product_id` as `id_product`';
|
| Combination ID | id_product_attribute (NUMBER) | * select = 'od.`product_attribute_id` as `id_product_attribute`';
|
| EAN 13 | product_ean13 (TEXT) | * select = 'od.`product_ean13`'; |
| UPC | product_upc (TEXT) | * select = 'od.`product_upc`'; |
| Reference | product_reference (TEXT) | * select = 'od.`product_reference`'; |
| Supplier reference | product_supplier_reference (TEXT) | * select = 'od.`product_supplier_reference`'; |
| Name | product_name (TEXT) | * select = 'od.`product_name`'; |
| Weight | product_weight (NUMBER) | * select = 'od.`product_weight`'; |
| Quantity | product_quantity (NUMBER) | * select = 'od.`product_quantity`'; |
| Stock at purchase | product_quantity_in_stock (NUMBER) | * select = 'od.`product_quantity_in_stock`'; |
| Quantity refunded | product_quantity_refunded (NUMBER) | * select = 'od.`product_quantity_refunded`'; |
| Quantity return | product_quantity_return (NUMBER) | * select = 'od.`product_quantity_return`'; |
| Quantity reinjected | product_quantity_reinjected (NUMBER) | * select = 'od.`product_quantity_reinjected`'; |
| Reduction percent | reduction_percent (NUMBER) | * select = 'od.`reduction_percent`'; |
| Reduction amount TTC | reduction_amount_tax_incl (NUMBER) | * select = 'od.`reduction_amount_tax_incl`'; |
| Reduction amount HT | reduction_amount_tax_excl (NUMBER) | * select = 'od.`reduction_amount_tax_excl`'; |
| Reduction amount HT | discount_quantity_applied (NUMBER) | * select = 'od.`discount_quantity_applied`'; |
| Unit price TTC | unit_price_tax_incl (NUMBER) | * select = 'od.`unit_price_tax_incl`'; |
| Unit price HT | unit_price_tax_excl (NUMBER) | * select = 'od.`unit_price_tax_excl`'; |
| Total price TTC | total_price_tax_incl (NUMBER) | * select = 'od.`total_price_tax_incl`'; |
| Total price HT | total_price_tax_excl (NUMBER) | * select = 'od.`total_price_tax_excl`'; |
| Shipping price TTC | total_shipping_price_tax_incl (NUMBER) | * select = 'od.`total_shipping_price_tax_incl`'; |
| Shipping price HT | total_shipping_price_tax_excl (NUMBER) | * select = 'od.`total_shipping_price_tax_excl`'; |
| Tax name | tax_name (TEXT) | * select = 'od.`tax_name`'; |
| Tax rate | tax_rate (NUMBER) | * select = 'od.`tax_rate`'; |
| Ecotax | ecotax (NUMBER) | * select = 'od.`ecotax`'; |
| Ecotax rate | ecotax_tax_rate (NUMBER) | * select = 'od.`ecotax_tax_rate`'; |
| Credit notes TTC | oslip_tax_incl (NUMBER) | * select = 'COALESCE((
SELECT SUM(`oslip_detail_ti`.total_price_tax_incl) FROM `ps_order_slip_detail` `oslip_detail_ti` WHERE `oslip_detail_ti`.id_order_detail = od.id_order_detail ), 0) as `oslip_tax_incl`'; |
| Credit notes HT | oslip_tax_excl (NUMBER) | * select = 'COALESCE((
SELECT SUM(`oslip_detail_te`.total_price_tax_excl) FROM `ps_order_slip_detail` `oslip_detail_te` WHERE `oslip_detail_te`.id_order_detail = od.id_order_detail ), 0) as `oslip_tax_excl`'; |
| Total price TTC - Credit notes TTC | turnover_tax_incl (NUMBER) | * select = '(total_price_tax_incl - COALESCE((
SELECT SUM(`oslip_detail_ti`.total_price_tax_incl) FROM `ps_order_slip_detail` `oslip_detail_ti` WHERE `oslip_detail_ti`.id_order_detail = od.id_order_detail ), 0)) as `turnover_tax_incl`'; |
| Total price HT - Credit notes HT | turnover_tax_excl (NUMBER) | * select = '(total_price_tax_excl - COALESCE((
SELECT SUM(`oslip_detail_te`.total_price_tax_excl) FROM `ps_order_slip_detail` `oslip_detail_te` WHERE `oslip_detail_te`.id_order_detail = od.id_order_detail ), 0)) as `turnover_tax_excl`'; |
| Original product price | original_product_price (NUMBER) | * select = 'od.`original_product_price`'; |
| Wholesale price | original_wholesale_price (NUMBER) | * select = 'od.`original_wholesale_price`'; |
| Supplier price | purchase_supplier_price (NUMBER) | * select = 'od.`purchase_supplier_price`'; |
| Category | category (TEXT) | * select = 'COALESCE(`categorylang`.`name`, '') as `category`';
* join = 'LEFT JOIN `ps_product_shop` `pscl` ON `pscl`.id_product = od.`product_id` AND `pscl`.id_shop = od.`id_shop` LEFT JOIN `ps_category_lang` `categorylang` ON `categorylang`.id_category = `pscl`.id_category_default AND `categorylang`.id_shop = od.`id_shop` AND `categorylang`.id_lang = 1'; |
| Manufacturer | manufacturer (TEXT) | * select = 'COALESCE(`manufacturer`.`name`, '') as `manufacturer`';
* join = 'LEFT JOIN `ps_product` `product_manufacturer` ON `product_manufacturer`.id_product = od.`product_id` LEFT JOIN `ps_manufacturer` `manufacturer` ON `manufacturer`.id_manufacturer = `product_manufacturer`.id_manufacturer'; |
| Supplier | supplier (TEXT) | * select = 'COALESCE(`supplier`.`name`, `supplier_2`.`name`, '') as `supplier`';
* join = 'LEFT JOIN `ps_product` `product_id_supplier` ON `product_id_supplier`.id_product = od.`product_id` LEFT JOIN `ps_supplier` `supplier` ON `supplier`.id_supplier = `product_id_supplier`.id_supplier LEFT JOIN `ps_product_supplier` `product_supplier` ON `product_supplier`.id_product = od.`product_id` AND `product_supplier`.id_product_attribute = od.`product_attribute_id` LEFT JOIN `ps_supplier` `supplier_2` ON `supplier_2`.id_supplier = `product_supplier`.id_supplier'; |
| Order date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(o.date_add, '%Y%m%d%H') as date_add';
|
| Payment method | payment (TEXT) | * select = 'o.`payment` as `payment`';
|
| Payment module | module (TEXT) | * select = 'o.`module` as `module`';
|
| Invoice Num | invoice_number (NUMBER) | * select = 'o.invoice_number as invoice_number';
|
| Invoice date | invoice_date (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(o.invoice_date, '%Y%m%d%H') as invoice_date';
|
| Image | image (TEXT) | * select = 'COALESCE(`product_image`.id_image, '') as image';
* join = 'LEFT JOIN `ps_image` `product_image` ON `product_image`.id_product = od.product_id AND `product_image`.cover = 1'; |
| Order status | status (TEXT) | * select = 'COALESCE(osl.name, '') as `status`';
* join = 'LEFT JOIN `ps_order_state_lang` osl ON (osl.id_order_state = o.current_state AND osl.id_lang = 1)'; |
| Current stock | stock (NUMBER) | * select = 'od.`product_id`';
* select = 'od.`product_attribute_id`'; * select = 'od.`id_shop`'; |
| Current stock value | stock_value_wholesale (NUMBER) | * select = 'od.`original_wholesale_price`';
* select = 'od.`product_id`'; * select = 'od.`product_attribute_id`'; * select = 'od.`id_shop`'; |
| Current stock value (supplier) | stock_value_supplier (NUMBER) | * select = 'od.`purchase_supplier_price`';
* select = 'od.`product_id`'; * select = 'od.`product_attribute_id`'; * select = 'od.`id_shop`'; |
| Location | location (TEXT) | * select = 'COALESCE(`location`.`location`, `product`.`location`) as `location`';
* join = 'LEFT JOIN `ps_warehouse_product_location` `location` ON `location`.id_product = od.`product_id` AND `location`.id_product_attribute = od.`product_attribute_id` AND `location`.id_warehouse = od.`id_warehouse` LEFT JOIN `ps_product` `product` ON `product`.id_product = od.`product_id`'; |
| Warehouse | warehouse (TEXT) | * select = 'COALESCE(`warehouse`.name, '') as `warehouse`';
* join = 'LEFT JOIN `ps_warehouse` `warehouse` ON `warehouse`.id_warehouse = od.id_warehouse'; |
| Paid and not canceled ? | valid (BOOLEAN) | * select = 'IF (o.valid > 0, 'true', 'false') as `valid`';
|
| Validated ? (logable) | logable (BOOLEAN) | * select = 'IF (oslg.logable > 0, 'true', 'false') as `logable`';
* join = 'LEFT JOIN `ps_order_state` `oslg` ON `oslg`.id_order_state = o.current_state'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = od.id_shop'; |
| Market place | marketplace (TEXT) | * select = 'COALESCE(`lengow`.`marketplace`, ''.
$this->module->l('website').'') as `marketplace`'; * join = 'LEFT JOIN `ps_lengow_orders` lengow ON lengow.id_order = o.id_order'; |