WPSyncSheets For WooCommerce

Documentation

List of Order Fields for Update

Column/Tag HeaderExplanationAccepted value
Product Name
Name of the product ordered

Text
Product WeightWeight of the productNumeric (e.g., 1.2, 500g)

Order Status
Current order statusCompleted, Pending, Cancelled, etc.
Payment Method
Method used for payment

PayPal, COD, Credit Card, etc.
Billing First name
First name of billing contact

Text

Billing Last Name

Last name of billing contact
Text

Billing Address 1

Primary billing street address

Text

Billing Address 2

Secondary billing address (optional)
Text

Billing City
Billing city nameText

Billing State
Billing state nameText
Billing PostcodeBilling area postal codeAlphanumeric
Billing Country
Billing country
Country name/code
Billing Address
Full billing address

Combined address in one field
Billing Company NameCompany name (if any)
Text

Shipping First Name

First name of shipping contact
Text
Shipping Last Name
Last name of shipping contact

Text

Shipping Address 1

Primary shipping street address

Text

Shipping Address 2

Secondary shipping address (optional)

Text

Shipping City

Shipping city name
Text

Shipping State
Shipping state name
Text
Shipping Postcode
Shipping area postal code
Alphanumeric

Shipping Country
Shipping countryCountry name/code

Shipping Company Name

Company name (if any)

Text

Email

Customer’s email address
Valid email format

Phone

Customer’s phone number
Numeric (with/without country code)

Customer ID
Unique ID for customerNumeric or Alphanumeric

Customer Note

Any note added by customer
Text

Real-Time Import, Export, and Migration of WooCommerce Data.

WPSyncSheets For WooCommerce

5.0
View Plugin

Have a question?

We’re here to help, just send us a message.

Need help?

We're ready to help out & answer questions!