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

{BuyerID}

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.

{BuyerNotes}
{BuyerNotes1}
{BuyerNotes2}

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

{Channel}

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

{CustomStr}
{CustomDec}
{CustomInt}

Custom fields for use in scripting.

{DownDate}
{DownDateS}
{DownDateL}

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

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

{Group}

Not used at present

{Notation}

Notation added from the Records Tab or script

{RecordID}

The unique identifier for the record generated by Packing Partner.

{SaleDate}
{SaleDateS}
{SaleDateL}

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

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

{SaleID}

The sales identifier collected from the sales channel

{SellerID}

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

{SellerNotes}
{SellerNotes1}
{SellerNotes2}

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

{SerialNo}

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

{ShipDate}
{ShipDateS}
{ShipDateL}

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

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

{ShipExtra}

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

{ShipMethod}

The shipping method collected from the web site

{ShipSort}

MailSort or PacketSort code for use with Royal Mail services.

{LongDate}
{ShortDate}

Today's date in long or short format

{Ev(expression)}
{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

{Charge}

The amount of charges on the invoice as a decimal

{Currency}

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

{Discount}

The amount of any discount as a decimal

{InvTotal}

Invoice total as a decimal

{InvWeight}

Invoice weight in Kgs (0.000)

{IOSSNumber}

 IOSS number (if provided by the platform)

{IOSSValue}

 IOSS tax value (if provided by the platform)

{ItemCount}

Total number of items

{ItemLen}

Number of rows

{PayRef}

Payment reference which does not always have a value

{PayType}

Payment type which should always have a value

{SubTotal}

Invoice subtotal as a decimal

{TaxRate}

Invoice tax rate (VAT), as a percentage

{TaxValue}

The tax value as a decimal

{RetInvoice}

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

{TaxInvoice}

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

Customer fields

 

{CusAddress}
{CusAddress1}
{CusAddress2}
{CusAddress3}
{CusAddress4}
{CusCompany}
{CusName}
{CusEmail}
{CusMobile}
{CusPhone}
{CusPostcode}
{CusCountry}

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

{Cost}

Item cost as a decimal

{CostX}

Item cost excluding and tax as a decimal

{Custom} 

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

{Det}

Product details field (Currently only collected from Amazon)

{GiftMsg}

{GiftOpt}

Item gift message and gift options.

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

{Idx}

Item Index

{Item} *

Item title without variation

{ItemL} *

Locally translated description without variation

{ItemN} *

Non translated (native)description without variation

{Kgs}

Item weight in Kgs (0.000)

{Loc}

Item location as a string

{Local} *

Translated item title & variation

{Msg}

Item message or note

{Native} *

Non translated description and variation

{Qty}

Item quantity as a decimal

{Sku}

Item SKU as a string

{TaxR}

Item tax rate as a percentage

{TaxV}

Item tax value as a decimal

{Title} *

Translated (local) item title & variation

{Total}

Item total as a decimal

{Var}

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 

 

{Carrier}

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

{Class}
{CodeNo}
{Format}
{Method}
{Service}

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

{TrackNo}

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