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

My Carry All Tote

by Filexec


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349821
barcode_type UPC
col1 15 in. x 18 in.
col1_sortorder 959
col2 strawberry
col2_sortorder 5835
col3 [empty string]
cost 5.6
deal_of_the_week NO
description 15 in. x 18 in., strawberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 18265
list_price 12
map NO
mfr_num 34982
net_weight 0.87
non_member_discount 20
non_member_price 9.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 18265
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.48
ta_price 9.6
text
array
1 18265
2 34982
3 15 in. x 18 in., strawberry
timestamp 2015-04-01T21:25:39.866Z
vip_member_price 8.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349814
barcode_type UPC
col1 15 in. x 18 in.
col1_sortorder 959
col2 blueberry
col2_sortorder 627
col3 [empty string]
cost 5.6
deal_of_the_week NO
description 15 in. x 18 in., blueberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 26097
list_price 12
map NO
mfr_num 34981
net_weight 0.85
non_member_discount 20
non_member_price 9.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 26097
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.48
ta_price 9.6
text
array
1 26097
2 34981
3 15 in. x 18 in., blueberry
timestamp 2015-04-01T21:25:49.158Z
vip_member_price 8.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349852
barcode_type UPC
col1 15 in. x 18 in.
col1_sortorder 959
col2 lime
col2_sortorder 3466
col3 [empty string]
cost 5.6
deal_of_the_week NO
description 15 in. x 18 in., lime
group_id 10491
group_uname filexec-my-carry-all-tote
id 31694
list_price 12
map NO
mfr_num 34985
net_weight 0.87
non_member_discount 20
non_member_price 9.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 31694
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.48
ta_price 9.6
text
array
1 31694
2 34985
3 15 in. x 18 in., lime
timestamp 2015-04-01T21:25:57.992Z
vip_member_price 8.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349845
barcode_type UPC
col1 15 in. x 18 in.
col1_sortorder 959
col2 grape
col2_sortorder 2576
col3 [empty string]
cost 5.6
deal_of_the_week NO
description 15 in. x 18 in., grape
group_id 10491
group_uname filexec-my-carry-all-tote
id 32752
list_price 12
map NO
mfr_num 34984
net_weight 0.89
non_member_discount 20
non_member_price 9.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 32752
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.48
ta_price 9.6
text
array
1 32752
2 34984
3 15 in. x 18 in., grape
timestamp 2015-04-01T21:26:00.121Z
vip_member_price 8.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349517
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 blueberry
col2_sortorder 627
col3 [empty string]
cost 6.53
deal_of_the_week NO
description 18 in. x 24 in., blueberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 68147
list_price 13.99
map NO
mfr_num 34951
net_weight 1.35
non_member_discount 20
non_member_price 11.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68147
sku_pix YES
supplier_id 1
ta_dealer_a_price 7
ta_dealer_c_price 7
ta_price 11.19
text
array
1 68147
2 34951
3 18 in. x 24 in., blueberry
timestamp 2015-04-01T21:26:54.997Z
vip_member_price 9.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349524
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 strawberry
col2_sortorder 5835
col3 [empty string]
cost 6.53
deal_of_the_week NO
description 18 in. x 24 in., strawberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 68148
list_price 13.99
map NO
mfr_num 34952
net_weight 1.24
non_member_discount 20
non_member_price 11.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68148
sku_pix YES
supplier_id 1
ta_dealer_a_price 7
ta_dealer_c_price 7
ta_price 11.19
text
array
1 68148
2 34952
3 18 in. x 24 in., strawberry
timestamp 2015-04-01T21:26:55.002Z
vip_member_price 9.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349548
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 grape
col2_sortorder 2576
col3 [empty string]
cost 6.53
deal_of_the_week NO
description 18 in. x 24 in., grape
group_id 10491
group_uname filexec-my-carry-all-tote
id 68150
list_price 13.99
map NO
mfr_num 34954
net_weight 1.21
non_member_discount 20
non_member_price 11.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68150
sku_pix YES
supplier_id 1
ta_dealer_a_price 7
ta_dealer_c_price 7
ta_price 11.19
text
array
1 68150
2 34954
3 18 in. x 24 in., grape
timestamp 2015-04-01T21:26:55.004Z
vip_member_price 9.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349555
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 lime
col2_sortorder 3466
col3 [empty string]
cost 6.53
deal_of_the_week NO
description 18 in. x 24 in., lime
group_id 10491
group_uname filexec-my-carry-all-tote
id 68151
list_price 13.99
map NO
mfr_num 34955
net_weight 1.24
non_member_discount 20
non_member_price 11.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68151
sku_pix YES
supplier_id 1
ta_dealer_a_price 7
ta_dealer_c_price 7
ta_price 11.19
text
array
1 68151
2 34955
3 18 in. x 24 in., lime
timestamp 2015-04-01T21:26:55.006Z
vip_member_price 9.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888340507
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 black
col2_sortorder 402
col3 [empty string]
cost 6.53
deal_of_the_week NO
description 18 in. x 24 in., black
group_id 10491
group_uname filexec-my-carry-all-tote
id 68181
list_price 13.99
map NO
mfr_num 34050-7
net_weight 1.23
non_member_discount 20
non_member_price 11.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68181
sku_pix YES
supplier_id 1
ta_dealer_a_price 7
ta_dealer_c_price 7
ta_price 11.19
text
array
1 68181
2 34050-7
3 18 in. x 24 in., black
timestamp 2015-04-01T21:26:55.071Z
vip_member_price 9.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349623
barcode_type UPC
col1 21 in. x 27 in.
col1_sortorder 1288
col2 strawberry
col2_sortorder 5835
col3 [empty string]
cost 7.93
deal_of_the_week NO
description 21 in. x 27 in., strawberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 12335
list_price 16.99
map NO
mfr_num 34962
net_weight 1.68
non_member_discount 20
non_member_price 13.59
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 12335
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 8.5
ta_price 13.59
text
array
1 12335
2 34962
3 21 in. x 27 in., strawberry
timestamp 2015-04-01T21:25:30.513Z
vip_member_price 11.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349647
barcode_type UPC-RANDOM
col1 21 in. x 27 in.
col1_sortorder 1288
col2 grape
col2_sortorder 2576
col3 [empty string]
cost 7.93
deal_of_the_week NO
description 21 in. x 27 in., grape
group_id 10491
group_uname filexec-my-carry-all-tote
id 13687
list_price 16.99
map NO
mfr_num 34964
net_weight 1.7
non_member_discount 20
non_member_price 13.59
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 13687
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 8.5
ta_price 13.59
text
array
1 13687
2 34964
3 21 in. x 27 in., grape
timestamp 2015-04-01T21:25:33.268Z
vip_member_price 11.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349616
barcode_type UPC
col1 21 in. x 27 in.
col1_sortorder 1288
col2 blueberry
col2_sortorder 627
col3 [empty string]
cost 7.93
deal_of_the_week NO
description 21 in. x 27 in., blueberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 17643
list_price 16.99
map NO
mfr_num 34961
net_weight 1.62
non_member_discount 20
non_member_price 13.59
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 17643
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 8.5
ta_price 13.59
text
array
1 17643
2 34961
3 21 in. x 27 in., blueberry
timestamp 2015-04-01T21:25:39.51Z
vip_member_price 11.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349609
barcode_type UPC
col1 21 in. x 27 in.
col1_sortorder 1288
col2 lime
col2_sortorder 3466
col3 [empty string]
cost 7.93
deal_of_the_week NO
description 21 in. x 27 in., lime
group_id 10491
group_uname filexec-my-carry-all-tote
id 26645
list_price 16.99
map NO
mfr_num 34965
net_weight 1.71
non_member_discount 20
non_member_price 13.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 26645
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 8.5
ta_price 13.59
text
array
1 26645
2 34965
3 21 in. x 27 in., lime
timestamp 2015-04-01T21:25:49.862Z
vip_member_price 11.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349715
barcode_type UPC
col1 24 in. x 32 in.
col1_sortorder 1351
col2 blueberry
col2_sortorder 627
col3 [empty string]
cost 9.33
deal_of_the_week NO
description 24 in. x 32 in., blueberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 68155
list_price 19.99
map NO
mfr_num 34971
net_weight 1.97
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 68155
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.99
text
array
1 68155
2 34971
3 24 in. x 32 in., blueberry
timestamp 2015-04-01T21:26:55.022Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349722
barcode_type UPC
col1 24 in. x 32 in.
col1_sortorder 1351
col2 strawberry
col2_sortorder 5835
col3 [empty string]
cost 9.33
deal_of_the_week NO
description 24 in. x 32 in., strawberry
group_id 10491
group_uname filexec-my-carry-all-tote
id 68163
list_price 19.99
map NO
mfr_num 34972
net_weight 1.97
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 68163
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.99
text
array
1 68163
2 34972
3 24 in. x 32 in., strawberry
timestamp 2015-04-01T21:26:55.032Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349746
barcode_type UPC
col1 24 in. x 32 in.
col1_sortorder 1351
col2 grape
col2_sortorder 2576
col3 [empty string]
cost 9.33
deal_of_the_week NO
description 24 in. x 32 in., grape
group_id 10491
group_uname filexec-my-carry-all-tote
id 68164
list_price 19.99
map NO
mfr_num 34974
net_weight 1.97
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 68164
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.99
text
array
1 68164
2 34974
3 24 in. x 32 in., grape
timestamp 2015-04-01T21:26:55.038Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888349753
barcode_type UPC
col1 24 in. x 32 in.
col1_sortorder 1351
col2 lime
col2_sortorder 3466
col3 [empty string]
cost 9.33
deal_of_the_week NO
description 24 in. x 32 in., lime
group_id 10491
group_uname filexec-my-carry-all-tote
id 68168
list_price 19.99
map NO
mfr_num 34975
net_weight 1.97
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 68168
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.99
text
array
1 68168
2 34975
3 24 in. x 32 in., lime
timestamp 2015-04-01T21:26:55.05Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


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

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

