Introduction

Datasources and destinations

Fields listing for WooCommerce

Product Id
Unique identifier for the resource. read-only
Field IDproduct/id
TypeNUMBER
Data Typedimension
Product Name
Product name.
Field IDproduct/name
TypeTEXT
Data Typedimension
Product Slug
Product slug.
Field IDproduct/slug
TypeTEXT
Data Typedimension
Product Permalink
Product URL. read-only
Field IDproduct/permalink
TypeTEXT
Data Typedimension
Product Date Created
The date the product was created, in the site's timezone. read-only
Field IDproduct/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date Created Gmt
The date the product was created, as GMT. read-only
Field IDproduct/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date Modified
The date the product was last modified, in the site's timezone. read-only
Field IDproduct/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date Modified Gmt
The date the product was last modified, as GMT. read-only
Field IDproduct/date_modified_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Type
Product type. Options: simple, grouped, external and variable. Default is simple.
Field IDproduct/type
TypeTEXT
Data Typedimension
Product Status
Product status (post status). Options: draft, pending, private and publish. Default is publish.
Field IDproduct/status
TypeTEXT
Data Typedimension
Product Featured
Featured product. Default is false.
Field IDproduct/featured
TypeBOOLEAN
Data Typedimension
Product Catalog Visibility
Catalog visibility. Options: visible, catalog, search and hidden. Default is visible.
Field IDproduct/catalog_visibility
TypeTEXT
Data Typedimension
Product Description
Product description.
Field IDproduct/description
TypeTEXT
Data Typedimension
Product Short Description
Product short description.
Field IDproduct/short_description
TypeTEXT
Data Typedimension
Product Sku
Unique identifier.
Field IDproduct/sku
TypeTEXT
Data Typedimension
Product Price
Current product price. read-only
Field IDproduct/price
TypeNUMBER
Data Typedimension
Product Regular Price
Product regular price.
Field IDproduct/regular_price
TypeNUMBER
Data Typedimension
Product Sale Price
Product sale price.
Field IDproduct/sale_price
TypeNUMBER
Data Typedimension
Product Date On Sale From
Start date of sale price, in the site's timezone.
Field IDproduct/date_on_sale_from
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date On Sale From Gmt
Start date of sale price, as GMT.
Field IDproduct/date_on_sale_from_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date On Sale To
End date of sale price, in the site's timezone.
Field IDproduct/date_on_sale_to
TypeYEAR_MONTH_DAY
Data Typedimension
Product Date On Sale To Gmt
End date of sale price, as GMT.
Field IDproduct/date_on_sale_to_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Price Html
Price formatted in HTML. read-only
Field IDproduct/price_html
TypeTEXT
Data Typedimension
Product On Sale
Shows if the product is on sale. read-only
Field IDproduct/on_sale
TypeBOOLEAN
Data Typedimension
Product Purchasable
Shows if the product can be bought. read-only
Field IDproduct/purchasable
TypeBOOLEAN
Data Typedimension
Product Total Sales
Amount of sales. read-only
Field IDproduct/total_sales
TypeNUMBER
Data Typedimension
Product Virtual
If the product is virtual. Default is false.
Field IDproduct/virtual
TypeBOOLEAN
Data Typedimension
Product Downloadable
If the product is downloadable. Default is false.
Field IDproduct/downloadable
TypeBOOLEAN
Data Typedimension
Product Downloads
List of downloadable files. See Product - Downloads properties
Field IDproduct/downloads
TypeTEXT
Data Typedimension
Product Download Limit
Number of times downloadable files can be downloaded after purchase. Default is -1.
Field IDproduct/download_limit
TypeNUMBER
Data Typedimension
Product Download Expiry
Number of days until access to downloadable files expires. Default is -1.
Field IDproduct/download_expiry
TypeNUMBER
Data Typedimension
Product External Url
Product external URL. Only for external products.
Field IDproduct/external_url
TypeTEXT
Data Typedimension
Product Button Text
Product external button text. Only for external products.
Field IDproduct/button_text
TypeTEXT
Data Typedimension
Product Tax Status
Tax status. Options: taxable, shipping and none. Default is taxable.
Field IDproduct/tax_status
TypeTEXT
Data Typedimension
Product Tax Class
Tax class.
Field IDproduct/tax_class
TypeTEXT
Data Typedimension
Product Manage Stock
Stock management at product level. Default is false.
Field IDproduct/manage_stock
TypeBOOLEAN
Data Typedimension
Product Stock Quantity
Stock quantity.
Field IDproduct/stock_quantity
TypeNUMBER
Data Typedimension
Product Stock Status
Controls the stock status of the product. Options: instock, outofstock, onbackorder. Default is instock.
Field IDproduct/stock_status
TypeTEXT
Data Typedimension
Product Backorders
If managing stock, this controls if backorders are allowed. Options: no, notify and yes. Default is no.
Field IDproduct/backorders
TypeTEXT
Data Typedimension
Product Backorders Allowed
Shows if backorders are allowed. read-only
Field IDproduct/backorders_allowed
TypeBOOLEAN
Data Typedimension
Product Backordered
Shows if the product is on backordered. read-only
Field IDproduct/backordered
TypeBOOLEAN
Data Typedimension
Product Sold Individually
Allow one item to be bought in a single order. Default is false.
Field IDproduct/sold_individually
TypeBOOLEAN
Data Typedimension
Product Weight
Product weight.
Field IDproduct/weight
TypeTEXT
Data Typedimension
Product height
Product height.
Field IDproduct/height
TypeTEXT
Data Typedimension
Product Length
Product Length.
Field IDproduct/length
TypeTEXT
Data Typedimension
Product Width
Product width.
Field IDproduct/width
TypeTEXT
Data Typedimension
Product Shipping Required
Shows if the product need to be shipped. read-only
Field IDproduct/shipping_required
TypeBOOLEAN
Data Typedimension
Product Shipping Taxable
Shows whether or not the product shipping is taxable. read-only
Field IDproduct/shipping_taxable
TypeBOOLEAN
Data Typedimension
Product Shipping Class
Shipping class slug.
Field IDproduct/shipping_class
TypeTEXT
Data Typedimension
Product Shipping Class Id
Shipping class ID. read-only
Field IDproduct/shipping_class_id
TypeNUMBER
Data Typedimension
Product Reviews Allowed
Allow reviews. Default is true.
Field IDproduct/reviews_allowed
TypeBOOLEAN
Data Typedimension
Product Average Rating
Reviews average rating. read-only
Field IDproduct/average_rating
TypeTEXT
Data Typedimension
Product Rating Count
Amount of reviews that the product have. read-only
Field IDproduct/rating_count
TypeNUMBER
Data Typedimension
Product Related Ids
List of related products IDs. read-only
Field IDproduct/related_ids
TypeTEXT
Data Typedimension
Product Upsell Ids
List of up-sell products IDs.
Field IDproduct/upsell_ids
TypeTEXT
Data Typedimension
Product Cross Sell Ids
List of cross-sell products IDs.
Field IDproduct/cross_sell_ids
TypeTEXT
Data Typedimension
Product Parent Id
Product parent ID.
Field IDproduct/parent_id
TypeNUMBER
Data Typedimension
Product Purchase Note
Optional note to send the customer after purchase.
Field IDproduct/purchase_note
TypeTEXT
Data Typedimension
Product Categories
List of categories. See Product - Categories properties
Field IDproduct/categories
TypeTEXT
Data Typedimension
Product Tags
List of tags. See Product - Tags properties
Field IDproduct/tags
TypeTEXT
Data Typedimension
Product Images
List of images. See Product - Images properties
Field IDproduct/images
TypeTEXT
Data Typedimension
Product Attributes
List of attributes. See Product - Attributes properties
Field IDproduct/attributes
TypeTEXT
Data Typedimension
Product Default Attributes
Defaults variation attributes. See Product - Default attributes properties
Field IDproduct/default_attributes
TypeTEXT
Data Typedimension
Product Variations
List of variations IDs. read-only
Field IDproduct/variations
TypeTEXT
Data Typedimension
Product Grouped Products
List of grouped products ID.
Field IDproduct/grouped_products
TypeTEXT
Data Typedimension
Product Menu Order
Menu order, used to custom sort products.
Field IDproduct/menu_order
TypeNUMBER
Data Typedimension
Coupon Id
Unique identifier for the object. read-only
Field IDcoupon/id
TypeTEXT
Data Typedimension
Coupon Code
Coupon code. mandatory
Field IDcoupon/code
TypeTEXT
Data Typedimension
Coupon Amount
The amount of discount. Should always be numeric, even if setting a percentage.
Field IDcoupon/amount
TypeNUMBER
Data Typedimension
Coupon Date Created
The date the coupon was created, in the site's timezone. read-only
Field IDcoupon/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Date Created Gmt
The date the coupon was created, as GMT. read-only
Field IDcoupon/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Date Modified
The date the coupon was last modified, in the site's timezone. read-only
Field IDcoupon/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Date Modified Gmt
The date the coupon was last modified, as GMT. read-only
Field IDcoupon/date_modified_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Discount Type
Determines the type of discount that will be applied. Options: percent, fixed_cart and fixed_product. Default is fixed_cart.
Field IDcoupon/discount_type
TypeTEXT
Data Typedimension
Coupon Description
Coupon description.
Field IDcoupon/description
TypeTEXT
Data Typedimension
Coupon Date Expires
The date the coupon expires, in the site's timezone.
Field IDcoupon/date_expires
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Date Expires Gmt
The date the coupon expires, as GMT.
Field IDcoupon/date_expires_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Coupon Usage Count
Number of times the coupon has been used already. read-only
Field IDcoupon/usage_count
TypeNUMBER
Data Typedimension
Coupon Individual Use
If true, the coupon can only be used individually. Other applied coupons will be removed from the cart. Default is false.
Field IDcoupon/individual_use
TypeTEXT
Data Typedimension
Coupon Product Ids
List of product IDs the coupon can be used on.
Field IDcoupon/product_ids
TypeTEXT
Data Typedimension
Coupon Excluded Product Ids
List of product IDs the coupon cannot be used on.
Field IDcoupon/excluded_product_ids
TypeTEXT
Data Typedimension
Coupon Usage Limit
How many times the coupon can be used in total.
Field IDcoupon/usage_limit
TypeNUMBER
Data Typedimension
Coupon Usage Limit Per User
How many times the coupon can be used per customer.
Field IDcoupon/usage_limit_per_user
TypeNUMBER
Data Typedimension
Coupon Limit Usage To X Items
Max number of items in the cart the coupon can be applied to.
Field IDcoupon/limit_usage_to_x_items
TypeNUMBER
Data Typedimension
Coupon Free Shipping
If true and if the free shipping method requires a coupon, this coupon will enable free shipping. Default is false.
Field IDcoupon/free_shipping
TypeTEXT
Data Typedimension
Coupon Product Categories
List of category IDs the coupon applies to.
Field IDcoupon/product_categories
TypeTEXT
Data Typedimension
Coupon Excluded Product Categories
List of category IDs the coupon does not apply to.
Field IDcoupon/excluded_product_categories
TypeTEXT
Data Typedimension
Coupon Exclude Sale Items
If true, this coupon will not be applied to items that have sale prices. Default is false.
Field IDcoupon/exclude_sale_items
TypeTEXT
Data Typedimension
Coupon Minimum Amount
Minimum order amount that needs to be in the cart before coupon applies.
Field IDcoupon/minimum_amount
TypeNUMBER
Data Typedimension
Coupon Maximum Amount
Maximum order amount allowed when using the coupon.
Field IDcoupon/maximum_amount
TypeNUMBER
Data Typedimension
Coupon Email Restrictions
List of email addresses that can use this coupon.
Field IDcoupon/email_restrictions
TypeTEXT
Data Typedimension
Coupon Used By
List of user IDs (or guest email addresses) that have used the coupon. read-only
Field IDcoupon/used_by
TypeTEXT
Data Typedimension
Customer Id
Unique identifier for the resource. read-only
Field IDcustomer/id
TypeTEXT
Data Typedimension
Customer Date Created
The date the customer was created, in the site's timezone. read-only
Field IDcustomer/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Date Created Gmt
The date the customer was created, as GMT. read-only
Field IDcustomer/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Date Modified
The date the customer was last modified, in the site's timezone. read-only
Field IDcustomer/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Date Modified Gmt
The date the customer was last modified, as GMT. read-only
Field IDcustomer/date_modified_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Email
The email address for the customer. mandatory
Field IDcustomer/email
TypeTEXT
Data Typedimension
Customer First Name
Customer first name.
Field IDcustomer/first_name
TypeTEXT
Data Typedimension
Customer Last Name
Customer last name.
Field IDcustomer/last_name
TypeTEXT
Data Typedimension
Customer Role
Customer role. read-only
Field IDcustomer/role
TypeTEXT
Data Typedimension
Customer Billing
List of billing address data. See Customer - Billing properties
Field IDcustomer/billing
TypeTEXT
Data Typedimension
Customer Shipping
List of shipping address data. See Customer - Shipping properties
Field IDcustomer/shipping
TypeTEXT
Data Typedimension
Customer Is Paying Customer
Is the customer a paying customer? read-only
Field IDcustomer/is_paying_customer
TypeTEXT
Data Typedimension
Customer Avatar Url
Avatar URL. read-only
Field IDcustomer/avatar_url
TypeTEXT
Data Typedimension
Order Id
Unique identifier for the resource. read-only
Field IDorder/id
TypeNUMBER
Data Typedimension
Order Parent Id
Parent order ID.
Field IDorder/parent_id
TypeNUMBER
Data Typedimension
Order Number
Order number. read-only
Field IDorder/number
TypeTEXT
Data Typedimension
Order Order Key
Order key. read-only
Field IDorder/order_key
TypeTEXT
Data Typedimension
Order Created Via
Shows where the order was created. read-only
Field IDorder/created_via
TypeTEXT
Data Typedimension
Order Version
Version of WooCommerce which last updated the order. read-only
Field IDorder/version
TypeTEXT
Data Typedimension
Order Status
Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending.
Field IDorder/status
TypeTEXT
Data Typedimension
Order Currency
Currency the order was created with, in ISO format. Options: AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BRL, BSD, BTC, BTN, BWP, BYR, BZD, CAD, CDF, CHF, CLP, CNY, COP, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GGP, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, IMP, INR, IQD, IRR, IRT, ISK, JEP, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PRB, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLL, SOS, SRD, SSP, STD, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, UYU, UZS, VEF, VND, VUV, WST, XAF, XCD, XOF, XPF, YER, ZAR and ZMW. Default is USD.
Field IDorder/currency
TypeTEXT
Data Typedimension
Order Date Created
The date the order was created, in the site's timezone. read-only
Field IDorder/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Created Gmt
The date the order was created, as GMT. read-only
Field IDorder/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Modified
The date the order was last modified, in the site's timezone. read-only
Field IDorder/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Modified Gmt
The date the order was last modified, as GMT. read-only
Field IDorder/date_modified_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Order Discount Total
Total discount amount for the order. read-only
Field IDorder/discount_total
TypeNUMBER
Data Typedimension
Order Discount Tax
Total discount tax amount for the order. read-only
Field IDorder/discount_tax
TypeNUMBER
Data Typedimension
Order Shipping Total
Total shipping amount for the order. read-only
Field IDorder/shipping_total
TypeNUMBER
Data Typedimension
Order Shipping Tax
Total shipping tax amount for the order. read-only
Field IDorder/shipping_tax
TypeNUMBER
Data Typedimension
Order Cart Tax
Sum of line item taxes only. read-only
Field IDorder/cart_tax
TypeNUMBER
Data Typedimension
Order Total
Grand total. read-only
Field IDorder/total
TypeNUMBER
Data Typedimension
Order Total Tax
Sum of all taxes. read-only
Field IDorder/total_tax
TypeNUMBER
Data Typedimension
Order Prices Include Tax
True the prices included tax during checkout. read-only
Field IDorder/prices_include_tax
TypeBOOLEAN
Data Typedimension
Order Customer Id
User ID who owns the order. 0 for guests. Default is 0.
Field IDorder/customer_id
TypeNUMBER
Data Typedimension
Order Customer Ip Address
Customer's IP address. read-only
Field IDorder/customer_ip_address
TypeTEXT
Data Typedimension
Order Customer User Agent
User agent of the customer. read-only
Field IDorder/customer_user_agent
TypeTEXT
Data Typedimension
Order Customer Note
Note left by customer during checkout.
Field IDorder/customer_note
TypeTEXT
Data Typedimension
Billing First Name
Billing First Name
Field IDorder/billing_first_name
TypeTEXT
Data Typedimension
Billing Last Name
Billing Last Name
Field IDorder/billing_last_name
TypeTEXT
Data Typedimension
Billing Company Name
Billing Company Name
Field IDorder/billing_company
TypeTEXT
Data Typedimension
Billing Address 1
Billing Address 2
Field IDorder/billing_address_1
TypeTEXT
Data Typedimension
Billing Address 2
Billing Address 2
Field IDorder/billing_address_2
TypeTEXT
Data Typedimension
Billing State
Billing State
Field IDorder/billing_state
TypeTEXT
Data Typedimension
Billing Post code
Billing Post code
Field IDorder/billing_postcode
TypeTEXT
Data Typedimension
Billing Country
Billing Country
Field IDorder/billing_country
TypeCOUNTRY_CODE
Data Typedimension
Billing Email
Billing Email
Field IDorder/billing_email
TypeTEXT
Data Typedimension
Billing Phone Number
Billing Email
Field IDorder/billing_phone
TypeTEXT
Data Typedimension
shipping First Name
shipping First Name
Field IDorder/shipping_first_name
TypeTEXT
Data Typedimension
shipping Last Name
shipping Last Name
Field IDorder/shipping_last_name
TypeTEXT
Data Typedimension
shipping Company Name
shipping Company Name
Field IDorder/shipping_company
TypeTEXT
Data Typedimension
shipping Address 1
shipping Address 2
Field IDorder/shipping_address_1
TypeTEXT
Data Typedimension
shipping Address 2
shipping Address 2
Field IDorder/shipping_address_2
TypeTEXT
Data Typedimension
shipping State
shipping State
Field IDorder/shipping_state
TypeTEXT
Data Typedimension
shipping Post code
shipping Post code
Field IDorder/shipping_postcode
TypeTEXT
Data Typedimension
shipping Country
shipping Country
Field IDorder/shipping_country
TypeCOUNTRY_CODE
Data Typedimension
shipping Email
shipping Email
Field IDorder/shipping_email
TypeTEXT
Data Typedimension
shipping Phone Number
shipping Email
Field IDorder/shipping_phone
TypeTEXT
Data Typedimension
Order Payment Method
Payment method ID.
Field IDorder/payment_method
TypeTEXT
Data Typedimension
Order Payment Method Title
Payment method title.
Field IDorder/payment_method_title
TypeTEXT
Data Typedimension
Order Transaction Id
Unique transaction ID.
Field IDorder/transaction_id
TypeTEXT
Data Typedimension
Order Date Paid
The date the order was paid, in the site's timezone. read-only
Field IDorder/date_paid
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Paid Gmt
The date the order was paid, as GMT. read-only
Field IDorder/date_paid_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Completed
The date the order was completed, in the site's timezone. read-only
Field IDorder/date_completed
TypeYEAR_MONTH_DAY
Data Typedimension
Order Date Completed Gmt
The date the order was completed, as GMT. read-only
Field IDorder/date_completed_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Order Cart Hash
MD5 hash of cart items to ensure orders are not modified. read-only
Field IDorder/cart_hash
TypeTEXT
Data Typedimension
Tax Lines 1 ID
Tax Lines 1 ID
Field IDorder/tax_lines_id
TypeNUMBER
Data Typedimension
Tax Lines Rate Code
Tax Lines Rate Code
Field IDorder/tax_lines_rate_code
TypeTEXT
Data Typedimension
Tax Lines Rate Id
Tax Lines Rate Id
Field IDorder/tax_lines_rate_id
TypeNUMBER
Data Typedimension
Tax Lines Label
Tax Lines Label
Field IDorder/tax_lines_label
TypeTEXT
Data Typedimension
Tax Lines Compound
Tax Lines Compound
Field IDorder/tax_lines_compound
TypeBOOLEAN
Data Typedimension
Tax Lines Number
Tax Lines Number
Field IDorder/tax_lines_tax_total
TypeNUMBER
Data Typedimension
Tax Lines Shipping Tax Total
Tax Lines Shipping Tax Total
Field IDorder/tax_lines_shipping_tax_total
TypeNUMBER
Data Typedimension
Order Shipping Lines ID
Order Shipping Lines ID
Field IDorder/shipping_lines_id
TypeNUMBER
Data Typedimension
Order Shipping Method Title
Order Shipping Method Title
Field IDorder/shipping_lines_method_title
TypeTEXT
Data Typedimension
Order Shipping Method ID
Order Shipping Method ID
Field IDorder/shipping_lines_method_id
TypeTEXT
Data Typedimension
Order Shipping Method Total
Order Shipping Method Total
Field IDorder/shipping_lines_total
TypeNUMBER
Data Typedimension
Order Shipping Method Total Tax
Order Shipping Method Total Tax
Field IDorder/shipping_lines_total_tax
TypeNUMBER
Data Typedimension
Order Set Paid
Define if the order is paid. It will set the status to processing and reduce stock items. Default is false. write-only
Field IDorder/set_paid
TypeTEXT
Data Typedimension
Order Line Id
Item ID.
Field IDorder_line/id
TypeNUMBER
Data Typedimension
Order Line Product name
Order Line Product name.
Field IDorder_line/name
TypeTEXT
Data Typedimension
Order Line Product Id
Order Line Product Id.
Field IDorder_line/product_id
TypeNUMBER
Data Typedimension
Order Line Product Variation Id
Order Line Product Variation Id.
Field IDorder_line/variation_id
TypeNUMBER
Data Typedimension
Order Line Product Quantity
Order Line Product Quantity
Field IDorder_line/quantity
TypeNUMBER
Data Typedimension
Order Line Tax Class
Slug of the tax class of product.
Field IDorder_line/tax_class
TypeTEXT
Data Typedimension
Order Line Subtotal
Line subtotal (before discounts).
Field IDorder_line/subtotal
TypeNUMBER
Data Typedimension
Order Line Subtotal tax
Line subtotal tax (before discounts).
Field IDorder_line/subtotal_tax
TypeNUMBER
Data Typedimension
Order Line Total
Line total (after discounts).
Field IDorder_line/total
TypeNUMBER
Data Typedimension
Order Line Total Tax
Line total tax (after discounts).
Field IDorder_line/total_tax
TypeNUMBER
Data Typedimension
Order Line Product SKU
Product SKU.
Field IDorder_line/sku
TypeTEXT
Data Typedimension
Order Line Product price
Product price.
Field IDorder_line/price
TypeNUMBER
Data Typedimension
Product Variations Id
Unique identifier for the resource. read-only
Field IDproduct_variation/id
TypeNUMBER
Data Typedimension
Product Variations Date Created
The date the variation was created, in the site's timezone. read-only
Field IDproduct_variation/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date Created Gmt
The date the variation was created, as GMT. read-only
Field IDproduct_variation/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date Modified
The date the variation was last modified, in the site's timezone. read-only
Field IDproduct_variation/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date Modified Gmt
The date the variation was last modified, as GMT. read-only
Field IDproduct_variation/date_modified_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Description
Variation description.
Field IDproduct_variation/description
TypeTEXT
Data Typedimension
Product Variations Permalink
Variation URL. read-only
Field IDproduct_variation/permalink
TypeTEXT
Data Typedimension
Product Variations Sku
Unique identifier.
Field IDproduct_variation/sku
TypeTEXT
Data Typedimension
Product Variations Price
Current variation price. read-only
Field IDproduct_variation/price
TypeNUMBER
Data Typedimension
Product Variations Regular Price
Variation regular price.
Field IDproduct_variation/regular_price
TypeNUMBER
Data Typedimension
Product Variations Sale Price
Variation sale price.
Field IDproduct_variation/sale_price
TypeNUMBER
Data Typedimension
Product Variations Date On Sale From
Start date of sale price, in the site's timezone.
Field IDproduct_variation/date_on_sale_from
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date On Sale From Gmt
Start date of sale price, as GMT.
Field IDproduct_variation/date_on_sale_from_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date On Sale To
End date of sale price, in the site's timezone.
Field IDproduct_variation/date_on_sale_to
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations Date On Sale To Gmt
End date of sale price, as GMT.
Field IDproduct_variation/date_on_sale_to_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Product Variations On Sale
Shows if the variation is on sale. read-only
Field IDproduct_variation/on_sale
TypeBOOLEAN
Data Typedimension
Product Variations Status
Variation status. Options: draft, pending, private and publish. Default is publish.
Field IDproduct_variation/status
TypeTEXT
Data Typedimension
Product Variations Purchasable
Shows if the variation can be bought. read-only
Field IDproduct_variation/purchasable
TypeBOOLEAN
Data Typedimension
Product Variations Virtual
If the variation is virtual. Default is false.
Field IDproduct_variation/virtual
TypeBOOLEAN
Data Typedimension
Product Variations Downloadable
If the variation is downloadable. Default is false.
Field IDproduct_variation/downloadable
TypeBOOLEAN
Data Typedimension
Product Variations Download Limit
Number of times downloadable files can be downloaded after purchase. Default is -1.
Field IDproduct_variation/download_limit
TypeNUMBER
Data Typedimension
Product Variations Download Expiry
Number of days until access to downloadable files expires. Default is -1.
Field IDproduct_variation/download_expiry
TypeNUMBER
Data Typedimension
Product Variations Tax Status
Tax status. Options: taxable, shipping and none. Default is taxable.
Field IDproduct_variation/tax_status
TypeTEXT
Data Typedimension
Product Variations Tax Class
Tax class.
Field IDproduct_variation/tax_class
TypeTEXT
Data Typedimension
Product Variations Manage Stock
Stock management at variation level. Default is false.
Field IDproduct_variation/manage_stock
TypeTEXT
Data Typedimension
Product Variations Stock Quantity
Stock quantity.
Field IDproduct_variation/stock_quantity
TypeNUMBER
Data Typedimension
Product Variations Stock Status
Controls the stock status of the product. Options: instock, outofstock, onbackorder. Default is instock.
Field IDproduct_variation/stock_status
TypeTEXT
Data Typedimension
Product Variations Backorders
If managing stock, this controls if backorders are allowed. Options: no, notify and yes. Default is no.
Field IDproduct_variation/backorders
TypeTEXT
Data Typedimension
Product Variations Backorders Allowed
Shows if backorders are allowed. read-only
Field IDproduct_variation/backorders_allowed
TypeBOOLEAN
Data Typedimension
Product Variations Backordered
Shows if the variation is on backordered. read-only
Field IDproduct_variation/backordered
TypeBOOLEAN
Data Typedimension
Product Variations Weight
Variation weight.
Field IDproduct_variation/weight
TypeTEXT
Data Typedimension
Product Variations Shipping Class
Shipping class slug.
Field IDproduct_variation/shipping_class
TypeTEXT
Data Typedimension
Product Variations Shipping Class Id
Shipping class ID. read-only
Field IDproduct_variation/shipping_class_id
TypeNUMBER
Data Typedimension
Product Variations Image
Variation image data. See Product variation - Image properties
Field IDproduct_variation/image
TypeTEXT
Data Typedimension
Product Variations Menu Order
Menu order, used to custom sort products.
Field IDproduct_variation/menu_order
TypeNUMBER
Data Typedimension
Refund Id
Unique identifier for the resource. read-only
Field IDrefund/id
TypeTEXT
Data Typedimension
Refund Date Created
The date the order refund was created, in the site's timezone. read-only
Field IDrefund/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Refund Date Created Gmt
The date the order refund was created, as GMT. read-only
Field IDrefund/date_created_gmt
TypeYEAR_MONTH_DAY
Data Typedimension
Refund Amount
Total refund amount. Optional. If this parameter is provided, it will take precedence over line item totals, even when total of line items does not matches with this amount.
Field IDrefund/amount
TypeTEXT
Data Typedimension
Refund Reason
Reason for refund.
Field IDrefund/reason
TypeTEXT
Data Typedimension
Refund Refunded By
User ID of user who created the refund.
Field IDrefund/refunded_by
TypeTEXT
Data Typedimension
Refund Refunded Payment
If the payment was refunded via the API. See api_refund. read-only
Field IDrefund/refunded_payment
TypeTEXT
Data Typedimension
Refund Meta Data
Meta data. See Order refund - Meta data properties
Field IDrefund/meta_data
TypeTEXT
Data Typedimension
Refund Line Items
Line items data. See Order refund - Line items properties
Field IDrefund/line_items
TypeTEXT
Data Typedimension
Refund Api Refund
When true, the payment gateway API is used to generate the refund. Default is true. write-only
Field IDrefund/api_refund
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension
Total Order Number
Total Order Number
Field IDtotal_order_number
TypeNUMBER
Data Typemetric
Total order CA
Total order CA
Field IDtotal_order_ca
TypeNUMBER
Data Typemetric