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

Fadeless Colored Paper Rolls

by Pacon


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571303
barcode_type UPC
col1 apple green
col1_sortorder 175
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 77-210-119.jpg
cost 1.89
deal_of_the_week NO
description apple green, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 14875
list_price 4.43
map NO
mfr_num 57130
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 14875
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 14875
2 57130
3 apple green, 24 in. x 12 ft.
timestamp 2015-03-27T14:46:32.564Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571358
barcode_type UPC
col1 apple green
col1_sortorder 175
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 77-210-119.jpg
cost 12.38
deal_of_the_week NO
description apple green, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 48902
list_price 29
map NO
mfr_num 57135
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 48902
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 48902
2 57135
3 apple green, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:23.429Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571600
barcode_type UPC
col1 azure blue
col1_sortorder 284
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 47-143-240.jpg
cost 1.89
deal_of_the_week NO
description azure blue, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 20113
list_price 4.43
map NO
mfr_num 57160
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 20113
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 20113
2 57160
3 azure blue, 24 in. x 12 ft.
timestamp 2015-03-27T14:46:40.126Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571655
barcode_type UPC
col1 azure blue
col1_sortorder 284
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 47-143-240.jpg
cost 12.38
deal_of_the_week NO
description azure blue, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 27472
list_price 29
map NO
mfr_num 57165
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 27472
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 27472
2 57165
3 azure blue, 48 in. x 50 ft.
timestamp 2015-03-27T14:46:50.678Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573000
barcode_type UPC
col1 black
col1_sortorder 402
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.89
deal_of_the_week NO
description black, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 10466
list_price 4.43
map NO
mfr_num 57300
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 10466
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 10466
2 57300
3 black, 24 in. x 12 ft.
timestamp 2015-03-27T14:46:24.446Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573055
barcode_type UPC
col1 black
col1_sortorder 402
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 0-0-0.jpg
cost 12.38
deal_of_the_week NO
description black, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 82689
list_price 29
map NO
mfr_num 57305
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 82689
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 82689
2 57305
3 black, 48 in. x 50 ft.
timestamp 2015-03-27T14:48:13.348Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571754
barcode_type UPC
col1 bright blue
col1_sortorder 692
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 0-98-210.jpg
cost 12.38
deal_of_the_week NO
description bright blue, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 24704
list_price 29
map NO
mfr_num 57175
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 24704
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 24704
2 57175
3 bright blue, 48 in. x 50 ft.
timestamp 2015-03-27T14:46:46.045Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570207
barcode_type UPC
col1 brown
col1_sortorder 798
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.89
deal_of_the_week NO
description brown, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 31327
list_price 4.43
map NO
mfr_num 57020
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 31327
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 31327
2 57020
3 brown, 24 in. x 12 ft.
timestamp 2015-03-27T14:46:56.573Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570856
barcode_type UPC
col1 canary
col1_sortorder 1057
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 240-213-47.jpg
cost 12.38
deal_of_the_week NO
description canary, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 32972
list_price 29
map NO
mfr_num 57085
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 32972
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 32972
2 57085
3 canary, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:00.459Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570801
barcode_type UPC
col1 canary
col1_sortorder 1057
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 240-213-47.jpg
cost 1.89
deal_of_the_week NO
description canary, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 39300
list_price 4.43
map NO
mfr_num 57080
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 39300
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 39300
2 57080
3 canary, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:11.605Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573253
barcode_type UPC
col1 dark yellow
col1_sortorder 1773
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 240-199-47.jpg
cost 12.38
deal_of_the_week NO
description dark yellow, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 34981
list_price 29
map NO
mfr_num 57325
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 34981
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 34981
2 57325
3 dark yellow, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:05.509Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571457
barcode_type UPC
col1 emerald green
col1_sortorder 2033
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 0-164-123.jpg
cost 12.38
deal_of_the_week NO
description emerald green, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 47926
list_price 29
map NO
mfr_num 57145
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 47926
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 47926
2 57145
3 emerald green, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:22.517Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570306
barcode_type UPC
col1 flame
col1_sortorder 2163
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 195-47-47.jpg
cost 1.89
deal_of_the_week NO
description flame, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 48982
list_price 4.43
map NO
mfr_num 57030
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 48982
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 48982
2 57030
3 flame, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:23.489Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570351
barcode_type UPC
col1 flame
col1_sortorder 2163
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 195-47-47.jpg
cost 12.38
deal_of_the_week NO
description flame, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 51772
list_price 29
map NO
mfr_num 57035
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 51772
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 51772
2 57035
3 flame, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:25.914Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571259
barcode_type UPC
col1 lite green
col1_sortorder 3483
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 166-210-0.jpg
cost 12.38
deal_of_the_week NO
description lite green, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 34546
list_price 29
map NO
mfr_num 57125
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 34546
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 34546
2 57125
3 lite green, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:04.927Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573451
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 255-0-196.jpg
cost 12.38
deal_of_the_week NO
description magenta, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 77928
list_price 29
map NO
mfr_num 57345
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 77928
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 77928
2 57345
3 magenta, 48 in. x 50 ft.
timestamp 2015-03-27T14:48:07.63Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571006
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 210-90-0.jpg
cost 1.89
deal_of_the_week NO
description orange, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 34826
list_price 4.43
map NO
mfr_num 57100
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 34826
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 34826
2 57100
3 orange, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:05.342Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571051
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 210-90-0.jpg
cost 12.38
deal_of_the_week NO
description orange, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 69331
list_price 29
map NO
mfr_num 57105
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 69331
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 69331
2 57105
3 orange, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:54.14Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444572652
barcode_type UPC
col1 pink
col1_sortorder 4716
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 240-183-232.jpg
cost 12.38
deal_of_the_week NO
description pink, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 45512
list_price 29
map NO
mfr_num 57265
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 45512
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 45512
2 57265
3 pink, 48 in. x 50 ft.
timestamp 2015-03-27T14:47:18.605Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444572607
barcode_type UPC
col1 pink
col1_sortorder 4716
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 240-183-232.jpg
cost 1.89
deal_of_the_week NO
description pink, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 85533
list_price 4.43
map NO
mfr_num 57260
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 85533
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 85533
2 57260
3 pink, 24 in. x 12 ft.
timestamp 2015-03-27T14:48:16.813Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571709
barcode_type UPC
col1 rich blue
col1_sortorder 5189
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 0-98-164.jpg
cost 1.89
deal_of_the_week NO
description rich blue, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 55349
list_price 4.43
map NO
mfr_num 57170
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 55349
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 55349
2 57170
3 rich blue, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:29.913Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444571853
barcode_type UPC
col1 rich blue
col1_sortorder 5189
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 0-98-164.jpg
cost 12.38
deal_of_the_week NO
description rich blue, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 75624
list_price 29
map NO
mfr_num 57185
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 75624
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 75624
2 57185
3 rich blue, 48 in. x 50 ft.
timestamp 2015-03-27T14:48:05.633Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573352
barcode_type UPC
col1 violet
col1_sortorder 6398
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 114-0-164.jpg
cost 12.38
deal_of_the_week NO
description violet, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 17428
list_price 29
map NO
mfr_num 57335
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 17428
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 17428
2 57335
3 violet, 48 in. x 50 ft.
timestamp 2015-03-27T14:46:37.287Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444573307
barcode_type UPC
col1 violet
col1_sortorder 6398
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 114-0-164.jpg
cost 1.89
deal_of_the_week NO
description violet, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 70138
list_price 4.43
map NO
mfr_num 57330
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 70138
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 70138
2 57330
3 violet, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:55.946Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570153
barcode_type UPC
col1 white
col1_sortorder 6534
col2 48 in. x 50 ft.
col2_sortorder 1894
col3 [empty string]
color_swatch 255-255-255.jpg
cost 12.38
deal_of_the_week NO
description white, 48 in. x 50 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 25467
list_price 29
map NO
mfr_num 57015
net_weight 3.62
non_member_discount 42
non_member_price 16.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 25467
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.5
ta_dealer_c_price 13.63
ta_price 20.3
text
array
1 25467
2 57015
3 white, 48 in. x 50 ft.
timestamp 2015-03-27T14:46:47.166Z
vip_member_price 14.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 029444570108
barcode_type UPC
col1 white
col1_sortorder 6534
col2 24 in. x 12 ft.
col2_sortorder 1336
col3 [empty string]
color_swatch 255-255-255.jpg
cost 1.89
deal_of_the_week NO
description white, 24 in. x 12 ft.
group_id 302
group_uname pacon-fadeless-colored-paper-rolls
id 60139
list_price 4.43
map NO
mfr_num 57010
net_weight 0.5
non_member_discount 42
non_member_price 2.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 60139
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.22
ta_dealer_c_price 2.08
ta_price 3.1
text
array
1 60139
2 57010
3 white, 24 in. x 12 ft.
timestamp 2015-03-27T14:47:37.681Z
vip_member_price 2.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 47
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] = '4495' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030f11697b8e7941aa32f191580244e3f54
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=brush-sets&CatC=fb~silver-brush~fp~30-9999.99~&gr=silver-brush-black-velvet-watercolor-brush-set.html
urltoken CFID=29811088&CFTOKEN=19221223&jsessionid=e030f11697b8e7941aa32f191580244e3f54
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 23:22:53'}
sessionid e030b6f93ccd412602d5513f515426673266
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~pacon~&gr=pacon-fadeless-colored-paper-rolls.html
urltoken CFID=29811089&CFTOKEN=28785217&jsessionid=e030b6f93ccd412602d5513f515426673266
validationerror [empty string]


