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

Flip Notes

by Wellspring


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229022325
barcode_type UPC
col1 lime blossoms
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description lime blossoms, each
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 92201
list_price 8.78
map NO
mfr_num 2232
net_weight 0.12
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 92201
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 92201
2 2232
3 lime blossoms, each
timestamp 2015-03-31T17:54:46.58Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229022356
barcode_type UPC
col1 raspberry hummingbird
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description raspberry hummingbird, each
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 92202
list_price 8.78
map NO
mfr_num 2235
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 92202
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 92202
2 2235
3 raspberry hummingbird, each
timestamp 2015-03-31T17:54:46.584Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229022332
barcode_type UPC
col1 plum wren
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description plum wren, each
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 92204
list_price 8.78
map NO
mfr_num 2233
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 92204
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 92204
2 2233
3 plum wren, each
timestamp 2015-03-31T17:54:46.586Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016294
barcode_type UPC
col1 bird
col1_sortorder 985
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description bird, each
group_id 13087
group_uname wellspring-flip-notes
id 03955
list_price 8.78
map NO
mfr_num 1629
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03955
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 03955
2 1629
3 bird, each
timestamp 2015-03-31T17:52:22.214Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229022493
barcode_type UPC
col1 black croc
col1_sortorder 1025
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description black croc, each
group_id 13087
group_uname wellspring-flip-notes
id 70269
list_price 8.78
map NO
mfr_num 2249
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 70269
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 70269
2 2249
3 black croc, each
timestamp 2015-03-31T17:54:18.262Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229022097
barcode_type UPC
col1 blue butterfly
col1_sortorder 1081
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description blue butterfly, each
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 66258
list_price 8.78
map NO
mfr_num 2209
net_weight 0.12
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 66258
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 66258
2 2209
3 blue butterfly, each
timestamp 2015-03-31T17:54:10.426Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229022509
barcode_type UPC
col1 brown croc
col1_sortorder 1225
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description brown croc, each
group_id 13087
group_uname wellspring-flip-notes
id 62237
list_price 8.78
map NO
mfr_num 2250
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 62237
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 62237
2 2250
3 brown croc, each
timestamp 2015-03-31T17:54:02.755Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229015440
barcode_type UPC
col1 dogwood
col1_sortorder 1981
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description dogwood, each
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 70267
list_price 8.78
map NO
mfr_num 1544
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 70267
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 70267
2 1544
3 dogwood, each
timestamp 2015-03-31T17:54:18.26Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016232
barcode_type UPC
col1 glitz black
col1_sortorder 2741
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description glitz black, each
group_id 13087
group_uname wellspring-flip-notes
id 03953
list_price 8.78
map NO
mfr_num 1623
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03953
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 03953
2 1623
3 glitz black, each
timestamp 2015-03-31T17:52:22.199Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016249
barcode_type UPC
col1 glitz pink
col1_sortorder 2743
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description glitz pink, each
group_id 13087
group_uname wellspring-flip-notes
id 03954
list_price 8.78
map NO
mfr_num 1624
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03954
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 03954
2 1624
3 glitz pink, each
timestamp 2015-03-31T17:52:22.204Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016973
barcode_type UPC
col1 lovely lashes
col1_sortorder 3604
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description lovely lashes, each
group_id 13087
group_uname wellspring-flip-notes
id 08393
list_price 8.78
map NO
mfr_num 1697
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 08393
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 08393
2 1697
3 lovely lashes, each
timestamp 2015-03-31T17:52:31.243Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016140
barcode_type UPC
col1 mauve mosaic
col1_sortorder 3746
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description mauve mosaic, each
group_id 13087
group_uname wellspring-flip-notes
id 03952
list_price 8.78
map NO
mfr_num 1614
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03952
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 03952
2 1614
3 mauve mosaic, each
timestamp 2015-03-31T17:52:22.195Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016317
barcode_type UPC
col1 mustache
col1_sortorder 4039
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description mustache, each
group_id 13087
group_uname wellspring-flip-notes
id 03956
list_price 8.78
map NO
mfr_num 1631
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03956
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 03956
2 1631
3 mustache, each
timestamp 2015-03-31T17:52:22.22Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229015242
barcode_type UPC
col1 owl
col1_sortorder 4286
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.58
deal_of_the_week NO
description owl, each
group_id 13087
group_uname wellspring-flip-notes
id 00369
list_price 8.33
map NO
mfr_num 1524
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 00369
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.41
ta_dealer_c_price 5.41
ta_price 7.49
text
array
1 00369
2 1524
3 owl, each
timestamp 2015-03-31T17:52:12.281Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229022042
barcode_type UPC
col1 replacement note pads
col1_sortorder 5003
col2 pack of 3
col2_sortorder 366
col3 [empty string]
cost 1.53
deal_of_the_week NO
description replacement note pads, pack of 3
flags
array
1 3
group_id 13087
group_uname wellspring-flip-notes
id 20171
list_price 2.78
map NO
mfr_num 2204
net_weight 0.12
non_member_discount 16
non_member_price 2.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 20171
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.81
ta_dealer_c_price 1.81
ta_price 2.5
text
array
1 20171
2 2204
3 replacement note pads, pack of 3
timestamp 2015-03-31T17:52:53.346Z
vip_member_price 2.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229016102
barcode_type UPC
col1 starfish
col1_sortorder 5777
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description starfish, each
group_id 13087
group_uname wellspring-flip-notes
id 01811
list_price 8.78
map NO
mfr_num 1610
net_weight 0.12
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 01811
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 01811
2 1610
3 starfish, each
timestamp 2015-03-31T17:52:15.723Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 784229022783
barcode_type UPC
col1 tire track
col1_sortorder 6143
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description tire track, each
group_id 13087
group_uname wellspring-flip-notes
id 62243
list_price 8.78
map NO
mfr_num 2278
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 62243
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 62243
2 2278
3 tire track, each
timestamp 2015-03-31T17:54:02.781Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


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

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

