表头:
id created_at base_total_invoiced subtotal_incl_tax subtotal_invoiced base_shipping_incl_tax total_online_refunded base_total_refunded tax_amount tax_invoiced tax_refunded customer_email status sku
sql:
select so.increment_id as id,so.created_at,so.base_total_invoiced,so.subtotal_incl_tax,so.subtotal_invoiced,so.base_shipping_incl_tax,so.total_online_refunded,so.base_total_refunded,so.tax_amount,so.tax_invoiced,so.tax_refunded,so.customer_email,so.status, soi.sku from sales_order so,sales_order_item soi where so.entity_id=soi.order_id GROUP BY so.increment_id;
可以扩展成后台插件