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

Puffy Velvet Fabric Marker

by Marvy Uchida


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102016
barcode_type UPC
col1 black
col1_sortorder 402
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.73
deal_of_the_week NO
description black
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 12155
list_price 3.79
map NO
mfr_num 1022S-1
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 12155
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 12155
2 1022S-1
3 black
timestamp 2015-03-27T14:46:27.184Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102030
barcode_type UPC
col1 blue
col1_sortorder 542
col2 [empty string]
col3 [empty string]
color_swatch 47-83-195.jpg
cost 1.73
deal_of_the_week NO
description blue
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 31261
list_price 3.79
map NO
mfr_num 1022S-3
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 31261
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 31261
2 1022S-3
3 blue
timestamp 2015-03-27T14:46:56.49Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102061
barcode_type UPC
col1 brown
col1_sortorder 798
col2 [empty string]
col3 [empty string]
color_swatch 104-58-47.jpg
cost 1.73
deal_of_the_week NO
description brown
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 21448
list_price 3.79
map NO
mfr_num 1022S-6
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 21448
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 21448
2 1022S-6
3 brown
timestamp 2015-03-27T14:46:41.886Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102375
barcode_type UPC
col1 cool grey
col1_sortorder 1519
col2 [empty string]
col3 [empty string]
color_swatch 165-165-165.jpg
cost 1.73
deal_of_the_week NO
description cool grey
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 16711
list_price 3.79
map NO
mfr_num 1022S-37
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 16711
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 16711
2 1022S-37
3 cool grey
timestamp 2015-03-27T14:46:36.235Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102351
barcode_type UPC
col1 cordovan
col1_sortorder 1550
col2 [empty string]
col3 [empty string]
color_swatch 255-168-168.jpg
cost 1.73
deal_of_the_week NO
description cordovan
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 21642
list_price 3.79
map NO
mfr_num 1022S-35
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 21642
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 21642
2 1022S-35
3 cordovan
timestamp 2015-03-27T14:46:42.282Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102474
barcode_type UPC
col1 flesh tone
col1_sortorder 2195
col2 [empty string]
col3 [empty string]
color_swatch 255-196-168.jpg
cost 1.73
deal_of_the_week NO
description flesh tone
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 24693
list_price 3.79
map NO
mfr_num 1022S-47
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 24693
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 24693
2 1022S-47
3 flesh tone
timestamp 2015-03-27T14:46:46.024Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102740
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 [empty string]
col3 [empty string]
color_swatch 174-240-138.jpg
cost 1.73
deal_of_the_week NO
description fluorescent green
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 27690
list_price 3.79
map NO
mfr_num 1022S-F4
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 27690
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 27690
2 1022S-F4
3 fluorescent green
timestamp 2015-03-27T14:46:50.895Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617103808
barcode_type UPC
col1 fluorescent light blue
col1_sortorder 2218
col2 [empty string]
col3 [empty string]
color_swatch 183-240-222.jpg
cost 1.73
deal_of_the_week NO
description fluorescent light blue
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 25334
list_price 3.79
map NO
mfr_num 1022S-10
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 25334
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 25334
2 1022S-10
3 fluorescent light blue
timestamp 2015-03-27T14:46:47.014Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102771
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 [empty string]
col3 [empty string]
color_swatch 240-172-92.jpg
cost 1.73
deal_of_the_week NO
description fluorescent orange
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 12341
list_price 3.79
map NO
mfr_num 1022S-F7
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 12341
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 12341
2 1022S-F7
3 fluorescent orange
timestamp 2015-03-27T14:46:27.431Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102795
barcode_type UPC
col1 fluorescent pink
col1_sortorder 2222
col2 [empty string]
col3 [empty string]
color_swatch 255-122-181.jpg
cost 1.73
deal_of_the_week NO
description fluorescent pink
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 13880
list_price 3.79
map NO
mfr_num 1022S-F9
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 13880
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 13880
2 1022S-F9
3 fluorescent pink
timestamp 2015-03-27T14:46:29.608Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102788
barcode_type UPC
col1 fluorescent violet
col1_sortorder 2230
col2 [empty string]
col3 [empty string]
color_swatch 231-138-240.jpg
cost 1.73
deal_of_the_week NO
description fluorescent violet
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 16343
list_price 3.79
map NO
mfr_num 1022S-F8
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 16343
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 16343
2 1022S-F8
3 fluorescent violet
timestamp 2015-03-27T14:46:35.759Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102757
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 [empty string]
col3 [empty string]
color_swatch 77-119-90.jpg
cost 1.73
deal_of_the_week NO
description fluorescent yellow
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 12017
list_price 3.79
map NO
mfr_num 1022S-F5
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 12017
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 12017
2 1022S-F5
3 fluorescent yellow
timestamp 2015-03-27T14:46:26.792Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102139
barcode_type UPC
col1 golden ochre
col1_sortorder 2549
col2 [empty string]
col3 [empty string]
color_swatch 240-186-92.jpg
cost 1.73
deal_of_the_week NO
description golden ochre
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 16188
list_price 3.79
map NO
mfr_num 1022S-13
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 16188
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 16188
2 1022S-13
3 golden ochre
timestamp 2015-03-27T14:46:35.639Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102047
barcode_type UPC
col1 green
col1_sortorder 2621
col2 [empty string]
col3 [empty string]
color_swatch 47-149-47.jpg
cost 1.73
deal_of_the_week NO
description green
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 15716
list_price 3.79
map NO
mfr_num 1022S-4
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 15716
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 15716
2 1022S-4
3 green
timestamp 2015-03-27T14:46:34.822Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102108
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 [empty string]
col3 [empty string]
color_swatch 77-158-210.jpg
cost 1.73
deal_of_the_week NO
description light blue
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 21372
list_price 3.79
map NO
mfr_num 1022S-10
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 21372
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 21372
2 1022S-10
3 light blue
timestamp 2015-03-27T14:46:41.812Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102955
barcode_type UPC
col1 light teal
col1_sortorder 3417
col2 [empty string]
col3 [empty string]
color_swatch 77-158-164.jpg
cost 1.73
deal_of_the_week NO
description light teal
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 25638
list_price 3.79
map NO
mfr_num 1022S-105
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 25638
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 25638
2 1022S-105
3 light teal
timestamp 2015-03-27T14:46:47.326Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102153
barcode_type UPC
col1 olive green
col1_sortorder 4164
col2 [empty string]
col3 [empty string]
color_swatch 170-195-92.jpg
cost 1.73
deal_of_the_week NO
description olive green
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 28686
list_price 3.79
map NO
mfr_num 1022S-15
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 28686
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 28686
2 1022S-15
3 olive green
timestamp 2015-03-27T14:46:52.386Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102078
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 [empty string]
col3 [empty string]
color_swatch 240-172-92.jpg
cost 1.73
deal_of_the_week NO
description orange
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 25777
list_price 3.79
map NO
mfr_num 1022S-7
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 25777
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 25777
2 1022S-7
3 orange
timestamp 2015-03-27T14:46:47.647Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102313
barcode_type UPC
col1 pale violet
col1_sortorder 4328
col2 [empty string]
col3 [empty string]
color_swatch 218-122-255.jpg
cost 1.73
deal_of_the_week NO
description pale violet
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 31178
list_price 3.79
map NO
mfr_num 1022S-31
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 31178
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 31178
2 1022S-31
3 pale violet
timestamp 2015-03-27T14:46:56.39Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102092
barcode_type UPC
col1 pink
col1_sortorder 4716
col2 [empty string]
col3 [empty string]
color_swatch 255-168-206.jpg
cost 1.73
deal_of_the_week NO
description pink
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 26758
list_price 3.79
map NO
mfr_num 1022S-9
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 26758
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 26758
2 1022S-9
3 pink
timestamp 2015-03-27T14:46:49.729Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102023
barcode_type UPC
col1 red
col1_sortorder 5079
col2 [empty string]
col3 [empty string]
color_swatch 195-75-47.jpg
cost 1.73
deal_of_the_week NO
description red
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 23086
list_price 3.79
map NO
mfr_num 1022S-2
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 23086
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 23086
2 1022S-2
3 red
timestamp 2015-03-27T14:46:44.134Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102085
barcode_type UPC
col1 violet
col1_sortorder 6398
col2 [empty string]
col3 [empty string]
color_swatch 76-0-119.jpg
cost 1.73
deal_of_the_week NO
description violet
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 26092
list_price 3.79
map NO
mfr_num 1022S-8
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 26092
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 26092
2 1022S-8
3 violet
timestamp 2015-03-27T14:46:48.225Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102122
barcode_type UPC
col1 warm gray
col1_sortorder 6458
col2 [empty string]
col3 [empty string]
color_swatch 135-135-135.jpg
cost 1.73
deal_of_the_week NO
description warm gray
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 14136
list_price 3.79
map NO
mfr_num 1022S-12
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 14136
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 14136
2 1022S-12
3 warm gray
timestamp 2015-03-27T14:46:30.078Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102009
barcode_type UPC
col1 white
col1_sortorder 6534
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 1.73
deal_of_the_week NO
description white
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 27181
list_price 3.79
map NO
mfr_num 1022S-0
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 27181
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 27181
2 1022S-0
3 white
timestamp 2015-03-27T14:46:50.362Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


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

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

