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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12835 | eyeglasses | Single Vision | puma | 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 | f | 2025-01-20 11:28:34.975243+00 | t | t | 0 | 16 | 24990 | D,M,A,I | f | f | f | |||||
| 12834 | prescription-sunglasses | Gradient | puma | 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.975216+00 | t | t | 0 | 13 | 24990 | D,M,A,I | f | f | f | ||||||
| 12833 | prescription-sunglasses | Gradient | puma | 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.975185+00 | t | t | 0 | 12 | 24990 | D,M,A,I | f | f | f | ||||||
| 12832 | prescription-sunglasses | Gradient | puma | 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.975158+00 | t | t | 0 | 11 | 24990 | D,M,A,I | f | f | f | ||||||
| 12831 | prescription-sunglasses | Gradient | puma | 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 | 7000 | CR1.5TMIRSILMSP | 1.50 Mirror | SATINP | CR1.5TMIRSILMSP | 1.50 Mirror | SATINP | f | 2025-01-20 11:28:34.97513+00 | t | t | 0 | 10 | 24990 | D,M,A,I | f | f | f | ||||||
| 12830 | prescription-sunglasses | Gradient | puma | 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 | 7000 | CR1.5TMIRBLUSP | 1.50 Mirror | SATINP | CR1.5TMIRBLUSP | 1.50 Mirror | SATINP | f | 2025-01-20 11:28:34.975102+00 | t | t | 0 | 9 | 24990 | D,M,A,I | blue_cut | f | f | f | |||||
| 12829 | prescription-sunglasses | Gradient | puma | Blue Gradient | 1000 | 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 | 3000 | degblu | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.975074+00 | t | t | 0 | 8 | 24990 | D,M,A,I | f | f | f | |||||
| 12828 | prescription-sunglasses | Gradient | puma | Brown Gradient | 1000 | 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 | 3000 | Brown | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.975045+00 | t | t | 0 | 7 | 24990 | D,M,A,I | f | f | f | |||||
| 12827 | prescription-sunglasses | Gradient | puma | Gray Gradient | 1000 | 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 | 3000 | Gray | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | PL1.56SRX | 1.56 clear | SATINP,TINTGRADEL | t | 2025-01-20 11:28:34.975018+00 | t | t | 0 | 6 | 24990 | D,M,A,I | f | f | f | |||||
| 12826 | prescription-sunglasses | Gradient | puma | Blue Tinted | 1000 | 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 | 3000 | blu | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | t | 2025-01-20 11:28:34.97499+00 | t | t | 0 | 5 | 24990 | D,M,A,I | f | f | f | |||||
| 12825 | prescription-sunglasses | Gradient | puma | Brown Tinted | 1000 | 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 | 3000 | Brown | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | t | 2025-01-20 11:28:34.974963+00 | t | t | 0 | 4 | 24990 | D,M,A,I | f | f | f | |||||
| 12824 | prescription-sunglasses | Gradient | puma | Gray Tinted | 1000 | 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 | 3000 | Gray | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | t | 2025-01-20 11:28:34.974936+00 | t | t | 0 | 3 | 24990 | D,M,A,I | f | f | f | |||||
| 12823 | prescription-sunglasses | Basic | puma | Gray Tinted Sunglasses with Anti Glare | 1000 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.5 Index, Anti Scratch Coating, Both Side Anti Glare Coating, Both Side Anti Reflective Coating, UV Protection, Water & Dust Repellent | 3000 | Gray | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | f | 2025-01-20 11:28:34.974908+00 | t | t | 0 | 2 | 24990 | D,M,A,I | f | f | f | |||||
| 12822 | prescription-sunglasses | Basic | puma | Gray Tinted Sunglasses | 1000 | Avail Additional Offers on Checkout | 1 Year Warranty, 1.5 Index, Anti Scratch Coating, Both Side Anti Glare Coating, UV Protection | 3000 | Gray | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | PL1.56SRX | 1.56 clear | SATINP,TINTSOLID | t | 2025-01-20 11:28:34.974881+00 | t | t | 0 | 1 | 24990 | D,M,A,I | f | f | f |