Do I change the file before sending it?

You do not split the file by currency before sending it.

Which columns come back?

The cleaned file uses title, price.

Sepky / Mixed currencies

CSV

Clean a catalog that mixes currencies

One catalog can price a row in dollars, the next in euros, and a third in pounds. Sepky strips the symbol from each cell and returns a number, with the title trimmed beside it.

What you send

The file as it arrived

Style: Merino scarf
List: €42,00

What you get back

The columns you saved

title: Merino scarf
price: 42.00

Column names

In the file

StyleList

In the result

titleprice

How this file is cleaned

Save title as text and price as a number. The number rule applies to $, €, and £.
Send the whole catalog. Style and List are matched from the first row.
Use one cleaned file. Every row comes back in those two columns.

Questions

Do I change the file before sending it? You do not split the file by currency before sending it.
Which columns come back? The cleaned file uses title, price.

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