> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stockful.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Transfer suggestions

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

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

## Example

```sql theme={null}
FROM transfer_suggestions
  SHOW units_to_transfer, transfer_value
  GROUP BY product
  ORDER BY units_to_transfer DESC
```

## Metrics

| 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.                            |

## Dimensions

| 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.                                                                                                                                                                       |

## Filters

| 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. |

## Related datasets

* [Reorder history](/stockfulql/datasets/reorder_history)
* [Transfer history](/stockfulql/datasets/transfer_history)
* [Reorder (all locations)](/stockfulql/datasets/reorder_consolidated)