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

Color Brush

by Pentel


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512245347
barcode_type UPC
col1 black, gray, sepia
col1_sortorder 9
col2 box set
col2_sortorder 1165
col3 [empty string]
cost 14.03
deal_of_the_week NO
description black, gray, sepia, box set
group_id 9132
group_uname pentel-color-brush
id 14064
list_price 32.27
map NO
mfr_num GFLFRHBP
net_weight 0.02
non_member_discount 25
non_member_price 24.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 14064
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.17
ta_dealer_c_price 15.17
ta_price 23.23
text
array
1 14064
2 GFLFRHBP
3 black, gray, sepia, box set
timestamp 2015-03-30T16:19:23.565Z
vip_member_price 20.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204146
barcode_type UPC
col1 blue
col1_sortorder 542
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 0-74-255.jpg
cost 1.22
deal_of_the_week NO
description blue, refill
group_id 9132
group_uname pentel-color-brush
id 20478
list_price 2.63
map NO
mfr_num FR-103
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 20478
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 20478
2 FR-103
3 blue, refill
timestamp 2015-03-30T16:19:39.931Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204238
barcode_type UPC
col1 brown
col1_sortorder 799
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 183-62-62.jpg
cost 1.22
deal_of_the_week NO
description brown, refill
group_id 9132
group_uname pentel-color-brush
id 23423
list_price 2.63
map NO
mfr_num FR-106
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 23423
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 23423
2 FR-106
3 brown, refill
timestamp 2015-03-30T16:19:45.154Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512203965
barcode_type UPC
col1 gray
col1_sortorder 2603
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 159-159-159.jpg
cost 4.15
deal_of_the_week NO
description gray, pen
group_id 9132
group_uname pentel-color-brush
id 19253
list_price 8.39
map NO
mfr_num GFLBP137
net_weight 0.04
non_member_discount 25
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 19253
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 5.87
text
array
1 19253
2 GFLBP137
3 gray, pen
timestamp 2015-03-30T16:19:37.956Z
vip_member_price 5.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204504
barcode_type UPC
col1 gray
col1_sortorder 2603
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 159-159-159.jpg
cost 1.22
deal_of_the_week NO
description gray, refill
group_id 9132
group_uname pentel-color-brush
id 63015
list_price 2.63
map NO
mfr_num FR-137
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63015
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63015
2 FR-137
3 gray, refill
timestamp 2015-03-30T16:21:03.846Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204351
barcode_type UPC
col1 light green
col1_sortorder 3353
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 61-193-113.jpg
cost 1.22
deal_of_the_week NO
description light green, refill
group_id 9132
group_uname pentel-color-brush
id 63008
list_price 2.63
map NO
mfr_num FR-111
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63008
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63008
2 FR-111
3 light green, refill
timestamp 2015-03-30T16:21:03.754Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204412
barcode_type UPC
col1 olive green
col1_sortorder 4171
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 74-140-0.jpg
cost 1.22
deal_of_the_week NO
description olive green, refill
group_id 9132
group_uname pentel-color-brush
id 63012
list_price 2.63
map NO
mfr_num FR-115
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63012
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63012
2 FR-115
3 olive green, refill
timestamp 2015-03-30T16:21:03.809Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204269
barcode_type UPC
col1 orange
col1_sortorder 4222
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 255-167-0.jpg
cost 1.22
deal_of_the_week NO
description orange, refill
group_id 9132
group_uname pentel-color-brush
id 63005
list_price 2.63
map NO
mfr_num FR-107
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63005
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63005
2 FR-107
3 orange, refill
timestamp 2015-03-30T16:21:03.72Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204443
barcode_type UPC
col1 pale orange
col1_sortorder 4322
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 255-224-197.jpg
cost 1.22
deal_of_the_week NO
description pale orange, refill
group_id 9132
group_uname pentel-color-brush
id 63013
list_price 2.63
map NO
mfr_num FR-116
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63013
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63013
2 FR-116
3 pale orange, refill
timestamp 2015-03-30T16:21:03.821Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512245804
barcode_type UPC
col1 pigment black
col1_sortorder 4712
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.15
deal_of_the_week NO
description pigment black, pen
group_id 9132
group_uname pentel-color-brush
id 14068
list_price 8.39
map NO
mfr_num FP5MBPA
net_weight 0.02
non_member_discount 25
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 14068
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 6.71
text
array
1 14068
2 FP5MBPA
3 pigment black, pen
timestamp 2015-03-30T16:19:23.594Z
vip_member_price 5.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204290
barcode_type UPC
col1 pink
col1_sortorder 4724
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 255-142-193.jpg
cost 1.22
deal_of_the_week NO
description pink, refill
group_id 9132
group_uname pentel-color-brush
id 63006
list_price 2.63
map NO
mfr_num FR-109
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63006
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63006
2 FR-109
3 pink, refill
timestamp 2015-03-30T16:21:03.731Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204597
barcode_type UPC
col1 purple
col1_sortorder 4938
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 172-0-218.jpg
cost 1.22
deal_of_the_week NO
description purple, refill
group_id 9132
group_uname pentel-color-brush
id 63020
list_price 2.63
map NO
mfr_num FR-150
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63020
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63020
2 FR-150
3 purple, refill
timestamp 2015-03-30T16:21:03.866Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 4902506143020
barcode_type ISBN13
col1 red
col1_sortorder 5088
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 255-0-0.jpg
cost 4.15
deal_of_the_week NO
description red, pen
group_id 9132
group_uname pentel-color-brush
id 12272
list_price 8.39
map NO
mfr_num GFLBP102
net_weight 0.04
non_member_discount 25
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 12272
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 5.87
text
array
1 12272
2 GFLBP102
3 red, pen
timestamp 2015-03-30T16:19:17.6Z
vip_member_price 5.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 4902506143174
barcode_type EAN
col1 sepia
col1_sortorder 5457
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 99-42-30.jpg
cost 4.15
deal_of_the_week NO
description sepia, pen
group_id 9132
group_uname pentel-color-brush
id 13998
list_price 8.39
map NO
mfr_num GFLBP141
net_weight 0.04
non_member_discount 25
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 13998
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 5.87
text
array
1 13998
2 GFLBP141
3 sepia, pen
timestamp 2015-03-30T16:19:23.144Z
vip_member_price 5.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204566
barcode_type UPC
col1 sepia
col1_sortorder 5457
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 99-42-30.jpg
cost 1.22
deal_of_the_week NO
description sepia, refill
group_id 9132
group_uname pentel-color-brush
id 63018
list_price 2.63
map NO
mfr_num FR-141
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63018
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63018
2 FR-141
3 sepia, refill
timestamp 2015-03-30T16:21:03.864Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204320
barcode_type UPC
col1 sky blue
col1_sortorder 5628
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 0-202-255.jpg
cost 1.22
deal_of_the_week NO
description sky blue, refill
group_id 9132
group_uname pentel-color-brush
id 63007
list_price 2.63
map NO
mfr_num FR-110
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63007
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63007
2 FR-110
3 sky blue, refill
timestamp 2015-03-30T16:21:03.743Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204474
barcode_type UPC
col1 steel blue
col1_sortorder 5806
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 0-123-175.jpg
cost 1.22
deal_of_the_week NO
description steel blue, refill
group_id 9132
group_uname pentel-color-brush
id 63014
list_price 2.63
map NO
mfr_num FR-117
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63014
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63014
2 FR-117
3 steel blue, refill
timestamp 2015-03-30T16:21:03.832Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204382
barcode_type UPC
col1 turquoise
col1_sortorder 6215
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 138-200-237.jpg
cost 1.22
deal_of_the_week NO
description turquoise, refill
group_id 9132
group_uname pentel-color-brush
id 63010
list_price 2.63
map NO
mfr_num FR-114
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63010
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63010
2 FR-114
3 turquoise, refill
timestamp 2015-03-30T16:21:03.783Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512226902
barcode_type UPC
col1 water based black
col1_sortorder 6522
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.15
deal_of_the_week NO
description water based black, pen
group_id 9132
group_uname pentel-color-brush
id 21827
list_price 8.39
map NO
mfr_num GFLBP101
net_weight 0.04
non_member_discount 25
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 21827
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 5.96
text
array
1 21827
2 GFLBP101
3 water based black, pen
timestamp 2015-03-30T16:19:42.267Z
vip_member_price 5.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204207
barcode_type UPC
col1 yellow
col1_sortorder 6681
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 255-255-0.jpg
cost 1.22
deal_of_the_week NO
description yellow, refill
group_id 9132
group_uname pentel-color-brush
id 13144
list_price 2.63
map NO
mfr_num FR-105
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 13144
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 13144
2 FR-105
3 yellow, refill
timestamp 2015-03-30T16:19:20.113Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512203668
barcode_type UPC
col1 yellow
col1_sortorder 6681
col2 pen
col2_sortorder 4481
col3 [empty string]
color_swatch 255-255-0.jpg
cost 3.51
deal_of_the_week NO
description yellow, pen
group_id 9132
group_uname pentel-color-brush
id 26309
list_price 7.99
map NO
mfr_num GFL-105
net_weight 0.04
non_member_discount 25
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 26309
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.07
ta_dealer_c_price 3.84
ta_price 5.67
text
array
1 26309
2 GFL-105
3 yellow, pen
timestamp 2015-03-30T16:19:50.19Z
vip_member_price 5.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


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

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

