What you send
The file as it arrived
- Qty
- 4
- Line £
- £36,00
Sepky / Order file
CSV
Clean an order file from CSV
Order exports put the quantity in a column called Qty and the line value in a column with a currency sign. Sepky returns quantity and line price as numbers your order system can take.
What you get back
The columns you saved
- quantity
- 4
- line_price
- 36.00
Column names
In the file
QtyLine £
In the result
quantityline_price
How this file is cleaned
- Set quantity and line_price as numbers. Both cells become plain values.
- Send the order CSV. Qty and Line £ are the incoming names.
- Load the cleaned lines. Each send is also kept in History as a file.
Questions
- Do I change the file before sending it? The buyer's export is sent as it was downloaded.
- Which columns come back? The cleaned file uses quantity, line_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.