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

Clay Fun Kit

by Alex Toys


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

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

ItemIDList: 78800
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 20
barcode 731346016867
barcode_type UPC
col1 each
col1_sortorder 344
col2 [empty string]
col3 [empty string]
cost 14.64
deal_of_the_week NO
description each
group_id 6189
group_uname alex-toys-clay-fun-kit
id 19286
list_price 26.67
map YES
mfr_num 168X
net_weight 4.74
non_member_discount 10
non_member_price 21.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 19286
sku_pix YES
supplier_id 1
ta_dealer_a_price 16
ta_dealer_c_price 16
ta_price 24
text
array
1 19286
2 168X
3 each
timestamp 2015-03-31T17:52:51.905Z
vip_member_price 19.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78800
CACHED false
EXECUTIONTIME 14
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] = '5452' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=fb~alex-toys~&gr=alex-toys-clay-fun-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:31:45'}
sessionid e030d8422017b56aacc424be10b565e4125f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~16-9999.99~&gr=dover-120-japanese-prints-cd-rom-and-book.html
urltoken CFID=30634314&CFTOKEN=83301476&jsessionid=e030d8422017b56aacc424be10b565e4125f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:31:45'}
sessionid e0306c18193ff72bee62127b4429417b1d34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=fb~alex-toys~&gr=alex-toys-clay-fun-kit.html
urltoken CFID=30634313&CFTOKEN=74964744&jsessionid=e0306c18193ff72bee62127b4429417b1d34
validationerror [empty string]


Shape and sculpt your own creations with 4 lbs. of gray and terra cotta air-dry clay! Then decorate your works of art with colorful paint, mosaic tiles, and glass jewels.

Learn how to create beads, cups, flowers, and more with the included easy instructions.

For ages 4+

Share on Facebook Twitter Pinterest

Ask a question about Clay Fun Kit Ask a question about this product

Clay Fun Kit

by Alex Toys

Average User Rating: Based on (1 Review)

5 1

Hope S. from Oakland, CA says:

this is a great kit. The clay itself if high quality, good-texture, easy to work with out of the bag. The paints are also easy to use and clean up and the included tools and decorating accessories likewise....[more]

[Read All Reviews] [Write a Review]

Why is the VIP Price not displayed for this product? MisterArt.com's goal is to provide our customers the lowest prices on all products we sell. Some manufacturers restrict retailers from displaying or promoting certain products at any price lower than a Minimum Advertised Price (MAP). It is MisterArt.com's policy to offer these products at their MAP price as our Non-Member Price. VIP Members will see the VIP Price after adding the product to the cart without any purchase obligation.









  Item# Image unit
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
19286
Clay Fun Kit each
Zoom Image
each 168X $26.67 $21.60 10% Off Click to See VIP Price Email When In Stock

Click the to add item to your Favorites.



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

Kids Finger Painting Book

by Strathmore

Heavy, smooth paper ideal for messy art

From $3.47

Clay Tool Sets

by Nicole

Sturdy and versatile

From $0.77

Chenille Stems

by Darice

Easy to shape and bend

From $0.69

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 Clay Fun Kit

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.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Hope S. in Oakland, CA
this is a great kit. The clay itself if high quality, good-texture, easy to work with out of the bag. The paints are also easy to use and clean up and the included tools and decorating accessories likewise. I bought this originally for a birthday gift for a friend's child but when my own children saw the box I had to order 2 more for them!

Write a Product Review for Clay Fun Kit

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...