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

Fantasy Prisme Effect Paint

by Pebeo


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074897
barcode_type EAN
col1 almond green
col1_sortorder 97
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 152-206-191.jpg
cost 3.71
deal_of_the_week NO
description almond green, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60713
list_price 7.6
map NO
mfr_num 166017CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60713
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60713
2 166017CAN
3 almond green, 45 ml
timestamp 2015-03-30T16:20:56.485Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074965
barcode_type EAN
col1 antique gold
col1_sortorder 148
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 230-200-107.jpg
cost 3.71
deal_of_the_week NO
description antique gold, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60724
list_price 7.6
map NO
mfr_num 166032CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60724
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60724
2 166032CAN
3 antique gold, 45 ml
timestamp 2015-03-30T16:20:56.513Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074804
barcode_type EAN
col1 antique pink
col1_sortorder 156
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 175-77-95.jpg
cost 3.71
deal_of_the_week NO
description antique pink, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60698
list_price 7.6
map NO
mfr_num 166022CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60698
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60698
2 166022CAN
3 antique pink, 45 ml
timestamp 2015-03-30T16:20:56.452Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074842
barcode_type EAN
col1 ash blue
col1_sortorder 211
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 188-194-199.jpg
cost 3.71
deal_of_the_week NO
description ash blue, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60703
list_price 7.6
map NO
mfr_num 166037CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60703
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60703
2 166037CAN
3 ash blue, 45 ml
timestamp 2015-03-30T16:20:56.467Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074811
barcode_type EAN
col1 bluish pink
col1_sortorder 638
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 121-106-163.jpg
cost 3.71
deal_of_the_week NO
description bluish pink, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60699
list_price 7.6
map NO
mfr_num 166028CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60699
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60699
2 166028CAN
3 bluish pink, 45 ml
timestamp 2015-03-30T16:20:56.455Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074743
barcode_type EAN
col1 buttercup
col1_sortorder 901
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 250-197-49.jpg
cost 3.71
deal_of_the_week NO
description buttercup, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60688
list_price 7.6
map NO
mfr_num 166024CAN
net_weight 0.12
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60688
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60688
2 166024CAN
3 buttercup, 45 ml
timestamp 2015-03-30T16:20:56.429Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074873
barcode_type EAN
col1 Caribbean blue
col1_sortorder 1104
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 0-173-231.jpg
cost 3.71
deal_of_the_week NO
description Caribbean blue, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60710
list_price 7.6
map NO
mfr_num 166039CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60710
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60710
2 166039CAN
3 Caribbean blue, 45 ml
timestamp 2015-03-30T16:20:56.477Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074781
barcode_type EAN
col1 cherry blossom
col1_sortorder 1197
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 167-9-33.jpg
cost 3.71
deal_of_the_week NO
description cherry blossom, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60696
list_price 7.6
map NO
mfr_num 166014CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60696
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60696
2 166014CAN
3 cherry blossom, 45 ml
timestamp 2015-03-30T16:20:56.442Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074972
barcode_type EAN
col1 chestnut
col1_sortorder 1206
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 185-148-86.jpg
cost 3.71
deal_of_the_week NO
description chestnut, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60725
list_price 7.6
map NO
mfr_num 166031CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60725
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60725
2 166031CAN
3 chestnut, 45 ml
timestamp 2015-03-30T16:20:56.519Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074958
barcode_type EAN
col1 cinnamon
col1_sortorder 1288
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 181-98-39.jpg
cost 3.71
deal_of_the_week NO
description cinnamon, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60723
list_price 7.6
map NO
mfr_num 166033CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60723
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60723
2 166033CAN
3 cinnamon, 45 ml
timestamp 2015-03-30T16:20:56.511Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074729
barcode_type EAN
col1 eggshell white
col1_sortorder 2013
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 255-241-214.jpg
cost 3.71
deal_of_the_week NO
description eggshell white, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60686
list_price 7.6
map NO
mfr_num 166020CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60686
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60686
2 166020CAN
3 eggshell white, 45 ml
timestamp 2015-03-30T16:20:56.425Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074903
barcode_type EAN
col1 emerald
col1_sortorder 2031
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 30-143-83.jpg
cost 3.71
deal_of_the_week NO
description emerald, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60715
list_price 7.6
map NO
mfr_num 166018CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60715
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60715
2 166018CAN
3 emerald, 45 ml
timestamp 2015-03-30T16:20:56.487Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074774
barcode_type EAN
col1 English red
col1_sortorder 2056
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 179-43-51.jpg
cost 3.71
deal_of_the_week NO
description English red, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60693
list_price 7.6
map NO
mfr_num 166013CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60693
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60693
2 166013CAN
3 English red, 45 ml
timestamp 2015-03-30T16:20:56.435Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074941
barcode_type EAN
col1 green umber
col1_sortorder 2675
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 159-134-81.jpg
cost 3.71
deal_of_the_week NO
description green umber, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60722
list_price 7.6
map NO
mfr_num 166034CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60722
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60722
2 166034CAN
3 green umber, 45 ml
timestamp 2015-03-30T16:20:56.509Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074934
barcode_type EAN
col1 greengold
col1_sortorder 2691
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 164-159-110.jpg
cost 3.71
deal_of_the_week NO
description greengold, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60718
list_price 7.6
map NO
mfr_num 166035CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60718
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60718
2 166035CAN
3 greengold, 45 ml
timestamp 2015-03-30T16:20:56.493Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074798
barcode_type EAN
col1 icy pink
col1_sortorder 2912
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 226-185-194.jpg
cost 3.71
deal_of_the_week NO
description icy pink, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60697
list_price 7.6
map NO
mfr_num 166021CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60697
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60697
2 166021CAN
3 icy pink, 45 ml
timestamp 2015-03-30T16:20:56.451Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074927
barcode_type EAN
col1 leaf
col1_sortorder 3259
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 69-107-53.jpg
cost 3.71
deal_of_the_week NO
description leaf, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60717
list_price 7.6
map NO
mfr_num 166029CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60717
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60717
2 166029CAN
3 leaf, 45 ml
timestamp 2015-03-30T16:20:56.491Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074750
barcode_type EAN
col1 mandarin
col1_sortorder 3571
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 245-139-53.jpg
cost 3.71
deal_of_the_week NO
description mandarin, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60691
list_price 7.6
map NO
mfr_num 166016CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60691
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60691
2 166016CAN
3 mandarin, 45 ml
timestamp 2015-03-30T16:20:56.431Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074866
barcode_type EAN
col1 marina
col1_sortorder 3599
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 72-103-169.jpg
cost 3.71
deal_of_the_week NO
description marina, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60707
list_price 7.6
map NO
mfr_num 166038CAN
net_weight 0.12
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60707
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60707
2 166038CAN
3 marina, 45 ml
timestamp 2015-03-30T16:20:56.474Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074859
barcode_type EAN
col1 midnight blue
col1_sortorder 3765
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 33-94-149.jpg
cost 3.71
deal_of_the_week NO
description midnight blue, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60705
list_price 7.6
map NO
mfr_num 166036CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60705
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60705
2 166036CAN
3 midnight blue, 45 ml
timestamp 2015-03-30T16:20:56.469Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074989
barcode_type EAN
col1 moonstone
col1_sortorder 3843
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 189-191-193.jpg
cost 3.71
deal_of_the_week NO
description moonstone, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60726
list_price 7.6
map NO
mfr_num 166050CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60726
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60726
2 166050CAN
3 moonstone, 45 ml
timestamp 2015-03-30T16:20:56.522Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074996
barcode_type EAN
col1 onyx
col1_sortorder 4184
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 141-130-122.jpg
cost 3.71
deal_of_the_week NO
description onyx, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60729
list_price 7.6
map NO
mfr_num 166051CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60729
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60729
2 166051CAN
3 onyx, 45 ml
timestamp 2015-03-30T16:20:56.53Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074910
barcode_type EAN
col1 pearl green
col1_sortorder 4468
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 211-221-202.jpg
cost 3.71
deal_of_the_week NO
description pearl green, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60716
list_price 7.6
map NO
mfr_num 166019CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60716
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60716
2 166019CAN
3 pearl green, 45 ml
timestamp 2015-03-30T16:20:56.489Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074828
barcode_type EAN
col1 pearl violine
col1_sortorder 4487
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 95-0-173.jpg
cost 3.71
deal_of_the_week NO
description pearl violine, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60701
list_price 7.6
map NO
mfr_num 166025CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60701
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60701
2 166025CAN
3 pearl violine, 45 ml
timestamp 2015-03-30T16:20:56.46Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074736
barcode_type EAN
col1 summer yellow
col1_sortorder 5860
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 221-187-122.jpg
cost 3.71
deal_of_the_week NO
description summer yellow, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60687
list_price 7.6
map NO
mfr_num 166023CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60687
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60687
2 166023CAN
3 summer yellow, 45 ml
timestamp 2015-03-30T16:20:56.427Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074880
barcode_type EAN
col1 turquoise
col1_sortorder 6215
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 61-162-165.jpg
cost 3.71
deal_of_the_week NO
description turquoise, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60711
list_price 7.6
map NO
mfr_num 166040CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60711
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60711
2 166040CAN
3 turquoise, 45 ml
timestamp 2015-03-30T16:20:56.479Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074767
barcode_type EAN
col1 vermilion
col1_sortorder 6362
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 254-59-30.jpg
cost 3.71
deal_of_the_week NO
description vermilion, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60692
list_price 7.6
map NO
mfr_num 166012CAN
net_weight 0.12
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60692
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60692
2 166012CAN
3 vermilion, 45 ml
timestamp 2015-03-30T16:20:56.433Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


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

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