This 50 lb. white sulfite paper is ink-coated on one side with vibrant, fade-resistant colors and is plain white on the other side. The paper will not crack when folded and accepts most art media with ease.

Pacon Fadeless Colored Paper is perfect for bulletin boards, banners, art projects, floats, and displays.



Share on Facebook Twitter Pinterest

Ask a question about Fadeless Colored Paper Rolls Ask a question about this product

Fadeless Colored Paper Rolls

by Pacon

Average User Rating: Based on (10 Reviews)

5 10

Doshia H. from Troy, NC says:

Everything was perfect; just as ordered. Also arrived very quickly. Thank you!!

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
14875
Fadeless Colored Paper Rolls apple green 24 in. x 12 ft.
Zoom Image
apple green 24 in. x 12 ft. 57130 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
48902
Fadeless Colored Paper Rolls apple green 48 in. x 50 ft.
Zoom Image
apple green 48 in. x 50 ft. 57135 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
20113
Fadeless Colored Paper Rolls azure blue 24 in. x 12 ft.
Zoom Image
azure blue 24 in. x 12 ft. 57160 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
27472
Fadeless Colored Paper Rolls azure blue 48 in. x 50 ft.
Zoom Image
azure blue 48 in. x 50 ft. 57165 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
10466
Fadeless Colored Paper Rolls black 24 in. x 12 ft.
Zoom Image
black 24 in. x 12 ft. 57300 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
82689
Fadeless Colored Paper Rolls black 48 in. x 50 ft.
Zoom Image
black 48 in. x 50 ft. 57305 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
24704
Fadeless Colored Paper Rolls bright blue 48 in. x 50 ft.
Zoom Image
bright blue 48 in. x 50 ft. 57175 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
31327
Fadeless Colored Paper Rolls brown 24 in. x 12 ft.
Zoom Image
brown 24 in. x 12 ft. 57020 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
32972
Fadeless Colored Paper Rolls canary 48 in. x 50 ft.
Zoom Image
canary 48 in. x 50 ft. 57085 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
39300
Fadeless Colored Paper Rolls canary 24 in. x 12 ft.
Zoom Image
canary 24 in. x 12 ft. 57080 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
34981
Fadeless Colored Paper Rolls dark yellow 48 in. x 50 ft.
Zoom Image
dark yellow 48 in. x 50 ft. 57325 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
47926
Fadeless Colored Paper Rolls emerald green 48 in. x 50 ft.
Zoom Image
emerald green 48 in. x 50 ft. 57145 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
48982
Fadeless Colored Paper Rolls flame 24 in. x 12 ft.
Zoom Image
flame 24 in. x 12 ft. 57030 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
51772
Fadeless Colored Paper Rolls flame 48 in. x 50 ft.
Zoom Image
flame 48 in. x 50 ft. 57035 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
34546
Fadeless Colored Paper Rolls lite green 48 in. x 50 ft.
Zoom Image
lite green 48 in. x 50 ft. 57125 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
77928
Fadeless Colored Paper Rolls magenta 48 in. x 50 ft.
Zoom Image
magenta 48 in. x 50 ft. 57345 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
34826
Fadeless Colored Paper Rolls orange 24 in. x 12 ft.
Zoom Image
orange 24 in. x 12 ft. 57100 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
69331
Fadeless Colored Paper Rolls orange 48 in. x 50 ft.
Zoom Image
orange 48 in. x 50 ft. 57105 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
45512
Fadeless Colored Paper Rolls pink 48 in. x 50 ft.
Zoom Image
pink 48 in. x 50 ft. 57265 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
85533
Fadeless Colored Paper Rolls pink 24 in. x 12 ft.
Zoom Image
pink 24 in. x 12 ft. 57260 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
55349
Fadeless Colored Paper Rolls rich blue 24 in. x 12 ft.
Zoom Image
rich blue 24 in. x 12 ft. 57170 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
75624
Fadeless Colored Paper Rolls rich blue 48 in. x 50 ft.
Zoom Image
rich blue 48 in. x 50 ft. 57185 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
17428
Fadeless Colored Paper Rolls violet 48 in. x 50 ft.
Zoom Image
violet 48 in. x 50 ft. 57335 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
70138
Fadeless Colored Paper Rolls violet 24 in. x 12 ft.
Zoom Image
violet 24 in. x 12 ft. 57330 $4.43 $2.55 42% Off $2.24 50% Off Email When In Stock
Add to Favorites
25467
Fadeless Colored Paper Rolls white 48 in. x 50 ft.
Zoom Image
white 48 in. x 50 ft. 57015 $29.00 $16.75 42% Off $14.64 50% Off Email When In Stock
Add to Favorites
60139
Fadeless Colored Paper Rolls white 24 in. x 12 ft.
Zoom Image
white 24 in. x 12 ft. 57010 $4.43 $2.55 42% Off $2.24 50% 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...

