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