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

Gel Xtreme Rolling Writers

by Yasutomo


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518200
barcode_type UPC
col1 black
col1_sortorder 402
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.68
deal_of_the_week NO
description black
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 35380
list_price 1.45
map NO
mfr_num GX101A (.5MM)
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 35380
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 35380
2 GX101A (.5MM)
3 black
timestamp 2015-03-27T14:47:06.101Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518019
barcode_type UPC
col1 blue
col1_sortorder 542
col2 [empty string]
col3 [empty string]
color_swatch 0-0-210.jpg
cost 0.68
deal_of_the_week NO
description blue
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 41742
list_price 1.45
map NO
mfr_num GX100C
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 41742
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 41742
2 GX100C
3 blue
timestamp 2015-03-27T14:47:14.282Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518071
barcode_type UPC
col1 bronze
col1_sortorder 790
col2 [empty string]
col3 [empty string]
color_swatch 195-163-47.jpg
cost 0.68
deal_of_the_week NO
description bronze
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 39384
list_price 1.45
map NO
mfr_num GX100Z
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 39384
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 39384
2 GX100Z
3 bronze
timestamp 2015-03-27T14:47:11.668Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518033
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 [empty string]
col3 [empty string]
color_swatch 195-174-138.jpg
cost 0.68
deal_of_the_week NO
description gold
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 27343
list_price 1.45
map NO
mfr_num GX100G
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 27343
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 27343
2 GX100G
3 gold
timestamp 2015-03-27T14:46:50.511Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518026
barcode_type UPC
col1 green
col1_sortorder 2621
col2 [empty string]
col3 [empty string]
color_swatch 0-164-123.jpg
cost 0.68
deal_of_the_week NO
description green
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 50871
list_price 1.45
map NO
mfr_num GX100D
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 50871
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 50871
2 GX100D
3 green
timestamp 2015-03-27T14:47:25.144Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518040
barcode_type UPC
col1 pink
col1_sortorder 4716
col2 [empty string]
col3 [empty string]
color_swatch 240-92-157.jpg
cost 0.68
deal_of_the_week NO
description pink
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 62721
list_price 1.45
map NO
mfr_num GX100P
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 62721
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 62721
2 GX100P
3 pink
timestamp 2015-03-27T14:47:42.419Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518064
barcode_type UPC
col1 purple
col1_sortorder 4930
col2 [empty string]
col3 [empty string]
color_swatch 114-0-164.jpg
cost 0.68
deal_of_the_week NO
description purple
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 74118
list_price 1.45
map NO
mfr_num GX100V
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 74118
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 74118
2 GX100V
3 purple
timestamp 2015-03-27T14:48:04.37Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 031248518057
barcode_type UPC
col1 silver
col1_sortorder 5562
col2 [empty string]
col3 [empty string]
color_swatch 210-210-210.jpg
cost 0.68
deal_of_the_week NO
description silver
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 27894
list_price 1.45
map NO
mfr_num GX100S
net_weight 0.02
non_member_discount 22
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 27894
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 27894
2 GX100S
3 silver
timestamp 2015-03-27T14:46:51.127Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


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

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

ItemIDList: 41508,53262,62061
AvailQtyList: 0E-12,7.000000000000,11.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 031248518286
barcode_type UPC
col1 white
col1_sortorder 6534
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 0.67
deal_of_the_week NO
description white
group_id 373
group_uname yasutomo-gel-xtreme-rolling-writers
id 79280
list_price 1.45
map NO
mfr_num GX101W
net_weight 0.02
non_member_discount 32
non_member_price 0.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 79280
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.09
text
array
1 79280
2 GX101W
3 white
timestamp 2015-03-27T14:48:09.036Z
vip_member_price 0.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41508
2 7.000000000000 53262
3 11.000000000000 62061
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] = '3731' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e0308af672ee1e92ffda6132473c2c572518
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~6-13~&gr=ultraoptix-magnifier.html
urltoken CFID=29412835&CFTOKEN=61933335&jsessionid=e0308af672ee1e92ffda6132473c2c572518
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:33:24'}
sessionid e030fd98d490294110a7305a1c3733196e5a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~yasutomo~fp~0-1~c1~scrapbooking~&gr=yasutomo-gel-xtreme-rolling-writers.html
urltoken CFID=29412834&CFTOKEN=10129303&jsessionid=e030fd98d490294110a7305a1c3733196e5a
validationerror [empty string]


These water-based, non-toxic gel ink pens are high quality and acid free. Luxurious metallic colors flow abundantly from their rollers to produce sparkling effects on both light and dark papers. The pens also have crystal clear barrels, so you always know how much ink is left.

Gel Xtreme pens are great for writing, embellishing, and decorating letters, cards, notes, and journals. They’re also perfect for use with embossing powders because of their quick drying time.

All Gel Xtreme pens have .7 mm rollers, except for black, which has a .5 mm roller.

Share on Facebook Twitter Pinterest

