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 EasyEcom with Daton
  • Workflow
  • EasyEcom Data

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

EasyEcom V2

EasyEcom ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

EasyEcom Email Address EasyEcom Password

Replication Type

Key based Replication Full Replication

Replication Key

DATE NA

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

Customers

Products

Purchase_orders

Returns

Inventory_details

Inventory_snapshots

Orders

Integrate EasyEcom 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 EasyEcom email address and EasyEcom password.

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

  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

EasyEcom Data

Customers

Purpose: Retrieve all customers

Replication: Full-Based Replication

Replication Key: NA

Fields

FULLNAME
DATATYPE

c_id

NUMERIC

companyname

STRING

customer_support_email

STRING

customer_support_contact

STRING

currency_code

STRING

gstNum

STRING

billingStreet

STRING

billingCity

STRING

billingZipcode

STRING

billingState

STRING

billingCountry

STRING

dispatchStreet

STRING

dispatchCity

STRING

dispatchZipcode

STRING

dispatchState

STRING

dispatchCountry

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Products

Purpose: Returns the list of Products

Replication: Fulload

Replication Key: NA

Fields

FULLNAME
DATATYPE

cp_id

NUMERIC

product_id

NUMERIC

sku

STRING

product_name

STRING

description

STRING

active

NUMERIC

created_at

DATETIME

updated_at

DATETIME

inventory

NUMERIC

product_type

STRING

brand

STRING

colour

STRING

category_id

NUMERIC

brand_id

NUMERIC

category_name

STRING

expiry_type

NUMERIC

company_name

STRING

c_id

NUMERIC

height

NUMERIC

length

NUMERIC

width

NUMERIC

weight

NUMERIC

cost

NUMERIC

mrp

NUMERIC

size

STRING

cp_sub_products_count

NUMERIC

model_no

STRING

hsn_code

STRING

tax_rate

NUMERIC

product_image_url

STRING

cp_inventory

NUMERIC

tax_rate_bn

BIGNUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Purchase Orders

Purpose: Returns the list of Purchase orders

Replication: Fulload

Replication Key: NA

Fields

FULLNAME
DATATYPE

po_id

NUMERIC

total_po_value

STRING

po_number

NUMERIC

po_ref_num

STRING

po_status_id

NUMERIC

po_created_date

DATETIME

po_updated_date

DATETIME

po_created_warehouse

STRING

po_created_warehouse_c_id

NUMERIC

vendor_name

STRING

vendor_c_id

NUMERIC

po_items

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

po_items.purchase_order_detail_id

NUMERIC

po_items.cp_id

NUMERIC

po_items.product_id

NUMERIC

po_items.sku

STRING

po_items.model_no

STRING

po_items.product_description

STRING

po_items.original_quantity

NUMERIC

po_items.pending_quantity

NUMERIC

po_items.item_price

STRING

Returns

Purpose: Retrieve list of all returns

Replication: Fulload

Replication Key: NA

Fields

FULLNAME
DATATYPE

credit_note_id

NUMERIC

invoice_id

NUMERIC

order_id

NUMERIC

reference_code

STRING

company_name

STRING

warehouseId

NUMERIC

forward_shipment_pickup_address

STRING

forward_shipment_pickup_city

STRING

forward_shipment_pickup_state

STRING

forward_shipment_pickup_pin_code

STRING

forward_shipment_pickup_country

STRING

order_type

STRING

order_type_key

STRING

replacement_order

NUMERIC

marketplace

STRING

marketplace_id

NUMERIC

salesmanUserId

NUMERIC

order_date

DATETIME

invoice_date

DATETIME

import_date

DATETIME

last_update_date

DATETIME

manifest_date

DATETIME

credit_note_date

DATETIME

return_date

DATE

manifest_no

STRING

invoice_number

STRING

credit_note_number

STRING

batch_id

NUMERIC

payment_mode

STRING

payment_mode_id

NUMERIC

buyer_gst

STRING

forward_shipment_customer_name

STRING

forward_shipment_customer_contact_num

STRING

forward_shipment_customer_address_line_1

STRING

forward_shipment_customer_address_line_2

STRING

forward_shipment_customer_city

STRING

forward_shipment_customer_pin_code

STRING

forward_shipment_customer_state

STRING

