csv5.4 KB
Alder Table Bistro: Supplier price list CSV
Supplier price list CSV for Alder Table Bistro. 48 rows covering 2 suppliers, 6 items and 4 effective dates (2026-08-05, 2026-08-12, 2026-08-19, 2026-08-26). Each row carries the list unit price, the case pack quantity, the price per case and a contract tier price that applies only at 250 units. Every purchase order line in this set is priced from the row matching its supplier, item and order date.
Preview, first 50 linescsv
supplier_id,supplier_name,supplier_item_code,gtin,ingredient_id,description,uom,uom_code,effective_from,list_unit_price,currency,case_pack_quantity,price_per_case,contract_tier_min_quantity,contract_tier_unit_price
SUP-01,Alder Wholesale,AW-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-05,10.75,CAD,10,107.50,250,10.32
SUP-01,Alder Wholesale,AW-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-12,10.93,CAD,10,109.30,250,10.49
SUP-01,Alder Wholesale,AW-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-19,11.12,CAD,10,111.20,250,10.68
SUP-01,Alder Wholesale,AW-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-26,11.30,CAD,10,113.00,250,10.85
SUP-01,Alder Wholesale,AW-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-05,3.08,CAD,10,30.80,250,2.96
SUP-01,Alder Wholesale,AW-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-12,3.05,CAD,10,30.50,250,2.93
SUP-01,Alder Wholesale,AW-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-19,3.01,CAD,10,30.10,250,2.89
SUP-01,Alder Wholesale,AW-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-26,2.97,CAD,10,29.70,250,2.85
SUP-01,Alder Wholesale,AW-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-05,1.80,CAD,10,18.00,250,1.73
SUP-01,Alder Wholesale,AW-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-12,1.80,CAD,10,18.00,250,1.73
SUP-01,Alder Wholesale,AW-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-19,1.80,CAD,10,18.00,250,1.73
SUP-01,Alder Wholesale,AW-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-26,1.80,CAD,10,18.00,250,1.73
SUP-01,Alder Wholesale,AW-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-05,5.69,CAD,12,68.28,250,5.46
SUP-01,Alder Wholesale,AW-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-12,5.79,CAD,12,69.48,250,5.56
SUP-01,Alder Wholesale,AW-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-19,5.89,CAD,12,70.68,250,5.65
SUP-01,Alder Wholesale,AW-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-26,5.98,CAD,12,71.76,250,5.74
SUP-01,Alder Wholesale,AW-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-05,5.78,CAD,10,57.80,250,5.55
SUP-01,Alder Wholesale,AW-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-12,5.71,CAD,10,57.10,250,5.48
SUP-01,Alder Wholesale,AW-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-19,5.64,CAD,10,56.40,250,5.41
SUP-01,Alder Wholesale,AW-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-26,5.57,CAD,10,55.70,250,5.35
SUP-01,Alder Wholesale,AW-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-05,8.20,CAD,12,98.40,250,7.87
SUP-01,Alder Wholesale,AW-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-12,8.20,CAD,12,98.40,250,7.87
SUP-01,Alder Wholesale,AW-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-19,8.20,CAD,12,98.40,250,7.87
SUP-01,Alder Wholesale,AW-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-26,8.20,CAD,12,98.40,250,7.87
SUP-02,Harbour Food Supply,HF-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-05,10.00,CAD,10,100.00,250,9.60
SUP-02,Harbour Food Supply,HF-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-12,10.17,CAD,10,101.70,250,9.76
SUP-02,Harbour Food Supply,HF-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-19,10.34,CAD,10,103.40,250,9.93
SUP-02,Harbour Food Supply,HF-ING-01,0614141001000,ING-01,Chicken Breast,kg,KGM,2026-08-26,10.51,CAD,10,105.10,250,10.09
SUP-02,Harbour Food Supply,HF-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-05,2.93,CAD,10,29.30,250,2.81
SUP-02,Harbour Food Supply,HF-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-12,2.89,CAD,10,28.90,250,2.77
SUP-02,Harbour Food Supply,HF-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-19,2.86,CAD,10,28.60,250,2.75
SUP-02,Harbour Food Supply,HF-ING-02,0614141002000,ING-02,Tomatoes,kg,KGM,2026-08-26,2.82,CAD,10,28.20,250,2.71
SUP-02,Harbour Food Supply,HF-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-05,1.67,CAD,10,16.70,250,1.60
SUP-02,Harbour Food Supply,HF-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-12,1.67,CAD,10,16.70,250,1.60
SUP-02,Harbour Food Supply,HF-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-19,1.67,CAD,10,16.70,250,1.60
SUP-02,Harbour Food Supply,HF-ING-03,0614141003000,ING-03,Potatoes,kg,KGM,2026-08-26,1.67,CAD,10,16.70,250,1.60
SUP-02,Harbour Food Supply,HF-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-05,5.41,CAD,12,64.92,250,5.19
SUP-02,Harbour Food Supply,HF-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-12,5.50,CAD,12,66.00,250,5.28
SUP-02,Harbour Food Supply,HF-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-19,5.59,CAD,12,67.08,250,5.37
SUP-02,Harbour Food Supply,HF-ING-04,0614141004000,ING-04,Cream,l,LTR,2026-08-26,5.68,CAD,12,68.16,250,5.45
SUP-02,Harbour Food Supply,HF-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-05,5.38,CAD,10,53.80,250,5.16
SUP-02,Harbour Food Supply,HF-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-12,5.31,CAD,10,53.10,250,5.10
SUP-02,Harbour Food Supply,HF-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-19,5.25,CAD,10,52.50,250,5.04
SUP-02,Harbour Food Supply,HF-ING-05,0614141005000,ING-05,Mixed Greens,kg,KGM,2026-08-26,5.18,CAD,10,51.80,250,4.97
SUP-02,Harbour Food Supply,HF-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-05,7.79,CAD,12,93.48,250,7.48
SUP-02,Harbour Food Supply,HF-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-12,7.79,CAD,12,93.48,250,7.48
SUP-02,Harbour Food Supply,HF-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-19,7.79,CAD,12,93.48,250,7.48
SUP-02,Harbour Food Supply,HF-ING-06,0614141006000,ING-06,Olive Oil,l,LTR,2026-08-26,7.79,CAD,12,93.48,250,7.48
Specifications
- Kit
- restaurant-bistro
- Schema Version
- 1
- Synthetic
- true
- As Of
- 2026-09-08
- Currency
- CAD
- Tax Name
- GST
- Tax Rate
- 0.05
- Rows
- 48
- Columns
- 15
- Delimiter
- comma
- Encoding
- UTF-8
- Byte Order Mark
- false
- Line Endings
- LF
- Decimal Separator
- .
Testing contract
Expected to pass- Scenario
- Read supplier price list csv into a procure-to-pay import, three-way match and reconciliation workflow for Alder Table Bistro.
- Expected result
- 48 rows covering 2 suppliers, 6 items and 4 effective dates (2026-08-05, 2026-08-12, 2026-08-19, 2026-08-26). Each row carries the list unit price, the case pack quantity, the price per case and a contract tier price that applies only at 250 units. Every purchase order line in this set is priced from the row matching its supplier, item and order date.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Alder Table Bistro: Supplier price list CSV” is a deterministic Testaroo fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 48 rows · 15 columns · UTF-8 · LF. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("price-list.csv")
print(df.head())
print(df.dtypes)Generated by generation/restaurant_procurement.py. Free for any use, no attribution required, license.
Related files
- csvAlder Table Bistro: Credit note lines CSVCredit note lines CSV for Alder Table Bistro. 2 credit lines, one per note. CN-BST-7001 credits 4 units for the short delivery and agrees with the goods-received note. CN-BST-7002 credits 5 units where GRN-BST-2004 records only 3 returned, an overstatement of 15.58 CAD net.
- csvAlder Table Bistro: Goods-received note lines CSVGoods-received note lines CSV for Alder Table Bistro. 12 received lines across 4 goods-received notes. Three lines are exceptions: a short delivery of 4 units on GRN-BST-2002, an item substitution on GRN-BST-2003 where the delivered ingredient id differs from the ordered one, and a part return of 3 units on GRN-BST-2004. accepted_quantity equals delivered_quantity minus returned_quantity on every row.
- csvAlder Table Bistro: Purchase order lines CSVPurchase order lines CSV for Alder Table Bistro. 12 lines across 4 purchase orders dated 2026-08-05 to 2026-08-26. Each line repeats its order's net, tax and gross totals, so a reader can check that the line values sum to the header without a second file. Order PO-BST-1002 totals 329.53 CAD including GST.
- csvAlder Table Bistro: Remittance advice lines CSVRemittance advice lines CSV for Alder Table Bistro. 13 lines, one for every document on both statements, each marked paid or withheld with a reason. 1120.68 CAD is settled and 1765.18 CAD is withheld against statement balances of 2885.86 CAD; the first two figures sum to the third.
- csvAlder Table Bistro: Statements of account CSVStatements of account CSV for Alder Table Bistro. 13 transaction rows across 2 month-end statements dated 2026-08-31. STM-BST-6001 closes at 1326.11 CAD and its four declared ageing buckets sum to exactly that. STM-BST-6002 closes at 1559.75 CAD while its declared buckets sum to 1566.76 CAD.
- csvAlder Table Bistro: Supplier invoice lines CSVSupplier invoice lines CSV for Alder Table Bistro. 14 lines across 5 invoice documents that carry only 4 distinct invoice numbers: INV-BST-5002 appears twice, dated 2026-08-14 and 2026-08-17. invoice_number is therefore not a key; the pair of invoice_number and invoice_date is. invoice_stated_tax_total is the figure printed on the document, which for INV-BST-5003 is one cent above the sum of its line tax amounts.
