Inventory Planner
Inventory Planner ETL connector for data replication
Inventory Planner
Inventory Planner ETL connector for data replication
Snapshot
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 |
Integrate Inventory Planner with Daton
- 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.
Workflow
- 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
Inventory Planner Data
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 |
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 |
