Views relationship not been added by code Im trying to make a abandoned cart notification module, trying to relate my notification table with the commerde_order table by its order_id in views. Right now i have this in my hook_views_data

function commerce_abandoned_cart_notification_views_data(){
    $data = array();

    $data['commerce_abandoned_cart_notification']['table']['group']  = t('Commerce abandoned cart notification');

    $data['commerce_abandoned_cart_notification']['table']['join'] = array(
        'commerce_order' =&gt; array(
            'left_field' =&gt; 'order_id',
            'field' =&gt; 'order_id',
        ),
    );

    $data['commerce_abandoned_cart_notification']['table']['base'] = array(
        'field' =&gt; 'id',
        'title' =&gt; t('Commerce abandoned cart notification'),
        'help' =&gt; t('Commerce abandoned cart notification'),
    );

    $data['commerce_abandoned_cart_notification']['id'] = array(
        'title' =&gt; t('Notification ID', array(), array('context' =&gt; 'A Commerce abandoned cart notification internal ID')),
        'help' =&gt; t('The unique internal identifier of the notification.'),
        'field' =&gt; array(
            'handler' =&gt; 'views_handler_field',
            'click sortable' =&gt; TRUE,
        ),
        'filter' =&gt; array(
            'handler' =&gt; 'views_handler_filter_string',
        ),
        'sort' =&gt; array(
            'handler' =&gt; 'views_handler_sort',
        ),
    );

    $data['commerce_abandoned_cart_notification']['order_id'] = array(
        'title' =&gt; t('Order ID', array(), array('context' =&gt; 'A Commerce order ID')),
        'help' =&gt; t('The unique internal identifier of the order.'),
        'relationship' =&gt; array(
            'base' =&gt; 'commerce_order',
            'field' =&gt; 'order_id',
            'handler' =&gt; 'views_handler_relationship',
            'label' =&gt; t('Referencing order'),
        ),
        'field' =&gt; array(
            'handler' =&gt; 'views_handler_field',
            'click sortable' =&gt; TRUE,
        ),
        'filter' =&gt; array(
            'handler' =&gt; 'views_handler_filter_string',
        ),
        'sort' =&gt; array(
            'handler' =&gt; 'views_handler_sort',
        ),
    );

    return $data;
}


The problem is that when creating a view i do not see my relationship to commerce orders or viceversa, (the hook works because i can create a view of type commerce_abandoned_cart_notification and add some of its fields). I know there is a commerce_abandoned_cart_notification or commerce_notification module but they seem incomplete and/or abadoned

Should i use hook_views_data_alter to alter commerce_order relatations and add one to my custom table?
Have you considered using the module Commerce Notification?