Banner1 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_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') 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

Brecknell(16)

DYMO by Pelouze(13)

Medline(1)

Rubbermaid Commercial(1)

 
Color(s)

Black/Silver(7)

Black(6)

Gray(5)

White(4)

Blue(2)

Pink(2)

Stainless Steel; White(1)

White; Gray(1)

Chrome(1)

Silver/White/Orange(1)

Stainless Steel(1)

 
Manufacturer Part Number

LPS400(1)

PB500(1)

GP250(1)

GP100(1)

40530(1)

B140(1)

PS25(1)

PS25BLUE(1)

PS7P(1)

S100300(1)

PS7B(1)

PS7(1)

PS25PINK(1)

PS400(1)

325(1)

311(1)

1776111(1)

1776112(1)

1772059(1)

1772057(1)

1772055(1)

1772056(1)

1776113(1)

1812588(1)

Y32R(1)

Y50(1)

P250S(1)

1812591(1)

1812589(1)

1812590(1)

MPH07SP1W(1)

 
Country of Origin

CN(31)

 
Power Source(s)

2 AAA Batteries (Included)(4)

USB Cable or 4 AAA Batteries (Both Included)(3)

AAA Batteries or AC Adapter(3)

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

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

3 AAA Batteries (Included)(2)

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

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

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

4 AAA Batteries (Included) or AC Adapter (Not Included)(1)

AC Adapter or 9V Battery (Both Included)(1)

AA Batteries or AC Adapter(1)

4 AA Batteries (Included)(1)

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

 
Weight Capacity

7 lbs; 3.2 kg(3)

2 lbs(2)

400 lbs; 181 kg(2)

0-1 kg; 1-12 kg; 0-1000 g; 1000-12000 g; 0-2 lb; 2-25 lb(2)

250 lbs(2)

10 lbs(2)

100 lbs; 45 kg(1)

60 lbs; 30 kg(1)

250 lbs; 110 kg(1)

300 lbs;150 kg(1)

0.1 g; 0.005 oz; 0.1 wt; 0.005 oz(1)

0-1kg; 1-12kg; 0-1000g; 1000-12000g; 0-2lb; 2-25lb(1)

30 lbs; 15 kg(1)

50 lbs(1)

100 lbs(1)

25 lbs(1)

5 lbs(1)

3 lbs(1)

400 lbs(1)

12 lbs(1)

11 lbs; 5 kg(1)

500 lbs(1)

32 oz(1)

25 lbs; 12 kg(1)

 
Electronic/Mechanical

Electronic(27)

Mechanical(4)

 
Platform Size

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

5 1/2" x 5 1/5"(3)

8" x 6"(3)

12" x 10"(2)

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

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

8" x 8"(2)

2 1/2" x 3"(1)

12" x 15"(1)

22" x 18"(1)

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

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

6" dia.(1)

10 1/2" x 13 1/4"(1)

6 2/5" x 5 4/5"(1)

7" x 7 5/8"(1)

6" x 6"(1)

6" x 4 3/4"(1)

6 1/2" x 8 1/8"(1)

3 1/4" x 13 1/4" x 14 1/4"(1)

9 1/2" x 8 1/2"(1)

 
Increments

0.1 oz(4)

0.02 kg; 0.2 oz(3)

10 g; 0.01 lb(3)

0.1 kg; 0.2 lb(2)

0.2 kg; 0.5 lb(2)

0.2 oz(2)

1 lb; 1 oz; 1 g(2)

1 g; 0.002 lb(1)

0.005 lbs(1)

0.005 oz; 0.1 g(1)

20 g; 0.05 lb(1)

2 oz(1)

0.005 lb, 0.1 oz, 1 g(1)

0.1 oz, 1/8 oz,1 g(1)

0.5 oz(1)

1 lb(1)

0.25 oz(1)

0.1 oz; 1 g(1)

4 oz(1)

0.1 oz; 2 g(1)

 
Scale Type

Postal(7)

Portion Control(5)

Postal/Freight(5)

Freight(5)

Utility(4)

Utility/Freight(2)

Utility/Postal(1)

Counting(1)

Beam(1)

 
Weight Units

Grams; Kilograms; Ounces; Pounds(7)

Grams; Pounds; Pounds/Ounces(7)

Kilograms; Pounds(5)

Grams; Kilograms; Pounds/Ounces(3)

Pounds(2)

Kilograms/Grams; Pounds/Ounces(2)

Ounces(1)

Grams; Ounces; Pennyweights; Troy Ounces(1)

Kilograms; Pounds; Pounds/Ounces(1)

Ounces; Pounds(1)

Grams; Kilograms; Ounces; Pounds; Pounds/Ounces(1)

 
Tare Feature

Yes(24)

No(2)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved