How Pricestock Works - Complete Guide

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

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