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.

  1. Zaloguj się do panelu administracyjnego IdoSell jako administrator.
  2. Utwórz klucz API dla Admin API z dostępem do odczytu danych wymienionych powyżej.
  3. 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ę.

Lista integracji z przyciskiem Dodaj integrację

Wybierz IdoSell z listy dostępnych integracji.

Katalog integracji zawężony do IdoSell

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

Pole Nazwa źródła danych wypełnione przykładową nazwą IdoSell PL

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.

Pole Adres URL sklepu wypełnione przykładowym adresem https://demo-shop.example

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.

Przycisk Autoryzuj obok pola Autoryzacja IdoSell, aktywny po wpisaniu adresu sklepu

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

Okno Autoryzuj z polem Klucz API wypełnionym przykładową wartością

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.

Otwarta lista Autoryzacja IdoSell z jednym przykładowym tokenem

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.

Otwarte ustawienia zaawansowane z polem Odświeżanie danych (produkty, stany magazynowe) ustawionym na 4 godziny

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.

Przełącznik Stały adres IP w ustawieniach zaawansowanych

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.

Pole Tabele do pobrania z wybranymi wszystkimi siedmioma oferowanymi tabelami

Kliknij Dalej.

Wypełnione ustawienia źródła danych z przyciskiem Dalej

Dane historyczne i harmonogram

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

Pole Dane historyczne wypełnione wartością 365 dni

Harmonogram synchronizacji danych tworzy się automatycznie. Więcej informacji na ten temat znajdziesz tutaj.

Kliknij Utwórz, aby zakończyć konfigurację.

Ustawienia pobierania danych z przyciskiem Utwórz

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

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.