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

Candy Shop Pens

by American Crafts


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625913
barcode_type UPC
col1 basic black
col1_sortorder 341
col2 [empty string]
col3 [empty string]
color_swatch 35-31-31.jpg
cost 0.82
deal_of_the_week NO
description basic black
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70535
list_price 1.49
map NO
mfr_num 62591
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70535
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70535
2 62591
3 basic black
timestamp 2015-03-27T14:47:56.681Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625920
barcode_type UPC
col1 basic blue
col1_sortorder 342
col2 [empty string]
col3 [empty string]
color_swatch 40-87-175.jpg
cost 0.82
deal_of_the_week NO
description basic blue
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70536
list_price 1.49
map NO
mfr_num 62592
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70536
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70536
2 62592
3 basic blue
timestamp 2015-03-27T14:47:56.683Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625968
barcode_type UPC
col1 basic green
col1_sortorder 350
col2 [empty string]
col3 [empty string]
color_swatch 0-131-80.jpg
cost 0.82
deal_of_the_week NO
description basic green
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70543
list_price 1.49
map NO
mfr_num 62596
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70543
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70543
2 62596
3 basic green
timestamp 2015-03-27T14:47:56.712Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625944
barcode_type UPC
col1 basic orange
col1_sortorder 351
col2 [empty string]
col3 [empty string]
color_swatch 249-176-128.jpg
cost 0.82
deal_of_the_week NO
description basic orange
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70538
list_price 1.49
map NO
mfr_num 62594
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70538
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70538
2 62594
3 basic orange
timestamp 2015-03-27T14:47:56.688Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625951
barcode_type UPC
col1 basic pink
col1_sortorder 352
col2 [empty string]
col3 [empty string]
color_swatch 245-116-178.jpg
cost 0.82
deal_of_the_week NO
description basic pink
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70542
list_price 1.49
map NO
mfr_num 62595
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70542
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70542
2 62595
3 basic pink
timestamp 2015-03-27T14:47:56.709Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625937
barcode_type UPC
col1 basic red
col1_sortorder 353
col2 [empty string]
col3 [empty string]
color_swatch 238-41-61.jpg
cost 0.82
deal_of_the_week NO
description basic red
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70537
list_price 1.49
map NO
mfr_num 62593
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70537
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70537
2 62593
3 basic red
timestamp 2015-03-27T14:47:56.686Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625807
barcode_type UPC
col1 glitter blue
col1_sortorder 2434
col2 [empty string]
col3 [empty string]
color_swatch 45-123-200.jpg
cost 0.82
deal_of_the_week NO
description glitter blue
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70522
list_price 1.49
map NO
mfr_num 62580
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70522
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70522
2 62580
3 glitter blue
timestamp 2015-03-27T14:47:56.651Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625838
barcode_type UPC
col1 glitter pink
col1_sortorder 2439
col2 [empty string]
col3 [empty string]
color_swatch 236-84-178.jpg
cost 0.82
deal_of_the_week NO
description glitter pink
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70526
list_price 1.49
map NO
mfr_num 62583
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70526
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70526
2 62583
3 glitter pink
timestamp 2015-03-27T14:47:56.658Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625821
barcode_type UPC
col1 glitter purple
col1_sortorder 2440
col2 [empty string]
col3 [empty string]
color_swatch 83-54-154.jpg
cost 0.82
deal_of_the_week NO
description glitter purple
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70524
list_price 1.49
map NO
mfr_num 62582
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70524
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70524
2 62582
3 glitter purple
timestamp 2015-03-27T14:47:56.654Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625814
barcode_type UPC
col1 glitter red
col1_sortorder 2441
col2 [empty string]
col3 [empty string]
color_swatch 241-68-114.jpg
cost 0.82
deal_of_the_week NO
description glitter red
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70523
list_price 1.49
map NO
mfr_num 62581
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70523
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70523
2 62581
3 glitter red
timestamp 2015-03-27T14:47:56.652Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625791
barcode_type UPC
col1 glitter silver
col1_sortorder 2442
col2 [empty string]
col3 [empty string]
color_swatch 145-143-143.jpg
cost 0.82
deal_of_the_week NO
description glitter silver
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70521
list_price 1.49
map NO
mfr_num 62579
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70521
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70521
2 62579
3 glitter silver
timestamp 2015-03-27T14:47:56.648Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625845
barcode_type UPC
col1 glitter yellow
col1_sortorder 2445
col2 [empty string]
col3 [empty string]
color_swatch 252-208-93.jpg
cost 0.82
deal_of_the_week NO
description glitter yellow
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70527
list_price 1.49
map NO
mfr_num 62584
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70527
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70527
2 62584
3 glitter yellow
timestamp 2015-03-27T14:47:56.661Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625746
barcode_type UPC
col1 metallic blue
col1_sortorder 3691
col2 [empty string]
col3 [empty string]
color_swatch 55-111-189.jpg
cost 0.82
deal_of_the_week NO
description metallic blue
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70514
list_price 1.49
map NO
mfr_num 62574
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70514
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70514
2 62574
3 metallic blue
timestamp 2015-03-27T14:47:56.635Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625777
barcode_type UPC
col1 metallic bronze
col1_sortorder 3693
col2 [empty string]
col3 [empty string]
color_swatch 187-121-56.jpg
cost 0.82
deal_of_the_week NO
description metallic bronze
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70518
list_price 1.49
map NO
mfr_num 62577
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70518
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70518
2 62577
3 metallic bronze
timestamp 2015-03-27T14:47:56.64Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625753
barcode_type UPC
col1 metallic gold
col1_sortorder 3703
col2 [empty string]
col3 [empty string]
color_swatch 197-176-96.jpg
cost 0.82
deal_of_the_week NO
description metallic gold
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70515
list_price 1.49
map NO
mfr_num 62575
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70515
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70515
2 62575
3 metallic gold
timestamp 2015-03-27T14:47:56.636Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625784
barcode_type UPC
col1 metallic green
col1_sortorder 3709
col2 [empty string]
col3 [empty string]
color_swatch 25-176-157.jpg
cost 0.82
deal_of_the_week NO
description metallic green
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70519
list_price 1.49
map NO
mfr_num 62578
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70519
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70519
2 62578
3 metallic green
timestamp 2015-03-27T14:47:56.642Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625760
barcode_type UPC
col1 metallic red
col1_sortorder 3719
col2 [empty string]
col3 [empty string]
color_swatch 153-54-62.jpg
cost 0.82
deal_of_the_week NO
description metallic red
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70516
list_price 1.49
map NO
mfr_num 62576
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70516
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70516
2 62576
3 metallic red
timestamp 2015-03-27T14:47:56.638Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625739
barcode_type UPC
col1 metallic silver
col1_sortorder 3724
col2 [empty string]
col3 [empty string]
color_swatch 142-140-140.jpg
cost 0.82
deal_of_the_week NO
description metallic silver
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70512
list_price 1.49
map NO
mfr_num 62573
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70512
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70512
2 62573
3 metallic silver
timestamp 2015-03-27T14:47:56.63Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625869
barcode_type UPC
col1 pastel blue
col1_sortorder 4397
col2 [empty string]
col3 [empty string]
color_swatch 105-206-234.jpg
cost 0.82
deal_of_the_week NO
description pastel blue
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70529
list_price 1.49
map NO
mfr_num 62586
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70529
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70529
2 62586
3 pastel blue
timestamp 2015-03-27T14:47:56.666Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625906
barcode_type UPC
col1 pastel green
col1_sortorder 4398
col2 [empty string]
col3 [empty string]
color_swatch 204-235-181.jpg
cost 0.82
deal_of_the_week NO
description pastel green
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70534
list_price 1.49
map NO
mfr_num 62590
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70534
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70534
2 62590
3 pastel green
timestamp 2015-03-27T14:47:56.679Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625890
barcode_type UPC
col1 pastel light green
col1_sortorder 4399
col2 [empty string]
col3 [empty string]
color_swatch 214-236-142.jpg
cost 0.82
deal_of_the_week NO
description pastel light green
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70533
list_price 1.49
map NO
mfr_num 62589
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70533
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70533
2 62589
3 pastel light green
timestamp 2015-03-27T14:47:56.676Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625883
barcode_type UPC
col1 pastel orange
col1_sortorder 4401
col2 [empty string]
col3 [empty string]
color_swatch 249-176-128.jpg
cost 0.82
deal_of_the_week NO
description pastel orange
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70531
list_price 1.49
map NO
mfr_num 62588
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70531
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70531
2 62588
3 pastel orange
timestamp 2015-03-27T14:47:56.672Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625876
barcode_type UPC
col1 pastel purple
col1_sortorder 4404
col2 [empty string]
col3 [empty string]
color_swatch 155-111-190.jpg
cost 0.82
deal_of_the_week NO
description pastel purple
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70530
list_price 1.49
map NO
mfr_num 62587
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70530
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70530
2 62587
3 pastel purple
timestamp 2015-03-27T14:47:56.669Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


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

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

