| Product ID | id_product (NUMBER) | * select = 'p.`id_product`'; |
| Combination ID | id_product_attribute (NUMBER) | * select = 'COALESCE(pa.id_product_attribute, 0) as `id_product_attribute`';
|
| Supplier ID | id_supplier (NUMBER) | * select = 'p.`id_supplier`'; |
| Supplier | supplier (TEXT) | * select = 'COALESCE(`supplier`.`name`, `supplier_2`.`name`, '') as `supplier`';
* join = 'LEFT JOIN `ps_supplier` `supplier` ON `supplier`.id_supplier = `p`.id_supplier LEFT JOIN `ps_product_supplier` `product_supplier` ON `product_supplier`.id_product = p.`id_product` LEFT JOIN `ps_supplier` `supplier_2` ON `supplier_2`.id_supplier = `product_supplier`.id_supplier'; |
| Manufacturer ID | id_manufacturer (NUMBER) | * select = 'p.`id_manufacturer`'; |
| Manufacturer | manufacturer (TEXT) | * select = 'COALESCE(`manufacturer`.`name`, '') as `manufacturer`';
* join = 'LEFT JOIN `ps_manufacturer` `manufacturer` ON `manufacturer`.id_manufacturer = `p`.id_manufacturer'; |
| Default Shop ID | id_shop_default (NUMBER) | * select = 'p.`id_shop_default`'; |
| Shop ID | id_shop (NUMBER) | * select = 'ps.id_shop as id_shop';
|
| Default Category ID | id_category_default (NUMBER) | * select = 'COALESCE(ps.id_category_default, p.id_category_default) as id_category_default';
|
| Category | default_category (TEXT) | * select = 'COALESCE(`categorylang`.`name`, '') as `default_category`';
* join = 'LEFT JOIN `ps_category_lang` `categorylang` ON `categorylang`.id_category = `p`.id_category_default AND `categorylang`.id_shop = ps.`id_shop` AND `categorylang`.id_lang = 1'; |
| Tax rules Group ID | id_tax_rules_group (NUMBER) | * select = 'COALESCE(ps.id_tax_rules_group, p.id_tax_rules_group) as id_tax_rules_group';
|
| Name | name (TEXT) | * select = 'p.id_product as name_product_id,
COALESCE(pa.id_product_attribute, 0) as name_product_attribute_id'; |
| Description | description (TEXT) | * select = 'pl.description as description';
|
| Description short | description_short (TEXT) | * select = 'pl.description_short as description_short';
|
| Link rewrite | link_rewrite (TEXT) | * select = 'pl.link_rewrite as link_rewrite';
|
| Meta title | meta_title (TEXT) | * select = 'pl.meta_title as meta_title';
|
| Meta description | meta_description (TEXT) | * select = 'pl.meta_description as meta_description';
|
| Meta keywords | meta_keywords (TEXT) | * select = 'pl.meta_keywords as meta_keywords';
|
| "Available now" text | available_now (TEXT) | * select = 'pl.available_now as available_now';
|
| "Available later" text | available_later (TEXT) | * select = 'pl.available_later as available_later';
|
| "Delivery in stock" text | delivery_in_stock (TEXT) | * select = 'pl.delivery_in_stock as delivery_in_stock';
|
| "Delivery out stock" text | delivery_out_stock (TEXT) | * select = 'pl.delivery_out_stock as delivery_out_stock';
|
| URL | url (TEXT) | * select = 'link_rewrite as url,
p.id_product as url_product_id, ps.id_shop as url_shop_id'; |
| On sale ? | on_sale (BOOLEAN) | * select = 'IF (COALESCE(ps.on_sale, p.on_sale) > 0, 'true', 'false') as `on_sale`';
|
| Online only ? | online_only (BOOLEAN) | * select = 'IF (
COALESCE(ps.online_only, p.online_only) > 0, 'true', 'false' ) as `online_only`'; |
| EAN 13 | ean13 (TEXT) | * select = 'COALESCE(pa.ean13, p.ean13, '') as `ean13`';
|
| ISBN | isbn (TEXT) | * select = 'COALESCE(pa.isbn, p.isbn, '') as `isbn`';
|
| UPC | upc (TEXT) | * select = 'COALESCE(pa.upc, p.upc, '') as `upc`';
|
| Ecotax | ecotax (NUMBER) | * select = 'COALESCE(ps.ecotax, p.ecotax) as ecotax';
|
| Quantity | quantity (NUMBER) | * select = 'COALESCE(`stockav`.quantity, p.quantity) as quantity';
* join = 'LEFT JOIN `ps_stock_available` `stockav` ON `stockav`.id_shop = ps.id_shop AND `stockav`.id_product_attribute = pa.id_product_attribute AND `stockav`.id_product = ps.id_product'; |
| Minimal quantity | minimal_quantity (NUMBER) | * select = 'COALESCE(ps.minimal_quantity, p.minimal_quantity) as minimal_quantity';
|
| Low stock threshold | low_stock_threshold (NUMBER) | * select = 'COALESCE(ps.low_stock_threshold, p.low_stock_threshold, 0) as low_stock_threshold';
|
| Low stock alert | low_stock_alert (NUMBER) | * select = 'COALESCE(ps.low_stock_alert, p.low_stock_alert, 0) as low_stock_alert';
|
| Price TE | price (NUMBER) | * select = 'p.id_product as price_product_id,
COALESCE(pa.id_product_attribute, 0) as price_product_attribute_id'; |
| Wholesale price TE | wholesale_price (NUMBER) | * select = 'COALESCE(
pa.wholesale_price, ps.wholesale_price, p.wholesale_price ) as wholesale_price'; |
| Unity | unity (TEXT) | * select = 'COALESCE(ps.unity, p.unity) as unity';
|
| Unit price ratio | unit_price_ratio (NUMBER) | * select = 'COALESCE(ps.unit_price_ratio, p.unit_price_ratio) as unit_price_ratio';
|
| Additional shipping cost TE | additional_shipping_cost (NUMBER) | * select = 'COALESCE(
ps.additional_shipping_cost, p.additional_shipping_cost ) as additional_shipping_cost'; |
| Reference | reference (TEXT) | * select = 'COALESCE(
pa.reference, p.reference, '' ) as reference'; |
| Supplier reference | supplier_reference (TEXT) | * select = 'COALESCE(
pa.supplier_reference, p.supplier_reference, '' ) as supplier_reference'; |
| Location | location (TEXT) | * select = 'p.`location`'; |
| Width | width (NUMBER) | * select = 'p.`width`'; |
| Height | height (NUMBER) | * select = 'p.`height`'; |
| Depth | depth (NUMBER) | * select = 'p.`depth`'; |
| Weight | weight (NUMBER) | * select = 'p.`weight`'; |
| Out of stock | out_of_stock (NUMBER) | * select = 'p.`out_of_stock`'; |
| Additional delivery times | additional_delivery_times (NUMBER) | * select = 'p.`additional_delivery_times`'; |
| Quantity discount | quantity_discount (NUMBER) | * select = 'p.`quantity_discount`'; |
| Customizable ? | customizable (BOOLEAN) | * select = 'IF (COALESCE(
ps.customizable, p.customizable ) > 0, 'true', 'false') as `customizable`'; |
| Uploadable files | uploadable_files (NUMBER) | * select = 'COALESCE(ps.uploadable_files, p.uploadable_files) as uploadable_files';
|
| Text fields | text_fields (NUMBER) | * select = 'COALESCE(ps.text_fields, p.text_fields) as text_fields';
|
| Active ? | active (BOOLEAN) | * select = 'IF (COALESCE(
ps.active, p.active ) > 0, 'true', 'false') as `active`'; |
| Available for order ? | available_for_order (BOOLEAN) | * select = 'IF (COALESCE(
ps.available_for_order, p.available_for_order ) > 0, 'true', 'false') as `available_for_order`'; |
| Available date | available_date (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(
COALESCE(ps.available_date, p.available_date), '%Y%m%d%H' ) as available_date'; |
| Show condition ? | show_condition (BOOLEAN) | * select = 'IF (COALESCE(
ps.show_condition, p.show_condition ) > 0, 'true', 'false') as `show_condition`'; |
| Condition | condition (TEXT) | * select = 'ps.`condition` as `condition`';
|
| Show price ? | show_price (BOOLEAN) | * select = 'IF (COALESCE(
ps.show_price, p.show_price ) > 0, 'true', 'false') as `show_price`'; |
| Indexed ? | indexed (BOOLEAN) | * select = 'IF (COALESCE(
ps.indexed, p.indexed ) > 0, 'true', 'false') as `indexed`'; |
| Visibility | visibility (TEXT) | * select = 'ps.visibility as visibility';
|
| is Pack ? (cache) | cache_is_pack (BOOLEAN) | * select = 'IF ((p.cache_is_pack) > 0, 'true', 'false') as `cache_is_pack`';
|
| has Attachments ? (cache) | cache_has_attachments (BOOLEAN) | * select = 'IF ((p.cache_has_attachments) > 0, 'true', 'false') as `cache_has_attachments`';
|
| has Combinations ? | has_combination (BOOLEAN) | * select = 'IF ((
SELECT COUNT(*) FROM `ps_product_attribute` hc WHERE hc.id_product = p.id_product ) > 0, 'true', 'false') as `has_combination`'; |
| Show condition ? | is_virtual (BOOLEAN) | * select = 'IF ((p.is_virtual) > 0, 'true', 'false') as `is_virtual`';
|
| Creation date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(COALESCE(ps.date_add, p.date_add), '%Y%m%d%H') as date_add';
|
| Update date | date_upd (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(COALESCE(ps.date_upd, p.date_upd), '%Y%m%d%H') as date_upd';
|
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = ps.id_shop'; |