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

Household Hardware Tidy Twist Pin 18 pack

by Moore


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

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

ItemIDList: 16509,16545
AvailQtyList: 14.000000000000,44.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 072228190009
barcode_type UPC
col1 pack of 18
col1_sortorder 427
col2 no. 9
col2_sortorder 541
col3 [empty string]
cost 1.81
deal_of_the_week NO
description pack of 18, no. 9
group_id 10626
group_uname moore-household-hardware-tidy-twist-pin-18-pack
id 94752
list_price 3.29
map NO
mfr_num 9
net_weight 0.03
non_member_discount 10
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 94752
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.97
ta_dealer_c_price 1.97
ta_price 2.96
text
array
1 94752
2 9
3 pack of 18, no. 9
timestamp 2015-03-30T16:22:09.581Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 16509
2 44.000000000000 16545
CACHED false
EXECUTIONTIME 15
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] = '10165' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~moore~c1~display-presentation~&gr=moore-household-hardware-tidy-twist-pin-18-pack.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:38:10'}
sessionid e030547ce4fa0470c2514f1d2f695765882a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=fp~10-9999.99~&gr=manetti-23-karat-gold-leaf.html
urltoken CFID=30234715&CFTOKEN=77320104&jsessionid=e030547ce4fa0470c2514f1d2f695765882a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:38:09'}
sessionid e030995ff2c478afbb8d1514c7aa66f29c40
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~moore~c1~display-presentation~&gr=moore-household-hardware-tidy-twist-pin-18-pack.html
urltoken CFID=30234713&CFTOKEN=58430705&jsessionid=e030995ff2c478afbb8d1514c7aa66f29c40
validationerror [empty string]


These nickel-plated brass pins twist into position. They are rust-proof and perfect for securing fabric. Beyond their artwork mounting capabilities, they can be used on furniture or in other household fabric applications.

Share on Facebook Twitter Pinterest

Ask a question about Household Hardware Tidy Twist Pin 18 pack Ask a question about this product

Household Hardware Tidy Twist Pin 18 pack

by Moore









  Item# Image unit
Ascending
series number Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
94752
Household Hardware Tidy Twist Pin 18 pack pack of 18 no. 9
Zoom Image
pack of 18 no. 9 9 $3.29 $2.96 10% Off $2.58 22% Off Email When In Stock

Click the to add item to your Favorites.



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

Wood Carving Tool Set

by Jack Richeson

Ideal for students on a budget

From $6.30

Woodburner Kits

by Wall Lenk Corporation

Start woodburning today

From $5.09

Color Round II Palette With Lid

by Jones

Make your own color wheel

From $9.35

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 Household Hardware Tidy Twist Pin 18 pack

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

Write a Product Review for Household Hardware Tidy Twist Pin 18 pack

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