ItemIDList: 00351,00352,00358,02466,02468,02469,02470,02472,02473,02475,02476,02477,02479,02480,02481,02482,02483,02484,02485,02487,91979
AvailQtyList: 3.000000000000,5.000000000000,5.000000000000,5.000000000000,4.000000000000,6.000000000000,10.000000000000,10.000000000000,8.000000000000,7.000000000000,3.000000000000,7.000000000000,13.000000000000,3.000000000000,6.000000000000,6.000000000000,9.000000000000,6.000000000000,6.000000000000,6.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 711888340705
barcode_type UPC
col1 24 in. x 32 in.
col1_sortorder 1351
col2 black
col2_sortorder 402
col3 [empty string]
cost 9.33
deal_of_the_week NO
description 24 in. x 32 in., black
group_id 10491
group_uname filexec-my-carry-all-tote
id 68179
list_price 19.99
map NO
mfr_num 34070-5
net_weight 1.97
non_member_discount 20
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 68179
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.99
text
array
1 68179
2 34070-5
3 24 in. x 32 in., black
timestamp 2015-04-01T21:26:55.066Z
vip_member_price 13.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 00351
2 5.000000000000 00352
3 5.000000000000 00358
4 5.000000000000 02466
5 4.000000000000 02468
6 6.000000000000 02469
7 10.000000000000 02470
8 10.000000000000 02472
9 8.000000000000 02473
10 7.000000000000 02475
11 3.000000000000 02476
12 7.000000000000 02477
13 13.000000000000 02479
14 3.000000000000 02480
15 6.000000000000 02481
16 6.000000000000 02482
17 9.000000000000 02483
18 6.000000000000 02484
19 6.000000000000 02485
20 6.000000000000 02487
21 5.000000000000 91979
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] = '11448' 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.163.106.31

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:30'}
sessionid e0301511711f8b99b19a24316d53323d4861
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=designs-motifs&CatD=sort~1~fb~dover~fp~0-5~&gr=dover-creative-haven-coloring-books.html
urltoken CFID=30910953&CFTOKEN=30387124&jsessionid=e0301511711f8b99b19a24316d53323d4861
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 22:10:31'}
sessionid e030a33667062e8bd2ab597c7e276210e216
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=fb~filexec~fp~4-13~&gr=filexec-my-carry-all-tote.html
urltoken CFID=30910954&CFTOKEN=52027685&jsessionid=e030a33667062e8bd2ab597c7e276210e216
validationerror [empty string]


