Free tool
Merge purchase orders into one spreadsheet
Upload the purchase orders you got today from different retailers, in Excel, CSV or PDF. You get one sheet with every order line, totals by item, and a list of lines to check before you confirm. No sign-up, and your files are not stored.
Drop purchase order files here, or click to choose
Up to 5 files, 10 MB in total. Excel, CSV or PDF with text.
Free, no sign-up. Files are not stored.
How it works
- 1Upload up to 5 purchase order files. Each retailer can use its own layout.
- 2For each file, an AI model reads the first rows and says which column is the item, quantity, price or date. The values themselves are read from the original cells, not retyped.
- 3Lines are combined into one sheet and added up by UPC, SKU or item name. Anything uncertain goes to a Check tab instead of being merged.
What it handles
- Files
- Up to 5 at a time, 10 MB in total
- Formats
- Excel (.xlsx), CSV, and PDFs that contain text
- Not yet
- Scanned PDFs, old .xls files, EDI 850 files
- Free use
- 5 merges a day, no sign-up
- Your files
- Read in memory and not stored
Questions
Is it really free?
Yes. You can run up to 5 merges a day with no sign-up and no email. To merge more, or to have it done every day, start a free Markhub workspace.
What happens to my files?
They are read in memory to build your sheet and are not stored. The first rows of each table, or the text of a PDF, are sent to an AI model so it can tell which column is the item, the quantity or the date.
Which files work?
Excel (.xlsx), CSV and PDFs that contain text. Scanned PDFs are images without text, so they are not supported yet. Export those as Excel or CSV from your EDI or retailer portal first.
How are items matched across retailers?
By UPC first, then by SKU, then by the item name. Names that look alike but are not identical are listed in the Check tab instead of being merged, so no total is combined by guess.
Why is a line marked for checking?
For PDFs, each quantity is compared with the text of the original file, and a number that cannot be found is flagged. Lines ordered in different units, like cases and eaches, are also kept apart and flagged.
Related
- Order consolidation template: the same sheet to fill in by hand, with formulas.
- Walmart purchase orders to Excel: EDI 850, Supplier One and NOVA, and how VNPK, WHPK and MABD map into your order sheet.
- Target purchase orders to Excel: EDI 850 and Partners Online, and how DPCI, casepack and the PO dates map into your order sheet.
- Amazon Vendor Central purchase orders to Excel: Confirm New POs and the Vendor Orders API, and how ASIN, cases and ship windows map into your order sheet.