Definition
| Canonical Type |
ThirdParty |
Objects Name |
ThirdParty |
| Description |
Woocommerce Customer Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Attribute_size |
custom_attribute_size |
|
VARCHAR
|
Attribute_size |
| Total_sales |
custom_total_sales |
|
VARCHAR
|
Total_sales |
| Adresse de messagerie |
user_email |
|
EMAIL
|
Adresse de messagerie |
| Role |
roles |
|
VARCHAR
|
Role |
| Identifiant |
user_login |
|
VARCHAR
|
Identifiant |
| First Name |
first_name |
|
VARCHAR
|
First Name |
| Last Name |
last_name |
|
VARCHAR
|
Last Name |
| Site web |
user_url |
|
URL
|
Site web |
| Created |
user_registered |
|
DATETIME
|
Created |
| Splash Id |
splash_id |
|
VARCHAR
|
Splash Id |
| Splash Origin Node |
splash_origin |
|
VARCHAR
|
Splash Origin Node |
| Company |
company |
|
VARCHAR
|
Company |
| Address line 1 |
address_1 |
|
VARCHAR
|
Address line 1 |
| Postcode / ZIP |
postcode |
|
VARCHAR
|
Postcode / ZIP |
| City |
city |
|
VARCHAR
|
City |
| Country |
country |
|
ISO COUNTRY
|
Country |
| State / County |
state |
|
ISO STATE
|
State / County |
| Phone |
phone |
|
PHONE
|
Phone |
Definition
| Canonical Type |
Product |
Objects Name |
Product |
| Description |
WooCommerce Product Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Auteur |
post_author |
|
VARCHAR
|
Auteur |
| Last Modified |
post_modified |
|
DATETIME
|
Last Modified |
| Created |
post_date |
|
DATETIME
|
Created |
| Splash Id |
splash_id |
|
VARCHAR
|
Splash Id |
| Splash Origin Node |
splash_origin |
|
VARCHAR
|
Splash Origin Node |
| Featured Image |
_thumbnail_id |
|
IMG
|
Featured Image |
| Attribute_size |
custom_attribute_size |
|
VARCHAR
|
Attribute_size |
| Total_sales |
custom_total_sales |
|
VARCHAR
|
Total_sales |
| Titre |
post_title |
|
VARCHAR
|
Products : Titre |
| Base Title |
base_title |
|
VARCHAR
|
Products : Title without Options |
| Product short description |
post_excerpt |
|
VARCHAR
|
Products : Product short description |
| Contents |
post_content |
|
TEXT
|
Products : Contents |
| Slug |
post_name |
|
VARCHAR
|
Products : Permalink |
| Status |
post_status |
|
VARCHAR
|
Products : Status |
| SKU |
_sku |
|
VARCHAR
|
Product : SKU |
| Enabled |
is_visible |
|
BOOL
|
Product : Enabled |
| Weight |
_weight |
|
DOUBLE
|
Product Weight |
| Hauteur |
_height |
|
DOUBLE
|
Product Hauteur |
| Length |
_length |
|
DOUBLE
|
Product Length |
| Largeur |
_width |
|
DOUBLE
|
Product Largeur |
| Stock quantity |
_stock |
|
INT
|
Product Stock quantity |
| Out of stock |
outofstock |
|
BOOL
|
Product Out of stock |
| Regular price |
_regular_price |
|
PRICE
|
Product Regular price |
| Product Type |
type |
|
VARCHAR
|
Product Type |
| Is default variant |
default_on |
|
BOOL
|
Is default variant |
| Default Variant |
default_id |
|
Product
|
Default Variant |
| Parent |
parent_id |
|
VARCHAR
|
Parent |
| Children |
id@variants |
|
>
Product
|
Children |
| SKU |
sku@variants |
|
>
VARCHAR
|
SKU |
| Attribute |
attribute@variants |
|
>
VARCHAR
|
Attribute |
| Code |
code@attributes |
|
>
VARCHAR
|
Code |
| Nom |
name@attributes |
|
>
VARCHAR
|
Nom |
| Value |
value@attributes |
|
>
VARCHAR
|
Value |
| Md5 |
md5 |
|
VARCHAR
|
Unik Md5 Object Checksum |
| Md5 Debug |
md5-debug |
|
VARCHAR
|
Unik Checksum String fro Debug |
| Images |
image@images |
|
>
IMG
|
Product Images |
| Position |
position@images |
|
>
INT
|
Image Order for this Product Variant |
| Enable |
visible@images |
|
>
BOOL
|
Image is visible for this Product Variant |
| Featured Image |
cover@images |
|
>
BOOL
|
Image is Main Product Cover Image |
Definition
| Canonical Type |
Post |
Objects Name |
Post |
| Description |
Wordpress Post Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Titre |
post_title |
|
VARCHAR
|
Article : Titre |
| Slug |
post_name |
|
VARCHAR
|
Article : Permalink |
| Contents |
post_content |
|
TEXT
|
Article : Contents |
| Status |
post_status |
|
VARCHAR
|
Article : Status |
| Auteur |
post_author |
|
VARCHAR
|
Auteur |
| Last Modified |
post_modified |
|
DATETIME
|
Last Modified |
| Created |
post_date |
|
DATETIME
|
Created |
| Splash Id |
splash_id |
|
VARCHAR
|
Splash Id |
| Splash Origin Node |
splash_origin |
|
VARCHAR
|
Splash Origin Node |
| Featured Image |
_thumbnail_id |
|
IMG
|
Featured Image |
| Parent |
post_parent |
|
Page
|
Parent |
| Attribute_size |
custom_attribute_size |
|
VARCHAR
|
Attribute_size |
| Total_sales |
custom_total_sales |
|
VARCHAR
|
Total_sales |
Definition
| Canonical Type |
Page |
Objects Name |
Page |
| Description |
Wordpress Page Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Titre |
post_title |
|
VARCHAR
|
Article : Titre |
| Slug |
post_name |
|
VARCHAR
|
Article : Permalink |
| Contents |
post_content |
|
TEXT
|
Article : Contents |
| Status |
post_status |
|
VARCHAR
|
Article : Status |
| Auteur |
post_author |
|
VARCHAR
|
Auteur |
| Last Modified |
post_modified |
|
DATETIME
|
Last Modified |
| Created |
post_date |
|
DATETIME
|
Created |
| Splash Id |
splash_id |
|
VARCHAR
|
Splash Id |
| Splash Origin Node |
splash_origin |
|
VARCHAR
|
Splash Origin Node |
| Featured Image |
_thumbnail_id |
|
IMG
|
Featured Image |
| Parent |
post_parent |
|
Page
|
Parent |
| Attribute_size |
custom_attribute_size |
|
VARCHAR
|
Attribute_size |
| Total_sales |
custom_total_sales |
|
VARCHAR
|
Total_sales |
Definition
| Canonical Type |
Order |
Objects Name |
Order |
| Description |
WooCommerce Order Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Customer |
_customer_id |
|
ThirdParty
|
Customer |
| Reference |
reference |
|
VARCHAR
|
Reference |
| Order date |
_date_created |
|
DATE
|
Order date |
| Item |
name@items |
|
>
VARCHAR
|
Item |
| Product |
product@items |
|
>
Product
|
Product |
| Quantity |
quantity@items |
|
>
INT
|
Quantity |
| Percentage discount |
discount@items |
|
>
DOUBLE
|
Percentage discount |
| Price |
subtotal@items |
|
>
PRICE
|
Price |
| Tax name |
tax_name@items |
|
>
VARCHAR
|
Tax name |
| Method |
_payment_method@payments |
|
>
VARCHAR
|
Method |
| Date |
_date_paid@payments |
|
>
DATE
|
Date |
| Transaction ID |
_transaction_id@payments |
|
>
VARCHAR
|
Transaction ID |
| Total |
_total_tax@payments |
|
>
DOUBLE
|
Total |
| Order total (Tax Excl.) |
total_ht |
|
DOUBLE
|
Order total (Tax Excl.) |
| Order total |
total |
|
DOUBLE
|
Order total |
| Status |
status |
|
VARCHAR
|
Status |
| Order : Pending payment |
isdraft |
|
BOOL
|
Order : Pending payment |
| Order : Cancelled |
iscanceled |
|
BOOL
|
Order : Cancelled |
| Order : Processing |
isvalidated |
|
BOOL
|
Order : Processing |
| Order : Terminée |
isclosed |
|
BOOL
|
Order : Terminée |
| Order : Paid |
ispaid |
|
BOOL
|
Order : Paid |
| Billing details |
billing_address_id |
|
Address
|
Billing details |
| Shipping details |
shipping_address_id |
|
Address
|
Shipping details |
Definition
| Canonical Type |
Invoice |
Objects Name |
Invoice |
| Description |
WooCommerce Virtual Invoice |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Customer |
_customer_id |
|
ThirdParty
|
Customer |
| Reference |
reference |
|
VARCHAR
|
Reference |
| Order date |
_date_created |
|
DATE
|
Order date |
| Item |
name@items |
|
>
VARCHAR
|
Item |
| Product |
product@items |
|
>
Product
|
Product |
| Quantity |
quantity@items |
|
>
INT
|
Quantity |
| Percentage discount |
discount@items |
|
>
DOUBLE
|
Percentage discount |
| Price |
subtotal@items |
|
>
PRICE
|
Price |
| Tax name |
tax_name@items |
|
>
VARCHAR
|
Tax name |
| Method |
_payment_method@payments |
|
>
VARCHAR
|
Method |
| Date |
_date_paid@payments |
|
>
DATE
|
Date |
| Transaction ID |
_transaction_id@payments |
|
>
VARCHAR
|
Transaction ID |
| Total |
_total_tax@payments |
|
>
DOUBLE
|
Total |
| Order total (Tax Excl.) |
total_ht |
|
DOUBLE
|
Order total (Tax Excl.) |
| Order total |
total |
|
DOUBLE
|
Order total |
| Status |
invoice_status |
|
VARCHAR
|
Status |
| Order : Pending payment |
isdraft |
|
BOOL
|
Order : Pending payment |
| Order : Cancelled |
iscanceled |
|
BOOL
|
Order : Cancelled |
| Order : Processing |
isvalidated |
|
BOOL
|
Order : Processing |
| Order : Terminée |
isclosed |
|
BOOL
|
Order : Terminée |
| Order : Paid |
ispaid |
|
BOOL
|
Order : Paid |
| Billing details |
billing_address_id |
|
Address
|
Billing details |
| Shipping details |
shipping_address_id |
|
Address
|
Shipping details |
Definition
| Canonical Type |
Address |
Objects Name |
Customer Address |
| Description |
Wordpress Customer Address Object |
| Capabilities |
Push Created
|
Push Updated
|
Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Nom |
Identifiant |
Tags |
Format |
Description du Champs |
| Customer |
user |
|
ThirdParty
|
Customer |
| Company |
company |
|
VARCHAR
|
Company |
| First Name |
first_name |
|
VARCHAR
|
First Name |
| Last Name |
last_name |
|
VARCHAR
|
Last Name |
| Address line 1 |
address_1 |
|
VARCHAR
|
Address line 1 |
| Postcode / ZIP |
postcode |
|
VARCHAR
|
Postcode / ZIP |
| City |
city |
|
VARCHAR
|
City |
| Country |
country |
|
ISO COUNTRY
|
Country |
| State / County |
state |
|
ISO STATE
|
State / County |
| Phone |
phone |
|
PHONE
|
Phone |
| Email address |
email |
|
EMAIL
|
Email address |
