What you send
The file as it arrived
- Trade code
- BK-220
- Net
- €48,50
Sepky / Wholesale price book
Excel
Clean a wholesale price book
A wholesale price book is a long sheet of trade codes and net prices, often updated every week by a different person. Sepky turns that sheet into sku and price without a fresh mapping each time the file arrives.
What you get back
The columns you saved
- sku
- BK-220
- price
- 48.50
Column names
In the file
Trade codeNet
In the result
skuprice
How this file is cleaned
- Save sku and price once. The price book always comes back in that shape.
- Attach this week's workbook. Trade code and Net are recognized from the first row.
- Replace last week's file. The new cleaned workbook is in History.
Questions
- Do I change the file before sending it? The first workbook teaches the column match. The next week's file reuses it.
- Which columns come back? The cleaned file uses sku, price.
Related files
Clean this file in Sepky
1,000 lines are free. $100 a month covers 50,000 lines, saved columns, file upload, code send, and History. The original file is not kept.