search
web_lenses
| id | primarycategory | main_category | brand | sub_category | selling_price | offer | features | price | coating | prodcodestock | prodlabelstock | prodcoatingcode | prodcoderx | productlabelrx | productcoatingcode | active | created | rx_required | xml_required | coating_charge | lens_ranking | blocked_shapes | max_product_price | platform_visible | buy_two_price | tag | usp | lens_brand | is_lens_free | is_retail | is_pos |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1224 | eyeglasses | Single Vision | mirar | Thinnest Lens (1.74 Index) | 5000 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.74, Powers upto +/-12, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water and Dust Repellent, Breakage & Crack Resistant | 16000 | 0 | PL1.74ASHMC | 1.74A Clear | NIL | SEKOPL1.74RX | 1.74A Clear | SATINP | f | 2025-01-20 11:28:34.652032+00 | t | t | 0 | 24 | 1790 | D,M,A,I | thin_lens | Emclar | f | f | f | |||
| 1223 | eyeglasses | Single Vision | mirar | Unbreakable Anti Glare Lenses | 1200 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.59, Powers upto +/-5, Blue Light Blocker, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water and Dust Repellent, Breakage & Crack Resistant | 5000 | 0 | PCSVRX | 1.59 Poly Clear | SATINPBL | PCSVRX | 1.59 Poly Clear | SATINPBL | f | 2025-01-20 11:28:34.652005+00 | t | t | 0 | 23 | 1790 | D,M,A,I | anti_glare | f | f | f | ||||
| 1222 | eyeglasses | Single Vision | mirar | Color Blind | 13000 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.50, Powers upto +/-8, Enhances Red & Green Colour Perception, For people with Colour Blindness. Results may vary from Person to Person | 15000 | 0 | COLB1.6FF1SVRX | 1.60 Color Blind 1 | SATINP | COLB1.6FF1SVRX | 1.60 Color Blind 1 | SATINP | f | 2025-01-20 11:28:34.651978+00 | t | t | 0 | 22 | 1790 | D,M,A,I | f | f | f | |||||
| 1221 | eyeglasses | Single Vision | mirar | Emclar Blue Pro | 1000 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.56, Powers upto +/-8, Blue Light Blocker, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water and Dust Repellent | 3000 | 0 | PLBMX1.6SUV420 | 1.60 Blumax | NIL | PLBMX1.6SRX | 1.60 Blumax | SATINP | f | 2025-01-20 11:28:34.651947+00 | t | t | 0 | 21 | 1790 | D,M,A,I | blue_cut | Top Seller | Emclar | f | f | f | ||
| 1220 | eyeglasses | Single Vision | mirar | Emclar Thin Blue | 1500 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.60, Powers upto +/-10, Blue Light Blocker, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water and Dust Repellent, Breakage & Crack Resistant | 4000 | 0 | PLBMX1.6SUV420 | 1.60 Blumax | NIL | PLBMX1.6SRX | 1.60 Blumax | SATINP | t | 2025-01-20 11:28:34.65192+00 | t | t | 0 | 20 | 1790 | D,M,A,I | blue_cut | Recommended | Emclar | f | f | f | ||
| 1219 | eyeglasses | Single Vision | mirar | Emclar Blue | 800 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.56, Powers upto +/-7, Blue Light Blocker, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating | 3000 | PLBMX1.5SUVULHMCP | 1.50 Blumax | NIL | PLBMX1.56SRX | 1.56 Blumax | SATINP | t | 2025-01-20 11:28:34.651892+00 | t | t | 0 | 15 | 1790 | D,M,A,I | blue_cut | f | f | f | |||||
| 1218 | eyeglasses | Single Vision | mirar | Photochromatic | 1500 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.56, Powers upto +/-7, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water and Dust Repellent | 3000 | PL156FTOGRSVHMC | 1.56 FOTOLENS GRAY | NIL | PL156FTOGRSVRX | 1.56 FOTOLENS GRAY | SATINP | f | 2025-01-20 11:28:34.651865+00 | t | t | 0 | 18 | 1790 | D,M,A,I | photochromatic | f | f | f | |||||
| 1217 | eyeglasses | Single Vision | mirar | Premium Anti Glare with UV Protection | 550 | Avail Additional Offers on Checkout | 1 Year Warranty, Index 1.56, Powers upto +/-5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection | 3000 | 0 | PL1.56SPHHMCUV | 1.56 Clear | NIL | PL1.56SRX | 1.56 Clear | SATINP | f | 2025-01-20 11:28:34.651837+00 | t | t | 0 | 17 | 1790 | D,M,A,I | anti_glare | f | f | f | ||||
| 1216 | eyeglasses | Single Vision | mirar | Non Anti Glare with Anti Scratch Coating | 450 | Avail Additional Offers on Checkout | 3 Months Warranty, 1.50 Index, Powers upto +/-3, Anti Scratch Coating | 1100 | 0 | CR1.5HT2 | 1.50 Clear | NIL | PL1.56SRX | 1.56 Clear | TC | f | 2025-01-20 11:28:34.65181+00 | t | t | 0 | 19 | 1790 | D,M,A,I | anti_glare | f | f | f | ||||
| 1215 | eyeglasses | Single Vision | mirar | Anti Glare Lenses | 500 | Avail Additional Offers on Checkout | 6 Months Warranty, Index 1.56, Powers upto +/-5, Anti Scratch Coating, Both Side Anti Glare Coating | 1500 | PL1.56SPHHMCUV | 1.56 Clear | NIL | PL1.56SRX | 1.56 Clear | SATINP | t | 2025-01-20 11:28:34.651783+00 | t | t | 0 | 16 | 1790 | D,M,A,I | anti_glare | f | f | f | |||||
| 1214 | eyeglasses | Single Vision | mirar | Non Anti Glare | 0 | Avail Additional Offers on Checkout | 3 Months Warranty, 1.50 Index, Powers upto +/-3 | 1000 | 0 | CR1.5HT2 | 1.50 Clear | NIL | PL1.56SRX | 1.56 Clear | TC | t | 2025-01-20 11:28:34.651755+00 | t | t | 0 | 14 | 1790 | D,M,A,I | f | f | f | |||||
| 1213 | prescription-sunglasses | Gradient | mirar | Green Polorized | 6300 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.50 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 9000 | NUPLGNSVRX | 1.50 Polarized | SATINP | NUPLGNSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.651728+00 | t | t | 0 | 13 | 1790 | D,M,A,I | f | f | f | ||||||
| 1212 | prescription-sunglasses | Gradient | mirar | Brown Polorized | 6300 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.50 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 9000 | NUPLBRSVRX | 1.50 Polarized | SATINP | NUPLBRSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.6517+00 | t | t | 0 | 12 | 1790 | D,M,A,I | f | f | f | ||||||
| 1211 | prescription-sunglasses | Gradient | mirar | Gray Polorized | 6300 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.50 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 9000 | NUPLGRSVRX | 1.50 Polarized | SATINP | NUPLGRSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.651673+00 | t | t | 0 | 11 | 1790 | D,M,A,I | f | f | f |