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

Fome-Cor Board

by Crescent


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 acid-free white
col1_sortorder 494
col2 3/16 in. x 40 in. x 60 in.
col2_sortorder 236
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 8
deal_of_the_week NO
description acid-free white, 3/16 in. x 40 in. x 60 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 18141
list_price 19.41
map NO
mfr_num 11104-6040C
net_weight 2.03
non_member_discount 30
non_member_price 13.59
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 18141
sku_pix NO
supplier_id 1
ta_dealer_a_price 8.73
ta_dealer_c_price 8.73
ta_price 13.59
text
array
1 18141
2 11104-6040C
3 acid-free white, 3/16 in. x 40 in. x 60 in., each
timestamp 2015-03-30T16:19:35.26Z
vip_member_price 11.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 28961-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 acid-free white
col1_sortorder 494
col2 3/8 in. x 48 in. x 96 in.
col2_sortorder 258
col3 pack of 14
col3_sortorder 422
color_swatch 255-255-255.jpg
cost 226.08
deal_of_the_week NO
description acid-free white, 3/8 in. x 48 in. x 96 in., pack of 14
group_id 1270
group_uname crescent-fome-cor-board
id 28961-PK
list_price 548.16
map NO
net_weight 94
non_member_discount 35
non_member_price 356.3
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 28961-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 28961-PK
2 acid-free white, 3/8 in. x 48 in. x 96 in., pack of 14
timestamp 2015-03-30T16:19:54.412Z
vip_member_price 301.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 50079946076658
barcode_type UPC-RANDOM
col1 acid-free white
col1_sortorder 494
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 4.03
deal_of_the_week NO
description acid-free white, 3/16 in. x 32 in. x 40 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 57361
list_price 9.76
map NO
mfr_num 11104-3240C
net_weight 0.75
non_member_discount 30
non_member_price 6.83
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 57361
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.39
ta_dealer_c_price 4.39
ta_price 6.83
text
array
1 57361
2 11104-3240C
3 acid-free white, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-30T16:20:49.688Z
vip_member_price 5.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 57361-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 acid-free white
col1_sortorder 494
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 100.75
deal_of_the_week NO
description acid-free white, 3/16 in. x 32 in. x 40 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 57361-PK
list_price 244
map NO
net_weight 39
non_member_discount 35
non_member_price 158.6
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 57361-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 57361-PK
2 acid-free white, 3/16 in. x 32 in. x 40 in., pack of 25
timestamp 2015-03-30T16:20:49.691Z
vip_member_price 134.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 40 in. x 60 in.
col2_sortorder 236
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 7.49
deal_of_the_week NO
description black-centered, 3/16 in. x 40 in. x 60 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 01404
list_price 18.17
map NO
mfr_num 11188-6040C
net_weight 2.08
non_member_discount 30
non_member_price 12.72
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 01404
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.18
ta_dealer_c_price 8.18
ta_price 12.72
text
array
1 01404
2 11188-6040C
3 black-centered, 3/16 in. x 40 in. x 60 in., each
timestamp 2015-03-30T16:18:52.681Z
vip_member_price 10.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 48 in. x 96 in.
col2_sortorder 237
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 14.34
deal_of_the_week NO
description black-centered, 3/16 in. x 48 in. x 96 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 42647
list_price 34.76
map NO
mfr_num 11188-4896C
net_weight 4.04
non_member_discount 30
non_member_price 24.33
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 42647
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.64
ta_dealer_c_price 15.64
ta_price 24.33
text
array
1 42647
2 11188-4896C
3 black-centered, 3/16 in. x 48 in. x 96 in., each
timestamp 2015-03-30T16:20:26.969Z
vip_member_price 20.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 42647-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 48 in. x 96 in.
col2_sortorder 237
col3 pack of 25
col3_sortorder 445
color_swatch 0-0-0.jpg
cost 358.5
deal_of_the_week NO
description black-centered, 3/16 in. x 48 in. x 96 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 42647-PK
list_price 869
map NO
net_weight 127
non_member_discount 35
non_member_price 564.85
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 42647-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 42647-PK
2 black-centered, 3/16 in. x 48 in. x 96 in., pack of 25
timestamp 2015-03-30T16:20:26.971Z
vip_member_price 477.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
VIP_member_discount 40
barcode 50079946140007
barcode_type UPC-RANDOM
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 1.87
deal_of_the_week NO
description black-centered, 3/16 in. x 20 in. x 30 in., each
flags
array
1 3
group_id 1270
group_uname crescent-fome-cor-board
id 43068
list_price 4.53
map NO
mfr_num 11188-2030C
net_weight 0.52
non_member_discount 30
non_member_price 3.17
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 43068
sku_pix NO
supplier_id 1
ta_dealer_a_price 2.04
ta_dealer_c_price 2.04
ta_price 3.17
text
array
1 43068
2 11188-2030C
3 black-centered, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-30T16:20:27.592Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 43068-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 25
col3_sortorder 445
color_swatch 0-0-0.jpg
cost 46.75
deal_of_the_week NO
description black-centered, 3/16 in. x 20 in. x 30 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 43068-PK
list_price 113.25
map NO
net_weight 16
non_member_discount 35
non_member_price 73.61
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 43068-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 43068-PK
2 black-centered, 3/16 in. x 20 in. x 30 in., pack of 25
timestamp 2015-03-30T16:20:27.597Z
vip_member_price 62.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 50079946042660
barcode_type UPC-RANDOM
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 4.15
deal_of_the_week NO
description black-centered, 3/16 in. x 32 in. x 40 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 85240
list_price 10.06
map NO
mfr_num 11188-3240C
net_weight 0.75
non_member_discount 30
non_member_price 7.04
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 85240
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.53
ta_dealer_c_price 4.53
ta_price 7.04
text
array
1 85240
2 11188-3240C
3 black-centered, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-30T16:21:53.886Z
vip_member_price 6.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 85240-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 black-centered
col1_sortorder 1043
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 25
col3_sortorder 445
color_swatch 0-0-0.jpg
cost 103.75
deal_of_the_week NO
description black-centered, 3/16 in. x 32 in. x 40 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 85240-PK
list_price 251.5
map NO
net_weight 34
non_member_discount 35
non_member_price 163.48
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 85240-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 85240-PK
2 black-centered, 3/16 in. x 32 in. x 40 in., pack of 25
timestamp 2015-03-30T16:21:53.888Z
vip_member_price 138.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 50079946045777
barcode_type UPC-RANDOM
col1 white
col1_sortorder 6563
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 2.78
deal_of_the_week NO
description white, 3/16 in. x 32 in. x 40 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 13201
list_price 6.75
map NO
mfr_num 11101-3240C
net_weight 0.75
non_member_discount 30
non_member_price 4.73
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 13201
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.04
ta_dealer_c_price 3.04
ta_price 4.73
text
array
1 13201
2 11101-3240C
3 white, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-30T16:19:20.142Z
vip_member_price 4.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 13201-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 69.5
deal_of_the_week NO
description white, 3/16 in. x 32 in. x 40 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 13201-PK
list_price 168.75
map NO
net_weight 37
non_member_discount 35
non_member_price 109.69
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 13201-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 13201-PK
2 white, 3/16 in. x 32 in. x 40 in., pack of 25
timestamp 2015-03-30T16:19:20.146Z
vip_member_price 92.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 white
col1_sortorder 6563
col2 1/8 in. x 32 in. x 40 in.
col2_sortorder 219
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 2.78
deal_of_the_week NO
description white, 1/8 in. x 32 in. x 40 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 16855
list_price 6.75
map NO
mfr_num 11801-3240C
net_weight 0.75
non_member_discount 30
non_member_price 4.73
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 16855
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.04
ta_dealer_c_price 3.04
ta_price 4.73
text
array
1 16855
2 11801-3240C
3 white, 1/8 in. x 32 in. x 40 in., each
timestamp 2015-03-30T16:19:33.327Z
vip_member_price 4.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 16855-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 1/8 in. x 32 in. x 40 in.
col2_sortorder 219
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 69.5
deal_of_the_week NO
description white, 1/8 in. x 32 in. x 40 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 16855-PK
list_price 168.75
map NO
net_weight 30
non_member_discount 35
non_member_price 109.69
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 16855-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 16855-PK
2 white, 1/8 in. x 32 in. x 40 in., pack of 25
timestamp 2015-03-30T16:19:33.332Z
vip_member_price 92.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 white
col1_sortorder 6563
col2 3/16 in. x 48 in. x 96 in.
col2_sortorder 237
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 10.24
deal_of_the_week NO
description white, 3/16 in. x 48 in. x 96 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 25466
list_price 24.82
map NO
mfr_num 11101-4896C
net_weight 4.04
non_member_discount 30
non_member_price 17.37
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 25466
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.17
ta_dealer_c_price 11.17
ta_price 17.37
text
array
1 25466
2 11101-4896C
3 white, 3/16 in. x 48 in. x 96 in., each
timestamp 2015-03-30T16:19:48.144Z
vip_member_price 14.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 25466-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/16 in. x 48 in. x 96 in.
col2_sortorder 237
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 256
deal_of_the_week NO
description white, 3/16 in. x 48 in. x 96 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 25466-PK
list_price 620.5
map NO
net_weight 127
non_member_discount 35
non_member_price 403.33
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 25466-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 25466-PK
2 white, 3/16 in. x 48 in. x 96 in., pack of 25
timestamp 2015-03-30T16:19:48.147Z
vip_member_price 341.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 50079946074791
barcode_type UPC-RANDOM
col1 white
col1_sortorder 6563
col2 3/16 in. x 40 in. x 60 in.
col2_sortorder 236
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 5.2
deal_of_the_week NO
description white, 3/16 in. x 40 in. x 60 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 26316
list_price 12.6
map NO
mfr_num 11101-6040C
net_weight 2.25
non_member_discount 30
non_member_price 8.82
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 26316
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.67
ta_dealer_c_price 5.67
ta_price 8.82
text
array
1 26316
2 11101-6040C
3 white, 3/16 in. x 40 in. x 60 in., each
timestamp 2015-03-30T16:19:50.195Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 white
col1_sortorder 6563
col2 3/8 in. x 48 in. x 96 in.
col2_sortorder 258
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 18.84
deal_of_the_week NO
description white, 3/8 in. x 48 in. x 96 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 28961
list_price 45.68
map NO
mfr_num 11301-4896C
net_weight 5.29
non_member_discount 30
non_member_price 31.98
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 28961
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.56
ta_dealer_c_price 20.56
ta_price 31.98
text
array
1 28961
2 11301-4896C
3 white, 3/8 in. x 48 in. x 96 in., each
timestamp 2015-03-30T16:19:54.4Z
vip_member_price 27.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
VIP_member_discount 40
col1 white
col1_sortorder 6563
col2 3/16 in. x 24 in. x 36 in.
col2_sortorder 233
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 2.17
deal_of_the_week NO
description white, 3/16 in. x 24 in. x 36 in., each
flags
array
1 3
group_id 1270
group_uname crescent-fome-cor-board
id 71200
list_price 5.27
map NO
mfr_num 11101-2436C
net_weight 0.75
non_member_discount 30
non_member_price 3.69
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 71200
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.69
text
array
1 71200
2 11101-2436C
3 white, 3/16 in. x 24 in. x 36 in., each
timestamp 2015-03-30T16:21:28.582Z
vip_member_price 3.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 71200-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/16 in. x 24 in. x 36 in.
col2_sortorder 233
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 54.25
deal_of_the_week NO
description white, 3/16 in. x 24 in. x 36 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 71200-PK
list_price 131.75
map NO
net_weight 24
non_member_discount 35
non_member_price 85.64
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 71200-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 71200-PK
2 white, 3/16 in. x 24 in. x 36 in., pack of 25
timestamp 2015-03-30T16:21:28.591Z
vip_member_price 72.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
col1 white
col1_sortorder 6563
col2 3/8 in. x 40 in. x 60 in.
col2_sortorder 257
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 8.89
deal_of_the_week NO
description white, 3/8 in. x 40 in. x 60 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 75549
list_price 21.57
map NO
mfr_num 11301-6040C
net_weight 2.68
non_member_discount 30
non_member_price 15.1
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 75549
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.71
ta_dealer_c_price 9.71
ta_price 15.1
text
array
1 75549
2 11301-6040C
3 white, 3/8 in. x 40 in. x 60 in., each
timestamp 2015-03-30T16:21:40.297Z
vip_member_price 12.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 75549-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/8 in. x 40 in. x 60 in.
col2_sortorder 257
col3 pack of 14
col3_sortorder 422
color_swatch 255-255-255.jpg
cost 124.46
deal_of_the_week NO
description white, 3/8 in. x 40 in. x 60 in., pack of 14
group_id 1270
group_uname crescent-fome-cor-board
id 75549-PK
list_price 301.98
map NO
net_weight 42
non_member_discount 35
non_member_price 196.29
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 75549-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 75549-PK
2 white, 3/8 in. x 40 in. x 60 in., pack of 14
timestamp 2015-03-30T16:21:40.299Z
vip_member_price 166.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
VIP_member_discount 40
barcode 50079946137458
barcode_type UPC-RANDOM
col1 white
col1_sortorder 6563
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 1.49
deal_of_the_week NO
description white, 3/16 in. x 20 in. x 30 in., each
flags
array
1 3
group_id 1270
group_uname crescent-fome-cor-board
id 75772
list_price 3.61
map NO
mfr_num 11101-3020C
net_weight 0.76
non_member_discount 30
non_member_price 2.53
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 75772
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.62
ta_dealer_c_price 1.62
ta_price 2.53
text
array
1 75772
2 11101-3020C
3 white, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-30T16:21:40.498Z
vip_member_price 2.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 75772-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 37.25
deal_of_the_week NO
description white, 3/16 in. x 20 in. x 30 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 75772-PK
list_price 90.25
map NO
net_weight 18
non_member_discount 35
non_member_price 58.66
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 75772-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 75772-PK
2 white, 3/16 in. x 20 in. x 30 in., pack of 25
timestamp 2015-03-30T16:21:40.499Z
vip_member_price 49.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


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

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 50079946144609
barcode_type UPC-RANDOM
col1 white
col1_sortorder 6563
col2 3/16 in. x 30 in. x 40 in.
col2_sortorder 234
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 2.75
deal_of_the_week NO
description white, 3/16 in. x 30 in. x 40 in., each
group_id 1270
group_uname crescent-fome-cor-board
id 88151
list_price 6.66
map NO
mfr_num 11101-3040C
net_weight 0.75
non_member_discount 30
non_member_price 4.66
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 88151
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.66
text
array
1 88151
2 11101-3040C
3 white, 3/16 in. x 30 in. x 40 in., each
timestamp 2015-03-30T16:22:00.262Z
vip_member_price 4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Problem with item sku 88151-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 30612
AvailQtyList: 33.000000000000