ItemIDList: 17638,27529,28967,44774,46018,88503
AvailQtyList: 11.000000000000,6.000000000000,9.000000000000,8.000000000000,3.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 072512204535
barcode_type UPC
col1 yellow orange
col1_sortorder 6714
col2 refill
col2_sortorder 4915
col3 [empty string]
color_swatch 255-211-109.jpg
cost 1.22
deal_of_the_week NO
description yellow orange, refill
group_id 9132
group_uname pentel-color-brush
id 63016
list_price 2.63
map NO
mfr_num FR-140
net_weight 0.02
non_member_discount 25
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 63016
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.34
ta_price 2.03
text
array
1 63016
2 FR-140
3 yellow orange, refill
timestamp 2015-03-30T16:21:03.856Z
vip_member_price 1.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17638
2 6.000000000000 27529
3 9.000000000000 28967
4 8.000000000000 44774
5 3.000000000000 46018
6 5.000000000000 88503
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] = '11885' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030bfc30eeb4a6cbc602f17387427f627c1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=paper&CatD=sort~1~fp~0-23~&gr=clearprint-design-vellum-rolls.html
urltoken CFID=30277394&CFTOKEN=52711981&jsessionid=e030bfc30eeb4a6cbc602f17387427f627c1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:26:26'}
sessionid e030c5d586082b1221356201c6f237d1b294
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~pentel~fp~16-9999.99~&gr=pentel-color-brush.html
urltoken CFID=30277393&CFTOKEN=37137772&jsessionid=e030c5d586082b1221356201c6f237d1b294
validationerror [empty string]


