The title/edition record has over 100 importable fields. The most commonly imported fields are listed below.
|Title||Name of the product||Beaches of France|
|AuthorFullName||Author’s name. Import AuthorCode or AuthorFullName||Jason Smith|
|ContributorType||Example: author, editor, illustrator, photographer||Author|
|ISBN||Unique identifier, required for all editions||978-000090-000-4|
|SKU||Secondary unique identifier||7578|
|EditionTitle||Name of the edition||Beaches of France|
|EditionFormat||Format/Product Type of the edition||Paperback|
|EditionPublicationDate||The pubdate / release date for this product||05/20/2014|
|VersionReference||A name for this price. Example: 2015USD, 2015CAN||2015USD|
|VersionEffectiveDate||Date that this price change takes effect||1/1/2015|
|Default Version||Is this the default version (retail price) price for this edition? Y/N||Y|
Every title has a unique title code. If a title code is not assigned during title creation the software will generate a title code.
The title is the name of the intellectual property. Every title record must have a title.
The author code identifies the author. Importing the author code; from an existing author record, eliminates the chance that importing a variant of the author’s name will create a new author record.
If an exact match with an existing author full name record is not found the software will create a new author record with a unique author code.
Is a unique identifier. All products must have an ISBN. By default the software checks for a valid ISBN. If your organization does not use valid ISBNs as the unique identifier you can turn off ISBN validation in the Preferences menu.
The SKU is a secondary unique product identifier. Many publishers use a product code; call SKU, to identify a product. A sales import can use the ISBN or SKU to link a sale to an edition. For eBook products, some publishers populate this field with the Amazon ASIN number.
Is the name of the product. The edition title can be the same as or different from the name of the parent title. If the edition title field is not populated the software will use the title as the edition title.
Refers to the product type. Ebook, hardcover and paperback are common edition formats for book publishers. Royalty rates can be based on the edition format. A publisher may pay a 10% royalty on hardcover products and a 25% royalty on ebooks.
If the retail currency is not specified the royalty software uses the home currency; defined in Options & settings, as the retail currency. For retail currency use the 3 character ISO code. A list of these codes is available from the lookup button in Options & settings > Exchange rates.
The retail price; also known as the MSRP, will populate a sales record and will be used to calculate the discount if the sales record does not contain a retail price. Royalties can be based on the retail price.
This Y/N field tells the software whether this retail price (version) is the default price for this edition. When sales records are created and a retail price is not specified this retail price/currency will be loaded as the default price. This version will also be the list price (MSRP) for the product.