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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1616 | eyeglasses | Single Vision | pierre cardin | Emclar Blue | 0 | 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 | 0 | PLBMX1.6SUV420 | 1.60 Blumax | NIL | PLBMX1.6SRX | 1.60 Blumax | SATINP | f | 2025-01-20 11:28:34.662916+00 | t | t | 0 | 15 | 24990 | D,M,A,I | blue_cut | Recommended | Gkb | f | f | f | |||
| 1615 | eyeglasses | Single Vision | pierre cardin | Photochromatic | 1000 | 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 | 1000 | PL156FTOGRSVHMC | 1.56 FOTOLENS GRAY | NIL | PL156FTOGRSVRX | 1.56 FOTOLENS GRAY | SATINP | f | 2025-01-20 11:28:34.662888+00 | t | t | 0 | 18 | 24990 | D,M,A,I | photochromatic | Gkb | f | f | f | ||||
| 1614 | eyeglasses | Single Vision | pierre cardin | Premium Anti Glare with UV Protection | 1400 | 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 | 1400 | 0 | PL1.56SPHHMCUV | 1.56 Clear | NIL | PL1.56SRX | 1.56 Clear | SATINP | f | 2025-01-20 11:28:34.662861+00 | t | t | 0 | 17 | 24990 | D,M,A,I | anti_glare | f | f | f | ||||
| 1613 | eyeglasses | Single Vision | pierre cardin | Non Anti Glare with Anti Scratch Coating | 760 | Avail Additional Offers on Checkout | 3 Months Warranty, 1.50 Index, Powers upto +/-3, Anti Scratch Coating | 760 | 0 | PL1.56SPHHMCUV | 1.56 Clear | NIL | PL1.56SRX | 1.56 Clear | SATINP | f | 2025-01-20 11:28:34.662833+00 | t | t | 0 | 19 | 24990 | D,M,A,I | anti_glare | f | f | f | ||||
| 1612 | eyeglasses | Single Vision | pierre cardin | Anti Glare Lenses | 0 | Avail Additional Offers on Checkout | 6 Months Warranty, Index 1.56, Powers upto +/-5, Anti Scratch Coating, Both Side Anti Glare Coating | 0 | PL1.56SPHHMCUV | 1.56 Clear | NIL | PL1.56SRX | 1.56 Clear | SATINP | t | 2025-01-20 11:28:34.662806+00 | t | t | 0 | 16 | 24990 | D,M,A,I | anti_glare | Value for Money | f | f | f | ||||
| 1611 | eyeglasses | Single Vision | pierre cardin | Non Anti Glare | 900 | Avail Additional Offers on Checkout | 3 Months Warranty, 1.50 Index, Powers upto +/-3 | 900 | 0 | CR1.5HT2 | 1.50 Clear | NIL | PL1.56SRX | 1.56 Clear | TC | f | 2025-01-20 11:28:34.662778+00 | t | t | 0 | 14 | 24990 | D,M,A,I | f | f | f | |||||
| 1610 | prescription-sunglasses | Gradient | pierre cardin | 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 | 6300 | NUPLGNSVRX | 1.50 Polarized | SATINP | NUPLGNSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.662751+00 | t | t | 0 | 13 | 24990 | D,M,A,I | f | f | f | ||||||
| 1609 | prescription-sunglasses | Gradient | pierre cardin | 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 | 6300 | NUPLBRSVRX | 1.50 Polarized | SATINP | NUPLBRSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.662723+00 | t | t | 0 | 12 | 24990 | D,M,A,I | f | f | f | ||||||
| 1608 | prescription-sunglasses | Gradient | pierre cardin | 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 | 6300 | NUPLGRSVRX | 1.50 Polarized | SATINP | NUPLGRSVRX | 1.50 Polarized | SATINP | f | 2025-01-20 11:28:34.662696+00 | t | t | 0 | 11 | 24990 | D,M,A,I | f | f | f | ||||||
| 1607 | prescription-sunglasses | Gradient | pierre cardin | Silver Mirror | 4200 | 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 | 4200 | CR1.5TMIRSILMSP | 1.50 Mirror | SATINP | CR1.5TMIRSILMSP | 1.50 Mirror | SATINP | f | 2025-01-20 11:28:34.662669+00 | t | t | 0 | 10 | 24990 | D,M,A,I | f | f | f | ||||||
| 1606 | prescription-sunglasses | Gradient | pierre cardin | Blue Mirror | 4200 | 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 | 4200 | CR1.5TMIRBLUSP | 1.50 Mirror | SATINP | CR1.5TMIRBLUSP | 1.50 Mirror | SATINP | f | 2025-01-20 11:28:34.662641+00 | t | t | 0 | 9 | 24990 | D,M,A,I | blue_cut | f | f | f | |||||
| 1605 | prescription-sunglasses | Gradient | pierre cardin | Blue Gradient | 1690 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.56 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 1690 | degblu | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.662614+00 | t | t | 0 | 8 | 24990 | D,M,A,I | f | f | f | |||||
| 1604 | prescription-sunglasses | Gradient | pierre cardin | Brown Gradient | 1690 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.56 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 1690 | Brown | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.662586+00 | t | t | 0 | 7 | 24990 | D,M,A,I | f | f | f | |||||
| 1603 | prescription-sunglasses | Gradient | pierre cardin | Gray Gradient | 1690 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.56 Index, Powers upto +/- 5, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 1690 | Gray | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.662559+00 | t | t | 0 | 6 | 24990 | D,M,A,I | f | f | f |