The Pentel Color Brush is an ink-filled nylon brush tip pen that produces thick and thin lines. The brightly colored liquid ink flows easily, dries quickly, and produces transparent watercolor effects.

The ink-filled brush is a convenient, portable alternative to traditional brushes and ink. It’s ideal for sketching and painting on location.

Refill cartridges are also available. They are economical and earth-friendly.

Share on Facebook Twitter Pinterest

Ask a question about Color Brush Ask a question about this product  |  See all questions & answers (1)

Color Brush

by Pentel

Average User Rating: Based on (6 Reviews)

5 6

Lee M. from Naalehu, HI says:

I thought I would try the black brush for inking instead of the Staedtler pigment liners I normally use. It was more difficult to control than a real brush because it doesn't have bristles. I suppose...[more]

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
description Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
14064
Color Brush black, gray, sepia box set
Zoom Image
black, gray, sepia box set GFLFRHBP $32.27 $24.19 25% Off $20.98 35% Off Email When In Stock
Add to Favorites
20478
Color Brush blue refill
Zoom Image
blue refill FR-103 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
23423
Color Brush brown refill
Zoom Image
brown refill FR-106 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
19253
Color Brush gray pen
Zoom Image
gray pen GFLBP137 $8.39 $6.29 25% Off $5.45 35% Off Email When In Stock
Add to Favorites
63015
Color Brush gray refill
Zoom Image
gray refill FR-137 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63008
Color Brush light green refill
Zoom Image
light green refill FR-111 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63012
Color Brush olive green refill
Zoom Image
olive green refill FR-115 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63005
Color Brush orange refill
Zoom Image
orange refill FR-107 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63013
Color Brush pale orange refill
Zoom Image
pale orange refill FR-116 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
14068
Color Brush pigment black pen
Zoom Image
pigment black pen FP5MBPA $8.39 $6.29 25% Off $5.45 35% Off Email When In Stock
Add to Favorites
63006
Color Brush pink refill
Zoom Image
pink refill FR-109 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63020
Color Brush purple refill
Zoom Image
purple refill FR-150 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
12272
Color Brush red pen
Zoom Image
red pen GFLBP102 $8.39 $6.29 25% Off $5.45 35% Off Email When In Stock
Add to Favorites
13998
Color Brush sepia pen
Zoom Image
sepia pen GFLBP141 $8.39 $6.29 25% Off $5.45 35% Off Email When In Stock
Add to Favorites
63018
Color Brush sepia refill
Zoom Image
sepia refill FR-141 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63007
Color Brush sky blue refill
Zoom Image
sky blue refill FR-110 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63014
Color Brush steel blue refill
Zoom Image
steel blue refill FR-117 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
63010
Color Brush turquoise refill
Zoom Image
turquoise refill FR-114 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
21827
Color Brush water based black pen
Zoom Image
water based black pen GFLBP101 $8.39 $6.29 25% Off $5.45 35% Off Email When In Stock
Add to Favorites
13144
Color Brush yellow refill
Zoom Image
yellow refill FR-105 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock
Add to Favorites
26309
Color Brush yellow pen
Zoom Image
yellow pen GFL-105 $7.99 $5.99 25% Off $5.19 35% Off Email When In Stock
Add to Favorites
63016
Color Brush yellow orange refill
Zoom Image
yellow orange refill FR-140 $2.63 $1.97 25% Off $1.71 35% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



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