struct
FLAGS 0
VIP_member_discount 45
col1 white
col1_sortorder 6563
col2 3/16 in. x 30 in. x 40 in.
col2_sortorder 234
col3 pack of 25
col3_sortorder 445
color_swatch 255-255-255.jpg
cost 68.75
deal_of_the_week NO
description white, 3/16 in. x 30 in. x 40 in., pack of 25
group_id 1270
group_uname crescent-fome-cor-board
id 88151-PK
list_price 166.5
map NO
net_weight 33
non_member_discount 35
non_member_price 108.23
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 88151-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 88151-PK
2 white, 3/16 in. x 30 in. x 40 in., pack of 25
timestamp 2015-03-30T16:22:00.279Z
vip_member_price 91.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 33.000000000000 30612
CACHED false
EXECUTIONTIME 2
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] = '2629' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d23714d35454627d562c3c4c206d6d61
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~fp~0-8~&gr=3m-scotch-package-sealing-tape.html
urltoken CFID=30233636&CFTOKEN=66869279&jsessionid=e030d23714d35454627d562c3c4c206d6d61
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:33:26'}
sessionid e030d70a25bdfe2e352ab5c384a5a4c233e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=fp~6-15~&gr=crescent-fome-cor-board.html
urltoken CFID=30233635&CFTOKEN=79995228&jsessionid=e030d70a25bdfe2e352ab5c384a5a4c233e7
validationerror [empty string]


