Register Login
| +911234567890 | info@trisco.in
Trisco.in
select prod_id,company_price, prod_name, friendly_name, prod_cat_name, products.cat_id, prod_maincat_name,brand_name, sku, image_path, prod_shipping_cost, products.date_added, price, avail_status , products.sort_order , prod_desc, upper(products.is_active) is_active, upper(products.is_featured) is_featured, pc.prod_cat_friendly_name , prod_maincat_friendly_name, product_rating, product_rating_count, products.tax_id, tax_name, coalesce(tax_percent,0) tax_percent, products.quantity_in_stock, is_offer, offer_discount_percent, offer_start_date, offer_end_date, if ( products.offer_start_date <= now() , if( products.offer_end_date >= now() , 1, 0 ) , 0 ) is_valid_offer, is_offer_active, get_prod_mrp( prod_id ) prod_mrp, get_prod_discount_amount( prod_id ) disc_amt, has_prod_discount( prod_id ) has_discount, has_product_variation_combination( products.prod_id) has_vc, get_variation_combination_with_least_price_for_product( products.prod_id) vc_with_min_price, get_price_for_prod_variation_combination(prod_id , get_variation_combination_with_least_price_for_product( products.prod_id)) price_for_min_vc, get_variation_combination_with_max_stock_for_product( products.prod_id) vc_with_max_stock, get_stock_for_prod_variation_combination(prod_id , get_variation_combination_with_max_stock_for_product( products.prod_id)) stock_for_max_vc from product_categories pc, product_maincategories pmc , products left join taxes on products.tax_id = taxes.tax_id left join product_subcategories ps on products.prod_subcat_id = ps.prod_subcat_id left join product_brands pb on products.brand_id = pb.brand_id where products.cat_id = pc.prod_cat_id and avail_status = 1 and upper(products.is_active) = 'Y' and pc.pc_maincat_id = pmc.prod_maincat_id and pc.is_active = 'Y' and pmc.prod_maincat_is_active = 'Y' order by offer_discount_percent desc
Blood Pressure Monitor Endo Dental General Dental Ortho Dental Pereo Dental Prostho Dental Pedo Dental OS Dental Home Care Accessories Wheel Chair Commods Accessories Dental Materials Respiratory Care Clinical Products Diposable Orthopedic Medical Care Cardio Diabetice Care Hand Sanitizer Face Mask Hand Gloves PPE Kit Face Shield Infrared Thermometer Covid Hospital Furniture Thermometers Nebulizer Water Bed Pulse Oximeter Sanitary And Hygiene Glucometers
FACE MASK 3 PLY TIE

Face Mask 3 Ply Tie

0.00
Body Wipes Medibath

Body Wipes Medibath

90.00
AIR BED DR.ODIN

Air Bed Dr.odin

2,200.00
Pull up pad - 10 Nos - B-FIT MEDIUM

Pull Up Pad - 10 Nos - B-fit Medium

480.00
Under Pad - 10 Nos - FRIENDS

Under Pad - 10 Nos - Friends

240.00
Adult Diaper XL - 10 Nos - FRIENDS

Adult Diaper Xl - 10 Nos - Friends

350.00
Adult Diapers Large -10 Nos - FRIENDS

Adult Diapers Large -10 Nos - Friends

320.00
Adult Diapers Medium - 10 Nos - FRIENDS

Adult Diapers Medium - 10 Nos - Friends

300.00
Infra Red Lamp

Infra Red Lamp

750.00
Finger tip Pulse Oxymeter Lifeline

Finger Tip Pulse Oxymeter Lifeline

1,400.00
Finger tipPulse oxymeter Amkay

Finger Tippulse Oxymeter Amkay

1,350.00
Finger tip Pulse oxymeter Dr.Odin

Finger Tip Pulse Oxymeter Dr.odin

1,400.00
Finger Tip Pluse Oxymeter

Finger Tip Pluse Oxymeter

0.00
Waterbed Medcure

Waterbed Medcure

2,465.00
Waterbed Unicare

Waterbed Unicare

1,500.00
Water Bed Safe Touch

Water Bed Safe Touch

1,350.00
Water Bed GME

Water Bed Gme

