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

Window Mega Markers

by Crayola


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

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

ItemIDList: 13897,13897-PK
AvailQtyList: 211.000000000000,17.000000000000

struct
FLAGS 0
VIP_member_discount 26
barcode 071662081713
barcode_type UPC
col1 set of 4
col1_sortorder 602
col2 school colors
col2_sortorder 5213
col3 [empty string]
cost 2.9
deal_of_the_week NO
description set of 4, school colors
group_id 10266
group_uname crayola-window-mega-markers
id 83209
list_price 5.56
map NO
mfr_num 58-8171
net_weight 0.37
non_member_discount 13
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 83209
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.34
ta_dealer_c_price 3.17
ta_price 4.73
text
array
1 83209
2 58-8171
3 set of 4, school colors
timestamp 2015-03-27T14:48:13.61Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 211.000000000000 13897
2 17.000000000000 13897-PK
CACHED false
EXECUTIONTIME 32
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] = '1505' 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.167.182.223

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:38'}
sessionid e030f2a4fd6ea396d72e202621316a133e1d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html
urltoken CFID=29773531&CFTOKEN=13516958&jsessionid=e030f2a4fd6ea396d72e202621316a133e1d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:38'}
sessionid e030f2a4fd6ea396d72e202621316a133e1d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html
urltoken CFID=29773531&CFTOKEN=13516958&jsessionid=e030f2a4fd6ea396d72e202621316a133e1d
validationerror [empty string]


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

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

ItemIDList: 13897,13897-PK
AvailQtyList: 211.000000000000,17.000000000000

struct
FLAGS 0
VIP_member_discount 26
barcode 071662081669
barcode_type UPC
col1 set of 4
col1_sortorder 602
col2 Original
col2_sortorder 4256
col3 [empty string]
cost 2.96
deal_of_the_week NO
description set of 4, Original
group_id 10266
group_uname crayola-window-mega-markers
id 95402
list_price 5.68
map NO
mfr_num 58-8166
net_weight 0.36
non_member_discount 13
non_member_price 4.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 95402
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.41
ta_dealer_c_price 3.24
ta_price 4.83
text
array
1 95402
2 58-8166
3 set of 4, Original
timestamp 2015-03-27T14:48:35.488Z
vip_member_price 4.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 211.000000000000 13897
2 17.000000000000 13897-PK
CACHED false
EXECUTIONTIME 32
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] = '1505' 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.167.182.223

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:38'}
sessionid e030f2a4fd6ea396d72e202621316a133e1d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html
urltoken CFID=29773531&CFTOKEN=13516958&jsessionid=e030f2a4fd6ea396d72e202621316a133e1d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:38'}
sessionid e030f2a4fd6ea396d72e202621316a133e1d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=sort~1~fp~4-8~&gr=crayola-window-mega-markers.html
urltoken CFID=29773531&CFTOKEN=13516958&jsessionid=e030f2a4fd6ea396d72e202621316a133e1d
validationerror [empty string]


Decorate windows, mirrors, and more with Crayola Washable Window Mega Markers! Specially formulated for writing on glass, these markers can be used to create fun and colorful designs on your windows for birthday parties, graduations, and other special occasions. And best of all, Crayola Washable Window Markers wash easily from skin and most clothes when you’re done.

The set of 4 contains yellow, blue, green, and red markers. The school colors set contains white, blue, black, and red markers. The Mega Markers have three times the normal ink supply.



Share on Facebook Twitter Pinterest

Ask a question about Window Mega Markers Ask a question about this product

Window Mega Markers

by Crayola

Average User Rating: Based on (1 Review)

1 1

Horton from New York, NY says:

These markers were dry and uneven. I have been using this brand for three years and never had a problem before. This was the first time i ordered them from you, and would not do so again.

[Read All Reviews] [Write a Review]









  Item# Image unit
Ascending
description Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
83209
Window Mega Markers set of 4 school colors
Zoom Image
set of 4 school colors 58-8171 $5.56 $4.82 13% Off $4.13 26% Off Email When In Stock
Add to Favorites
95402
Window Mega Markers set of 4 Original
Zoom Image
set of 4 Original 58-8166 $5.68 $4.93 13% Off $4.22 26% Off Email When In Stock

Click the to add item to your Favorites.



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

Plastic Slide Clamps

by ProEdge

Constructed of heavy-duty plastic for extra durability

From $2.14

Ten Well Palette With Cover

by Jack Richeson

Keep paints fresh and wet

From $1.19

Standard Hobby Tool Set

by X-Acto

The ultimate hobby tool set

Up to 32% Off

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 Window Mega Markers

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: Horton in New York, NY
These markers were dry and uneven. I have been using this brand for three years and never had a problem before. This was the first time i ordered them from you, and would not do so again.

Write a Product Review for Window Mega Markers

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