Data Structure

This page describes the data types, structures and examples for each field for each sync operation.

Outbound syncs require certain fields to be specific data types.

Supported Outbound Sync operations:

• Customers

• Products

• Orders

• Fulfillments

Note: 1. * means the field is REQUIRED to be filled and cannot be null. 2. enum fields only accepts certain terms as strings which are shown in its corresponding example.

Customer

Outbound Sync: Create

This operation creates a new customer in Shopify.

Field Name	Type	Example
*first_name	string	John
*last_name	number	Smith
tags	string	first
phone	string	[phone]
email	string	[e-mail]
note	string	Bulk Customer
tax_exempt	boolean	TRUE | FALSE
email_marketing_consent	object	Example under "Object Examples"
sms_marketing_consent	object	Example under "Object Examples"
addresses	array of objects	Example under "Object Examples"

Outbound Sync: Update

This operation updates the details of an existing customer in Shopify. Will not update if no existing customer ID is found.

Field Name	Type	Example
*record_id	number	651023456789
first_name	string	John
last_name	number	Smith
tags	string	first
phone	string	[phone]
email	string	[e-mail]
note	string	Bulk Customer
tax_exempt	boolean	TRUE | FALSE
email_marketing_consent	object	Example under "Object Examples"
sms_marketing_consent	object	Example under "Object Examples"
addresses	array of objects	Example under "Object Examples"

Outbound Sync: Upsert

This operation creates a customer if the customer has never been created with this sync operation. This operation will update the existing customer's details if the customer was previously created from this sync operation.

Field Name	Type	Example
*record_id	number	651023456789
*first_name	string	John
*last_name	number	Smith
tags	string	first
phone	string	[phone]
email	string	[e-mail]
note	string	Bulk Customer
tax_exempt	boolean	TRUE | FALSE
email_marketing_consent	object	Example under "Object Examples"
sms_marketing_consent	object	Example under "Object Examples"
addresses	array of objects	Example under "Object Examples"

Outbound Sync: Delete

This operation deletes an already existing customer. Will not delete if existing customer ID is not found.

Field Name	Type	Example
*record_id	number	651023456789

Object Examples (Customer)

addresses

[
    { 
        // first_name, last_name is required
        "address1": "123 Oak St",
        "city":"Ottawa",
        "province":"ON",
        "phone":"555-1212",
        "zip":"123 ABC",
        "first_name":"Mother",
        "last_name":"Lastnameson",        
        "country":"CA"
    }
]

email_marketing_consent

{
   "state": "subscribed",
   "opt_in_level": "confirmed_opt_in",
}

sms_marketing_consent

{
   "state": "subscribed",
   "opt_in_level": "confirmed_opt_in",
   "consent_collected_from": "OTHER"
}

Objects or array of objects should not be empty. At least one field of the object should be present when performing a sync operation.

---

Product

Outbound Sync: Create

This operation creates a new product in Shopify.

Field Name	Type	Example
*title	string	Computer Laptop 32 inch
body_html	string	Silent, powerful and affordable laptop!
product_type	string	Laptop
published_scope	string (enum)	web | global
status	string (enum)	active | archived | draft
tags	string	Affordable, Big Screen
variants	array of objects	Example under "Object Examples"
vendor	string	Steve Jobs

Outbound Sync: Update

This operation updates the details of an existing product in Shopify. Will not update if no existing product ID is found.

Field Name	Type	Example
*record_id	number	632910392
title	string	Computer Laptop 32 inch
body_html	string	Silent, powerful and affordable laptop!
product_type	string	Laptop
published_scope	string (enum)	web | global
status	string (enum)	active | archived | draft
tags	string	Affordable, Big Screen
variants	array of objects	Example under "Object Examples"
vendor	string	Steve Jobs

Outbound Sync: Upsert

This operation creates a product if the product has never been created with this sync operation. This operation will update the existing product's details if the product was previously created from this sync operation.

Field Name	Type	Example
*record_id	number	632910392
*title	string	Computer Laptop 32 inch
body_html	string	Silent, powerful and affordable laptop!
product_type	string	Laptop
published_scope	string (enum)	web | global
status	string (enum)	active | archived | draft
tags	string	Affordable, Big Screen
variants	array of objects	Example under "Object Examples"
vendor	string	Steve Jobs

Outbound Sync: Delete

This operation deletes an already existing product. Will not delete if existing product ID is not found.

Field Name	Type	Example
*record_id	number	632910392

Object Examples (Product)

Variants

// Each item represents one variant of the product
[
  {
    "option1":"First",
    "price":"10.00",
    "sku":"123"
  },
  {
    "option1":"Second",
    "price":"20.00",
    "sku":"123"
  }
]

Each variant item in the object can accept more parameters than stated in the example.

Reference: https://shopify.dev/docs/api/admin-rest/2024-07/resources/product-variant

---

Order

Outbound Sync: Create

This operation creates a new order in Shopify.

Field Name	Type	Example
*line_items	array of objects	Example under "Object Examples"
email	string	[e-mail]
phone	string	[phone]
billing_address	object	Example under "Object Examples"
shipping_address	object	Example under "Object Examples"
discount_codes	array of objects	Example under "Object Examples"
financial_status	string (enum)	pending | paid | authorized | partially_paid | partially_refunded | refunded | voided
tax_lines will fail if line_items have tax_lines object	array of objects	Example under "Object Examples"
customer	object	Example under "Object Examples"
fulfillment_status	string	fulfilled | null | partial | restocked
note	string	Bulk order
note_attributes	array of objects	Example under "Object Examples"
buyer_accepts_marketing	boolean	TRUE | FALSE
tags	string	RTX, Intel, SSD, Music

