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

Other
notes
serial_number
parts_master_notes

---

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.

Required:
part_number
condition_code
price_cents
quantity

Other information
notes
delivery_days

---

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.

To download an example, click here

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