What you send
The file as it arrived
- Counted item
- PLT-8
- Physical
- 1,200
Sepky / Stock count
Excel
Clean a stock count from Excel
A stock count typed into Excel has codes with accidental spaces and quantities entered as words or with a thousands comma. Sepky returns sku and quantity for the count you are posting.
What you get back
The columns you saved
- sku
- PLT-8
- quantity
- 1200
Column names
In the file
Counted itemPhysical
In the result
skuquantity
How this file is cleaned
- Set sku as text and quantity as a number. 1,200 becomes 1200.
- Attach the count workbook. Counted item and Physical are the source headers.
- Post the cleaned count. The file is returned and kept in History.
Questions
- Do I change the file before sending it? The counter's sheet is the file. It does not need a cleanup tab.
- 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.