From Offline Shelves to Online Signals
Pricing, discounts, vendors, and inventory behavior in a Shopify-based marketplace
This project analyzes sample product data from a Shopify Partner development store to understand how pricing, discounting, vendor behavior, and inventory risk interact when offline retail businesses move into an online marketplace.
The dataset is interpreted as a simulated digital marketplace, allowing structural risks to be identified before real customers are exposed.
Retail digitization often introduces new challenges instead of eliminating old ones:
- Inconsistent pricing across categories
- Reactive discounting
- Inventory accumulation
- Vendor-driven competitive pressure
Key Question
How do pricing, discounts, vendors, and inventory signals interact when products are onboarded into Shopify using standardized CSVs?
- Shopify Partner Sample Product CSVs
https://github.com/shopifypartners/product-csvs or Data Folder
Core Fields
price · compare_at_price · discount · inventory · vendor · category · product_type
Data is simulated onboarding data (no real sales or customers).
Method Notes
- Median Absolute Deviation (MAD) controls price outliers
- Extreme prices treated as strategic exceptions
- Focus on structural signals, not prediction
| Focus Area | Purpose | Figures |
|---|---|---|
| Category & Vendor Mix | Competition & dependency | Fig 1–2 |
| Price Behavior | Signal vs noise | Fig 3–4 |
| Price Tiers | Value positioning | Fig 5 |
| Discounts | Competitive pressure | Fig 6–9 |
| Vendors | Strategic discipline | Fig 10–13 |
| Inventory | Hidden price driver | Fig 14 |
- Price is a signal, not just a number
- Discounts indicate pressure, not generosity
- Inventory risk drives discounting
- Vendor discipline shapes perceived value
- Positioning matters more than volume
- No demand, conversion, or seasonality data
- Patterns reflect onboarding assumptions
- Insights are directional, not causal
- Shopify Partner CSVs https://github.com/shopifypartners/product-csvs
- E-commerce Data Engineering https://www.kaggle.com/code/autowired/part-1-e-commerce-behavioral-data-engineering
- Data Storytelling Best Practices https://www.thoughtspot.com/data-trends/best-practices/data-storytelling
By: Bhanu Pratap Singh