Sepky / Supplier price list

CSV

Clean a supplier price list from CSV

A supplier CSV rarely arrives with your column names. Prices show up as $249,99 or €12,50, and product codes carry stray spaces. Sepky maps that file onto the columns you saved and returns a clean CSV.

What you send

The file as it arrived

Item Code
HX-440
Net Price
$249,99

What you get back

The columns you saved

sku
HX-440
price
249.99

Column names

In the file

Item CodeNet Price

In the result

skuprice

How this file is cleaned

  1. Keep their headers. Item Code and Net Price stay as the supplier wrote them.
  2. Set your columns once. sku is text. price is a number. That choice is saved on the account.
  3. Send the CSV. The cleaned rows come back, and the same file is saved in History.

Questions

  • Do I change the file before sending it? You keep the vendor's headers. You do not rebuild the sheet before sending 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.

Get started