Pigma Brush Pen

by Sakura

Top name brands for less

From $1.80

Up to 45% Off

Kneaded Rubber Erasers

by Prismacolor

Perfect for chalk, charcoal, and pastels

From $0.52

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 »

Product Questions and Answers

Ask a Question
Ask a Question

Is there a way to get the ink to flow?

- Asked by stephanie van lammeren on 08-Sep-12
Answer

Here is the secret to these pens: when you first get it, there is a red ring on the pen. You must remove the red ring, and screw the pen back together, and then the ink will flow.

- Answered by MisterArt on 10-Oct-12

Ask a Question About Color Brush


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: Lee M. in Naalehu, HI
I thought I would try the black brush for inking instead of the Staedtler pigment liners I normally use. It was more difficult to control than a real brush because it doesn't have bristles. I suppose I could learn to use it if I practiced. These would be good for painting, tho...
Rated by: Barbara S. in Southern Pines, NC
These pens work very well and I use them primarily after I complete a work done in water colors. Love the brush and the fact that this pen is refillable. I have recommended this product to several of my artist friends.
Rated by: Harley T. in Palm Desert, CA
I've tried inking with brushes but wanted to find some type of marker like a brush. This brush came recommended thru an artist community so i tried it out. I really love this brush! It's super fluid and you can control line weight with ease! I'll definitely be buying more of these brushes!!
Rated by: John M. in Moreno Valley, CA
This is a wonderful invention and it works SO well too. The portable brush. It is dark black (other colors too) and responsive. I can get some values as well. Had one years ago, lost it and now I have MisterArt.com to thank for making it available to me and others. Enjoy, you won't be sorry you tried it.
Rated by: Shauna S. in Queens, NY
I love this brush! Quite nifty and is just a pleasure to use. I actually guard this one.
Rated by: Sterling F. in San Francisco, CA
Only show them off to people you can trust... Or in my case, guard them. Starving artists will covet them with envy! =P The thief decided to disappear and live in fear for my set. Start using one and you'll know why. The control is amazing! Consistent fine lines, precise color fill-ins... Unlike a felt tip ink marker, you can overlap colors for blending. It almost seems like these pens are a well-kept secret.

Write a Product Review for Color Brush

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