My Carry All portfolios feature a 3-inch fabric gusset, a zipper closure, and a nylon double-stitched shoulder strap. These totes come with a variety of storage space, including an inside sheet protector, with a CD and business card holder. The reinforced stitching and gusset will help you transport most large or heavy art projects, as well as drawings on paper! Available in an assortment of colors with a frosted finish, and in varying sizes.

Share on Facebook Twitter Pinterest

Ask a question about My Carry All Tote Ask a question about this product  |  See all questions & answers (3)

My Carry All Tote

by Filexec

Average User Rating: Based on (1 Review)

5 1

Casey V. from Los Angeles, CA says:

I needed something to tote around my posters (which are mounted on a stiff foam core). I carry them frequently from work to home in the car, on mass transit. Need some protection from the elements so...[more]

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
color Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
18265
My Carry All Tote 15 in. x 18 in. strawberry
Zoom Image
15 in. x 18 in. strawberry 34982 $12.00 $9.59 20% Off $8.39 30% Off Email When In Stock
Add to Favorites
26097
My Carry All Tote 15 in. x 18 in. blueberry
Zoom Image
15 in. x 18 in. blueberry 34981 $12.00 $9.59 20% Off $8.39 30% Off Email When In Stock
Add to Favorites
31694
My Carry All Tote 15 in. x 18 in. lime
Zoom Image
15 in. x 18 in. lime 34985 $12.00 $9.59 20% Off $8.39 30% Off Email When In Stock
Add to Favorites
32752
My Carry All Tote 15 in. x 18 in. grape
Zoom Image
15 in. x 18 in. grape 34984 $12.00 $9.59 20% Off $8.39 30% Off Email When In Stock
Add to Favorites
68147
My Carry All Tote 18 in. x 24 in. blueberry
Zoom Image
18 in. x 24 in. blueberry 34951 $13.99 $11.19 20% Off $9.79 30% Off Email When In Stock
Add to Favorites
68148
My Carry All Tote 18 in. x 24 in. strawberry
Zoom Image
18 in. x 24 in. strawberry 34952 $13.99 $11.19 20% Off $9.79 30% Off Email When In Stock
Add to Favorites
68150
My Carry All Tote 18 in. x 24 in. grape
Zoom Image
18 in. x 24 in. grape 34954 $13.99 $11.19 20% Off $9.79 30% Off Email When In Stock
Add to Favorites
68151
My Carry All Tote 18 in. x 24 in. lime
Zoom Image
18 in. x 24 in. lime 34955 $13.99 $11.19 20% Off $9.79 30% Off Email When In Stock
Add to Favorites
68181
My Carry All Tote 18 in. x 24 in. black
Zoom Image
18 in. x 24 in. black 34050-7 $13.99 $11.19 20% Off $9.79 30% Off Email When In Stock
Add to Favorites My Carry All Tote 21 in. x 27 in. strawberry
Zoom Image
21 in. x 27 in. strawberry 34962 $16.99 $13.59 20% Off $11.89 30% Off Email When In Stock
Add to Favorites My Carry All Tote 21 in. x 27 in. grape
Zoom Image
21 in. x 27 in. grape 34964 $16.99 $13.59 20% Off $11.89 30% Off Email When In Stock
Add to Favorites My Carry All Tote 21 in. x 27 in. blueberry
Zoom Image
21 in. x 27 in. blueberry 34961 $16.99 $13.59 20% Off $11.89 30% Off Email When In Stock
Add to Favorites
26645
My Carry All Tote 21 in. x 27 in. lime
Zoom Image
21 in. x 27 in. lime 34965 $16.99 $13.59 20% Off $11.89 30% Off Email When In Stock
Add to Favorites
68155
My Carry All Tote 24 in. x 32 in. blueberry
Zoom Image
24 in. x 32 in. blueberry 34971 $19.99 $15.99 20% Off $13.99 30% Off Email When In Stock
Add to Favorites
68163
My Carry All Tote 24 in. x 32 in. strawberry
Zoom Image
24 in. x 32 in. strawberry 34972 $19.99 $15.99 20% Off $13.99 30% Off Email When In Stock
Add to Favorites
68164
My Carry All Tote 24 in. x 32 in. grape
Zoom Image
24 in. x 32 in. grape 34974 $19.99 $15.99 20% Off $13.99 30% Off Email When In Stock
Add to Favorites
68168
My Carry All Tote 24 in. x 32 in. lime
Zoom Image
24 in. x 32 in. lime 34975 $19.99 $15.99 20% Off $13.99 30% Off Email When In Stock
Add to Favorites
68179
My Carry All Tote 24 in. x 32 in. black
Zoom Image
24 in. x 32 in. black 34070-5 $19.99 $15.99 20% Off $13.99 30% Off Email When In Stock

