This article describes the file format of BookRouter™ exports available in the Export Inventory tool. This format is also the default export for Custom Routing tools. 

Export Inventory Tool (screenshot)

Key Characteristics of BookRouter™ Export Files

1. Files may be gzipped, leading to a .txt.gz extension
2. Filenames begin with Upload_ and then a numeric sequence prior to the extension. Ex: Upload_1772265880.txt.gz
3. Purge files are named with the word Purge_ in place of Upload_
4. The first record in all upload files sent from BookRouter™ is a header record with field names.

BookRouter™ Standard Export Format

Preset marketplaces are not typically constrained by the following format. We may work with third-parties to support special features, use an API rather than text file for updating inventory, etc. If you decide to use the Custom Routing tools, this standard format would be the default output. See Custom Routing to Unsupported Destinations.

sku
type
author
title
subtitle
illustrator
place_pub
publisher
date_pub
edition
binding
signed_text
description
comments
condition
jacket_cond
keywords
language
pages
size
categories
isbn
isbn13
dj
signed
first_ed
image_url
quantity
volumes
weight
weight_unit
handling_fee
extra1
extra2
extra3
price
action_type
custom1
custom2
custom3
custom4
hidden_categories
catalogs
banner
location
private_notes
meta_description
meta_keywords
status
cost
ship_exempt
sale_price
discount
savings
allow_discount
sale_kind
sale_id
tax_exempt
inquire_only
hide_price
published
category_ids
date_add
created
updated
action_type (d = delete; 1 = add) 

* See marketplace specific image_url notes below