0.00
DIGITAL THERMOMETER OMRON 246C

Digital Thermometer Omron 246c

180.00
DIGITAL THERMOMETER DR.ODIN

Digital Thermometer Dr.odin

0.00
DIGITAL THERMOMETER LIFE LINE FLEXI TIP

Digital Thermometer Life Line Flexi Tip

150.00
DIGITAL BP MONITOR DR.ODIN B12

Digital Bp Monitor Dr.odin B12

1,350.00
TS 209 BED SIDE LOCKER STANDARD

Ts 209 Bed Side Locker Standard

2,900.00
TS 517 ABS MANUAL ONE CRANK BED

Ts 517 Abs Manual One Crank Bed

13,500.00
DIGITAL B.P.MONITOR CH 432 CITIZEN

Digital B.p.monitor Ch 432 Citizen

1,500.00
TS 517 A SEMI FOWLER BED BACKREST BED 1 FUNCTION (Deluxe)

Ts 517 A Semi Fowler Bed Backrest Bed 1 Function (deluxe)

24,200.00
DIGITAL B.P.MONITOR LIFELINE BETA

Digital B.p.monitor Lifeline Beta

2,200.00
TS 205 WARD BED

Ts 205 Ward Bed

6,844.00
DIGITAL B.P.MONITOR HEM 7130 OMRON

Digital B.p.monitor Hem 7130 Omron

2,800.00
INFRA RED THERMOMETER

Infra Red Thermometer

0.00
FACE MASK 3 PLY ELASTIC

Face Mask 3 Ply Elastic

0.00
DIGITAL BP MONITOR HEM 8712 OMRON

Digital Bp Monitor Hem 8712 Omron

2,300.00
FACE MASK N 95 Oxygen

Face Mask N 95 Oxygen

0.00
DIGITAL BP MONITOR HEM 7121 J OMRON

Digital Bp Monitor Hem 7121 J Omron

1,900.00
FULL BODY COVER

Full Body Cover

0.00
Hand Sanitizer 500 ML

Hand Sanitizer 500 Ml

0.00
WEIHGING MACHINE OMRON HN 289

Weihging Machine Omron Hn 289

1,900.00
FACE SHIELD

Face Shield

0.00
Hand Sanitizer 100 ML

Hand Sanitizer 100 Ml

0.00
WEIHGING MACHINE OMRON HN 286

Weihging Machine Omron Hn 286

2,100.00
PPE KIT 10015

Ppe Kit 10015

0.00
Hand Sanitizer 50 ML

Hand Sanitizer 50 Ml

0.00
NEBULISER OMRON NEC 302

Nebuliser Omron Nec 302

2,600.00
PPE KIT

Ppe Kit

0.00
Accu Check Active - 10 strip Free

Accu Check Active - 10 Strip Free

1,500.00
NEBULISER OMRON NEC 101

Nebuliser Omron Nec 101

2,600.00
HAND GLOVES (STERILE)

Hand Gloves (sterile)

0.00
Accu Check Instant - 10 strip Free

Accu Check Instant - 10 Strip Free

1,000.00
NEBULISER LIFELINE Mini

Nebuliser Lifeline Mini

0.00
HAND GLOVES (NON-STERILE)

Hand Gloves (non-sterile)

0.00
One Touch Verio - Johnson And Johnson - 10 strip Free

One Touch Verio - Johnson And Johnson - 10 Strip Free

1,650.00
NEBULISER DR.ODIN OD 303

Nebuliser Dr.odin Od 303

1,350.00
HAND GLOVES (EXAMINATION)

Hand Gloves (examination)

0.00
FACE MASK 2 PLY TIE

Face Mask 2 Ply Tie

0.00
One Touch Select Plus - Johnson And Johnson - 10 strip Free

One Touch Select Plus - Johnson And Johnson - 10 Strip Free

899.00
AIR BED K-LIFE

Air Bed K-life

2,100.00
FACE MASK 2 PLY ELASTIC

Face Mask 2 Ply Elastic

0.00
Body Wipes Ecobath

Body Wipes Ecobath

85.00
AIR BED LIFELINE

Air Bed Lifeline

2,200.00