Transfer suggestions

The live rebalance list: stock worth moving between locations right now, and how much.

Example

FROM transfer_suggestions
  SHOW units_to_transfer, transfer_value
  GROUP BY product
  ORDER BY units_to_transfer DESC

Metric	Type	Description
`units_to_transfer`	Number	Units worth moving from the source to the destination right now.
`transfer_value`	Currency	Cost value of the units worth moving.
`pairs_suggested`	Number	How many source-to-destination moves are suggested.
`source_units_on_hand`	Number	Units currently held at the source location.
`destination_units_on_hand`	Number	Units currently held at the destination location.
`source_days_of_supply`	Number	How long the source’s stock lasts at its current sales rate.
`destination_days_of_supply`	Number	How long the destination’s stock lasts at its current sales rate.
`unit_cost`	Currency	Cost price of the variant being moved.

Dimension	Description
`product`	Product with image, rendered as a single cell (variants roll up).
`sku`	Variant SKU - splits a product-grain report into variant rows.
`variant`	Variant title (e.g. “Small / Blue”), shown as a dash for products without options. Group by product too - on its own, variants sharing a title across different products fall into one row.
`source_location`	The location stock would move out of.
`destination_location`	The location stock would move into.
`vendor`	Product vendor.
`product_type`	Shopify product type.

Filter	Type	Description
`product_title`	Text	Product title.
`sku`	Text	Variant SKU.
`vendor`	Text	Product vendor.
`product_type`	Text	Shopify product type.
`source_location_name`	Text	Source location name.
`destination_location_name`	Text	Destination location name.
`source_is_hub`	Text	Whether the stock is moving out of a hub location.
`suggested_transfer_quantity`	Number	Units worth moving.
`dismissed`	Text	Whether the pair was dismissed, or already has an open transfer.