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

Adhesive Remover

by Un-Du


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

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

ItemIDList: 11195,12091,12616,16313,22004,23631,23812,24193,24383,28638,28718,28723,28735,28741,59557,69491,69492,69497,69534,69535,69536,69540,69542,69544,71141,71145,71158,71178,71195,81168,81169,81170,81173,81175,81176,81177,81179,81180,81183,81184,81187,81188,81189,81191,81192,81193,81195,81196,81197,81198,81199
AvailQtyList: 6.000000000000,6.000000000000,2.000000000000,13.000000000000,3.000000000000,10.000000000000,0E-12,5.000000000000,25.000000000000,11.000000000000,3.000000000000,16.000000000000,5.000000000000,1.000000000000,17.000000000000,19.000000000000,8.000000000000,16.000000000000,8.000000000000,5.000000000000,10.000000000000,2.000000000000,6.000000000000,7.000000000000,5.000000000000,5.000000000000,5.000000000000,23.000000000000,6.000000000000,12.000000000000,0E-12,5.000000000000,10.000000000000,5.000000000000,1.000000000000,2.000000000000,10.000000000000,1.000000000000,0E-12,18.000000000000,5.000000000000,13.000000000000,7.000000000000,5.000000000000,11.000000000000,10.000000000000,16.000000000000,8.000000000000,0E-12,3.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 896526002051
barcode_type UPC-RANDOM
col1 4 oz. bottle
col1_sortorder 1807
col2 [empty string]
col3 [empty string]
cost 4.88
deal_of_the_week NO
description 4 oz. bottle
group_id 7562
group_uname un-du-adhesive-remover
id 36067
list_price 9.41
map NO
mfr_num 01004-20
net_weight 0.11
non_member_discount 15
non_member_price 7.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 36067
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.65
ta_dealer_c_price 5.65
ta_price 8
text
array
1 36067
2 01004-20
3 4 oz. bottle
timestamp 2015-03-27T14:47:06.999Z
vip_member_price 7.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 11195
2 6.000000000000 12091
3 2.000000000000 12616
4 13.000000000000 16313
5 3.000000000000 22004
6 10.000000000000 23631
7 0E-12 23812
8 5.000000000000 24193
9 25.000000000000 24383
10 11.000000000000 28638
11 3.000000000000 28718
12 16.000000000000 28723
13 5.000000000000 28735
14 1.000000000000 28741
15 17.000000000000 59557
16 19.000000000000 69491
17 8.000000000000 69492
18 16.000000000000 69497
19 8.000000000000 69534
20 5.000000000000 69535
21 10.000000000000 69536
22 2.000000000000 69540
23 6.000000000000 69542
24 7.000000000000 69544
25 5.000000000000 71141
26 5.000000000000 71145
27 5.000000000000 71158
28 23.000000000000 71178
29 6.000000000000 71195
30 12.000000000000 81168
31 0E-12 81169
32 5.000000000000 81170
33 10.000000000000 81173
34 5.000000000000 81175
35 1.000000000000 81176
36 2.000000000000 81177
37 10.000000000000 81179
38 1.000000000000 81180
39 0E-12 81183
40 18.000000000000 81184
41 5.000000000000 81187
42 13.000000000000 81188
43 7.000000000000 81189
44 5.000000000000 81191
45 11.000000000000 81192
46 10.000000000000 81193
47 16.000000000000 81195
48 8.000000000000 81196
49 0E-12 81197
50 3.000000000000 81198
51 7.000000000000 81199
CACHED false
EXECUTIONTIME 12
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] = '9561' 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.186.83

URL: www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fb~un-du~&gr=un-du-adhesive-remover.html

StartSessionVariables:
struct
cart
struct
FDTOTAL 0
GCINCART 0
VIPINCART 0
checkout
struct
ITEMLIST 12982,30153,16308,36324,62411,84129,89334,12024,51388,45017
NOSHIP 0
ORDER_TOTAL 203.91
SAVED_LIST_PRICE 86.2
SAVED_VIP_PRICE 119.72
Subtotal 203.91
country US
nongcsubtotal 203.910018921
nongcvipsubtotal 203.910018921
requeststarttime {ts '2015-03-30 04:50:06'}
savedquery water color
sessionid e030206deb3dd147a4b1167c4e32135ce2e5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=sort~1~Query~water color~pageNo~11~sort~1~perpage~10~
urltoken CFID=42597657&CFTOKEN=15745520&jsessionid=e030206deb3dd147a4b1167c4e32135ce2e5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 04:50:06'}
sessionid e030c6f9321a6e3741aca17197c7f685fdf1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fb~un-du~&gr=un-du-adhesive-remover.html
urltoken CFID=30155907&CFTOKEN=72091462&jsessionid=e030c6f9321a6e3741aca17197c7f685fdf1
validationerror [empty string]


Un-Du Adhesive Remover works on contact to temporarily neutralize adhesives, allowing reuse of stickers, tapes and labels. It leaves no greasy or oily residue and is safe to use on most any surface, including plexiglas, wood, fabric, paper, plastic, photos, glassware and car finishes.

It comes with a built-in scraper/applicator that delivers the remover beneath the surface of labels, stamps, and adhesive sheets.

Share on Facebook Twitter Pinterest

Ask a question about Adhesive Remover Ask a question about this product

Adhesive Remover

by Un-Du

Average User Rating: Based on (3 Reviews)

5 3

Lisa C from PA says:

Undu is perfect for scrapbooking. It does not stain the cardstock and dries completely without ruining the page. I could not scrap without it!!

[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 size
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
23568
Adhesive Remover set of 6
Zoom Image
set of 6 121072 $24.83 $14.90 40% Off Click to See VIP Price Email When In Stock

Click the to add item to your Favorites.



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

Nori Paste

by Yasutomo

The perfect paper glue

From $1.83

Canvas Pads

by Fredrix

Practice made affordable

Up to 69% Off

Gold and Silver Markers

by Pilot

Add luster to your writing

From $2.62

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 Adhesive Remover

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: Lisa C in PA
Undu is perfect for scrapbooking. It does not stain the cardstock and dries completely without ruining the page. I could not scrap without it!!
Rated by: Vernette in Florida
I couldn't scrapbook without the UNDU. It is great to move my emblishments around if I find something new to add to the page or want to change the arangement. It is easy and doesn't leave a mark on my pictures or page.
Rated by: Phyllis J. in Las Vegas, NV
Ihave not had the opportunity to use this product yet, but I would like to mention that this company has excellent customer service. My bottle arrived half empty and they replaced it with a fresh one immediately

Write a Product Review for Adhesive Remover

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