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

1. Signin to Daton

2. Select Impact from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Inventory Planner API key, Inventory Planner Account ID Click here to learn more about API key and Account ID

5. After providing the details to authorize Daton to periodically extract data from Inventory Planner.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. 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

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. 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