Limited-Time Promotion

Puffco 4/20 Wholesale Sale

Save 10% on select Puffco devices & 20% on select accessories

Applies to eligible Puffco products only. Not all Puffco items are included. Eligible Puffco items only.

Shop Puffco Sale

7" Colored Glass Striped Standing Sherlock Pipe – P3148

MSRP: $38.99
Wholesale: $8.95
You save $30.04
SKU:
P3148
In Stock & Ready To Ship!
Current Stock:Only left: 29

Frequently Bought Together:

Total: Inc. Tax
Total: Ex. Tax

Description

Why Retailers Stock It: Upright sherlocks are easy to merchandise and even easier to sell. This 7" colored-glass standing sherlock pairs a classic curved stem with thin white stripe work and glass rings, giving you a compact counter piece that looks premium without the premium price. The upright base makes it simple to face on shelves or nest in a small tray by the register, where it reliably converts impulse shoppers.

MSRP $34.99–$38.99 per unit

Key Features & Specs

  • Style: Standing sherlock hand pipe with glass ring accents
  • Look: Colored glass with thin white stripe design; colors may vary
  • Approx. Size & Weight: 7" • ~95 g
  • Category: Glass Pipes → Sherlock
  • Purchase Options: 1 Count • Bundle of 2
  • SKU: P3148

Wholesale Perks

  • Counter-friendly footprint that stands on its own—easy to face multiples
  • Fast shipping from our CA warehouse • $100 order minimum
  • Steady margins on everyday head-shop supplies

Merchandising Tips

  • Group three to five units by hue (note “colors may vary” on the shelf tag) to spark quick decisions.
  • Position near pipe screens, lighters, and pocket cleaners to lift average ticket.
  • Use the Bundle of 2 option for a small color assortment that refreshes fast.

Care

  • Rinse after use; for periodic deep cleaning, a specialty glass solution such as Formula 420 keeps the bore clear and the finish glossy.

Stock up today and keep your shelves ready for demand.

Extra Information

Size:
7"
Weight:
95g
Style:
Sherlock

Shipping & Delivery

Shipping & Delivery

ETA: Most orders arrive in 3–8 business days (business days only)
Processing: Ships in 2 business days or less from CA
Free Ship: $750+ on eligible items (AK/HI, COD, expedited & excluded items/brands excluded)
UPS Ground time-in-transit map from California origin
Guide only. Transit times are business days and not guaranteed; holidays and weather can add time.
Where & how we ship

UPS Ground to the 50 U.S. states. Orders typically leave our CA warehouse within 2 business days or less.

Rates & thresholds
  • Orders $750+ qualify for free UPS Ground on eligible items within the contiguous U.S. (AK/HI, COD, expedited services, and excluded items/brands are not eligible).
  • Mixed carts: If your order contains excluded items/brands, free shipping may still apply to eligible items, but shipping charges will apply to excluded items as shown in cart/checkout.
  • Under $750: weight-based rates shown in cart/checkout.
  • Expedited options (when available) are offered at checkout but are not eligible for free shipping.
  • UPS rounds up to the next full pound.
  • See full Free Shipping & Sale Info for exclusions and any limited-time sale details.
Returns & claims
  • 30-Day Returns: New/unused. We cover return freight if it was our mistake; restocking may apply over $500 or for careless repack.
  • Damages: Report within 14 days of delivery with photos, your invoice #, and the product code to claims@spswholesale.com.
  • Missing/Pack errors: Tell us within 2 days of delivery; we record pack-out video to resolve quickly.
Peak-season planning

See our current Holiday Order-By Dates & UPS Transit Map.

Quick Answers

Do I have to be a business to order?

Yes. We sell wholesale to businesses. A tax ID / reseller permit may be required in certain states.

Do you offer drop-shipping?

Yes. We support drop-ship fulfillment through our dropshipping program (powered by Crowdship), so orders can ship directly from our warehouse to your customers. Learn how our dropshipping program works.

Do you ship internationally?

Not directly. We currently ship UPS Ground within the 50 U.S. states.

Why am I seeing shipping charges on a $750+ order?

Some items/brands are excluded from free shipping due to carrier and handling costs. If your order contains excluded items, free shipping may still apply to eligible items, but shipping charges will apply to excluded items as shown at checkout.

Estimates are based on typical handling times and UPS Ground guidance. Transit is measured in business days and is not guaranteed. Check carrier holiday schedules for non-operational days.