WooCommerce Code Reference

WC_Order_Data_Store_CPT extends Abstract_WC_Order_Data_Store_CPT
in package
implements WC_Object_Data_Store_Interface, WC_Order_Data_Store_Interface

WC Order Data Store: Stored in CPT.

Tags
version
3.0.0

Interfaces, Classes and Traits

WC_Object_Data_Store_Interface
Object Data Store Interface
WC_Order_Data_Store_Interface
Order Data Store Interface

Table of Contents

$internal_meta_keys  : array
Data stored in meta keys, but not considered "meta" for an order.
$meta_type  : string
Meta type. This should match up with the types available at https://developer.wordpress.org/reference/functions/add_metadata/.
$must_exist_meta_keys  : array
Meta data which should exist in the DB, even if empty.
$object_id_field_for_meta  : string
This only needs set if you are using a custom metadata type (for example payment tokens.
add_meta()  : int
Add new piece of meta.
create()  : mixed
Method to create a new order in the database.
delete()  : void
Method to delete an order from the database.
delete_from_lookup_table()  : mixed
Delete lookup table data for an ID.
delete_items()  : mixed
Remove all line items (products, coupons, shipping, taxes) from the order.
delete_meta()  : mixed
Deletes meta based on meta ID.
get_coupon_held_keys()  : array|string
Return array of coupon_code => meta_key for coupon which have usage limit and have tentative keys.
get_coupon_held_keys_for_users()  : mixed
Return array of coupon_code => meta_key for coupon which have usage limit per customer and have tentative keys.
get_download_permissions_granted()  : bool
Gets information about whether permissions were generated yet.
get_internal_meta_keys()  : array
Return list of internal meta keys.
get_order_count()  : int
Return count of orders with a specific status.
get_order_id_by_order_key()  : int
Finds an Order ID based on an order key.
get_order_item_type()  : string
Return the order type of a given item which belongs to WC_Order.
get_order_type()  : string
Get the order type based on Order ID.
get_orders()  : array|object
Get all orders matching the passed in args.
get_payment_token_ids()  : array
Get token ids for an order.
get_recorded_coupon_usage_counts()  : bool
Gets information about whether coupon counts were updated.
get_recorded_sales()  : bool
Gets information about whether sales were recorded.
get_stock_reduced()  : bool
Gets information about whether stock was reduced.
get_total_refunded()  : float
Get amount already refunded.
get_total_shipping_refunded()  : float
Get the total shipping refunded.
get_total_tax_refunded()  : float
Get the total tax refunded.
get_unpaid_orders()  : array
Get unpaid orders after a certain date,
parse_date_for_wp_query()  : array
Map a valid date query var to WP_Query arguments.
query()  : array|object
Query for Orders matching specific criteria.
read()  : mixed
Method to read an order from the database.
read_items()  : array
Read order items of a specific type from the database for this order.
read_meta()  : array
Returns an array of meta for an object.
release_held_coupons()  : mixed
Release all coupons held by this order.
search_orders()  : array
Search order data for a term and return ids.
set_coupon_held_keys()  : mixed
Add/Update list of meta keys that are currently being used by this order to hold a coupon.
set_download_permissions_granted()  : mixed
Stores information about whether permissions were generated yet.
set_recorded_coupon_usage_counts()  : mixed
Stores information about whether coupon counts were updated.
set_recorded_sales()  : mixed
Stores information about whether sales were recorded.
set_stock_reduced()  : mixed
Stores information about whether stock was reduced.
update()  : mixed
Method to update an order in the database.
update_meta()  : mixed
Update meta.
update_payment_token_ids()  : mixed
Update token ids for an order.
clear_caches()  : mixed
Clear any caches.
exclude_internal_meta_keys()  : bool
Callback to remove unwanted meta data.
get_data_for_lookup_table()  : array
Get data to save to a lookup table.
get_db_info()  : array
Table structure is slightly different between meta types, this function will return what we need to know.
get_order_key()  : string
Get order key.
get_post_excerpt()  : string
Excerpt for post.
get_post_status()  : string
Get the status to save to the post object.
get_post_title()  : string
Get a title for the new post type.
get_primary_key_for_lookup_table()  : string
Get primary key name for lookup table.
get_props_to_update()  : array
Gets a list of props and meta keys that need updated based on change state or if they are present in the database or not.
get_search_stopwords()  : array
Retrieve stopwords used when parsing search terms.
get_term_ids()  : array
Get and store terms from a taxonomy.
get_valid_search_terms()  : array
Check if the terms are suitable for searching.
get_wp_query_args()  : array
Get valid WP_Query args from a WC_Order_Query's query variables.
prefix_key()  : string
Internal meta keys we don't want exposed as part of meta_data. This is in addition to all data props with _ prefix.
read_order_data()  : mixed
Read order data. Can be overridden by child classes to load other props.
update_lookup_table()  : null
Update a lookup table for an object.
update_or_delete_post_meta()  : bool
Update meta data in, or delete it from, the database.
update_post_meta()  : mixed
Helper method that updates all the post meta for an order based on it's settings in the WC_Order class.
get_orders_generate_customer_meta_query()  : array
Generate meta query for wc_get_orders.

Properties

$internal_meta_keys

Data stored in meta keys, but not considered "meta" for an order.

protected array $internal_meta_keys = array('_customer_user', '_order_key', '_order_currency', '_billing_first_name', '_billing_last_name', '_billing_company', '_billing_address_1', '_billing_address_2', '_billing_city', '_billing_state', '_billing_postcode', '_billing_country', '_billing_email', '_billing_phone', '_shipping_first_name', '_shipping_last_name', '_shipping_company', '_shipping_address_1', '_shipping_address_2', '_shipping_city', '_shipping_state', '_shipping_postcode', '_shipping_country', '_completed_date', '_paid_date', '_edit_lock', '_edit_last', '_cart_discount', '_cart_discount_tax', '_order_shipping', '_order_shipping_tax', '_order_tax', '_order_total', '_payment_method', '_payment_method_title', '_transaction_id', '_customer_ip_address', '_customer_user_agent', '_created_via', '_order_version', '_prices_include_tax', '_date_completed', '_date_paid', '_payment_tokens', '_billing_address_index', '_shipping_address_index', '_recorded_sales', '_recorded_coupon_usage_counts', '_download_permissions_granted', '_order_stock_reduced')
Tags
since
3.0.0

$meta_type

Meta type. This should match up with the types available at https://developer.wordpress.org/reference/functions/add_metadata/.

protected string $meta_type = 'post'

WP defines 'post', 'user', 'comment', and 'term'.

$object_id_field_for_meta

This only needs set if you are using a custom metadata type (for example payment tokens.

protected string $object_id_field_for_meta = ''

This should be the name of the field your table uses for associating meta with objects. For example, in payment_tokenmeta, this would be payment_token_id.

Methods

delete_from_lookup_table()

Delete lookup table data for an ID.

public delete_from_lookup_table(int $id, string $table) : mixed
Parameters
$id : int

ID of object to update.

$table : string

Lookup table name.

Tags
since
3.6.0
Return values
mixed

get_coupon_held_keys()

Return array of coupon_code => meta_key for coupon which have usage limit and have tentative keys.

public get_coupon_held_keys(WC_Order $order[, int $coupon_id = null ]) : array|string

Pass $coupon_id if key for only one of the coupon is needed.

Parameters
$order : WC_Order

Order object.

$coupon_id : int = null

If passed, will return held key for that coupon.

Return values
array|stringKey value pair for coupon code and meta key name. If $coupon_id is passed, returns meta_key for only that coupon.

get_coupon_held_keys_for_users()

Return array of coupon_code => meta_key for coupon which have usage limit per customer and have tentative keys.

public get_coupon_held_keys_for_users(WC_Order $order[, int $coupon_id = null ]) : mixed
Parameters
$order : WC_Order

Order object.

$coupon_id : int = null

If passed, will return held key for that coupon.

Return values
mixed

get_order_count()

Return count of orders with a specific status.

public get_order_count(string $status) : int
Parameters
$status : string

Order status. Function wc_get_order_statuses() returns a list of valid statuses.

Return values
int

get_order_id_by_order_key()

Finds an Order ID based on an order key.

public get_order_id_by_order_key(string $order_key) : int
Parameters
$order_key : string

An order key has generated by.

Return values
intThe ID of an order, or 0 if the order could not be found

get_order_item_type()

Return the order type of a given item which belongs to WC_Order.

public get_order_item_type(WC_Order $order, int $order_item_id) : string
Parameters
$order : WC_Order

Order Object.

$order_item_id : int

Order item id.

Tags
since
3.2.0
Return values
stringOrder Item type

get_orders()

Get all orders matching the passed in args.

public get_orders([array $args = array() ]) : array|object
Parameters
$args : array = array()

List of args passed to wc_get_orders().

Tags
deprecated
3.1.0
  • Use wc_get_orders instead.
see
wc_get_orders()
Return values
array|object

parse_date_for_wp_query()

Map a valid date query var to WP_Query arguments.

public parse_date_for_wp_query(mixed $query_var, string $key[, array $wp_query_args = array() ]) : array

Valid date formats: YYYY-MM-DD or timestamp, possibly combined with an operator from $valid_operators. Also accepts a WC_DateTime object.

Parameters
$query_var : mixed

A valid date format.

$key : string

meta or db column key.

$wp_query_args : array = array()

WP_Query args.

Tags
since
3.2.0
Return values
arrayModified $wp_query_args

query()

Query for Orders matching specific criteria.

public query(array $query_vars) : array|object
Parameters
$query_vars : array

query vars from a WC_Order_Query.

Tags
since
3.1.0
Return values
array|object

release_held_coupons()

Release all coupons held by this order.

public release_held_coupons(WC_Order $order[, bool $save = true ]) : mixed
Parameters
$order : WC_Order

Current order object.

$save : bool = true

Whether to delete keys from DB right away. Could be useful to pass false if you are building a bulk request.

Return values
mixed

set_coupon_held_keys()

Add/Update list of meta keys that are currently being used by this order to hold a coupon.

public set_coupon_held_keys(WC_Order $order, array $held_keys, array $held_keys_for_user) : mixed

This is used to figure out what all meta entries we should delete when order is cancelled/completed.

Parameters
$order : WC_Order

Order object.

$held_keys : array

Array of coupon_code => meta_key.

$held_keys_for_user : array

Array of coupon_code => meta_key for held coupon for user.

Return values
mixed

set_download_permissions_granted()

Stores information about whether permissions were generated yet.

public set_download_permissions_granted(WC_Order|int $order, bool $set) : mixed
Parameters
$order : WC_Order|int

Order ID or order object.

$set : bool

True or false.

Return values
mixed

exclude_internal_meta_keys()

Callback to remove unwanted meta data.

protected exclude_internal_meta_keys(object $meta) : bool
Parameters
$meta : object

Meta object to check if it should be excluded or not.

Return values
bool

get_data_for_lookup_table()

Get data to save to a lookup table.

protected get_data_for_lookup_table(int $id, string $table) : array
Parameters
$id : int

ID of object to update.

$table : string

Lookup table name.

Tags
since
3.6.0
Return values
array

get_db_info()

Table structure is slightly different between meta types, this function will return what we need to know.

protected get_db_info() : array
Tags
since
3.0.0
Return values
arrayArray elements: table, object_id_field, meta_id_field

get_post_status()

Get the status to save to the post object.

protected get_post_status(WC_order $order) : string

Plugins extending the order classes can override this to change the stored status/add prefixes etc.

Parameters
$order : WC_order

Order object.

Tags
since
3.6.0
Return values
string

get_primary_key_for_lookup_table()

Get primary key name for lookup table.

protected get_primary_key_for_lookup_table(string $table) : string
Parameters
$table : string

Lookup table name.

Tags
since
3.6.0
Return values
string

get_props_to_update()

Gets a list of props and meta keys that need updated based on change state or if they are present in the database or not.

protected get_props_to_update(WC_Data $object, array $meta_key_to_props[, string $meta_type = 'post' ]) : array
Parameters
$object : WC_Data

The WP_Data object (WC_Coupon for coupons, etc).

$meta_key_to_props : array

A mapping of meta keys => prop names.

$meta_type : string = 'post'

The internal WP meta type (post, user, etc).

Return values
arrayA mapping of meta keys => prop names, filtered by ones that should be updated.

get_term_ids()

Get and store terms from a taxonomy.

protected get_term_ids(WC_Data|int $object, string $taxonomy) : array
Parameters
$object : WC_Data|int

WC_Data object or object ID.

$taxonomy : string

Taxonomy name e.g. product_cat.

Tags
since
3.0.0
Return values
arrayof terms

get_valid_search_terms()

Check if the terms are suitable for searching.

protected get_valid_search_terms(array $terms) : array

Uses an array of stopwords (terms) that are excluded from the separate term matching when searching for posts. The list of English stopwords is the approximate search engines list, and is translatable.

Parameters
$terms : array

Terms to check.

Tags
since
3.4.0
Return values
arrayTerms that are not stopwords.

get_wp_query_args()

Get valid WP_Query args from a WC_Order_Query's query variables.

protected get_wp_query_args(array $query_vars) : array
Parameters
$query_vars : array

query vars from a WC_Order_Query.

Tags
since
3.1.0
Return values
array

prefix_key()

Internal meta keys we don't want exposed as part of meta_data. This is in addition to all data props with _ prefix.

protected prefix_key(string $key) : string
Parameters
$key : string

Prefix to be added to meta keys.

Tags
since
2.6.0
Return values
string

update_lookup_table()

Update a lookup table for an object.

protected update_lookup_table(int $id, string $table) : null
Parameters
$id : int

ID of object to update.

$table : string

Lookup table name.

Tags
since
3.6.0
Return values
null

update_or_delete_post_meta()

Update meta data in, or delete it from, the database.

protected update_or_delete_post_meta(WC_Data $object, string $meta_key, mixed $meta_value) : bool

Avoids storing meta when it's either an empty string or empty array. Other empty values such as numeric 0 and null should still be stored. Data-stores can force meta to exist using must_exist_meta_keys.

Note: WordPress get_metadata function returns an empty string when meta data does not exist.

Parameters
$object : WC_Data

The WP_Data object (WC_Coupon for coupons, etc).

$meta_key : string

Meta key to update.

$meta_value : mixed

Value to save.

Tags
since
3.6.0

Added to prevent empty meta being stored unless required.

Return values
boolTrue if updated/deleted.

get_orders_generate_customer_meta_query()

Generate meta query for wc_get_orders.

private get_orders_generate_customer_meta_query(array $values[, string $relation = 'or' ]) : array
Parameters
$values : array

List of customers ids or emails.

$relation : string = 'or'

'or' or 'and' relation used to build the WP meta_query.

Return values
array