ERP Data Guide

Stock

If you would like to sync Stock data with Rotabull, please format your file as a CSV with the following headers. Please note that this is separate from Listings, as Listings may include parts that are not in stock.

To download an example, click here.

Required
part_number
condition_code
quantity
stock_line

Tag / Trace information:
tagged_by
tag_date
tag_number
tag_type
rec_date
cert_source
tag_type_code

Geographic Information:
consignment_code
location_code
warehouse_code

Pricing information:
unit_cost_cents list_price_cents
sell_price_cents
exchange_price_cents

Note: price_cents fields should be entered as dollar amounts (with a decimal if necessary), not cents.

Other
notes
serial_number
parts_master_notes

Listings

If you would like to sync Listings data with Rotabull, please format your file as a CSV with the following headers. The part numbers in your Listings may be identical to your Stock, but in Rotabull Listings are stored separately from Stock. The main difference is that Rotabull will upload your Listings to marketplaces and they can be customized when doing so. Listings can also include some different data fields from Stock (see below).

Required
part_number
description
condition_code
quantity

Other information
manufacturer
alternate_part_number
price
unit
stock_category_code
ils_flag_description
asset_id
part_number_group_id
parts_master_list_price
min_sell_quantity
serial_number
stock_mkt_enabled

Companies

If you would like to sync Company data with Rotabull, please format your file as a CSV with the following headers.

To download an example, click here.

Required:
company_name
company_code
erp_key

Geographic information
address
address2
city
state
country

Company type information
company_category
company_rank
region

Quote controls
quote_warning
quote_allowed

Other information
external_id
preferred_terms_id
preferred_carrier_id
preferred_carrier_account_number
currency_code
customer_flag

Price Lines

If you would like to sync Price Line data with Rotabull, please format your file as a CSV with the following headers.

To download an example, click here (parts price lines) or here (mro price lines).

Required:
part_number
condition_code
price_cents
quantity

Other information
notes delivery_days exchange_cost_method core_charge days_until_core_due erp_delivery_code company_id company_category trace_to tag_source tag_date tag_type warranty serial_number unit_of_measure stock_line expiration_date (UTC)

Alternates

If you would like to sync Alternate data with Rotabull, please format your file as a CSV with the following headers.

To download an example, click here

Required:
part_number
alternate_part_number

Quote History

If you would like to sync Quote History data with Rotabull, please format your file as a CSV with the following headers.

Required:
erp_key
part_number
condition_code
customer_name
quantity
quoted_at
price_type
price_cents
currency

Other information
delivery_days
serial_number
trace_to
tag_source
stock_line
tag_date
notes
warranty
description