Fome-Cor is an innovative board that can be used for a wide variety of applications, including exhibits, POP displays, signage, photo mounting, screen-printing, and framing.

The polystyrene core is bonded between high-quality papers to create a lightweight, reliably rigid, ultra-smooth board. Fome-Cor simplifies production, resists warping, and cuts cleanly.

White Fome-Cor is laminated on both sides with clay-coated papers and has a white core. It’s perfect for all general mounting applications as well as die-cutting and embossing.

Black-Centered Fome-Cor has a crisp black core that is laminated between high-quality uncoated black papers. It’s ideal for mounting photographs, prints, presentations, and other materials.

Acid-Free Fome-Cor uses papers that are made of high alpha-cellulose virgin pulp. The board is lignin-free and ideal for all conservation-grade mounting applications.



Share on Facebook Twitter Pinterest

Ask a question about Fome-Cor Board Ask a question about this product  |  See all questions & answers (2)

Fome-Cor Board

by Crescent

Average User Rating: Based on (12 Reviews)

5 12

Marti G. from Port Orchard, WA says:

This fome-cor is of great quality. The size is just right for shipping prints and selling prints in the gallery. The cost is very affordable with the best quality.

[Read All Reviews] [Write a Review]









  Item# Swatch Image description
Ascending
size unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
  acid-free white 3/16 in. x 40 in. x 60 in. each 11104-6040C $19.41 $13.59 30% Off $11.65 40% Off Email When In Stock
