Who can use it?
Anyone! If you can use Whiplash, you can use WhiplashData. Access it by emailing tech@whiplash.com with your Customer Name, and we'll shoot back credentials.
You can view data with SQL viewers like Postico, TablePlus, or DBeaver.
What is it?
Whiplash Data is a Redshift database connection to the Whiplash application, tied to your account and updated nightly. Plug your Business Intelligence tool into the database and start making custom reports. Most information that's available in the Whiplash app or the v2 API is available in Whiplash Data. SQL proficiency is required.
When should I use it?
How often is my expedited carrier hitting their SLA?
What should I be charging for basic shipping to Europe?
When should I be making POs to minimize my storage costs without going out of stock?
Whiplash Data is great for building reports where pulling large amounts of data across an API is impractical. Because Whiplash Data is updated nightly at midnight PST (7 am UTC) and read-only, it is a helpful addition to the API, but not a replacement.
WhiplashData is not a good solution for real-time integrations, or for communicating inventory data to your ecommerce platform.
How can I unload this data?
Here's a guide from Amazon specific to S3 but applicable to a variety of data warehouse solutions.
Which data properties are available?
Column | Data Type |
---|---|
accounts | |
id | int |
balance | decimal(12,2) |
currency | varchar |
accountable_id | int |
accountable_type | varchar |
refill_amount | decimal(12,2) |
payment_method_token | varchar |
created_at | timestamp |
updated_at | timestamp |
account_transactions | |
id | int |
account_id | int |
description | varchar(512) |
amount | decimal(8,2) |
invoice_id | int |
created_at | timestamp |
updated_at | timestamp |
income_account | varchar |
balance | decimal(12,2) |
warehouse_id | int |
currency | varchar |
owner_type | varchar |
owner_id | int |
account_transaction_items | |
id | int |
account_id | int |
account_transaction_id | int |
income_account | varchar |
amount | decimal(8,2) |
invoices | |
id | int |
account_id | int |
grand_total | decimal(12,2) |
billing_period_start | timestamp |
billing_period_end | timestamp |
pdf_url | varchar |
csv_url | varchar |
items | |
id | int |
sku | varchar |
title | varchar |
description | varchar |
original_location | varchar |
created_at | timestamp |
updated_at | timestamp |
customer_id | int |
quantity | int |
weight | decimal(10,3) |
available | boolean |
image_originator_url | varchar |
vendor | varchar |
scancode | varchar |
price | decimal(8,2) |
media_mail | boolean |
packaging | boolean |
length | decimal(8,2) |
width | decimal(8,2) |
height | decimal(8,2) |
active | boolean |
wholesale_cost | decimal(10,2) |
is_bundle | boolean |
packaging_type | varchar |
promo | boolean |
street_date | timestamp |
category | varchar |
include_inbound_in_published | boolean |
returnable | boolean |
return_sku_match | varchar |
return_price_restricted | boolean |
request_serial_number | boolean |
currency | varchar |
tariff_number | varchar |
label_format | varchar |
notify_originator_inventory | int |
hazmat | boolean |
misc | varchar |
ean | varchar |
low_inventory_threshold | int |
locations | |
id | int |
item_id | int |
quantity | int |
warehouse_id | int |
orders | |
id | int |
customer_id | int |
order_batch_id | int |
quote_id | int |
warehouse_id | int |
shipping_method_id | int |
status | int |
previous_status | int |
order_orig | varchar |
level1_token | varchar |
level2_token | varchar |
workable_at | timestamp |
skip_street_date | boolean |
due_at | timestamp |
created_at | timestamp |
updated_at | timestamp |
meta_data | varchar |
shop_warehouse_id | int |
shop_warehouse_ids | varchar |
shop_shipping_method_currency | varchar |
shop_created_at | timestamp |
shop_updated_at | timestamp |
shop_shipping_method_text | varchar |
shop_shipping_method_price | decimal(10,2) |
billing_company | varchar |
billing_address_1 | varchar |
billing_address_2 | varchar |
billing_address_3 | varchar |
billing_city | varchar |
billing_state | varchar |
billing_zip | varchar |
billing_country | varchar |
billing_phone | varchar |
billed | boolean |
billing_name | varchar |
first_name | varchar |
last_name | varchar |
full_name | varchar |
shipping_name | varchar |
shipping_company | varchar |
shipping_address_1 | varchar |
shipping_address_2 | varchar |
shipping_city | varchar |
shipping_state | varchar |
shipping_zip | varchar |
shipping_country | varchar |
shipping_country_iso2 | varchar |
shipping_phone | varchar |
varchar | |
requested_address | varchar(512) |
residential | boolean |
address_verified | boolean |
address_message | varchar |
require_signature | boolean |
require_adult_signature | boolean |
saturday_delivery | boolean |
gift | boolean |
insure | boolean |
contains_alcohol | boolean |
customer_provided_label_carrier | varchar |
ship_actual_cost | decimal(8,2) |
shipped_on | timestamp |
ship_notes | varchar(512) |
shipping_confirmation_sent | boolean |
ship_3rdparty_cost | decimal(10,2) |
ship_3rdparty_account | varchar |
ship_3rdparty_zip | varchar |
ship_3rdparty_country | varchar |
incoterm | varchar |
public_note | varchar(512) |
days_in_transit | int |
days_in_transit_carrier_estimate | int |
req_insurance_value | decimal(8,2) |
return_name | varchar |
return_company | varchar |
return_address_1 | varchar |
return_address_2 | varchar |
return_city | varchar |
return_state | varchar |
return_country | varchar |
return_zip | varchar |
return_phone | varchar |
return_email | varchar |
return_address_verified | boolean |
return_time_limit | int |
order_documents | |
id | int |
order_id | int |
customer_id | int |
created_at | timestamp |
updated_at | timestamp |
order_items | |
id | int |
order_id | int |
customer_id | int |
item_id | int |
package_id | int |
quote_item_id | int |
sku | varchar |
description | varchar(512) |
quantity | int |
price | decimal(8,2) |
created_at | timestamp |
updated_at | timestamp |
unshippable | boolean |
available | boolean |
packed | int |
packaging | boolean |
wholesale_cost | decimal(10,2) |
is_bundle | boolean |
retail_fee | decimal(10,2) |
promo | boolean |
returnable | boolean |
currency | varchar |
wholesale_fee | decimal(8,2) |
hazmat | boolean |
misc | varchar |
originators | |
id | int |
customer_id | int |
originated_id | int |
originated_type | varchar |
shop_id | int |
provider | varchar |
original_id | varchar |
group_id | varchar |
misc | varchar |
active | boolean |
integration_id | int |
last_notified_at | timestamp |
last_notification_status | varchar |
distinct_originator_key | varchar |
created_at | timestamp |
updated_at | timestamp |
application_id | int |
packages | |
id | int |
order_id | int |
shipped_on | timestamp |
ship_actual_cost | decimal(6,2) |
actual_weight | decimal(10,2) |
actual_width | decimal(6,2) |
actual_height | decimal(6,2) |
actual_length | decimal(6,2) |
actual_dimensional_weight | decimal(15,2) |
tracking | varchar |
bill_of_lading | varchar |
created_at | timestamp |
updated_at | timestamp |
ucc128 | varchar |
shipnotices | |
id | int |
customer_id | int |
warehouse_id | int |
sender | varchar |
eta | timestamp |
status | int |
received_by | varchar |
notes_by_whiplash | varchar(512) |
notes_by_customer | varchar(512) |
total_boxes | int |
created_at | timestamp |
updated_at | timestamp |
processing_started_at | timestamp |
skip_images | boolean |
easypostable_id | varchar |
easypostable_type | varchar |
shipping_label_url | varchar |
ship_actual_cost | decimal(7,2) |
shipping_method_text | varchar |
tracking | varchar |
order_id | int |
type | varchar |
postage_billed | boolean |
handling_billed | boolean |
ship_3rdparty_cost | decimal(7,2) |
requires_label | boolean |
completed_at | timestamp |
ship_actual_currency | varchar |
delivered_at | timestamp |
due_at | timestamp |
meta_data | varchar |
reference |
varchar(255) |
shipnotice_items | |
id | int (8) |
shipnotice_id | int (8) |
item_id | int (8) |
customer_id | int (8) |
quantity | int (8) |
quantity_good | int (8) |
quantity_damaged | int (8) |
created_at | timestamp |
updated_at | timestamp |
available | varchar (65535) |
description | varchar (65535) |
extended_description | varchar (65535) |
include_in_published | varchar (65535) |
return_action | varchar (65535) |
purchase_order_number | varchar (65535) |
damaged_reason_code | varchar (65535) |
damaged_reason_description | varchar (65535) |
shipping_methods | |
id | int |
carrier | varchar |
service | varchar |
description | varchar |
international | boolean |
active | boolean |
flat_rate | boolean |
expedited | boolean |
trackable | boolean |
origins | varchar |
extended_description | varchar |
created_at | timestamp |
updated_at | timestamp |
item_transactions | |
id | int |
item_id | int |
order_id | int |
shipnotice_id | int |
user_id | int |
rule_id | int |
description | varchar |
quantity | int |
created_at | timestamp |
updated_at | timestamp |
warehouses | |
id | int |
name | varchar |
customers | |
id | int |
name | varchar |
partner_id | int |
shops | |
id | int |
provider | varchar |
domain | varchar |
customer_id | int |