Reference: Liquid Template Objects and Placeholders

Duoplane uses Liquid in order to allow customized documents, data files, and other user-defined dynamically generated content.

Please refer to the official Liquid documentation for details on how to use Liquid.

Below is a list of available template objects and their placeholders / variables:

 

address

An address, such as a shipping or billing address of an order, or the address of a vendor or retailer.

full_name	The first and last name of the address
first_name	First name
last_name	Last name
company_name	Company
address_1	Address line 1
address_2	Address line 2
city	City
province	State or province. Depending on the ecommerce platform from where the address came, this could be the complete name or abbreviation.
province_iso	The ISO 3166-2 code for the state or province
province_name	The full name of the state or province
post_code	Zip or postal code
country	Country name. Depending on the ecommerce platform from where the address came, this could be the complete name or abbreviation.
country_iso2	The 2 letter ISO 3166-1 code for the country
country_name	The full name of the country
phone	Phone number
fax	Fax number
email	Email address

 

comment

A message linked to another object.

body	The message body
commenter_company	The company whose user created the comment.
recipient_company	If the comment was intended as a message for another company (like on a comment on an order_item), the name of the company to whom the message was written.

 

company

Either a vendor or a retailer.

name	Company name
address	Reference to the address object of the company's main address
actual_return_address	Reference to the address object of the company's address for returns. If a return address is not set up for a company, the main address is used.

 

order

A sales order from an ecommerce channel.

id	The unique numeric ID assigned by Duoplane to this order
public_reference	The order number as provided by the ecommerce channel
shipping_address	Reference to the address object of the order's shipping address
billing_address	Reference to the address object of the order's billing address
retailer	Reference to the company object of the order's retailer
store	Reference to the store object of the order's ecommerce channel
ordered_at	The time at which the order was placed
order_items	An array of order_item objects referencing the items on the order
customer_note	Text provided by the ecommerce channel of an order note written by the customer
order_notes	An array of order_note objects referencing any order-level notes provided by the ecommerce channel
order_note	This order's order_notes expressed as a hash (set of key / value pairs), where the title is the key and the body is the value. For example, if an order_note object has the title "Gift Wrap" and body "Yes", the Liquid template {{ order.order_note['Gift Wrap'] }} would render: Yes
tag_names	If the ecommerce channel supports the tagging of orders, this is an array of order tags. This is blank if tag importing is not enabled on your account.
store_payment_status	The text of the payment status for the order, as provided by the ecommerce channel
ship_method	The text of the selected shipping service level, as provided by the ecommerce channel
ok_to_process	A boolean value that is false if the order is on hold and true otherwise
total_shipping_revenue	The shipping fee collected from the end customer
order_level_discount	Order-level discount applied on this order. This does not include any discounts that were applied to specific line items.
total_discount	Total discount applied on this order, including any discounts that were applied to specific line items.
item_weight_in_grams	Weight of all items in grams
item_weight_in_ounces	Weight of all items in ounces

 

order_item

A line item on a sales order or purchase order.

id	The unique numeric ID assigned by Duoplane to this order_item
order	Reference to the order object of the line item's order
purchase_order	Reference to the purchase_order object of the line item's purchase order
name	Name of the item
vendor_sku	Vendor SKU of the item
retailer_sku	Retailer SKU of the item
upc	UPC of the item's product
purchase_order_name	Name of the item as it appears on purchase orders
quantity	Quantity purchased
quantity_open	Quantity pending fulfillment
price	The retail price of the item on its sales order
cost	The wholesale cost of the item on its associated purchase order
discount_each	Retail discount given per unit. This includes both the item-level discount as well as a pro rata allocation of any order-level discount.
item_level_discount_each	Retail discount that was specifically applied to this item. This value does not include any order-level discounts.
tax_each	Per-unit tax for the line item.
tax_amount	Tax for the line item. Note that this is the total tax for the line item, not a per-unit value.
promise_date_active	For unfulfilled items, this is the expected ship date. The value is blank for items that have been fulfilled.
line_item_number	Sequence number of this item on its purchase order. (For example, "2" for the second item on the PO.)
order_item_notes	An array of order_item_note objects referencing any item-level notes provided by the ecommerce channel
order_item_note	This item's order_item_notes expressed as a hash (set of key / value pairs), where the title is the key and the body is the value. For example, if an order_item_note object has the title "Initials" and body "ABC", the Liquid template {{ order_item.order_item_note['Initials'] }} would render: ABC
weight_each_in_grams	Weight of each unit in grams
weight_each_in_ounces	Weight of each unit in ounces
retailer_product	Reference to the product object of the item's underlying product
image_url	If provided by the ecommerce channel, a URL for an image of this item
retailer_purchase_order_comments	An array of comment objects referencing the item-level messages written by the item retailer to the item vendor
vendor_purchase_order_comments	An array of comment objects referencing the item-level messages written by the item vendor to the item retailer
all_purchase_order_comments	An array of comment objects referencing the item-level messages written by either the item vendor or the item retailer
order_item_parent	If this order_item is the component of a bundle, this is a reference to the bundle parent order_item object
order_item_children	If this order_item is a bundle, this is an array of the bundle component order_item objects

 

order_item_note

A note or other additional data attached to an order item.

title	The title or key of the note
body	The body or value of the note

 

order_note

A note or other additional data attached to a sales order.

