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

Decorative Sealing Sets

by Manuscript


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727001
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 heart
col2_sortorder 250
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, heart
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98621
list_price 3.95
map NO
mfr_num MSH727HEA
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98621
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 2.96
text
array
1 98621
2 MSH727HEA
3 decorative seal coin, heart
timestamp 2015-03-27T14:48:42.607Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727018
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 flower
col2_sortorder 226
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, flower
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98622
list_price 3.95
map NO
mfr_num MSH727FLO
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98622
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98622
2 MSH727FLO
3 decorative seal coin, flower
timestamp 2015-03-27T14:48:42.609Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727025
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 christmas tree
col2_sortorder 143
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, christmas tree
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98623
list_price 3.95
map NO
mfr_num MSH727CHT
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98623
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98623
2 MSH727CHT
3 decorative seal coin, christmas tree
timestamp 2015-03-27T14:48:42.615Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727056
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 leaf
col2_sortorder 277
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, leaf
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98624
list_price 3.95
map NO
mfr_num MSH727LEA
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98624
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98624
2 MSH727LEA
3 decorative seal coin, leaf
timestamp 2015-03-27T14:48:42.618Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727049
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 pram
col2_sortorder 408
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, pram
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98625
list_price 3.95
map NO
mfr_num MSH727PRM
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98625
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98625
2 MSH727PRM
3 decorative seal coin, pram
timestamp 2015-03-27T14:48:42.62Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
col1 decorative seal coin
col1_sortorder 1866
col2 pumpkin
col2_sortorder 414
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, pumpkin
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98626
list_price 3.95
map NO
mfr_num MSH727PUM
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98626
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 2.96
text
array
1 98626
2 MSH727PUM
3 decorative seal coin, pumpkin
timestamp 2015-03-27T14:48:42.623Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727063
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 celebration glass/bubbles
col2_sortorder 136
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, celebration glass/bubbles
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98627
list_price 3.95
map NO
mfr_num MSH727CLB
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98627
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98627
2 MSH727CLB
3 decorative seal coin, celebration glass/bubbles
timestamp 2015-03-27T14:48:42.625Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727094
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 butterfly
col2_sortorder 128
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, butterfly
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98628
list_price 3.95
map NO
mfr_num MSH727BUT
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98628
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98628
2 MSH727BUT
3 decorative seal coin, butterfly
timestamp 2015-03-27T14:48:42.631Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727100
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 rocking horse
col2_sortorder 430
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, rocking horse
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98629
list_price 3.95
map NO
mfr_num MSH727RCK
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98629
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98629
2 MSH727RCK
3 decorative seal coin, rocking horse
timestamp 2015-03-27T14:48:42.636Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727117
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 rings
col2_sortorder 428
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, rings
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98630
list_price 3.95
map NO
mfr_num MSH727RIN
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98630
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98630
2 MSH727RIN
3 decorative seal coin, rings
timestamp 2015-03-27T14:48:42.642Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727131
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 cake
col2_sortorder 132
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, cake
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98631
list_price 3.95
map NO
mfr_num MSH727CAK
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98631
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98631
2 MSH727CAK
3 decorative seal coin, cake
timestamp 2015-03-27T14:48:42.644Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727148
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 snowflake
col2_sortorder 477
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, snowflake
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98632
list_price 3.95
map NO
mfr_num MSH727SNF
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98632
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 2.96
text
array
1 98632
2 MSH727SNF
3 decorative seal coin, snowflake
timestamp 2015-03-27T14:48:42.647Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727162
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 horseshoe
col2_sortorder 265
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, horseshoe
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98633
list_price 3.95
map NO
mfr_num MSH727HRS
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98633
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98633
2 MSH727HRS
3 decorative seal coin, horseshoe
timestamp 2015-03-27T14:48:42.65Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 762491727179
barcode_type UPC
col1 decorative seal coin
col1_sortorder 1866
col2 thank you
col2_sortorder 519
col3 [empty string]
cost 1.68
deal_of_the_week NO
description decorative seal coin, thank you
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98634
list_price 3.95
map NO
mfr_num MSH727THY
net_weight 0.2
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 98634
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 2.13
ta_price 1.98
text
array
1 98634
2 MSH727THY
3 decorative seal coin, thank you
timestamp 2015-03-27T14:48:42.652Z
vip_member_price 2.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 5020180727004
barcode_type UPC-RANDOM
col1 decorative seal set
col1_sortorder 1867
col2 butterfly/cake/heart
col2_sortorder 130
col3 [empty string]
cost 6.84
deal_of_the_week NO
description decorative seal set, butterfly/cake/heart
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98617
list_price 16.03
map NO
mfr_num MSH7273OCC
net_weight 0.9
non_member_discount 20
non_member_price 12.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 98617
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.66
ta_dealer_c_price 8.66
ta_price 12.02
text
array
1 98617
2 MSH7273OCC
3 decorative seal set, butterfly/cake/heart
timestamp 2015-03-27T14:48:42.592Z
vip_member_price 10.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 5020180727011
barcode_type UPC-RANDOM
col1 decorative seal set
col1_sortorder 1867
col2 flower/leaf/snowflake
col2_sortorder 228
col3 [empty string]
cost 6.84
deal_of_the_week NO
description decorative seal set, flower/leaf/snowflake
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98618
list_price 16.03
map NO
mfr_num MSH7273SEA
net_weight 0.9
non_member_discount 20
non_member_price 12.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 98618
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.66
ta_dealer_c_price 8.66
ta_price 12.02
text
array
1 98618
2 MSH7273SEA
3 decorative seal set, flower/leaf/snowflake
timestamp 2015-03-27T14:48:42.594Z
vip_member_price 10.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 762491727421
barcode_type UPC
col1 decorative seal set
col1_sortorder 1867
col2 foot/pram/rocking horse
col2_sortorder 232
col3 [empty string]
cost 6.84
deal_of_the_week NO
description decorative seal set, foot/pram/rocking horse
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98619
list_price 16.03
map NO
mfr_num MSH7273BIR
net_weight 0.9
non_member_discount 20
non_member_price 12.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 98619
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.66
ta_dealer_c_price 8.66
ta_price 12.02
text
array
1 98619
2 MSH7273BIR
3 decorative seal set, foot/pram/rocking horse
timestamp 2015-03-27T14:48:42.597Z
vip_member_price 10.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


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

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

