Ask or search…
K
Links
Comment on page

Kibo Commerce

Snapshot

Features
Details
Release Status
Released
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Base URL Application Key Shared secret Site ID Master Catalog
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1hr

Integrate Kibo Commerce with Daton

  1. 1.
    Sign in to Daton.
  2. 2.
    Select Kibo commerce from the list of Integrations.
  3. 3.
    Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
  4. 4.
    Provide Base URL, Application Key, Shared secret, Site ID and Master Catalog ID.
  5. 5.
    Post which you will be prompted to choose from the list of available tables.
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Getting Base URL, Application Key, Shared secret, Site ID and Master Catalog ID.

  1. 1.
    Base URL:
    1. 1.
      Login to Kibo Commerce and the URL there (e.g: https://tenant_id.sandbox.mozu.com/admin/) in place of /admin replace it with /api. The final base URL should look something like this: https://tennat_id.sandbox.mozu.com/api
  2. 2.
    Application Key & Shared secret you'll need to create an app and use those key & secret on Daton. Steps: https://www.mozu.com/docs/developer/applications/quickstart.htm
  3. 3.
    Site ID:
    1. 1.
      On the Kibo dashboard, go to the system tab, inside structure and click site.
    2. 2.
      On the new page will be the list of all the site IDs and the names, use the site IDs there.
  4. 4.
    Master Catalog enter 1.

Tables

  1. 1.
    Channels Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    tenantId
    NUMERIC
    code
    STRING
    name
    STRING
    countryCode
    STRING
    siteIds
    STRING
    auditInfo
    RECORD
  2. 2.
    Customer Accounts Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    emailAddress
    STRING
    userName
    STRING
    firstName
    STRING
    userId
    STRING
    isAnonymous
    BOOLEAN
    isLocked
    BOOLEAN
    isActive
    BOOLEAN
    acceptsMarketing
    BOOLEAN
    hasExternalPassword
    BOOLEAN
    id
    NUMERIC
    customerSet
    STRING
    commerceSummary
    RECORD
    taxExempt
    BOOLEAN
    auditInfo
    RECORD
    customerSinceDate
    TIMESTAMP
    accountType
    STRING
  3. 3.
    Order cancel reasons Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    reasonCode
    STRING
    name
    STRING
    needsMoreInfo
    BOOLEAN
  4. 4.
    Orders Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    orderNumber
    NUMERIC
    version
    STRING
    isPartialOrder
    BOOLEAN
    priceListCode
    STRING
    customerAccountId
    NUMERIC
    isTaxExempt
    BOOLEAN
    email
    STRING
    ipAddress
    STRING
    status
    STRING
    type
    STRING
    paymentStatus
    STRING
    returnStatus
    STRING
    isEligibleForReturns
    BOOLEAN
    totalCollected
    NUMERIC
    handlingTotal
    NUMERIC
    fulfillmentStatus
    STRING
    isFulfillable
    BOOLEAN
    submittedDate
    TIMESTAMP
    notes
    RECORD
    items
    RECORD
    billingInfo
    RECORD
    payments
    RECORD
    isDraft
    BOOLEAN
    hasDraft
    BOOLEAN
    isImport
    BOOLEAN
    isHistoricalImport
    BOOLEAN
    isUnified
    BOOLEAN
    amountAvailableForRefund
    NUMERIC
    amountRemainingForPayment
    NUMERIC
    amountRefunded
    NUMERIC
    readyToCapture
    BOOLEAN
    isOptInForSms
    BOOLEAN
    subscriptionIds
    STRING
    continuityOrderOrdinal
    NUMERIC
    userId
    STRING
    id
    STRING
    tenantId
    NUMERIC
    siteId
    NUMERIC
    channelCode
    STRING
    currencyCode
    STRING
    customerInteractionType
    STRING
    fulfillmentInfo
    RECORD
    subtotal
    NUMERIC
    discountedSubtotal
    NUMERIC
  5. 5.
    Payments Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    id
    STRING
    groupId
    RECORD
    paymentServiceTransactionId
    STRING
    availableActions
    STRING
    orderId
    STRING
    paymentType
    STRING
    paymentWorkflow
    STRING
    billingInfo
    RECORD
    data
    RECORD
    status
    STRING
    interactions
    RECORD
    isRecurring
    BOOLEAN
    amountCollected
    NUMERIC
    amountCredited
    NUMERIC
    amountRequested
    NUMERIC
    changeMessages
    RECORD
    auditInfo
    RECORD
  6. 6.
    Pricelists Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    priceListCode
    STRING
    priceListSequence
    NUMERIC
    name
    STRING
    description
    STRING
    enabled
    BOOLEAN
    filteredInStorefront
    BOOLEAN
    validForAllSites
    BOOLEAN
    validSites
    STRING
    resolvable
    BOOLEAN
    auditInfo
    RECORD
  7. 7.
    Product Categories Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    categoryId
    NUMERIC
    categoryCode
    STRING
    content
    RECORD
    sequence
    NUMERIC
    isDisplayed
    BOOLEAN
    count
    NUMERIC
    updateDate
    TIMESTAMP
    shouldSlice
    BOOLEAN
  8. 8.
    Products Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    productCode
    STRING
    productUsage
    STRING
    fulfillmentTypesSupported
    STRING
    masterCatalogId
    NUMERIC
    productSequence
    NUMERIC
    productTypeId
    NUMERIC
    isValidForProductType
    BOOLEAN
    productInCatalogs
    RECORD
    content
    RECORD
    price
    RECORD
    pricingBehavior
    RECORD
    seoContent
    RECORD
    options
    RECORD
    properties
    RECORD
    isTaxable
    BOOLEAN
    inventoryInfo
    RECORD
    isRecurring
    BOOLEAN
    upc
    STRING
    supplierInfo
    RECORD
    isPackagedStandAlone
    BOOLEAN
    standAlonePackageType
    STRING
    packageHeight
    RECORD
    packageWidth
    RECORD
    packageLength
    RECORD
    packageWeight
    RECORD
    isVariation
    BOOLEAN
    hasConfigurableOptions
    BOOLEAN
    hasStandAloneOptions
    BOOLEAN
    publishingInfo
    RECORD
    productImageGroups
    RECORD
    auditInfo
    RECORD
    slicingSettings
    RECORD
    primaryProductCollectionCode
    STRING
  9. 9.
    Refund Reasons Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    reasonCode
    STRING
    name
    STRING
    needsMoreInfo
    BOOLEAN
  10. 10.
    Return Reasons Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    items
    STRING
  11. 11.
    Returns Purpose: To get all the data for all Replication: Incremental
    Name
    Datatype
    id
    STRING
    customerAccountId
    NUMERIC
    customerInteractionType
    STRING
    availableActions
    STRING
    returnNumber
    NUMERIC
    contact
    RECORD
    locationCode
    STRING
    originalOrderId
    STRING
    originalOrderNumber
    NUMERIC
    currencyCode
    STRING
    status
    STRING
    receiveStatus
    STRING
    refundStatus
    STRING
    replaceStatus
    STRING
    items
    RECORD
    returnType
    STRING
    refundAmount
    NUMERIC
    auditInfo
    RECORD
    payments
    RECORD
    productLossTotal
    NUMERIC
    shippingLossTotal
    NUMERIC
    lossTotal
    NUMERIC
    productLossTaxTotal
    NUMERIC
    shippingLossTaxTotal
    NUMERIC
    tenantId
    NUMERIC
    siteId
    NUMERIC
    userId
    STRING
    channelCode
    STRING
    changeMessages
    RECORD
    actionRequired
    BOOLEAN
    isUnified
    BOOLEAN
    canInitiateRefund
    BOOLEAN
    refundToGC
    BOOLEAN
  12. 12.
    Shipments Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    shipmentNumber
    NUMERIC
    orderId
    STRING
    orderNumber
    NUMERIC
    orderSubmitDate
    TIMESTAMP
    customerAccountId
    NUMERIC
    tenantId
    NUMERIC
    siteId
    NUMERIC
    fulfillmentDate
    TIMESTAMP
    shipmentType
    STRING
    shipmentStatus
    STRING
    fulfillmentStatus
    STRING
    fulfillmentLocationCode
    STRING
    assignedLocationCode
    STRING
    workflowProcessId
    STRING
    workflowProcessContainerId
    STRING
    shipmentAdjustment
    NUMERIC
    lineItemSubtotal
    NUMERIC
    lineItemTaxAdjustment
    NUMERIC
    lineItemTaxTotal
    NUMERIC
    lineItemTotal
    NUMERIC
    shippingAdjustment
    NUMERIC
    shippingSubtotal
    NUMERIC
    shippingTaxAdjustment
    NUMERIC
    shippingTaxTotal
    NUMERIC
    shippingTotal
    NUMERIC
    handlingAdjustment
    NUMERIC
    handlingSubtotal
    NUMERIC
    handlingTaxAdjustment
    NUMERIC
    handlingTaxTotal
    NUMERIC
    handlingTotal
    NUMERIC
    dutyAdjustment
    NUMERIC
    dutyTotal
    NUMERIC
    total
    NUMERIC
    currencyCode
    STRING
    destination
    RECORD
    customer
    RECORD
    shippingMethodCode
    STRING
    shippingMethodName
    STRING
    items
    RECORD
    workflowState
    RECORD
    changeMessages
    RECORD
    email
    STRING
    isExpress
    BOOLEAN
    auditInfo
    RECORD
  13. 13.
    Subscriptions Purpose: To get all the data for all Replication: Full Load
    Name
    Datatype
    id
    STRING
    siteId
    NUMERIC
    tenantId
    NUMERIC
    number
    NUMERIC
    parentOrderId
    STRING
    items
    RECORD
    payment
    RECORD
    priceListCode
    STRING
    auditInfo
    RECORD
    fulfillmentInfo
    RECORD
    userId
    STRING
    customerAccountId
    NUMERIC
    email
    STRING
    isTaxExempt
    BOOLEAN
    currencyCode
    STRING
    channelCode
    STRING
    ipAddress
    STRING
    customerInteractionType
    STRING
    frequency
    RECORD
    nextOrderDate
    TIMESTAMP
    ordinal
    NUMERIC
    subTotal
    NUMERIC
    itemLevelProductDiscountTotal
    NUMERIC
    itemLevelAdjustmentsTotal
    NUMERIC
    orderLevelProductDiscountTotal
    NUMERIC
    itemTaxTotal
    NUMERIC
    itemTotal
    NUMERIC
    total
    NUMERIC
    itemLevelShippingDiscountTotal
    NUMERIC
    orderLevelShippingDiscountTotal
    NUMERIC
    shippingAmount
    NUMERIC
    shippingSubTotal
    NUMERIC
    shippingTax
    NUMERIC
    shippingTaxTotal
    NUMERIC
    shippingTotal
    NUMERIC
    itemLevelHandlingDiscountTotal
    NUMERIC
    orderLevelHandlingDiscountTotal
    NUMERIC
    handlingSubTotal
    NUMERIC
    handlingTax
    NUMERIC
    handlingTaxTotal
    NUMERIC
    handlingTotal
    NUMERIC
    dutyTotal
    NUMERIC
    feeTotal
    NUMERIC
    status
    STRING
  14. 14.
    Orders extended properties Purpose: To get all the data for all Replication: Incremental