Ask a question about Gel Xtreme Rolling Writers Ask a question about this product

Gel Xtreme Rolling Writers

by Yasutomo

Average User Rating: Based on (13 Reviews)

5 13

Leslie R. from Gilbert, AZ says:

Love these pens - smooth writing and great for signing artwork mats.

[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
35380
Gel Xtreme Rolling Writers black
Zoom Image
black GX101A (.5MM) $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
41742
Gel Xtreme Rolling Writers blue
Zoom Image
blue GX100C $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
39384
Gel Xtreme Rolling Writers bronze
Zoom Image
bronze GX100Z $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
27343
Gel Xtreme Rolling Writers gold
Zoom Image
gold GX100G $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
50871
Gel Xtreme Rolling Writers green
Zoom Image
green GX100D $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
62721
Gel Xtreme Rolling Writers pink
Zoom Image
pink GX100P $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
74118
Gel Xtreme Rolling Writers purple
Zoom Image
purple GX100V $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
27894
Gel Xtreme Rolling Writers silver
Zoom Image
silver GX100S $1.45 $1.13 22% Off $0.99 32% Off Email When In Stock
Add to Favorites
79280
Gel Xtreme Rolling Writers white
Zoom Image
white GX101W $1.45 $0.99 32% Off $0.86 41% 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...

Gelly Roll Metallic Pens

by Sakura

Release your inner shimmer on light or dark papers

From $0.90

From $2.19

Metallic Markers

by American Crafts

A paint-like finish.

From $1.60

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 Gel Xtreme Rolling Writers

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: Leslie R. in Gilbert, AZ
Love these pens - smooth writing and great for signing artwork mats.
Rated by: Alice V. in San Diego, CA
I buy the Yasutomo Gel Xtreme pens by the dozen in black , and have used them for at least 15 years. I've found that they are the best gel pens, since they have a consistent line and don't skip or blob. For the price, they are the best I've found.
Rated by: Lisa D. in Americus, GA
I love these pens. I am making cards to sell and found the colors to be bright and the ink dries quickly so it does not smudge.
Rated by: Sandra L. in Dallas, TX
Nice product but nothing to scream about. I used these to write addresses on brown envelopes. The darker pens write well if you're just looking for a black or blue pen to use on a daily basis. They were silky and wrote great. Out of the lighter colors, I thought the silver looked the best and was the smoothest. Some of the other lighter colored ones, like the pink, would leave dry gaps as I was writing and looked a bit streaky.
Rated by: Tracy K. in Springfield, IL
These are wonderful! I purchased them on behalf of my Regional Vice President to complete personalized items for our client holiday gifts and they are the best I've ever found!
Rated by: ann b. in st. louis, MO
I really like the gold and silver metallic colors for this pen. Less messy than the paint pens.
Rated by: Jeremy G. in Paramount, CA
I first came across Y&C Gel Extreme pens in college. They were the best pens I had ever used! The 0.5mm tip is perfect for taking CLEAR, UNCLUTTERED notes. They also work great for accounting, which requires fine tipped pens. Thanks Y&C!
Rated by: Karin J. in Bloomfield Hills, MI
I found a Yasutomo Gel Xtreme Rolling Pen in a desk at work, and loved it! Then I went online and a search took me to Misterart.com. The website was easy to use and I purchased the pen in many colors. They are great for my crafts, scrapbooking, anything I need to write! These are definitely the smoothest pens I have ever used. No skipping...just smooth lines!I will definitely save the site and order again!
Rated by: Elizabeth G. in Point Pleasant, NJ
I purchased the Yasutomo Xtreme Gel Writers in black and in gold,and loved them. The ink is smooth,the color is vivid..whether writing a letter,stenciling a design or embossing an image,they are a quality tool.A must have for anyones craft creations,and most affordable as well.
Rated by: Susan P. in Des Moines, IA
Best pens ever...use for scrapbooking, journaling, office, etc...smooth, comfortable, will not clog like other gel pens! Great .7 tip on the black! Order several at a time.
Rated by: Amanda S. in oklahoma city, OK
There are the best pens ever!!
Rated by: Jeremy G. in Los Angeles, CA
These are the best pens I have ever been able to find. Prior to coming across this site, the only place I was able to find these pens was my old college campus. In my line of work, (intakes for substance abuse clients) I do a lot of writing, and the black gel pens never fail! I was so happy to find them here that I bought 48 which is all they had on hand. Sorry for the inconvenience to the rest of you, but if you've used these pens you know why I bought them all.
Rated by: Ann S. in Springfield, MO
These are by far the best metallic gel pens. They are sometimes hard to find, but well worth it. No more trying to get the pen to write as fast as you do. No aggravation of gel globs and then no ink at all. Just perfect, smooth, not too sparkly, gel ink. Great on all kinds of surfaces; doesn't bleed. You can see when it's dry, so wait or it will smear.

Write a Product Review for Gel Xtreme Rolling Writers

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