ItemIDList: 12025
AvailQtyList: 45.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 762491727438
barcode_type UPC
col1 decorative seal set
col1_sortorder 1867
col2 rings/horseshoe/thank you
col2_sortorder 429
col3 [empty string]
cost 6.84
deal_of_the_week NO
description decorative seal set, rings/horseshoe/thank you
group_id 10130
group_uname manuscript-decorative-sealing-sets
id 98620
list_price 16.03
map NO
mfr_num MSH7273MRG
net_weight 0.9
non_member_discount 20
non_member_price 12.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 98620
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.66
ta_dealer_c_price 8.66
ta_price 12.02
text
array
1 98620
2 MSH7273MRG
3 decorative seal set, rings/horseshoe/thank you
timestamp 2015-03-27T14:48:42.601Z
vip_member_price 10.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 12025
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] = '12008' 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.89.0.97

URL: www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030cd282524c2855aa7256b12455a3e1c7d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=fabric-glue&CatD=fp~8-13~&gr=beacon-fabri-tac-permanent-adhesive.html
urltoken CFID=30206547&CFTOKEN=31800021&jsessionid=e030cd282524c2855aa7256b12455a3e1c7d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 09:11:57'}
sessionid e030e141f0030cc5413b78060437a529397c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=sort~1~fp~8-14~&gr=manuscript-decorative-sealing-sets.html
urltoken CFID=30206546&CFTOKEN=92308685&jsessionid=e030e141f0030cc5413b78060437a529397c
validationerror [empty string]


