SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` 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=1102
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
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '70') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '70') AND (`at_name`.`store_id` = 1) ORDER BY `name` ASC, `e`.`entity_id` DESC
LIMIT 9
Shop By
Shopping Options
Flap Style
Finish
Envelope Color
Manufacturer
Weight
- 100C 13 items
- 100T 8 items
- 11.2PT 1 item
- 110C 3 items
- 110CB 1 item
- 111C 2 items
- 12.4PT 1 item
- 120C 4 items
- 120DTC 2 items
- 130C 1 item
- 130CB 1 item
- 130DTC 3 items
- 134C 1 item
- 160DTC 1 item
- 179C 1 item
- 220DTC 1 item
- 24W 15 items
- 28W 3 items
- 32W 1 item
- 60T 2 items
- 65C 4 items
- 70T 17 items
- 80C 18 items
- 80T 16 items
- 88CB 1 item
- 9.5PT 1 item
- 90C 6 items
Paper Color
Color
- 700 High White 3 items
- Albatross 1 item
- Atoll 1 item
- Azure 1 item
- Azure Blue 3 items
- Baltic Sea 1 item
- Basalt 1 item
- Beet 1 item
- Biscuit 1 item
- Black 3 items
- Blackberry 1 item
- Blazer Blue 6 items
- Bright White 11 items
- Camel 1 item
- Cappuccino 1 item
- Caribbean Blue 1 item
- Carmine 1 item
- Chalk 1 item
- Chili Pepper 1 item
- China White 1 item
- Chino 1 item
- Cobblestone 1 item
- Coral 1 item
- Cream White 18 items
- Deep Black 1 item
- Deep Blue 1 item
- Desert Haze 2 items
- Ecru White 6 items
- Eggplant 4 items
- Fluorescent White 18 items
- Forest Green 1 item
- Glacier Mist 1 item
- Grey Fog 1 item
- Guardsman Red 1 item
- Holly 1 item
- Indian Yellow 1 item
- Ivory 15 items
- Kiwi 1 item
- Lichen 1 item
- Lipstick 1 item
- Mahogany 1 item
- Matcha Tea 1 item
- Meadow 1 item
- Midnight Black 2 items
- Moonstone Grey 3 items
- Natural White 20 items
- Navy Blue 1 item
- New Black 4 items
- Old Rose 1 item
- Orchid 1 item
- Pastel Blue 1 item
- Pastel Green 1 item
- Pastel Pink 1 item
- Pearl White 17 items
- Port Wine 1 item
- Prune 1 item
- Pumpkin 1 item
- Pure White 20 items
- Radiant White 8 items
- Recycled Bright White 3 items
- Red 3 items
- Rosebud 1 item
- Royal Blue 1 item
- Sand Stone 1 item
- Sandstone 2 items
- Sea Spray 2 items
- Seal 1 item
- Sequoia 1 item
- Smoke Gray 3 items
- Snow White 1 item
- Soft Blue 3 items
- Soft Gray 5 items
- Soft White 9 items
- Softwhite 14 items
- Sombre Grey 1 item
- Steel 1 item
- Stellar White 2 items
- Ultawhite 1 item
- Ultimate White 14 items
- Ultrawhite 19 items
- Warm White 8 items
- White 32 items
- Yellow 1 item
Paper Size
- 11 X 17 34 items
- 11 x 8.5 13 items
- 12 X 12 7 items
- 12 X 18 37 items
- 13 X 19 10 items
- 17 X 11 8 items
- 18 X 12 19 items
- 19 X 13 14 items
- 20 X 26 1 item
- 20.75 X 29.4375 5 items
- 22 X 30 1 item
- 23 X 29 1 item
- 23 X 35 43 items
- 25 X 38 22 items
- 26 X 20 5 items
- 26 X 40 46 items
- 27.5 X 39.3 1 item
- 28 X 40 4 items
- 29.4375 X 20.75 7 items
- 35 X 23 20 items
- 38 X 25 1 item
- 8.5 X 11 46 items
- 8.5 x 11-Mixed 14 items
- A-1 CARD 1 item
- A-1 FOLDER 1 item
- A-2 CARD 6 items
- A-2 FOLDER 1 item
- A-6 CARD 3 items
- A-6 FOLDER 3 items
- A-7 CARD 5 items
- A-7 FOLDER 4 items
Brand
- Carnival Cordwain 1 item
- Crane's Bond 6 items
- Crane's Crest 13 items
- Crane's Lettra 6 items
- Everyday Digital Gloss 5 items
- Everyday Digital Silk 5 items
- Everyday Digital Uncoated 9 items
- Keaykolour 1 item
- Mohawk Carnival 4 items
- Mohawk Carnival Felt 2 items
- Mohawk Chromolux 3 items
- Mohawk Loop Smooth 2 items
- Mohawk Superfine Eggshell 9 items
- Mohawk Superfine Smooth 12 items
- Mohawk Via Felt 7 items
- Mohawk Via Linen 7 items
- Mohawk Via Smooth 7 items
- Mohawk Via Vellum 8 items
- Strathmore Premium Cambric 4 items
- Strathmore Premium Enhance 2 items
- Strathmore Premium Grandee 2 items
- Strathmore Premium Supersmooth 5 items
- Strathmore Premium Wove 5 items
- Strathmore Pure Cotton 1 item
- Strathmore Writing 5 items
Unit of Measure
Envelope Size
- 5" × 5" 13 items
- 5½in Sqr 1 item
- 6½ Sqr 1 item
- 6½ Sqr Deep 2 items
- A-1 3 items
- A-1 Deep 3 items
- A-10 6 items
- A-10 Thin 1 item
- A-2 8 items
- A-2 Deep 4 items
- A-2 Thin 2 items
- A-6 9 items
- A-6 Deep 1 item
- A-6 Thin 3 items
- A-7 9 items
- A-7 Deep 3 items
- A-7 Plus Deep 1 item
- A-7 Plus Square 1 item
- A-7 Thin 2 items
- A-8 6 items
- A-8 Thin 1 item
- A-9 2 items
- A-9 Deep 1 item
- No 10 Commercial 9 items
- No 10 Peel-N-Seal 2 items
- No 10 Pointed 3 items
- No 10 Square 8 items
- No 8 2 items