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

Amphibian Rover Kit

by 4M


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

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

ItemIDList: 21932,21932-PK,29921,29921-PK,31248,31248-PK,35115,35115-PK,35396,35396-PK,46299,46299-PK,47044,47044-PK,56711,56711-PK,73129,73243,73243-PK,82057,82057-PK
AvailQtyList: 23.000000000000,3.000000000000,30.000000000000,5.000000000000,66.000000000000,11.000000000000,49.000000000000,8.000000000000,34.000000000000,5.000000000000,17.000000000000,2.000000000000,33.000000000000,5.000000000000,63.000000000000,10.000000000000,22.000000000000,51.000000000000,8.000000000000,14.000000000000,2.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 085761090828
barcode_type UPC
col1 each
col1_sortorder 340
col2 [empty string]
col3 [empty string]
cost 10.37
deal_of_the_week NO
description each
group_id 12026
group_uname 4m-amphibian-rover-kit
id 57759
list_price 18.89
map NO
mfr_num 3636
net_weight 0.61
non_member_discount 10
non_member_price 16
prop65 NO
ship_rule_desc STD
shipping STD
sku 57759
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.33
ta_dealer_c_price 11.33
ta_price 17
text
array
1 57759
2 3636
3 each
timestamp 2015-03-27T14:47:32.795Z
vip_member_price 14.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 21932
2 3.000000000000 21932-PK
3 30.000000000000 29921
4 5.000000000000 29921-PK
5 66.000000000000 31248
6 11.000000000000 31248-PK
7 49.000000000000 35115
8 8.000000000000 35115-PK
9 34.000000000000 35396
10 5.000000000000 35396-PK
11 17.000000000000 46299
12 2.000000000000 46299-PK
13 33.000000000000 47044
14 5.000000000000 47044-PK
15 63.000000000000 56711
16 10.000000000000 56711-PK
17 22.000000000000 73129
18 51.000000000000 73243
19 8.000000000000 73243-PK
20 14.000000000000 82057
21 2.000000000000 82057-PK
CACHED false
EXECUTIONTIME 3
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] = '2027' 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.23.190

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=fp~7-9999.99~&gr=4m-amphibian-rover-kit.html

StartSessionVariables:
struct
cart
struct
CART_SUBTOTAL 0
FDTOTAL 0
GCINCART 0
MESSAGE [empty string]
VIPINCART 0
checkout
struct
ITEMLIST 89400,56711,89994
NOSHIP 0
ORDER_TOTAL 64.1899990845
SAVED_LIST_PRICE 48.3
SAVED_VIP_PRICE 58.32
SHIPPINGTOTAL 10.98
SHIPPING_OPTION
struct
COST 10.98
DESC 4 - 6 business days
NOOPTIONS 3
SURCHARGE 0
TYPE GROUNDFDX
Subtotal 53.21
country US
nongcsubtotal 53.2099990845
nongcvipsubtotal 53.2099990845
requeststarttime {ts '2015-03-28 10:15:34'}
selshipping DISPLAY_STD
sessionid e030387e9de0ef361e99675847105444b793
ship_to_zip 33983
state FL
stformdata
struct [empty]
tax 0.0
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=stretched-canvas&gr=fredrix-blue-label-ultra-smooth-portrait-grade-pre-stretched-artist-canvas.html
urltoken CFID=29403227&CFTOKEN=37973113&jsessionid=e030387e9de0ef361e99675847105444b793
validationerror [empty string]
ziperror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 10:15:34'}
sessionid e0304d8132f1888efeb67b1217523e68766d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=fp~7-9999.99~&gr=4m-amphibian-rover-kit.html
urltoken CFID=29656290&CFTOKEN=25076619&jsessionid=e0304d8132f1888efeb67b1217523e68766d
validationerror [empty string]


This easy-to-assemble kit, with it's eco-friendly design, sets kids on the road to discovery and makes an innovative use of everyday items. Create a motorized vehicle using your recycled plastic bottles as monster wheels. The set includes plastic body parts, motor, battery case, wheel hubs, paddles, screws, terminal caps, and instructions. Requires 2 AAA batteries, which are not included.

