# Kibo Commerce

### Snapshot

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

### Integrate Kibo Commerce with Daton

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

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

1. **Base URL**:
   1. Login to Kibo Commerce and the URL there (e.g: [https://tenant\_id.sandbox.mozu.com/admin/](https://t31948.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](https://t31948.sandbox.mozu.com/admin/)
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](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.\
      ![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FnUbPCj9gBeu8r4GWPqHe%2Fimage.png?alt=media\&token=68414f23-c746-4a15-b2dd-8cb525d17eb9)
   2. On the new page will be the list of all the site IDs and the names, use the site IDs there.\
      ![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FX6sJO1F0QM8LyDUQPgWO%2Fimage.png?alt=media\&token=799e82e7-b7d6-4366-a980-c6be023f051c)
4. **Master Catalog** enter 1.

### Tables

Source documentation: [https://apidocs.kibocommerce.com/?spec=overview#overview](https://apidocs.kibocommerce.com/?spec=overview#overview)

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.  Customer Accounts\
    Purpose: To get all the data for all \
    Replication: Incremental\
    \


    <table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td><strong>Name</strong></td><td><strong>Datatype</strong></td><td>Policy Tags </td><td>Description</td><td></td></tr><tr><td>emailAddress</td><td>STRING</td><td></td><td></td><td></td></tr><tr><td>userName</td><td>STRING</td><td></td><td></td><td></td></tr><tr><td>firstName</td><td>STRING</td><td></td><td></td><td></td></tr><tr><td>userId</td><td>STRING</td><td></td><td></td><td></td></tr><tr><td>isAnonymous</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>isLocked</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>isActive</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>acceptsMarketing</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>hasExternalPassword</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>id</td><td>NUMERIC</td><td></td><td></td><td></td></tr><tr><td>customerSet</td><td>STRING</td><td></td><td></td><td></td></tr><tr><td>commerceSummary</td><td>RECORD</td><td></td><td></td><td></td></tr><tr><td>taxExempt</td><td>BOOLEAN</td><td></td><td></td><td></td></tr><tr><td>auditInfo</td><td>RECORD</td><td></td><td></td><td></td></tr><tr><td>customerSinceDate</td><td>TIMESTAMP</td><td></td><td></td><td></td></tr><tr><td>accountType</td><td>STRING</td><td></td><td></td><td></td></tr></tbody></table>
3.  Order cancel reasons\
    Purpose: To get all the data for all \
    Replication: Full Load\


    | **Name**      | **Datatype** |
    | ------------- | ------------ |
    | reasonCode    | STRING       |
    | name          | STRING       |
    | needsMoreInfo | BOOLEAN      |

    \

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.  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.  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.  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.  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.  Refund Reasons\
    Purpose: To get all the data for all \
    Replication: Full Load\


    | **Name**      | **Datatype** |
    | ------------- | ------------ |
    | reasonCode    | STRING       |
    | name          | STRING       |
    | needsMoreInfo | BOOLEAN      |

    \
    \

10. Return Reasons\
    Purpose: To get all the data for all \
    Replication: Full Load\


    | **Name** | **Datatype** |
    | -------- | ------------ |
    | items    | STRING       |
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. 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. 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. Orders extended properties\
    Purpose: To get all the data for all \
    Replication: Incremental\
    \


