#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Surfer Girl Beach Beads Set

by Creativity For Kids


Problem with item sku 74086. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a12510 12510&wt=json&indent=on&fl=*&rows=1000&fq=group_id:12510&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 15925,23407,25117,28597,30501,31473,44137,46343,47939,56419,60138,66968,67339,67365,68646,70541,73096,73460,75670,78744,79777,80904,85773,87668,87776
AvailQtyList: 3.000000000000,6.000000000000,5.000000000000,2.000000000000,11.000000000000,6.000000000000,6.000000000000,1.000000000000,7.000000000000,8.000000000000,6.000000000000,15.000000000000,4.000000000000,8.000000000000,8.000000000000,9.000000000000,4.000000000000,8.000000000000,4.000000000000,6.000000000000,6.000000000000,6.000000000000,7.000000000000,4.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 092633156100
barcode_type UPC
col1 each
col1_sortorder 340
col2 [empty string]
col3 [empty string]
cost 9.76
deal_of_the_week NO
description each
group_id 12510
group_uname creativity-for-kids-surfer-girl-beach-beads-set
id 74086
list_price 20
map NO
mfr_num 1561
net_weight 0.79
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 74086
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 10.8
ta_price 16
text
array
1 74086
2 1561
3 each
timestamp 2015-03-27T14:48:04.224Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 15925
2 6.000000000000 23407
3 5.000000000000 25117
4 2.000000000000 28597
5 11.000000000000 30501
6 6.000000000000 31473
7 6.000000000000 44137
8 1.000000000000 46343
9 7.000000000000 47939
10 8.000000000000 56419
11 6.000000000000 60138
12 15.000000000000 66968
13 4.000000000000 67339
14 8.000000000000 67365
15 8.000000000000 68646
16 9.000000000000 70541
17 4.000000000000 73096
18 8.000000000000 73460
19 4.000000000000 75670
20 6.000000000000 78744
21 6.000000000000 79777
22 6.000000000000 80904
23 7.000000000000 85773
24 4.000000000000 87668
25 3.000000000000 87776
CACHED false
EXECUTIONTIME 8
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1276' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.211.236.52

URL: www.misterart.com:/index.cfm:module=gift-ideas&catB=for-the-kids&gr=creativity-for-kids-surfer-girl-beach-beads-set.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:18:12'}
sessionid e0309ea352ca60d267261f753c3a4a202b4e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~fp~6-9~c1~crafts~c2~textiles-dyes~c3~fabric-paints~&gr=createx-acrylic-colors.html
urltoken CFID=29432183&CFTOKEN=83621738&jsessionid=e0309ea352ca60d267261f753c3a4a202b4e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:18:12'}
sessionid e0307507076520cf4dd54d246737f7462415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=gift-ideas&catB=for-the-kids&gr=creativity-for-kids-surfer-girl-beach-beads-set.html
urltoken CFID=29432182&CFTOKEN=30503433&jsessionid=e0307507076520cf4dd54d246737f7462415
validationerror [empty string]


This deluxe bead set features more shells, more beads, and even more fun. Combine these mix and match components to create a jewelry box full of beach inspired bracelets, anklets, and necklaces. The set includes real shells, a bounty of beads, cool cord, jewelry findings, and easy-to-follow instructions.

For ages 8 +

Share on Facebook Twitter Pinterest

Ask a question about Surfer Girl Beach Beads Set Ask a question about this product

Surfer Girl Beach Beads Set

by Creativity For Kids

Be the first to write a review on this product!









  Item# Swatch Image unit
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
15925
Surfer Girl Beach Beads Set burnt umber 8 oz.
Zoom Image
burnt umber 2014-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
73460
Surfer Girl Beach Beads Set carbazole violet 16 oz.
Zoom Image
carbazole violet 2013-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
87776
Surfer Girl Beach Beads Set carbazole violet 8 oz.
Zoom Image
carbazole violet 2013-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
28597
Surfer Girl Beach Beads Set carbon black 16 oz.
Zoom Image
carbon black 2015-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
67365
Surfer Girl Beach Beads Set carbon black 8 oz.
Zoom Image
carbon black 2015-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
78744
Surfer Girl Beach Beads Set golden yellow 8 oz.
Zoom Image
golden yellow 2003-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
56419
Surfer Girl Beach Beads Set hansa yellow medium 8 oz.
Zoom Image
hansa yellow medium 2002-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
80904
Surfer Girl Beach Beads Set hansa yellow medium 16 oz.
Zoom Image
hansa yellow medium 2002-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
73096
Surfer Girl Beach Beads Set orange 16 oz.
Zoom Image
orange 2004-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
75670
Surfer Girl Beach Beads Set orange 8 oz.
Zoom Image
orange 2004-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
46343
Surfer Girl Beach Beads Set phthalo blue green shade 16 oz.
Zoom Image
phthalo blue green shade 2011-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
47939
Surfer Girl Beach Beads Set phthalo blue green shade 8 oz.
Zoom Image
phthalo blue green shade 2011-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
23407
Surfer Girl Beach Beads Set phthalo green 16 oz.
Zoom Image
phthalo green 2010-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
31473
Surfer Girl Beach Beads Set phthalo green 8 oz.
Zoom Image
phthalo green 2010-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
44137
Surfer Girl Beach Beads Set primary red 16 oz.
Zoom Image
primary red 2006-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
70541
Surfer Girl Beach Beads Set primary red 8 oz.
Zoom Image
primary red 2006-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
60138
Surfer Girl Beach Beads Set quinacridone crimson 16 oz.
Zoom Image
quinacridone crimson 2007-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
87668
Surfer Girl Beach Beads Set quinacridone crimson 8 oz.
Zoom Image
quinacridone crimson 2007-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
79777
Surfer Girl Beach Beads Set quinacridone magenta 8 oz.
Zoom Image
quinacridone magenta 2012-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
25117
Surfer Girl Beach Beads Set scarlet 8 oz.
Zoom Image
scarlet 2005-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
30501
Surfer Girl Beach Beads Set titanium white 8 oz.
Zoom Image
titanium white 2001-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
66968
Surfer Girl Beach Beads Set titanium white 16 oz.
Zoom Image
titanium white 2001-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
67339
Surfer Girl Beach Beads Set turquoise hue 8 oz.
Zoom Image
turquoise hue 2009-08 $7.82 $6.83 10% Off $6.07 20% Off
Add to Favorites
68646
Surfer Girl Beach Beads Set ultramarine blue 16 oz.
Zoom Image
ultramarine blue 2008-16 $12.81 $11.20 10% Off $9.95 20% Off
Add to Favorites
85773
Surfer Girl Beach Beads Set ultramarine blue 8 oz.
Zoom Image
ultramarine blue 2008-08 $7.82 $6.83 10% Off $6.07 20% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.

Add to Cart


Please wait...
You May Also Like...

Paint Ice Beads

by Alex Toys

Paint dots, dashes, and more on cool ice beads!

At Least 9 % Off

From $6.72

From $10.39

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Surfer Girl Beach Beads Set

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Surfer Girl Beach Beads Set

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...