title	The title or key of the note
body	The body or value of the note

 

order_return

A record of the return of items on an order.

address_text	Plain text version of the full address to which this order should be returned
rma_number	The auto-assigned RMA number for this return
vendor_rma	The corresponding RMA number of this return in the vendor's record
destination_company	The company object listed as the "Return destination" of the order record
order	The order object representing the original sales order of this return
purchase_order	The purchase_order object representing the vendor purchase order linked to the items on this return. The purchase_order will only be present if all of the items on the return were on the same purchase order.
order_return_items	An array of order_return_item objects, each representing an item that is either expected or was received on this return

 

order_return_item

A record of the items on a return.

order_item	The order_item object linked to this item
quantity_received	The quantity received of this item
quantity_expected	The quantity expected of this item

 

product

A product in the ecommerce catalog.

name	Product name
vendor_sku	Vendor SKU
retailer_sku	Retailer SKU
price	Retail price
cost	Wholesale cost
price_msrp	Manufacturer's Suggested Retailer Price
price_map	Minimum Advertised Price
upc	Universal Product Code
mpn	Manufacturer's Part Number
other_barcode	Other product identifier
description	Product description
custom_text_1	Custom text field for products
custom_text_2	Custom text field for products
custom_text_3	Custom text field for products
product_inventories	An array of product_inventory objects representing the inventory sources for this product

 

product_inventory

An inventory record for a product from a single supplier. A single product can have multiple inventory records.

vendor_id	The Duoplane-generated unique ID of the vendor
vendor_sku	Vendor SKU
cost	Wholesale cost
purchase_name	The name of the product as it is known to this vendor
quantity_available	Quantity available of this item at this vendor

 

promise_date

An object representing the date by which an item should ship before it is considered late.

promise_date	The expected ship date
order_item	Reference to the order_item object to which this promise date applies
previous_promise_date	Reference to the most recent promise_date object that existed before this current promise_date. This would only exist if there has been at least one promise date change for this particular order_item.

 

purchase_order

An order placed by the retailer with the vendor,

id	The unique numeric ID assigned by Duoplane to this purchase_order
public_reference	The purchase order number
shipping_address	Reference to the address object of the purchase order's shipping address
retailer_name	The name of the PO retailer
retailer_id	The Duoplane-generated unique ID of the PO retailer
retailer	Reference to the company object of the purchase order's retailer
vendor_name	The name of the PO vendor
vendor_id	The Duoplane-generated unique ID of the PO vendor
vendor	Reference to the company object of the purchase order's vendor
created_at	The time at which the PO was created
retailer_account_reference	The account number of the retailer in the vendor's records
order	Reference to the order object of the purchase order's sales order
store	Reference to the store object of the purchase order's ecommerce channel
ship_method	The shipping service method as it appears on the associated sales order.
ship_method_for_vendor	The shipping service level of this PO after applying any vendor translations to the ship_method from the associated sales order.
customer_note	Text provided by the ecommerce channel of an order note written by the customer. This is blank if the retailer has not enabled customer notes to appear on purchase orders.
gift_note	Text provided by the ecommerce channel of a gift note on the order. This is blank if the retailer has not enabled customer notes to appear on purchase orders.
order_items	An array of order_item objects referencing the items on the order.
promise_date_cache	Date by which this order should ship.
item_quantity_cache	Total quantity of items on this PO
item_count_cache	Total count of unique lines items on this PO
total_price	The total retail price of all items on this PO
total_shipping_revenue	The shipping fee collected from the end customer for items on this PO
total_sales_discount	The sales discount given to end customer for items on this PO
total_cost	The total wholesale cost of all items on this PO
item_weight_in_grams	Weight of all items in grams
item_weight_in_ounces	Weight of all items in ounces
sent_at	The time at which the PO was sent
to_text	A plain text version of the entire PO

retail_relationship

A relationship between a retailer and a vendor.

id	The unique numeric ID assigned by Duoplane to this retail_relationship
retailer	Reference to the company object of the retailer
vendor	Reference to the company object of the vendor
retailer_account_reference	The account number of the retailer in the vendor's systems

shipment

A shipment of items.

id	The unique numeric ID assigned by Duoplane to this shipment
purchase_order	Reference to the purchase_order object for the purchase order linked to this shipment.
shipment_items	An array of shipment_item objects referencing the items on the shipment
shipper_name	The name of the carrier for this shipment
tracking_number_array	An array of tracking numbers for this shipment
total_shipping_revenue	The shipping fee collected from the end customer for items on this shipment
order_previous_shipments	An array of shipment objects for any shipments that were previously created for this shipment's order.
purchase_order_previous_shipments	An array of shipment objects for any shipments that were previously created for this shipment's purchase order.
vendor_invoice_item_subtotal	The total wholesale cost of the line items of this shipment.

shipment_item

An item on a shipment.

id	The unique numeric ID assigned by Duoplane to this shipment
order_item	Reference to the order_item object linked to this shipment_item.
quantity	The quantity shipped on the shipment
serial_codes	An array of serial numbers for this shipment_item

store

An ecommerce channel

id	The unique numeric ID assigned by Duoplane to this store
name	The name of the ecommerce store
print_logo_url	URL of the print logo uploaded into Duoplane for this store. If there is no store-level logo, this will be the URL of the company-level logo.