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

DecoFabric Marker

by Marvy Uchida


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617200101
barcode_type UPC
col1 black
col1_sortorder 402
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.68
deal_of_the_week NO
description black
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 67685
list_price 3.69
map NO
mfr_num 222S#1
net_weight 0.02
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 67685
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 67685
2 222S#1
3 black
timestamp 2015-03-27T14:47:50.343Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617200309
barcode_type UPC
col1 blue
col1_sortorder 542
col2 [empty string]
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.68
deal_of_the_week NO
description blue
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 16945
list_price 3.69
map NO
mfr_num 222S#3
net_weight 0.02
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 16945
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 16945
2 222S#3
3 blue
timestamp 2015-03-27T14:46:36.538Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220604
barcode_type UPC
col1 bronze
col1_sortorder 790
col2 [empty string]
col3 [empty string]
color_swatch 119-79-0.jpg
cost 1.68
deal_of_the_week NO
description bronze
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 27980
list_price 3.69
map NO
mfr_num 222S#BRZ
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 27980
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 27980
2 222S#BRZ
3 bronze
timestamp 2015-03-27T14:46:51.431Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617200606
barcode_type UPC
col1 brown
col1_sortorder 798
col2 [empty string]
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.68
deal_of_the_week NO
description brown
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 44099
list_price 3.69
map NO
mfr_num 222S#6
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 44099
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 44099
2 222S#6
3 brown
timestamp 2015-03-27T14:47:16.669Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220703
barcode_type UPC
col1 copper
col1_sortorder 1527
col2 [empty string]
col3 [empty string]
color_swatch 195-95-47.jpg
cost 1.68
deal_of_the_week NO
description copper
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 17034
list_price 3.69
map NO
mfr_num 222S#CPR
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 17034
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 17034
2 222S#CPR
3 copper
timestamp 2015-03-27T14:46:36.702Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201405
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 [empty string]
col3 [empty string]
color_swatch 182-255-77.jpg
cost 1.68
deal_of_the_week NO
description fluorescent green
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74400
list_price 3.69
map NO
mfr_num 222S#F4
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74400
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74400
2 222S#F4
3 fluorescent green
timestamp 2015-03-27T14:48:04.691Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617211008
barcode_type UPC
col1 fluorescent light blue
col1_sortorder 2218
col2 [empty string]
col3 [empty string]
color_swatch 0-192-255.jpg
cost 1.68
deal_of_the_week NO
description fluorescent light blue
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74406
list_price 3.69
map NO
mfr_num 222S#F10
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74406
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74406
2 222S#F10
3 fluorescent light blue
timestamp 2015-03-27T14:48:04.71Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201702
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 [empty string]
col3 [empty string]
color_swatch 255-190-77.jpg
cost 1.68
deal_of_the_week NO
description fluorescent orange
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74402
list_price 3.69
map NO
mfr_num 222S#F7
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74402
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74402
2 222S#F7
3 fluorescent orange
timestamp 2015-03-27T14:48:04.697Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201900
barcode_type UPC
col1 fluorescent pink
col1_sortorder 2222
col2 [empty string]
col3 [empty string]
color_swatch 255-168-220.jpg
cost 1.68
deal_of_the_week NO
description fluorescent pink
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74405
list_price 3.69
map NO
mfr_num 222S#F9
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74405
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74405
2 222S#F9
3 fluorescent pink
timestamp 2015-03-27T14:48:04.706Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201801
barcode_type UPC
col1 fluorescent violet
col1_sortorder 2230
col2 [empty string]
col3 [empty string]
color_swatch 190-122-255.jpg
cost 1.68
deal_of_the_week NO
description fluorescent violet
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74403
list_price 3.69
map NO
mfr_num 222S#F8
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74403
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74403
2 222S#F8
3 fluorescent violet
timestamp 2015-03-27T14:48:04.7Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201504
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 [empty string]
col3 [empty string]
color_swatch 255-255-122.jpg
cost 1.68
deal_of_the_week NO
description fluorescent yellow
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74401
list_price 3.69
map NO
mfr_num 222S#F5
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74401
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74401
2 222S#F5
3 fluorescent yellow
timestamp 2015-03-27T14:48:04.694Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221106
barcode_type UPC
col1 glitter black
col1_sortorder 2433
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.68
deal_of_the_week NO
description glitter black
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74418
list_price 3.69
map NO
mfr_num 222S#G1
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74418
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74418
2 222S#G1
3 glitter black
timestamp 2015-03-27T14:48:04.736Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221304
barcode_type UPC
col1 glitter blue
col1_sortorder 2434
col2 [empty string]
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.68
deal_of_the_week NO
description glitter blue
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74423
list_price 3.69
map NO
mfr_num 222S#G3
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74423
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74423
2 222S#G3
3 glitter blue
timestamp 2015-03-27T14:48:04.744Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220307
barcode_type UPC
col1 glitter gold
col1_sortorder 2435
col2 [empty string]
col3 [empty string]
color_swatch 195-174-47.jpg
cost 1.68
deal_of_the_week NO
description glitter gold
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74415
list_price 3.69
map NO
mfr_num 222S#GGLD
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74415
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74415
2 222S#GGLD
3 glitter gold
timestamp 2015-03-27T14:48:04.731Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221403
barcode_type UPC
col1 glitter green
col1_sortorder 2436
col2 [empty string]
col3 [empty string]
color_swatch 0-119-106.jpg
cost 1.68
deal_of_the_week NO
description glitter green
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74424
list_price 3.69
map NO
mfr_num 222S#G4
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74424
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74424
2 222S#G4
3 glitter green
timestamp 2015-03-27T14:48:04.746Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221700
barcode_type UPC
col1 glitter orange
col1_sortorder 2438
col2 [empty string]
col3 [empty string]
color_swatch 210-90-0.jpg
cost 1.68
deal_of_the_week NO
description glitter orange
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74426
list_price 3.69
map NO
mfr_num 222S#G7
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74426
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74426
2 222S#G7
3 glitter orange
timestamp 2015-03-27T14:48:04.75Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221205
barcode_type UPC
col1 glitter red
col1_sortorder 2441
col2 [empty string]
col3 [empty string]
color_swatch 195-47-80.jpg
cost 1.68
deal_of_the_week NO
description glitter red
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74420
list_price 3.69
map NO
mfr_num 222S#G2
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74420
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74420
2 222S#G2
3 glitter red
timestamp 2015-03-27T14:48:04.74Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220406
barcode_type UPC
col1 glitter silver
col1_sortorder 2442
col2 [empty string]
col3 [empty string]
color_swatch 210-210-210.jpg
cost 1.68
deal_of_the_week NO
description glitter silver
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74416
list_price 3.69
map NO
mfr_num 222S#GSLV
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74416
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74416
2 222S#GSLV
3 glitter silver
timestamp 2015-03-27T14:48:04.733Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221809
barcode_type UPC
col1 glitter violet
col1_sortorder 2443
col2 [empty string]
col3 [empty string]
color_swatch 99-47-149.jpg
cost 1.68
deal_of_the_week NO
description glitter violet
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74428
list_price 3.69
map NO
mfr_num 222S#G8
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74428
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74428
2 222S#G8
3 glitter violet
timestamp 2015-03-27T14:48:04.754Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221908
barcode_type UPC
col1 glitter white
col1_sortorder 2444
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 1.68
deal_of_the_week NO
description glitter white
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74417
list_price 3.69
map NO
mfr_num 222S#G0
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74417
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74417
2 222S#G0
3 glitter white
timestamp 2015-03-27T14:48:04.735Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617221502
barcode_type UPC
col1 glitter yellow
col1_sortorder 2445
col2 [empty string]
col3 [empty string]
color_swatch 240-213-47.jpg
cost 1.68
deal_of_the_week NO
description glitter yellow
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74425
list_price 3.69
map NO
mfr_num 222S#G5
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74425
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74425
2 222S#G5
3 glitter yellow
timestamp 2015-03-27T14:48:04.748Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220512
barcode_type UPC
col1 glow in the dark
col1_sortorder 2478
col2 [empty string]
col3 [empty string]
color_swatch 205-210-168.jpg
cost 1.68
deal_of_the_week NO
description glow in the dark
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 53008
list_price 3.68
map NO
mfr_num 222-C #GO
net_weight 0.03
non_member_discount 20
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 53008
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.84
ta_dealer_c_price 1.84
ta_price 2.95
text
array
1 53008
2 222-C #GO
3 glow in the dark
timestamp 2015-03-27T14:47:28.245Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617220901
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 [empty string]
col3 [empty string]
color_swatch 195-174-47.jpg
cost 1.68
deal_of_the_week NO
description gold
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 87461
list_price 3.69
map NO
mfr_num 222S#GLD
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 87461
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 87461
2 222S#GLD
3 gold
timestamp 2015-03-27T14:48:19.394Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617200408
barcode_type UPC
col1 green
col1_sortorder 2621
col2 [empty string]
col3 [empty string]
color_swatch 0-119-106.jpg
cost 1.68
deal_of_the_week NO
description green
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 34587
list_price 3.69
map NO
mfr_num 222S#4
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 34587
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 34587
2 222S#4
3 green
timestamp 2015-03-27T14:47:05.152Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617201108
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 [empty string]
col3 [empty string]
color_swatch 0-120-210.jpg
cost 1.68
deal_of_the_week NO
description light blue
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 29183
list_price 3.69
map NO
mfr_num 222S#10
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 29183
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 29183
2 222S#10
3 light blue
timestamp 2015-03-27T14:46:53.093Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617200705
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 [empty string]
col3 [empty string]
color_swatch 210-90-0.jpg
cost 1.68
deal_of_the_week NO
description orange
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 60559
list_price 3.69
map NO
mfr_num 222S#7
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 60559
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 60559
2 222S#7
3 orange
timestamp 2015-03-27T14:47:38.606Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231105
barcode_type UPC
col1 pearl black
col1_sortorder 4450
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.68
deal_of_the_week NO
description pearl black
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74408
list_price 3.69
map NO
mfr_num 222S#P1
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74408
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74408
2 222S#P1
3 pearl black
timestamp 2015-03-27T14:48:04.714Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231303
barcode_type UPC
col1 pearl blue
col1_sortorder 4451
col2 [empty string]
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.68
deal_of_the_week NO
description pearl blue
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74410
list_price 3.69
map NO
mfr_num 222S#P3
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74410
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74410
2 222S#P3
3 pearl blue
timestamp 2015-03-27T14:48:04.718Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231402
barcode_type UPC
col1 pearl green
col1_sortorder 4460
col2 [empty string]
col3 [empty string]
color_swatch 0-119-106.jpg
cost 1.68
deal_of_the_week NO
description pearl green
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74412
list_price 3.69
map NO
mfr_num 222S#P4
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74412
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74412
2 222S#P4
3 pearl green
timestamp 2015-03-27T14:48:04.723Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231907
barcode_type UPC
col1 pearl pink
col1_sortorder 4471
col2 [empty string]
col3 [empty string]
color_swatch 255-77-255.jpg
cost 1.68
deal_of_the_week NO
description pearl pink
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74414
list_price 3.69
map NO
mfr_num 222S#P9
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74414
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74414
2 222S#P9
3 pearl pink
timestamp 2015-03-27T14:48:04.728Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231808
barcode_type UPC
col1 pearl violet
col1_sortorder 4478
col2 [empty string]
col3 [empty string]
color_swatch 99-47-149.jpg
cost 1.68
deal_of_the_week NO
description pearl violet
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74413
list_price 3.69
map NO
mfr_num 222S#P8
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74413
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74413
2 222S#P8
3 pearl violet
timestamp 2015-03-27T14:48:04.726Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


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

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

