How Pricestock Works

A complete guide to understanding what Pricestock can and cannot do for your business

What Pricestock Does

Pricestock transforms your Google Sheets into automated product intelligence systems. You provide product URLs, we collect real-time data, and you receive enriched export files ready for any platform.

Import

Google Sheets

Enrich

Real-time data

Export

Ready-to-use files

Step-by-Step Process

1

Connect Your Google Sheet

Required Setup

  • Create a Google Sheet with a column named "url"
  • Fill the "url" column with product page links (Amazon, Shopify, etc.)
  • Share the sheet with us (view access is sufficient)

Optional Enhancements

  • Add a "variation" column for product variants (works with Bed Bath & Beyond and Shopify)
  • Include any custom columns (SKU, category, your cost, etc.) - these pass through to your export

Example Sheet Structure:

url sku my_cost category
amazon.com/dp/B08N5WRWNW ECHO-001 25.00 Electronics
shopify-store.com/products/widget WDG-123 15.50 Home
2

Automatic Data Enrichment

What We Collect

Price Information
  • • Current selling price
  • • Sale/discounted price (if applicable)
  • • Original/MSRP price
  • • Is on sale flag
Availability Data
  • • In stock / out of stock status
  • • Quantity available (when shown)
  • • Number of days out of stock
Product Details
  • • Product title/name
  • • Brand information (when available)
Shipping Info
  • • Shipping costs
  • • Delivery timeframes
3

Custom Export Configuration

Export Customization Options

Column Selection & Mapping
  • • Choose which original columns to include
  • • Select which enriched data fields to add
  • • Rename columns to match your system requirements
  • • Reorder columns for optimal workflow
Data Transformation
  • • Apply markup formulas (e.g., competitor_price * 0.95)
  • • Set default values for missing data
File Format & Delivery
  • • CSV files (universal compatibility)
  • • Tab-delimited text files
  • • Custom delimiters for specialized systems

What Pricestock CAN Do

Data Sources

  • ✅ Amazon (all marketplaces)
  • ✅ Shopify stores
  • ✅ Home Depot
  • ✅ Zoro Industrial
  • ✅ Bed Bath & Beyond
  • ✅ Most major ecommerce platforms
  • ✅ Custom retailer websites
  • ✅ Manufacturer direct sites

Data Management

  • ✅ Real-time data synchronization
  • ✅ Flexible update schedules
  • ✅ Automatic sheet monitoring
  • ✅ Add/remove products anytime
  • ✅ Error handling & notifications
  • ✅ Data validation & cleaning
  • ✅ Custom business logic

Export Capabilities

  • ✅ Marketplace feed files
  • ✅ ERP system imports
  • 🚧 Custom database formats (in progress)
  • 🚧 API-ready JSON/XML (in progress)
  • 🚧 Automated FTP delivery (in progress)
  • 🚧 Email attachments (in progress)

Use Cases

  • ✅ Competitive price monitoring
  • ✅ Inventory availability tracking
  • ✅ Market research & analysis
  • ✅ Dynamic pricing strategies
  • ✅ Supplier price comparison
  • ✅ Product catalog updates
  • ✅ Cross-channel synchronization
  • ✅ Bulk pricing operations
  • 🚧 N8n integration (in progress)

What Pricestock CANNOT Do

Data Limitations

  • ❌ Internal inventory systems
  • ❌ Private cost data
  • ❌ Login-protected content
  • ❌ Contract pricing terms
  • ❌ Historical sales data
  • ❌ Customer reviews/ratings
  • ❌ Search ranking data
  • ❌ Traffic/analytics data

Business Functions

  • ❌ Automatic price adjustments
  • ❌ Inventory management
  • ❌ Order processing
  • ❌ Customer communications
  • ❌ Payment processing
  • ❌ Shipping coordination
  • ❌ Tax calculations
  • ❌ Compliance monitoring

Important Considerations

Update Frequency & Reliability

  • Hourly: Recommended for price-sensitive markets
  • Daily: Most cost-effective for general monitoring
  • Custom intervals: Weekly, bi-weekly, or monthly options available
  • Reliability: 99%+ uptime, but depends on target site availability
  • Failures: Automatic retries, with notifications for persistent issues

Data Accuracy & Legal Compliance

  • • We collect only publicly available information
  • • Data accuracy depends on source website structure
  • • Some sites may block or limit automated access
  • • Users are responsible for compliance with terms of service
  • • We respect robots.txt and rate limiting

Setup & Maintenance Requirements

  • Initial setup: 1-2 business days after receiving your requirements
  • Testing period: 1 week to ensure data accuracy and format compatibility
  • Ongoing maintenance: Minimal - we handle site changes and technical issues
  • Your involvement: Update your Google Sheet as needed, review export formats
  • Support: Email support with 24-hour response time

Ready to Get Started?

What We Need From You

Required Information

  • 📋 Google Sheet URL with product URLs
  • 🎯 List of target websites/retailers
  • ⏰ Desired update frequency
  • 📤 Export format preferences
  • 🔄 Delivery method (email, FTP, etc.)

Optional Enhancements

  • 🧮 Custom pricing formulas
  • 🏷️ Column renaming requirements
  • 📊 Specific data fields needed
  • 🔗 Integration requirements
  • 📈 Reporting preferences
Contact Us to Get Started

We'll respond within 24 hours with a custom setup plan and pricing