For ages 8+

Share on Facebook Twitter Pinterest

Ask a question about Amphibian Rover Kit Ask a question about this product

Amphibian Rover Kit

by 4M

Be the first to write a review on this product!









  Item# Image unit
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
73243
Amphibian Rover Kit 11 in. x 14 in. each
Zoom Image
11 in. x 14 in. 5604 $15.66 $8.55 45% Off $7.05 55% Off
Add to Favorites
73243-PK
  11 in. x 14 in. $93.96 $46.98 50% Off $37.58 60% Off
Add to Favorites
31248
Amphibian Rover Kit 12 in. x 16 in. each
Zoom Image
12 in. x 16 in. 5605 $18.64 $10.18 45% Off $8.39 55% Off
Add to Favorites
31248-PK
  12 in. x 16 in. $111.84 $55.92 50% Off $44.74 60% Off
Add to Favorites
56711
Amphibian Rover Kit 16 in. x 20 in. each
Zoom Image
16 in. x 20 in. 5607 $22.97 $12.55 45% Off $10.34 55% Off BEST SELLER
Add to Favorites
56711-PK
  16 in. x 20 in. $137.82 $68.91 50% Off $55.13 60% Off
Add to Favorites
47044
Amphibian Rover Kit 18 in. x 24 in. each
Zoom Image
18 in. x 24 in. 5608 $29.77 $16.26 45% Off $13.40 55% Off
Add to Favorites
47044-PK
  18 in. x 24 in. $178.62 $89.31 50% Off $71.45 60% Off
Add to Favorites
35396
Amphibian Rover Kit 20 in. x 24 in. each
Zoom Image
20 in. x 24 in. 5609 $32.14 $17.55 45% Off $14.46 55% Off
Add to Favorites
35396-PK
  20 in. x 24 in. $192.84 $96.42 50% Off $77.14 60% Off
Add to Favorites Amphibian Rover Kit 22 in. x 28 in. each
Zoom Image
22 in. x 28 in. 5610 $38.42 $20.99 45% Off $17.29 55% Off
Add to Favorites   22 in. x 28 in. $230.52 $115.26 50% Off $92.21 60% Off
Add to Favorites Amphibian Rover Kit 24 in. x 30 in. each
Zoom Image
24 in. x 30 in. 5611 $40.58 $22.16 45% Off $18.26 55% Off
Add to Favorites   24 in. x 30 in. $243.48 $121.74 50% Off $97.39 60% Off
Add to Favorites Amphibian Rover Kit 24 in. x 36 in. each
Zoom Image
24 in. x 36 in. 5612 $48.72 $26.61 45% Off $21.92 55% Off
Add to Favorites   24 in. x 36 in. $292.32 $146.16 50% Off $116.93 60% Off
Add to Favorites Amphibian Rover Kit 30 in. x 40 in. each
Zoom Image
30 in. x 40 in. 5613 $72.51 $39.60 45% Off $32.63 55% Off
Add to Favorites
35115
Amphibian Rover Kit 8 in. x 10 in. each
Zoom Image
8 in. x 10 in. 5601 $11.33 $6.19 45% Off $5.10 55% Off
Add to Favorites
35115-PK
  8 in. x 10 in. $67.98 $33.99 50% Off $27.19 60% Off
Add to Favorites
29921
Amphibian Rover Kit 9 in. x 12 in. each
Zoom Image
9 in. x 12 in. 5602 $13.49 $7.37 45% Off $6.07 55% Off
Add to Favorites
29921-PK
  9 in. x 12 in. $80.94 $40.47 50% Off $32.38 60% Off Email When In Stock

Click the to add item to your Favorites.

Add to Cart


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

Plastic 10 Well Round Tray

by Economy Brand

Affordable and easy to clean

From $0.58

Big Brush Watercolor Palette

by Sterling Edwards

22 wells for both mixing and storing color mixes

At Least 39 % Off

From $5.19

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

Write a Product Review for Amphibian Rover 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...