Add to Favorites
  acid-free white 3/8 in. x 48 in. x 96 in. pack of 14 $548.16 $356.30 35% Off $301.49 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board acid-free white 3/16 in. x 32 in. x 40 in. each
Zoom Image
acid-free white 3/16 in. x 32 in. x 40 in. each 11104-3240C $9.76 $6.83 30% Off $5.86 40% Off Email When In Stock
Add to Favorites
  acid-free white 3/16 in. x 32 in. x 40 in. pack of 25 $244.00 $158.60 35% Off $134.20 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board black-centered 3/16 in. x 40 in. x 60 in. each
Zoom Image
black-centered 3/16 in. x 40 in. x 60 in. each 11188-6040C $18.17 $12.72 30% Off $10.90 40% Off Email When In Stock
Add to Favorites
Fome-Cor Board black-centered 3/16 in. x 48 in. x 96 in. each
Zoom Image
black-centered 3/16 in. x 48 in. x 96 in. each 11188-4896C $34.76 $24.33 30% Off $20.86 40% Off Email When In Stock
Add to Favorites
  black-centered 3/16 in. x 48 in. x 96 in. pack of 25 $869.00 $564.85 35% Off $477.95 45% Off Email When In Stock
Add to Favorites
  black-centered 3/16 in. x 20 in. x 30 in. each 11188-2030C $4.53 $3.17 30% Off $2.72 40% Off Email When In Stock