ItemIDList: 44658
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 35
barcode 718813625852
barcode_type UPC
col1 pastel white
col1_sortorder 4406
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 0.82
deal_of_the_week NO
description pastel white
group_id 10713
group_uname american-crafts-candy-shop-pens
id 70528
list_price 1.49
map NO
mfr_num 62585
net_weight 0.02
non_member_discount 25
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 70528
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.89
ta_dealer_c_price 0.89
ta_price 1.34
text
array
1 70528
2 62585
3 pastel white
timestamp 2015-03-27T14:47:56.664Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 44658
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] = '15831' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030937892d0496fd5201f46e3114f577e17
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~21-9999.99~&gr=stc-craft-craftng-a-meaningful-home.html
urltoken CFID=30131792&CFTOKEN=36736943&jsessionid=e030937892d0496fd5201f46e3114f577e17
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:34:53'}
sessionid e030add4b4986ff555e55a39745f44307426
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=pens-markers&CatC=sort~1~&gr=american-crafts-candy-shop-pens.html
urltoken CFID=30131791&CFTOKEN=80436484&jsessionid=e030add4b4986ff555e55a39745f44307426
validationerror [empty string]


Candy Shop Gel Pens from American Crafts deliver a smooth laydown, perfect for a variety of applications, such as scrapbooking, journaling, writing, drawing and more! These pens are acid free and non-toxic, and feature a special bleed proof gel ink fomula.

