Show Schedule | Testimonials | bestingems@gmail.comEmail | Phone614-742-7466| Login| Signup
FREE SHIPPING (NO MINIMUM)
Cart   Icon
Collections

Get Instant Update On Discounts,
Special Sales & New Arrivals


( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1002' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Gemstones
View All
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1004' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Drops & Beads
View All
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1005' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Jewelry
View All
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1006' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Semi-Mounts
View All
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1007' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='dha6m1hdrasvp54ovrl5dcm991' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Findings
View All
Gemstone Jewelry

testimonial


Happy Clients
Why Choose Us?

Free Delivery
Free Shipping
(U.S.A Only)
Easy Returns
Easy Returns
Happy Customers
2.5k Happy Customers
Secured Payments
Secured Payment
Huge Variety
Huge Variety
Transparent Pricing
Transparent Pricing
Free Delivery
Free Shipping
(U.S.A Only)
Easy Returns
Easy Returns
Happy Customers
2.5k Happy Customers
Secured Payments
Secured Payment
Huge Variety
Huge Variety
Transparent Pricing
Transparent Pricing
Free Delivery Easy Returns
Free Shipping
Easy Returns
Happy Customers Secure Payment
Happy Customers
Secured Payment
Huge Variety Transparent Pricing
Huge Variety
Transparent Pricing
Birthstone of the Month