Add to Favorites
  black-centered 3/16 in. x 20 in. x 30 in. pack of 25 $113.25 $73.61 35% Off $62.29 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board black-centered 3/16 in. x 32 in. x 40 in. each
Zoom Image
black-centered 3/16 in. x 32 in. x 40 in. each 11188-3240C $10.06 $7.04 30% Off $6.04 40% Off Email When In Stock
Add to Favorites
  black-centered 3/16 in. x 32 in. x 40 in. pack of 25 $251.50 $163.48 35% Off $138.33 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 32 in. x 40 in. each
Zoom Image
white 3/16 in. x 32 in. x 40 in. each 11101-3240C $6.75 $4.73 30% Off $4.05 40% Off Email When In Stock
Add to Favorites
  white 3/16 in. x 32 in. x 40 in. pack of 25 $168.75 $109.69 35% Off $92.81 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 1/8 in. x 32 in. x 40 in. each
Zoom Image
white 1/8 in. x 32 in. x 40 in. each 11801-3240C $6.75 $4.73 30% Off $4.05 40% Off Email When In Stock
Add to Favorites
  white 1/8 in. x 32 in. x 40 in. pack of 25 $168.75 $109.69 35% Off $92.81 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 48 in. x 96 in. each
Zoom Image
white 3/16 in. x 48 in. x 96 in. each 11101-4896C $24.82 $17.37 30% Off $14.89 40% Off Email When In Stock
Add to Favorites
  white 3/16 in. x 48 in. x 96 in. pack of 25 $620.50 $403.33 35% Off $341.28 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 40 in. x 60 in. each
Zoom Image
white 3/16 in. x 40 in. x 60 in. each 11101-6040C $12.60 $8.82 30% Off $7.56 40% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/8 in. x 48 in. x 96 in. each
Zoom Image
white 3/8 in. x 48 in. x 96 in. each 11301-4896C $45.68 $31.98 30% Off $27.41 40% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 24 in. x 36 in. each
Zoom Image
white 3/16 in. x 24 in. x 36 in. each 11101-2436C $5.27 $3.69 30% Off $3.16 40% Off Email When In Stock
Add to Favorites
  white 3/16 in. x 24 in. x 36 in. pack of 25 $131.75 $85.64 35% Off $72.46 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/8 in. x 40 in. x 60 in. each
Zoom Image
white 3/8 in. x 40 in. x 60 in. each 11301-6040C $21.57 $15.10 30% Off $12.94 40% Off Email When In Stock
Add to Favorites
  white 3/8 in. x 40 in. x 60 in. pack of 14 $301.98 $196.29 35% Off $166.09 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 20 in. x 30 in. each
