Autoship Customer Metrics User Metadata Fields

The Autoship Cloud plugin can synchronize your customer metrics data from QPilot to your site's database, so it can be used "on demand" without needing to make a request to the QPilot API. These fields by default are saved to the wp_usermeta table in your site's database under the following keys (which can be customized using the autoship_customer_metrics_fields_mapping filter):

  • autoship_customer_created_date_utc  - The date the customer was created in QPilot (UTC Datetime)

  • autoship_first_scheduled_order_created_utc - The date the customer created their first Scheduled Order (checkout, My-Account > Scheduled Orders, or admin created) (UTC Datetime)

  • autoship_total_scheduled_orders_active - The count of Scheduled Orders for customer with a status of "Active"

  • autoship_total_scheduled_orders_active_value - The total value of Scheduled Orders for customer with a status of "Active"

  • autoship_total_scheduled_orders_paused - The count of Scheduled Orders for customer with a status of "Paused"

  • autoship_total_scheduled_orders_paused_value - The total value of Scheduled Orders for customer with a status of "Paused"

  • autoship_total_scheduled_orders_failed - The count of Scheduled Orders for customer with a status of "Failed"

  • autoship_total_scheduled_orders_failed_value - The total value of Scheduled Orders for customer with a status of "Failed"

  • autoship_total_scheduled_orders_deleted - The count of Scheduled Orders for customer with a status of "Deleted"

  • autoship_total_scheduled_orders_deleted_value - The total value of Scheduled Orders for customer with a status of "Deleted"

  • autoship_total_scheduled_orders_lifetime_value - The total lifetime value for customer's Scheduled Orders

  • autoship_average_processing_cycle_value - The average value of a customer's Scheduled Orders for each processing cycle

  • autoship_last_successful_processing_cycle_date - The datetime of the last time a Scheduled Order processed successfully for customer

  • autoship_last_failed_processing_cycle_date - The datetime of the last time a Scheduled Order failed processing for customer

  • autoship_total_successful_processing_cycles - The count of successful processing cycles for the customer

  • autoship_total_products_purchased - The total amount of unique products that have processed as part of a Scheduled Order for customer

  • autoship_first_products_purchased - The product titles of the products on a customer's first Scheduled Order

  • autoship_all_products_purchased - The product titles of all the products that have successfully processed on a customer's Scheduled Order(s)