forward_shipment_customer_country

STRING

forward_shipment_customer_email

STRING

forward_shipment_billing_name

STRING

forward_shipment_billing_address_1

STRING

forward_shipment_billing_address_2

STRING

forward_shipment_billing_city

STRING

forward_shipment_billing_state

STRING

forward_shipment_billing_pin_code

STRING

forward_shipment_billing_country

STRING

forward_shipment_billing_mobile

STRING

order_quantity

NUMERIC

total_invoice_amount

NUMERIC

total_invoice_tax

NUMERIC

invoice_collectable_amount

NUMERIC

items

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

total_invoice_tax_bn

BIGNUMERIC

total_invoice_amount_bn

BIGNUMERIC

invoice_collectable_amount_bn

BIGNUMERIC

marketplace_invoice_num

STRING

credit_note_amount

BIGNUMERIC

credit_note_tax_amount

NUMERIC

credit_note_tax_amount_bn

BIGNUMERIC

credit_note_amount_nu

NUMERIC

return_type

STRING

return_awb_number

STRING

seller_gst

STRING

items.company_product_id

NUMERIC

items.product_id

NUMERIC

items.suborder_id

NUMERIC

items.suborder_num

STRING

items.return_reason

STRING

items.inventory_status

STRING

items.shipment_type

STRING

items.suborder_quantity

NUMERIC

items.returned_item_quantity

NUMERIC

items.tax_type

STRING

items.total_item_selling_price

STRING

items.credit_note_total_item_shipping_charge

BIGNUMERIC

items.item_tax_rate

NUMERIC

items.credit_note_total_item_tax

NUMERIC

items.credit_note_total_item_excluding_tax

NUMERIC

items.sku

STRING

items.productName

STRING

items.description

STRING

items.category

STRING

items.brand

STRING

items.model_no

STRING

items.product_tax_code

STRING

items.ean

STRING

items.size

STRING

items.cost

NUMERIC

items.mrp

NUMERIC

items.weight

NUMERIC

items.length

NUMERIC

items.width

NUMERIC

items.height

NUMERIC

Inventory Details

Purpose: Fetches inventory details

Replication: Fulload

Replication Key: NA

Fields

FULLNAME
DATATYPE

companyId

NUMERIC

companyName

STRING

companyProductId

NUMERIC

productId

NUMERIC

availableInventory

NUMERIC

reservedInventory

STRING

sku

STRING

mrp

NUMERIC

creationDate

DATETIME

lastUpdateDate

DATETIME

cost

NUMERIC

skuTaxRate

NUMERIC

color

STRING

size

STRING

weight

NUMERIC

height

NUMERIC

length

NUMERIC

width

NUMERIC

category

STRING

ImageUrl

STRING

brand

STRING

productName

STRING

modelNo

STRING

description

STRING

is_combo

NUMERIC

skuTaxRate_bn

BIGNUMERIC

productUniqueCode

STRING

weight_bn

BIGNUMERIC

height_bn

BIGNUMERIC

length_bn

BIGNUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Inventory Snahpshot

Purpose: Fetches inventory snapshots

Replication: Key-Based

Replication Key: LastDateRun

Fields

fullname
type

c_id

NUMERIC

companyname

STRING

job_type_id

NUMERIC

entry_date

DATETIME

file_url

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Orders

Purpose: Retrieves list of orders

Replication: Key-Based

Replication Key: LastDateRun

FULLNAME
DATATYPE

invoice_id

NUMERIC

order_id

NUMERIC

queue_status

NUMERIC

order_priority

NUMERIC

blockSplit

NUMERIC

reference_code

STRING

company_name

STRING

warehouseId

NUMERIC

import_warehouse_id

NUMERIC

import_warehouse_name

STRING

pickup_address

STRING

pickup_city

STRING

pickup_state

STRING

pickup_pin_code

STRING

pickup_country

STRING

order_type

STRING

order_type_key

STRING

replacement_order

NUMERIC

marketplace

STRING

marketplace_id

NUMERIC

qcPassed

NUMERIC

salesmanUserId

NUMERIC

order_date

DATETIME

tat

DATETIME

invoice_date

STRING

import_date

DATETIME

last_update_date

DATETIME

courier

STRING

carrier_id

NUMERIC

