Integration of IdoSell with BigQuery

Learn how to connect an IdoSell store to Google BigQuery using WitCloud to collect orders, products, product opinions, categories, returns, shop settings and customers.

Updated

Introduction

This module connects your IdoSell store to Google Cloud BigQuery. WitCloud reads your orders, products, product opinions, categories, returns, shop settings and the customers who placed orders through the IdoSell Admin API and stores them in your project's BigQuery dataset. Use it to analyse sales, assortment, returns and customer reviews next to your advertising and web data, and as a source for the All in One tables.

Configuration guide

Follow the steps below to connect IdoSell with BigQuery. WitCloud needs the address of your store and an IdoSell API key.

Generate the API key before you start: you will paste it into WitCloud in the Authorization step. WitCloud only reads data, so the key needs read access to orders, products, product opinions, categories, returns, customers and shop settings.

Create the API key in IdoSell

This step takes place in your IdoSell admin panel, which is not part of WitCloud. Menu names there come from IdoSell and may differ between versions; see the IdoSell documentation if you cannot find them.

  1. Log in to your IdoSell admin panel as an administrator.
  2. Create an API key for the Admin API with read access to the data listed above.
  3. Copy the key. Keep it private: anyone who has it can read your store data.

Module setup

Go to Integrations and click Add integration.

Integrations list with the Add integration button

Select IdoSell from the list of available integrations.

Integration catalog filtered to IdoSell

Enter the Collect name, e.g. "IdoSell PL". A clear name helps you recognise the data source later.

Collect name field filled in with the example name IdoSell PL

Enter the Shop url: the address of your store, including https://, e.g. https://your-shop.com. The Authorize button stays inactive until you enter a valid address. WitCloud does not follow redirects, so enter the final address of your store.

Shop url field filled in with the example address https://demo-shop.example

Authorization

If you have already authorized this IdoSell store in WitCloud, you can pick the existing token from the IdoSell authorization drop-down and skip the next two steps.

Click Authorize.

Authorize button next to the IdoSell authorization field, active once the shop address is filled in

In the Authorize pop-up paste your IdoSell key into the API Key field and click Create. WitCloud checks the key against your store. If the check fails, the reason is shown under the form (see Troubleshooting).

Authorize pop-up with the API Key field filled with an example value

The saved token is selected automatically. You can also choose a token from the IdoSell authorization drop-down; each one is labelled with the shop address and a masked part of the key.

IdoSell authorization drop-down open with one example token

Advanced settings

Click Show advanced settings to see three more fields.

In Data freshness (products, stocks) enter how often, in hours, the tables that hold the current state of the catalogue are refreshed: idosell_products and idosell_categories. If such a table was refreshed less than that many hours ago, the run leaves it as it is. The value must be between 4 and 12 hours; the default is 4.

Advanced settings open with the Data freshness field set to 4 hours

Turn on Static IP if your store sits behind extra network protection such as Cloudflare. All data requests are then sent from one fixed IP address, 34.118.32.227, which you can add to the allowed list of your store.

Static IP switch in the advanced settings

In Tables to collect you can remove the tables you do not need. The field offers orders, products, product_opinions, categories, returns, shops and clients; all of them are selected by default and at least one must stay selected. A table you remove is still created in your dataset, but stays empty.

Tables to collect field with all seven offered tables selected

Click Next.

Collect settings filled in with the Next button

Historical data and scheduling

In Historical Data enter the number of days to fetch on the first run, up to 365.

Historical Data field filled in with 365 days

A data synchronization schedule is created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your IdoSell data will now be synchronized with BigQuery. Orders, returns, product opinions and clients are collected day by day. Products, categories and shop settings are collected in full on each run, and products and categories are refreshed no more often than the data freshness you set.

Data schema

The tables below show the data collected from IdoSell. Orders are collected by the day they were added, returns by the day they were created, and the clients table holds the customers who placed an order on that day.

The orders and clients tables contain personal data of your shoppers, such as names, e-mail addresses, phone numbers and addresses; the clients table also holds dates of birth. Share access to the dataset accordingly.

