LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Integrate Inventory Planner with Daton
  • Workflow
  • Inventory Planner Data

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

Inventory Planner

Inventory Planner ETL connector for data replication

PreviousRelease NotesNextJira

Last updated 2 years ago

Was this helpful?

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

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

Source API Documentation:

Click here
https://help.inventory-planner.com/en/articles/6852616-inventory-planner-reports-api