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

Sketcho Oil Pastel Crayons

by Prang


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 35
barcode 072067116604
barcode_type UPC
col1 set of 12
col1_sortorder 5327
col2 [empty string]
col3 [empty string]
cost 4.09
deal_of_the_week NO
description set of 12
group_id 565
group_uname prang-sketcho-oil-pastel-crayons
id 17067
list_price 8.44
map NO
mfr_num 11660
net_weight 0.35
non_member_discount 25
non_member_price 6.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 17067
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.56
ta_price 7.18
text
array
1 17067
2 11660
3 set of 12
timestamp 2015-04-01T21:25:39.167Z
vip_member_price 5.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
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] = '8370' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:10:27'}
sessionid e0302d158cc8101ee5f0132c30742f53257d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html
urltoken CFID=30864562&CFTOKEN=60336946&jsessionid=e0302d158cc8101ee5f0132c30742f53257d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:10:27'}
sessionid e0302d158cc8101ee5f0132c30742f53257d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html
urltoken CFID=30864562&CFTOKEN=60336946&jsessionid=e0302d158cc8101ee5f0132c30742f53257d
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 35
barcode 072067116703
barcode_type UPC
col1 set of 24
col1_sortorder 5345
col2 [empty string]
col3 [empty string]
cost 7.6
deal_of_the_week NO
description set of 24
group_id 565
group_uname prang-sketcho-oil-pastel-crayons
id 72459
list_price 16.12
map NO
mfr_num 11670
net_weight 0.58
non_member_discount 25
non_member_price 12.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 72459
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.19
ta_dealer_c_price 8.7
ta_price 13.71
text
array
1 72459
2 11670
3 set of 24
timestamp 2015-04-01T21:27:09.774Z
vip_member_price 10.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
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] = '8370' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:10:27'}
sessionid e0302d158cc8101ee5f0132c30742f53257d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html
urltoken CFID=30864562&CFTOKEN=60336946&jsessionid=e0302d158cc8101ee5f0132c30742f53257d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:10:27'}
sessionid e0302d158cc8101ee5f0132c30742f53257d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pastels&CatC=fb~prang~fp~3-7~&gr=prang-sketcho-oil-pastel-crayons.html
urltoken CFID=30864562&CFTOKEN=60336946&jsessionid=e0302d158cc8101ee5f0132c30742f53257d
validationerror [empty string]


Sketcho oil crayons can be blended with your fingertips or layered to give the effect of oil paint. Sketchos are recommended for drawings and outdoor sketching. Versatile oil crayons can be used in a variety of ways --blend them, pile crayon on crayon, do sgraffito, or work with a paint solvent. Each Sketcho is 2 1/2 in. x 1/2 in.. AP certified non-toxic. Made in the USA.

The 12 color box contain red, orange, yellow, yellow-green, green, turquoise, blue, blue-violet, magenta, black, brown, and white. The 24 color box contains the same colors in 12 color set plus red orange, pink, peach, dark yellow, yellow orange, gray, red violet, ultramarine blue, dark orange, blue-green, light blue-green, and Prussian blue.

Share on Facebook Twitter Pinterest

Ask a question about Sketcho Oil Pastel Crayons Ask a question about this product

Sketcho Oil Pastel Crayons

by Prang

Average User Rating: Based on (1 Review)

4 1

Laura A. from Centralia, IL says:

Very Sturdy and colorful. My clients love to use them and they work well for any age!

[Read All Reviews] [Write a Review]









  Item# Image description
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
17067
Sketcho Oil Pastel Crayons set of 12
Zoom Image
set of 12 11660 $8.44 $6.33 25% Off $5.49 35% Off Email When In Stock
Add to Favorites
72459
Sketcho Oil Pastel Crayons set of 24
Zoom Image
set of 24 11670 $16.12 $12.09 25% Off $10.48 35% Off Email When In Stock

Click the to add item to your Favorites.



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

Oil Pastel

by Pentel

The "must have" for every classroom!

From $2.67

400 Series Pastel Pads

by Strathmore

Ideal texture for pastels

Up to 53% Off

Ambrite Colored Paper Chalk

by Prang

Specially designed for use on paper and cardboard

From $3.33

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 Sketcho Oil Pastel Crayons

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: Laura A. in Centralia, IL
Very Sturdy and colorful. My clients love to use them and they work well for any age!

Write a Product Review for Sketcho Oil Pastel Crayons

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