Column

Example Data

Description

*Type

Product

The type is either "Product" or "Delivery" If the product is required to be delivered then it must have both a Product and a Delivery Line

*Line Ref

1

The Line Ref is used to associate a Product with a Delivery. If the product line reference is 1 then the Delivery line for that product will be 1. Split deliveries can be set for a product by referencing the Product Line Ref.

Order ref

A112233

The Order ref shows in the PO reference field on the job. If you keep the same order ref for each product, those lines will be added as individual products under the same quote/job number. All lines containing a new or blank "Order ref" column have the following required fields: Customer code, Address line 1, Address city, Address country, Address post code, Contact first name, Contact surname, Contact email

Customer code [REQUIRED_ON_ORDER]

CC123

Customer code under which the order will be created

Job title

My Test Job

This will show in the Job Title on the job

Due date

31/12/19 01:00:00 PM

The expected format for due date is dd/MM/yy hh:mm tt, for example: 05/03/19 06:33 PM 

Series ref

Campaign 1

If Required - Enter existing series or If it does not exist then it will be created in print IQ on save

Address line 1 [REQUIRED_ON_ORDER]

100 Queen Street

Address – The address field is mandatory so must be included in the spreadsheet line. The “Product” type line will have these details entered as the Contact Details. The “Delivery” Type will have these details entered as the Delivery Contact details. Note: The delivery method chosen will be the cheapest available

Address line 2

Address line 3

Address city [REQUIRED_ON_ORDER]

Brisbane

Address state

QLD

Address country [REQUIRED_ON_ORDER]

Australia

Address post code [REQUIRED_ON_ORDER]

4000

Contact first name [REQUIRED_ON_ORDER]

John

Contact surname [REQUIRED_ON_ORDER]

Smith

Contact email [REQUIRED_ON_ORDER]

john.smith@printIQ.com

Product ref

All lines containing a new or blank "Product ref" column have the following required fields: Quantity, Tree node, Size (width), Size (height)

Base product code [REQUIRED_ON_XMPIE_PRODUCT]

For XMPie Products

Base section code [REQUIRED_ON_XMPIE_SECTION]

For XMPie Products

Attributes 1 (list)

For XMPie Products

Attribute 2

For XMPie Products

Attribute 3

For XMPie Products

Quantity [REQUIRED_ON_NATIVE_PRODUCT] [REQUIRED_ON_XMPIE_PRODUCT]

500

Enter Quantity

Kinds

1

Product - Must have a value of 1 or above

Delivery – If your Product line has multiple Kinds the Delivery lines must have the Total Quantity with a kind of 1. Example – Product 5 x 5 Kinds – Delivery line will be 25 x 1 Kind.

Tree node [REQUIRED_ON_NATIVE_PRODUCT]

Business Cards

This is the Product Category NAME - The ID Number is not used on this spreadsheet - Any existing Product Category can be used as this is a requirement to generate a job.

Section type [REQUIRED_ON_NATIVE_SECTION]

Single-Section

You can only add one section per row. If you have multiple sections duplicate the row and change the section type with updated specifications. Ie – Cover / Text 

Stock [REQUIRED_ON_NATIVE_SECTION]

ABSPMX20

This is the Stock code found in Admin>Configure Factory>Stock

Process front [REQUIRED_ON_NATIVE_SECTION]

CMYK

Code found at Admin>Configure Factory>Processes – use the Short Name

Process reverse [REQUIRED_ON_NATIVE_SECTION]

CMYK

Code found at Admin>Configure Factory>Processes – use the Short Name

Size (width) [REQUIRED_ON_NATIVE_SECTION] [REQUIRED_ON_NATIVE_PRODUCT]

210

Enter Width in mm

Size (height) [REQUIRED_ON_NATIVE_SECTION] [REQUIRED_ON_NATIVE_PRODUCT]

297

Enter Height in mm

Fold catalogue [REQUIRED_ON_NATIVE_SECTION]

Flat Sheet

Enter Fold Catalogue "Description" NOT the Fold Catalogue 

Pages [REQUIRED_ON_NATIVE_SECTION]

2

Enter Pages - If flat Product 2 

Front side operations 1 (list)

Gloss Laminate

Enter the operation name in here. If you have up to 3 operations place them in the separate columns OR If you have 2 or more then enter them in this column with a comma "," Separator. The operation names used in the SectionFinish, SideFinish & JobFinish fields are found at Admin>Configure Factory> Operations. Use the “Name” field 

Front side operation 2

Front side operation 3

Reverse side operations 1 (list)

Gloss Laminate

Enter the operation name in here.  If you have up to 3 operations place them in the separate columns OR  If you have 2 or more then enter them in this column with a comma "," Separator.

Reverse side operation 2

Reverse side operation 3

Section operations 1 (list)

Round Corner,Drill,Collate

Enter the operation name in here. If you have up to 3 operations place them in the separate columns OR If you have 2 or more then enter them in this column with a comma "," Separator.

Section operation 2

Section operation 3

Job operations 1 (list)

Cartons

Enter the operation name in here.  If you have up to 3 operations place them in the separate columns OR If you have 2 or more then enter them in this column with a comma "," Separator.

Job operation 2

Admin

Job operation 3

Preflight

Section artwork pdf url

https://s3-ap-southeast-2.amazonaws.com/myfiles/Test_Document.pdf

The artwork must be referenced by a Public URL or an FTP site. As an Example  -ftp://username:password@ftp.com/file.pdf or a publicly available URL such as a public AWS S3 Bucket

Target retail price

$50

Retail Price Inc GST

Note: If the Invoice is set to use component lines the Price Override will not be successful. 

Target freight price

$10

Freight Price Inc GST

New product code

Enter the required Product Code that you wish to assign to the custom product you create. If this is left blank Print IQ will assign a code for you