An individual and striking way to decorate your correspondence, scrapbooks and gifts! Each set includes a handle, sealing wax stick and 3 interchangeable seal coins. Seal designs vary per set.
Designs also available as individual seal coins.


Share on Facebook Twitter Pinterest

Ask a question about Decorative Sealing Sets Ask a question about this product

Decorative Sealing Sets

by Manuscript

Be the first to write a review on this product!









  Item# Image description
Ascending
shape Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
98621
Decorative Sealing Sets decorative seal coin heart
Zoom Image
decorative seal coin heart MSH727HEA $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98622
Decorative Sealing Sets decorative seal coin flower
Zoom Image
decorative seal coin flower MSH727FLO $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98623
Decorative Sealing Sets decorative seal coin christmas tree
Zoom Image
decorative seal coin christmas tree MSH727CHT $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98624
Decorative Sealing Sets decorative seal coin leaf
Zoom Image
decorative seal coin leaf MSH727LEA $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98625
Decorative Sealing Sets decorative seal coin pram
Zoom Image
decorative seal coin pram MSH727PRM $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98626
Decorative Sealing Sets decorative seal coin pumpkin
Zoom Image
decorative seal coin pumpkin MSH727PUM $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98627
Decorative Sealing Sets decorative seal coin celebration glass/bubbles
Zoom Image
decorative seal coin celebration glass/bubbles MSH727CLB $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98628
Decorative Sealing Sets decorative seal coin butterfly
Zoom Image
decorative seal coin butterfly MSH727BUT $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98629
Decorative Sealing Sets decorative seal coin rocking horse
Zoom Image
decorative seal coin rocking horse MSH727RCK $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98630
Decorative Sealing Sets decorative seal coin rings
Zoom Image
decorative seal coin rings MSH727RIN $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98631
Decorative Sealing Sets decorative seal coin cake
Zoom Image
decorative seal coin cake MSH727CAK $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98632
Decorative Sealing Sets decorative seal coin snowflake
Zoom Image
decorative seal coin snowflake MSH727SNF $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98633
Decorative Sealing Sets decorative seal coin horseshoe
Zoom Image
decorative seal coin horseshoe MSH727HRS $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98634
Decorative Sealing Sets decorative seal coin thank you
Zoom Image
decorative seal coin thank you MSH727THY $3.95 $3.16 20% Off $2.71 31% Off Email When In Stock
Add to Favorites
98617
Decorative Sealing Sets decorative seal set butterfly/cake/heart
Zoom Image
decorative seal set butterfly/cake/heart MSH7273OCC $16.03 $12.76 20% Off $10.94 32% Off Email When In Stock
Add to Favorites
98618
Decorative Sealing Sets decorative seal set flower/leaf/snowflake
Zoom Image
decorative seal set flower/leaf/snowflake MSH7273SEA $16.03 $12.76 20% Off $10.94 32% Off Email When In Stock
Add to Favorites
98619
Decorative Sealing Sets decorative seal set foot/pram/rocking horse
Zoom Image
decorative seal set foot/pram/rocking horse MSH7273BIR $16.03 $12.76 20% Off $10.94 32% Off Email When In Stock
Add to Favorites
98620
Decorative Sealing Sets decorative seal set rings/horseshoe/thank you
Zoom Image
decorative seal set rings/horseshoe/thank you MSH7273MRG $16.03 $12.76 20% Off $10.94 32% Off Email When In Stock

Click the to add item to your Favorites.



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

Deluxe Glass Etching Kit

by Armour

Start etching today

Up to 33% Off

Calligraphy Classic Kit for the...

by Sheaffer

Quick and easy guide for beginners

Up to 48% Off

From $6.22

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 Decorative Sealing Sets

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 Decorative Sealing Sets

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