Comment on page
Kibo Commerce
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 |
- 1.Sign in to Daton.
- 2.Select Kibo commerce from the list of Integrations.
- 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.Provide Base URL, Application Key, Shared secret, Site ID and Master Catalog ID.
- 5.Post which you will be prompted to choose from the list of available tables.
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Base URL:
- 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.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.Site ID:
- 1.On the Kibo dashboard, go to the system tab, inside structure and click site.
- 2.On the new page will be the list of all the site IDs and the names, use the site IDs there.
- 4.Master Catalog enter 1.
- 1.Channels Purpose: To get all the data for all Replication: Full LoadNameDatatypetenantIdNUMERICcodeSTRINGnameSTRINGcountryCodeSTRINGsiteIdsSTRINGauditInfoRECORD
- 2.Customer Accounts Purpose: To get all the data for all Replication: IncrementalNameDatatypeemailAddressSTRINGuserNameSTRINGfirstNameSTRINGuserIdSTRINGisAnonymousBOOLEANisLockedBOOLEANisActiveBOOLEANacceptsMarketingBOOLEANhasExternalPasswordBOOLEANidNUMERICcustomerSetSTRINGcommerceSummaryRECORDtaxExemptBOOLEANauditInfoRECORDcustomerSinceDateTIMESTAMPaccountTypeSTRING
- 3.Order cancel reasons Purpose: To get all the data for all Replication: Full LoadNameDatatypereasonCodeSTRINGnameSTRINGneedsMoreInfoBOOLEAN
- 4.Orders Purpose: To get all the data for all Replication: IncrementalNameDatatypeorderNumberNUMERICversionSTRINGisPartialOrderBOOLEANpriceListCodeSTRINGcustomerAccountIdNUMERICisTaxExemptBOOLEANemailSTRINGipAddressSTRINGstatusSTRINGtypeSTRINGpaymentStatusSTRINGreturnStatusSTRINGisEligibleForReturnsBOOLEANtotalCollectedNUMERIChandlingTotalNUMERICfulfillmentStatusSTRINGisFulfillableBOOLEANsubmittedDateTIMESTAMPnotesRECORDitemsRECORDbillingInfoRECORDpaymentsRECORDisDraftBOOLEANhasDraftBOOLEANisImportBOOLEANisHistoricalImportBOOLEANisUnifiedBOOLEANamountAvailableForRefundNUMERICamountRemainingForPaymentNUMERICamountRefundedNUMERICreadyToCaptureBOOLEANisOptInForSmsBOOLEANsubscriptionIdsSTRINGcontinuityOrderOrdinalNUMERICuserIdSTRINGidSTRINGtenantIdNUMERICsiteIdNUMERICchannelCodeSTRINGcurrencyCodeSTRINGcustomerInteractionTypeSTRINGfulfillmentInfoRECORDsubtotalNUMERICdiscountedSubtotalNUMERIC
- 5.Payments Purpose: To get all the data for all Replication: IncrementalNameDatatypeidSTRINGgroupIdRECORDpaymentServiceTransactionIdSTRINGavailableActionsSTRINGorderIdSTRINGpaymentTypeSTRINGpaymentWorkflowSTRINGbillingInfoRECORDdataRECORDstatusSTRINGinteractionsRECORDisRecurringBOOLEANamountCollectedNUMERICamountCreditedNUMERICamountRequestedNUMERICchangeMessagesRECORDauditInfoRECORD
- 6.Pricelists Purpose: To get all the data for all Replication: IncrementalNameDatatypepriceListCodeSTRINGpriceListSequenceNUMERICnameSTRINGdescriptionSTRINGenabledBOOLEANfilteredInStorefrontBOOLEANvalidForAllSitesBOOLEANvalidSitesSTRINGresolvableBOOLEANauditInfoRECORD
- 7.Product Categories Purpose: To get all the data for all Replication: IncrementalNameDatatypecategoryIdNUMERICcategoryCodeSTRINGcontentRECORDsequenceNUMERICisDisplayedBOOLEANcountNUMERICupdateDateTIMESTAMPshouldSliceBOOLEAN
- 8.Products Purpose: To get all the data for all Replication: IncrementalNameDatatypeproductCodeSTRINGproductUsageSTRINGfulfillmentTypesSupportedSTRINGmasterCatalogIdNUMERICproductSequenceNUMERICproductTypeIdNUMERICisValidForProductTypeBOOLEANproductInCatalogsRECORDcontentRECORDpriceRECORDpricingBehaviorRECORDseoContentRECORDoptionsRECORDpropertiesRECORDisTaxableBOOLEANinventoryInfoRECORDisRecurringBOOLEANupcSTRINGsupplierInfoRECORDisPackagedStandAloneBOOLEANstandAlonePackageTypeSTRINGpackageHeightRECORDpackageWidthRECORDpackageLengthRECORDpackageWeightRECORDisVariationBOOLEANhasConfigurableOptionsBOOLEANhasStandAloneOptionsBOOLEANpublishingInfoRECORDproductImageGroupsRECORDauditInfoRECORDslicingSettingsRECORDprimaryProductCollectionCodeSTRING
- 9.Refund Reasons Purpose: To get all the data for all Replication: Full LoadNameDatatypereasonCodeSTRINGnameSTRINGneedsMoreInfoBOOLEAN
- 10.Return Reasons Purpose: To get all the data for all Replication: Full LoadNameDatatypeitemsSTRING
- 11.Returns Purpose: To get all the data for all Replication: IncrementalNameDatatypeidSTRINGcustomerAccountIdNUMERICcustomerInteractionTypeSTRINGavailableActionsSTRINGreturnNumberNUMERICcontactRECORDlocationCodeSTRINGoriginalOrderIdSTRINGoriginalOrderNumberNUMERICcurrencyCodeSTRINGstatusSTRINGreceiveStatusSTRINGrefundStatusSTRINGreplaceStatusSTRINGitemsRECORDreturnTypeSTRINGrefundAmountNUMERICauditInfoRECORDpaymentsRECORDproductLossTotalNUMERICshippingLossTotalNUMERIClossTotalNUMERICproductLossTaxTotalNUMERICshippingLossTaxTotalNUMERICtenantIdNUMERICsiteIdNUMERICuserIdSTRINGchannelCodeSTRINGchangeMessagesRECORDactionRequiredBOOLEANisUnifiedBOOLEANcanInitiateRefundBOOLEANrefundToGCBOOLEAN
- 12.Shipments Purpose: To get all the data for all Replication: Full LoadNameDatatypeshipmentNumberNUMERICorderIdSTRINGorderNumberNUMERICorderSubmitDateTIMESTAMPcustomerAccountIdNUMERICtenantIdNUMERICsiteIdNUMERICfulfillmentDateTIMESTAMPshipmentTypeSTRINGshipmentStatusSTRINGfulfillmentStatusSTRINGfulfillmentLocationCodeSTRINGassignedLocationCodeSTRINGworkflowProcessIdSTRINGworkflowProcessContainerIdSTRINGshipmentAdjustmentNUMERIClineItemSubtotalNUMERIClineItemTaxAdjustmentNUMERIClineItemTaxTotalNUMERIClineItemTotalNUMERICshippingAdjustmentNUMERICshippingSubtotalNUMERICshippingTaxAdjustmentNUMERICshippingTaxTotalNUMERICshippingTotalNUMERIChandlingAdjustmentNUMERIChandlingSubtotalNUMERIChandlingTaxAdjustmentNUMERIChandlingTaxTotalNUMERIChandlingTotalNUMERICdutyAdjustmentNUMERICdutyTotalNUMERICtotalNUMERICcurrencyCodeSTRINGdestinationRECORDcustomerRECORDshippingMethodCodeSTRINGshippingMethodNameSTRINGitemsRECORDworkflowStateRECORDchangeMessagesRECORDemailSTRINGisExpressBOOLEANauditInfoRECORD
- 13.Subscriptions Purpose: To get all the data for all Replication: Full LoadNameDatatypeidSTRINGsiteIdNUMERICtenantIdNUMERICnumberNUMERICparentOrderIdSTRINGitemsRECORDpaymentRECORDpriceListCodeSTRINGauditInfoRECORDfulfillmentInfoRECORDuserIdSTRINGcustomerAccountIdNUMERICemailSTRINGisTaxExemptBOOLEANcurrencyCodeSTRINGchannelCodeSTRINGipAddressSTRINGcustomerInteractionTypeSTRINGfrequencyRECORDnextOrderDateTIMESTAMPordinalNUMERICsubTotalNUMERICitemLevelProductDiscountTotalNUMERICitemLevelAdjustmentsTotalNUMERICorderLevelProductDiscountTotalNUMERICitemTaxTotalNUMERICitemTotalNUMERICtotalNUMERICitemLevelShippingDiscountTotalNUMERICorderLevelShippingDiscountTotalNUMERICshippingAmountNUMERICshippingSubTotalNUMERICshippingTaxNUMERICshippingTaxTotalNUMERICshippingTotalNUMERICitemLevelHandlingDiscountTotalNUMERICorderLevelHandlingDiscountTotalNUMERIChandlingSubTotalNUMERIChandlingTaxNUMERIChandlingTaxTotalNUMERIChandlingTotalNUMERICdutyTotalNUMERICfeeTotalNUMERICstatusSTRING
- 14.Orders extended properties Purpose: To get all the data for all Replication: Incremental
Last modified 1yr ago