Operations Field guide
EDI 810 invoices explained for convenience store owners
What an EDI 810 file is, how to read one, how it gets from your distributor to your back office, and how to stop typing wholesaler invoices by hand.
Every week, a truck shows up and someone at your store signs for a stack of paper. Then, later, someone types that paper into the back office. Or doesn’t, and the costs in your pricebook slowly drift away from what you actually pay.
Most large distributors can send that same invoice electronically. The format is called EDI 810. If you’ve ever heard a wholesaler rep say “we can send you your 810s,” this is what they meant.
EDI in one paragraph
EDI stands for Electronic Data Interchange. It’s a family of standard file formats businesses use to send each other documents. In North American retail and distribution, the standard is called ANSI X12, and each document type has a number. The ones a c-store owner is likely to hear about:
| Number | Document | Who sends it | What it’s for |
|---|---|---|---|
| 850 | Purchase order | You (or your system) | What you want to order |
| 855 | PO acknowledgment | Distributor | Confirms what they’ll ship |
| 856 | Advance ship notice (ASN) | Distributor | What is actually on the truck |
| 810 | Invoice | Distributor | What you owe and for what |
| 997 | Functional acknowledgment | Whoever received a file | Confirms a file arrived and could be read |
For most single-store and small-chain operators, the 810 is the one that matters. It replaces the typing.
What’s inside an 810
An X12 file looks like gibberish the first time you open it. It’s plain text, split into segments, each one ending with a terminator (often ~). Each segment starts with a short code and has elements separated by a delimiter (often *).
Here’s a simplified, illustrative piece of an 810:
ISA*00* *00* *ZZ*DISTRIBUTOR *ZZ*STORE123 *261103*0612*U*00401*000000123*0*P*>~
GS*IN*DISTRIBUTOR*STORE123*20261103*0612*123*X*004010~
ST*810*0001~
BIG*20261103*INV448812~
N1*ST*CORNER MARKET 1*92*STORE123~
IT1*1*2*CA*18.24**UP*012000001234~
PID*F****COLA 12OZ CAN 24PK~
IT1*2*1*CA*42.60**UP*028400090896~
PID*F****CHIPS ASSORTED 50CT~
TDS*7908~
SE*9*0001~
GE*1*123~
IEA*1*000000123~
You don’t need to memorize it. But it helps to know the parts:
- ISA / IEA wrap the whole transmission. Sender, receiver, date, control numbers.
- GS / GE wrap a group of documents of the same type.
- ST / SE wrap one document.
ST*810means this one is an invoice. - BIG is the invoice header: invoice date and invoice number.
- N1 identifies parties, like the ship-to store.
- IT1 is one invoice line: line number, quantity, unit (CA for case), unit price, and a product ID.
UPmeans the ID is a UPC. - PID is the item description.
- TDS is the invoice total, in cents with no decimal point.
7908here means $79.08, which is 2 × $18.24 plus 1 × $42.60.
Different distributors use different optional segments and qualifiers. Some send the vendor’s own item number instead of, or as well as, the UPC. Some send pack size in a separate segment. That’s why “we support EDI” always comes with a setup step.
Shop-floor tip: Before you sign up, ask your distributor for a sample 810 from your own account. Testing with a real file from your store saves a week of back-and-forth.
How the file gets to you
The file has to travel from the distributor’s system to yours. The common options:
- FTP or SFTP folder. The distributor drops files in a folder; your system logs in on a schedule and picks them up. SFTP is encrypted and is the better choice when it’s offered.
- Email attachment. Simple, but someone or something has to pull the attachment and load it.
- Portal download. You log into the distributor’s site and download files. Works, but it’s still a manual step.
- CSV export. Not EDI, but many distributors offer a spreadsheet version of the invoice. Easier to read, but every distributor’s columns are different.
Automated pickup over SFTP is the goal. Once it runs, invoices show up in your back office as the truck pulls in.
Matching lines to your pricebook
This is the hard part, and it’s the same with EDI, CSV or a photo of a paper invoice. Every line has to land on the right item in your pricebook.
A good matching order is:
- UPC. Exact match on the barcode. This catches most lines.
- Vendor item number. The distributor’s own code for the item, stored on your product.
- Description. A last resort, and something a person should confirm.
The first time you import from a new distributor, expect a pile of unmatched lines. Case UPCs that differ from unit UPCs. Items you’ve never set up. Items where the distributor’s code was never saved. Match them once, have the system remember, and the next file goes much faster.
Case packs and costs
An 810 line usually says “2 CA at $18.24.” Your pricebook sells single cans. So the system needs the pack size: 24 per case means 48 units received and a unit cost of $0.76.
| Line | Qty | Unit | Case cost | Pack | Units received | Unit cost |
|---|---|---|---|---|---|---|
| Cola 12oz | 2 | CA | $18.24 | 24 | 48 | $0.760 |
| Chips 50ct | 1 | CA | $42.60 | 50 | 50 | $0.852 |
If the pack size on your product is wrong, every cost and stock figure from that line is wrong. When your margins on an item suddenly look strange after an import, check pack size first.
Shop-floor tip: When a case cost jumps more than a few percent from last time, look at it before posting. It’s either a real price increase you should pass on, or a pack size change you need to fix.
Draft first, post second
Importing a file should never change your stock or costs by itself. The safe workflow is:
- File comes in and becomes a draft invoice.
- Someone checks totals against the paper (at least for the first few weeks).
- Unmatched lines are matched or added as new items.
- The invoice is posted. Stock is received, costs update, and the invoice becomes a payable.
Check the received quantities against what actually came off the truck. EDI tells you what was billed. It doesn’t prove what was delivered. Shorts and damages still need a credit request.
Duplicates
The same file can arrive twice. A distributor resends after a glitch. Someone uploads it manually after it was already picked up. Your system should recognize an invoice number, or the same file content, that it has already seen and skip it. Without that check, you receive the stock twice and your inventory is wrong until the next count.
Why bother
Typing invoices takes time, and it’s where errors creep in. A transposed digit on a case cost shows up weeks later as a weird margin. A skipped invoice means stock you have but the system doesn’t. EDI doesn’t remove the need to check, but it moves the work from typing to reviewing, which is faster and catches more.
It also keeps your costs current. When your pricebook cost matches your last invoice, your margin reports mean something. That matters for buying, for pricing, and for spotting shrink. More on that in reducing shrink.
How CornerHawk handles EDI
CornerHawk’s EDI import works the way this article describes.
- Upload a distributor’s X12 810 file, or a CSV export with a column mapping saved per vendor (there’s a “guess from header” helper).
- Every invoice in the file becomes a draft. Lines match by UPC, then vendor item number, then name. Unmatched lines are matched once and remembered.
- A file or invoice number seen before is skipped as a duplicate.
- Automatic pickup connects to a vendor’s FTP, FTPS or SFTP folder on a schedule (hourly or daily), downloads new files matching patterns like
*.edi, skips anything already seen, loads it and archives it. Every file is logged. - Posting from Purchases receives the stock (quantity × pack), updates unit and case cost, and logs the change in Item Logs. Vendors without EDI can still use Scan invoice, which reads a photo or PDF.
Every distributor’s 810 has its own habits, so check the first few imports against the paper invoice before you trust it on autopilot.
Checklist for going electronic
- Ask each distributor if they offer 810s or a CSV export, and how they deliver them.
- Get a sample file from your own account.
- Make sure your products have UPCs and, ideally, vendor item numbers.
- Check pack sizes on your top items from that vendor.
- Run the first imports side by side with paper.
- Set up automatic pickup once you trust the matching.
The glossary has a short definition of EDI 810 and the related terms if you need to explain it to a manager.
Quick answers
What is an EDI 810?
It's the standard X12 electronic invoice. Your distributor sends the same information as a paper invoice, but as a structured file a computer can read line by line: invoice number, date, items, quantities, pack sizes and costs.
What's the difference between an 810, 850, 856 and 997?
An 850 is a purchase order, an 856 is an advance ship notice describing what's on the truck, an 810 is the invoice, and a 997 is a functional acknowledgment confirming a file was received and could be read.
How do I get EDI invoices from my distributor?
Ask your distributor's EDI or customer service team. They'll usually offer delivery by FTP or SFTP folder, sometimes email, and will need your account number and the destination details. Some also offer a CSV export.
Does EDI update my costs automatically?
It can, once the invoice is matched and posted. In CornerHawk, an imported file becomes a draft invoice; nothing changes until you post it, and posting receives the stock and updates unit and case costs.