Sepky Get started

Sepky / Inventory file

CSV

Clean an inventory file from CSV

Stock files mix a location code, a SKU with padding spaces, and a count with extra spaces. Sepky returns the code and the count your inventory list expects.

What you send

The file as it arrived

Bin SKU
A1-09
On hand
18

What you get back

The columns you saved

sku
A1-09
quantity
18

Column names

In the file

Bin SKUOn hand

In the result

skuquantity

How this file is cleaned

  1. Set sku as text and quantity as a number. The count is read as a number.
  2. Send the inventory CSV. Bin SKU and On hand are the source headers.
  3. Load the cleaned counts. The result is also stored in History as a file.

Questions

  • Do I change the file before sending it? The warehouse export is sent unchanged.
  • Which columns come back? The cleaned file uses sku, quantity.

Related files

Clean a stock count spreadsheetClean SKU and price columns in ExcelMap supplier column names automatically

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