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

Currently Filtered by

Category

Scales

Refine Search

  GO
 
Brand

DYMO by Pelouze(8)

Brecknell(6)

Rubbermaid Commercial(1)

 
Color(s)

Black/Silver(7)

Black(3)

Silver/White(1)

Chrome(1)

Gray(1)

White; Gray(1)

Stainless Steel; White(1)

 
Manufacturer Part Number

1772055(1)

1772056(1)

1772057(1)

1772059(1)

1776111(1)

1776112(1)

1776113(1)

632SRWQ(1)

Y50(1)

311(1)

B140(1)

GP100(1)

GP250(1)

PS400(1)

S100300(1)

 
Country of Origin

CN(15)

 
Power Source(s)

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

3 AAA Batteries (Included)(2)

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

4 AA Batteries (Included)(1)

Rechargeable Battery and AC Adapter (Both 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

3 lbs(1)

5 lbs(1)

10 lbs(1)

25 lbs(1)

100 lbs(1)

250 lbs(1)

400 lbs(1)

32 oz(1)

50 lbs(1)

11 lbs; 5 kg(1)

60 lbs; 30 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)

Mechanical(2)

 
Platform Size

11 4/5" x 11 4/5"(3)

5 9/10" x 5 9/10"(2)

8" x 8"(2)

12" x 10"(2)

7" x 5"(1)

6" x 4 3/4"(1)

6" dia.(1)

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

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

22" x 18"(1)

 
Increments

0.1 oz(4)

0.2 oz(2)

0.2 kg; 0.5 lb(2)

0.5 oz(1)

0.25 oz(1)

2 oz(1)

0.1 oz; 1 g(1)

1 g; 0.002 lb(1)

0.1 kg; 0.2 lb(1)

20 g; 0.05 lb(1)

 
Scale Type

Postal(4)

Freight(4)

Utility/Freight(2)

Utility(2)

Portion Control(1)

Postal/Freight(1)

Counting(1)

 
Weight Units

Grams; Kilograms; Ounces; Pounds(7)

Kilograms; Pounds(5)

Ounces(1)

Ounces; Pounds(1)

Pounds/Ounces;Kilograms/Grams(1)

 
Tare Feature

Yes(14)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved