What you send
The file as it arrived
- Product__Name
- Brass hook
- Cost_USD
- $18,00
Sepky / Column names
CSV
Map supplier column names to yours
The same price arrives as Net, Trade, Cost_USD, or Price (GBP), depending on who sent the file. Sepky looks at the headers you received and returns the columns you named.
What you get back
The columns you saved
- title
- Brass hook
- price
- 18.00
Column names
In the file
Product__NameCost_USD
In the result
titleprice
How this file is cleaned
- Name the columns you want back. title and price live on the account, not in the file.
- Send the supplier headers as they are. The first row is matched. Later rows reuse that match.
- Take your column names. The cleaned CSV uses title and price.
Questions
- Do I change the file before sending it? You do not edit the header row to match your system before each send.
- Which columns come back? The cleaned file uses title, 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.