There are 36 importable fields for each sales record. Most clients use only a few of these fields.
|ProductID||Required field. ISBN, SKU or Vendor Code||9781000030002|
|EntryType||Required if returns quantity or value is positive. H,P,R,S||S|
|Currency||3 character ISO code||USD|
|TotalSale||The net value of the sale after discounts are applied||$200.00|
The sales date is a required field. The sales date determines which royalty period the sales will be applied to.
Product ID is a required field. The product ID can be an ISBN, SKU or Vendor Code.
Entry type is required if the returns quantity or value is positive.
- H – Historical: Royalties are not calculated on historical sales. Historical sales are used to determine the value of royalty escalators.
- P – Press: Sales designated as entry type P are excluded from royalty and escalator calculations. The sales import can automatically code sales records with a zero sales value as entry type P.
- R – Returns: The return entry type allows the software to handled returns entered as positive quantities or positive sales.
- S – Sales: All sales records have a default value of S, unless otherwise specified.
Customer is the name of the book buyer. This field is recommended.
Consumer is the name of a book buyer’s customer. Example: Ingram purchases the book from you and sells it to ABC Books. Ingram is the customer and ABC Books is the consumer.
Currency is the 3 character ISO, if the sale was in a foreign currency.
Import territory if you want to track sales by country or your royalty rates vary by country.
If the 2 character ISO country code is specified the import process will convert this code to its proper country name.
The total sale is the net value of the sale after discounts are applied.
If the total cost of sales is not included in the import file the software will calculate it using the formula:
TotalCostOfSales = Quantity * Unit Cost
If the unit cost field is not imported, the field will be populated with the default unit cost; if any, in the edition record. If the TotalCostOfSales value is populated the unit cost will be calculated by dividing the TotalCostOfSales by the Quantity sold.