Price Lists

This dataset provides a comprehensive record of product pricing, including historical price changes, discount tiers, promotional offers, effective dates, and currency codes. It enables detailed tracking and management of pricing strategies, supports multi-currency operations, and facilitates analysis of promotions and discount effectiveness over time.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Dynamic pricing and discount strategy analysis

Sample rows

preview · 8 of 200 rows · all 14 columns
price_list_idstringcurrency_codestringdiscount_percentagefloatis_activebooleanproduct_idstringproduct_namestringbase_pricefloatdiscount_tierintegerpromotional_pricefloatpromotion_descriptionstringeffective_start_datedateeffective_end_datedatelast_updateddatetimeprice_history_referencestring
PL1001USD10falseP001Eco Widget19.99117.99Spring Sale Promo2024-05-012024-06-302024-07-01T08:01:12blank
PL1002USD3.5trueP002Ultra Widget12000311580Executive Rate2024-03-012024-12-312024-06-30T10:24:55blank
PL1003USD15trueP003Pro Widget249.992212.49Back to School2024-07-152024-08-152024-07-16T09:45:28blank
PL1004EURblankfalseP004Legacy Widget99blankblankblank2022-01-012022-12-312022-12-31T16:55:00blank
PL1005USD0falseP005Nano Widget9.991blankblank2024-06-012024-06-302024-07-01T12:00:00blank
PL1006USD20falseP006Sonic Widget4992399.2Flash Event Discount2024-07-102024-07-122024-07-13T08:33:02blank
PL1007USD15trueP001Eco Widget19.99116.99Summer Sale2024-07-012024-08-012024-07-01T08:10:00PL1001
PL1008USD25falseP007Prime Widget129.99297.49Prime Day Deal2024-07-152024-07-162024-07-16T22:00:00blank

What the 200 rows show

from the 200-row sample
  • 55%is_active = true
  • 10.0median discount_percentage
  • 135.0median base_price
  • 2median discount_tier
  • 197.3median promotional_price
currency_code200 rows by value
075150143USD72%57EUR28%
discount_percentage164 rows, in bands of 10
035706657310040006050100discount_percentage →

Median 10.0, from 0.0 to 100.0.

14 columns by typefrom the column list below
  • string 6
  • integer 1
  • float 3
  • date 2
  • datetime 1
  • boolean 1

Columns

14 columns in four groups
blueprint · 14 columns
columntypedescriptionexample
Text 6 columns
price_list_idstringUnique identifier for the price list entryuniquePL1001
product_idstringUnique identifier for the productP001
product_namestringName of the productEco Widget
currency_codestringISO 4217 currency code for the price (e.g., USD, EUR)2 codesUSD
promotion_descriptionstringDescription of the promotion or campaignoptionalSpring Sale Promo
price_history_referencestringReference ID to previous price list entry for historical trackingoptionalPL1001
Numbers 4 columns
base_pricefloatStandard price of the product before discounts or promotions0 or more19.99
discount_tierintegerDiscount tier level (e.g., 1 for standard, 2 for premium, etc.)1 or more · optional1
discount_percentagefloatDiscount percentage applied to the base price for the tier0 to 100 · optional10
promotional_pricefloatTemporary promotional price for the product, if applicable0 or more · optional17.99
Dates and times 3 columns
effective_start_datedateDate when the price or promotion becomes effective2024-05-01
effective_end_datedateDate when the price or promotion endsoptional2024-06-30
last_updateddatetimeTimestamp of the last update to this price entry2024-07-01T08:01:12
True or false 1 column
is_activebooleanIndicates if the price entry is currently activefalse

Use it for

  • is active55%109 of 200 rowsmean discount percent…15.5USD13.5EUR

    An e-commerce dashboard

    The is_active rate and discount_percentage by currency_code. Excel, Power BI or Tableau.

  • Why do 109 of 200 rows have is_active = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable price lists with product_id, product_name and base_price to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows14 columns
Yours1,000 rows14 columns

blueprint · price-lists

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Base price before any discounts
  • Effective date range for pricing
  • Volume discounts at quantity thresholds
  • Currency code follows ISO standard
  • Price change history maintained
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
price-lists

More in E-commerce

Browse all
Also in E-commerceE-Commerce Packaging Compliance TrackerE-Commerce Session Conversion DataOnline Retail Product Return AnalyticsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.