Package Weight

NUMERIC

Package Height

NUMERIC

Package Length

NUMERIC

Package Width

NUMERIC

order_status

STRING

order_status_id

NUMERIC

payment_mode

STRING

payment_mode_id

NUMERIC

buyer_gst

STRING

customer_name

STRING

contact_num

STRING

address_line_1

STRING

address_line_2

STRING

city

STRING

pin_code

STRING

state

STRING

country

STRING

email

STRING

billing_name

STRING

billing_address_1

STRING

billing_address_2

STRING

billing_city

STRING

billing_state

STRING

billing_pin_code

STRING

billing_country

STRING

billing_mobile

STRING

order_quantity

NUMERIC

total_amount

NUMERIC

total_tax

NUMERIC

total_shipping_charge

NUMERIC

total_discount

NUMERIC

collectable_amount

NUMERIC

tcs_rate

NUMERIC

tcs_amount

NUMERIC

customer_code

STRING

suborders

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

documents

RECORD

seller_gst

STRING

manifest_date

DATETIME

manifest_no

STRING

invoice_number

STRING

shipping_last_update_date

DATETIME

awb_number

STRING

shipping_status

STRING

shipping_status_id

NUMERIC

payment_gateway_transaction_number

STRING

payment_gateway_name

STRING

total_tax_bn

BIGNUMERIC

batch_id

NUMERIC

batch_created_at

DATETIME

total_shipping_charge_bn

BIGNUMERIC

total_amount_bn

BIGNUMERIC

total_discount_bn

BIGNUMERIC

collectable_amount_bn

BIGNUMERIC

Package_Length_bn

BIGNUMERIC

Package_Width_bn

BIGNUMERIC

marketplace_invoice_num

STRING

queue_message

STRING

shipping_history

RECORD

Package_Weight_bn

BIGNUMERIC

available_after

DATETIME

Package_Weight_st

STRING

Package_Height_st

STRING

Package_Length_st

STRING

Package_Width_st

STRING

Package_Height_bn

BIGNUMERIC

suborders.suborder_id

NUMERIC

suborders.suborder_num

STRING

suborders.item_status

STRING

suborders.shipment_type

STRING

suborders.suborder_quantity

NUMERIC

suborders.item_quantity

NUMERIC

suborders.returned_quantity

NUMERIC

suborders.cancelled_quantity

NUMERIC

suborders.shipped_quantity

NUMERIC

suborders.serial_nums

STRING

suborders.batchcode_serial

STRING

suborders.tax_type

STRING

suborders.suborder_history

RECORD

suborders.suborder_history.qc_pass_datetime

DATETIME

suborders.selling_price

STRING

suborders.total_shipping_charge

BIGNUMERIC

suborders.tax_rate

NUMERIC

suborders.tax

NUMERIC

suborders.product_id

NUMERIC

suborders.company_product_id

NUMERIC

suborders.sku

STRING

suborders.sku_type

STRING

suborders.sub_product_count

NUMERIC

suborders.marketplace_sku

STRING

suborders.productName

STRING

suborders.description

STRING

suborders.category

STRING

suborders.brand

STRING

suborders.model_no

STRING

suborders.product_tax_code

STRING

suborders.ean

STRING

suborders.size

STRING

suborders.cost

NUMERIC

suborders.mrp

NUMERIC

suborders.weight

NUMERIC

suborders.length

NUMERIC

suborders.width

NUMERIC

suborders.height

NUMERIC

suborders.scheme_applied

NUMERIC

documents.easyecom_invoice

STRING

documents.label

STRING

documents.marketplace_tax_invoice

STRING

shipping_history.status

STRING

shipping_history.time

DATETIME

shipping_history.location

STRING

PreviousEasyecomNextRelease Notes

Last updated 1 year ago

Was this helpful?

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

https://api-docs.easyecom.io/#849fab71-b30d-46c6-94f5-1abea951b595
https://api-docs.easyecom.io/#3129767c-adc5-4a98-9f26-7e27cca3d14c
https://api-docs.easyecom.io/#5a890ecf-5d3d-41a5-a6f2-11489f46b726
https://api-docs.easyecom.io/#b675a104-2ee3-440d-a5fb-d3ea0d0a4a5b
https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8
https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8
https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8