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

Satin Glazes

by Duncan


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754213792
barcode_type UPC
col1 banana cream
col1_sortorder 314
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-232-183.jpg
cost 2.59
deal_of_the_week NO
description banana cream, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 80589
list_price 5.65
map NO
mfr_num SN367 21379
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 80589
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 80589
2 SN367 21379
3 banana cream, 4 oz.
timestamp 2015-03-26T14:52:13.698Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754970107
barcode_type UPC
col1 black
col1_sortorder 402
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.59
deal_of_the_week NO
description black, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 35252
list_price 5.65
map NO
mfr_num SN366-4 97010
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 35252
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 35252
2 SN366-4 97010
3 black, 4 oz.
timestamp 2015-03-26T14:51:04.917Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754970053
barcode_type UPC
col1 Christmas green
col1_sortorder 1233
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 113-149-92.jpg
cost 2.24
deal_of_the_week NO
description Christmas green, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 24077
list_price 4.9
map NO
mfr_num SN761 97005
net_weight 0.4
non_member_discount 20
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 24077
sku_pix NO
supplier_id 1
ta_dealer_a_price 2.94
ta_dealer_c_price 2.45
ta_price 4.9
text
array
1 24077
2 SN761 97005
3 Christmas green, 4 oz.
timestamp 2015-03-26T14:50:46.899Z
vip_member_price 3.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754969965
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
cost 1.23
deal_of_the_week NO
description clear, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 68175
list_price 2.7
map NO
mfr_num SN351-4 96996
net_weight 0.4
non_member_discount 20
non_member_price 2.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 68175
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.62
ta_dealer_c_price 1.35
ta_price 2.7
text
array
1 68175
2 SN351-4 96996
3 clear, 4 oz.
timestamp 2015-03-26T14:51:53.063Z
vip_member_price 1.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754213853
barcode_type UPC
col1 ice blue
col1_sortorder 2889
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 151-138-195.jpg
cost 2.59
deal_of_the_week NO
description ice blue, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 81571
list_price 5.65
map NO
mfr_num SN370-4 21385
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 81571
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 81571
2 SN370-4 21385
3 ice blue, 4 oz.
timestamp 2015-03-26T14:52:14.567Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754213914
barcode_type UPC
col1 midnight blue
col1_sortorder 3758
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 218-183-240.jpg
cost 2.24
deal_of_the_week NO
description midnight blue, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 30847
list_price 4.9
map NO
mfr_num SN373-4 21391
net_weight 0.4
non_member_discount 20
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 30847
sku_pix NO
supplier_id 1
ta_dealer_a_price 2.94
ta_dealer_c_price 2.45
ta_price 4.9
text
array
1 30847
2 SN373-4 21391
3 midnight blue, 4 oz.
timestamp 2015-03-26T14:50:56.485Z
vip_member_price 3.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239884
barcode_type UPC
col1 neon blue
col1_sortorder 3972
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 77-186-210.jpg
cost 2.59
deal_of_the_week NO
description neon blue, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 15581
list_price 5.65
map NO
mfr_num SN377-4 23988
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 15581
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 15581
2 SN377-4 23988
3 neon blue, 4 oz.
timestamp 2015-03-26T14:50:35.366Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239891
barcode_type UPC
col1 neon chartreuse
col1_sortorder 3973
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-240-47.jpg
cost 2.59
deal_of_the_week NO
description neon chartreuse, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 25369
list_price 5.65
map NO
mfr_num SN378-4 23989
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 25369
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 25369
2 SN378-4 23989
3 neon chartreuse, 4 oz.
timestamp 2015-03-26T14:50:48.763Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239907
barcode_type UPC
col1 neon green
col1_sortorder 3977
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 154-210-122.jpg
cost 2.59
deal_of_the_week NO
description neon green, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 25702
list_price 5.65
map NO
mfr_num SN379-4 23990
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 25702
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 25702
2 SN379-4 23990
3 neon green, 4 oz.
timestamp 2015-03-26T14:50:49.026Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239860
barcode_type UPC
col1 neon orange
col1_sortorder 3983
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-204-77.jpg
cost 2.59
deal_of_the_week NO
description neon orange, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 23434
list_price 5.65
map NO
mfr_num SN375-4 23986
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 23434
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 23434
2 SN375-4 23986
3 neon orange, 4 oz.
timestamp 2015-03-26T14:50:46.056Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239914
barcode_type UPC
col1 neon purple
col1_sortorder 3990
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 76-0-119.jpg
cost 2.59
deal_of_the_week NO
description neon purple, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 26485
list_price 5.65
map NO
mfr_num SN380-4 23991
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 26485
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 26485
2 SN380-4 23991
3 neon purple, 4 oz.
timestamp 2015-03-26T14:50:49.908Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239877
barcode_type UPC
col1 neon red
col1_sortorder 3992
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-147-122.jpg
cost 2.59
deal_of_the_week NO
description neon red, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 23839
list_price 5.65
map NO
mfr_num SN376-4 23987
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 23839
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 23839
2 SN376-4 23987
3 neon red, 4 oz.
timestamp 2015-03-26T14:50:46.45Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754239853
barcode_type UPC
col1 neon yellow
col1_sortorder 3994
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-255-0.jpg
cost 2.59
deal_of_the_week NO
description neon yellow, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 28237
list_price 5.65
map NO
mfr_num SN374-4 23985
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 28237
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 28237
2 SN374-4 23985
3 neon yellow, 4 oz.
timestamp 2015-03-26T14:50:52.219Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754969217
barcode_type UPC
col1 orange fizz
col1_sortorder 4225
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-173-77.jpg
cost 2.59
deal_of_the_week NO
description orange fizz, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 86561
list_price 5.65
map NO
mfr_num SN355-4 96921
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 86561
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 86561
2 SN355-4 96921
3 orange fizz, 4 oz.
timestamp 2015-03-26T14:52:18.431Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754213891
barcode_type UPC
col1 red velvet
col1_sortorder 5144
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-47-47.jpg
cost 2.59
deal_of_the_week NO
description red velvet, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 16146
list_price 5.65
map NO
mfr_num SN372-4 21389
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 16146
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 16146
2 SN372-4 21389
3 red velvet, 4 oz.
timestamp 2015-03-26T14:50:36.216Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754213815
barcode_type UPC
col1 rose petal
col1_sortorder 5244
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-214-183.jpg
cost 2.59
deal_of_the_week NO
description rose petal, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 54568
list_price 5.65
map NO
mfr_num SN368-4 21381
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 54568
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 54568
2 SN368-4 21381
3 rose petal, 4 oz.
timestamp 2015-03-26T14:51:30.22Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


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

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

