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

Art Profolio PolyZip Envelope

by Itoya


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901246
barcode_type UPC
col1 11 in. x 14 in.
col1_sortorder 781
col2 [empty string]
col3 [empty string]
cost 1.66
deal_of_the_week NO
description 11 in. x 14 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 25233
list_price 3.39
map NO
mfr_num AZ-11-14
net_weight 0.2
non_member_discount 20
non_member_price 2.71
prop65 NO
ship_rule_desc STD
shipping STD
sku 25233
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.83
ta_dealer_c_price 1.83
ta_price 2.71
text
array
1 25233
2 AZ-11-14
3 11 in. x 14 in.
timestamp 2015-03-31T17:53:01.278Z
vip_member_price 2.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901253
barcode_type UPC
col1 11 in. x 17 in.
col1_sortorder 789
col2 [empty string]
col3 [empty string]
cost 1.76
deal_of_the_week NO
description 11 in. x 17 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 59815
list_price 3.59
map NO
mfr_num AZ-11-17
net_weight 0.21
non_member_discount 20
non_member_price 2.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 59815
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.94
ta_dealer_c_price 1.94
ta_price 2.87
text
array
1 59815
2 AZ-11-17
3 11 in. x 17 in.
timestamp 2015-03-31T17:53:54.16Z
vip_member_price 2.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
VIP_member_discount 30
barcode 075633901260
barcode_type UPC
col1 13 in. x 19 in.
col1_sortorder 905
col2 [empty string]
col3 [empty string]
cost 2.15
deal_of_the_week NO
description 13 in. x 19 in.
flags
array
1 3
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 21810
list_price 4.39
map NO
mfr_num AZ-13-19
net_weight 0.28
non_member_discount 20
non_member_price 3.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 21810
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.51
text
array
1 21810
2 AZ-13-19
3 13 in. x 19 in.
timestamp 2015-03-31T17:52:56.519Z
vip_member_price 3.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901307
barcode_type UPC
col1 14 in. x 17 in.
col1_sortorder 924
col2 [empty string]
col3 [empty string]
cost 1.9
deal_of_the_week NO
description 14 in. x 17 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 59816
list_price 3.89
map NO
mfr_num AZ-14-17
net_weight 0.27
non_member_discount 20
non_member_price 3.11
prop65 NO
ship_rule_desc STD
shipping STD
sku 59816
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.1
ta_dealer_c_price 2.1
ta_price 3.11
text
array
1 59816
2 AZ-14-17
3 14 in. x 17 in.
timestamp 2015-03-31T17:53:54.162Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901154
barcode_type UPC
col1 4 in. x 6 in.
col1_sortorder 1785
col2 [empty string]
col3 [empty string]
cost 0.88
deal_of_the_week NO
description 4 in. x 6 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 38704
list_price 1.79
map NO
mfr_num AZ-4-6
net_weight 0.05
non_member_discount 20
non_member_price 1.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 38704
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.97
ta_dealer_c_price 0.97
ta_price 1.43
text
array
1 38704
2 AZ-4-6
3 4 in. x 6 in.
timestamp 2015-03-31T17:53:22.584Z
vip_member_price 1.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901178
barcode_type UPC
col1 4 in. x 9 in.
col1_sortorder 1791
col2 [empty string]
col3 [empty string]
cost 0.93
deal_of_the_week NO
description 4 in. x 9 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 07935
list_price 1.89
map NO
mfr_num AZ-4-9
net_weight 0.07
non_member_discount 20
non_member_price 1.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 07935
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.02
ta_dealer_c_price 1.02
ta_price 1.51
text
array
1 07935
2 AZ-4-9
3 4 in. x 9 in.
timestamp 2015-03-31T17:52:30.067Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901161
barcode_type UPC
col1 5 in. x 7 in.
col1_sortorder 1959
col2 [empty string]
col3 [empty string]
cost 0.93
deal_of_the_week NO
description 5 in. x 7 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 38706
list_price 1.89
map NO
mfr_num AZ-5-7
net_weight 0.07
non_member_discount 20
non_member_price 1.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 38706
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.02
ta_dealer_c_price 1.02
ta_price 1.51
text
array
1 38706
2 AZ-5-7
3 5 in. x 7 in.
timestamp 2015-03-31T17:53:22.592Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901185
barcode_type UPC
col1 8 in. x 10 in.
col1_sortorder 2288
col2 [empty string]
col3 [empty string]
cost 1.17
deal_of_the_week NO
description 8 in. x 10 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 18246
list_price 2.39
map NO
mfr_num AZ-8-10
net_weight 0.12
non_member_discount 20
non_member_price 1.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 18246
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.29
ta_dealer_c_price 1.29
ta_price 1.91
text
array
1 18246
2 AZ-8-10
3 8 in. x 10 in.
timestamp 2015-03-31T17:52:49.773Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 075633901215
barcode_type UPC
col1 8 1/2 in. x 11 in.
col1_sortorder 2311
col2 [empty string]
col3 [empty string]
cost 1.27
deal_of_the_week NO
description 8 1/2 in. x 11 in.
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 38708
list_price 2.59
map NO
mfr_num AZ-8-11
net_weight 0.13
non_member_discount 20
non_member_price 2.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 38708
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.07
text
array
1 38708
2 AZ-8-11
3 8 1/2 in. x 11 in.
timestamp 2015-03-31T17:53:22.594Z
vip_member_price 1.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


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

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

