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.
- Log in to your IdoSell admin panel as an administrator.
- Create an API key for the Admin API with read access to the data listed above.
- Copy the key. Keep it private: anyone who has it can read your store data.
Module setup
Go to Integrations and click Add integration.

Select IdoSell from the list of available integrations.

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

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.

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.

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).

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.

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.

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.

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.

Click Next.

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

A data synchronization schedule is created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

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 Name | Mode | Type |
|---|---|---|
| orderBridgeNote | NULLABLE | STRING |
| orderId | NULLABLE | STRING |
| orderDetails | NULLABLE | RECORD |
| orderDetails.dropshippingOrderStatus | NULLABLE | STRING |
| orderDetails.productsResults | REPEATED | RECORD |
| orderDetails.productsResults.productOrderPriceNet | NULLABLE | FLOAT |
| orderDetails.productsResults.productOrderPrice | NULLABLE | FLOAT |
| orderDetails.productsResults.productPanelPrice | NULLABLE | FLOAT |
| orderDetails.productsResults.bundleId | NULLABLE | INTEGER |
| orderDetails.productsResults.productWeight | NULLABLE | INTEGER |
| orderDetails.productsResults.productQuantity | NULLABLE | FLOAT |
| orderDetails.productsResults.productOrderAdditional | NULLABLE | STRING |
| orderDetails.productsResults.sizeId | NULLABLE | STRING |
| orderDetails.productsResults.productSizeCodeExternal | NULLABLE | STRING |
| orderDetails.productsResults.productSerialNumbers | NULLABLE | STRING |
| orderDetails.productsResults.productName | NULLABLE | STRING |
| orderDetails.productsResults.sizePanelName | NULLABLE | STRING |
| orderDetails.productsResults.productId | NULLABLE | INTEGER |
| orderDetails.productsResults.orderSalesMode | NULLABLE | STRING |
| orderDetails.productsResults.basketPosition | NULLABLE | INTEGER |
| orderDetails.productsResults.remarksToProduct | NULLABLE | STRING |
| orderDetails.productsResults.productPanelPriceNet | NULLABLE | FLOAT |
| orderDetails.productsResults.productOrderPriceNetBaseCurrency | NULLABLE | FLOAT |
| orderDetails.productsResults.productCode | NULLABLE | STRING |
| orderDetails.productsResults.productVat | NULLABLE | FLOAT |
| orderDetails.productsResults.productPriceLog | NULLABLE | STRING |
| orderDetails.productsResults.stockId | NULLABLE | INTEGER |
| orderDetails.productsResults.productOrderPriceBaseCurrency | NULLABLE | FLOAT |
| orderDetails.orderPrepareTime | NULLABLE | INTEGER |
| orderDetails.clientRequestInvoice | NULLABLE | STRING |
| orderDetails.orderNote | NULLABLE | STRING |
| orderDetails.clientDeliveryAddressId | NULLABLE | INTEGER |
| orderDetails.orderPackingPersonLogin | NULLABLE | STRING |
| orderDetails.clientNoteToOrder | NULLABLE | STRING |
| orderDetails.clientNoteToCourier | NULLABLE | STRING |
| orderDetails.prepaids | REPEATED | RECORD |
| orderDetails.prepaids.paymentType | NULLABLE | STRING |
| orderDetails.prepaids.currencyId | NULLABLE | STRING |
| orderDetails.prepaids.paymentValue | NULLABLE | FLOAT |
| orderDetails.prepaids.payformName | NULLABLE | STRING |
| orderDetails.prepaids.paymentOrdinalNumber | NULLABLE | INTEGER |
| orderDetails.prepaids.payformId | NULLABLE | INTEGER |
| orderDetails.prepaids.paymentStatus | NULLABLE | STRING |
| orderDetails.prepaids.paymentModifiedDateByShop | NULLABLE | STRING |
| orderDetails.prepaids.paymentNumber | NULLABLE | STRING |
| orderDetails.prepaids.paymentAddDate | NULLABLE | STRING |
| orderDetails.prepaids.paymentModifiedDateByClient | NULLABLE | STRING |
| orderDetails.prepaids.payformAccount | NULLABLE | STRING |
| orderDetails.prepaids.prepaidId | NULLABLE | INTEGER |
| orderDetails.orderDispatchDate | NULLABLE | STRING |
| orderDetails.stockId | NULLABLE | INTEGER |
| orderDetails.orderAddDate | NULLABLE | STRING |
| orderDetails.apiFlag | NULLABLE | STRING |
| orderDetails.auctionInfo | NULLABLE | JSON |
| orderDetails.orderOperatorLogin | NULLABLE | STRING |
| orderDetails.purchaseDate | NULLABLE | STRING |
| orderDetails.orderConfirmation | NULLABLE | STRING |
| orderDetails.productRemovedInStock | NULLABLE | STRING |
| orderDetails.orderChangeDate | NULLABLE | STRING |
| orderDetails.orderSourceResults | NULLABLE | RECORD |
| orderDetails.orderSourceResults.auctionsServiceName | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceType | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceDetails | NULLABLE | RECORD |
| orderDetails.orderSourceResults.orderSourceDetails.orderExternalId | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceDetails.orderSourceId | NULLABLE | INTEGER |
| orderDetails.orderSourceResults.orderSourceDetails.fulfillment | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceDetails.orderSourceType | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceDetails.orderSourceTypeId | NULLABLE | INTEGER |
| orderDetails.orderSourceResults.orderSourceDetails.orderSourceName | NULLABLE | STRING |
| orderDetails.orderSourceResults.orderSourceDetails.fresh | NULLABLE | STRING |
| orderDetails.orderSourceResults.shopId | NULLABLE | INTEGER |
| orderDetails.orderSourceResults.preorderSourcesDetails | REPEATED | RECORD |
| orderDetails.orderSourceResults.preorderSourcesDetails.entryDate | NULLABLE | STRING |
| orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceName | NULLABLE | STRING |
| orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceId | NULLABLE | INTEGER |
| orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceType | NULLABLE | STRING |
| orderDetails.orderSourceResults.preorderSourcesDetails.orderSourceTypeId | NULLABLE | INTEGER |
| orderDetails.dispatch | NULLABLE | RECORD |
| orderDetails.dispatch.deliveryDateAdditional | NULLABLE | STRING |
| orderDetails.dispatch.estimatedDeliveryDate | NULLABLE | STRING |
| orderDetails.dispatch.deliveryDate | NULLABLE | STRING |
| orderDetails.dispatch.deliveryPackageId | NULLABLE | STRING |
| orderDetails.dispatch.courierId | NULLABLE | INTEGER |
| orderDetails.dispatch.courierName | NULLABLE | STRING |
| orderDetails.dispatch.deliveryWeight | NULLABLE | INTEGER |
| orderDetails.dispatch.courierWebserviceOnly | NULLABLE | BOOLEAN |
| orderDetails.orderStatus | NULLABLE | STRING |
| orderDetails.payments | NULLABLE | RECORD |
| orderDetails.payments.orderBaseCurrency | NULLABLE | RECORD |
| orderDetails.payments.orderBaseCurrency.billingCurrency | NULLABLE | STRING |
| orderDetails.payments.orderBaseCurrency.orderInsuranceVat | NULLABLE | STRING |
| orderDetails.payments.orderBaseCurrency.orderInsuranceCost | NULLABLE | FLOAT |
| orderDetails.payments.orderBaseCurrency.orderPayformVat | NULLABLE | FLOAT |
| orderDetails.payments.orderBaseCurrency.orderProductsCost | NULLABLE | FLOAT |
| orderDetails.payments.orderBaseCurrency.orderPayformCost | NULLABLE | FLOAT |
| orderDetails.payments.orderBaseCurrency.orderDeliveryVat | NULLABLE | FLOAT |
| orderDetails.payments.orderBaseCurrency.orderDeliveryCost | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency | NULLABLE | RECORD |
| orderDetails.payments.orderCurrency.orderDeliveryCost | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.orderInsuranceCost | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.orderCurrencyValue | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.orderPayformCost | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.orderProductsCost | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.billingCurrencyRate | NULLABLE | FLOAT |
| orderDetails.payments.orderCurrency.currencyId | NULLABLE | STRING |
| orderDetails.payments.orderPaymentType | NULLABLE | STRING |
| orderDetails.payments.orderVatExists | NULLABLE | STRING |
| orderDetails.payments.orderWorthCalculateType | NULLABLE | STRING |
| orderDetails.payments.orderRebatePercent | NULLABLE | FLOAT |
| orderDetails.payments.orderPaymentDays | NULLABLE | INTEGER |
| orderDetails.receivedDate | NULLABLE | STRING |
| orderType | NULLABLE | STRING |
| clientResult | NULLABLE | RECORD |
| clientResult.clientDeliveryAddress | NULLABLE | RECORD |
| clientResult.clientDeliveryAddress.clientDeliveryAddressProvince | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressProvinceId | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressPhone2 | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressCountryId | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressFirstName | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressCountry | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressType | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressCity | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressStreet | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressLastName | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressId | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressPickupPointInternalId | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressPhone1 | NULLABLE | STRING |
| clientResult.clientDeliveryAddress.clientDeliveryAddressFirm | NULLABLE | STRING |
| clientResult.clientAccount | NULLABLE | RECORD |
| clientResult.clientAccount.clientPhone2 | NULLABLE | STRING |
| clientResult.clientAccount.clientPhone1 | NULLABLE | STRING |
| clientResult.clientAccount.clientEmail | NULLABLE | STRING |
| clientResult.clientAccount.clientLogin | NULLABLE | STRING |
| clientResult.clientAccount.clientCodeExternal | NULLABLE | STRING |
| clientResult.clientAccount.clientId | NULLABLE | INTEGER |
| clientResult.clientBillingAddress | NULLABLE | RECORD |
| clientResult.clientBillingAddress.clientCountryName | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientProvince | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientCountryId | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientPhone2 | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientCity | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientZipCode | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientPhone1 | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientLastName | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientStreet | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientNip | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientProvinceId | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientFirm | NULLABLE | STRING |
| clientResult.clientBillingAddress.clientFirstName | NULLABLE | STRING |
| clientResult.endClientAccount | NULLABLE | RECORD |
| clientResult.endClientAccount.clientPhone2 | NULLABLE | STRING |
| clientResult.endClientAccount.clientPhone1 | NULLABLE | STRING |
| clientResult.endClientAccount.clientEmail | NULLABLE | STRING |
| clientResult.endClientAccount.clientLogin | NULLABLE | STRING |
| clientResult.endClientAccount.clientCodeExternal | NULLABLE | STRING |
| clientResult.endClientAccount.clientId | NULLABLE | INTEGER |
| orderSerialNumber | NULLABLE | INTEGER |
Data schema for idosell_products
| Field Name | Mode | Type |
|---|---|---|
| productIndividualUrlsData | REPEATED | RECORD |
| productIndividualUrlsData.shopId | NULLABLE | INTEGER |
| productIndividualUrlsData.langId | NULLABLE | STRING |
| productIndividualUrlsData.url | NULLABLE | STRING |
| bundledIds | REPEATED | INTEGER |
| productVersion | NULLABLE | RECORD |
| productVersion.versionGroupNames | NULLABLE | RECORD |
| productVersion.versionGroupNames.versionGroupNamesLangData | REPEATED | RECORD |
| productVersion.versionGroupNames.versionGroupNamesLangData.versionGroupName | NULLABLE | STRING |
| productVersion.versionGroupNames.versionGroupNamesLangData.langId | NULLABLE | STRING |
| productVersion.versionNames | NULLABLE | RECORD |
| productVersion.versionNames.versionNamesLangData | REPEATED | RECORD |
| productVersion.versionNames.versionNamesLangData.versionName | NULLABLE | STRING |
| productVersion.versionNames.versionNamesLangData.langId | NULLABLE | STRING |
| productVersion.versionSettings | NULLABLE | RECORD |
| productVersion.versionSettings.versionCommonSumInBasket | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonCurrency | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonComplexNotes | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonSeries | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonDictionary | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonWarranty | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonProfitPoints | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonAdvance | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonNote | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonPhotos | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonLongDescription | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonSizes | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonShops | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonDeliverer | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonAvailableProfile | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonWeight | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonDescription | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonName | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonVisibility | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonPrice | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonRebate | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonIcon | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonPriority | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionDisplayRelCanonicalInShop | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonCategory | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonMenuItems | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonProducer | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionDisplayAllInPanel | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonVat | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionDisplayAllInShop | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonCode | NULLABLE | BOOLEAN |
| productVersion.versionSettings.versionCommonAssociated | NULLABLE | BOOLEAN |
| productVersion.versionProductsIds | REPEATED | INTEGER |
| productVersion.versionParentId | NULLABLE | INTEGER |
| productParametersDistinction | REPEATED | RECORD |
| productParametersDistinction.parameterValueName | NULLABLE | STRING |
| productParametersDistinction.parameterValueId | NULLABLE | INTEGER |
| productParametersDistinction.parameterName | NULLABLE | STRING |
| productParametersDistinction.parameterId | NULLABLE | INTEGER |
| producerCodesStandard | NULLABLE | STRING |
| productBundleItems | REPEATED | RECORD |
| productBundleItems.bundledAvailableSizes | REPEATED | RECORD |
| productBundleItems.bundledAvailableSizes.sizePanelName | NULLABLE | STRING |
| productBundleItems.bundledAvailableSizes.sizeId | NULLABLE | STRING |
| productBundleItems.isBundleShown | NULLABLE | BOOLEAN |
| productBundleItems.bundleQuantity | NULLABLE | INTEGER |
| productBundleItems.bundledAllSizes | REPEATED | RECORD |
| productBundleItems.bundledAllSizes.sizePanelName | NULLABLE | STRING |
| productBundleItems.bundledAllSizes.sizeId | NULLABLE | STRING |
| productBundleItems.bundledId | NULLABLE | INTEGER |
| productBundleItems.productId | NULLABLE | INTEGER |
| productType | NULLABLE | STRING |
| productWarranty | NULLABLE | RECORD |
| productWarranty.warrantyId | NULLABLE | INTEGER |
| productWarranty.warrantyName | NULLABLE | STRING |
| productUnit | NULLABLE | RECORD |
| productUnit.unitPrecision | NULLABLE | INTEGER |
| productUnit.unitId | NULLABLE | INTEGER |
| productUnit.unitName | NULLABLE | STRING |
| productAvailabilityManagementType | NULLABLE | STRING |
| shopsMask | NULLABLE | INTEGER |
| productInPersistent | NULLABLE | BOOLEAN |
| productIsVisible | NULLABLE | BOOLEAN |
| productDiscount | NULLABLE | RECORD |
| productDiscount.promoteItemEndingDate | NULLABLE | STRING |
| productDiscount.promoteItemNormalPrice | NULLABLE | FLOAT |
| productDiscount.promoteItemWholesaleNormalPrice | NULLABLE | FLOAT |
| productDiscount.promoteItemEnabled | NULLABLE | BOOLEAN |
| productSizesAttributes | REPEATED | RECORD |
| productSizesAttributes.productSizeCodeExternal | NULLABLE | STRING |
| productSizesAttributes.productStrikethroughWholesalePrice | NULLABLE | FLOAT |
| productSizesAttributes.productPosPrice | NULLABLE | FLOAT |
| productSizesAttributes.productMinimalPrice | NULLABLE | FLOAT |
| productSizesAttributes.sizeId | NULLABLE | STRING |
| productSizesAttributes.productRetailPrice | NULLABLE | FLOAT |
| productSizesAttributes.productWholesalePrice | NULLABLE | FLOAT |
| productSizesAttributes.productStrikethroughRetailPrice | NULLABLE | FLOAT |
| productSizesAttributes.productSizeCodeProducer | NULLABLE | STRING |
| productSizesAttributes.sizePanelName | NULLABLE | STRING |
| productSizesAttributes.productInPersistent | NULLABLE | BOOLEAN |
| productSizesAttributes.productSizeWeight | NULLABLE | INTEGER |
| productSizesAttributes.productAutomaticCalculationPrice | NULLABLE | FLOAT |
| productSizesAttributes.productSizeWeightWithoutPackaging | NULLABLE | INTEGER |
| productPromotion | NULLABLE | RECORD |
| productPromotion.promoteItemEndingDate | NULLABLE | STRING |
| productPromotion.promoteItemNormalPrice | NULLABLE | FLOAT |
| productPromotion.promoteItemWholesaleNormalPrice | NULLABLE | FLOAT |
| productPromotion.promoteItemEnabled | NULLABLE | BOOLEAN |
| productAdvance | NULLABLE | RECORD |
| productAdvance.productAdvancePrice | NULLABLE | FLOAT |
| productAdvance.productAdvancePercent | NULLABLE | FLOAT |
| productParameters | REPEATED | RECORD |
| productParameters.parameterDescriptionsLangData | REPEATED | RECORD |
| productParameters.parameterDescriptionsLangData.parameterDescription | NULLABLE | STRING |
| productParameters.parameterDescriptionsLangData.parameterShopsData | REPEATED | RECORD |
| productParameters.parameterDescriptionsLangData.parameterShopsData.shopId | NULLABLE | INTEGER |
| productParameters.parameterDescriptionsLangData.parameterShopsData.parameterValueIconCard | NULLABLE | STRING |
| productParameters.parameterDescriptionsLangData.parameterShopsData.parameterValueIconProductsList | NULLABLE | STRING |
| productParameters.parameterDescriptionsLangData.parameterName | NULLABLE | STRING |
| productParameters.parameterDescriptionsLangData.langId | NULLABLE | STRING |
| productParameters.parameterType | NULLABLE | STRING |
| productParameters.parameterValues | REPEATED | RECORD |
| productParameters.parameterValues.parameterValueDescriptionsLangData | REPEATED | RECORD |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueDescription | NULLABLE | STRING |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData | REPEATED | RECORD |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.shopId | NULLABLE | INTEGER |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.parameterValueIconCard | NULLABLE | STRING |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueShopsData.parameterValueIconProductsList | NULLABLE | STRING |
| productParameters.parameterValues.parameterValueDescriptionsLangData.parameterValueName | NULLABLE | STRING |
| productParameters.parameterValues.parameterValueDescriptionsLangData.langId | NULLABLE | STRING |
| productParameters.parameterValues.parameterValueId | NULLABLE | INTEGER |
| productParameters.parameterId | NULLABLE | INTEGER |
| productSizes | REPEATED | RECORD |
| productSizes.sizePanelName | NULLABLE | STRING |
| productSizes.sizeId | NULLABLE | STRING |
| productEnableInPos | NULLABLE | BOOLEAN |
| productInExportToPriceComparisonSites | NULLABLE | STRING |
| productShops | REPEATED | RECORD |
| productShops.shopId | NULLABLE | INTEGER |
| productHotspotsZones | REPEATED | RECORD |
| productHotspotsZones.productIsSpecial | NULLABLE | BOOLEAN |
| productHotspotsZones.productIsPromotion | NULLABLE | BOOLEAN |
| productHotspotsZones.productIsDistinguished | NULLABLE | BOOLEAN |
| productHotspotsZones.productIsDiscount | NULLABLE | BOOLEAN |
| productHotspotsZones.shopId | NULLABLE | INTEGER |
| productHotspotsZones.productHotspotIsEnabled | NULLABLE | BOOLEAN |
| productSaveSerialNumbers | NULLABLE | STRING |
| productVatFree | NULLABLE | BOOLEAN |
| productVat | NULLABLE | FLOAT |
| productPurchasePriceGrossAverage | NULLABLE | FLOAT |
| productIcon | NULLABLE | RECORD |
| productIcon.productIconLargeHeight | NULLABLE | INTEGER |
| productIcon.productIconLargeWidth | NULLABLE | INTEGER |
| productIcon.productIconHash | NULLABLE | STRING |
| productIcon.productIconSmallUrl | NULLABLE | STRING |
| productIcon.productIconLargeSize | NULLABLE | FLOAT |
| productIcon.productIconLargeUrl | NULLABLE | STRING |
| productIcon.productIconExists | NULLABLE | BOOLEAN |
| productWholesalePrice | NULLABLE | FLOAT |
| productMinimalPrice | NULLABLE | FLOAT |
| productStrikethroughWholesalePrice | NULLABLE | FLOAT |
| productImagesCount | NULLABLE | INTEGER |
| availableProfile | NULLABLE | INTEGER |
| productStrikethroughRetailPrice | NULLABLE | FLOAT |
| productDescriptionsLangData | REPEATED | RECORD |
| productDescriptionsLangData.productMetaKeywords | NULLABLE | STRING |
| productDescriptionsLangData.productMetaDescription | NULLABLE | STRING |
| productDescriptionsLangData.productLongDescription | NULLABLE | STRING |
| productDescriptionsLangData.productPriceComparisonSitesName | NULLABLE | STRING |
| productDescriptionsLangData.productAuctionLongDescription | NULLABLE | STRING |
| productDescriptionsLangData.productName | NULLABLE | STRING |
| productDescriptionsLangData.productDescription | NULLABLE | STRING |
| productDescriptionsLangData.productAuctionName | NULLABLE | STRING |
| productDescriptionsLangData.productMetaTitle | NULLABLE | STRING |
| productDescriptionsLangData.langId | NULLABLE | STRING |
| sizeChartId | NULLABLE | INTEGER |
| productPosPrice | NULLABLE | FLOAT |
| productWeight | NULLABLE | INTEGER |
| productInBestseller | NULLABLE | BOOLEAN |
| productInNew | NULLABLE | BOOLEAN |
| productCurrenciesShops | REPEATED | RECORD |
| productCurrenciesShops.currencyId | NULLABLE | STRING |
| productCurrenciesShops.shopId | NULLABLE | INTEGER |
| productComplexNotes | NULLABLE | INTEGER |
| currencyId | NULLABLE | STRING |
| availableProfileName | NULLABLE | STRING |
| productPriceChangedTime | NULLABLE | STRING |
| productStocksData | NULLABLE | RECORD |
| productStocksData.productOrdersUnfinishedQuantities | REPEATED | RECORD |
| productStocksData.productOrdersUnfinishedQuantities.productSizesData | REPEATED | RECORD |
| productStocksData.productOrdersUnfinishedQuantities.productSizesData.productSizeQuantity | NULLABLE | FLOAT |
| productStocksData.productOrdersUnfinishedQuantities.productSizesData.productSizeCodeExternal | NULLABLE | STRING |
| productStocksData.productOrdersUnfinishedQuantities.productSizesData.sizePanelName | NULLABLE | STRING |
| productStocksData.productOrdersUnfinishedQuantities.productSizesData.sizeId | NULLABLE | STRING |
| productStocksData.productOrdersUnfinishedQuantities.stockId | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions | NULLABLE | RECORD |
| productStocksData.productSizesDispositions.productSizesDispositionsInAuctions | REPEATED | RECORD |
| productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.productSizeQuantity | NULLABLE | FLOAT |
| productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.productSizeCodeExternal | NULLABLE | STRING |
| productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.sizePanelName | NULLABLE | STRING |
| productStocksData.productSizesDispositions.productSizesDispositionsInAuctions.sizeId | NULLABLE | STRING |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales | REPEATED | RECORD |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition4w | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition3w | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition1w | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition2w | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition3d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition2d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition5d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityAllStocks | NULLABLE | FLOAT |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityOutsideStock | NULLABLE | FLOAT |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeQuantityOwnStock | NULLABLE | FLOAT |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeCodeExternal | NULLABLE | STRING |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition4d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition6d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition1d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.productSizeDisposition7d | NULLABLE | INTEGER |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.sizePanelName | NULLABLE | STRING |
| productStocksData.productSizesDispositions.productSizesDispositionsInSales.sizeId | NULLABLE | STRING |
| productStocksData.productSizesStocksLocations | REPEATED | RECORD |
| productStocksData.productSizesStocksLocations.productSizesLocation | REPEATED | RECORD |
| productStocksData.productSizesStocksLocations.productSizesLocation.stockLocationTextId | NULLABLE | STRING |
| productStocksData.productSizesStocksLocations.productSizesLocation.stockLocationId | NULLABLE | INTEGER |
| productStocksData.productSizesStocksLocations.productSizesLocation.sizeId | NULLABLE | STRING |
| productStocksData.productSizesStocksLocations.stockId | NULLABLE | INTEGER |
| productStocksData.productStocksQuantities | REPEATED | RECORD |
| productStocksData.productStocksQuantities.productSizesData | REPEATED | RECORD |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations | NULLABLE | RECORD |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationWholesale | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationAdhoc | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationClient | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationRetail | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationOrder | NULLABLE | INTEGER |
| productStocksData.productStocksQuantities.productSizesData.productSizeReservations.productSizeReservationAuction | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.productSizeQuantity | NULLABLE | FLOAT |
| productStocksData.productStocksQuantities.productSizesData.productSizeCodeExternal | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.sizePanelName | NULLABLE | STRING |
| productStocksData.productStocksQuantities.productSizesData.sizeId | NULLABLE | STRING |
| productStocksData.productStocksQuantities.stockId | NULLABLE | INTEGER |
| productStocksData.productSizesDeliveries | REPEATED | RECORD |
| productStocksData.productSizesDeliveries.productSizeQuantity | NULLABLE | FLOAT |
| productStocksData.productSizesDeliveries.sizeId | NULLABLE | STRING |
| productStocksData.productSizesDeliveries.sizePanelName | NULLABLE | STRING |
| productInWrapper | NULLABLE | INTEGER |
| productAddingTime | NULLABLE | STRING |
| productMenu | REPEATED | RECORD |
| productMenu.menuItemDescriptionsLangData | REPEATED | RECORD |
| productMenu.menuItemDescriptionsLangData.menuItemTextId | NULLABLE | STRING |
| productMenu.menuItemDescriptionsLangData.menuItemName | NULLABLE | STRING |
| productMenu.menuItemDescriptionsLangData.langId | NULLABLE | STRING |
| productMenu.menuId | NULLABLE | INTEGER |
| productMenu.shopId | NULLABLE | INTEGER |
| productMenu.menuItemId | NULLABLE | INTEGER |
| productSellByRetail | NULLABLE | FLOAT |
| productImages | REPEATED | RECORD |
| productImages.productImageSize | NULLABLE | FLOAT |
| productImages.productImageId | NULLABLE | STRING |
| productImages.productImageDate | NULLABLE | STRING |
| productImages.productImageSmallUrl | NULLABLE | STRING |
| productImages.productImageWidth | NULLABLE | INTEGER |
| productImages.productImageMediumUrl | NULLABLE | STRING |
| productImages.productImageHash | NULLABLE | STRING |
| productImages.productImagePriority | NULLABLE | STRING |
| productImages.productImageHeight | NULLABLE | INTEGER |
| productImages.productImageLargeUrl | NULLABLE | STRING |
| productProfitPoints | REPEATED | RECORD |
| productProfitPoints.productProfitPointsAwardWholesale | NULLABLE | FLOAT |
| productProfitPoints.productProfitPointsAwardRetail | NULLABLE | FLOAT |
| productProfitPoints.productProfitPointsCostRetail | NULLABLE | FLOAT |
| productProfitPoints.productProfitPointsCostWholesale | NULLABLE | FLOAT |
| productProfitPoints.shopId | NULLABLE | INTEGER |
| productProfitPoints.productProfitPointsAreEnabled | NULLABLE | BOOLEAN |
| productPurchasePriceGrossLast | NULLABLE | FLOAT |
| productQuantityChangedTime | NULLABLE | STRING |
| productAuctionIcon | NULLABLE | RECORD |
| productAuctionIcon.productAuctionIconExists | NULLABLE | BOOLEAN |
| productPriority | NULLABLE | INTEGER |
| productModificationTime | NULLABLE | STRING |
| categoryIdoSellPath | NULLABLE | STRING |
| categoryIdoSellId | NULLABLE | INTEGER |
| delivererId | NULLABLE | INTEGER |
| sizeChartName | NULLABLE | STRING |
| producerId | NULLABLE | INTEGER |
| productSpecial | NULLABLE | RECORD |
| productSpecial.promoteItemEndingDate | NULLABLE | STRING |
| productSpecial.promoteItemNormalPrice | NULLABLE | FLOAT |
| productSpecial.promoteItemWholesaleNormalPrice | NULLABLE | FLOAT |
| productSpecial.promoteItemEnabled | NULLABLE | BOOLEAN |
| producerName | NULLABLE | STRING |
| productSellByWholesale | NULLABLE | FLOAT |
| cnTaricCode | NULLABLE | STRING |
| standardUnit | NULLABLE | RECORD |
| standardUnit.converterUnitValue | NULLABLE | FLOAT |
| standardUnit.contextValue | NULLABLE | STRING |
| standardUnit.standardUnitValue | NULLABLE | FLOAT |
| categoryName | NULLABLE | STRING |
| productInExportToAmazonMarketplace | NULLABLE | STRING |
| productAutomaticCalculationPrice | NULLABLE | FLOAT |
| productSumInBasket | NULLABLE | BOOLEAN |
| minQuantityPerOrder | NULLABLE | RECORD |
| minQuantityPerOrder.minQuantityPerOrderWholesale | NULLABLE | INTEGER |
| minQuantityPerOrder.minQuantityPerOrderRetail | NULLABLE | INTEGER |
| productId | NULLABLE | INTEGER |
| productTaxCode | NULLABLE | STRING |
| categoryId | NULLABLE | INTEGER |
| productNote | NULLABLE | STRING |
| productRebate | NULLABLE | INTEGER |
| productIsDeleted | NULLABLE | BOOLEAN |
| productRetailPrice | NULLABLE | FLOAT |
| productGroupIcon | NULLABLE | RECORD |
| productGroupIcon.productGroupIconHash | NULLABLE | STRING |
| productGroupIcon.productGroupIconSmallUrl | NULLABLE | STRING |
| productGroupIcon.productGroupIconLargeSize | NULLABLE | FLOAT |
| productGroupIcon.productGroupIconLargeHeight | NULLABLE | INTEGER |
| productGroupIcon.productGroupIconLargeWidth | NULLABLE | INTEGER |
| productGroupIcon.productGroupIconLargeUrl | NULLABLE | STRING |
| productGroupIcon.productGroupIconExists | NULLABLE | BOOLEAN |
| delivererName | NULLABLE | STRING |
| sizesGroupId | NULLABLE | INTEGER |
| productDistinguished | NULLABLE | RECORD |
| productDistinguished.promoteItemEndingDate | NULLABLE | STRING |
| productDistinguished.promoteItemNormalPrice | NULLABLE | FLOAT |
| productDistinguished.promoteItemWholesaleNormalPrice | NULLABLE | FLOAT |
| productDistinguished.promoteItemEnabled | NULLABLE | BOOLEAN |
| productDisplayedCode | NULLABLE | STRING |
| countryOfOrigin | NULLABLE | STRING |
| productIsGratis | NULLABLE | BOOLEAN |
| productSeries | NULLABLE | RECORD |
| productSeries.seriesDescriptionsLangData | REPEATED | RECORD |
| productSeries.seriesDescriptionsLangData.langId | NULLABLE | STRING |
| productSeries.seriesDescriptionsLangData.seriesName | NULLABLE | STRING |
| productSeries.seriesId | NULLABLE | INTEGER |
| productSeries.seriesPanelName | NULLABLE | STRING |
| dispatchSettings | NULLABLE | RECORD |
| dispatchSettings.enabled | NULLABLE | BOOLEAN |
| productPurchasePriceNetLast | NULLABLE | FLOAT |
| productPurchasePriceNetAverage | NULLABLE | FLOAT |
| productPromoRetailPrice | NULLABLE | FLOAT |
| productAttachments | NULLABLE | RECORD |
| productAttachments.attachments | REPEATED | RECORD |
| productAttachments.attachments.attachmentId | NULLABLE | INTEGER |
| productAttachments.attachments.attachmentName | NULLABLE | STRING |
| productAttachments.attachments.attachmentPriority | NULLABLE | INTEGER |
| productAttachments.attachments.attachmentEnable | NULLABLE | STRING |
| productAttachments.attachments.attachmentFileType | NULLABLE | STRING |
| productAttachments.attachments.attachmentFileExtension | NULLABLE | STRING |
| productAttachments.attachments.attachmentDownloadLog | NULLABLE | STRING |
| productAttachments.attachments.langId | NULLABLE | STRING |
| productAttachments.attachments.documentTypes | REPEATED | RECORD |
| productAttachments.attachments.documentTypes.documentType | NULLABLE | STRING |
| productAttachments.attachments.documentTypes.documentName | NULLABLE | STRING |
| productAttachments.attachments.documentTypes.description | NULLABLE | STRING |
Data schema for idosell_categories
| Field Name | Mode | Type |
|---|---|---|
| lang_data | REPEATED | RECORD |
| lang_data.description | NULLABLE | STRING |
| lang_data.plural_name | NULLABLE | STRING |
| lang_data.singular_name | NULLABLE | STRING |
| lang_data.lang_id | NULLABLE | STRING |
| product_count | NULLABLE | INTEGER |
| pkwiu | NULLABLE | STRING |
| parent_id | NULLABLE | INTEGER |
| priority | NULLABLE | INTEGER |
| id | NULLABLE | INTEGER |
Data schema for idosell_returns
| Field Name | Mode | Type |
|---|---|---|
| preferedPaymentType | NULLABLE | STRING |
| incomingShippingNumber | NULLABLE | STRING |
| additionalPaymentCostValue | NULLABLE | RECORD |
| additionalPaymentCostValue.vat | NULLABLE | FLOAT |
| additionalPaymentCostValue.net | NULLABLE | FLOAT |
| additionalPaymentCostValue.gross | NULLABLE | FLOAT |
| clientNote | NULLABLE | STRING |
| return_method | NULLABLE | STRING |
| additional_payment_cost | NULLABLE | STRING |
| prepaids | REPEATED | RECORD |
| prepaids.prepaidId | NULLABLE | STRING |
| prepaids.paymentOrdinalNumber | NULLABLE | STRING |
| prepaids.paymentNumber | NULLABLE | STRING |
| prepaids.paymentAddDate | NULLABLE | STRING |
| prepaids.paymentModifiedDateByClient | NULLABLE | STRING |
| prepaids.paymentModifiedDateByShop | NULLABLE | STRING |
| prepaids.paymentStatus | NULLABLE | STRING |
| prepaids.paymentType | NULLABLE | STRING |
| prepaids.payformId | NULLABLE | STRING |
| prepaids.payformName | NULLABLE | STRING |
| prepaids.payformAccount | NULLABLE | STRING |
| prepaids.paymentValue | NULLABLE | STRING |
| prepaids.currencyId | NULLABLE | STRING |
| status | NULLABLE | STRING |
| products | REPEATED | RECORD |
| products.id | NULLABLE | STRING |
| products.size | NULLABLE | STRING |
| products.product_sizecode | NULLABLE | STRING |
| products.quantity | NULLABLE | STRING |
| products.price | NULLABLE | STRING |
| products.price_net | NULLABLE | STRING |
| products.order_price | NULLABLE | STRING |
| products.order_price_net | NULLABLE | STRING |
| products.product_type | NULLABLE | STRING |
| products.points | NULLABLE | STRING |
| products.points_awarded | NULLABLE | STRING |
| products.serial_numbers | NULLABLE | STRING |
| products.product_order_additional | NULLABLE | STRING |
| account_number | NULLABLE | STRING |
| package_number | NULLABLE | STRING |
| stock_id | NULLABLE | INTEGER |
| include_shipping_cost | NULLABLE | STRING |
| shop_shipping_cost_vat | NULLABLE | FLOAT |
| shippingCost | NULLABLE | RECORD |
| shippingCost.vat | NULLABLE | FLOAT |
| shippingCost.net | NULLABLE | FLOAT |
| shippingCost.gross | NULLABLE | FLOAT |
| parentStatusNumeric | NULLABLE | INTEGER |
| shop_shipping_cost | NULLABLE | FLOAT |
| order_sn | NULLABLE | INTEGER |
| date_last_edit | NULLABLE | STRING |
| bridge_note | NULLABLE | STRING |
| parentStatusNameInUserLanguage | NULLABLE | STRING |
| userNote | NULLABLE | STRING |
| id | NULLABLE | INTEGER |
| date_end | NULLABLE | STRING |
| parentStatus | NULLABLE | STRING |
| statusNameInUserLanguage | NULLABLE | STRING |
| status_numeric | NULLABLE | INTEGER |
| currency | NULLABLE | STRING |
| date_add | NULLABLE | STRING |
Data schema for idosell_product_opinions
| Field Name | Mode | Type |
|---|---|---|
| modificationDatetime | NULLABLE | TIMESTAMP |
| answerDatetime | NULLABLE | STRING |
| scoreNegative | NULLABLE | INTEGER |
| product | NULLABLE | RECORD |
| product.id | NULLABLE | INTEGER |
| shopId | NULLABLE | INTEGER |
| language | NULLABLE | STRING |
| content | NULLABLE | STRING |
| confirmedByPurchase | NULLABLE | BOOLEAN |
| confirmed | NULLABLE | BOOLEAN |
| scorePositive | NULLABLE | INTEGER |
| points | NULLABLE | FLOAT |
| id | NULLABLE | INTEGER |
| rating | NULLABLE | STRING |
| host | NULLABLE | STRING |
| answer | NULLABLE | STRING |
| createDate | NULLABLE | TIMESTAMP |
Data schema for idosell_shops
| Field Name | Mode | Type |
|---|---|---|
| fiscal_printers | REPEATED | RECORD |
| fiscal_printers.id | NULLABLE | INTEGER |
| fiscal_printers.name | NULLABLE | STRING |
| fiscal_printers.address | NULLABLE | STRING |
| fiscal_printers.key | NULLABLE | STRING |
| typeOfPrinterProtocolAdress | NULLABLE | STRING |
| printers | REPEATED | RECORD |
| printers.id | NULLABLE | INTEGER |
| printers.name | NULLABLE | STRING |
| printers.address | NULLABLE | STRING |
| printers.key | NULLABLE | STRING |
| pictures_settings | NULLABLE | RECORD |
| pictures_settings.picture_small_width | NULLABLE | INTEGER |
| pictures_settings.picture_medium_height | NULLABLE | INTEGER |
| pictures_settings.picture_medium_width | NULLABLE | INTEGER |
| pictures_settings.picture_large_height | NULLABLE | INTEGER |
| pictures_settings.picture_quality | NULLABLE | INTEGER |
| pictures_settings.group_icon_height | NULLABLE | INTEGER |
| pictures_settings.icon_small_height | NULLABLE | INTEGER |
| pictures_settings.group_icon_width | NULLABLE | INTEGER |
| pictures_settings.auction_icon_height | NULLABLE | INTEGER |
| pictures_settings.icon_large_width | NULLABLE | INTEGER |
| pictures_settings.icon_resize | NULLABLE | BOOLEAN |
| pictures_settings.icon_small_width | NULLABLE | INTEGER |
| pictures_settings.picture_small_height | NULLABLE | INTEGER |
| pictures_settings.picture_large_width | NULLABLE | INTEGER |
| pictures_settings.icon_large_height | NULLABLE | INTEGER |
| pictures_settings.auction_icon_width | NULLABLE | INTEGER |
| pictures_settings.icon_quality | NULLABLE | INTEGER |
| availability_profiles | REPEATED | RECORD |
| availability_profiles.name | NULLABLE | STRING |
| availability_profiles.id | NULLABLE | INTEGER |
| warranties | REPEATED | RECORD |
| warranties.name | NULLABLE | STRING |
| warranties.id | NULLABLE | INTEGER |
| units | REPEATED | RECORD |
| units.lang_data | REPEATED | RECORD |
| units.lang_data.plural_name | NULLABLE | STRING |
| units.lang_data.singular_name | NULLABLE | STRING |
| units.lang_data.fraction_name | NULLABLE | STRING |
| units.lang_data.lang_id | NULLABLE | STRING |
| units.unit_visible | NULLABLE | BOOLEAN |
| units.unit_precision | NULLABLE | INTEGER |
| units.unit_name | NULLABLE | STRING |
| units.unit_id | NULLABLE | INTEGER |
| dedicated_server | NULLABLE | BOOLEAN |
| languages | REPEATED | RECORD |
| languages.lang_name | NULLABLE | STRING |
| languages.lang_id | NULLABLE | STRING |
| price_comparers | REPEATED | RECORD |
| price_comparers.id | NULLABLE | INTEGER |
| price_comparers.name | NULLABLE | STRING |
| price_comparers.key | NULLABLE | STRING |
| price_comparers.active | NULLABLE | BOOLEAN |
| panel_basecurrency_id | NULLABLE | STRING |
| panel_settings | NULLABLE | RECORD |
| panel_settings.search_by_code | NULLABLE | RECORD |
| panel_settings.search_by_code.code_producer | NULLABLE | BOOLEAN |
| panel_settings.search_by_code.code_extern | NULLABLE | BOOLEAN |
| panel_settings.search_by_code.code_iai | NULLABLE | BOOLEAN |
| panel_settings.salesDocumentsAreCreatedByClient | NULLABLE | BOOLEAN |
| panel_settings.default_lang_id | NULLABLE | STRING |
| panel_settings.stocks_change_disabled | NULLABLE | BOOLEAN |
| panel_settings.main_stock_system | NULLABLE | STRING |
| panel_settings.basecurrency_id | NULLABLE | STRING |
| panel_settings.stock_state_config | NULLABLE | STRING |
| vat_rates | REPEATED | RECORD |
| vat_rates.value | NULLABLE | FLOAT |
| vat_rates.id | NULLABLE | INTEGER |
| inv_prod_name_templace | NULLABLE | STRING |
| shop_owner_data | NULLABLE | RECORD |
| shop_owner_data.VATRegistered | NULLABLE | BOOLEAN |
| shop_owner_data.country | NULLABLE | STRING |
| shop_owner_data.address | NULLABLE | STRING |
| shop_owner_data.city | NULLABLE | STRING |
| shop_owner_data.company_short_name | NULLABLE | STRING |
| shop_owner_data.nip | NULLABLE | STRING |
| shop_owner_data.krs | NULLABLE | STRING |
| shop_owner_data.regon | NULLABLE | STRING |
| shop_owner_data.zipcode | NULLABLE | STRING |
| shop_owner_data.company_name | NULLABLE | STRING |
| panel_literals | NULLABLE | RECORD |
| panel_literals.warranty | NULLABLE | STRING |
| panel_literals.distinguished | NULLABLE | STRING |
| panel_literals.discount | NULLABLE | STRING |
| panel_literals.promotion | NULLABLE | STRING |
| shops | REPEATED | RECORD |
| shops.giftCards | NULLABLE | RECORD |
| shops.giftCards.active | NULLABLE | BOOLEAN |
| shops.shop_name | NULLABLE | STRING |
| shops.product_free_invoices | NULLABLE | STRING |
| shops.shop_loyalty_active | NULLABLE | BOOLEAN |
| shops.client_edit_require_fields | NULLABLE | RECORD |
| shops.client_edit_require_fields.phone | NULLABLE | BOOLEAN |
| shops.client_edit_require_fields.vat_number | NULLABLE | BOOLEAN |
| shops.client_edit_require_fields.email | NULLABLE | BOOLEAN |
| shops.client_edit_require_fields.lastname | NULLABLE | BOOLEAN |
| shops.branch_document_data | NULLABLE | RECORD |
| shops.branch_document_data.country | NULLABLE | STRING |
| shops.branch_document_data.address | NULLABLE | STRING |
| shops.branch_document_data.city | NULLABLE | STRING |
| shops.branch_document_data.company_short_name | NULLABLE | STRING |
| shops.branch_document_data.nip | NULLABLE | STRING |
| shops.branch_document_data.krs | NULLABLE | STRING |
| shops.branch_document_data.regon | NULLABLE | STRING |
| shops.branch_document_data.zipcode | NULLABLE | STRING |
| shops.branch_document_data.company_name | NULLABLE | STRING |
| shops.active_price_comparers | REPEATED | RECORD |
| shops.active_price_comparers.default_price_percent_diff | NULLABLE | INTEGER |
| shops.active_price_comparers.id | NULLABLE | INTEGER |
| shops.vouchers | NULLABLE | RECORD |
| shops.vouchers.active | NULLABLE | BOOLEAN |
| shops.default_icon_url | NULLABLE | STRING |
| shops.currency_id | NULLABLE | STRING |
| shops.shop_lang_id_default | NULLABLE | STRING |
| shops.shop_id | NULLABLE | INTEGER |
| client_id | NULLABLE | INTEGER |
| stocks | REPEATED | RECORD |
| stocks.stock_name | NULLABLE | STRING |
| stocks.stock_id | NULLABLE | INTEGER |
| deliverers | REPEATED | RECORD |
| deliverers.name | NULLABLE | STRING |
| deliverers.id | NULLABLE | INTEGER |
| panel_lang_id_default | NULLABLE | STRING |
Data schema for idosell_clients
| Field Name | Mode | Type |
|---|---|---|
| clientId | NULLABLE | INTEGER |
| clientLogin | NULLABLE | STRING |
| clientEmail | NULLABLE | STRING |
| clientCodeExternal | NULLABLE | STRING |
| clientType | NULLABLE | STRING |
| showClientAsPartner | NULLABLE | STRING |
| isUnregistered | NULLABLE | STRING |
| blockAutomaticallyAssigningGroupDiscount | NULLABLE | STRING |
| clientRegistrationDate | NULLABLE | STRING |
| clientsLastModificationDate | NULLABLE | STRING |
| affiliateLogin | NULLABLE | STRING |
| affiliateId | NULLABLE | INTEGER |
| operator | NULLABLE | RECORD |
| operator.login | NULLABLE | STRING |
| operator.name | NULLABLE | STRING |
| clientBillingAddress | NULLABLE | RECORD |
| clientBillingAddress.clientFirstName | NULLABLE | STRING |
| clientBillingAddress.clientLastName | NULLABLE | STRING |
| clientBillingAddress.clientFirm | NULLABLE | STRING |
| clientBillingAddress.clientNip | NULLABLE | STRING |
| clientBillingAddress.clientStreet | NULLABLE | STRING |
| clientBillingAddress.clientZipCode | NULLABLE | STRING |
| clientBillingAddress.clientCity | NULLABLE | STRING |
| clientBillingAddress.clientCountryId | NULLABLE | STRING |
| clientBillingAddress.clientRegionId | NULLABLE | STRING |
| clientBillingAddress.clientProvinceId | NULLABLE | STRING |
| clientBillingAddress.clientPhone1 | NULLABLE | STRING |
| clientBillingAddress.clientPhone2 | NULLABLE | STRING |
| clientPersonalData | NULLABLE | RECORD |
| clientPersonalData.clientBirthDate | NULLABLE | STRING |
| clientPreferences | NULLABLE | RECORD |
| clientPreferences.langId | NULLABLE | STRING |
| clientPreferences.currencyId | NULLABLE | STRING |
| clientPreferences.clientIsWholesaler | NULLABLE | STRING |
| clientPreferences.clientVatPreferences | NULLABLE | STRING |
| clientPreferences.clientGroupDiscountNumber | NULLABLE | INTEGER |
| clientPreferences.clientGroupDiscountName | NULLABLE | STRING |
| clientPreferences.clientNipUeDeclaration | NULLABLE | STRING |
| clientTradeCredit | NULLABLE | RECORD |
| clientTradeCredit.clientTradeCreditLimit | NULLABLE | FLOAT |
| clientTradeCredit.clientTradeCreditUsed | NULLABLE | FLOAT |
| clientTradeCredit.currencyId | NULLABLE | STRING |
| clientBalances | REPEATED | RECORD |
| clientBalances.clientBalanceAmount | NULLABLE | FLOAT |
| clientBalances.currencyId | NULLABLE | STRING |
| newsletterEmailApprovalsData | REPEATED | RECORD |
| newsletterEmailApprovalsData.newsletterEmailApprovalDate | NULLABLE | STRING |
| newsletterEmailApprovalsData.shopId | NULLABLE | INTEGER |
| newsletterSmsApprovalsData | REPEATED | RECORD |
| newsletterSmsApprovalsData.newsletterSmsApprovalDate | NULLABLE | STRING |
| newsletterSmsApprovalsData.shopId | NULLABLE | INTEGER |
| clientActiveInShops | REPEATED | RECORD |
| clientActiveInShops.shopId | NULLABLE | INTEGER |
| clientActiveInShops.shopName | NULLABLE | STRING |
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.
