0

Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_4` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Calendars & Planners') AND (`category_3` LIKE 'Calendars & Refills') AND `pinfo`.`is_recycled` LIKE 'Y' AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Calendars Refills' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Calendars +Refills' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Calendars +Refills' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Calendars +Refills' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Refills',`category_4` ='Refills') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Refills,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Refills', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Calendars Refills

Refine Search

  GO
 
Brand

House of Doolittle(89)

At-A-Glance(22)

Rediform(21)

Blue Sky(20)

Brownline(16)

Blueline(5)

Dome(1)

Day-Timer(1)

 
Color

Black(28)

White(21)

Blue(19)

Multi(15)

Assorted(10)

Multicolor(8)

Gray(8)

Green(6)

Nature's Hues(5)

Gold(3)

Black/White(2)

Pink(2)

Red(2)

Light Blue(2)

Floral(2)

Teal(1)

Blue/Gray(1)

Tan(1)

Cream(1)

Sea Blue(1)

Orchid(1)

Navy(1)

Aqua(1)

Navy Tweed(1)

 
Binder Capacity

1"(1)

 
Recycled

Yes(170)

No(5)

 
Packaged Quantity

1 Each(170)

1 / Each(5)

 
Weight (Approximate)

8 oz(2)

6 oz(1)

9.76 oz(1)

13.44 oz(1)

1.92 lb(1)

13.92 oz(1)

3.68 oz(1)

1 lb(1)

5.60 oz(1)

15.84 oz(1)

4.80 oz(1)

14.88 oz(1)

7.68 oz(1)

14.08 oz(1)

13.30 oz(1)

10.56 oz(1)

 
Recycled Content

50%(1)

 
Date Format

Monthly(137)

Weekly(49)

Daily(39)

Yearly(8)

 
Sheet Color

White(5)

Blue(1)

Blue/Gray(1)

White/Blue(1)

 
Sheet Height

11"(34)

17"(23)

8"(10)

8 1/2"(9)

8 3/4"(7)

13"(7)

22"(5)

10 7/8"(4)

10"(4)

6"(3)

12"(3)

16 1/2"(3)

27"(2)

24"(2)

26"(2)

8 7/8"(1)

7 1/8"(1)

16"(1)

23 1/2"(1)

3 3/4"(1)

31 1/4"(1)

19"(1)

22 3/4"(1)

17 1/8"(1)

5"(1)

 
Start Month

January(121)

December(27)

July(18)

August(2)

June(1)

 
End Month

December(114)

January(33)

June(8)

August(7)

July(6)

February(1)

 
Cover Color

Black(32)

Blue(6)

Assorted(1)

Green(1)

Black Suede(1)

 
Start Year

2021(96)

2020(43)

 
End Year

2021(110)

2022(25)

2020(2)

2026(1)

 
Double Page Layout

1 Month(34)

1 Week(23)

1 Day(6)

2 Month(1)

 
Single Page Layout

1 Month(62)

3 Month(8)

1 Day(7)

1 Week(3)

2 Month(1)

 
Mount Type

Wall Mountable(43)

 
Cover Material

Leatherette(1)

 
Planner/Diary Type

Academic(12)

Academic/Professional(3)

Professional(2)

 
Enclosure

Elastic(1)

Chipboard(1)

 
Manufacturer Part Number

122200(1)

3640(1)

334(1)

337(1)

3395(1)

342(1)

343(1)

362(1)

3636(1)

3638(1)

3645(1)

331HD(1)

3646(1)

3648(1)

3731(1)

3732(1)

378(1)

393(1)

3974(1)

417(1)

332(1)

328(1)

50907(1)

28202(1)

264632(1)

265-02(1)

268-02(1)

272002(1)

27202(1)

272-07(1)

278-02(1)

27902(1)

28302(1)

327(1)

28774(1)

28802(1)

289632(1)

294-02(1)

294632(1)

296-02(1)

29799(1)

303(1)

4717(1)

78097(1)

26309(1)

CB634C-RED(1)

CB1200VBLK(1)

CB1262BLK(1)

CB1262C.BLK(1)

CB1262G02(1)

CB1262G03(1)

CB1262G04(1)

CB1262V.BLK(1)

CB435W.BLK(1)

CB634VBLK(1)

CB1200G03(1)

CB800BLK(1)

CB950.BLK(1)

CB950C.BLK(1)

CB950G01(1)

CB950G02(1)

CB950G03(1)

CB950G04(1)

CB950VBLK(1)

CB1200G04(1)

CB1200G01(1)

33995(1)

C181700(1)

A30C.81(1)

B4481(1)

C171101(1)

C171102(1)

C171121(1)

C172106(1)

C173106(1)

C173121(1)

C181700A(1)

CB1200.BLK(1)

C181721(1)

C181721A(1)

C2917001(1)

C2917311(1)

CA177227(1)

CA181721(1)

CA181731(1)

CA201BLK(1)

26402(1)

26308(1)

122905(1)

101711(1)

100004(1)

100009(1)

100079(1)

100087(1)

101555(1)

101613(1)

101633(1)

101707(1)

101714(1)

100001(1)

101716(1)

101718(1)

101971(1)

102132(1)

102142(1)

102411(1)

107924(1)

107925(1)

100003(1)

W6099707(1)

41745(1)

70-260G-05(1)

182905(1)

551200(1)

551905(1)

70-100G-05(1)

70100X05(1)

70-120G-05(1)

70120X05(1)

7021279(1)

70-260G-60(1)

SK32G-00(1)

70950E05(1)

70-950G-05(1)

70-950G-60(1)

D6099704(1)

E717R50(1)

PM11X28(1)

PM3G28(1)

PMG77-28(1)

40977(1)

0124(1)

26305(1)

2171-02(1)

178(1)

1786(1)

180-HD(1)

187(1)

1876(1)

1886(1)

193(1)

199(1)

239508(1)

175(1)

26002(1)

260602(1)

262002(1)

26202(1)

26207(1)

262502(1)

262602(1)

26302(1)

176(1)

174(1)

012540(1)

140HD(1)

122(1)

124(1)

12440(1)

124-43(1)

12473(1)

12502(1)

136(1)

1395(1)

1466(1)

172(1)

1467(1)

148(1)

1506(1)

150HD(1)

155(1)

1596(1)

164(1)

1646(1)

CF3409002(1)

 
Country of Origin

United States(107)

China(25)

Mexico(25)

Canada(13)

Malaysia(2)

Taiwan(1)

Brazil(1)

Indonesia(1)

 
Material

Paper(62)

Simulated Leather(27)

Leatherette(25)

Chipboard(16)

Poly(7)

Vinyl(7)

Leather(4)

Wood(1)

 
Height

17"(9)

11"(7)

13"(3)

12"(3)

10.9"(2)

8.5"(2)

27.1"(1)

6"(1)

11.4"(1)

11.3"(1)

16.5"(1)

9.1"(1)

26"(1)

8"(1)

7"(1)

8.4"(1)

9.3"(1)

 
Width

22"(6)

12"(5)

8.5"(5)

8"(3)

18.5"(3)

17.8"(2)

11"(1)

9"(1)

23.5"(1)

17"(1)

12.3"(1)

5.4"(1)

16.5"(1)

9.3"(1)

3.5"(1)

9.8"(1)

7.5"(1)

5.8"(1)

7.3"(1)

 
Depth

0.5"(1)

0.3"(1)

0.8"(1)

1"(1)

 
Sheet Size

5 1/2" Width x 8 1/2" Length(1)

 
Placement

Desk Pad(43)

Desktop(12)

Desk(1)

 
Fastener Type

Ring(1)

 
Number of Fasteners

7(1)

 
Binding Type

Wire Bound(59)

Twin Wire(38)

Spiral Bound(4)

Headband(2)

3-ring(2)

2-ring(1)

Gummed(1)

Sewn(1)

 
Sheet Width

8 1/2"(29)

22"(20)

11"(12)

12"(8)

18 1/2"(7)

5"(6)

8"(5)

6 7/8"(4)

7"(3)

17"(3)

4 7/8"(3)

15 1/2"(3)

3 1/2"(3)

12 1/4"(2)

15"(2)

8 1/4"(2)

8 3/4"(2)

9"(2)

21 1/4"(1)

17 3/4"(1)

60"(1)

8 7/8"(1)

37"(1)

10"(1)

20"(1)

24"(1)

36"(1)

22 1/5"(1)

5 1/2"(1)

7 1/8"(1)

 
Time Period

1 Year(104)

1.2 Year(30)

1.1 Year(11)

2 Year(2)

5.2 Year(1)

9 Month(1)

 
Number of Holes Punched

3(2)

2(1)

 
Julian Dates

Yes(133)

 
Sheet Quantity

12(6)

120(1)

14(1)

30(1)

6(1)

56(1)

192(1)

80(1)

 
 
 

© 2020-2021 CPS Office Products, All Rights Reserved