# 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>
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>

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\
    \\
