Solutions · By industry
Supplier files in, correct prices and products online.
A common webshop problem: hundreds of vendors, each with its own price spreadsheet. StencilFlow finds the table by pattern recognition, a person confirms the mapping once per vendor, new prices are calculated from your discount, margin and rounding tables and compared with what is live in the shop. You get a file with only the changed fields to upload.
What lands in the inbox
- Supplier price lists
- Product feeds
- Shop exports
Read, checked against your data and handed off, with people deciding the exceptions.
The flow
From inbox to system, step by step
Every case follows the same visible path. Where a rule cannot decide, a person does.
- Mailbox
- Find table
- Confirm
- Compare to shop
- Calculate
- Upload file
Step by step
How it runs, step by step
A worked example with made-up names. Rules do the checking; people decide what the rules cannot.
- 1
Hundreds of vendors, hundreds of layouts
A common webshop problem: every vendor sends prices in its own spreadsheet, and the layout changes again.
XLSXAcme ToysXLSXBirchwood GamesCSVCobalt CraftsXLSXMulti-sheet workbook - 2
Find the table by pattern recognition
The engine reads layout and column meaning, not a fixed template: header row, names in several languages and the values themselves.
Birchwood Games price list
Autumn list · valid from 1 September
BarcodePrix htAdviesprijs871234500005012.0029.99871234500006724.5054.99Totals and terms, left out
- 3
One person confirms, once per vendor
The proposed mapping is shown with sample values. After the confirm, the vendor's naming is remembered and their next file maps itself.
Remembered: Birchwood Games
- BarcodeEAN
- Prix htCost
- AdviesprijsRRP
Maps itselfXLSXBirchwood Games, next list - 4
Compare with what is live
The shop's daily product export is the reference. Each vendor row is matched by EAN, then SKU.
New from vendor
- EAN8712345000050
- List price12.00
Live in the shop
- EAN8712345000050
- List price11.00
- 5
Pricing rules your team owns
Vendor discount, brand margin per price band, rounding ladder. Pinned prices are honoured; a gap goes to a person, never a guess.
Vendor discount
- Birchwood Games: 8%
- Acme Toys: 10%
Brand margin by band
- Up to 25: x 2.2
- 25 to 60: x 1.9
Rounding ladder
- Ends in .99
Pinned prices
- Honoured as set
No margin rule for Cobalt Craftsgoes to a person, never a guess - 6
Calculate the new price
Example with made-up numbers: discount, then margin for the band, then rounding.
Worked example
- List price40.00
- Vendor discount 8%36.80 cost
- Margin factor 1.969.92
- Rounded to ladder69.99
Margin limits and big cost jumps are checked too.
- 7
Only what changed, ready to upload
A bulk-upload file with only the changed fields, a review file and a summary email. A person uploads; nothing goes live silently.
- Shop upload fileOnly changed fields of ready rows
- Review fileFlagged and new products with reasons
- Summary emailTo the buyers
Before and after
Retail & e-commerce, with and without StencilFlow
Today
- Spreadsheet gymnastics before every price update
- Margin errors discovered by customers
- New products slow to go online
With StencilFlow
- Price lists mapped by pattern recognition, confirmed once per vendor
- Margin rules per brand and price band applied on every row; gaps go to a person
- A bulk-upload file with only the changes; a person uploads it
Rules
Checks that run on every case
Your rules and reference data, applied the same way every time. Each outcome records which check passed or failed.
- Margin per brand and price band
- Margin limits and cost jumps
- Product matched by EAN, then SKU
Connects to
Hands off to the systems you run
- Shopify
- Matrixify
- ERP
Through an API, an import file or a mailbox. About actions and integrations
In practice
About 19,500 supplier price-list rows checked for margin against the shop in about 12 seconds.
Ready to look at your inbox?
Bring one process and a handful of real documents. We show you the path from inbox to decision, on your own data.