ItemIDList: 65275
AvailQtyList: 0E-12

struct
VIP_member_discount 30
barcode 075633901239
barcode_type UPC
col1 9 in. x 12 in.
col1_sortorder 2373
col2 [empty string]
col3 [empty string]
cost 1.37
deal_of_the_week NO
description 9 in. x 12 in.
flags
array
1 3
group_id 9400
group_uname itoya-art-profolio-polyzip-envelope
id 19272
list_price 2.79
map NO
mfr_num AZ-9-12
net_weight 0.14
non_member_discount 20
non_member_price 2.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 19272
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.51
ta_dealer_c_price 1.51
ta_price 2.23
text
array
1 19272
2 AZ-9-12
3 9 in. x 12 in.
timestamp 2015-03-31T17:52:51.873Z
vip_member_price 1.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 65275
CACHED false
EXECUTIONTIME 16
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] = '14576' 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.81.2.75

URL: www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 03:14:49'}
sessionid e03028580ffd0c0aa0fc4713758134766440
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=storage&catB=fb~itoya~fp~0-5~&gr=itoya-art-profolio-polyzip-envelope.html
urltoken CFID=30687608&CFTOKEN=58808222&jsessionid=e03028580ffd0c0aa0fc4713758134766440
validationerror [empty string]


PolyZip Envelopes by ITOYA are the best way to organize and store your art and photography. The envelopes are made from durable polypropylene and are archival safe for long term storage.

Featuring an easy to use zip closure, the envelopes seal out the elements to help resist dust and moisture. An expanding gusset provides flexible storage for a single or a stack of art and photo materials. The envelopes also have single sheet pockets in the front for routing slips or content samples.

Share on Facebook Twitter Pinterest

Ask a question about Art Profolio PolyZip Envelope Ask a question about this product

Art Profolio PolyZip Envelope

by Itoya









  Item# Image size
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
25233
Art Profolio PolyZip Envelope 11 in. x 14 in.
Zoom Image
11 in. x 14 in. AZ-11-14 $3.39 $2.71 20% Off $2.37 30% Off Email When In Stock
Add to Favorites
59815
Art Profolio PolyZip Envelope 11 in. x 17 in.
Zoom Image
11 in. x 17 in. AZ-11-17 $3.59 $2.87 20% Off $2.51 30% Off Email When In Stock
Add to Favorites
21810
Art Profolio PolyZip Envelope 13 in. x 19 in.
Zoom Image
13 in. x 19 in. AZ-13-19 $4.39 $3.51 20% Off $3.07 30% Off Email When In Stock
Add to Favorites
59816
Art Profolio PolyZip Envelope 14 in. x 17 in.
Zoom Image
14 in. x 17 in. AZ-14-17 $3.89 $3.11 20% Off $2.72 30% Off Email When In Stock
Add to Favorites
38704
Art Profolio PolyZip Envelope 4 in. x 6 in.
Zoom Image
4 in. x 6 in. AZ-4-6 $1.79 $1.43 20% Off $1.25 30% Off Email When In Stock
Add to Favorites
07935
Art Profolio PolyZip Envelope 4 in. x 9 in.
Zoom Image
4 in. x 9 in. AZ-4-9 $1.89 $1.51 20% Off $1.32 30% Off Email When In Stock
Add to Favorites
38706
Art Profolio PolyZip Envelope 5 in. x 7 in.
Zoom Image
5 in. x 7 in. AZ-5-7 $1.89 $1.51 20% Off $1.32 30% Off Email When In Stock
Add to Favorites
18246
Art Profolio PolyZip Envelope 8 in. x 10 in.
Zoom Image
8 in. x 10 in. AZ-8-10 $2.39 $1.91 20% Off $1.67 30% Off Email When In Stock
Add to Favorites
38708
Art Profolio PolyZip Envelope 8 1/2 in. x 11 in.
Zoom Image
8 1/2 in. x 11 in. AZ-8-11 $2.59 $2.07 20% Off $1.81 30% Off Email When In Stock
Add to Favorites
19272
Art Profolio PolyZip Envelope 9 in. x 12 in.
Zoom Image
9 in. x 12 in. AZ-9-12 $2.79 $2.23 20% Off $1.95 30% Off Email When In Stock

Click the to add item to your Favorites.



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

White Artist's Tape

by Pro Tapes

Removes from paper easily

From $4.99

Ready Frame Black

by Nielsen Bainbridge

Fully assembled, professional quality

Up to 55% Off

Storage Cups

by Loew Cornell

Resealable cups have many storage uses

From $1.99

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Art Profolio PolyZip Envelope

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.

Write a Product Review for Art Profolio PolyZip Envelope

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