#WOOCOMMERCE CSV EXPORTER HOW TO#
#WOOCOMMERCE CSV EXPORTER CODE#
#WOOCOMMERCE CSV EXPORTER DOWNLOAD#

Refund Reason: The reason for the refund.

Refund Amounts: The value of each refund applied to the order.

Refund ID: The post ID of the refund, automatically assigned by WooCommerce when the refund is processed.

Refund Total: Exports a numerical value with the total amount being refunded, for example, 12.69.

A pipe character is used to separate multiple refunds: Refunds applied to WooCommerce orders appear in the Available Data › Refunds.

Note User Email: Exports the email address of the note's author.

Note User Name: Exports the username of the note's author.

Note Visibility: Exports the note's visibility.

Note Date: Exports the date when the note was made.

Note Content: Exports the note's content as a text string.

Multiple notes on the same order are separated by a pipe character: Notes attached to WooCommerce orders are found in Available Data › Notes. When empty, exports an empty serialized array such as a:2.

Item Tax Data: Exports a serialized array that contains the subtotal and total tax.

Item Tax Total: Total tax for the item(s).

Item Total: Item cost multiplied by quantity, it's the total amount for each purchased item(s) without taxes or shipping.

Product Variation Details: If the product has variations, this exports its attribute's name (in the column header) and its attribute's value if there are multiple attributes on a single product, each attribute gets its own column.

Product Name: The product's name, or the parent product for variations.

#WOOCOMMERCE CSV EXPORTER CODE#

SKU: The product code used to reference and differentiate products.

For variable products, this would be the post ID of the variation purchased, not the parent product.

Product ID: The post ID of the product, automatically assigned by WordPress.

The products purchased in WooCommerce orders are found in Available Data › Items. Both sets of addresses are organized in the same way:

Customer Note: Notes left by site administrators about the customer.Įvery customer in WooCommerce has a billing address and a shipping address added as custom user meta.

Customer User ID: If the customer is registered on the site, this exports their numerical WordPress user ID.

Order Total: Total amount the client has to pay, for example, 105.15.Ĭustomer information for WooCommerce orders is located in Available Data › Customer:.

Payment Method Title: The name of the payment method chosen by the client, for example, PayPal.

Order Currency: The currency in which the order was placed, for example, USD.

The possible WooCommerce order statuses are wc-completed, wc-pending, wc-processing, wc-on-hold, and wc-cancelled.

Order Status: The order's current status.

Completed Date: The date when the order was completed, in Y-m-d H:i:s format.

Order Date: The date when the order was placed, in Y-m-d H:i:s format.

Order Key: An order code used to differentiate orders within WooCommerce.

Order ID: The Order ID as assigned by WordPress.

WooCommerce Order Dataīasic WooCommerce order information is found under Available Data › Order. The available export fields are categorized into the following sections: Order, Customer, Items, Taxes & Shipping, Fees & Discounts, Notes, Refunds, Custom Fields, and Other. To remove a column, drag it out of the selection area and drop it on another part of the interface. To include a field as a column in the order export file, simply drag the field into the column selection area: WP All Export lets you choose your order export columns using a simple Drag & Drop interface.Īll of the relevant order tables and fields are listed in the Available Data section on the right. Most WooCommerce order exports require only a subset of the order columns. Step 2: Select Your WooCommerce Order Export Columns Go to All Export › New Export and choose to export WooCommerce Orders. Step 1: Create a New Export for WooCommerce Orders

#WOOCOMMERCE CSV EXPORTER DOWNLOAD#

Use the drag and drop tool to build the order export, then run the export and download the file. To export orders, go to WP All Export › New Export and select WooCommerce Orders. If you are looking for a broader description of these capabilities, please see Export WooCommerce Orders.

#WOOCOMMERCE CSV EXPORTER HOW TO#

This page shows you how to export WooCommerce orders using WP All Export.

Woocommerce csv exporter