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

Bulldog Clips

by X-Acto


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

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

ItemIDList:
AvailQtyList:

struct
VIP_member_discount 20
barcode 079946020007
barcode_type UPC
col1 size 0
col1_sortorder 2574
col2 1 in.
col2_sortorder 6
col3 each
col3_sortorder 340
cost 0.17
deal_of_the_week NO
description size 0, 1 in., each
flags
array
1 3
group_id 570
group_uname x-acto-bulldog-clips
id 20766
list_price 0.31
map NO
mfr_num 2000-36
net_weight 0.01
non_member_discount 10
non_member_price 0.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 20766
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.19
ta_dealer_c_price 0.19
ta_price 0.25
text
array
1 20766
2 2000-36
3 size 0, 1 in., each
timestamp 2015-03-27T14:46:40.878Z
vip_member_price 0.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Problem with item sku 20766-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 25
col1 size 0
col1_sortorder 2574
col2 1 in.
col2_sortorder 6
col3 box of 36
col3_sortorder 259
cost 6.12
deal_of_the_week NO
description size 0, 1 in., box of 36
group_id 570
group_uname x-acto-bulldog-clips
id 20766-PK
list_price 11.16
map NO
net_weight 0.72
non_member_discount 15
non_member_price 9.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 20766-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 20766-PK
2 size 0, 1 in., box of 36
timestamp 2015-03-27T14:46:40.88Z
vip_member_price 8.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
VIP_member_discount 20
barcode 079946020014
barcode_type UPC
col1 size 1
col1_sortorder 2575
col2 1 1/4 in.
col2_sortorder 7
col3 each
col3_sortorder 340
cost 0.18
deal_of_the_week NO
description size 1, 1 1/4 in., each
flags
array
1 3
group_id 570
group_uname x-acto-bulldog-clips
id 27393
list_price 0.33
map NO
mfr_num 2001-36
net_weight 0.02
non_member_discount 10
non_member_price 0.3
prop65 NO
ship_rule_desc STD
shipping STD
sku 27393
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.2
ta_dealer_c_price 0.2
ta_price 0.3
text
array
1 27393
2 2001-36
3 size 1, 1 1/4 in., each
timestamp 2015-03-27T14:46:50.577Z
vip_member_price 0.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Problem with item sku 27393-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 25
col1 size 1
col1_sortorder 2575
col2 1 1/4 in.
col2_sortorder 7
col3 box of 36
col3_sortorder 259
cost 6.48
deal_of_the_week NO
description size 1, 1 1/4 in., box of 36
group_id 570
group_uname x-acto-bulldog-clips
id 27393-PK
list_price 11.88
map NO
net_weight 0.85
non_member_discount 15
non_member_price 10.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 27393-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 27393-PK
2 size 1, 1 1/4 in., box of 36
timestamp 2015-03-27T14:46:50.582Z
vip_member_price 8.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
VIP_member_discount 20
barcode 079946020021
barcode_type UPC
col1 size 2
col1_sortorder 2576
col2 2 1/4 in.
col2_sortorder 13
col3 each
col3_sortorder 340
cost 0.23
deal_of_the_week NO
description size 2, 2 1/4 in., each
flags
array
1 3
group_id 570
group_uname x-acto-bulldog-clips
id 75696
list_price 0.43
map NO
mfr_num 2002-36
net_weight 0.04
non_member_discount 9
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 75696
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.39
text
array
1 75696
2 2002-36
3 size 2, 2 1/4 in., each
timestamp 2015-03-27T14:48:05.676Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Problem with item sku 75696-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 25
col1 size 2
col1_sortorder 2576
col2 2 1/4 in.
col2_sortorder 13
col3 box of 36
col3_sortorder 259
cost 8.28
deal_of_the_week NO
description size 2, 2 1/4 in., box of 36
group_id 570
group_uname x-acto-bulldog-clips
id 75696-PK
list_price 15.48
map NO
net_weight 1.38
non_member_discount 15
non_member_price 13.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 75696-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 75696-PK
2 size 2, 2 1/4 in., box of 36
timestamp 2015-03-27T14:48:05.678Z
vip_member_price 11.61

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 20
barcode 079946020038
barcode_type UPC
col1 size 3
col1_sortorder 2577
col2 2 5/8 in.
col2_sortorder 14
col3 each
col3_sortorder 340
cost 0.54
deal_of_the_week NO
description size 3, 2 5/8 in., each
group_id 570
group_uname x-acto-bulldog-clips
id 15917
list_price 0.97
map NO
mfr_num 2003-12
net_weight 0.07
non_member_discount 10
non_member_price 0.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 15917
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.58
ta_dealer_c_price 0.58
ta_price 0.87
text
array
1 15917
2 2003-12
3 size 3, 2 5/8 in., each
timestamp 2015-03-27T14:46:35.002Z
vip_member_price 0.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Problem with item sku 15917-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 25
col1 size 3
col1_sortorder 2577
col2 2 5/8 in.
col2_sortorder 14
col3 box of 12
col3_sortorder 248
cost 6.48
deal_of_the_week NO
description size 3, 2 5/8 in., box of 12
group_id 570
group_uname x-acto-bulldog-clips
id 15917-PK
list_price 11.64
map NO
net_weight 0.75
non_member_discount 15
non_member_price 9.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 15917-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 15917-PK
2 size 3, 2 5/8 in., box of 12
timestamp 2015-03-27T14:46:35.007Z
vip_member_price 8.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
VIP_member_discount 20
barcode 079946020045
barcode_type UPC
col1 size 4
col1_sortorder 2578
col2 3 in.
col2_sortorder 15
col3 each
col3_sortorder 340
cost 0.59
deal_of_the_week NO
description size 4, 3 in., each
flags
array
1 3
group_id 570
group_uname x-acto-bulldog-clips
id 20986
list_price 1.07
map NO
mfr_num 2004-12
net_weight 0.13
non_member_discount 10
non_member_price 0.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 20986
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.64
ta_dealer_c_price 0.64
ta_price 0.9
text
array
1 20986
2 2004-12
3 size 4, 3 in., each
timestamp 2015-03-27T14:46:41.361Z
vip_member_price 0.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Problem with item sku 20986-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 25
col1 size 4
col1_sortorder 2578
col2 3 in.
col2_sortorder 15
col3 box of 12
col3_sortorder 248
cost 7.08
deal_of_the_week NO
description size 4, 3 in., box of 12
group_id 570
group_uname x-acto-bulldog-clips
id 20986-PK
list_price 12.84
map NO
net_weight 0.85
non_member_discount 15
non_member_price 10.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 20986-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 20986-PK
2 size 4, 3 in., box of 12
timestamp 2015-03-27T14:46:41.367Z
vip_member_price 9.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '570' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:15:36'}
sessionid e030a222852a0f0887694bf404e496075116
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~x-acto~c1~tools~&gr=x-acto-bulldog-clips.html
urltoken CFID=30173475&CFTOKEN=78427469&jsessionid=e030a222852a0f0887694bf404e496075116
validationerror [empty string]


