What you send
The file as it arrived
- Ordered item
- CUP-2
- How many
- 6
Sepky / Customer orders
CSV
Clean a customer order export
A shop export names the ordered item one way and the quantity another. Sepky turns that export into sku and quantity so the orders can be picked without a manual pass.
What you get back
The columns you saved
- sku
- CUP-2
- quantity
- 6
Column names
In the file
Ordered itemHow many
In the result
skuquantity
How this file is cleaned
- Set sku as text and quantity as a number. Those are the picking columns.
- Send the order export. Ordered item and How many are the incoming headers.
- Pick from the cleaned file. The result is saved in History as well as returned.
Questions
- Do I change the file before sending it? The export is sent on the schedule you already run.
- Which columns come back? The cleaned file uses sku, quantity.
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.