ItemIDList: 22944,46833,48241,58351,67677,69092,71990,75473,75562
AvailQtyList: 6.000000000000,1.000000000000,0E-12,1.000000000000,0E-12,1.000000000000,6.000000000000,6.000000000000,8.000000000000

struct
FLAGS 0
VIP_member_discount 31
barcode 3167860074835
barcode_type EAN
col1 violet
col1_sortorder 6409
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 57-57-168.jpg
cost 3.71
deal_of_the_week NO
description violet, 45 ml
group_id 11007
group_uname pebeo-fantasy-prisme-effect-paint
id 60702
list_price 7.6
map NO
mfr_num 166026CAN
net_weight 0.13
non_member_discount 21
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60702
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60702
2 166026CAN
3 violet, 45 ml
timestamp 2015-03-30T16:20:56.464Z
vip_member_price 5.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 22944
2 1.000000000000 46833
3 0E-12 48241
4 1.000000000000 58351
5 0E-12 67677
6 1.000000000000 69092
7 6.000000000000 71990
8 6.000000000000 75473
9 8.000000000000 75562
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] = '4662' 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.204.243.45

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e0302a440a87ddf924b97624f32693302552
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=metal-tooling&gr=mercart-decorative-embossing-wheels.html
urltoken CFID=30311104&CFTOKEN=23048043&jsessionid=e0302a440a87ddf924b97624f32693302552
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:14:10'}
sessionid e030d973dd04434641c02a2e19326d122544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=fb~pebeo~&gr=pebeo-fantasy-prisme-effect-paint.html
urltoken CFID=30311105&CFTOKEN=26710043&jsessionid=e030d973dd04434641c02a2e19326d122544
validationerror [empty string]