The entire create operation for the record will FAIL if the line_items field, which also accepts a tax_lines field in the object, has a present tax_lines field as part of the object.

It is advisable to fill the tax_lines field as part of each item if each individual item has it's own tax details.

If all items share the same tax details, it is advisable to not have any tax_lines objects in each line_item but part of the optional parameter instead.

In Object Examples (Order) demonstrates the usage of the tax_lines object in line_items.

Outbound Sync: Update

This operation updates the details of an existing order in Shopify. Will not update if no existing order ID is found.

Field Name	Type	Example
*record_id	number	50123456789
note	string	Bulk order
note_attributes	array of objects	Example under "Object Examples"
buyer_accepts_marketing	boolean	TRUE | FALSE
tags	string	RTX, Intel, SSD, Music
phone	string	Example under "Object Examples"
shipping_address	object	Example under "Object Examples"
customer	null	null

The customer field only accepts a null argument. This will remove the customer that placed the order. Shopify API has not provided a way to insert an existing customer into an order after creation.

Outbound Sync: Upsert

This operation creates an order if the order has never been created with this sync operation. This operation will update the existing order's details if the product was previously created from this sync operation.

Field Name	Type	Example
*line_items	array of objects	Example under "Object Examples"
*record_id	number	50123456789
email	string	[e-mail]
phone	string	[phone]
billing_address	object	Example under "Object Examples"
shipping_address	object	Example under "Object Examples"
discount_codes	array of objects	Example under "Object Examples"
financial_status	string (enum)	pending | paid | authorized | partially_paid | partially_refunded | refunded | voided
tax_lines will fail if line_items have tax_lines object	array of objects	Example under "Object Examples"
customer	object | null	Example under "Object Examples" | null
fulfillment_status	string (enum)	fulfilled | null | partial | restocked
note	string	Bulk order
note_attributes	array of objects	Example under "Object Examples"
buyer_accepts_marketing	boolean	TRUE | FALSE
tags	string	RTX, Intel, SSD, Music

If this operation performs a create operation, the customer field will be able to accept the object.

If this operation performs an update operation, the customer field can only accept a null object. If this field remains filled with a customer object, it will be ignored and the corresponding customer will not be updated in the order. A null object will remove the customer from the order.

Outbound Sync: Delete

This operation deletes an already existing order. Will not delete if existing order ID is not found.

Field Name	Type	Example
*record_id	number	50123456789

Object Examples (Order)

line_items

[
  {
    "title":"Big Brown Bear Boots",
    "price":74.99,
    "grams":"1300",
    "quantity":3
  }
]

line_items (tax_lines)

[
  {
    "title":"Big Brown Bear Boots",
    "price":74.99,
    "grams":"1300",
    "quantity":3,
    "tax_lines":[
        {
            "price":13.5,
            "rate":0.06,
            "title":"State tax"
        }
    ]
  }
]

billing_address/shipping_address

{
    "first_name":"John",
    "last_name":"Smith",
    "address1":"123 Fake Street",
    "phone":"555-555-5555",
    "city":"Fakecity",
    "province":"Ontario",
    "country":"Canada",
    "zip":"K2P 1L4"
}

discount_codes

[
  {
     "code":"FAKE30",
     "amount":"9.00",
     // type is an enum: fixed_amount | percentage | shipping
     "type":"percentage"
  }
]

tax_lines

[
  {
    "price":6,
    "rate":0.06,
    "title": "State Tax"
  }
]

customer

{
    "first_name":"Paul",
    "last_name":"Norman",
    "email":"[e-mail]"
}

---

Fulfillment

Outbound Sync: Create

This operation fulfills an existing unfulfilled order's items given the fulfillment order ID. Orders that have all items fulfilled will be marked as fulfilled. Orders that have only part of it's items fulfilled will be marked as partially fulfilled.

Field Name	Type	Example
*line_items_by_fulfillment_order	array of objects	Example under "Object Examples"
message	string	Leave at doorstep
notify_customer	boolean	TRUE | FALSE
origin_address	object	Example under "Object Examples"
tracking_info	object	Example under "Object Examples"

Outbound Sync: Update

This operations updates an existing fulfilled order's details, such as the tracking information and delivery company.

Field Name	Type	Example
*record_id	number	4123456789
tracking_info	object	Example under "Object Examples"
notify_customer	boolean	TRUE | FALSE

Outbound Sync: Upsert

This operation will fulfill an order if the order has never been fulfilled with this sync operation. This operation will update the existing fulfillment's details if the order was previously fulfilled from this sync operation.

Field Name	Type	Example
*line_items_by_fulfillment_order	array of objects	Example under "Object Examples"
*record_id	number	4123456789
tracking_info	object	Example under "Object Examples"
notify_customer	boolean	TRUE | FALSE

Outbound Sync: Delete

This operation will unfulfill an order, changing the items of orders from fulfilled into unfulfilled state.

Field Name	Type	Example
*record_id	number	4123456789

Object Examples (Fulfillment)

line_items_by_fulfillment_order

[
  // only fulfillment_order_id is required
  // fulfillment_order_line_items is optional
  {
    "fulfillment_order_id":1046000819,
    "fulfillment_order_line_items":[{ "id":1058737537, "quantity":1 }]
  }
]

origin_address

{
   "address1": "123 Test Street",
   "address2": "Test Town",
   "city": "Sydney",
   "country_code": "AU",
   "province_code": "B1",
   "zip": "2000"
}

tracking_info

{
    // company - The name of the tracking company.
    "company":"FedEx",
    // number - The tracking number for the fulfillment. 
    "number": "MS1562678",
    // url - The URL to track the fulfillment. 
    "url": "https://www.my-shipping-company.com?tracking=MS1562678"
}