Target purchase orders to Excel
Target sends purchase orders as EDI 850, and its supplier portal is Partners Online (POL). To get Target POs into one order sheet, take the PO data from the tool that receives your EDI, add one row per PO line, map Target’s DPCI to your own SKU, and plan from the PO dates Target’s compliance policy works with: PO Create, PO Ship End and PO ETA.
Checked against public Target and EDI provider documentation in September 2026. Sources are listed at the end of the page.
How Target purchase orders reach you
- EDI 850Target sends purchase orders as EDI 850 transactions. EDI providers describe EDI as required for Target vendors, along with the acknowledgment, ship notice and invoice.
- Partners Online (POL)Target’s supplier portal, where vendors find Target’s compliance information and vendor tools.
- Vendor Routing System (VRS)Where collect vendors enter shipments so Target can arrange pickup. It works from the PO dates, so the order sheet has to carry them.
Fields on a Target PO and where they go in your sheet
| On the Target PO | In your order sheet | Watch for |
|---|---|---|
| PO number | PO number | Add one row per PO line, not one row per PO. |
| DPCI | SKU (mapped) | Department, Class, Item: Target’s own item number. Map it to your SKU so totals by SKU line up across channels. |
| Casepack | Case pack | The number of units grouped in one case. Use it to turn units into cases before you add up. |
| PO Create | Order date | The day the PO was created. Target’s compliance policy also uses it to work out expected release dates. |
| PO Ship End | Ship by | The end of the ship window. For collect freight, the expected release is counted back from it. |
| PO ETA / SDA | Notes | The expected arrival. Deliveries to Target’s fulfillment distribution centers have to match it exactly. |
What you send back
- PO acknowledgment (EDI 855)
- EDI providers list the 855 among Target’s required documents. Confirm the timing that applies to you in Partners Online.
- Ship notice (EDI 856)
- Required, and it has to match what is on the truck. The timing rules are in Target’s compliance documents.
- Invoice (EDI 810)
- Sent after the ship notice, not before it.
- Collect shipments in VRS
- Enter them by 11:00 AM Central, two business days before pickup, according to SPS Commerce’s summary of Target’s compliance policy.
Where it goes wrong
- Ship notices that are late, missing or do not match what is on the truck.
- Invoices sent before the ship notice.
- GTIN or label errors, and shipments routed the wrong way.
- A compliance violation that is still unresolved at the end of its two-week cycle becomes a chargeback, a deduction from what Target pays you.
Turn Target POs into one order sheet
- 1Take the PO data from the tool that receives your Target EDI: your EDI provider’s portal or your ERP.
- 2Add one row per PO line with the PO number, DPCI mapped to your SKU, quantity and casepack.
- 3Convert every quantity to cases with the casepack.
- 4Write PO Ship End in Ship by and keep PO ETA in Notes, then check totals by SKU against stock before you acknowledge.
- 5For collect freight, set a reminder to enter the shipment in VRS two business days before pickup.
In Markhub
Combine Target POs with every other channel
- 1Download the day’s Target POs the way you already do, and post the files in Markhub with the other channels’ files, as csv, xlsx or pdf.
- 2The Order Consolidator agent reads every file and fills one sheet, one row per line, with totals by SKU.
- 3You check short lines and changes, then confirm in Target’s own system. Markhub prepares the sheet and does not send anything to Target.
Then add the Order Consolidator from the agent library in your workspace.
Questions
What is a DPCI?
Department, Class, Item. It is Target’s own item number, so it will not match your SKU. Keep a mapping table between the two.
Which Target date goes in my ship date column?
PO Ship End marks the end of the ship window and is what Target’s compliance policy counts back from for collect freight. Keep PO ETA alongside it, because some deliveries have to arrive exactly on that date.
Can I download Target POs as a spreadsheet?
Target’s public material does not describe a spreadsheet download. Most suppliers export the data from the tool that receives their EDI 850, such as an EDI provider portal or their ERP.
Does Markhub connect to Target?
No. Markhub does not connect to Partners Online, VRS or your EDI. You post the PO files you already export, and the Order Consolidator agent combines them with your other channels in one sheet for a person to review.
Other retailers
Sources
- Orderful: Target EDI requirements (2026)
- SPS Commerce: Target compliance glossary (2025)
- SPS Commerce: A supplier’s guide to Target’s compliance policy (2024)
Markhub is not affiliated with, endorsed by or connected to Target. Target is a trademark of its owner. Supplier requirements change, so confirm the details in your own supplier agreement and portal.