Share on Facebook Twitter Pinterest

Ask a question about Candy Shop Pens Ask a question about this product  |  See all questions & answers (1)

Candy Shop Pens

by American Crafts









  Item# Swatch Image color
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
70535
Candy Shop Pens basic black
Zoom Image
basic black 62591 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70536
Candy Shop Pens basic blue
Zoom Image
basic blue 62592 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70543
Candy Shop Pens basic green
Zoom Image
basic green 62596 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70538
Candy Shop Pens basic orange
Zoom Image
basic orange 62594 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70542
Candy Shop Pens basic pink
Zoom Image
basic pink 62595 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70537
Candy Shop Pens basic red
Zoom Image
basic red 62593 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70522
Candy Shop Pens glitter blue
Zoom Image
glitter blue 62580 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70526
Candy Shop Pens glitter pink
Zoom Image
glitter pink 62583 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70524
Candy Shop Pens glitter purple
Zoom Image
glitter purple 62582 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70523
Candy Shop Pens glitter red
Zoom Image
glitter red 62581 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70521
Candy Shop Pens glitter silver
Zoom Image
glitter silver 62579 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70527
Candy Shop Pens glitter yellow
Zoom Image
glitter yellow 62584 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70514
Candy Shop Pens metallic blue
Zoom Image
metallic blue 62574 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70518
Candy Shop Pens metallic bronze
Zoom Image
metallic bronze 62577 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70515
Candy Shop Pens metallic gold
Zoom Image
metallic gold 62575 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70519
Candy Shop Pens metallic green
Zoom Image
metallic green 62578 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70516
Candy Shop Pens metallic red
Zoom Image
metallic red 62576 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70512
Candy Shop Pens metallic silver
Zoom Image
metallic silver 62573 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70529
Candy Shop Pens pastel blue
Zoom Image
pastel blue 62586 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70534
Candy Shop Pens pastel green
Zoom Image
pastel green 62590 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70533
Candy Shop Pens pastel light green
Zoom Image
pastel light green 62589 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70531
Candy Shop Pens pastel orange
Zoom Image
pastel orange 62588 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70530
Candy Shop Pens pastel purple
Zoom Image
pastel purple 62587 $1.49 $1.13 25% Off $0.98 35% Off Email When In Stock
Add to Favorites
70528
Candy Shop Pens pastel white
Zoom Image
pastel white 62585 $1.49 $1.13 25% Off $0.98 35% 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...

Scale Lumber Gauge

by Midwest

Modeling essentials

From $4.07

Big Brush Watercolor Palette

by Sterling Edwards

22 wells for both mixing and storing color mixes

At Least 39 % Off

Deluxe Woodcarving Set

by X-Acto

Name brand quality for less

Up to 32% Off

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

Are these waterproof?

- Asked by mona on 22-Jul-13
Answer

According to American Crafts, these pens are permanent, but there's no indication that they're also waterproof.

- Answered by MisterArt on 22-Jul-13

Ask a Question About Candy Shop Pens


Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Candy Shop Pens

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