Mapping Columns When Uploading Data

Here is a comprehensive list of columns that are ready for mapping when you upload your data.

Column headings displayed in bold text can be expanded to reveal subheadings represented by

bullet points underneath.

Agent

Agent Role

Alternate Labels

• Editor 1
• Editor 2
• Proj Editor 1
• Proj Editor 2
• Cover Designer
• Ins Designer

Audience

• Audience Code
• ATOS
• Guided Reading Level
• Lexile
• Interest Age Years
• UK School Grade
• US School Grade Range
• Onix Adult Audience
• Prop Audience Type Name
• Prop Audience Code

Barcode Indicator

Bic Codes

• Bic Codes
• BicCode_1
• BicCode_2
• BicCode_3

Bisac Codes

• Bisac Codes
• BisacCode_1
• BisacCode_2
• BisacCode_3

CBMC

City of Publication

Classifications

• Amazon
• Thema

Commodity Code

Contributor

• Contributor role
• Contributor name
• Contributor affiliation
• Contributor description
• Contributor Statement
• Contributor 1
• Contributor Role 1
• Contributor 2
• Contributor Role 2
• Contributor 3
• Contributor Role 3
• Contributor 4
• Contributor Role 4
• Contributor 5
• Contributor Role 5
• Contributor 6
• Contributor Role 6
• Contributor 7
• Contributor Role 7

Contributor Type Breakdown

• Author FS
• Author SF
• Editor FS
• Editor SF
• Illustrator FS
• Illustrator SF

Country of Manufacture

Country of Publication

       Dates

• Copyright Year
• Expected Ship Date
• On Sale Date
• Publication Date
• Year First Published

Description- Not included in ONIX

• Catalogue Long

Description- Reviews

• Review1
• Review 1 Title
• Review 1 Author
• Review 2
• Review 2 Title
• Review 2 Author
• Review 3
• Review 3 Title
• Review 3 Author
• Review 4
• Review 4 Title
• Review 4 Author
• Review 5
• Review 5 Title
• Review 5 Author

Descriptions

• Bio Note
• Long
• Main
• Review
• Short
• Key Selling
• Table Of Contents

Dewey

Dimensions

• Height
• Height x Width
• Width
• Width x Height
• Weight
• Weight Unit
• Thickness

Edition

• Edition Number
• Edition Version Number
• Edition Statement
• Edition Type Code

Extents

• Number Of Words
• File size ('Filesize (Kb)')
• Duration (Duration (min)

Form

•                     Product Form
•                     Epub Type
•                     Product Form Detail
•                     Product Form Description

HMRC Code

Identifiers

• ASIN
• DOI
• EAN13
• ISBN
• ISBN13
• ISBN13- EPUB
• ISBN13- PDF
• ISBN13- Kindle
• ISBN13- Print
• ISSN
• Record Reference
• Stock Code

Illustration Note

Illustrations

• Bibliography
• Black & white illustrations
• Charts
• Colour illustrations
• Diagrams
• Figures
• Frontispiece
• Gazetteer
• Glossary
• GPS Grids
• Graphs
• Halftones, black & white
• Halftones, colour
• Halftones, duotone
• Halftones, unspecified
• Illustrations, unspecified
• Index
• Inset maps
• Line drawings, black & white
• Line drawings, colour
• Line drawings, unspecified
• Maps
• Plates, black & white
• Plates, colour
• Plates, unspecified
• Printed, music items
• Table of contents
• Tables, black & white
• Tables, colour
• Tables, unspecified
• Unspecified

Imprint

Keywords

Lib. Cong. Class

Lib. Cong. Number

Language

Pages

Pack Quantity

• Pack Quantity (Book)
• Pack Quantity (Supplier)

Price Profile

Prices

• Countries Included
• Currency Code
• Discount Code
• Gross Price / RRP
• Net Price           
• Tax
• Price Type
• Price Type Description
• Price Qualifier
• TAX Rate
• Net Price 2
• Tax 2
• Date From
• Date To
• Web Price
• Web Discount

Prices - Currencies

• AUD Price
• CAD Price
• EUR Price
• GBP Price
• NZD Price
• SGD Price
• USD Price

Product Availability

Publisher

Publisher Roles

• Publisher Role
• Publisher Name

Publishing Season

Publishing Status

Related

• Related Item Code
• Related Item

Returns

• Returns Code
• Returns Code Type
• Returns- Last Date

Rights

• Rights 01 (Rights - Exclusive)
• Rights 02 (Rights - Non Exclusive)
• Rights 03 (Rights - Not For Sale)
• Rights 04 (Rights - Not For Sale)
• Rights-05 (Rights - Not For Sale)
• Rights-06 (Rights - Not For Sale)

Series

• Series Name
• Number within Series

Stock

• Stock (On Hand)
• Stock (On Order)
• Stock (Back Orders)
• Stock QTY Code Name
• Stock Qty Code

Strapline

Subject

Sub Title

Supplier

Supplier Rights

• Market Rights 01  (Market Rights - Exclusive)
• Market Rights 03 (Market Rights - Not For Sale)

TARIC Code

Tags

Themes

Title

Unit Cost