Stock imports need verified codes, locations and count units
Move a photographed count sheet into a CSV that you can review and map to an inventory import. Preserve item and location identifiers as text, and resolve count-unit differences before any file is used to update stock.
Preparing a cycle-count import
Recover sheet entries, verify the bin and SKU mapping, and adapt the reviewed columns to the inventory system's import template.
Combining counts from separate locations
Add verified location context to reviewed files before combining them, keeping identical SKUs from different bins distinguishable.
Prepare count-sheet rows for your system's template
- Capture the whole count table with its location and unit labels.
- Correct codes, handwritten counts and any rows affected by strike-through marks.
- Export CSV, match the target template and review the proposed stock changes separately.
Leading-zero SKUs, mixed units and crossed-out stock counts
- Does inventory sheet to CSV overwrite stock quantities?
- No. It produces a downloadable file. Updating inventory is a separate operation in your own system after validation.
- How do I preserve SKUs with leading zeros in CSV?
- Review the extracted characters and configure the destination importer to treat SKU fields as text rather than numbers.
- Can case counts and individual units share one quantity column?
- Only if their meaning remains explicit. Keep a unit column or normalize quantities yourself using verified pack sizes before an inventory import.
- Will crossed-out counts be interpreted as the corrected value?
- Recognition may read either mark or both. Check each correction against the original sheet and confirm the intended quantity manually.
- How do I add a location column to an inventory sheet CSV?
- The grid cannot add columns, so open the CSV in a spreadsheet, insert a Location column and fill it with the bin or aisle. Do this before you combine files from several sheets, so identical SKUs in different places stay as separate rows.
- What does an empty quantity cell mean after conversion?
- An empty cell means nothing was read in that position, which can be an uncounted line or a mark the reader skipped. Rows are also padded to the widest row, so a short row can get empty cells at the end. Check the sheet before you treat an empty cell as zero.
- How do I compare the CSV with system stock before importing?
- Open both lists in a spreadsheet, match them on SKU plus location with a lookup, and show the difference between counted and system quantity. Check large differences against the sheet first, since one misread digit looks exactly like a stock error.
- Which language should I pick for a sheet with product names in two languages?
- Choose the language of most of the printed text, because one language applies to the whole image. Changing Language or Engine clears the grid, so convert again after switching. Look closely at product names with accents or special characters, since that is where a wrong setting shows.
- Is there a batch option for a stack of count sheets?
- Premium accounts can switch to Batch mode and convert many sheets with the same settings, receiving one CSV per image in a ZIP. Batch mode has no review grid, so open each file and check the quantities yourself before you import anything.




