Heavy spring clips with easy grip handles. Useful for fastening papers too thick for paper clips.

Share on Facebook Twitter Pinterest

Ask a question about Bulldog Clips Ask a question about this product

Bulldog Clips

by X-Acto

Average User Rating: Based on (6 Reviews)

5 6

Margaret G. from Kennebunk, ME says:

Use these clips when making lamp shades. Tried other alternatives, but these work the best.

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
width unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
20766
Bulldog Clips size 0 1 in. each
Zoom Image
size 0 1 in. each 2000-36 $0.31 $0.28 10% Off $0.25 20% Off Email When In Stock
Add to Favorites
20766-PK
  size 0 1 in. box of 36 $11.16 $9.49 15% Off $8.37 25% Off Email When In Stock
Add to Favorites
27393
Bulldog Clips size 1 1 1/4 in. each
Zoom Image
size 1 1 1/4 in. each 2001-36 $0.33 $0.30 10% Off $0.26 20% Off Email When In Stock
Add to Favorites
27393-PK
  size 1 1 1/4 in. box of 36 $11.88 $10.10 15% Off $8.91 25% Off Email When In Stock
Add to Favorites
75696
Bulldog Clips size 2 2 1/4 in. each
Zoom Image
size 2 2 1/4 in. each 2002-36 $0.43 $0.39 9% Off $0.34 20% Off Email When In Stock
Add to Favorites
75696-PK
  size 2 2 1/4 in. box of 36 $15.48 $13.16 15% Off $11.61 25% Off Email When In Stock
Add to Favorites
15917
Bulldog Clips size 3 2 5/8 in. each
Zoom Image
size 3 2 5/8 in. each 2003-12 $0.97 $0.87 10% Off $0.78 20% Off Email When In Stock
Add to Favorites
15917-PK
  size 3 2 5/8 in. box of 12 $11.64 $9.89 15% Off $8.73 25% Off Email When In Stock
Add to Favorites
20986
Bulldog Clips size 4 3 in. each
Zoom Image
size 4 3 in. each 2004-12 $1.07 $0.96 10% Off $0.86 20% Off Email When In Stock
Add to Favorites
20986-PK
  size 4 3 in. box of 12 $12.84 $10.91 15% Off $9.63 25% Off Email When In Stock

Click the to add item to your Favorites.



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

TB 715 Glaze Brush

by Duncan

Ideal for glazing and shading

From $5.47

Mini Screwdriver with Phillips and...

by ProEdge

Two screwdrivers in one mini tool

From $9.82

Totally Brushes

by Loew Cornell

Great for crafts and hobbies

From $6.28

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Bulldog Clips

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: Margaret G. in Kennebunk, ME
Use these clips when making lamp shades. Tried other alternatives, but these work the best.
Rated by: mary catherine l. in greybull, WY
I love these doggies. They are better than an extra pair of hansds!
Rated by: Kim S. in Orland, ME
I love the product. The customer service was excellent
Rated by: Holly J K. in Magdalena, NM
Every studio (or kitchen) should have a dozen of these. I use thse every day and the quality is the best.
Rated by: Lisa A. in Homestead, FL
I love these for all kinds of things, but most recently to use as embellishments on the altered objects I have become so fond of. They add just the perfect touch of extra, while also being functional.
Rated by: Ammi R. in Belmont, CA
These are just perfect for me to keep my paperwork in order!

Write a Product Review for Bulldog Clips

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