Click the to add item to your Favorites.



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

Studio 100 Soldering Iron

by Diamond Tech

With built-in temperature control

From $12.25

No. 17 Lightweight Chiseling Blade

by X-Acto

Top quality name brands for less

From $1.81

Watercolor Cup

by Jack Richeson

Economical and lightweight

From $0.17

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

How deep is the gusset? How many 1/4 in. posters will it hold?

- Asked by Brenda on 19-Nov-13
Answer

This Tote has a 3 in. gusset, which would give it the capacity to hold about 12 1/4 in. posters.

- Answered by MisterArt on 19-Nov-13

What is the tote made of?

- Asked by Joyce on 14-Feb-13
Answer

They are plastic-sided, with a stitched nylon shoulder strap, and a 3 in. fabric gusset.

- Answered by MisterArt on 14-Feb-13

Are these totes waterproof?

- Asked by Chris Nj on 20-Oct-12
Answer

The My Carry All totes by Filexec are not waterproof but they are water-resistant.

- Answered by MisterArt on 26-Oct-12

Ask a Question About My Carry All Tote


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: Casey V. in Los Angeles, CA
I needed something to tote around my posters (which are mounted on a stiff foam core). I carry them frequently from work to home in the car, on mass transit. Need some protection from the elements so they can last me for awhile. These totes are well-built and perform just as described on the website. Very happy with delivery, packaging, and especially the value for the price.

Write a Product Review for My Carry All Tote

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