Pebeo Fantasy Prisme Effect Colours feature multi-toned, textured effects when they dry, giving the appearance of a unique textured surface, but with a smooth, glossy finish. Fantasy Prisme Effect Colours are solvent-based, and can be used in thick layers on all flat surfaces, including, wood, canvas, metal, glass, ceramic, terracotta, porcelain, mirrors, and more! When adding a precious quality finish to jewelry, Prisme Effect Colours work wonders.

When mixed with Vitrail or Fantasy Moon colours, Fantasy Prisme creates contrasting marble effects.

Available in 45-milliliter bottles.



Share on Facebook Twitter Pinterest

Ask a question about Fantasy Prisme Effect Paint Ask a question about this product

Fantasy Prisme Effect Paint

by Pebeo

Be the first to write a review on this product!









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
60713
Fantasy Prisme Effect Paint almond green 45 ml
Zoom Image
almond green 45 ml 166017CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60724
Fantasy Prisme Effect Paint antique gold 45 ml
Zoom Image
antique gold 45 ml 166032CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60698
Fantasy Prisme Effect Paint antique pink 45 ml
Zoom Image
antique pink 45 ml 166022CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60703
Fantasy Prisme Effect Paint ash blue 45 ml
Zoom Image
ash blue 45 ml 166037CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60699
Fantasy Prisme Effect Paint bluish pink 45 ml
Zoom Image
bluish pink 45 ml 166028CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60688
Fantasy Prisme Effect Paint buttercup 45 ml
Zoom Image
buttercup 45 ml 166024CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60710
Fantasy Prisme Effect Paint Caribbean blue 45 ml
Zoom Image
Caribbean blue 45 ml 166039CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60696
Fantasy Prisme Effect Paint cherry blossom 45 ml
Zoom Image
cherry blossom 45 ml 166014CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60725
Fantasy Prisme Effect Paint chestnut 45 ml
Zoom Image
chestnut 45 ml 166031CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60723
Fantasy Prisme Effect Paint cinnamon 45 ml
Zoom Image
cinnamon 45 ml 166033CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60686
Fantasy Prisme Effect Paint eggshell white 45 ml
Zoom Image
eggshell white 45 ml 166020CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60715
Fantasy Prisme Effect Paint emerald 45 ml
Zoom Image
emerald 45 ml 166018CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60693
Fantasy Prisme Effect Paint English red 45 ml
Zoom Image
English red 45 ml 166013CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60722
Fantasy Prisme Effect Paint green umber 45 ml
Zoom Image
green umber 45 ml 166034CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60718
Fantasy Prisme Effect Paint greengold 45 ml
Zoom Image
greengold 45 ml 166035CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60697
Fantasy Prisme Effect Paint icy pink 45 ml
Zoom Image
icy pink 45 ml 166021CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60717
Fantasy Prisme Effect Paint leaf 45 ml
Zoom Image
leaf 45 ml 166029CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60691
Fantasy Prisme Effect Paint mandarin 45 ml
Zoom Image
mandarin 45 ml 166016CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60707
Fantasy Prisme Effect Paint marina 45 ml
Zoom Image
marina 45 ml 166038CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60705
Fantasy Prisme Effect Paint midnight blue 45 ml
Zoom Image
midnight blue 45 ml 166036CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60726
Fantasy Prisme Effect Paint moonstone 45 ml
Zoom Image
moonstone 45 ml 166050CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60729
Fantasy Prisme Effect Paint onyx 45 ml
Zoom Image
onyx 45 ml 166051CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60716
Fantasy Prisme Effect Paint pearl green 45 ml
Zoom Image
pearl green 45 ml 166019CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60701
Fantasy Prisme Effect Paint pearl violine 45 ml
Zoom Image
pearl violine 45 ml 166025CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60687
Fantasy Prisme Effect Paint summer yellow 45 ml
Zoom Image
summer yellow 45 ml 166023CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60711
Fantasy Prisme Effect Paint turquoise 45 ml
Zoom Image
turquoise 45 ml 166040CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60692
Fantasy Prisme Effect Paint vermilion 45 ml
Zoom Image
vermilion 45 ml 166012CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock
Add to Favorites
60702
Fantasy Prisme Effect Paint violet 45 ml
Zoom Image
violet 45 ml 166026CAN $7.60 $5.99 21% Off $5.24 31% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



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