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

Letter Opener Magnifiers

by UltraOptix


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

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

ItemIDList: 10439,12197,12307,15686,16870,17747,18043,18907,27610,27679,38781,39414,40099,42444,52510,54868,57986,60442,60577,61752,61768,64774,72409,75177,75939,79866,82558,84488,86689,87693
AvailQtyList: 14.000000000000,4.000000000000,11.000000000000,5.000000000000,0E-12,1.000000000000,4.000000000000,9.000000000000,2.000000000000,12.000000000000,0E-12,9.000000000000,20.000000000000,8.000000000000,6.000000000000,5.000000000000,1.000000000000,7.000000000000,3.000000000000,3.000000000000,0E-12,5.000000000000,9.000000000000,11.000000000000,2.000000000000,12.000000000000,8.000000000000,12.000000000000,25.000000000000,6.000000000000

struct
AVAILABLEQTY 12
FLAGS 0
HIGHLIGHTEDSKU 79866
VIP_member_discount 56
barcode 757063520234
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.67
deal_of_the_week NO
description 12, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 79866
list_price 11.95
map NO
mfr_num 5200F-12
net_weight 0.08
non_member_discount 46
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 79866
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.3
ta_dealer_c_price 4.06
ta_price 7.78
text
array
1 79866
2 5200F-12
3 12, flat
timestamp 2015-03-27T14:48:09.717Z
vip_member_price 5.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 10439
2 4.000000000000 12197
3 11.000000000000 12307
4 5.000000000000 15686
5 0E-12 16870
6 1.000000000000 17747
7 4.000000000000 18043
8 9.000000000000 18907
9 2.000000000000 27610
10 12.000000000000 27679
11 0E-12 38781
12 9.000000000000 39414
13 20.000000000000 40099
14 8.000000000000 42444
15 6.000000000000 52510
16 5.000000000000 54868
17 1.000000000000 57986
18 7.000000000000 60442
19 3.000000000000 60577
20 3.000000000000 61752
21 0E-12 61768
22 5.000000000000 64774
23 9.000000000000 72409
24 11.000000000000 75177
25 2.000000000000 75939
26 12.000000000000 79866
27 8.000000000000 82558
28 12.000000000000 84488
29 25.000000000000 86689
30 6.000000000000 87693
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] = '231' 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.159.171.164

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&gr=ultraoptix-letter-opener-magnifiers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:46:34'}
sessionid e0304e05ca9f1c155e14226658803a5d4a66
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=bright&CatD=fp~0-4~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29852308&CFTOKEN=94630753&jsessionid=e0304e05ca9f1c155e14226658803a5d4a66
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:46:34'}
sessionid e030cee3656cfab5bf2511226f357b233279
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&gr=ultraoptix-letter-opener-magnifiers.html
urltoken CFID=29852307&CFTOKEN=34993254&jsessionid=e030cee3656cfab5bf2511226f357b233279
validationerror [empty string]


This innovative tool combines a hi-power magnifier lens with a letter opener. The optical quality 2X lens is unbreakable and scratch resistant. It’s the perfect compact magnifier for reading small type. The extra-sharp letter opener provides a clean and quick cut every time.

Share on Facebook Twitter Pinterest

Ask a question about Letter Opener Magnifiers Ask a question about this product

Letter Opener Magnifiers

