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

6" Swirl Striped Glass Sherlock Pipe – P3149

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

Frequently Bought Together:

Total: Inc. Tax
Total: Ex. Tax

Description

Why Shops Love It: Classic sherlock shape with bright swirl striping—this 6-inch hand pipe is a quick converter in any case. The body comes in clear or color-changing fumed glass with a colored bowl, giving customers a premium look at an everyday price point. Stock singles for fast top-offs, or add the 2-piece bundle to expand color variety and protect margins.

MSRP $34.99–$38.99 per unit

  • Style & Size: Glass sherlock hand pipe • approx. 6"
  • Construction: Clear or color-changing (fumed) glass with colored bowl
  • Design Details: Spiral/swirl striped stem • assorted colors; each piece varies
  • Approx. Weight: ~110 g per unit
  • Quantity Options: 1 Count • Bundle of 2
  • Category Fit: Head-shop essentials • reliable retail smoke gear

Wholesale Perks:

  • Shelf-ready presentation that pops under case lighting
  • Fast California shipping on in-stock items
  • $100 order minimum makes quick restocks simple

Merchandising Tips: Unwrap and polish before display for maximum shine. Create a small “Sherlocks Under $40” row and cross-sell pipe screens and pocket-size cleaner at checkout to boost attachment.

Care: For best results, clean regularly with isopropyl alcohol and coarse salt, or use a specialty glass cleaner such as Formula 420 to maintain clarity and flavor.

Hand-worked glass means minor variations in color and pattern are normal. Stock up today and keep your shelves ready for demand.

Extra Information

Size:
6"
Weight:
110g
Style:
Sherlock
Features:
Color Changing

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.