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
Sign in to Daton.
Select Kibo commerce from the list of Integrations.
Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
Provide Base URL, Application Key, Shared secret, Site ID and Master Catalog ID.
Post which you will be prompted to choose from the list of available tables.
Then select all required fields for each table
Submit the integration
Getting Base URL, Application Key, Shared secret, Site ID and Master Catalog ID.
Base URL:
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
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
Site ID:
Master Catalog enter 1.
Tables
Source documentation: https://apidocs.kibocommerce.com/?spec=overview#overview
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
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
Order cancel reasons Purpose: To get all the data for all Replication: Full Load
Name
Datatype
reasonCode
STRING
name
STRING
needsMoreInfo
BOOLEAN
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
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
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
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
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
Refund Reasons Purpose: To get all the data for all Replication: Full Load
Name
Datatype
reasonCode
STRING
name
STRING
needsMoreInfo
BOOLEAN
Return Reasons Purpose: To get all the data for all Replication: Full Load
Name
Datatype
items
STRING
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
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
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
Orders extended properties Purpose: To get all the data for all Replication: Incremental
Last updated