Zoom Image
white 3/16 in. x 20 in. x 30 in. each 11101-3020C $3.61 $2.53 30% Off $2.17 40% Off Email When In Stock
Add to Favorites
  white 3/16 in. x 20 in. x 30 in. pack of 25 $90.25 $58.66 35% Off $49.64 45% Off Email When In Stock
Add to Favorites
Fome-Cor Board white 3/16 in. x 30 in. x 40 in. each
Zoom Image
white 3/16 in. x 30 in. x 40 in. each 11101-3040C $6.66 $4.66 30% Off $4.00 40% Off Email When In Stock
Add to Favorites
  white 3/16 in. x 30 in. x 40 in. pack of 25 $166.50 $108.23 35% Off $91.58 45% 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...

Positionable Mounting Adhesive 568

by Scotch

Professional mounting with no heat

Up to 35% Off

Up to 30% Off

No. 11 Blades

by X-Acto

The blades you trust for less

Up to 37% Off

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

I am interested in the 48 in. x 96 in. black foam boards. What is the minimum order of foam boards that you can order?

- Asked by Sandra on 01-Nov-13
Answer

There is no minimum order, but at this size it will have to go LTL Freight. It is recommended, so that it does not get damaged, that you order the full case of 25, so that it can be packed in it's original case.

- Answered by MisterArt on 01-Nov-13

Can the Acid Free White FomeCor be used as an outdoor sign for 3 to 6 consecutive months in any weather condition?

- Asked by Julieta Issa on 15-Nov-12
Answer

The FomeCor boards are not coated with a weather-proof and / or UV protection finish. This will not hold up under bad weather conditions.

- Answered by MisterArt on 20-Nov-12

Ask a Question About Fome-Cor Board


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: Marti G. in Port Orchard, WA
This fome-cor is of great quality. The size is just right for shipping prints and selling prints in the gallery. The cost is very affordable with the best quality.
Rated by: christine g. in altus, OK
exactly what I was looking for; I'm not sure whose idea the packaging was (fome-cor or mister art) but it arrived almost flawlessly intact, which is something I did not expect of the edges of such a soft product, and also arrived in lightening fast speed. I'll buy again and again from mister art now that I've found it! thank you!
Rated by: Paulette M. in Nassau, Bahamas, FL
Good quality at an affordable price. It has worked out well for me and gives me the flexibility to do a variety of things.
Rated by: beverly w. in Cumberland, MD
This foam board is a staple for framing my work and I try to keep a good supply. MisterArt is so good at getting a new batch of it to me quickly when I run low both on board and time.
Rated by: Belinda B. in Port Republic, MD
Great board.Strong and sturdy.Many uses
Rated by: Mike M. in Hunt Valley, MD
My company has used these boards for several years to mount all of our presentations with excellent results and very little "bowing".
Rated by: beverly w. in Cumberland, MD
This foam board is a staple for me and MisterArt.com gives me a great price on it. I never notice I'm almost out of it until I'm in a big rush to frame a bunch of work, but I can always count on MisterArt.com to get my order to me pronto!
Rated by: L W. in Willows, CA
This foam board has proven to be a quality backing for canvas and heavy poster products. I have used a variety of spray and liquid adhesives and all worked excellent. I have used rubbing alcohol to remove minor spray adhesive overspray, with no apparent damgage to the board covering. Very strong and cuts easily. Just an excellent overall product.
Rated by: DeAnn M. in Ouray, CO
This foam board has proven to be an excellent backing for my framed watercolors and colored pencil art. It's consistent in texture with a smooth exterior, and was easy to cut with a utility knife.
Rated by: carole C. in bellingham, WA
thank you so much for making my life easier. The foam core boards are easy to maneuver and store and they come undamaged. I even used the empty boxes to transport my paintings to a show this weekend.
Rated by: Allison W. in Jacksonville, FL
As an amatuer artist, I needed to save money, so buying in quantity made sense. Fast Delivery, excellent product. Saved loads of money!
Rated by: Lana B. in Chuluota, FL
As an amature artist I use foam board to mount my paintings, but don't need a full case as most foam board is sold. It was nice to buy just the amount I need. Quality of the product is great, and I received it within days of my order.

Write a Product Review for Fome-Cor Board

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