Bạn có thể dễ dàng tạo một set quà độc đáo tặng riêng cho người ấy bằng 4 bước đơn giản sau. Bạn bấm "chọn quà này" mỗi món quà bạn thích sau đó đặt hàng nhé
Bước 1: Chọn Hộp
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (680)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`cataloginventory_stock_status`.`stock_status` = 1) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
Bước 2: Chọn Thiệp
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (681)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`cataloginventory_stock_status`.`stock_status` = 1) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
-
-
-
Thiệp Giáng Sinh Merry Christmas-Vuông gấp
Giá thường: 15.000 ₫
Special Price 10.000 ₫
Bước 3: Chọn Phụ kiện trong set
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (682)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`cataloginventory_stock_status`.`stock_status` = 1) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
Bước 4: Chọn Quà Lưu niệm
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (683)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`cataloginventory_stock_status`.`stock_status` = 1) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
Cốc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`e`.`entity_id` IN('6698', '6695', '6692', '6582', '6579')) AND (`cataloginventory_stock_status`.`stock_status` = 1) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
LuvGift Các set tạo sẵn
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (671)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id WHERE (`cataloginventory_stock_status`.`stock_status` = 1) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc