Inventory Planner
Inventory Planner ETL connector for data replication
Last updated
Inventory Planner ETL connector for data replication
Last updated
Snapshot
Signin to Daton
Select Impact from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Inventory Planner API key, Inventory Planner Account ID Click here to learn more about API key and Account ID
After providing the details to authorize Daton to periodically extract data from Inventory Planner.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Variants
Purpose: Retrieve a list of all Variants
Source API Documentation: https://help.inventory-planner.com/en/articles/6852616-inventory-planner-reports-api
Replication: Key-Based Replication
Replication Key: NA
Fields
FullName | DataType |
---|---|
Features
Details
Release Status
Released
Source API Version
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Inventory Planner API Key Inventory Planner Account ID
Replication Type
Key based Replication
Replication Key
NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Variants
connections
RECORD
warehouse
RECORD
removed
BOOLEAN
sku
STRING
in_stock
NUMERIC
cost
NUMERIC
retail_value
NUMERIC
gross_retail_value
NUMERIC
replenishment
NUMERIC
purchase_orders_qty
NUMERIC
id
STRING
created_at
TIMESTAMP
updated_at
TIMESTAMP
version
NUMERIC
first_order_date
DATE
last_order_date
DATE
orders_by_month
RECORD
revenue_by_month
RECORD
total_revenue
NUMERIC
total_sales
NUMERIC
total_sales_cost
NUMERIC
lead_time
NUMERIC
review_period
NUMERIC
avg_lead_time
NUMERIC
first_received_qty
NUMERIC
last_received_qty
NUMERIC
po_cost
NUMERIC
po_retail_value
NUMERIC
purchase_orders_qty_bundles
NUMERIC
purchase_orders_qty_for_bundles
NUMERIC
purchase_orders_qty_in_bundles
NUMERIC
transfer_cost_in
NUMERIC
transfer_cost_out
NUMERIC
age
RECORD
cur_sales
NUMERIC
first_30_days_sales
NUMERIC
forecast_by_period
RECORD
forecast_description
RECORD
forecast_revenue
RECORD
cur_forecasted_stock
NUMERIC
forecast_wholesale
NUMERIC
forecasted_lost_revenue_velocity_days_of_stock
NUMERIC
forecasted_lost_sales_lead_time
NUMERIC
forecasted_profit
NUMERIC
oos
NUMERIC
overstocked_cost
NUMERIC
overstocked_units
NUMERIC
overstocked_value
NUMERIC
overstocked_variants
NUMERIC
replenishment_cost_value
NUMERIC
replenishment_retail_value
NUMERIC
sells_out_in_first
NUMERIC
to_order
NUMERIC
to_order_cost
NUMERIC
to_order_gross
NUMERIC
to_order_profit
NUMERIC
cost_price
NUMERIC
wholesale_orders_by_month
RECORD
forecasted_stockouts_dos
NUMERIC
min_stock
NUMERIC
forecasted_lost_sales_lead_time_bn
BIGNUMERIC
returns_units_by_month
RECORD
replenish_date
DATE
landing_cost_price
NUMERIC
forecasted_lost_revenue_velocity_days_of_stock_bn
BIGNUMERIC
connections.removed
BOOLEAN
connections.title
STRING
connections.sku
STRING
connections.barcode
STRING
connections.price
NUMERIC
connections.regular_price
NUMERIC
connections.brand
STRING
connections.image
STRING
connections.product_type
STRING
connections.product_id
NUMERIC
connections.product_title
STRING
connections.published
BOOLEAN
connections.inventory_management
BOOLEAN
connections.created_at_time
NUMERIC
connections.updated_at_time
NUMERIC
connections.vendors
RECORD
connections.vendors.cost_price
NUMERIC
connections.vendors.cost_price_list
RECORD
connections.vendors.cost_price_list.usd
NUMERIC
connections.vendors.vendor_reference
STRING
connections.vendors.vendor
STRING
connections.vendors.cost_price_currency
STRING
connections.linked_by
STRING
connections.price_account
NUMERIC
connections.regular_price_account
NUMERIC
connections.connection_main
BOOLEAN
connections.id
STRING
connections.connection_id
STRING
connections.options
RECORD
connections.options.flavor
STRING
connections.options.title
STRING
connections.options.gtin__case_
STRING
warehouse.warehouse
STRING
warehouse.cost
NUMERIC
warehouse.retail_value
NUMERIC
warehouse.gross_retail_value
NUMERIC
warehouse.lead_time
NUMERIC
warehouse.review_period
NUMERIC
warehouse.po_cost
NUMERIC
warehouse.po_retail_value
NUMERIC
warehouse.purchase_orders_qty
NUMERIC
warehouse.purchase_orders_qty_bundles
NUMERIC
warehouse.purchase_orders_qty_for_bundles
NUMERIC
warehouse.purchase_orders_qty_in_bundles
NUMERIC
warehouse.transfer_cost_in
NUMERIC
warehouse.transfer_cost_out
NUMERIC
warehouse.age
RECORD
warehouse.age.qty
RECORD
warehouse.age.qty.____30_days
NUMERIC
warehouse.age.qty._1___60_days
NUMERIC
warehouse.age.qty._1___90_days
NUMERIC
warehouse.age.qty._1___120_days
NUMERIC
warehouse.age.qty._20___180_days
NUMERIC
warehouse.age.qty._80___365_days
NUMERIC
warehouse.age.qty.__365_days
NUMERIC
warehouse.age.qty._
NUMERIC
warehouse.age.cost
RECORD
warehouse.age.cost.____30_days
NUMERIC
warehouse.age.cost._1___60_days
NUMERIC
warehouse.age.cost._1___90_days
NUMERIC
warehouse.age.cost._1___120_days
NUMERIC
warehouse.age.cost._20___180_days
NUMERIC
warehouse.age.cost._80___365_days
NUMERIC
warehouse.age.cost.__365_days
NUMERIC
warehouse.age.cost._
NUMERIC
warehouse.age.retail
RECORD
warehouse.age.retail.____30_days
NUMERIC
warehouse.age.retail._1___60_days
NUMERIC
warehouse.age.retail._1___90_days
NUMERIC
warehouse.age.retail._1___120_days
NUMERIC
warehouse.age.retail._20___180_days
NUMERIC
warehouse.age.retail._80___365_days
NUMERIC
warehouse.age.retail.__365_days
NUMERIC
warehouse.cur_sales
NUMERIC
warehouse.first_30_days_sales
NUMERIC
warehouse.forecast_by_period
RECORD
warehouse.forecast_by_period._021
RECORD
warehouse.forecast_by_period._021._
NUMERIC
warehouse.forecast_by_period._021._0
NUMERIC
warehouse.forecast_by_period._021._1
NUMERIC
warehouse.forecast_by_period._021._2
NUMERIC
warehouse.forecast_by_period._022
RECORD
warehouse.forecast_by_period._022._
NUMERIC
warehouse.forecast_by_period._022._0
NUMERIC
warehouse.forecast_by_period._022._1
NUMERIC
warehouse.forecast_by_period._022._2
NUMERIC
warehouse.forecast_by_period._023
RECORD
warehouse.forecast_by_period._023._
NUMERIC
warehouse.forecast_by_period._023._0
NUMERIC
warehouse.forecast_by_period._023._1
NUMERIC
warehouse.forecast_by_period._023._2
NUMERIC
warehouse.forecast_by_period._023.__bn
BIGNUMERIC
warehouse.forecast_by_period._023._0_bn
BIGNUMERIC
warehouse.forecast_by_period._023._1_bn
BIGNUMERIC
warehouse.forecast_by_period._023._2_bn
BIGNUMERIC
warehouse.forecast_by_period._024
RECORD
warehouse.forecast_by_period._024._
NUMERIC
warehouse.forecast_by_period._024._0
NUMERIC
warehouse.forecast_by_period._024.__bn
BIGNUMERIC
warehouse.forecast_by_period._024._0_bn
BIGNUMERIC
warehouse.forecast_description
RECORD
warehouse.forecast_description.method
STRING
warehouse.forecast_description.oos_management
BOOLEAN
warehouse.forecast_description.sales_velocity30
NUMERIC
warehouse.forecast_description.sales_velocity1
NUMERIC
warehouse.forecast_description.total_sales
NUMERIC
warehouse.forecast_description.excluded_sales
NUMERIC
warehouse.forecast_description.total_days
NUMERIC
warehouse.forecast_description.total_days_sales
NUMERIC
warehouse.forecast_description.total_days_oos
NUMERIC
warehouse.forecast_description.excluded_days
NUMERIC
warehouse.forecast_description.sales_from
STRING
warehouse.forecast_description.sales_to
STRING
warehouse.forecast_description.trend
STRING
warehouse.forecast_description.trend_num
NUMERIC
warehouse.forecast_description.trend_months
NUMERIC
warehouse.forecast_description.short_sales_history
BOOLEAN
warehouse.forecast_description.excluded_periods
RECORD
warehouse.forecast_description.excluded_periods.from
STRING
warehouse.forecast_description.excluded_periods.to
STRING
warehouse.forecast_description.excluded_periods.days
NUMERIC
warehouse.forecast_description.excluded_periods.sales
NUMERIC
warehouse.forecast_description.messages
RECORD
warehouse.forecast_description.messages.title
STRING
warehouse.forecast_description.messages.column1
STRING
warehouse.forecast_description.messages.column2
STRING
warehouse.forecast_description.included_periods
RECORD
warehouse.forecast_description.included_periods.from
STRING
warehouse.forecast_description.included_periods.to
STRING
warehouse.forecast_description.included_periods.days
NUMERIC
warehouse.forecast_description.included_periods.sales
NUMERIC
warehouse.forecast_description.included_periods.warehouse
STRING
warehouse.forecast_description.sales_velocity1_bn
BIGNUMERIC
warehouse.forecast_description.sales_velocity30_bn
BIGNUMERIC
warehouse.forecast_revenue
RECORD
warehouse.forecast_revenue._021
RECORD
warehouse.forecast_revenue._021._
NUMERIC
warehouse.forecast_revenue._021._0
NUMERIC
warehouse.forecast_revenue._021._1
NUMERIC
warehouse.forecast_revenue._021._2
NUMERIC
warehouse.forecast_revenue._022
RECORD
warehouse.forecast_revenue._022._
NUMERIC
warehouse.forecast_revenue._022._0
NUMERIC
warehouse.forecast_revenue._022._1
NUMERIC
warehouse.forecast_revenue._022._2
NUMERIC
warehouse.forecast_revenue._023
RECORD
warehouse.forecast_revenue._023._
NUMERIC
warehouse.forecast_revenue._023._0
NUMERIC
warehouse.forecast_revenue._023._1
NUMERIC
warehouse.forecast_revenue._023._2
NUMERIC
warehouse.forecast_revenue._024
RECORD
warehouse.forecast_revenue._024._
NUMERIC
warehouse.forecast_revenue._024._0
NUMERIC
warehouse.cur_forecasted_stock
NUMERIC
warehouse.forecast_wholesale
NUMERIC
warehouse.forecasted_lost_revenue_velocity_days_of_stock
NUMERIC
warehouse.forecasted_lost_sales_lead_time
NUMERIC
warehouse.forecasted_profit
NUMERIC
warehouse.oos
NUMERIC
warehouse.overstocked_cost
NUMERIC
warehouse.overstocked_units
NUMERIC
warehouse.overstocked_value
NUMERIC
warehouse.overstocked_variants
NUMERIC
warehouse.replenishment
NUMERIC
warehouse.replenishment_cost_value
NUMERIC
warehouse.replenishment_retail_value
NUMERIC
warehouse.sells_out_in_first
NUMERIC
warehouse.first_order_date
DATE
warehouse.last_order_date
DATE
warehouse.total_revenue
NUMERIC
warehouse.total_sales
NUMERIC
warehouse.total_sales_cost
NUMERIC
warehouse.to_order
NUMERIC
warehouse.to_order_cost
NUMERIC
warehouse.to_order_gross
NUMERIC
warehouse.to_order_profit
NUMERIC
warehouse.cost_price
NUMERIC
warehouse.forecasted_stockouts_dos
NUMERIC
warehouse.min_stock
NUMERIC
warehouse.replenish_date
DATE
warehouse.in_stock
NUMERIC
warehouse.avg_lead_time
NUMERIC
warehouse.first_received_qty
NUMERIC
warehouse.last_received_qty
NUMERIC
warehouse.orders_by_month
RECORD
warehouse.orders_by_month._020
RECORD
warehouse.orders_by_month._020._
NUMERIC
warehouse.orders_by_month._020._0
NUMERIC
warehouse.orders_by_month._020._1
NUMERIC
warehouse.orders_by_month._020._2
NUMERIC
warehouse.orders_by_month._021
RECORD
warehouse.orders_by_month._021._
NUMERIC
warehouse.orders_by_month._021._0
NUMERIC
warehouse.orders_by_month._021._1
NUMERIC
warehouse.orders_by_month._021._2
NUMERIC
warehouse.orders_by_month._022
RECORD
warehouse.orders_by_month._022._
NUMERIC
warehouse.orders_by_month._022._0
NUMERIC
warehouse.orders_by_month._022._1
NUMERIC
warehouse.orders_by_month._022._2
NUMERIC
warehouse.orders_by_month._023
RECORD
warehouse.orders_by_month._023._
NUMERIC
warehouse.revenue_by_month
RECORD
warehouse.revenue_by_month._020
RECORD
warehouse.revenue_by_month._020._
NUMERIC
warehouse.revenue_by_month._020._0
NUMERIC
warehouse.revenue_by_month._020._1
NUMERIC
warehouse.revenue_by_month._020._2
NUMERIC
warehouse.revenue_by_month._021
RECORD
warehouse.revenue_by_month._021._
NUMERIC
warehouse.revenue_by_month._021._0
NUMERIC
warehouse.revenue_by_month._021._1
NUMERIC
warehouse.revenue_by_month._021._2
NUMERIC
warehouse.revenue_by_month._022
RECORD
warehouse.revenue_by_month._022._
NUMERIC
warehouse.revenue_by_month._022._0
NUMERIC
warehouse.revenue_by_month._022._1
NUMERIC
warehouse.revenue_by_month._022._2
NUMERIC
warehouse.revenue_by_month._023
RECORD
warehouse.revenue_by_month._023._
NUMERIC
warehouse.wholesale_orders_by_month
RECORD
warehouse.wholesale_orders_by_month._020
RECORD
warehouse.wholesale_orders_by_month._020._
NUMERIC
warehouse.wholesale_orders_by_month._020._0
NUMERIC
warehouse.wholesale_orders_by_month._020._1
NUMERIC
warehouse.wholesale_orders_by_month._020._2
NUMERIC
warehouse.wholesale_orders_by_month._021
RECORD
warehouse.wholesale_orders_by_month._021._
NUMERIC
warehouse.wholesale_orders_by_month._021._0
NUMERIC
warehouse.wholesale_orders_by_month._021._1
NUMERIC
warehouse.wholesale_orders_by_month._021._2
NUMERIC
warehouse.wholesale_orders_by_month._022
RECORD
warehouse.wholesale_orders_by_month._022._
NUMERIC
warehouse.wholesale_orders_by_month._022._0
NUMERIC
warehouse.wholesale_orders_by_month._022._1
NUMERIC
warehouse.wholesale_orders_by_month._022._2
NUMERIC
warehouse.wholesale_orders_by_month._023
RECORD
warehouse.wholesale_orders_by_month._023._
NUMERIC
warehouse.forecasted_lost_revenue_velocity_days_of_stock_bn
BIGNUMERIC
warehouse.returns_units_by_month
RECORD
warehouse.returns_units_by_month._020
RECORD
warehouse.returns_units_by_month._020._1
NUMERIC
warehouse.returns_units_by_month._020._
NUMERIC
warehouse.returns_units_by_month._020._0
NUMERIC
warehouse.landing_cost_price
NUMERIC
warehouse.forecasted_lost_sales_lead_time_bn
BIGNUMERIC
orders_by_month._020
RECORD
orders_by_month._020._
NUMERIC
orders_by_month._020._0
NUMERIC
orders_by_month._020._1
NUMERIC
orders_by_month._020._2
NUMERIC
orders_by_month._021
RECORD
orders_by_month._021._
NUMERIC
orders_by_month._021._0
NUMERIC
orders_by_month._021._1
NUMERIC
orders_by_month._021._2
NUMERIC
orders_by_month._022
RECORD
orders_by_month._022._
NUMERIC
orders_by_month._022._0
NUMERIC
orders_by_month._022._1
NUMERIC
orders_by_month._022._2
NUMERIC
orders_by_month._023
RECORD
orders_by_month._023._
NUMERIC
revenue_by_month._020
RECORD
revenue_by_month._020._
NUMERIC
revenue_by_month._020._0
NUMERIC
revenue_by_month._020._1
NUMERIC
revenue_by_month._020._2
NUMERIC
revenue_by_month._021
RECORD
revenue_by_month._021._
NUMERIC
revenue_by_month._021._0
NUMERIC
revenue_by_month._021._1
NUMERIC
revenue_by_month._021._2
NUMERIC
revenue_by_month._022
RECORD
revenue_by_month._022._
NUMERIC
revenue_by_month._022._0
NUMERIC
revenue_by_month._022._1
NUMERIC
revenue_by_month._022._2
NUMERIC
revenue_by_month._023
RECORD
revenue_by_month._023._
NUMERIC
age.qty
RECORD
age.qty._
NUMERIC
age.cost
RECORD
age.cost._
NUMERIC
forecast_by_period._023
RECORD
forecast_by_period._023._
NUMERIC
forecast_by_period._023._0
NUMERIC
forecast_by_period._023._1
NUMERIC
forecast_by_period._023._2
NUMERIC
forecast_by_period._023.__bn
BIGNUMERIC
forecast_by_period._023._0_bn
BIGNUMERIC
forecast_by_period._023._1_bn
BIGNUMERIC
forecast_by_period._023._2_bn
BIGNUMERIC
forecast_by_period._024
RECORD
forecast_by_period._024._
NUMERIC
forecast_by_period._024._0
NUMERIC
forecast_by_period._024.__bn
BIGNUMERIC
forecast_by_period._024._0_bn
BIGNUMERIC
forecast_description.method
STRING
forecast_description.oos_management
BOOLEAN
forecast_description.sales_velocity30
NUMERIC
forecast_description.sales_velocity1
NUMERIC
forecast_description.total_sales
NUMERIC
forecast_description.excluded_sales
NUMERIC
forecast_description.total_days
NUMERIC
forecast_description.total_days_sales
NUMERIC
forecast_description.total_days_oos
NUMERIC
forecast_description.excluded_days
NUMERIC
forecast_description.excluded_periods
RECORD
forecast_description.excluded_periods.from
STRING
forecast_description.excluded_periods.to
STRING
forecast_description.excluded_periods.days
NUMERIC
forecast_description.excluded_periods.sales
NUMERIC
forecast_description.messages
RECORD
forecast_description.messages.title
STRING
forecast_description.messages.column1
STRING
forecast_description.messages.column2
STRING
forecast_description.sales_from
STRING
forecast_description.sales_to
STRING
forecast_description.trend
STRING
forecast_description.trend_num
NUMERIC
forecast_description.trend_months
NUMERIC
forecast_description.short_sales_history
BOOLEAN
forecast_description.sales_velocity1_bn
BIGNUMERIC
forecast_description.included_periods
RECORD
forecast_description.included_periods.from
STRING
forecast_description.included_periods.to
STRING
forecast_description.included_periods.days
NUMERIC
forecast_description.included_periods.sales
NUMERIC
forecast_description.sales_velocity30_bn
BIGNUMERIC
forecast_revenue._023
RECORD
forecast_revenue._023._
NUMERIC
forecast_revenue._023._0
NUMERIC
forecast_revenue._023._1
NUMERIC
forecast_revenue._023._2
NUMERIC
forecast_revenue._024
RECORD
forecast_revenue._024._
NUMERIC
forecast_revenue._024._0
NUMERIC
wholesale_orders_by_month._020
RECORD
wholesale_orders_by_month._020._
NUMERIC
wholesale_orders_by_month._020._0
NUMERIC
wholesale_orders_by_month._020._1
NUMERIC
wholesale_orders_by_month._020._2
NUMERIC
wholesale_orders_by_month._021
RECORD
wholesale_orders_by_month._021._
NUMERIC
wholesale_orders_by_month._021._0
NUMERIC
wholesale_orders_by_month._021._1
NUMERIC
wholesale_orders_by_month._021._2
NUMERIC
wholesale_orders_by_month._022
RECORD
wholesale_orders_by_month._022._
NUMERIC
wholesale_orders_by_month._022._0
NUMERIC
wholesale_orders_by_month._022._1
NUMERIC
wholesale_orders_by_month._022._2
NUMERIC
wholesale_orders_by_month._023
RECORD
wholesale_orders_by_month._023._
NUMERIC
returns_units_by_month._020
RECORD
returns_units_by_month._020._1
NUMERIC
returns_units_by_month._020._
NUMERIC
returns_units_by_month._020._0
NUMERIC