Data schema for idosell_orders
Field NameModeType
orderBridgeNoteNULLABLESTRING
orderIdNULLABLESTRING
orderDetailsNULLABLERECORD
orderDetails.dropshippingOrderStatusNULLABLESTRING
orderDetails.productsResultsREPEATEDRECORD
orderDetails.productsResults.productOrderPriceNetNULLABLEFLOAT
orderDetails.productsResults.productOrderPriceNULLABLEFLOAT
orderDetails.productsResults.productPanelPriceNULLABLEFLOAT
orderDetails.productsResults.bundleIdNULLABLEINTEGER
orderDetails.productsResults.productWeightNULLABLEINTEGER
orderDetails.productsResults.productQuantityNULLABLEFLOAT
orderDetails.productsResults.productOrderAdditionalNULLABLESTRING
orderDetails.productsResults.sizeIdNULLABLESTRING
orderDetails.productsResults.productSizeCodeExternalNULLABLESTRING
orderDetails.productsResults.productSerialNumbersNULLABLESTRING
orderDetails.productsResults.productNameNULLABLESTRING
orderDetails.productsResults.sizePanelNameNULLABLESTRING
orderDetails.productsResults.productIdNULLABLEINTEGER
orderDetails.productsResults.orderSalesModeNULLABLESTRING
orderDetails.productsResults.basketPositionNULLABLEINTEGER
orderDetails.productsResults.remarksToProductNULLABLESTRING
orderDetails.productsResults.productPanelPriceNetNULLABLEFLOAT
orderDetails.productsResults.productOrderPriceNetBaseCurrencyNULLABLEFLOAT
orderDetails.productsResults.productCodeNULLABLESTRING
orderDetails.productsResults.productVatNULLABLEFLOAT
orderDetails.productsResults.productPriceLogNULLABLESTRING
orderDetails.productsResults.stockIdNULLABLEINTEGER
orderDetails.productsResults.productOrderPriceBaseCurrencyNULLABLEFLOAT
orderDetails.orderPrepareTimeNULLABLEINTEGER
orderDetails.clientRequestInvoiceNULLABLESTRING
orderDetails.orderNoteNULLABLESTRING
orderDetails.clientDeliveryAddressIdNULLABLEINTEGER
orderDetails.orderPackingPersonLoginNULLABLESTRING
orderDetails.clientNoteToOrderNULLABLESTRING
orderDetails.clientNoteToCourierNULLABLESTRING
orderDetails.prepaidsREPEATEDRECORD
orderDetails.prepaids.paymentTypeNULLABLESTRING
orderDetails.prepaids.currencyIdNULLABLESTRING
orderDetails.prepaids.paymentValueNULLABLEFLOAT
orderDetails.prepaids.payformNameNULLABLESTRING
orderDetails.prepaids.paymentOrdinalNumberNULLABLEINTEGER
orderDetails.prepaids.payformIdNULLABLEINTEGER
orderDetails.prepaids.paymentStatusNULLABLESTRING
orderDetails.prepaids.paymentModifiedDateByShopNULLABLESTRING
orderDetails.prepaids.paymentNumberNULLABLESTRING
orderDetails.prepaids.paymentAddDateNULLABLESTRING
orderDetails.prepaids.paymentModifiedDateByClientNULLABLESTRING
orderDetails.prepaids.payformAccountNULLABLESTRING
orderDetails.prepaids.prepaidIdNULLABLEINTEGER
orderDetails.orderDispatchDateNULLABLESTRING
orderDetails.stockIdNULLABLEINTEGER
orderDetails.orderAddDateNULLABLESTRING
orderDetails.apiFlagNULLABLESTRING
orderDetails.auctionInfoNULLABLEJSON
orderDetails.orderOperatorLoginNULLABLESTRING
orderDetails.purchaseDateNULLABLESTRING
orderDetails.orderConfirmationNULLABLESTRING
orderDetails.productRemovedInStockNULLABLESTRING
orderDetails.orderChangeDateNULLABLESTRING
orderDetails.orderSourceResultsNULLABLERECORD
orderDetails.orderSourceResults.auctionsServiceNameNULLABLESTRING
orderDetails.orderSourceResults.orderSourceTypeNULLABLESTRING
orderDetails.orderSourceResults.orderSourceDetailsNULLABLERECORD
orderDetails.orderSourceResults.orderSourceDetails.orderExternalIdNULLABLESTRING
orderDetails.orderSourceResults.orderSourceDetails.orderSourceIdNULLABLEINTEGER
orderDetails.orderSourceResults.orderSourceDetails.fulfillmentNULLABLESTRING
orderDetails.orderSourceResults.orderSourceDetails.orderSourceTypeNULLABLESTRING
orderDetails.orderSourceResults.orderSourceDetails.orderSourceTypeIdNULLABLEINTEGER
orderDetails.orderSourceResults.orderSourceDetails.orderSourceNameNULLABLESTRING
orderDetails.orderSourceResults.orderSourceDetails.freshNULLABLESTRING
orderDetails.orderSourceResults.shopIdNULLABLEINTEGER
orderDetails.orderSourceResults.preorderSourcesDetailsREPEATEDRECORD
orderDetails.orderSourceResults.preorderSourcesDetails.entryDateNULLABLESTRING
orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceNameNULLABLESTRING
orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceIdNULLABLEINTEGER
orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceTypeNULLABLESTRING
orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceTypeIdNULLABLEINTEGER
orderDetails.dispatchNULLABLERECORD
orderDetails.dispatch.deliveryDateAdditionalNULLABLESTRING
orderDetails.dispatch.estimatedDeliveryDateNULLABLESTRING
orderDetails.dispatch.deliveryDateNULLABLESTRING
orderDetails.dispatch.deliveryPackageIdNULLABLESTRING
orderDetails.dispatch.courierIdNULLABLEINTEGER
orderDetails.dispatch.courierNameNULLABLESTRING
orderDetails.dispatch.deliveryWeightNULLABLEINTEGER
orderDetails.dispatch.courierWebserviceOnlyNULLABLEBOOLEAN
orderDetails.orderStatusNULLABLESTRING
orderDetails.paymentsNULLABLERECORD
orderDetails.payments.orderBaseCurrencyNULLABLERECORD
orderDetails.payments.orderBaseCurrency.billingCurrencyNULLABLESTRING
orderDetails.payments.orderBaseCurrency.orderInsuranceVatNULLABLESTRING
orderDetails.payments.orderBaseCurrency.orderInsuranceCostNULLABLEFLOAT
orderDetails.payments.orderBaseCurrency.orderPayformVatNULLABLEFLOAT
orderDetails.payments.orderBaseCurrency.orderProductsCostNULLABLEFLOAT
orderDetails.payments.orderBaseCurrency.orderPayformCostNULLABLEFLOAT
orderDetails.payments.orderBaseCurrency.orderDeliveryVatNULLABLEFLOAT
orderDetails.payments.orderBaseCurrency.orderDeliveryCostNULLABLEFLOAT
orderDetails.payments.orderCurrencyNULLABLERECORD
orderDetails.payments.orderCurrency.orderDeliveryCostNULLABLEFLOAT
orderDetails.payments.orderCurrency.orderInsuranceCostNULLABLEFLOAT
orderDetails.payments.orderCurrency.orderCurrencyValueNULLABLEFLOAT
orderDetails.payments.orderCurrency.orderPayformCostNULLABLEFLOAT
orderDetails.payments.orderCurrency.orderProductsCostNULLABLEFLOAT
orderDetails.payments.orderCurrency.billingCurrencyRateNULLABLEFLOAT
orderDetails.payments.orderCurrency.currencyIdNULLABLESTRING
orderDetails.payments.orderPaymentTypeNULLABLESTRING
orderDetails.payments.orderVatExistsNULLABLESTRING
orderDetails.payments.orderWorthCalculateTypeNULLABLESTRING
orderDetails.payments.orderRebatePercentNULLABLEFLOAT
orderDetails.payments.orderPaymentDaysNULLABLEINTEGER
orderDetails.receivedDateNULLABLESTRING
orderTypeNULLABLESTRING
clientResultNULLABLERECORD
clientResult.clientDeliveryAddressNULLABLERECORD
clientResult.clientDeliveryAddress.clientDeliveryAddressProvinceNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressProvinceIdNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressPhone2NULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressCountryIdNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressFirstNameNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressCountryNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressTypeNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressCityNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressStreetNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressLastNameNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressIdNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressPickupPointInternalIdNULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressPhone1NULLABLESTRING
clientResult.clientDeliveryAddress.clientDeliveryAddressFirmNULLABLESTRING
clientResult.clientAccountNULLABLERECORD
clientResult.clientAccount.clientPhone2NULLABLESTRING
clientResult.clientAccount.clientPhone1NULLABLESTRING
clientResult.clientAccount.clientEmailNULLABLESTRING
clientResult.clientAccount.clientLoginNULLABLESTRING
clientResult.clientAccount.clientCodeExternalNULLABLESTRING
clientResult.clientAccount.clientIdNULLABLEINTEGER
clientResult.clientBillingAddressNULLABLERECORD
clientResult.clientBillingAddress.clientCountryNameNULLABLESTRING
clientResult.clientBillingAddress.clientProvinceNULLABLESTRING
clientResult.clientBillingAddress.clientCountryIdNULLABLESTRING
clientResult.clientBillingAddress.clientPhone2NULLABLESTRING
clientResult.clientBillingAddress.clientCityNULLABLESTRING
clientResult.clientBillingAddress.clientZipCodeNULLABLESTRING
clientResult.clientBillingAddress.clientPhone1NULLABLESTRING
clientResult.clientBillingAddress.clientLastNameNULLABLESTRING
clientResult.clientBillingAddress.clientStreetNULLABLESTRING
clientResult.clientBillingAddress.clientNipNULLABLESTRING
clientResult.clientBillingAddress.clientProvinceIdNULLABLESTRING
clientResult.clientBillingAddress.clientFirmNULLABLESTRING
clientResult.clientBillingAddress.clientFirstNameNULLABLESTRING
clientResult.endClientAccountNULLABLERECORD
clientResult.endClientAccount.clientPhone2NULLABLESTRING
clientResult.endClientAccount.clientPhone1NULLABLESTRING
clientResult.endClientAccount.clientEmailNULLABLESTRING
clientResult.endClientAccount.clientLoginNULLABLESTRING
clientResult.endClientAccount.clientCodeExternalNULLABLESTRING
clientResult.endClientAccount.clientIdNULLABLEINTEGER
orderSerialNumberNULLABLEINTEGER
Data schema for idosell_products
Field NameModeType
productIndividualUrlsDataREPEATEDRECORD
productIndividualUrlsData.shopIdNULLABLEINTEGER
productIndividualUrlsData.langIdNULLABLESTRING
productIndividualUrlsData.urlNULLABLESTRING
bundledIdsREPEATEDINTEGER
productVersionNULLABLERECORD
productVersion.versionGroupNamesNULLABLERECORD
productVersion.versionGroupNames.versionGroupNamesLangDataREPEATEDRECORD
productVersion.versionGroupNames.versionGroupNamesLangData.versionGroupNameNULLABLESTRING
productVersion.versionGroupNames.versionGroupNamesLangData.langIdNULLABLESTRING
productVersion.versionNamesNULLABLERECORD
productVersion.versionNames.versionNamesLangDataREPEATEDRECORD
productVersion.versionNames.versionNamesLangData.versionNameNULLABLESTRING
productVersion.versionNames.versionNamesLangData.langIdNULLABLESTRING
productVersion.versionSettingsNULLABLERECORD
productVersion.versionSettings.versionCommonSumInBasketNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonCurrencyNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonComplexNotesNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonSeriesNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonDictionaryNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonWarrantyNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonProfitPointsNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonAdvanceNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonNoteNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonPhotosNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonLongDescriptionNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonSizesNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonShopsNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonDelivererNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonAvailableProfileNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonWeightNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonDescriptionNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonNameNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonVisibilityNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonPriceNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonRebateNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonIconNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonPriorityNULLABLEBOOLEAN
productVersion.versionSettings.versionDisplayRelCanonicalInShopNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonCategoryNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonMenuItemsNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonProducerNULLABLEBOOLEAN
productVersion.versionSettings.versionDisplayAllInPanelNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonVatNULLABLEBOOLEAN
productVersion.versionSettings.versionDisplayAllInShopNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonCodeNULLABLEBOOLEAN
productVersion.versionSettings.versionCommonAssociatedNULLABLEBOOLEAN
productVersion.versionProductsIdsREPEATEDINTEGER
productVersion.versionParentIdNULLABLEINTEGER
productParametersDistinctionREPEATEDRECORD
productParametersDistinction.parameterValueNameNULLABLESTRING
productParametersDistinction.parameterValueIdNULLABLEINTEGER
productParametersDistinction.parameterNameNULLABLESTRING
productParametersDistinction.parameterIdNULLABLEINTEGER
producerCodesStandardNULLABLESTRING
productBundleItemsREPEATEDRECORD
productBundleItems.bundledAvailableSizesREPEATEDRECORD
productBundleItems.bundledAvailableSizes.sizePanelNameNULLABLESTRING
productBundleItems.bundledAvailableSizes.sizeIdNULLABLESTRING
productBundleItems.isBundleShownNULLABLEBOOLEAN
productBundleItems.bundleQuantityNULLABLEINTEGER
productBundleItems.bundledAllSizesREPEATEDRECORD
productBundleItems.bundledAllSizes.sizePanelNameNULLABLESTRING
productBundleItems.bundledAllSizes.sizeIdNULLABLESTRING
productBundleItems.bundledIdNULLABLEINTEGER
productBundleItems.productIdNULLABLEINTEGER
productTypeNULLABLESTRING
productWarrantyNULLABLERECORD
productWarranty.warrantyIdNULLABLEINTEGER
productWarranty.warrantyNameNULLABLESTRING
productUnitNULLABLERECORD
productUnit.unitPrecisionNULLABLEINTEGER
productUnit.unitIdNULLABLEINTEGER
productUnit.unitNameNULLABLESTRING
productAvailabilityManagementTypeNULLABLESTRING
shopsMaskNULLABLEINTEGER
productInPersistentNULLABLEBOOLEAN
productIsVisibleNULLABLEBOOLEAN
productDiscountNULLABLERECORD
productDiscount.promoteItemEndingDateNULLABLESTRING
productDiscount.promoteItemNormalPriceNULLABLEFLOAT
productDiscount.promoteItemWholesaleNormalPriceNULLABLEFLOAT
productDiscount.promoteItemEnabledNULLABLEBOOLEAN
productSizesAttributesREPEATEDRECORD
productSizesAttributes.productSizeCodeExternalNULLABLESTRING
productSizesAttributes.productStrikethroughWholesalePriceNULLABLEFLOAT
productSizesAttributes.productPosPriceNULLABLEFLOAT
productSizesAttributes.productMinimalPriceNULLABLEFLOAT
productSizesAttributes.sizeIdNULLABLESTRING
productSizesAttributes.productRetailPriceNULLABLEFLOAT
productSizesAttributes.productWholesalePriceNULLABLEFLOAT
productSizesAttributes.productStrikethroughRetailPriceNULLABLEFLOAT
productSizesAttributes.productSizeCodeProducerNULLABLESTRING
productSizesAttributes.sizePanelNameNULLABLESTRING
productSizesAttributes.productInPersistentNULLABLEBOOLEAN
productSizesAttributes.productSizeWeightNULLABLEINTEGER
productSizesAttributes.productAutomaticCalculationPriceNULLABLEFLOAT
productSizesAttributes.productSizeWeightWithoutPackagingNULLABLEINTEGER
productPromotionNULLABLERECORD
productPromotion.promoteItemEndingDateNULLABLESTRING
productPromotion.promoteItemNormalPriceNULLABLEFLOAT
productPromotion.promoteItemWholesaleNormalPriceNULLABLEFLOAT
productPromotion.promoteItemEnabledNULLABLEBOOLEAN
productAdvanceNULLABLERECORD
productAdvance.productAdvancePriceNULLABLEFLOAT
productAdvance.productAdvancePercentNULLABLEFLOAT
productParametersREPEATEDRECORD
productParameters.parameterDescriptionsLangDataREPEATEDRECORD
productParameters.parameterDescriptionsLangData.parameterDescriptionNULLABLESTRING
productParameters.parameterDescriptionsLangData.parameterShopsDataREPEATEDRECORD
productParameters.parameterDescriptionsLangData.parameterShopsData.shopIdNULLABLEINTEGER
productParameters.parameterDescriptionsLangData.parameterShopsData.parameterValueIconCardNULLABLESTRING
productParameters.parameterDescriptionsLangData.parameterShopsData.parameterValueIconProductsListNULLABLESTRING
productParameters.parameterDescriptionsLangData.parameterNameNULLABLESTRING
productParameters.parameterDescriptionsLangData.langIdNULLABLESTRING
productParameters.parameterTypeNULLABLESTRING
productParameters.parameterValuesREPEATEDRECORD
productParameters.parameterValues.parameterValueDescriptionsLangDataREPEATEDRECORD
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueDescriptionNULLABLESTRING
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsDataREPEATEDRECORD
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.shopIdNULLABLEINTEGER
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.parameterValueIconCardNULLABLESTRING
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.parameterValueIconProductsListNULLABLESTRING
productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueNameNULLABLESTRING
productParameters.parameterValues.parameterValueDescriptionsLangData.langIdNULLABLESTRING
productParameters.parameterValues.parameterValueIdNULLABLEINTEGER
productParameters.parameterIdNULLABLEINTEGER
productSizesREPEATEDRECORD
productSizes.sizePanelNameNULLABLESTRING
productSizes.sizeIdNULLABLESTRING
productEnableInPosNULLABLEBOOLEAN
productInExportToPriceComparisonSitesNULLABLESTRING
productShopsREPEATEDRECORD
productShops.shopIdNULLABLEINTEGER
productHotspotsZonesREPEATEDRECORD
productHotspotsZones.productIsSpecialNULLABLEBOOLEAN
productHotspotsZones.productIsPromotionNULLABLEBOOLEAN
productHotspotsZones.productIsDistinguishedNULLABLEBOOLEAN
productHotspotsZones.productIsDiscountNULLABLEBOOLEAN
productHotspotsZones.shopIdNULLABLEINTEGER
productHotspotsZones.productHotspotIsEnabledNULLABLEBOOLEAN
productSaveSerialNumbersNULLABLESTRING
productVatFreeNULLABLEBOOLEAN
productVatNULLABLEFLOAT
productPurchasePriceGrossAverageNULLABLEFLOAT
productIconNULLABLERECORD
productIcon.productIconLargeHeightNULLABLEINTEGER
productIcon.productIconLargeWidthNULLABLEINTEGER
productIcon.productIconHashNULLABLESTRING
productIcon.productIconSmallUrlNULLABLESTRING
productIcon.productIconLargeSizeNULLABLEFLOAT
productIcon.productIconLargeUrlNULLABLESTRING
productIcon.productIconExistsNULLABLEBOOLEAN
productWholesalePriceNULLABLEFLOAT
productMinimalPriceNULLABLEFLOAT
productStrikethroughWholesalePriceNULLABLEFLOAT
productImagesCountNULLABLEINTEGER
availableProfileNULLABLEINTEGER
productStrikethroughRetailPriceNULLABLEFLOAT
productDescriptionsLangDataREPEATEDRECORD
productDescriptionsLangData.productMetaKeywordsNULLABLESTRING
productDescriptionsLangData.productMetaDescriptionNULLABLESTRING
productDescriptionsLangData.productLongDescriptionNULLABLESTRING
productDescriptionsLangData.productPriceComparisonSitesNameNULLABLESTRING
productDescriptionsLangData.productAuctionLongDescriptionNULLABLESTRING
productDescriptionsLangData.productNameNULLABLESTRING
productDescriptionsLangData.productDescriptionNULLABLESTRING
productDescriptionsLangData.productAuctionNameNULLABLESTRING
productDescriptionsLangData.productMetaTitleNULLABLESTRING
productDescriptionsLangData.langIdNULLABLESTRING
sizeChartIdNULLABLEINTEGER
productPosPriceNULLABLEFLOAT
productWeightNULLABLEINTEGER
productInBestsellerNULLABLEBOOLEAN
productInNewNULLABLEBOOLEAN
productCurrenciesShopsREPEATEDRECORD
productCurrenciesShops.currencyIdNULLABLESTRING
productCurrenciesShops.shopIdNULLABLEINTEGER
productComplexNotesNULLABLEINTEGER
currencyIdNULLABLESTRING
availableProfileNameNULLABLESTRING
productPriceChangedTimeNULLABLESTRING
productStocksDataNULLABLERECORD
productStocksData.productOrdersUnfinishedQuantitiesREPEATEDRECORD
productStocksData.productOrdersUnfinishedQuantities.productSizesDataREPEATEDRECORD
productStocksData.productOrdersUnfinishedQuantities.productSizesData.productSizeQuantityNULLABLEFLOAT
productStocksData.productOrdersUnfinishedQuantities.productSizesData.productSizeCodeExternalNULLABLESTRING
productStocksData.productOrdersUnfinishedQuantities.productSizesData.sizePanelNameNULLABLESTRING
productStocksData.productOrdersUnfinishedQuantities.productSizesData.sizeIdNULLABLESTRING
productStocksData.productOrdersUnfinishedQuantities.stockIdNULLABLEINTEGER
productStocksData.productSizesDispositionsNULLABLERECORD
productStocksData.productSizesDispositions.productSizesDispositionsInAuctionsREPEATEDRECORD
productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.productSizeQuantityNULLABLEFLOAT
productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.productSizeCodeExternalNULLABLESTRING
productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.sizePanelNameNULLABLESTRING
productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.sizeIdNULLABLESTRING
productStocksData.productSizesDispositions.productSizesDispositionsInSalesREPEATEDRECORD
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition4wNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition3wNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition1wNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition2wNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition3dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition2dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition5dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityAllStocksNULLABLEFLOAT
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityOutsideStockNULLABLEFLOAT
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityOwnStockNULLABLEFLOAT
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeCodeExternalNULLABLESTRING
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition4dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition6dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition1dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition7dNULLABLEINTEGER
productStocksData.productSizesDispositions.productSizesDispositionsInSales.sizePanelNameNULLABLESTRING
productStocksData.productSizesDispositions.productSizesDispositionsInSales.sizeIdNULLABLESTRING
productStocksData.productSizesStocksLocationsREPEATEDRECORD
productStocksData.productSizesStocksLocations.productSizesLocationREPEATEDRECORD
productStocksData.productSizesStocksLocations.productSizesLocation.stockLocationTextIdNULLABLESTRING
productStocksData.productSizesStocksLocations.productSizesLocation.stockLocationIdNULLABLEINTEGER
productStocksData.productSizesStocksLocations.productSizesLocation.sizeIdNULLABLESTRING
productStocksData.productSizesStocksLocations.stockIdNULLABLEINTEGER
productStocksData.productStocksQuantitiesREPEATEDRECORD
productStocksData.productStocksQuantities.productSizesDataREPEATEDRECORD
productStocksData.productStocksQuantities.productSizesData.productSizeReservationsNULLABLERECORD
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationWholesaleNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationAdhocNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationClientNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationRetailNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationOrderNULLABLEINTEGER
productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationAuctionNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.productSizeQuantityNULLABLEFLOAT
productStocksData.productStocksQuantities.productSizesData.productSizeCodeExternalNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.sizePanelNameNULLABLESTRING
productStocksData.productStocksQuantities.productSizesData.sizeIdNULLABLESTRING
productStocksData.productStocksQuantities.stockIdNULLABLEINTEGER
productStocksData.productSizesDeliveriesREPEATEDRECORD
productStocksData.productSizesDeliveries.productSizeQuantityNULLABLEFLOAT
productStocksData.productSizesDeliveries.sizeIdNULLABLESTRING
productStocksData.productSizesDeliveries.sizePanelNameNULLABLESTRING
productInWrapperNULLABLEINTEGER
productAddingTimeNULLABLESTRING
productMenuREPEATEDRECORD
productMenu.menuItemDescriptionsLangDataREPEATEDRECORD
productMenu.menuItemDescriptionsLangData.menuItemTextIdNULLABLESTRING
productMenu.menuItemDescriptionsLangData.menuItemNameNULLABLESTRING
productMenu.menuItemDescriptionsLangData.langIdNULLABLESTRING
productMenu.menuIdNULLABLEINTEGER
productMenu.shopIdNULLABLEINTEGER
productMenu.menuItemIdNULLABLEINTEGER
productSellByRetailNULLABLEFLOAT
productImagesREPEATEDRECORD
productImages.productImageSizeNULLABLEFLOAT
productImages.productImageIdNULLABLESTRING
productImages.productImageDateNULLABLESTRING
productImages.productImageSmallUrlNULLABLESTRING
productImages.productImageWidthNULLABLEINTEGER
productImages.productImageMediumUrlNULLABLESTRING
productImages.productImageHashNULLABLESTRING
productImages.productImagePriorityNULLABLESTRING
productImages.productImageHeightNULLABLEINTEGER
productImages.productImageLargeUrlNULLABLESTRING
productProfitPointsREPEATEDRECORD
productProfitPoints.productProfitPointsAwardWholesaleNULLABLEFLOAT
productProfitPoints.productProfitPointsAwardRetailNULLABLEFLOAT
productProfitPoints.productProfitPointsCostRetailNULLABLEFLOAT
productProfitPoints.productProfitPointsCostWholesaleNULLABLEFLOAT
productProfitPoints.shopIdNULLABLEINTEGER
productProfitPoints.productProfitPointsAreEnabledNULLABLEBOOLEAN
productPurchasePriceGrossLastNULLABLEFLOAT
productQuantityChangedTimeNULLABLESTRING
productAuctionIconNULLABLERECORD
productAuctionIcon.productAuctionIconExistsNULLABLEBOOLEAN
productPriorityNULLABLEINTEGER
productModificationTimeNULLABLESTRING
categoryIdoSellPathNULLABLESTRING
categoryIdoSellIdNULLABLEINTEGER
delivererIdNULLABLEINTEGER
sizeChartNameNULLABLESTRING
producerIdNULLABLEINTEGER
productSpecialNULLABLERECORD
productSpecial.promoteItemEndingDateNULLABLESTRING
productSpecial.promoteItemNormalPriceNULLABLEFLOAT
productSpecial.promoteItemWholesaleNormalPriceNULLABLEFLOAT
productSpecial.promoteItemEnabledNULLABLEBOOLEAN
producerNameNULLABLESTRING
productSellByWholesaleNULLABLEFLOAT
cnTaricCodeNULLABLESTRING
standardUnitNULLABLERECORD
standardUnit.converterUnitValueNULLABLEFLOAT
standardUnit.contextValueNULLABLESTRING
standardUnit.standardUnitValueNULLABLEFLOAT
categoryNameNULLABLESTRING
productInExportToAmazonMarketplaceNULLABLESTRING
productAutomaticCalculationPriceNULLABLEFLOAT
productSumInBasketNULLABLEBOOLEAN
minQuantityPerOrderNULLABLERECORD
minQuantityPerOrder.minQuantityPerOrderWholesaleNULLABLEINTEGER
minQuantityPerOrder.minQuantityPerOrderRetailNULLABLEINTEGER
productIdNULLABLEINTEGER
productTaxCodeNULLABLESTRING
categoryIdNULLABLEINTEGER
productNoteNULLABLESTRING
productRebateNULLABLEINTEGER
productIsDeletedNULLABLEBOOLEAN
productRetailPriceNULLABLEFLOAT
productGroupIconNULLABLERECORD
productGroupIcon.productGroupIconHashNULLABLESTRING
productGroupIcon.productGroupIconSmallUrlNULLABLESTRING
productGroupIcon.productGroupIconLargeSizeNULLABLEFLOAT
productGroupIcon.productGroupIconLargeHeightNULLABLEINTEGER
productGroupIcon.productGroupIconLargeWidthNULLABLEINTEGER
productGroupIcon.productGroupIconLargeUrlNULLABLESTRING
productGroupIcon.productGroupIconExistsNULLABLEBOOLEAN
delivererNameNULLABLESTRING
sizesGroupIdNULLABLEINTEGER
productDistinguishedNULLABLERECORD
productDistinguished.promoteItemEndingDateNULLABLESTRING
productDistinguished.promoteItemNormalPriceNULLABLEFLOAT
productDistinguished.promoteItemWholesaleNormalPriceNULLABLEFLOAT
productDistinguished.promoteItemEnabledNULLABLEBOOLEAN
productDisplayedCodeNULLABLESTRING
countryOfOriginNULLABLESTRING
productIsGratisNULLABLEBOOLEAN
productSeriesNULLABLERECORD
productSeries.seriesDescriptionsLangDataREPEATEDRECORD
productSeries.seriesDescriptionsLangData.langIdNULLABLESTRING
productSeries.seriesDescriptionsLangData.seriesNameNULLABLESTRING
productSeries.seriesIdNULLABLEINTEGER
productSeries.seriesPanelNameNULLABLESTRING
dispatchSettingsNULLABLERECORD
dispatchSettings.enabledNULLABLEBOOLEAN
productPurchasePriceNetLastNULLABLEFLOAT
productPurchasePriceNetAverageNULLABLEFLOAT
productPromoRetailPriceNULLABLEFLOAT
productAttachmentsNULLABLERECORD
productAttachments.attachmentsREPEATEDRECORD
productAttachments.attachments.attachmentIdNULLABLEINTEGER
productAttachments.attachments.attachmentNameNULLABLESTRING
productAttachments.attachments.attachmentPriorityNULLABLEINTEGER
productAttachments.attachments.attachmentEnableNULLABLESTRING
productAttachments.attachments.attachmentFileTypeNULLABLESTRING
productAttachments.attachments.attachmentFileExtensionNULLABLESTRING
productAttachments.attachments.attachmentDownloadLogNULLABLESTRING
productAttachments.attachments.langIdNULLABLESTRING
productAttachments.attachments.documentTypesREPEATEDRECORD
productAttachments.attachments.documentTypes.documentTypeNULLABLESTRING
productAttachments.attachments.documentTypes.documentNameNULLABLESTRING
productAttachments.attachments.documentTypes.descriptionNULLABLESTRING
Data schema for idosell_categories
Field NameModeType
lang_dataREPEATEDRECORD
lang_data.descriptionNULLABLESTRING
lang_data.plural_nameNULLABLESTRING
lang_data.singular_nameNULLABLESTRING
lang_data.lang_idNULLABLESTRING
product_countNULLABLEINTEGER
pkwiuNULLABLESTRING
parent_idNULLABLEINTEGER
priorityNULLABLEINTEGER
idNULLABLEINTEGER
Data schema for idosell_returns
Field NameModeType
preferedPaymentTypeNULLABLESTRING
incomingShippingNumberNULLABLESTRING
additionalPaymentCostValueNULLABLERECORD
additionalPaymentCostValue.vatNULLABLEFLOAT
additionalPaymentCostValue.netNULLABLEFLOAT
additionalPaymentCostValue.grossNULLABLEFLOAT
clientNoteNULLABLESTRING
return_methodNULLABLESTRING
additional_payment_costNULLABLESTRING
prepaidsREPEATEDRECORD
prepaids.prepaidIdNULLABLESTRING
prepaids.paymentOrdinalNumberNULLABLESTRING
prepaids.paymentNumberNULLABLESTRING
prepaids.paymentAddDateNULLABLESTRING
prepaids.paymentModifiedDateByClientNULLABLESTRING
prepaids.paymentModifiedDateByShopNULLABLESTRING
prepaids.paymentStatusNULLABLESTRING
prepaids.paymentTypeNULLABLESTRING
prepaids.payformIdNULLABLESTRING
prepaids.payformNameNULLABLESTRING
prepaids.payformAccountNULLABLESTRING
prepaids.paymentValueNULLABLESTRING
prepaids.currencyIdNULLABLESTRING
statusNULLABLESTRING
productsREPEATEDRECORD
products.idNULLABLESTRING
products.sizeNULLABLESTRING
products.product_sizecodeNULLABLESTRING
products.quantityNULLABLESTRING
products.priceNULLABLESTRING
products.price_netNULLABLESTRING
products.order_priceNULLABLESTRING
products.order_price_netNULLABLESTRING
products.product_typeNULLABLESTRING
products.pointsNULLABLESTRING
products.points_awardedNULLABLESTRING
products.serial_numbersNULLABLESTRING
products.product_order_additionalNULLABLESTRING
account_numberNULLABLESTRING
package_numberNULLABLESTRING
stock_idNULLABLEINTEGER
include_shipping_costNULLABLESTRING
shop_shipping_cost_vatNULLABLEFLOAT
shippingCostNULLABLERECORD
shippingCost.vatNULLABLEFLOAT
shippingCost.netNULLABLEFLOAT
shippingCost.grossNULLABLEFLOAT
parentStatusNumericNULLABLEINTEGER
shop_shipping_costNULLABLEFLOAT
order_snNULLABLEINTEGER
date_last_editNULLABLESTRING
bridge_noteNULLABLESTRING
parentStatusNameInUserLanguageNULLABLESTRING
userNoteNULLABLESTRING
idNULLABLEINTEGER
date_endNULLABLESTRING
parentStatusNULLABLESTRING
statusNameInUserLanguageNULLABLESTRING
status_numericNULLABLEINTEGER
currencyNULLABLESTRING
date_addNULLABLESTRING
Data schema for idosell_product_opinions
Field NameModeType
modificationDatetimeNULLABLETIMESTAMP
answerDatetimeNULLABLESTRING
scoreNegativeNULLABLEINTEGER
productNULLABLERECORD
product.idNULLABLEINTEGER
shopIdNULLABLEINTEGER
languageNULLABLESTRING
contentNULLABLESTRING
confirmedByPurchaseNULLABLEBOOLEAN
confirmedNULLABLEBOOLEAN
scorePositiveNULLABLEINTEGER
pointsNULLABLEFLOAT
idNULLABLEINTEGER
ratingNULLABLESTRING
hostNULLABLESTRING
answerNULLABLESTRING
createDateNULLABLETIMESTAMP
Data schema for idosell_shops
Field NameModeType
fiscal_printersREPEATEDRECORD
fiscal_printers.idNULLABLEINTEGER
fiscal_printers.nameNULLABLESTRING
fiscal_printers.addressNULLABLESTRING
fiscal_printers.keyNULLABLESTRING
typeOfPrinterProtocolAdressNULLABLESTRING
printersREPEATEDRECORD
printers.idNULLABLEINTEGER
printers.nameNULLABLESTRING
printers.addressNULLABLESTRING
printers.keyNULLABLESTRING
pictures_settingsNULLABLERECORD
pictures_settings.picture_small_widthNULLABLEINTEGER
pictures_settings.picture_medium_heightNULLABLEINTEGER
pictures_settings.picture_medium_widthNULLABLEINTEGER
pictures_settings.picture_large_heightNULLABLEINTEGER
pictures_settings.picture_qualityNULLABLEINTEGER
pictures_settings.group_icon_heightNULLABLEINTEGER
pictures_settings.icon_small_heightNULLABLEINTEGER
pictures_settings.group_icon_widthNULLABLEINTEGER
pictures_settings.auction_icon_heightNULLABLEINTEGER
pictures_settings.icon_large_widthNULLABLEINTEGER
pictures_settings.icon_resizeNULLABLEBOOLEAN
pictures_settings.icon_small_widthNULLABLEINTEGER
pictures_settings.picture_small_heightNULLABLEINTEGER
pictures_settings.picture_large_widthNULLABLEINTEGER
pictures_settings.icon_large_heightNULLABLEINTEGER
pictures_settings.auction_icon_widthNULLABLEINTEGER
pictures_settings.icon_qualityNULLABLEINTEGER
availability_profilesREPEATEDRECORD
availability_profiles.nameNULLABLESTRING
availability_profiles.idNULLABLEINTEGER
warrantiesREPEATEDRECORD
warranties.nameNULLABLESTRING
warranties.idNULLABLEINTEGER
unitsREPEATEDRECORD
units.lang_dataREPEATEDRECORD
units.lang_data.plural_nameNULLABLESTRING
units.lang_data.singular_nameNULLABLESTRING
units.lang_data.fraction_nameNULLABLESTRING
units.lang_data.lang_idNULLABLESTRING
units.unit_visibleNULLABLEBOOLEAN
units.unit_precisionNULLABLEINTEGER
units.unit_nameNULLABLESTRING
units.unit_idNULLABLEINTEGER
dedicated_serverNULLABLEBOOLEAN
languagesREPEATEDRECORD
languages.lang_nameNULLABLESTRING
languages.lang_idNULLABLESTRING
price_comparersREPEATEDRECORD
price_comparers.idNULLABLEINTEGER
price_comparers.nameNULLABLESTRING
price_comparers.keyNULLABLESTRING
price_comparers.activeNULLABLEBOOLEAN
panel_basecurrency_idNULLABLESTRING
panel_settingsNULLABLERECORD
panel_settings.search_by_codeNULLABLERECORD
panel_settings.search_by_code.code_producerNULLABLEBOOLEAN
panel_settings.search_by_code.code_externNULLABLEBOOLEAN
panel_settings.search_by_code.code_iaiNULLABLEBOOLEAN
panel_settings.salesDocumentsAreCreatedByClientNULLABLEBOOLEAN
panel_settings.default_lang_idNULLABLESTRING
panel_settings.stocks_change_disabledNULLABLEBOOLEAN
panel_settings.main_stock_systemNULLABLESTRING
panel_settings.basecurrency_idNULLABLESTRING
panel_settings.stock_state_configNULLABLESTRING
vat_ratesREPEATEDRECORD
vat_rates.valueNULLABLEFLOAT
vat_rates.idNULLABLEINTEGER
inv_prod_name_templaceNULLABLESTRING
shop_owner_dataNULLABLERECORD
shop_owner_data.VATRegisteredNULLABLEBOOLEAN
shop_owner_data.countryNULLABLESTRING
shop_owner_data.addressNULLABLESTRING
shop_owner_data.cityNULLABLESTRING
shop_owner_data.company_short_nameNULLABLESTRING
shop_owner_data.nipNULLABLESTRING
shop_owner_data.krsNULLABLESTRING
shop_owner_data.regonNULLABLESTRING
shop_owner_data.zipcodeNULLABLESTRING
shop_owner_data.company_nameNULLABLESTRING
panel_literalsNULLABLERECORD
panel_literals.warrantyNULLABLESTRING
panel_literals.distinguishedNULLABLESTRING
panel_literals.discountNULLABLESTRING
panel_literals.promotionNULLABLESTRING
shopsREPEATEDRECORD
shops.giftCardsNULLABLERECORD
shops.giftCards.activeNULLABLEBOOLEAN
shops.shop_nameNULLABLESTRING
shops.product_free_invoicesNULLABLESTRING
shops.shop_loyalty_activeNULLABLEBOOLEAN
shops.client_edit_require_fieldsNULLABLERECORD
shops.client_edit_require_fields.phoneNULLABLEBOOLEAN
shops.client_edit_require_fields.vat_numberNULLABLEBOOLEAN
shops.client_edit_require_fields.emailNULLABLEBOOLEAN
shops.client_edit_require_fields.lastnameNULLABLEBOOLEAN
shops.branch_document_dataNULLABLERECORD
shops.branch_document_data.countryNULLABLESTRING
shops.branch_document_data.addressNULLABLESTRING
shops.branch_document_data.cityNULLABLESTRING
shops.branch_document_data.company_short_nameNULLABLESTRING
shops.branch_document_data.nipNULLABLESTRING
shops.branch_document_data.krsNULLABLESTRING
shops.branch_document_data.regonNULLABLESTRING
shops.branch_document_data.zipcodeNULLABLESTRING
shops.branch_document_data.company_nameNULLABLESTRING
shops.active_price_comparersREPEATEDRECORD
shops.active_price_comparers.default_price_percent_diffNULLABLEINTEGER
shops.active_price_comparers.idNULLABLEINTEGER
shops.vouchersNULLABLERECORD
shops.vouchers.activeNULLABLEBOOLEAN
shops.default_icon_urlNULLABLESTRING
shops.currency_idNULLABLESTRING
shops.shop_lang_id_defaultNULLABLESTRING
shops.shop_idNULLABLEINTEGER
client_idNULLABLEINTEGER
stocksREPEATEDRECORD
stocks.stock_nameNULLABLESTRING
stocks.stock_idNULLABLEINTEGER
deliverersREPEATEDRECORD
deliverers.nameNULLABLESTRING
deliverers.idNULLABLEINTEGER
panel_lang_id_defaultNULLABLESTRING
Data schema for idosell_clients
Field NameModeType
clientIdNULLABLEINTEGER
clientLoginNULLABLESTRING
clientEmailNULLABLESTRING
clientCodeExternalNULLABLESTRING
clientTypeNULLABLESTRING
showClientAsPartnerNULLABLESTRING
isUnregisteredNULLABLESTRING
blockAutomaticallyAssigningGroupDiscountNULLABLESTRING
clientRegistrationDateNULLABLESTRING
clientsLastModificationDateNULLABLESTRING
affiliateLoginNULLABLESTRING
affiliateIdNULLABLEINTEGER
operatorNULLABLERECORD
operator.loginNULLABLESTRING
operator.nameNULLABLESTRING
clientBillingAddressNULLABLERECORD
clientBillingAddress.clientFirstNameNULLABLESTRING
clientBillingAddress.clientLastNameNULLABLESTRING
clientBillingAddress.clientFirmNULLABLESTRING
clientBillingAddress.clientNipNULLABLESTRING
clientBillingAddress.clientStreetNULLABLESTRING
clientBillingAddress.clientZipCodeNULLABLESTRING
clientBillingAddress.clientCityNULLABLESTRING
clientBillingAddress.clientCountryIdNULLABLESTRING
clientBillingAddress.clientRegionIdNULLABLESTRING
clientBillingAddress.clientProvinceIdNULLABLESTRING
clientBillingAddress.clientPhone1NULLABLESTRING
clientBillingAddress.clientPhone2NULLABLESTRING
clientPersonalDataNULLABLERECORD
clientPersonalData.clientBirthDateNULLABLESTRING
clientPreferencesNULLABLERECORD
clientPreferences.langIdNULLABLESTRING
clientPreferences.currencyIdNULLABLESTRING
clientPreferences.clientIsWholesalerNULLABLESTRING
clientPreferences.clientVatPreferencesNULLABLESTRING
clientPreferences.clientGroupDiscountNumberNULLABLEINTEGER
clientPreferences.clientGroupDiscountNameNULLABLESTRING
clientPreferences.clientNipUeDeclarationNULLABLESTRING
clientTradeCreditNULLABLERECORD
clientTradeCredit.clientTradeCreditLimitNULLABLEFLOAT
clientTradeCredit.clientTradeCreditUsedNULLABLEFLOAT
clientTradeCredit.currencyIdNULLABLESTRING
clientBalancesREPEATEDRECORD
clientBalances.clientBalanceAmountNULLABLEFLOAT
clientBalances.currencyIdNULLABLESTRING
newsletterEmailApprovalsDataREPEATEDRECORD
newsletterEmailApprovalsData.newsletterEmailApprovalDateNULLABLESTRING
newsletterEmailApprovalsData.shopIdNULLABLEINTEGER
newsletterSmsApprovalsDataREPEATEDRECORD
newsletterSmsApprovalsData.newsletterSmsApprovalDateNULLABLESTRING
newsletterSmsApprovalsData.shopIdNULLABLEINTEGER
clientActiveInShopsREPEATEDRECORD
clientActiveInShops.shopIdNULLABLEINTEGER
clientActiveInShops.shopNameNULLABLESTRING

Troubleshooting

When you click Create in the Authorize pop-up, WitCloud checks the key against your store and shows one of these messages under the form:

  • Invalid IdoSell API key: the key is wrong or has been revoked. Copy it again from IdoSell.
  • IdoSell API key does not have sufficient permissions: give the key read access to the data listed at the top of the configuration guide.
  • Cannot reach IdoSell shop URL: check the Shop url.
  • IdoSell endpoint redirects - invalid API URL: the address redirects somewhere else. Enter the final address of your store.
  • Invalid IdoSell shop URL or token or Invalid IdoSell URL or token: the address does not belong to an IdoSell store, or the key does not match it.
  • IdoSell API request timeout: the store did not answer within 5 seconds. Try again.