Sample Products CSV File — Free Download
A product catalog with prices, costs, stock levels, SKUs and ratings — enough structure to compute margins, flag low stock and test an e-commerce or PIM import.
Download the sample file
CSV · 160 rows · 11.0 KB · synthetic data, free for any use
Download CSV samplePreview
| product_id | name | category | price | cost | stock | sku | rating |
|---|---|---|---|---|---|---|---|
| PRD-0001 | Webcam 1080p Lite | Peripherals | 248.77 | 156.73 | 310 | SKU-74914 | 3.3 |
| PRD-0002 | Cable Organizer Mini | Peripherals | 570.24 | 245.20 | 13 | SKU-19201 | 5.0 |
| PRD-0003 | USB-C Hub | Accessories | 816.08 | 538.61 | 299 | SKU-15726 | 3.3 |
| PRD-0004 | Ergonomic Chair V2 | Electronics | 799.11 | 543.39 | 33 | SKU-64435 | 3.1 |
| PRD-0005 | Mechanical Keyboard V2 | Storage | 701.74 | 371.92 | 94 | SKU-70797 | 4.5 |
| PRD-0006 | 27-inch Monitor | Furniture | 305.75 | 137.59 | 376 | SKU-89874 | 4.9 |
Showing the first 6 of 160 rows.
Columns
| Column | Type | Description |
|---|---|---|
product_id | string | Primary key, PRD-0001… |
name | string | Product name with a variant suffix |
category | string | 5 categories |
price | decimal | Retail price, USD |
cost | decimal | Unit cost, USD (35–70% of price) |
stock | integer | Units on hand (0–500) |
sku | string | SKU code |
rating | decimal | Average rating, 2.8–5.0 |
What makes this file useful
- cost is always a fraction of price, so margin math produces sensible positive numbers you can verify.
- Some rows have stock = 0, which is the case you want when testing out-of-stock handling and filters.
- name deliberately contains near-duplicates (e.g. "Laptop Stand Pro" vs "Laptop Stand") for fuzzy-matching practice.
Use cases
- Compute gross margin as (price − cost) / price
- Flag products with stock below a reorder threshold
- Test a Shopify / WooCommerce product import
- Rank categories by average rating or total inventory value
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
Do the SKUs follow a real standard?
No. SKUs are random SKU-##### codes, unique within the file but not tied to any real product identifier system like GTIN or UPC.
Can I import this into Shopify?
It is not in Shopify's exact column format, but it is a good file for practising the mapping and transformation step before importing your own catalog.
Are prices realistic?
They are plausible for desk / peripheral products but randomly generated, not scraped from any store.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.