Up to 50% Off

Aurora Washable Tempera

by Chroma Inc.

Cleans up with soap and water

From $2.06

Green Label Silk Colors

by Jacquard

Ideal for coloring silk and wool

From $2.57

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 Fadeless Colored Paper Rolls

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: Doshia H. in Troy, NC
Everything was perfect; just as ordered. Also arrived very quickly. Thank you!!
Rated by: Edie S. in Oak Park, MI
I loved the paper, it was nice and wide and thick. It was the best value I found online for wide rolls of paper. I used it to cover over cardboard scenery which was made for a fundraiser.
Rated by: Judith R. in San Jose, CA
I LOVE the smaller sized rolls of fadeless paper (24x12ft) and have had so much trouble locating the variety of colors UNTIL I found MisterArt. AND the pricing is GREAT!
Rated by: Kay H. in Elk Grove, CA
I use your paper for our church bulletin boards. I love it. It is easy to work with and the colors are superb! The price is great too. I will be back again. Thank you for great products!
Rated by: Sean M. in Cliffwood Beach, NJ
We would like to take the time to say thank you. The roll paper worked out great. We purchased it to use as store front window signs and could not be happier. Thank You, Coastal Design Studio
Rated by: Betsy G. in Snoqualmie, WA
All of the young people loved the way this paper could be used to brighten up their classroom. Now they want more colors!
Rated by: april t. in red hook, NY
this paper is awesome! Nobody has it cheaper on the web. I use it for my bulleting boards at school and love it so much I will buy more. My fellow teachers will also be purchasing some. THank you Misterart!
Rated by: Delora R. in Rockland, WI
Great product - works well for bulletin boards.
Rated by: Mindi M. in Las Vegas, NV
This paper is great. We have given it to all our teachers and it brightens up the school and doesn't fade in the Las Vegas sun. I will continue to buy this paper at MisterArt.com's low prices.
Rated by: Brent N. in Sleepy Eye, MN
This paper was exactly what I was looking for. Translucent enough to trace through with a light box.

Write a Product Review for Fadeless Colored Paper Rolls

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