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


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

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

ItemIDList: 34581,59565,67353
AvailQtyList: 48.000000000000,42.000000000000,132.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 836943007710
barcode_type UPC-RANDOM
col1 1 lb.
col1_sortorder 56
col2 bag
col2_sortorder 223
col3 [empty string]
cost 4.4
deal_of_the_week NO
description 1 lb., bag
group_id 9288
group_uname r-f-handmade-paints-soy-wax
id 97231
list_price 8.5
map YES
mfr_num 917-1
net_weight 1.01
non_member_discount 20
non_member_price 6.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 97231
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.1
ta_dealer_c_price 5.1
ta_price 8.07
text
array
1 97231
2 917-1
3 1 lb., bag
timestamp 2015-03-27T14:48:39.432Z
vip_member_price 5.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 48.000000000000 34581
2 42.000000000000 59565
3 132.000000000000 67353
CACHED false
EXECUTIONTIME 5
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] = '150' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~4-9999.99~&gr=r-f-handmade-paints-soy-wax.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 18:48:32'}
sessionid e0307480c7f91a92f1fc276d776437204620
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&gr=weldbond-universal-adhesive.html
urltoken CFID=30038627&CFTOKEN=53989067&jsessionid=e0307480c7f91a92f1fc276d776437204620
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 18:48:32'}
sessionid e0305318e10fe5b3425d6a18111d7a76332a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~4-9999.99~&gr=r-f-handmade-paints-soy-wax.html
urltoken CFID=30038628&CFTOKEN=98110321&jsessionid=e0305318e10fe5b3425d6a18111d7a76332a
validationerror [empty string]


Soy wax (actually partially hydrogenated soybean oil) is an excellent alternative to paraffin for cleaning brushes for several reasons. Soy beans are a renewable resource, unlike paraffin, which is a petroleum product. Soy wax is non-toxic, burns cleaner than paraffin, and is naturally biodegradable. Soy wax is also easier to remove than paraffin wax, so after the color has been cleaned out of the brush, the brush can be washed with soap and water and is reusable in other mediums.

Share on Facebook Twitter Pinterest

Ask a question about Soy Wax Ask a question about this product









  Item# Image weight
Ascending
unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
59565
Soy Wax 14.2 oz. bottle
Zoom Image
14.2 oz. bottle 8-50420 $9.39 $7.12 10% Off $6.33 20% Off
Add to Favorites
34581
Soy Wax 2 oz. tube
Zoom Image
2 oz. tube 8-120098 $4.21 $5.68 10% Off $5.05 20% Off
Add to Favorites
67353
Soy Wax 5.4 oz. bottle
Zoom Image
5.4 oz. bottle 8-50160 $5.44 $3.36 10% Off $2.98 20% 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 Soy Wax

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 Soy Wax

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