• My Account
  • Register
  • Compare Products
Shop
Wishlist
My Cart
Shop
Account
Return to Previous Page
x

Rainbow Collection

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '5' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5') LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (25071, 62979, 62983, 63019, 63021, 63022, 63023, 68001, 68003, 68004, 76738, 76750, 76751, 76752, 76753, 76754, 76755, 76781, 76782, 24925, 33899, 33937, 33955, 33980, 34064, 34233, 34236, 34307, 43274, 43277, 43307, 53308)) ORDER BY FIELD(e.entity_id,25071,62979,62983,63019,63021,63022,63023,68001,68003,68004,76738,76750,76751,76752,76753,76754,76755,76781,76782,24925,33899,33937,33955,33980,34064,34233,34236,34307,43274,43277,43307,53308)

Items 1-32 of 82

Set Ascending Direction
per page
Page
  1. Rainbow Hearts Hematite Bracelet
    Carrie Elspeth Rainbow Hearts Hematite Bracelet
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  2. Everyone Deserves To Sparkle Rainbow Sentiment Bracelet
    Carrie Elspeth Everyone Deserves To Sparkle Rainbow Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  3. Sending Positive Vibes Sentiment Bracelet
    Carrie Elspeth Sending Positive Vibes Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  4. Rainbow Miracle & Haematite Bracelet
    Carrie Elspeth Rainbow Miracle & Haematite Bracelet
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  5. Pinks Miracle & Haematite Earrings
    Carrie Elspeth Pinks Miracle & Haematite Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  6. Rainbow Miracle & Haematite Full Necklace
    Carrie Elspeth Rainbow Miracle & Haematite Full Necklace
    Special Price $40.50 Regular Price $45.00
    Add to Wish List Add to Compare
  7. Rainbow Miracle & Haematite Links Necklace
    Carrie Elspeth Rainbow Miracle & Haematite Links Necklace
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  8. Rainbow Carnival Bracelet
    Carrie Elspeth Rainbow Carnival Bracelet
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  9. Rainbow Carnival Full Necklace
    Carrie Elspeth Rainbow Carnival Full Necklace
    Special Price $33.30 Regular Price $37.00
    Add to Wish List Add to Compare
  10. Rainbow Carnival Links Necklace
    Carrie Elspeth Rainbow Carnival Links Necklace
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  11. Rainbow Strata Bracelet
    Carrie Elspeth Rainbow Strata Bracelet
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  12. Light Blue Strata Earrings
    Carrie Elspeth Light Blue Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  13. Royal Blue Strata Earrings
    Carrie Elspeth Royal Blue Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  14. Mustard Yellow Strata Earrings
    Carrie Elspeth Mustard Yellow Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  15. Green Strata Earrings
    Carrie Elspeth Green Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  16. Red Strata Earrings
    Carrie Elspeth Red Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  17. Lilac Strata Earrings
    Carrie Elspeth Lilac Strata Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  18. Rainbow Strata Links Necklace
    Carrie Elspeth Rainbow Strata Links Necklace
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  19. Rainbow Strata Spaced Necklace
    Carrie Elspeth Rainbow Strata Spaced Necklace
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  20. Rainbow Hearts Hematite Necklace
    Carrie Elspeth Rainbow Hearts Hematite Necklace
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  21. Rainbow Glow Necklace
    Carrie Elspeth Rainbow Glow Necklace
    Special Price $33.30 Regular Price $37.00
    Add to Wish List Add to Compare
  22. Picasso Rainbow Necklace
    Carrie Elspeth Picasso Rainbow Necklace
    Special Price $40.50 Regular Price $45.00
    Add to Wish List Add to Compare
  23. Picasso Rainbow Blue Earrings
    Carrie Elspeth Picasso Rainbow Blue Earrings
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  24. Picasso Rainbow Turquoise Earrings
    Carrie Elspeth Picasso Rainbow Turquoise Earrings
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  25. Picasso Rainbow Green Earrings
    Carrie Elspeth Picasso Rainbow Green Earrings
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  26. Picasso Rainbow Maroon Earrings
    Carrie Elspeth Picasso Rainbow Maroon Earrings
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  27. Rainbow Glow Earrings
    Carrie Elspeth Rainbow Glow Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  28. Picasso Rainbow Peach Earrings
    Carrie Elspeth Picasso Rainbow Peach Earrings
    Special Price $17.10 Regular Price $19.00
    Add to Wish List Add to Compare
  29. Myriad Full Bracelet
    Carrie Elspeth Myriad Full Bracelet
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  30. Myriad Earrings
    Carrie Elspeth Myriad Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  31. Myriad Links Necklace
    Carrie Elspeth Myriad Links Necklace
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  32. Rainbow Satin Cubes Links Necklace
    Carrie Elspeth Rainbow Satin Cubes Links Necklace
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare

Items 1-32 of 82

Set Ascending Direction
per page
Page
Trending In This Category
Rainbow Strata Bracelet
Rainbow Strata Bracelet
Special Price $24.30 Regular Price $27.00
Medley Globe Full 3 Piece Jewellery Set
Medley Globe Full 3 Piece Jewellery Set
Out of stock
Myriad Links Necklace
Myriad Links Necklace
Special Price $19.80 Regular Price $22.00
Rainbow Carnival Links Necklace
Rainbow Carnival Links Necklace
Special Price $19.80 Regular Price $22.00
Green Strata Earrings
Green Strata Earrings
Special Price $19.80 Regular Price $22.00
Red Strata Earrings
Red Strata Earrings
Special Price $19.80 Regular Price $22.00
Red/Orange Crystal Rainbow Earrings
Red/Orange Crystal Rainbow Earrings
Special Price $27.00 Regular Price $30.00
Out of stock
Rainbow Shimmer Drums Links Necklace
Rainbow Shimmer Drums Links Necklace
Special Price $27.00 Regular Price $30.00
Frosted Rainbow Necklace
Frosted Rainbow Necklace
Special Price $24.30 Regular Price $27.00
Out of stock
Ombre Haematites Discs Necklace
Ombre Haematites Discs Necklace
Special Price $33.30 Regular Price $37.00
Out of stock
closex
Filter Products
Filters
Product
  1. Bracelet 25 items
  2. Earrings 39 items
  3. Necklace 32 items
Price
Special Features
  1. Made in the UK 73 items
Colour
  1. Black 6 items
  2. Blue 10 items
  3. Green 7 items
  4. Grey 1 item
  5. Lilac 1 item
  6. Lime 1 item
  7. Maroon 1 item
  8. Metallic 3 items
  9. Multi 18 items
  10. Multi - Rainbow 39 items
  11. Orange 4 items
  12. Peach 1 item
  13. Pink 1 item
  14. Purple 4 items
  15. Red 10 items
  16. Silver 11 items
  17. Turquoise 2 items
  18. Yellow 3 items
Material
  1. Glass 3 items

Customer Service

Fast and secure payment with:
Secure Payment Options
Terms & Conditions
© 2023 - 2025