ItemIDList: 70673
AvailQtyList: 0E-12

struct
VIP_member_discount 26
barcode 784229017031
barcode_type UPC
col1 waverly
col1_sortorder 6533
col2 each
col2_sortorder 344
col3 [empty string]
cost 4.82
deal_of_the_week NO
description waverly, each
flags
array
1 2
group_id 13087
group_uname wellspring-flip-notes
id 09734
list_price 8.78
map NO
mfr_num 1703
net_weight 0.13
non_member_discount 16
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 09734
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 7.9
text
array
1 09734
2 1703
3 waverly, each
timestamp 2015-03-31T17:52:34.136Z
vip_member_price 6.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 70673
CACHED false
EXECUTIONTIME 10
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] = '10773' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e030ac0aba8c537bda5b73791fa387b33195
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~creativity-for-kids~&gr=creativity-for-kids-giant-fuzzy-pom-pom-pets.html
urltoken CFID=30583042&CFTOKEN=77529941&jsessionid=e030ac0aba8c537bda5b73791fa387b33195
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:53:13'}
sessionid e0307ae024fd7350c3f7270650787b59513f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~wellspring~&gr=wellspring-flip-notes.html
urltoken CFID=30583040&CFTOKEN=75280247&jsessionid=e0307ae024fd7350c3f7270650787b59513f
validationerror [empty string]


These 50 sheet blank note pads have a spring-loaded metal cover in a variety of colors and themed collections. A retractable pen is included and a replacement pack of blank note pads is available.

The flip note case measures 4 3/8 in. high x 2 3/4 in. wide.
The flip note refill pads measure 4 1/4 in. high x 2 3/8 in. wide.



Share on Facebook Twitter Pinterest

Ask a question about Flip Notes Ask a question about this product  |  See all questions & answers (1)

Flip Notes

by Wellspring

Average User Rating: Based on (2 Reviews)

5 2

Cheryl T. from Pittsburgh PA says:

Product was just as described on the Wb site at a great price. I'm very happy with my purchase!

[Read All Reviews] [Write a Review]









  Item# Image description
Ascending
unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
92201
Flip Notes lime blossoms each
Zoom Image
lime blossoms each 2232 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
92202
Flip Notes raspberry hummingbird each
Zoom Image
raspberry hummingbird each 2235 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
92204
Flip Notes plum wren each
Zoom Image
plum wren each 2233 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
03955
Flip Notes bird each
Zoom Image
bird each 1629 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
70269
Flip Notes black croc each
Zoom Image
black croc each 2249 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
66258
Flip Notes blue butterfly each
Zoom Image
blue butterfly each 2209 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
62237
Flip Notes brown croc each
Zoom Image
brown croc each 2250 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
70267
Flip Notes dogwood each
Zoom Image
dogwood each 1544 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
03953
Flip Notes glitz black each
Zoom Image
glitz black each 1623 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
03954
Flip Notes glitz pink each
Zoom Image
glitz pink each 1624 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
08393
Flip Notes lovely lashes each
Zoom Image
lovely lashes each 1697 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
03952
Flip Notes mauve mosaic each
Zoom Image
mauve mosaic each 1614 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
03956
Flip Notes mustache each
Zoom Image
mustache each 1631 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
00369
Flip Notes owl each
Zoom Image
owl each 1524 $8.33 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
20171
Flip Notes replacement note pads pack of 3
Zoom Image
replacement note pads pack of 3 2204 $2.78 $2.33 16% Off $2.06 26% Off Email When In Stock
Add to Favorites
01811
Flip Notes starfish each
Zoom Image
starfish each 1610 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
62243
Flip Notes tire track each
Zoom Image
tire track each 2278 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock
Add to Favorites
09734
  waverly each 1703 $8.78 $6.99 16% Off $6.19 26% Off Email When In Stock

Click the to add item to your Favorites.



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

Wood Carving Knife Set

by Loew Cornell

An excellent set for beginners

From $8.20

Cordless Embossing Tool

by Wall Lenk Corporation

World's best cordless heat gun

Up to 30% Off

Precision Screwdriver Set

by Cousin

Perfect for delicate jewelry work

From $1.77

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

Do you have lined note paper or colored paper?

- Asked by Albert R Cromie on 04-Oct-12
Answer

The Flip Notes are blank note pads. However, we do carry both lined and colored paper notebooks on our website. Use the search box above to find these options.

- Answered by MisterArt on 11-Oct-12

Ask a Question About Flip Notes


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

Customer Product Reviews
Write a Review
Write a Review
Rated by: Cheryl T. in Pittsburgh PA
Product was just as described on the Wb site at a great price. I'm very happy with my purchase!
Rated by: Irish49 in Orchard Park, NY
Love this little pad. It fits into my purse, has the pen handy, and is easy to find. The paper stays clean and flat inside the metal case. I bought several of these to give as gifts.

Write a Product Review for Flip Notes

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