ItemIDList: 04884,04885,04886,04887
AvailQtyList: 0E-12,4.000000000000,6.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 028617102054
barcode_type UPC
col1 yellow
col1_sortorder 6670
col2 [empty string]
col3 [empty string]
color_swatch 255-255-0.jpg
cost 1.73
deal_of_the_week NO
description yellow
group_id 9136
group_uname marvy-uchida-puffy-velvet-fabric-marker
id 24382
list_price 3.79
map NO
mfr_num 1022S-5
net_weight 0.22
non_member_discount 31
non_member_price 2.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 24382
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.9
ta_dealer_c_price 1.9
ta_price 2.27
text
array
1 24382
2 1022S-5
3 yellow
timestamp 2015-03-27T14:46:45.632Z
vip_member_price 2.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 04884
2 4.000000000000 04885
3 6.000000000000 04886
4 11.000000000000 04887
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] = '11962' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.87.83.162

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e0304c6c9842b3ab1fb45e75747121457f3d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=scratch-art&gr=scratch-art-color-reveal-board-sets.html
urltoken CFID=29989413&CFTOKEN=98599084&jsessionid=e0304c6c9842b3ab1fb45e75747121457f3d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 14:41:43'}
sessionid e030158eb3e2e7804f5c2d5601a323a52602
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&gr=marvy-uchida-puffy-velvet-fabric-marker.html
urltoken CFID=29989412&CFTOKEN=38683364&jsessionid=e030158eb3e2e7804f5c2d5601a323a52602
validationerror [empty string]