ItemIDList: 58411
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754969972
barcode_type UPC
col1 white
col1_sortorder 6534
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-255-255.jpg
cost 2.59
deal_of_the_week NO
description white, 4 oz.
group_id 1033
group_uname duncan-satin-glazes
id 26465
list_price 5.65
map NO
mfr_num SN352-4 96997
net_weight 0.4
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 26465
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 26465
2 SN352-4 96997
3 white, 4 oz.
timestamp 2015-03-26T14:50:49.89Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 58411
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] = '7440' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030fc758eefbce2cb1013547f77552d3821
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=sort~1~fb~silentaire~fp~172-247~&gr=silentaire-scorpion-i-compressor.html
urltoken CFID=29236198&CFTOKEN=47263520&jsessionid=e030fc758eefbce2cb1013547f77552d3821
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:34:07'}
sessionid e030d450eace3f3bea6f1e492418687a2267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~duncan~fp~0-2~&gr=duncan-satin-glazes.html
urltoken CFID=29236197&CFTOKEN=35076026&jsessionid=e030d450eace3f3bea6f1e492418687a2267
validationerror [empty string]


Satin Glazes are so named because of their soft, muted sheen. They move very little during firing, which makes them ideally suited for creative design work, majolica, and controlled glazing techniques.

Satin Glazes are nontoxic, lead free, and safe for food containers.

Share on Facebook Twitter Pinterest

Ask a question about Satin Glazes Ask a question about this product

Satin Glazes

by Duncan

Average User Rating: Based on (2 Reviews)

5 2

Wendy K. from Ferndale, WA says:

Nice color but not the greatest for brush application.

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
80589
Satin Glazes banana cream 4 oz.
Zoom Image
banana cream 4 oz. SN367 21379 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
35252
Satin Glazes black 4 oz.
Zoom Image
black 4 oz. SN366-4 97010 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
24077
  Christmas green 4 oz. SN761 97005 $4.90 $3.92 20% Off $3.43 30% Off Email When In Stock
Add to Favorites
68175
Satin Glazes clear 4 oz.
Zoom Image
clear 4 oz. SN351-4 96996 $2.70 $2.16 20% Off $1.89 30% Off Email When In Stock
Add to Favorites
81571
Satin Glazes ice blue 4 oz.
Zoom Image
ice blue 4 oz. SN370-4 21385 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
30847
  midnight blue 4 oz. SN373-4 21391 $4.90 $3.92 20% Off $3.43 30% Off Email When In Stock
Add to Favorites
15581
Satin Glazes neon blue 4 oz.
Zoom Image
neon blue 4 oz. SN377-4 23988 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
25369
Satin Glazes neon chartreuse 4 oz.
Zoom Image
neon chartreuse 4 oz. SN378-4 23989 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
25702
Satin Glazes neon green 4 oz.
Zoom Image
neon green 4 oz. SN379-4 23990 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
23434
Satin Glazes neon orange 4 oz.
Zoom Image
neon orange 4 oz. SN375-4 23986 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
26485
Satin Glazes neon purple 4 oz.
Zoom Image
neon purple 4 oz. SN380-4 23991 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
23839
Satin Glazes neon red 4 oz.
Zoom Image
neon red 4 oz. SN376-4 23987 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
28237
Satin Glazes neon yellow 4 oz.
Zoom Image
neon yellow 4 oz. SN374-4 23985 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
86561
Satin Glazes orange fizz 4 oz.
Zoom Image
orange fizz 4 oz. SN355-4 96921 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
16146
Satin Glazes red velvet 4 oz.
Zoom Image
red velvet 4 oz. SN372-4 21389 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
54568
Satin Glazes rose petal 4 oz.
Zoom Image
rose petal 4 oz. SN368-4 21381 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock
Add to Favorites
26465
Satin Glazes white 4 oz.
Zoom Image
white 4 oz. SN352-4 96997 $5.65 $4.52 20% Off $3.96 30% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



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

Envision Glazes

by Duncan

Incredible selection

Up to 30% Off

French Dimensions

by Duncan

Great for raised design effects

From $2.21

Courtyard Art Glazes

by Duncan

For a unique, rich color

From $3.05

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 Satin Glazes

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: Wendy K. in Ferndale, WA
Nice color but not the greatest for brush application.
Rated by: Mike M. in Denver, CO
I have been using the Duncan SN 352 (white) for years now. I have fired it from cone 06 to 6 and it is a very stable glaze. Gorgeous.

Write a Product Review for Satin Glazes

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