ItemIDList: 43241
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 028617231006
barcode_type UPC
col1 pearl white
col1_sortorder 4480
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 1.68
deal_of_the_week NO
description pearl white
group_id 7581
group_uname marvy-uchida-decofabric-marker
id 74407
list_price 3.69
map NO
mfr_num 222S#P0
net_weight 0.03
non_member_discount 20
non_member_price 2.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 74407
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.85
ta_dealer_c_price 1.85
ta_price 2.95
text
array
1 74407
2 222S#P0
3 pearl white
timestamp 2015-03-27T14:48:04.712Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 43241
CACHED false
EXECUTIONTIME 1
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] = '14773' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e0303bbd77e094355ace17523c525c202d42
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=activities-projects&CatD=fp~7-15~&gr=klutz-slightly-odd-united-states-of-america.html
urltoken CFID=30192479&CFTOKEN=33202184&jsessionid=e0303bbd77e094355ace17523c525c202d42
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 08:03:42'}
sessionid e030af6071aef209a7534e3f161113117f36
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=fabric-markers&gr=marvy-uchida-decofabric-marker.html
urltoken CFID=30192478&CFTOKEN=73994094&jsessionid=e030af6071aef209a7534e3f161113117f36
validationerror [empty string]


Problem with item sku 21981. Item is found in Solr index but not found in vAvailQt