The Puffy Velvet Fabric Marker creates a velvety texture when heated. The marker is acid-free, odorless, and lightfast. It’s great for marking on t-shirts, canvas bags, canvas shoes, denim, and paper.

Heat tool is required.

Share on Facebook Twitter Pinterest

Ask a question about Puffy Velvet Fabric Marker Ask a question about this product  |  See all questions & answers (1)

Puffy Velvet Fabric Marker

by Marvy Uchida

Average User Rating: Based on (10 Reviews)

5 10

Camille R. from Jackson, CA says:

Try these pens on felt--they do wonders! Be careful using your heat tool, don't hover too long. Adds just a touch of "Wow".

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
12155
Puffy Velvet Fabric Marker black
Zoom Image
black 1022S-1 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
31261
Puffy Velvet Fabric Marker blue
Zoom Image
blue 1022S-3 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
21448
Puffy Velvet Fabric Marker brown
Zoom Image
brown 1022S-6 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
16711
Puffy Velvet Fabric Marker cool grey
Zoom Image
cool grey 1022S-37 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
21642
Puffy Velvet Fabric Marker cordovan
Zoom Image
cordovan 1022S-35 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
24693
Puffy Velvet Fabric Marker flesh tone
Zoom Image
flesh tone 1022S-47 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
27690
Puffy Velvet Fabric Marker fluorescent green
Zoom Image
fluorescent green 1022S-F4 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
25334
Puffy Velvet Fabric Marker fluorescent light blue
Zoom Image
fluorescent light blue 1022S-10 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
12341
Puffy Velvet Fabric Marker fluorescent orange
Zoom Image
fluorescent orange 1022S-F7 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
13880
Puffy Velvet Fabric Marker fluorescent pink
Zoom Image
fluorescent pink 1022S-F9 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
16343
Puffy Velvet Fabric Marker fluorescent violet
Zoom Image
fluorescent violet 1022S-F8 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
12017
Puffy Velvet Fabric Marker fluorescent yellow
Zoom Image
fluorescent yellow 1022S-F5 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
16188
Puffy Velvet Fabric Marker golden ochre
Zoom Image
golden ochre 1022S-13 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
15716
Puffy Velvet Fabric Marker green
Zoom Image
green 1022S-4 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
21372
Puffy Velvet Fabric Marker light blue
Zoom Image
light blue 1022S-10 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
25638
Puffy Velvet Fabric Marker light teal
Zoom Image
light teal 1022S-105 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
28686
Puffy Velvet Fabric Marker olive green
Zoom Image
olive green 1022S-15 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
25777
Puffy Velvet Fabric Marker orange
Zoom Image
orange 1022S-7 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
31178
Puffy Velvet Fabric Marker pale violet
Zoom Image
pale violet 1022S-31 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
26758
Puffy Velvet Fabric Marker pink
Zoom Image
pink 1022S-9 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
23086
Puffy Velvet Fabric Marker red
Zoom Image
red 1022S-2 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
26092
Puffy Velvet Fabric Marker violet
Zoom Image
violet 1022S-8 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
14136
Puffy Velvet Fabric Marker warm gray
Zoom Image
warm gray 1022S-12 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
27181
Puffy Velvet Fabric Marker white
Zoom Image
white 1022S-0 $3.79 $2.62 31% Off $2.26 40% Off Email When In Stock
Add to Favorites
24382
Puffy Velvet Fabric Marker yellow
Zoom Image
yellow 1022S-5 $3.79 $2.62 31% Off $2.26 40% 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...

