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

Browse All

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 (74751, 14523, 14524, 14525, 24925, 24926, 24993, 25016, 25020, 25071, 28420, 28421, 29003, 31126, 33310, 33314, 33899, 33937, 33955, 33980, 34014, 34236, 34307, 40110, 40121, 40240, 43277, 43307, 49586, 49596, 49614, 49623)) ORDER BY FIELD(e.entity_id,74751,14523,14524,14525,24925,24926,24993,25016,25020,25071,28420,28421,29003,31126,33310,33314,33899,33937,33955,33980,34014,34236,34307,40110,40121,40240,43277,43307,49586,49596,49614,49623)

Items 1-32 of 254

Set Ascending Direction
per page
Page
  1. ‘Granddaughters’ Sentiment Bracelet
    Carrie Elspeth ‘Granddaughters’ Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  2. Large Gift Box
    Carrie Elspeth Large Gift Box
    Special Price $5.40 Regular Price $6.00
    Add to Wish List Add to Compare
  3. Medium Gift Box
    Carrie Elspeth Medium Gift Box
    Special Price $3.60 Regular Price $4.00
    Add to Wish List Add to Compare
  4. Small Gift Box
    Carrie Elspeth Small Gift Box
    Special Price $3.60 Regular Price $4.00
    Add to Wish List Add to Compare
  5. 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
  6. Rainbow Hearts Hematite Earrings
    Carrie Elspeth Rainbow Hearts Hematite Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  7. Something Wonderful Sentiment Bracelet
    Carrie Elspeth Something Wonderful Sentiment Bracelet
    Special Price $20.80 Regular Price $26.00
    Add to Wish List Add to Compare
  8. Good Friends Sentiment Bracelet
    Carrie Elspeth Good Friends Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  9. Thank You Sentiment Bracelet
    Carrie Elspeth Thank You Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  10. 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
  11. Ocean Bohemian Earrings
    Carrie Elspeth Ocean Bohemian Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  12. Ocean Bohemian Bracelet
    Carrie Elspeth Ocean Bohemian Bracelet
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  13. Special Things You Do Sentiment Bracelet
    Carrie Elspeth Special Things You Do Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  14. You're Amazing Sentiment Bracelet
    Carrie Elspeth You're Amazing Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  15. You're a Star Sentiment Bracelet
    Carrie Elspeth You're a Star Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  16. A Guardian Angel Sentiment Bracelet
    Carrie Elspeth A Guardian Angel Sentiment Bracelet
    Special Price $23.40 Regular Price $26.00
    Add to Wish List Add to Compare
  17. Rainbow Glow Necklace
    Carrie Elspeth Rainbow Glow Necklace
    Special Price $33.30 Regular Price $37.00
    Add to Wish List Add to Compare
  18. Picasso Rainbow Necklace
    Carrie Elspeth Picasso Rainbow Necklace
    Special Price $40.50 Regular Price $45.00
    Add to Wish List Add to Compare
  19. 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
  20. 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
  21. Picasso Rainbow Bracelet
    Carrie Elspeth Picasso Rainbow Bracelet
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  22. Rainbow Glow Earrings
    Carrie Elspeth Rainbow Glow Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  23. 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
  24. Seven Chakra Unity Beaded Bracelet
    Carrie Elspeth Seven Chakra Unity Beaded Bracelet
    Special Price $24.30 Regular Price $27.00
    Add to Wish List Add to Compare
  25. Elongated Heart Earrings
    Carrie Elspeth Elongated Heart Earrings
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  26. Elongated Heart Pendant
    Carrie Elspeth Elongated Heart Pendant
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  27. Myriad Earrings
    Carrie Elspeth Myriad Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  28. Myriad Links Necklace
    Carrie Elspeth Myriad Links Necklace
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  29. Shell Hearts Spaced Necklace
    Carrie Elspeth Shell Hearts Spaced Necklace
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  30. Shell Hearts Bracelet
    Carrie Elspeth Shell Hearts Bracelet
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare
  31. Shell Hearts Duo Earrings
    Carrie Elspeth Shell Hearts Duo Earrings
    Special Price $19.80 Regular Price $22.00
    Add to Wish List Add to Compare
  32. Shell Hearts Links Necklace
    Carrie Elspeth Shell Hearts Links Necklace
    Special Price $27.00 Regular Price $30.00
    Add to Wish List Add to Compare

Items 1-32 of 254

Set Ascending Direction
per page
Page
closex
Filter Products
Filters
Product
  1. Bracelet 114 items
  2. Earrings 102 items
  3. Gift Box 3 items
  4. Necklace 97 items
Price
Special Features
  1. Made in the UK 204 items
Colour
  1. Amber 4 items
  2. Black 8 items
  3. Blue 45 items
  4. Bronze 1 item
  5. Brown 8 items
  6. Clear 8 items
  7. Copper 2 items
  8. Cream 10 items
  9. Gold 18 items
  10. Green 46 items
  11. Grey 3 items
  12. Ivory 9 items
  13. Lilac 1 item
  14. Lime 1 item
  15. Maroon 1 item
  16. Metallic 7 items
  17. Mint 1 item
  18. Multi 35 items
  19. Multi - Rainbow 52 items
  20. Orange 5 items
  21. Peach 1 item
  22. Pink 29 items
  23. Purple 17 items
  24. Red 13 items
  25. Rose Gold 5 items
  26. Silver 43 items
  27. Taupe 4 items
  28. Teal 7 items
  29. Turquoise 13 items
  30. White 4 items
  31. Yellow 7 items
Material
  1. Card 3 items
  2. Ceramics 1 item
  3. Glass 10 items
  4. Silver Plated 8 items
Occasion
  1. Christmas 2 items
Recipient
  1. Daughter 1 item
  2. Friend 3 items
  3. Girlfriend 1 item
  4. Grandchildren 1 item
  5. Grandparents 2 items
  6. Mum/Mother 2 items

Customer Service

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