Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "now": {
- "mode": "now",
- "title": "",
- "skip_empty_file": true,
- "log_results": false,
- "from_status": [],
- "to_status": [],
- "change_order_status_to": "",
- "statuses": [],
- "from_date": "2018-07-09",
- "to_date": "2018-07-09",
- "shipping_locations": [],
- "shipping_methods": [],
- "item_names": [],
- "item_metadata": [],
- "user_roles": [],
- "user_names": [],
- "billing_locations": [],
- "payment_methods": [],
- "any_coupon_used": "0",
- "coupons": [],
- "order_custom_fields": [],
- "product_categories": [],
- "product_vendors": [],
- "products": [],
- "product_taxonomies": [],
- "product_custom_fields": [],
- "product_attributes": [],
- "product_itemmeta": [],
- "format": "XLS",
- "format_xls_use_xls_format": "0",
- "format_xls_sheet_name": "Orders",
- "format_xls_display_column_names": "1",
- "format_xls_auto_width": "1",
- "format_xls_populate_other_columns_product_rows": "1",
- "format_xls_direction_rtl": "0",
- "format_csv_enclosure": "\"",
- "format_csv_delimiter": ",",
- "format_csv_linebreak": "\\r\\n",
- "format_csv_display_column_names": "1",
- "format_csv_add_utf8_bom": "0",
- "format_csv_populate_other_columns_product_rows": "1",
- "format_csv_item_rows_start_from_new_line": "0",
- "format_csv_encoding": "UTF-8",
- "format_csv_delete_linebreaks": "0",
- "format_tsv_linebreak": "\\r\\n",
- "format_tsv_display_column_names": "1",
- "format_tsv_add_utf8_bom": "0",
- "format_tsv_populate_other_columns_product_rows": "1",
- "format_tsv_encoding": "UTF-8",
- "format_xml_root_tag": "Orders",
- "format_xml_order_tag": "Order",
- "format_xml_product_tag": "Product",
- "format_xml_coupon_tag": "Coupon",
- "format_xml_prepend_raw_xml": "",
- "format_xml_append_raw_xml": "",
- "format_xml_self_closing_tags": "1",
- "all_products_from_order": "1",
- "skip_refunded_items": "1",
- "skip_suborders": "0",
- "export_refunds": "0",
- "date_format": "Y-m-d",
- "time_format": "H:i",
- "sort_direction": "DESC",
- "sort": "order_id",
- "format_number_fields": "0",
- "export_all_comments": "0",
- "export_refund_notes": "0",
- "strip_tags_product_fields": "0",
- "cleanup_phone": "0",
- "enable_debug": "0",
- "format_json_start_tag": "[",
- "format_json_end_tag": "]",
- "custom_php": "0",
- "custom_php_code": "",
- "mark_exported_orders": "0",
- "export_unmarked_orders": "0",
- "summary_report_by_products": "0",
- "order_fields": {
- "line_number": {
- "checked": "0",
- "colname": "Line number",
- "label": "Line number",
- "segment": "common",
- "default": 1
- },
- "order_id": {
- "checked": "0",
- "colname": "Order ID",
- "label": "Order ID",
- "segment": "common",
- "default": 1
- },
- "order_number": {
- "checked": "1",
- "colname": "Order Number",
- "label": "Order Number",
- "segment": "common",
- "default": 1
- },
- "order_status": {
- "checked": "0",
- "colname": "Order Status",
- "label": "Order Status",
- "segment": "common",
- "default": 1
- },
- "order_date": {
- "checked": "1",
- "colname": "Order Date",
- "label": "Order Date",
- "segment": "common",
- "default": 1,
- "format": "date"
- },
- "modified_date": {
- "checked": "0",
- "colname": "Modification Date",
- "label": "Modification Date",
- "segment": "common",
- "default": 1,
- "format": "date"
- },
- "transaction_id": {
- "checked": "0",
- "colname": "Transaction ID",
- "label": "Transaction ID",
- "segment": "common",
- "default": 1
- },
- "completed_date": {
- "checked": "0",
- "colname": "Completed Date",
- "label": "Completed Date",
- "segment": "common",
- "default": 1,
- "format": "date"
- },
- "paid_date": {
- "checked": "0",
- "colname": "Paid Date",
- "label": "Paid Date",
- "segment": "common",
- "default": 1,
- "format": "date"
- },
- "first_refund_date": {
- "checked": "0",
- "colname": "Date of first refund",
- "label": "Date of first refund",
- "segment": "common",
- "default": 1,
- "format": "date"
- },
- "customer_note": {
- "checked": "0",
- "colname": "Customer Note",
- "label": "Customer Note",
- "segment": "common",
- "default": 1,
- "format": "string"
- },
- "order_notes": {
- "checked": "0",
- "colname": "Order Notes",
- "label": "Order Notes",
- "segment": "common",
- "default": 1,
- "format": "string"
- },
- "customer_ip_address": {
- "checked": "0",
- "colname": "Customer IP address",
- "label": "Customer IP address",
- "segment": "user",
- "default": 1
- },
- "customer_user": {
- "checked": "0",
- "colname": "Customer User ID",
- "label": "Customer User ID",
- "segment": "user",
- "default": 1
- },
- "user_login": {
- "checked": "0",
- "colname": "Customer Username",
- "label": "Customer Username",
- "segment": "user",
- "default": 1
- },
- "user_email": {
- "checked": "0",
- "colname": "Customer User Email",
- "label": "Customer User Email",
- "segment": "user",
- "default": 1
- },
- "user_role": {
- "checked": "0",
- "colname": "Customer Role",
- "label": "Customer Role",
- "segment": "user",
- "default": 1
- },
- "customer_total_orders": {
- "checked": "0",
- "colname": "Customer Total Orders",
- "label": "Customer Total Orders",
- "segment": "user",
- "default": 1
- },
- "billing_first_name": {
- "checked": "1",
- "colname": "First Name (Billing)",
- "label": "First Name (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_last_name": {
- "checked": "1",
- "colname": "Last Name (Billing)",
- "label": "Last Name (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_full_name": {
- "checked": "0",
- "colname": "Full Name (Billing)",
- "label": "Full Name (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_company": {
- "checked": "0",
- "colname": "Company (Billing)",
- "label": "Company (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_address": {
- "checked": "0",
- "colname": "Address 1&2 (Billing)",
- "label": "Address 1&2 (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_address_1": {
- "checked": "0",
- "colname": "Address 1 (Billing)",
- "label": "Address 1 (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_address_2": {
- "checked": "0",
- "colname": "Address 2 (Billing)",
- "label": "Address 2 (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_city": {
- "checked": "0",
- "colname": "City (Billing)",
- "label": "City (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_state": {
- "checked": "0",
- "colname": "State Code (Billing)",
- "label": "State Code (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_citystatezip": {
- "checked": "0",
- "colname": "City, State, Zip (Billing)",
- "label": "City, State, Zip (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_state_full": {
- "checked": "0",
- "colname": "State Name (Billing)",
- "label": "State Name (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_postcode": {
- "checked": "0",
- "colname": "Postcode (Billing)",
- "label": "Postcode (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_country": {
- "checked": "0",
- "colname": "Country Code (Billing)",
- "label": "Country Code (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_country_full": {
- "checked": "0",
- "colname": "Country Name (Billing)",
- "label": "Country Name (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_email": {
- "checked": "0",
- "colname": "Email (Billing)",
- "label": "Email (Billing)",
- "segment": "billing",
- "default": 1
- },
- "billing_phone": {
- "checked": "0",
- "colname": "Phone (Billing)",
- "label": "Phone (Billing)",
- "segment": "billing",
- "default": 1,
- "format": "string"
- },
- "shipping_first_name": {
- "checked": "0",
- "colname": "First Name (Shipping)",
- "label": "First Name (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_last_name": {
- "checked": "0",
- "colname": "Last Name (Shipping)",
- "label": "Last Name (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_full_name": {
- "checked": "0",
- "colname": "Full Name (Shipping)",
- "label": "Full Name (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_company": {
- "checked": "0",
- "colname": "Company (Shipping)",
- "label": "Company (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_address": {
- "checked": "0",
- "colname": "Address 1&2 (Shipping)",
- "label": "Address 1&2 (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_address_1": {
- "checked": "0",
- "colname": "Address 1 (Shipping)",
- "label": "Address 1 (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_address_2": {
- "checked": "0",
- "colname": "Address 2 (Shipping)",
- "label": "Address 2 (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_city": {
- "checked": "0",
- "colname": "City (Shipping)",
- "label": "City (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_state": {
- "checked": "0",
- "colname": "State Code (Shipping)",
- "label": "State Code (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_citystatezip": {
- "checked": "0",
- "colname": "City, State, Zip (Shipping)",
- "label": "City, State, Zip (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_state_full": {
- "checked": "0",
- "colname": "State Name (Shipping)",
- "label": "State Name (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_postcode": {
- "checked": "0",
- "colname": "Postcode (Shipping)",
- "label": "Postcode (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_country": {
- "checked": "0",
- "colname": "Country Code (Shipping)",
- "label": "Country Code (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "shipping_country_full": {
- "checked": "0",
- "colname": "Country Name (Shipping)",
- "label": "Country Name (Shipping)",
- "segment": "shipping",
- "default": 1
- },
- "products": {
- "checked": "0",
- "colname": "Products",
- "label": "Products",
- "repeat": "rows",
- "max_cols": "10",
- "segment": "product",
- "default": 1
- },
- "coupons": {
- "checked": "0",
- "colname": "Coupons",
- "label": "Coupons",
- "repeat": "rows",
- "max_cols": "10",
- "segment": "coupon",
- "default": 1
- },
- "shipping_method_title": {
- "checked": "0",
- "colname": "Shipping Method Title",
- "label": "Shipping Method Title",
- "segment": "cart",
- "default": 1
- },
- "shipping_method": {
- "checked": "0",
- "colname": "Shipping Method",
- "label": "Shipping Method",
- "segment": "cart",
- "default": 1
- },
- "payment_method_title": {
- "checked": "0",
- "colname": "Payment Method Title",
- "label": "Payment Method Title",
- "segment": "cart",
- "default": 1
- },
- "payment_method": {
- "checked": "0",
- "colname": "Payment Method",
- "label": "Payment Method",
- "segment": "cart",
- "default": 1
- },
- "coupons_used": {
- "checked": "0",
- "colname": "Coupons Used",
- "label": "Coupons Used",
- "segment": "cart",
- "default": 1
- },
- "cart_discount": {
- "checked": "0",
- "colname": "Cart Discount Amount",
- "label": "Cart Discount Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "cart_discount_tax": {
- "checked": "0",
- "colname": "Cart Discount Amount Tax",
- "label": "Cart Discount Amount Tax",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_subtotal": {
- "checked": "0",
- "colname": "Order Subtotal Amount",
- "label": "Order Subtotal Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_subtotal_minus_discount": {
- "checked": "0",
- "colname": "Order Subtotal - Cart Discount",
- "label": "Order Subtotal - Cart Discount",
- "segment": "cart",
- "default": 1
- },
- "order_subtotal_refunded": {
- "checked": "0",
- "colname": "Order Subtotal Amount Refunded",
- "label": "Order Subtotal Amount Refunded",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_subtotal_minus_refund": {
- "checked": "0",
- "colname": "Order Subtotal Amount (- Refund)",
- "label": "Order Subtotal Amount (- Refund)",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_tax": {
- "checked": "0",
- "colname": "Order Tax Amount",
- "label": "Order Tax Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping": {
- "checked": "0",
- "colname": "Order Shipping Amount",
- "label": "Order Shipping Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping_refunded": {
- "checked": "0",
- "colname": "Order Shipping Amount Refunded",
- "label": "Order Shipping Amount Refunded",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping_minus_refund": {
- "checked": "0",
- "colname": "Order Shipping Amount (- Refund)",
- "label": "Order Shipping Amount (- Refund)",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping_tax": {
- "checked": "0",
- "colname": "Order Shipping Tax Amount",
- "label": "Order Shipping Tax Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping_tax_refunded": {
- "checked": "0",
- "colname": "Order Shipping Tax Refunded",
- "label": "Order Shipping Tax Refunded",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_shipping_tax_minus_refund": {
- "checked": "0",
- "colname": "Order Shipping Tax Amount (- Refund)",
- "label": "Order Shipping Tax Amount (- Refund)",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_refund": {
- "checked": "0",
- "colname": "Order Refund Amount",
- "label": "Order Refund Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total_inc_refund": {
- "checked": "0",
- "colname": "Order Total Amount (- Refund)",
- "label": "Order Total Amount (- Refund)",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total": {
- "checked": "1",
- "colname": "Order Total Amount",
- "label": "Order Total Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total_no_tax": {
- "checked": "0",
- "colname": "Order Total Amount without Tax",
- "label": "Order Total Amount without Tax",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total_tax": {
- "checked": "0",
- "colname": "Order Total Tax Amount",
- "label": "Order Total Tax Amount",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total_tax_refunded": {
- "checked": "0",
- "colname": "Order Total Tax Amount Refunded",
- "label": "Order Total Tax Amount Refunded",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_total_tax_minus_refund": {
- "checked": "0",
- "colname": "Order Total Tax Amount (- Refund)",
- "label": "Order Total Tax Amount (- Refund)",
- "segment": "cart",
- "default": 1,
- "format": "money"
- },
- "order_currency": {
- "checked": "0",
- "colname": "Currency",
- "label": "Currency",
- "segment": "cart",
- "default": 1
- },
- "total_weight_items": {
- "checked": "0",
- "colname": "Total weight",
- "label": "Total weight",
- "segment": "misc",
- "default": 1,
- "format": "number"
- },
- "count_total_items": {
- "checked": "0",
- "colname": "Total items",
- "label": "Total items",
- "segment": "misc",
- "default": 1
- },
- "count_unique_products": {
- "checked": "0",
- "colname": "Total products",
- "label": "Total products",
- "segment": "misc",
- "default": 1
- }
- },
- "order_product_fields": {
- "item_id": {
- "checked": "0",
- "colname": "Item ID",
- "label": "Item ID",
- "default": 1
- },
- "line_id": {
- "checked": "1",
- "colname": "Item #",
- "label": "Item #",
- "default": 1
- },
- "sku": {
- "checked": "1",
- "colname": "SKU",
- "label": "SKU",
- "default": 1
- },
- "name": {
- "checked": "1",
- "colname": "Item Name",
- "label": "Item Name",
- "default": 1
- },
- "product_name": {
- "checked": "0",
- "colname": "Product Name",
- "label": "Product Name",
- "default": 1
- },
- "product_variation": {
- "checked": "0",
- "colname": "Product Variation",
- "label": "Product Variation",
- "default": 1
- },
- "seller": {
- "checked": "0",
- "colname": "Item Seller",
- "label": "Item Seller",
- "default": 1
- },
- "qty": {
- "checked": "1",
- "colname": "Quantity",
- "label": "Quantity",
- "default": 1
- },
- "qty_minus_refund": {
- "checked": "0",
- "colname": "Quantity (- Refund)",
- "label": "Quantity (- Refund)",
- "default": 1
- },
- "item_price": {
- "checked": "1",
- "colname": "Item Cost",
- "label": "Item Cost",
- "default": 1,
- "format": "money"
- },
- "price": {
- "checked": "0",
- "colname": "Product Current Price",
- "label": "Product Current Price",
- "default": 1,
- "format": "money"
- },
- "line_no_tax": {
- "checked": "0",
- "colname": "Order Line (w\/o tax)",
- "label": "Order Line (w\/o tax)",
- "default": 1,
- "format": "money"
- },
- "line_tax": {
- "checked": "0",
- "colname": "Order Line Tax",
- "label": "Order Line Tax",
- "default": 1,
- "format": "money"
- },
- "line_tax_refunded": {
- "checked": "0",
- "colname": "Order Line Tax Refunded",
- "label": "Order Line Tax Refunded",
- "default": 1,
- "format": "money"
- },
- "line_tax_minus_refund": {
- "checked": "0",
- "colname": "Order Line Tax (- Refund)",
- "label": "Order Line Tax (- Refund)",
- "default": 1,
- "format": "money"
- },
- "line_subtotal": {
- "checked": "0",
- "colname": "Order Line Subtotal",
- "label": "Order Line Subtotal",
- "default": 1,
- "format": "money"
- },
- "line_total": {
- "checked": "0",
- "colname": "Order Line Total",
- "label": "Order Line Total",
- "default": 1,
- "format": "money"
- },
- "line_total_plus_tax": {
- "checked": "0",
- "colname": "Order Line Total (include tax)",
- "label": "Order Line Total (include tax)",
- "default": 1,
- "format": "money"
- },
- "line_total_refunded": {
- "checked": "0",
- "colname": "Order Line Total Refunded",
- "label": "Order Line Total Refunded",
- "default": 1,
- "format": "money"
- },
- "line_total_minus_refund": {
- "checked": "0",
- "colname": "Order Line Total (- Refund)",
- "label": "Order Line Total (- Refund)",
- "default": 1,
- "format": "money"
- },
- "discount_amount": {
- "checked": "0",
- "colname": "Item Discount Amount",
- "label": "Item Discount Amount",
- "default": 1,
- "format": "money"
- },
- "tax_rate": {
- "checked": "0",
- "colname": "Item Tax Rate",
- "label": "Item Tax Rate",
- "default": 1,
- "format": "number"
- },
- "type": {
- "checked": "0",
- "colname": "Type",
- "label": "Type",
- "default": 1
- },
- "category": {
- "checked": "0",
- "colname": "Category",
- "label": "Category",
- "default": 1
- },
- "tags": {
- "checked": "0",
- "colname": "Tags",
- "label": "Tags",
- "default": 1
- },
- "width": {
- "checked": "0",
- "colname": "Width",
- "label": "Width",
- "default": 1,
- "format": "number"
- },
- "length": {
- "checked": "0",
- "colname": "Length",
- "label": "Length",
- "default": 1,
- "format": "number"
- },
- "height": {
- "checked": "0",
- "colname": "Height",
- "label": "Height",
- "default": 1,
- "format": "number"
- },
- "weight": {
- "checked": "0",
- "colname": "Weight",
- "label": "Weight",
- "default": 1,
- "format": "number"
- },
- "product_url": {
- "checked": "0",
- "colname": "Product URL",
- "label": "Product URL",
- "default": 1
- },
- "download_url": {
- "checked": "0",
- "colname": "Download URL",
- "label": "Download URL",
- "default": 1
- },
- "image_url": {
- "checked": "0",
- "colname": "Image URL",
- "label": "Image URL",
- "default": 1
- },
- "product_shipping_class": {
- "checked": "0",
- "colname": "Product Shipping Class",
- "label": "Product Shipping Class",
- "default": 1
- },
- "post_content": {
- "checked": "0",
- "colname": "Description",
- "label": "Description",
- "default": 1
- },
- "post_excerpt": {
- "checked": "0",
- "colname": "Short Description",
- "label": "Short Description",
- "default": 1
- },
- "full_category_names": {
- "checked": "0",
- "colname": "Full names for categories",
- "label": "Full names for categories",
- "default": 1
- }
- },
- "order_coupon_fields": {
- "code": {
- "checked": "1",
- "colname": "Coupon Code",
- "label": "Coupon Code",
- "default": 1
- },
- "discount_amount": {
- "checked": "1",
- "colname": "Discount Amount",
- "label": "Discount Amount",
- "default": 1,
- "format": "money"
- },
- "discount_amount_tax": {
- "checked": "1",
- "colname": "Discount Amount Tax",
- "label": "Discount Amount Tax",
- "default": 1,
- "format": "money"
- },
- "discount_amount_plus_tax": {
- "checked": "0",
- "colname": "Discount Amount + Tax",
- "label": "Discount Amount + Tax",
- "default": 1
- },
- "excerpt": {
- "checked": "0",
- "colname": "Coupon Description",
- "label": "Coupon Description",
- "default": 1
- },
- "discount_type": {
- "checked": "0",
- "colname": "Coupon Type",
- "label": "Coupon Type",
- "default": 1
- },
- "coupon_amount": {
- "checked": "0",
- "colname": "Coupon Amount",
- "label": "Coupon Amount",
- "default": 1,
- "format": "money"
- }
- },
- "id": "0",
- "export_rule_field": "date",
- "export_filename": "orders-%y-%m-%d-%h-%i-%s.xlsx"
- },
- "profiles": [],
- "cron": [],
- "order-action": []
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement