Send plan export columns

The send plan export has one row per SKU and network, in the 22 columns below, in this order. Excel (.xlsx) and CSV (.csv) files have the same columns; the Excel sheet is named Send plan #N after the plan. To download the file, see Export a send plan.

What the file covers

• The whole saved plan. Grid filters, saved views, the selection and an unapplied tuning preview don't narrow or change it.
• One row per SKU and network. A SKU planned for four networks has four rows, including networks where it isn't listed.
• On-screen words. The Network, Status and Flags columns use the same names as the screen, such as Amazon FBA, Not listed and Stocks out first.
• Numbers stay numbers. Quantities and days are written as plain numbers, so you can sum and sort them. Text cells, such as product names, are always stored as text.
• Accented characters. CSV files start with a byte-order mark, so Excel opens product names with accents correctly.
• There is no import. You can't edit the file and upload it back. Change quantities on the grid instead; see Change a send quantity.

Columns

#	Column	What it holds	Blank when
1	SKU	The product's SKU.	Never
2	Product	The product name.	Never
3	Network	The kind of network: Amazon FBA, Amazon AWD, Walmart WFS, TikTok FBT, or Warehouse transfer for your own warehouses and 3PLs.	Never
4	Destination	The destination's full name, for example Amazon FBA US or the name of one of your warehouses. If the plan has no name for it, the warehouse's number is written instead.	Never
5	Status	Whether the network can take the product: Listed, New listing, Stranded, Ineligible or Not listed. See Send Planner statuses.	Never
6	Sales/day	The daily sales rate the plan used for this network.	The network has no sales rate, for example when the product isn't listed there.
7	On hand	Units at the network that it can sell now.	Never (0 when none)
8	Inbound	Units already on the way to the network.	Never
9	Open drafts	Units in shipment drafts that haven't shipped yet.	Never
10	Need	Units the network needs to reach its target cover, before sharing and rounding.	Never
11	Suggested	The plan's own suggestion.	Never
12	Override	The quantity someone typed on the grid.	The send was never edited.
13	Final	What will be sent: the Override when there is one, otherwise the Suggested quantity.	Never
14	Cases	Final divided by the case pack, rounded down to whole cases.	The product ships in units rather than cases (a case pack of 1).
15	Days of cover today	Days of sales the network holds today: on hand ÷ Sales/day. Stock on the way isn't counted.	The network has no sales to measure against.
16	Days of cover after	Days of sales the network will hold once the Final quantity lands, counting on hand, inbound and open drafts too. An edited send shows the cover after your edit, the same as the grid's pill.	The network has no sales to measure against.
17	Marketplace suggests	What the marketplace itself suggests sending, such as Amazon Restock.	The marketplace gave no suggestion.
18	Flags	The flags on this network's send, separated by semicolons, for example Stocks out first; Differs from network. See the flag list.	The send has no flags.
19	On hand at your warehouses (per product)	Stock on hand at your warehouses for the whole SKU.	Every row of the SKU except its first.
20	Kept for self-fulfilled orders (per product)	Units kept back for self-fulfilled orders.	Every row of the SKU except its first.
21	Stock to share (per product)	Units the networks share, the grid's Stock to share.	Every row of the SKU except its first.
22	Short (per product)	Units the SKU is short of bringing every network to target.	Every row of the SKU except its first.

The per-product columns

Columns 19 to 22 describe the SKU's whole pool, not one network. That's why their headers end in (per product) and why each SKU fills them in only once, on its first row. Its other network rows leave them blank. This keeps the totals right: summing these columns down the file counts each SKU once.

If you sort or filter the file, the filled row can end up apart from the SKU's other rows. To total these columns for some networks only, look the values up by SKU rather than adding the rows you see.

Flags column values

The Flags column holds network flags only. Flags about the whole SKU (Short, Below floor, Needs kit build and All protected) aren't repeated on every row; use the Short (per product) column for the shortage instead.

Value in the file	Meaning
Stranded	The listing can't sell the units at the network.
Ineligible	The network won't take the product.
Stocks out first	The network runs out before this send can arrive.
Capacity cap	The send was capped or cut to fit the network's capacity.
Source-limited	The warehouses allowed to ship here don't have enough.
New listing	A first send to a listing with no sales yet.
Stale data	Planned with Plan anyway on out-of-date network stock.
Blackout	The send would arrive during a receiving blackout.
Differs from network	Far from the marketplace's own suggestion.
Below one case	The need is less than one case, so it rounds to nothing.
Expires too soon	Some lots lack the shelf life the network needs.
Over N per box	The case holds more units than the network accepts in one box. N is that network's own limit, such as Over 150 per box for Amazon FBA. Over box limit when the limit isn't known.
Carton too big	The carton is heavier or longer than the network accepts.
No case label	The network needs an ITF-14 case label the product doesn't have.
Supplier can ship	A supplier that ships straight to the network can cover what your warehouses can't.
Uses protected stock	An edit takes units kept for self-fulfilled orders.

What each flag means and how to clear it is in Send Planner flags.

Related

• Export a send plan
• Send plan grid columns and filters
• Follow background jobs: exports over 1,000 rows are built in the background and offered from the job tray.