Integracja IdoSell z BigQuery
Dowiedz się, jak połączyć sklep IdoSell z Google BigQuery w WitCloud, aby pobierać zamówienia, produkty, opinie o produktach, kategorie, zwroty, ustawienia sklepu i klientów.
Aktualizacja
Wprowadzenie
Ten moduł łączy Twój sklep IdoSell z Google Cloud BigQuery. WitCloud odczytuje zamówienia, produkty, opinie o produktach, kategorie, zwroty, ustawienia sklepu oraz klientów, którzy złożyli zamówienia, przez IdoSell Admin API i zapisuje je w datasecie BigQuery Twojego projektu. Dzięki temu analizujesz sprzedaż, asortyment, zwroty i opinie klientów obok danych reklamowych i danych z serwisu, a także używasz ich jako źródła dla tabel All in One.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć IdoSell z BigQuery. WitCloud potrzebuje adresu Twojego sklepu i klucza API IdoSell.
Wygeneruj klucz API przed rozpoczęciem: wkleisz go w WitCloud w kroku Autoryzacja. WitCloud tylko odczytuje dane, więc klucz potrzebuje dostępu do odczytu zamówień, produktów, opinii o produktach, kategorii, zwrotów, klientów i ustawień sklepu.
Utwórz klucz API w IdoSell
Ten krok wykonujesz w panelu administracyjnym IdoSell, który nie jest częścią WitCloud. Nazwy menu w nim pochodzą z IdoSell i mogą się różnić w zależności od wersji. Jeśli nie możesz ich znaleźć, zajrzyj do dokumentacji IdoSell.
- Zaloguj się do panelu administracyjnego IdoSell jako administrator.
- Utwórz klucz API dla Admin API z dostępem do odczytu danych wymienionych powyżej.
- Skopiuj klucz. Zachowaj go w tajemnicy: każdy, kto go ma, może odczytać dane Twojego sklepu.
Konfiguracja modułu
Przejdź do Integracje i kliknij Dodaj integrację.

Wybierz IdoSell z listy dostępnych integracji.

Wpisz Nazwa źródła danych, np. „IdoSell PL”. Czytelna nazwa pomoże Ci później rozpoznać źródło danych.

Wpisz Adres URL sklepu: adres Twojego sklepu razem z https://, np. https://your-shop.com. Przycisk Autoryzuj pozostaje nieaktywny, dopóki nie wpiszesz poprawnego adresu. WitCloud nie podąża za przekierowaniami, więc wpisz ostateczny adres sklepu.

Autoryzacja
Jeśli ten sklep IdoSell był już autoryzowany w WitCloud, wybierz istniejący token z listy Autoryzacja IdoSell i pomiń dwa kolejne kroki.
Kliknij Autoryzuj.

W oknie Autoryzuj wklej klucz IdoSell w polu Klucz API i kliknij Utwórz. WitCloud sprawdza klucz w Twoim sklepie. Jeśli sprawdzenie się nie powiedzie, powód zobaczysz pod formularzem (zobacz Rozwiązywanie problemów).

Zapisany token zostanie wybrany automatycznie. Token możesz też wybrać z listy Autoryzacja IdoSell; każdy jest opisany adresem sklepu i zamaskowaną częścią klucza.

Ustawienia zaawansowane
Kliknij Pokaż ustawienia zaawansowane, aby zobaczyć trzy kolejne pola.
W polu Odświeżanie danych (produkty, stany magazynowe) wpisz, co ile godzin mają być odświeżane tabele przechowujące aktualny stan katalogu: idosell_products i idosell_categories. Jeśli taka tabela była odświeżana mniej niż tyle godzin temu, uruchomienie pozostawia ją bez zmian. Wartość musi mieścić się między 4 a 12 godzin; domyślnie jest to 4.

Włącz Stały adres IP, jeśli Twój sklep jest za dodatkową ochroną sieciową, np. Cloudflare. Wszystkie zapytania o dane wychodzą wtedy z jednego stałego adresu IP, 34.118.32.227, który możesz dodać do listy dozwolonych adresów swojego sklepu.

W polu Tabele do pobrania możesz usunąć tabele, których nie potrzebujesz. Pole oferuje orders, products, product_opinions, categories, returns, shops i clients; domyślnie wszystkie są wybrane i co najmniej jedna musi pozostać wybrana. Usunięta tabela nadal jest tworzona w Twoim datasecie, ale pozostaje pusta.

Kliknij Dalej.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, które mają zostać pobrane przy pierwszym uruchomieniu, maksymalnie 365.

Harmonogram synchronizacji danych tworzy się automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane z IdoSell będą teraz synchronizowane z BigQuery. Zamówienia, zwroty, opinie o produktach i klienci są pobierani dzień po dniu. Produkty, kategorie i ustawienia sklepu są pobierane w całości przy każdym uruchomieniu, a produkty i kategorie są odświeżane nie częściej, niż wynosi ustawione odświeżanie danych.
Schemat danych
Poniższe tabele pokazują dane pobierane z IdoSell. Zamówienia są pobierane według dnia ich dodania, zwroty według dnia ich utworzenia, a tabela klientów zawiera klientów, którzy złożyli zamówienie danego dnia.
Tabele zamówień i klientów zawierają dane osobowe Twoich kupujących, takie jak imiona i nazwiska, adresy e-mail, numery telefonów i adresy; tabela klientów zawiera też daty urodzenia. Udostępniaj dataset z rozwagą.
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Rozwiązywanie problemów
Gdy klikniesz Utwórz w oknie Autoryzuj, WitCloud sprawdza klucz w Twoim sklepie i pod formularzem pokazuje jeden z poniższych komunikatów:
- Invalid IdoSell API key: klucz jest błędny albo został unieważniony. Skopiuj go ponownie z IdoSell.
- IdoSell API key does not have sufficient permissions: nadaj kluczowi dostęp do odczytu danych wymienionych na początku przewodnika konfiguracji.
- Cannot reach IdoSell shop URL: sprawdź Adres URL sklepu.
- IdoSell endpoint redirects - invalid API URL: adres przekierowuje gdzie indziej. Wpisz ostateczny adres swojego sklepu.
- Invalid IdoSell shop URL or token lub Invalid IdoSell URL or token: adres nie należy do sklepu IdoSell albo klucz do niego nie pasuje.
- IdoSell API request timeout: sklep nie odpowiedział w ciągu 5 sekund. Spróbuj ponownie.