Puffy Dimensional Fabric Paint

by Tulip

EasyFlow bottles are easy to hold and use

From $1.23

DecoFabric Marker

by Marvy Uchida

Ideal for light and dark fabric.

From $2.58

Soft Polymer Clay

by Fimo

Premiere soft polymer clay

From $2.08

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

Has anyone used these on fabric? If so how do they withstand washing and normal wear?

- Asked by goldie on 04-Oct-12
Answer

These markers are suggested for use on t-shirts, canvas bags, canvas shoes, denim, and paper. The markers need to be heat set to become permanent. A heating tool is required to make them washable.

- Answered by MisterArt on 11-Oct-12

Ask a Question About Puffy Velvet Fabric Marker


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: Camille R. in Jackson, CA
Try these pens on felt--they do wonders! Be careful using your heat tool, don't hover too long. Adds just a touch of "Wow".
Rated by: rosie v. in New York, NY
These markers are the best. When they puff up it's like magic. They give such a wonderful new look to my cards and scrapbook layouts. The texture is just amazing.
Rated by: Stephanie M. in Santa Cruz, CA
These are really cool. I use them for scrapbooking and card making. It literally adds dimension to the item.
Rated by: Karen K. in Lincolnshire, IL
Very nice addition to my marker arsenal! For Easter cards I used green for grass, and pink to fluff up the bunnies.
Rated by: Mary Ann K. in Medford, NJ
I like these markers. However, you have to be careful with overlapping strokes when you use them because then the puffiness comes out uneven.
Rated by: Bonny L. in Venetia, PA
I used the black Puffy Velvet Marker to make a Halloween Spider on greeting cards. It gave the spider a textured feeling after being heated, which was very unique. I plan to use the red and green markers on my holiday cards.
Rated by: Cheryl B. in Pell City, AL
I am a scrapbooker and ordered these to use on some of my layouts. I love them. They make lettering look good and they have the feel of velvet. I recommend these highly for scrapbookers.
Rated by: Deborah B. in Worland, WY
Love these for scrapbooking projects! Very cool!!
Rated by: Lynn M. in San Diego, CA
I liked the product, but not for what I had ordered them for. I tended to get too much "puff" on and it just blows up and is hard. When I went lighter, it was nicer, but never slightly soft, at least to me. I will continue to use them now that I know how since I think there are very special uses for them.
Rated by: Schelley T. in Paradise, CA
The puffy velvet markers are a wonderful addition to my scrapbook and card making!! Just use them as you would on fabric except you immediately set the markers with a hot air gun. It puffs up magically and makes a great impression on any work!!

Write a Product Review for Puffy Velvet Fabric Marker

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