$view = new view(); $view->name = 'top_selling_products'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'commerce_order'; $view->human_name = 'Top selling products'; $view->core = 7; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Master */ $handler = $view->new_display('default', 'Master', 'default'); $handler->display->display_options['title'] = 'Top selling products'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'none'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'some'; $handler->display->display_options['pager']['options']['items_per_page'] = '5'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; /* Relationship: Commerce Order: Referenced line items */ $handler->display->display_options['relationships']['commerce_line_items_line_item_id']['id'] = 'commerce_line_items_line_item_id'; $handler->display->display_options['relationships']['commerce_line_items_line_item_id']['table'] = 'field_data_commerce_line_items'; $handler->display->display_options['relationships']['commerce_line_items_line_item_id']['field'] = 'commerce_line_items_line_item_id'; $handler->display->display_options['relationships']['commerce_line_items_line_item_id']['label'] = 'Line items'; $handler->display->display_options['relationships']['commerce_line_items_line_item_id']['required'] = TRUE; /* Relationship: Commerce Line item: Referenced products */ $handler->display->display_options['relationships']['commerce_product_product_id']['id'] = 'commerce_product_product_id'; $handler->display->display_options['relationships']['commerce_product_product_id']['table'] = 'field_data_commerce_product'; $handler->display->display_options['relationships']['commerce_product_product_id']['field'] = 'commerce_product_product_id'; $handler->display->display_options['relationships']['commerce_product_product_id']['relationship'] = 'commerce_line_items_line_item_id'; $handler->display->display_options['relationships']['commerce_product_product_id']['label'] = 'Product'; $handler->display->display_options['relationships']['commerce_product_product_id']['required'] = TRUE; /* Relationship: Commerce Product: Referencing Node */ $handler->display->display_options['relationships']['field_product']['id'] = 'field_product'; $handler->display->display_options['relationships']['field_product']['table'] = 'commerce_product'; $handler->display->display_options['relationships']['field_product']['field'] = 'field_product'; $handler->display->display_options['relationships']['field_product']['relationship'] = 'commerce_product_product_id'; $handler->display->display_options['relationships']['field_product']['label'] = 'Product display'; $handler->display->display_options['relationships']['field_product']['required'] = TRUE; /* Field: Content: Rendered Node */ $handler->display->display_options['fields']['rendered_entity']['id'] = 'rendered_entity'; $handler->display->display_options['fields']['rendered_entity']['table'] = 'views_entity_node'; $handler->display->display_options['fields']['rendered_entity']['field'] = 'rendered_entity'; $handler->display->display_options['fields']['rendered_entity']['relationship'] = 'field_product'; $handler->display->display_options['fields']['rendered_entity']['label'] = ''; $handler->display->display_options['fields']['rendered_entity']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['rendered_entity']['link_to_entity'] = 1; $handler->display->display_options['fields']['rendered_entity']['display'] = 'view'; $handler->display->display_options['fields']['rendered_entity']['view_mode'] = 'teaser'; $handler->display->display_options['fields']['rendered_entity']['bypass_access'] = 0; /* Sort criterion: COUNT(Commerce Order: Order ID) */ $handler->display->display_options['sorts']['order_id']['id'] = 'order_id'; $handler->display->display_options['sorts']['order_id']['table'] = 'commerce_order'; $handler->display->display_options['sorts']['order_id']['field'] = 'order_id'; $handler->display->display_options['sorts']['order_id']['group_type'] = 'count'; $handler->display->display_options['sorts']['order_id']['order'] = 'DESC'; /* 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']['value'] = array( 'pending' => 'pending', 'completed' => 'completed', ); /* Display: Block */ $handler = $view->new_display('block', 'Block', 'block');