by UltraOptix









  Item# Image description
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
60577
Letter Opener Magnifiers 1 round
Zoom Image
1 5200R-1 $4.35 $2.36 46% Off $1.94 56% Off
Add to Favorites
75177
Letter Opener Magnifiers 1 flat
Zoom Image
1 5200F-1 $4.25 $2.31 46% Off $1.89 56% Off
Add to Favorites
75939
Letter Opener Magnifiers 1 bright
Zoom Image
1 5200B-1 $4.25 $2.31 46% Off $1.89 56% Off
Add to Favorites
10439
Letter Opener Magnifiers 10 round
Zoom Image
10 5200R-10 $10.35 $5.62 46% Off $4.60 56% Off
Add to Favorites
18043
Letter Opener Magnifiers 10 flat
Zoom Image
10 5200F-10 $10.35 $5.62 46% Off $4.60 56% Off
Add to Favorites
27610
Letter Opener Magnifiers 10 bright
Zoom Image
10 5200B-10 $10.35 $5.62 46% Off $4.60 56% Off
Add to Favorites
15686
Letter Opener Magnifiers 12 filbert
Zoom Image
12 5200FB-12 $11.95 $6.49 46% Off $5.32 56% Off
Add to Favorites
42444
Letter Opener Magnifiers 12 round
Zoom Image
12 5200R-12 $11.95 $6.49 46% Off $5.32 56% Off
Add to Favorites
79866
Letter Opener Magnifiers 12 flat
Zoom Image
12 5200F-12 $11.95 $6.49 46% Off $5.32 56% Off
Add to Favorites
84488
Letter Opener Magnifiers 12 bright
Zoom Image
12 5200B-12 $11.95 $6.49 46% Off $5.32 56% Off
Add to Favorites
18907
Letter Opener Magnifiers 16 flat
Zoom Image
16 5200F-16 $13.50 $7.33 46% Off $6.01 56% Off
Add to Favorites
60442
Letter Opener Magnifiers 2 bright
Zoom Image
2 5200B-2 $4.95 $2.69 46% Off $2.20 56% Off
Add to Favorites
61752
Letter Opener Magnifiers 2 round
Zoom Image
2 5200R-2 $4.95 $2.69 46% Off $2.20 56% Off
Add to Favorites
82558
Letter Opener Magnifiers 2 flat
Zoom Image
2 5200F-2 $4.95 $2.69 46% Off $2.20 56% Off
Add to Favorites
86689
Letter Opener Magnifiers 2 filbert
Zoom Image
2 5200FB-2 $4.95 $2.69 46% Off $2.20 56% Off
Add to Favorites
38781
Letter Opener Magnifiers 3 fan
Zoom Image
3 5200FN-3 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
16870
Letter Opener Magnifiers 4 bright
Zoom Image
4 5200B-4 $5.65 $3.07 46% Off $2.51 56% Off Email When In Stock
Add to Favorites
54868
Letter Opener Magnifiers 4 filbert
Zoom Image
4 5200FB-4 $5.65 $3.07 46% Off $2.51 56% Off
Add to Favorites
64774
Letter Opener Magnifiers 4 round
Zoom Image
4 5200R-4 $5.50 $2.99 46% Off $2.45 56% Off
Add to Favorites
72409
Letter Opener Magnifiers 4 flat
Zoom Image
4 5200F-4 $5.65 $3.07 46% Off $2.51 56% Off
Add to Favorites
17747
Letter Opener Magnifiers 6 filbert
Zoom Image
6 5200FB-6 $6.95 $3.77 46% Off $3.09 56% Off
Add to Favorites
39414
Letter Opener Magnifiers 6 fan
Zoom Image
6 5200FN-6 $5.50 $2.99 46% Off $2.45 56% Off
Add to Favorites
40099
Letter Opener Magnifiers 6 flat
Zoom Image
6 5200F-6 $6.95 $3.77 46% Off $3.09 56% Off
Add to Favorites
52510
Letter Opener Magnifiers 6 round
Zoom Image
6 5200R-6 $6.95 $3.77 46% Off $3.09 56% Off
Add to Favorites
87693
Letter Opener Magnifiers 6 bright
Zoom Image
6 5200B-6 $6.95 $3.77 46% Off $3.09 56% Off
Add to Favorites
12197
Letter Opener Magnifiers 8 bright
Zoom Image
8 5200B-8 $8.95 $4.86 46% Off $3.98 56% Off
Add to Favorites
12307
Letter Opener Magnifiers 8 angular bright
Zoom Image
8 5200AB-8 $9.25 $5.02 46% Off $4.12 56% Off
Add to Favorites
27679
Letter Opener Magnifiers 8 flat
Zoom Image
8 5200F-8 $8.95 $4.86 46% Off $3.98 56% Off
Add to Favorites
57986
Letter Opener Magnifiers 8 round
Zoom Image
8 5200R-8 $8.75 $4.75 46% Off $3.89 56% Off
Add to Favorites
61768
Letter Opener Magnifiers 8 filbert
Zoom Image
8 5200FB-8 $8.95 $4.86 46% Off $3.98 56% Off Email When In Stock

Click the to add item to your Favorites.

Add to Cart


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

Up to 35% Off

From $5.19

Artist Style Palette

by Loew Cornell

Durable and functional

From $1.25

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 Letter Opener Magnifiers

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 Letter Opener Magnifiers

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