$view = new view(); $view->name = 'commerce_orders'; $view->description = 'Export a list of orders'; $view->tag = 'commerce'; $view->base_table = 'commerce_order'; $view->human_name = 'Export Orders'; $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'] = 'Orders'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'view any commerce_order entity'; $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['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( 'order_number' => 'order_number', 'changed' => 'changed', 'commerce_customer_address' => 'commerce_customer_address', 'name' => 'name', 'commerce_order_total' => 'commerce_order_total', 'status' => 'status', 'operations' => 'operations', ); $handler->display->display_options['style_options']['default'] = 'changed'; $handler->display->display_options['style_options']['info'] = array( 'order_number' => array( 'sortable' => 0, 'default_sort_order' => 'desc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'changed' => array( 'sortable' => 1, 'default_sort_order' => 'desc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'commerce_customer_address' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'name' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'commerce_order_total' => 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, ), 'operations' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); $handler->display->display_options['style_options']['empty_table'] = TRUE; /* Header: Global: View order form */ $handler->display->display_options['header']['view_order_form']['id'] = 'view_order_form'; $handler->display->display_options['header']['view_order_form']['table'] = 'views'; $handler->display->display_options['header']['view_order_form']['field'] = 'view_order_form'; /* No results behavior: Commerce Order: Empty text */ $handler->display->display_options['empty']['empty_text']['id'] = 'empty_text'; $handler->display->display_options['empty']['empty_text']['table'] = 'commerce_order'; $handler->display->display_options['empty']['empty_text']['field'] = 'empty_text'; $handler->display->display_options['empty']['empty_text']['add_path'] = 'admin/commerce/orders/add'; /* Relationship: Commerce Order: Owner */ $handler->display->display_options['relationships']['uid']['id'] = 'uid'; $handler->display->display_options['relationships']['uid']['table'] = 'commerce_order'; $handler->display->display_options['relationships']['uid']['field'] = 'uid'; /* Relationship: Commerce Order: Referenced customer profile */ $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['id'] = 'commerce_customer_billing_profile_id'; $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['table'] = 'field_data_commerce_customer_billing'; $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['field'] = 'commerce_customer_billing_profile_id'; /* Field: Commerce Order: Order number */ $handler->display->display_options['fields']['order_number']['id'] = 'order_number'; $handler->display->display_options['fields']['order_number']['table'] = 'commerce_order'; $handler->display->display_options['fields']['order_number']['field'] = 'order_number'; $handler->display->display_options['fields']['order_number']['link_to_order'] = 'admin'; /* Field: Commerce Order: Updated date */ $handler->display->display_options['fields']['changed']['id'] = 'changed'; $handler->display->display_options['fields']['changed']['table'] = 'commerce_order'; $handler->display->display_options['fields']['changed']['field'] = 'changed'; $handler->display->display_options['fields']['changed']['label'] = 'Updated'; $handler->display->display_options['fields']['changed']['date_format'] = 'medium'; /* Field: Commerce Customer profile: Address */ $handler->display->display_options['fields']['commerce_customer_address']['id'] = 'commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['field'] = 'commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['relationship'] = 'commerce_customer_billing_profile_id'; $handler->display->display_options['fields']['commerce_customer_address']['label'] = 'Name'; $handler->display->display_options['fields']['commerce_customer_address']['empty'] = '-'; $handler->display->display_options['fields']['commerce_customer_address']['hide_alter_empty'] = FALSE; $handler->display->display_options['fields']['commerce_customer_address']['click_sort_column'] = 'country'; $handler->display->display_options['fields']['commerce_customer_address']['settings'] = array( 'use_widget_handlers' => 0, 'format_handlers' => array( 'name-oneline' => 'name-oneline', ), ); /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['relationship'] = 'uid'; $handler->display->display_options['fields']['name']['label'] = 'User'; /* Field: Commerce Order: Order total */ $handler->display->display_options['fields']['commerce_order_total']['id'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['table'] = 'field_data_commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['field'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['label'] = 'Total'; $handler->display->display_options['fields']['commerce_order_total']['click_sort_column'] = 'amount'; $handler->display->display_options['fields']['commerce_order_total']['settings'] = array( 'calculation' => FALSE, ); /* Field: Commerce Order: Order status */ $handler->display->display_options['fields']['status']['id'] = 'status'; $handler->display->display_options['fields']['status']['table'] = 'commerce_order'; $handler->display->display_options['fields']['status']['field'] = 'status'; /* Field: Commerce Order: Operations links */ $handler->display->display_options['fields']['operations']['id'] = 'operations'; $handler->display->display_options['fields']['operations']['table'] = 'commerce_order'; $handler->display->display_options['fields']['operations']['field'] = 'operations'; $handler->display->display_options['fields']['operations']['label'] = 'Operations'; /* Field: Commerce Order: Shipping information */ $handler->display->display_options['fields']['commerce_customer_shipping']['id'] = 'commerce_customer_shipping'; $handler->display->display_options['fields']['commerce_customer_shipping']['table'] = 'field_data_commerce_customer_shipping'; $handler->display->display_options['fields']['commerce_customer_shipping']['field'] = 'commerce_customer_shipping'; /* 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']['operator'] = 'not in'; $handler->display->display_options['filters']['state']['value'] = array( 'cart' => 'cart', 'checkout' => 'checkout', ); $handler->display->display_options['filters']['state']['group'] = 1; $handler->display->display_options['filters']['state']['expose']['label'] = 'Order state'; $handler->display->display_options['filters']['state']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op'; $handler->display->display_options['filters']['state']['expose']['identifier'] = 'state'; /* Display: Data export */ $handler = $view->new_display('views_data_export', 'Data export', 'views_data_export_1'); $handler->display->display_options['defaults']['query'] = FALSE; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['query']['options']['disable_sql_rewrite'] = TRUE; $handler->display->display_options['pager']['type'] = 'none'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['style_plugin'] = 'views_data_export_xml'; $handler->display->display_options['style_options']['provide_file'] = 0; $handler->display->display_options['style_options']['filename'] = '%view-%timestamp-full.xml'; $handler->display->display_options['style_options']['parent_sort'] = 0; $handler->display->display_options['style_options']['transform'] = 1; $handler->display->display_options['style_options']['root_node'] = 'commerce_orders'; $handler->display->display_options['style_options']['item_node'] = 'commerce_order'; $handler->display->display_options['style_options']['no_entity_encode'] = array( 'line_item_title' => 'line_item_title', ); $handler->display->display_options['defaults']['header'] = FALSE; $handler->display->display_options['defaults']['empty'] = FALSE; $handler->display->display_options['defaults']['relationships'] = FALSE; /* Relationship: Commerce Order: Referenced customer profile */ $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['id'] = 'commerce_customer_billing_profile_id'; $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['table'] = 'field_data_commerce_customer_billing'; $handler->display->display_options['relationships']['commerce_customer_billing_profile_id']['field'] = 'commerce_customer_billing_profile_id'; /* Relationship: Commerce Order: Referenced customer profile */ $handler->display->display_options['relationships']['commerce_customer_shipping_profile_id']['id'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['relationships']['commerce_customer_shipping_profile_id']['table'] = 'field_data_commerce_customer_shipping'; $handler->display->display_options['relationships']['commerce_customer_shipping_profile_id']['field'] = 'commerce_customer_shipping_profile_id'; /* 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['defaults']['fields'] = FALSE; /* Field: Commerce Order: Order number */ $handler->display->display_options['fields']['order_number']['id'] = 'order_number'; $handler->display->display_options['fields']['order_number']['table'] = 'commerce_order'; $handler->display->display_options['fields']['order_number']['field'] = 'order_number'; $handler->display->display_options['fields']['order_number']['element_default_classes'] = FALSE; /* Field: 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']['element_default_classes'] = FALSE; $handler->display->display_options['fields']['created']['date_format'] = 'long'; $handler->display->display_options['fields']['created']['second_date_format'] = 'long'; /* Field: Commerce Customer profile: Address */ $handler->display->display_options['fields']['commerce_customer_address']['id'] = 'commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['field'] = 'commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address']['relationship'] = 'commerce_customer_billing_profile_id'; $handler->display->display_options['fields']['commerce_customer_address']['label'] = 'Billing Name'; $handler->display->display_options['fields']['commerce_customer_address']['alter']['strip_tags'] = TRUE; $handler->display->display_options['fields']['commerce_customer_address']['element_default_classes'] = FALSE; $handler->display->display_options['fields']['commerce_customer_address']['empty'] = '-'; $handler->display->display_options['fields']['commerce_customer_address']['hide_alter_empty'] = FALSE; $handler->display->display_options['fields']['commerce_customer_address']['click_sort_column'] = 'country'; $handler->display->display_options['fields']['commerce_customer_address']['settings'] = array( 'use_widget_handlers' => 0, 'format_handlers' => array( 'name-oneline' => 'name-oneline', ), ); /* Field: Commerce Line item: Product */ $handler->display->display_options['fields']['commerce_product']['id'] = 'commerce_product'; $handler->display->display_options['fields']['commerce_product']['table'] = 'field_data_commerce_product'; $handler->display->display_options['fields']['commerce_product']['field'] = 'commerce_product'; $handler->display->display_options['fields']['commerce_product']['relationship'] = 'commerce_line_items_line_item_id'; $handler->display->display_options['fields']['commerce_product']['type'] = 'commerce_product_reference_sku_plain'; $handler->display->display_options['fields']['commerce_product']['settings'] = array( 'show_quantity' => 0, 'default_quantity' => '1', 'combine' => 1, 'show_single_product_attributes' => 0, 'line_item_type' => 'product', ); /* Field: 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_line_items_line_item_id'; /* Field: Commerce Order: E-mail */ $handler->display->display_options['fields']['mail']['id'] = 'mail'; $handler->display->display_options['fields']['mail']['table'] = 'commerce_order'; $handler->display->display_options['fields']['mail']['field'] = 'mail'; $handler->display->display_options['fields']['mail']['element_default_classes'] = FALSE; $handler->display->display_options['fields']['mail']['render_as_link'] = 0; /* Field: Commerce Customer profile: Address - Full name */ $handler->display->display_options['fields']['commerce_customer_address_name_line']['id'] = 'commerce_customer_address_name_line'; $handler->display->display_options['fields']['commerce_customer_address_name_line']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_name_line']['field'] = 'commerce_customer_address_name_line'; $handler->display->display_options['fields']['commerce_customer_address_name_line']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_name_line']['label'] = 'Shipping Full name'; $handler->display->display_options['fields']['commerce_customer_address_name_line']['element_default_classes'] = FALSE; /* Field: Commerce Customer profile: Address - Thoroughfare (i.e. Street address) */ $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['id'] = 'commerce_customer_address_thoroughfare'; $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['field'] = 'commerce_customer_address_thoroughfare'; $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['label'] = 'Shipping Address1'; $handler->display->display_options['fields']['commerce_customer_address_thoroughfare']['element_default_classes'] = FALSE; /* Field: Commerce Customer profile: Address - Premise (i.e. Apartment / Suite number) */ $handler->display->display_options['fields']['commerce_customer_address_premise']['id'] = 'commerce_customer_address_premise'; $handler->display->display_options['fields']['commerce_customer_address_premise']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_premise']['field'] = 'commerce_customer_address_premise'; $handler->display->display_options['fields']['commerce_customer_address_premise']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_premise']['label'] = 'Shipping Address2'; $handler->display->display_options['fields']['commerce_customer_address_premise']['element_default_classes'] = FALSE; /* Field: Commerce Customer profile: Address - Locality (i.e. City) */ $handler->display->display_options['fields']['commerce_customer_address_locality']['id'] = 'commerce_customer_address_locality'; $handler->display->display_options['fields']['commerce_customer_address_locality']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_locality']['field'] = 'commerce_customer_address_locality'; $handler->display->display_options['fields']['commerce_customer_address_locality']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_locality']['label'] = 'Shipping City'; $handler->display->display_options['fields']['commerce_customer_address_locality']['element_default_classes'] = FALSE; /* Field: Commerce Customer profile: Address - Administrative area (i.e. State / Province) */ $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['id'] = 'commerce_customer_address_administrative_area'; $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['field'] = 'commerce_customer_address_administrative_area'; $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['label'] = 'Shipping Province'; $handler->display->display_options['fields']['commerce_customer_address_administrative_area']['element_default_classes'] = FALSE; /* Field: Commerce Customer profile: Address - Country */ $handler->display->display_options['fields']['commerce_customer_address_country']['id'] = 'commerce_customer_address_country'; $handler->display->display_options['fields']['commerce_customer_address_country']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_country']['field'] = 'commerce_customer_address_country'; $handler->display->display_options['fields']['commerce_customer_address_country']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_country']['label'] = 'Shipping Country'; $handler->display->display_options['fields']['commerce_customer_address_country']['element_default_classes'] = FALSE; $handler->display->display_options['fields']['commerce_customer_address_country']['display_name'] = 1; /* Field: Commerce Customer profile: Address - Postal code */ $handler->display->display_options['fields']['commerce_customer_address_postal_code']['id'] = 'commerce_customer_address_postal_code'; $handler->display->display_options['fields']['commerce_customer_address_postal_code']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['fields']['commerce_customer_address_postal_code']['field'] = 'commerce_customer_address_postal_code'; $handler->display->display_options['fields']['commerce_customer_address_postal_code']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['fields']['commerce_customer_address_postal_code']['label'] = 'Shipping Postal code'; $handler->display->display_options['fields']['commerce_customer_address_postal_code']['element_default_classes'] = FALSE; /* Field: Commerce Order: Order total */ $handler->display->display_options['fields']['commerce_order_total']['id'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['table'] = 'field_data_commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['field'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['label'] = 'Total'; $handler->display->display_options['fields']['commerce_order_total']['element_default_classes'] = FALSE; $handler->display->display_options['fields']['commerce_order_total']['click_sort_column'] = 'amount'; $handler->display->display_options['fields']['commerce_order_total']['settings'] = array( 'calculation' => FALSE, ); /* Field: Commerce Order: Order status */ $handler->display->display_options['fields']['status']['id'] = 'status'; $handler->display->display_options['fields']['status']['table'] = 'commerce_order'; $handler->display->display_options['fields']['status']['field'] = 'status'; $handler->display->display_options['fields']['status']['element_default_classes'] = FALSE; $handler->display->display_options['defaults']['arguments'] = FALSE; $handler->display->display_options['defaults']['filter_groups'] = FALSE; $handler->display->display_options['defaults']['filters'] = FALSE; /* 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']['operator'] = 'not in'; $handler->display->display_options['filters']['state']['value'] = array( 'canceled' => 'canceled', 'cart' => 'cart', 'checkout' => 'checkout', ); $handler->display->display_options['filters']['state']['group'] = 1; $handler->display->display_options['filters']['state']['expose']['label'] = 'Order state'; $handler->display->display_options['filters']['state']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op'; $handler->display->display_options['filters']['state']['expose']['identifier'] = 'state'; /* Filter criterion: Commerce Customer profile: Address - Country */ $handler->display->display_options['filters']['commerce_customer_address_country']['id'] = 'commerce_customer_address_country'; $handler->display->display_options['filters']['commerce_customer_address_country']['table'] = 'field_data_commerce_customer_address'; $handler->display->display_options['filters']['commerce_customer_address_country']['field'] = 'commerce_customer_address_country'; $handler->display->display_options['filters']['commerce_customer_address_country']['relationship'] = 'commerce_customer_shipping_profile_id'; $handler->display->display_options['filters']['commerce_customer_address_country']['value'] = array( 'CA' => 'CA', ); $handler->display->display_options['path'] = 'orders.xml';