LTV Numbers
LTV Numbers
Search
⌃K

[Deprecated] WooCommerce

DEPRECATED

This method is no longer maintained, supported, or recommended. Only use this method in special cases.

​

For most cases, use the method outlined here.

Set Up Webhooks

Webhooks pull your sales data in real time and should be set up first before importing historical sales data to avoid gaps in your data
  1. 1.
  2. 2.
    In LTV Numbers’ side navigation bar, go to the "Settings" tab
  3. 3.
    Click the "Copy" button for your Webhook URL in the “Clickfunnels Integrations” section. You will paste this into WooCommerce at a later step
  4. 4.
    In a separate browser window or tab, log into your WooCommerce store
  5. 5.
    In the left menu, go to WooCommerce, then Settings
  6. 6.
    Go to Advanced then Webhooks
  7. 7.
    Click Add Webhook and fill the fields as described below:
    • Name: LTV Numbers
    • Status: Active
    • Topic: Order updated
    • Delivery URL:
      • Paste the Webhook URL you copied from LTV Numbers earlier into this field and edit the Webhook URL by replacing "clickfunnels" with "woocommerce"
    • Secret:
      • Leave blank
    • API Version:
      • Most recent version
  8. 8.
    Click Save webhook

Historical Sales Data

After setting up webhooks to pull in real time sales data, import your past sales for a complete picture of your data.

Export Historical Sales Data from WooCommerce

  1. 2.
    Activate the "Advanced Order Export For WooCommerce" plugin
  2. 3.
    In the left menu, go to Export Orders under WooCommerce
  3. 4.
    Set up the export settings as follows:
    • Date Range: select the date range of the data you wish to analyze with LTV Numbers
    • Format: CSV
    • Filter Order By: check Export Refunds
    • Order statuses: Completed, Refunded, Processing, Cancelled
    • Set up fields to export: ensure all of the fields listed in the expanding section below are included in the list of fields to be exported on the left side of the exporter
      • If these fields are not present, add them by finding them in their section, then dragging and dropping them into the exported fields list
      • Once added, click the Save Settings button
  4. 5.
    Click the Export button to begin the export of your all time WooCommerce sales data
  5. 6.
    Once the export is finished, save it to your computer
Fields To Include In The Exported Fields List
  • Product order items:
    • Item ID
    • Item Name
    • Item Cost
    • Quantity
    • Order Line Total (include tax)
  • Products:
    • Product ID
  • Common:
    • Order ID
    • Order Status
    • Date Paid
    • Order Date
    • Currency
  • Billing Address:
    • Email (Billing)
    • Full Name (Billing)
    • Country Code (Billing)
  • Customer:
    • Customer IP address

Import WooCommerce Historical Data Into LTV Numbers

  1. 1.
    In LTV Numbers' side menu, click "Upload" to get to the Data Uploader
  2. 2.
    Click the "Choose File" button
  3. 3.
    Select the historical sales data CSV from the previous section and click Next
    • Note: if you have multiple files of the same format, you can multiselect them to upload them all at once. Do not mix formats.
  4. 4.
    In the "Choose Format" dropdown, select "WooCommerce Advanced Order Export CSV"
  5. 5.
    Click Next then Upload to begin the ingest process
    • Note: this process may take some time to complete

WooCommerce Limitations

  • WooCommerce does not collect UTMs by default
    • Third party plugins such as "HandL UTM Grabber v3" can enable UTM tracking and analysis going forward. It is impossible to recover UTMs from before setup as they have not been saved.
  • Refunds are applied at the order level so they are not attributed to any particular product. WooCommerce refunds will instead be grouped into a product named "WooCommerce Order Refund". Thus a product's net revenue as displayed in LTV Numbers does not include refunds and will therefore be equivalent to gross revenue.
Last modified 8mo ago