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_1` 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_id` IN ('60271')) 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 '%MailroomScales' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MailroomScales' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MailroomScales' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MailroomScales"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MailroomScales"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MailroomScales"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MailroomScales"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MailroomScales' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MailroomScales',`category_4` ='MailroomScales') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MailroomScales,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MailroomScales', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Mailroom Scales

Refine Search

  GO
 
Brand

Brecknell(7)

DYMO by Pelouze(6)

 
Color(s)

Black/Silver(6)

Black(3)

Gray(1)

White; Gray(1)

Silver(1)

Stainless Steel; White(1)

 
Manufacturer Part Number

1772056(1)

1772057(1)

1772059(1)

1776111(1)

1776112(1)

1776113(1)

311(1)

B140(1)

DSB4848-05(1)

GP100(1)

GP250(1)

PS400(1)

S100300(1)

 
Country of Origin

CN(13)

 
Power Source(s)

USB Cable (Included), AC Adapter (Included) or 3 AAA Batteries (Sold Separately)(3)

USB Cable (Included) or 3 AAA Batteries (Sold Separately)(2)

3 AAA Batteries (Included)(1)

4 AA Batteries (Included)(1)

Rechargeable Battery and AC Adapter (Both Included)(1)

AC Adapter (Included)(1)

AC Adapter (Sold Separately) or 9V Battery (Included).(1)

AC Adapter (Included) or 9V Battery (Sold Separately).(1)

AC Adapter or 6 AA batteries (Both Included)(1)

Rechargeable Lead-Acid Battery and AC Adapter (Both Included)(1)

 
Weight Capacity

5 lbs(1)

10 lbs(1)

25 lbs(1)

100 lbs(1)

250 lbs(1)

400 lbs(1)

11 lbs; 5 kg(1)

60 lbs; 30 kg(1)

5000 lbs; 2500 kg(1)

100 lbs; 45 kg(1)

250 lbs; 110 kg(1)

400 lbs; 181 kg(1)

300 lbs;150 kg(1)

 
Electronic/Mechanical

Electronic(13)

 
Platform Size

11.8 x 11.8(3)

8 x 8(2)

12 x 10(2)

5.9 x 5.9(1)

6" dia.(1)

11 1/2" x 8 3/4"(1)

48" x 48"(1)

12 1/5" x 11 7/10"(1)

22" x 18"(1)

 
Increments

0.1 oz(3)

0.2 oz(2)

0.2 kg; 0.5 lb(2)

0.5 oz(1)

0.1 oz; 1 g(1)

1 g; 0.002 lb(1)

1 lb(1)

0.1 kg; 0.2 lb(1)

20 g; 0.05 lb(1)

 
Scale Type

Freight(4)

Postal(3)

Utility/Freight(2)

Utility(2)

Postal/Freight(1)

Counting(1)

 
Weight Units

Grams; Kilograms; Ounces; Pounds(6)

Kilograms; Pounds(6)

Pounds/Ounces;Kilograms/Grams(1)

 
Tare Feature

Yes(13)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved