in your browser
Software brief
Software brief
Describe the users, the data and the steps, and get a brief split into phases.
FREE TOOL
Check your product data before a shop–warehouse sync
Drop the export from your stock program. We show which items will link to your online shop on their own, which need a mapping table and which have errors, in your browser and without uploading the file.
The file is read in your browser and is never sent to us. Only the counts go into your enquiry, never the file's content.
CSV, XLSX or XML · up to 50 MB and 200,000 rows
Chosen file: · ·
Optional. It only goes into your enquiry, if you decide to send one. We connect the shop to any stock program; from the name we see what export or API yours has.
Columns
We recognised the columns by their headers. If one is wrong, choose the right one and the check runs again at once.
The first rows of the file
Now drop the export from your online shop. We match the codes and, where both files have them, the prices and stock.
Warehouse · . We use the file from the first tab.
First choose the export from your stock program, here or in the first tab.
CSV, XLSX or XML · up to 50 MB and 200,000 rows
Chosen file: · ·
CSV, XLSX or XML · up to 50 MB and 200,000 rows
Chosen file: · ·
Columns
We recognised the columns by their headers. If one is wrong, choose the right one and the check runs again at once.
The first rows of the file
Result
-
What it means:
What to do:
Show the rows affected ()
Where Code Name Value
What this means
online shop and warehouse software sync.
Radans's store syncs with its warehouse program twice a day.
Every affected row as a CSV file, made in your browser.
WANT A HAND
Send us the report
This is the first step of the audit we run before every sync. Send us the report, without the file itself, and we will tell you what comes next.
Replace your text with the result?
ENQUIRY RECEIVED
We have it. We reply within two working days.
A copy is on its way to your inbox. If it does not arrive, check the spam folder — and write to us directly. [email protected]
Reference number:
What we check
We read the export in your browser: CSV, XLSX or XML, in UTF-8 or windows-1251. We recognise the columns by their headers and go through every row: empty and repeated codes, barcodes with a wrong check digit or shortened by Excel, lost leading zeros, prices stored as text, at zero or below it, negative and fractional stock, VAT rates other than 20, 9 and 0 %, variants hidden in names, and the groups. We never run formulas or macros.
The report is the first step of an online shop and warehouse software sync.
In the glossary: EAN-13 barcode
How to check the export yourself
The same checks, if you would rather do them by hand, without JavaScript for example.
- Open the export in a text editor rather than Excel, so you see the codes exactly as they are stored.
- Sort by the code column and look for empty cells and identical codes one under the other.
- Search the barcode column for "E+". Excel has shortened a barcode like that, and it no longer matches anything.
- Count the digits: an EAN-13 has 13. A 12-digit barcode in such a column has usually lost its leading zero.
- Check a few barcodes against the product label. The last digit is a check digit, and a mistake in any digit breaks it.
- The price column should hold numbers only, with no currency and no spaces, and the same decimal separator throughout.
- Stock counted in pieces is a whole number and never below zero.
- The VAT rate is 20 %, 9 % or 0 %.
- Names that end in a size or colour ("Blue shirt M", "Blue shirt L") are one product with variants in a shop.
- Save the file as CSV in UTF-8 and do not open it in Excel again before the import.
QUESTIONS
What people ask
How do I check the barcodes in a stock export?
Drop the export into the check above. For every barcode we work out the EAN-8, EAN-13, UPC-A and GTIN-14 check digit, look for codes Excel has stored as 3.8E+12, 12-digit barcodes that have lost their leading zero, and one barcode on two items. You see the affected rows on screen and can download them as a list.
Why does Excel break barcodes?
Excel reads a long barcode as a number. It shows it as 3.8E+12 and, when you save as CSV, writes it that way too, so the other digits are lost. As a number it also drops the leading zero. Export straight from your program, or import the column as text.
Which file should I export from my stock program?
The item list with code, barcode, name, price, stock, VAT, unit and group, as CSV or XLSX. Most programs have that export under items or reports. If you cannot find it, tell us which program you use; we work with any of them and will tell you what export or API it has.
Do you upload the file?
No. The file is read in your browser and is not sent to us or to anyone else. If you send an enquiry, it holds only the counts and the kinds of error, never the file's content.
What happens if the codes do not match?
You make a mapping table: which warehouse code goes with which shop product. Codes that differ only by spaces, capital letters or leading zeros link after a clean-up. The rest are linked by hand once, and the sync keeps them from then on.
More free tools
All tools
in your browser
B2B ordering calculator
B2B ordering calculator
How many hours and how much money go on taking and re-keying phone, Viber and email orders.