$view = new view(); $view->name = 'commerce_products'; $view->description = 'Display a list of products for store admin.'; $view->tag = 'commerce'; $view->base_table = 'commerce_product'; $view->human_name = 'Products'; $view->core = 0; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Defaults */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->display->display_options['title'] = 'Products'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'administer commerce_product entities'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['query']['options']['query_comment'] = FALSE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = 50; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'sku' => 'sku', 'title' => 'title', 'type' => 'type', 'commerce_price' => 'commerce_price', 'status' => 'status', 'quantity' => 'quantity', 'commerce_total' => 'commerce_total', 'created' => 'created', 'operations' => 'operations', ); $handler->display->display_options['style_options']['default'] = 'sku'; $handler->display->display_options['style_options']['info'] = array( 'sku' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'title' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'type' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'commerce_price' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'status' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'quantity' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'commerce_total' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'created' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'operations' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); $handler->display->display_options['style_options']['empty_table'] = TRUE; /* Header: Global: Result summary */ $handler->display->display_options['header']['result']['id'] = 'result'; $handler->display->display_options['header']['result']['table'] = 'views'; $handler->display->display_options['header']['result']['field'] = 'result'; /* No results behavior: Commerce Product: Empty text */ $handler->display->display_options['empty']['empty_text']['id'] = 'empty_text'; $handler->display->display_options['empty']['empty_text']['table'] = 'commerce_product'; $handler->display->display_options['empty']['empty_text']['field'] = 'empty_text'; $handler->display->display_options['empty']['empty_text']['add_path'] = 'admin/commerce/products/add'; /* Relationship: Commerce Product: Commerce Line item referencing products from commerce_product */ $handler->display->display_options['relationships']['commerce_product']['id'] = 'commerce_product'; $handler->display->display_options['relationships']['commerce_product']['table'] = 'commerce_product'; $handler->display->display_options['relationships']['commerce_product']['field'] = 'commerce_product'; /* Relationship: Commerce Line Item: Order ID */ $handler->display->display_options['relationships']['order_id']['id'] = 'order_id'; $handler->display->display_options['relationships']['order_id']['table'] = 'commerce_line_item'; $handler->display->display_options['relationships']['order_id']['field'] = 'order_id'; $handler->display->display_options['relationships']['order_id']['relationship'] = 'commerce_product'; /* Field: Commerce Product: SKU */ $handler->display->display_options['fields']['sku']['id'] = 'sku'; $handler->display->display_options['fields']['sku']['table'] = 'commerce_product'; $handler->display->display_options['fields']['sku']['field'] = 'sku'; $handler->display->display_options['fields']['sku']['link_to_product'] = 0; /* Field: MIN(Commerce Product: Title) */ $handler->display->display_options['fields']['title']['id'] = 'title'; $handler->display->display_options['fields']['title']['table'] = 'commerce_product'; $handler->display->display_options['fields']['title']['field'] = 'title'; $handler->display->display_options['fields']['title']['group_type'] = 'min'; $handler->display->display_options['fields']['title']['link_to_product'] = 1; /* Field: MIN(Commerce Product: Type) */ $handler->display->display_options['fields']['type']['id'] = 'type'; $handler->display->display_options['fields']['type']['table'] = 'commerce_product'; $handler->display->display_options['fields']['type']['field'] = 'type'; $handler->display->display_options['fields']['type']['group_type'] = 'min'; $handler->display->display_options['fields']['type']['link_to_product'] = 0; /* Field: MIN(Commerce Product: Price) */ $handler->display->display_options['fields']['commerce_price']['id'] = 'commerce_price'; $handler->display->display_options['fields']['commerce_price']['table'] = 'field_data_commerce_price'; $handler->display->display_options['fields']['commerce_price']['field'] = 'commerce_price'; $handler->display->display_options['fields']['commerce_price']['group_type'] = 'min'; $handler->display->display_options['fields']['commerce_price']['click_sort_column'] = 'amount'; $handler->display->display_options['fields']['commerce_price']['type'] = 'commerce_price_formatted_amount'; $handler->display->display_options['fields']['commerce_price']['group_column'] = 'entity_id'; $handler->display->display_options['fields']['commerce_price']['group_columns'] = array( 'amount' => 'amount', 'currency_code' => 'currency_code', ); /* Field: MIN(Commerce Product: Status) */ $handler->display->display_options['fields']['status']['id'] = 'status'; $handler->display->display_options['fields']['status']['table'] = 'commerce_product'; $handler->display->display_options['fields']['status']['field'] = 'status'; $handler->display->display_options['fields']['status']['group_type'] = 'min'; $handler->display->display_options['fields']['status']['type'] = 'active-disabled'; $handler->display->display_options['fields']['status']['not'] = 0; /* Field: SUM(Commerce Line Item: Quantity) */ $handler->display->display_options['fields']['quantity']['id'] = 'quantity'; $handler->display->display_options['fields']['quantity']['table'] = 'commerce_line_item'; $handler->display->display_options['fields']['quantity']['field'] = 'quantity'; $handler->display->display_options['fields']['quantity']['relationship'] = 'commerce_product'; $handler->display->display_options['fields']['quantity']['group_type'] = 'sum'; /* Field: SUM(Commerce Line item: Total) */ $handler->display->display_options['fields']['commerce_total']['id'] = 'commerce_total'; $handler->display->display_options['fields']['commerce_total']['table'] = 'field_data_commerce_total'; $handler->display->display_options['fields']['commerce_total']['field'] = 'commerce_total'; $handler->display->display_options['fields']['commerce_total']['relationship'] = 'commerce_product'; $handler->display->display_options['fields']['commerce_total']['group_type'] = 'sum'; $handler->display->display_options['fields']['commerce_total']['click_sort_column'] = 'amount'; $handler->display->display_options['fields']['commerce_total']['type'] = 'commerce_price_formatted_amount'; $handler->display->display_options['fields']['commerce_total']['settings'] = array( 'calculation' => FALSE, ); $handler->display->display_options['fields']['commerce_total']['group_column'] = 'entity_id'; $handler->display->display_options['fields']['commerce_total']['group_columns'] = array( 'amount' => 'amount', 'currency_code' => 'currency_code', ); /* Field: MAX(Commerce Order: Created date) */ $handler->display->display_options['fields']['created']['id'] = 'created'; $handler->display->display_options['fields']['created']['table'] = 'commerce_order'; $handler->display->display_options['fields']['created']['field'] = 'created'; $handler->display->display_options['fields']['created']['relationship'] = 'order_id'; $handler->display->display_options['fields']['created']['group_type'] = 'max'; $handler->display->display_options['fields']['created']['label'] = 'Latest order date'; $handler->display->display_options['fields']['created']['date_format'] = 'short'; /* Field: Commerce Product: Operations links */ $handler->display->display_options['fields']['operations']['id'] = 'operations'; $handler->display->display_options['fields']['operations']['table'] = 'commerce_product'; $handler->display->display_options['fields']['operations']['field'] = 'operations'; $handler->display->display_options['fields']['operations']['label'] = 'Operations'; $handler->display->display_options['fields']['operations']['add_destination'] = 1; /* Sort criterion: Commerce Product: SKU */ $handler->display->display_options['sorts']['sku']['id'] = 'sku'; $handler->display->display_options['sorts']['sku']['table'] = 'commerce_product'; $handler->display->display_options['sorts']['sku']['field'] = 'sku'; $handler->display->display_options['filter_groups']['groups'] = array( 1 => 'AND', 2 => 'OR', ); /* Filter criterion: Commerce Product: SKU */ $handler->display->display_options['filters']['sku']['id'] = 'sku'; $handler->display->display_options['filters']['sku']['table'] = 'commerce_product'; $handler->display->display_options['filters']['sku']['field'] = 'sku'; $handler->display->display_options['filters']['sku']['operator'] = 'contains'; $handler->display->display_options['filters']['sku']['group'] = 1; $handler->display->display_options['filters']['sku']['exposed'] = TRUE; $handler->display->display_options['filters']['sku']['expose']['operator_id'] = 'sku_op'; $handler->display->display_options['filters']['sku']['expose']['label'] = 'Filter by SKUs containing'; $handler->display->display_options['filters']['sku']['expose']['operator'] = 'sku_op'; $handler->display->display_options['filters']['sku']['expose']['identifier'] = 'sku'; /* Filter criterion: Commerce Order: Order state */ $handler->display->display_options['filters']['state']['id'] = 'state'; $handler->display->display_options['filters']['state']['table'] = 'commerce_order'; $handler->display->display_options['filters']['state']['field'] = 'state'; $handler->display->display_options['filters']['state']['relationship'] = 'order_id'; $handler->display->display_options['filters']['state']['value'] = array( 'completed' => 'completed', ); $handler->display->display_options['filters']['state']['group'] = 2; $handler->display->display_options['filters']['state']['exposed'] = TRUE; $handler->display->display_options['filters']['state']['expose']['operator_id'] = 'state_op'; $handler->display->display_options['filters']['state']['expose']['label'] = 'Order state'; $handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op'; $handler->display->display_options['filters']['state']['expose']['identifier'] = 'state'; $handler->display->display_options['filters']['state']['expose']['multiple'] = TRUE; $handler->display->display_options['filters']['state']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, ); /* Filter criterion: Commerce Order: Order status */ $handler->display->display_options['filters']['status']['id'] = 'status'; $handler->display->display_options['filters']['status']['table'] = 'commerce_order'; $handler->display->display_options['filters']['status']['field'] = 'status'; $handler->display->display_options['filters']['status']['relationship'] = 'order_id'; $handler->display->display_options['filters']['status']['operator'] = 'empty'; $handler->display->display_options['filters']['status']['value'] = array( 'min' => '', 'max' => '', 'value' => '', ); $handler->display->display_options['filters']['status']['group'] = 2; /* Display: Admin page */ $handler = $view->new_display('page', 'Admin page', 'admin_page'); $handler->display->display_options['defaults']['hide_admin_links'] = FALSE; $handler->display->display_options['path'] = 'admin/commerce/products/list'; $handler->display->display_options['menu']['type'] = 'default tab'; $handler->display->display_options['menu']['title'] = 'List'; $handler->display->display_options['menu']['weight'] = '-10'; $handler->display->display_options['tab_options']['type'] = 'normal'; $handler->display->display_options['tab_options']['title'] = 'Products'; $handler->display->display_options['tab_options']['description'] = 'Manage products and product types in the store.'; $handler->display->display_options['tab_options']['weight'] = ''; $handler->display->display_options['tab_options']['name'] = 'management';