Placeholder Fields

Placeholder Fields

The following fields can be used in Exporting records , Email templates and Print layouts .

Record fields

In a layout, Item fields can only be used within an invoice frame


The username that identifies the buyer on the channel. Some channels use a BuyerID that is distinct from the buyer's name. e.g.

Where a distinct user name is not available this will be either the buyer's name or email address.


On a channel that has more than one place for Buyer's to leave notes, this will be {BuyerNotes} will contain both notes combined.


The channel where the order came from. e.g. ebay, amazon etc. To get the name of the channel see {SellerID} below.


Custom fields for use in scripting.


Date the order was downloaded, in normal, short and long date formats.

The date formats are defined by Windows time and date settings.


Not used at present


Notation added from the Records Tab or script


The unique identifier for the record generated by Packing Partner.


The date the order was placed, in normal, short and long date formats.

The date formats are defined by Windows time and date settings.


The sales identifier collected from the sales channel


The seller's business name, user name or web site name, which is different for each channel.


For channels that support seller notes. e.g. On ebay {SellerNotes1}would contain 'my notes'.


The record serial number generated by Packing Partner. This number is sequential and prefixed by the identifier of the PC that generated it.


The date the order was shipped in normal, short and long format.

The date formats are defined by Windows time and date settings.


Contains ship extra codes that define useful information for choosing a carrier and method.


The shipping method collected from the web site


MailSort or PacketSort code for use with Royal Mail services.


Today's date in long or short format

{If(expression, True, False)}

An expression that can be evaluated using Spreadsheet like syntax. Ev evaluates an expression and If asks a question with a true and false answer.

Operators are: = < > >= <= like and in . Strings are delimited by single quotes ('). The like operator can only have wildcards at the start or end.

{If('{DelCountry}' like '*KINGDOM', 'INLAND', 'EXPORT')}

{If('{DelCountry}' like '*KINGDOM', 'INLAND', 'EXPORT')}

Invoice fields

The amount of any carriage as a decimal


The amount of charges on the invoice as a decimal


Currency of the sale: AUD, CAD, EUR, GBP, USD


The amount of any discount as a decimal


Invoice total as a decimal


Invoice weight in Kgs (0.000)


 IOSS number (if provided by the platform)


 IOSS tax value (if provided by the platform)


Total number of items


Number of rows


Payment reference which does not always have a value


Payment type which should always have a value


Invoice subtotal as a decimal


Invoice tax rate (VAT), as a percentage


The tax value as a decimal


Inserts a complete retail invoice (without VAT breakdown) as an HTML table


Inserts a complete tax invoice (with VAT breakdown) as an HTML table

Customer fields



Fields to retrieve details of the customer / invoice address

Of the address lines, {CusAddress} is replaced by the entire address, the others only replace a single line.

Address lines at the top and bottom are the more significant (extra lines in the middle, are less significant, regional detail)

If your address fields are limited, use address lines starting from the top and bottom, working towards the middle.

e.g. If you only need 4 address lines, use {CusAddress1} , {CusAddress2} , {CusAddress4} and {CusPostcode}

Delivery fields


Fields to retrieve details of the delivery address

See notes above for Customer address fields

 Item list fields

 These fields are for when you want product details outside of an invoice frame

These fields insert a list of items and quantities from the invoice, in HTML templates the lines are separated by a <br> tag, in other formats CRLF is used.e.g. inserting {TitleList} will produce:

1 x Item one title
1 x Item two title

Item fields

Item fields do not apply to email templates, see: {RetInvoice} and {TaxInvoice} above

Item category (department), comment and condition. Currently only available from Amazon

Item code as a string


Item cost as a decimal


Item cost excluding and tax as a decimal


 Custom attributes for the item, e.g. Amazon Custom or Handmade options


Product details field (Currently only collected from Amazon)



Item gift message and gift options.

These can be printed one per label for gift certificates, etc. See here for details .


Item Index

{Item} *

Item title without variation

{ItemL} *

Locally translated description without variation

{ItemN} *

Non translated (native)description without variation


Item weight in Kgs (0.000)


Item location as a string

{Local} *

Translated item title & variation


Item message or note

{Native} *

Non translated description and variation


Item quantity as a decimal


Item SKU as a string


Item tax rate as a percentage


Item tax value as a decimal

{Title} *

Translated (local) item title & variation


Item total as a decimal


Item variation

{VarL} *

Translated variation

{VarN} *

Non translated (native) variation

*Translated titles and variations require the convert feature , otherwise all these fields will show the native title or variation as collected from the sales channel.

The carrier fields are generated by the shipping rules  when records are collected or transferred.

Carrier fields 



Name of the carrier as entered in the shipping rules, e.g Royal Mail or DPD


These fields are different for each carrier, again they are defined in the shipping rules.


The tracking number that will have been imported into Packing Partner when marking records as shipped .