What you send
The file as it arrived
- Order qty
- 240
- Unit cost
- €1,25
Sepky / Purchase order
Excel
Clean a purchase order from Excel
Purchase orders arrive from buyers as spreadsheets with a quantity and a unit cost in whatever format that buyer uses. Sepky returns quantity and unit cost ready for the order you are raising.
What you get back
The columns you saved
- quantity
- 240
- unit_price
- 1.25
Column names
In the file
Order qtyUnit cost
In the result
quantityunit_price
How this file is cleaned
- Set quantity and unit_price as numbers. The euro amount becomes 1.25.
- Attach the purchase order. Order qty and Unit cost map from the first row.
- Raise the order from the result. Download the cleaned sheet from History.
Questions
- Do I change the file before sending it? The buyer's sheet is the input. Your columns are already saved.
- Which columns come back? The cleaned file uses quantity, unit_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.