Integration of Shoper with BigQuery
Learn how to connect Shoper to Google BigQuery using WitCloud to collect orders, order products, products, categories, stock and other shop data from your store.
Updated
Introduction
This module connects your Shoper store to Google Cloud BigQuery. WitCloud reads your orders and the products in them, your product catalogue (products, images, categories, stock levels, producers) and the shop's settings (statuses, currencies, payment and shipping methods, taxes) through the Shoper API and stores them in your project's BigQuery dataset. You can then analyse sales, products and stock together with your advertising data.
Configuration guide
Follow the steps below to connect Shoper with BigQuery. WitCloud needs the address of your store and the username and password of a Shoper account that can use Shoper's REST API (WebAPI).
Prepare the Shoper account before you start: you enter its username and password in the Authorization step. Only data is read from your store; WitCloud does not change anything in it.
Prepare the Shoper account
This step takes place in your Shoper administration panel, which is not part of WitCloud, so it is not shown here. How to create an account with access to the Shoper REST API (WebAPI) is described in Shoper's own documentation.
Make sure you have the username and the password of such an account. Keep them private: anyone who has them can read your store data through the API.
Module setup
Go to Integrations and click Add integration.

Select Shoper from the list of available integrations.

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

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

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

In the Authorize pop-up enter the Username and the password of your Shoper account and click Create. WitCloud checks them against your store and saves them so that it can renew access later. If the password is wrong, the shop address cannot be reached or is not valid, the reason is shown under the form.

The saved token is selected automatically and is named after your shop address and username. You can also choose a token from the Shoper authorization drop-down.

Advanced settings
Click Show advanced settings to see three more fields.
In Data freshness (products, stocks) enter how often, in hours, the tables that hold the whole catalogue (products, product images and stock) are refreshed. A table that was updated more recently than that is skipped on the next run. The value must be between 4 and 12 hours; the default is 4.

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

In Tables to collect you can remove the tables you do not need. The field offers orders, order_products, products, product_images, categories, categories_tree, stock, producers, statuses, currencies, option_values, application_config, payments, shippings and taxes; all of them are selected by default and at least one must stay selected.

Click Next.

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

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

Done! Your Shoper data will now be synchronized with BigQuery. Orders and order products are collected day by day, so the historical days are filled in for them; all the other tables are collected in full on each run.
Data schema
Expand the tables below to view the full data schema collected from Shoper.
Data schema for shoper_application_config
| Field Name | Mode | Type |
|---|---|---|
| is_mobile | NULLABLE | BOOLEAN |
| is_facebook | NULLABLE | BOOLEAN |
| shop_url | NULLABLE | STRING |
| shop_email | NULLABLE | STRING |
| shop_company_name | NULLABLE | STRING |
| shop_phone | NULLABLE | STRING |
| shop_tax_id | NULLABLE | STRING |
| shop_address_1 | NULLABLE | STRING |
| shop_address_2 | NULLABLE | STRING |
| shop_city | NULLABLE | STRING |
| shop_zip_code | NULLABLE | STRING |
| shop_province | NULLABLE | STRING |
| shop_country | NULLABLE | STRING |
| shop_trade | NULLABLE | STRING |
| shop_regon | NULLABLE | STRING |
| shop_off | NULLABLE | STRING |
| shop_name | NULLABLE | STRING |
| shop_full_address | NULLABLE | STRING |
| shop_trade_code | NULLABLE | STRING |
| product_defaults_tax_id | NULLABLE | STRING |
| product_defaults_code | NULLABLE | STRING |
| product_defaults_stock | NULLABLE | STRING |
| product_defaults_warn_level | NULLABLE | STRING |
| product_defaults_order | NULLABLE | STRING |
| product_defaults_active | NULLABLE | STRING |
| product_defaults_weight | NULLABLE | STRING |
| product_defaults_unit_id | NULLABLE | STRING |
| product_defaults_availability_id | NULLABLE | STRING |
| product_defaults_delivery_id | NULLABLE | STRING |
| product_defaults_bundle_unit_id | NULLABLE | STRING |
| license_id | NULLABLE | STRING |
| shopping_vat_eu_enable | NULLABLE | STRING |
| shopping_allow_product_different_currency | NULLABLE | STRING |
| shopping_price_levels | NULLABLE | STRING |
| shopping_save_basket | NULLABLE | STRING |
| shopping_update_stock_on_buy | NULLABLE | STRING |
| shopping_basket_adding | NULLABLE | STRING |
| shopping_allow_to_buy_not_reg | NULLABLE | STRING |
| shopping_order_via_token | NULLABLE | STRING |
| shopping_confirm_order | NULLABLE | STRING |
| shopping_min_prod_quantity | NULLABLE | STRING |
| shopping_min_order_value | NULLABLE | STRING |
| shopping_off | NULLABLE | STRING |
| shopping_products_allow_zero | NULLABLE | STRING |
| shopping_allow_overselling | NULLABLE | STRING |
| shopping_parcel_create_status_id | NULLABLE | STRING |
| shopping_parcel_send_status_id | NULLABLE | STRING |
| shopping_change_status_payment_made_id | NULLABLE | STRING |
| shopping_change_status_refund_made_id | NULLABLE | STRING |
| shopping_shipping_extra_step | NULLABLE | STRING |
| shopping_newproducts_days | NULLABLE | STRING |
| shopping_newproducts_mode | NULLABLE | STRING |
| shopping_bestseller_days | NULLABLE | STRING |
| shopping_bestseller_mode | NULLABLE | STRING |
| shopping_bestseller_algorithm | NULLABLE | STRING |
| shopping_price_comparision_field | NULLABLE | STRING |
| shopping_volumetric_weight_enable | NULLABLE | STRING |
| shopping_promo_codes_enable | NULLABLE | STRING |
| shopping_pesel | NULLABLE | STRING |
| product_notifies_enable | NULLABLE | STRING |
| registration_enable | NULLABLE | STRING |
| registration_confirm | NULLABLE | STRING |
| registration_login_to_see_price | NULLABLE | STRING |
| registration_new_cust_discount | NULLABLE | STRING |
| registration_require_address | NULLABLE | STRING |
| shipping_add_payment_cost_to_free_shipping | NULLABLE | STRING |
| shipping_volumetric_weight_enable | NULLABLE | STRING |
| product_search_type | NULLABLE | STRING |
| product_search_all_tokens | NULLABLE | STRING |
| product_search_code | NULLABLE | STRING |
| product_search_short_description | NULLABLE | STRING |
| product_search_description | NULLABLE | STRING |
| digital_product_unlocking_status_id | NULLABLE | STRING |
| digital_product_link_expiration_time | NULLABLE | STRING |
| digital_product_number_of_downloads | NULLABLE | STRING |
| comment_enable | NULLABLE | STRING |
| comment_for_users | NULLABLE | STRING |
| comment_moderation | NULLABLE | STRING |
| loyalty_enable | NULLABLE | STRING |
| blog_items_per_page | NULLABLE | STRING |
| blog_comments_enable | NULLABLE | STRING |
| blog_comments_for_users | NULLABLE | STRING |
| blog_comments_moderation | NULLABLE | STRING |
| blog_download_enable | NULLABLE | STRING |
| blog_download_for_users | NULLABLE | STRING |
| blog_news_default_url_format | NULLABLE | STRING |
| blog_category_default_url_format | NULLABLE | STRING |
| blog_use_new_url_namespace | NULLABLE | STRING |
| locale_timezone | NULLABLE | STRING |
| locale_default_weight | NULLABLE | STRING |
| default_language_name | NULLABLE | STRING |
| default_language_id | NULLABLE | STRING |
| default_currency_id | NULLABLE | STRING |
| default_currency_name | NULLABLE | STRING |
| warehouses_enabled | NULLABLE | BOOLEAN |
Data schema for shoper_categories
| Field Name | Mode | Type |
|---|---|---|
| category_id | NULLABLE | STRING |
| root | NULLABLE | BOOLEAN |
| order | NULLABLE | INTEGER |
| translations | REPEATED | RECORD |
| ├─ translations.language | NULLABLE | STRING |
| ├─ translations.trans_id | NULLABLE | STRING |
| ├─ translations.category_id | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.description | NULLABLE | STRING |
| ├─ translations.description_bottom | NULLABLE | STRING |
| ├─ translations.seo_title | NULLABLE | STRING |
| ├─ translations.seo_description | NULLABLE | STRING |
| ├─ translations.seo_keywords | NULLABLE | STRING |
| ├─ translations.seo_url | NULLABLE | STRING |
| ├─ translations.permalink | NULLABLE | STRING |
| ├─ translations.active | NULLABLE | BOOLEAN |
| ├─ translations.isdefault | NULLABLE | BOOLEAN |
| ├─ translations.items | NULLABLE | INTEGER |
Data schema for shoper_categories_tree
| Field Name | Mode | Type |
|---|---|---|
| parent_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| category_path | REPEATED | STRING |
Data schema for shoper_currencies
| Field Name | Mode | Type |
|---|---|---|
| currency_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| rate_sync | NULLABLE | STRING |
| rate_date | NULLABLE | DATE |
| default | NULLABLE | BOOLEAN |
Data schema for shoper_option_values
| Field Name | Mode | Type |
|---|---|---|
| ovalue_id | NULLABLE | STRING |
| option_id | NULLABLE | STRING |
| order | NULLABLE | STRING |
| total_products | NULLABLE | INTEGER |
| change_price_type | NULLABLE | STRING |
| change_price_value | NULLABLE | FLOAT |
| percent | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| ├─ translations.translation_id | NULLABLE | STRING |
| ├─ translations.ovalue_id | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| ├─ translations.value | NULLABLE | STRING |
Data schema for shoper_order_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| order_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| type | NULLABLE | STRING |
| stock_id | NULLABLE | STRING |
| price | NULLABLE | FLOAT |
| discount_perc | NULLABLE | FLOAT |
| quantity | NULLABLE | INTEGER |
| delivery_time | NULLABLE | INTEGER |
| delivery_time_hours | NULLABLE | FLOAT |
| name | NULLABLE | STRING |
| code | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| tax | NULLABLE | STRING |
| tax_value | NULLABLE | FLOAT |
| unit | NULLABLE | STRING |
| option | NULLABLE | STRING |
| unit_fp | NULLABLE | BOOLEAN |
| weight | NULLABLE | FLOAT |
| loyalty | NULLABLE | RECORD |
| ├─ loyalty.exchanged | NULLABLE | BOOLEAN |
| ├─ loyalty.score | NULLABLE | INTEGER |
| ├─ loyalty.ratio | NULLABLE | STRING |
| children | REPEATED | RECORD |
| ├─ children.id | NULLABLE | STRING |
| ├─ children.order_id | NULLABLE | STRING |
| ├─ children.stock_id | NULLABLE | STRING |
| ├─ children.price | NULLABLE | FLOAT |
| ├─ children.discount_perc | NULLABLE | FLOAT |
| ├─ children.quantity | NULLABLE | INTEGER |
| ├─ children.delivery_time | NULLABLE | INTEGER |
| ├─ children.name | NULLABLE | STRING |
| ├─ children.code | NULLABLE | STRING |
| ├─ children.pkwiu | NULLABLE | STRING |
| ├─ children.tax | NULLABLE | STRING |
| ├─ children.tax_value | NULLABLE | FLOAT |
| ├─ children.unit | NULLABLE | STRING |
| ├─ children.option | NULLABLE | STRING |
| ├─ children.unit_fp | NULLABLE | BOOLEAN |
| ├─ children.weight | NULLABLE | FLOAT |
Data schema for shoper_orders
| Field Name | Mode | Type |
|---|---|---|
| order_id | NULLABLE | STRING |
| user_id | NULLABLE | STRING |
| date | NULLABLE | TIMESTAMP |
| status_date | NULLABLE | TIMESTAMP |
| confirm_date | NULLABLE | TIMESTAMP |
| delivery_date | NULLABLE | TIMESTAMP |
| status_id | NULLABLE | STRING |
| sum | NULLABLE | FLOAT |
| payment_id | NULLABLE | STRING |
| user_order | NULLABLE | BOOLEAN |
| shipping_id | NULLABLE | STRING |
| shipping_cost | NULLABLE | FLOAT |
| NULLABLE | STRING | |
| code | NULLABLE | STRING |
| confirm | NULLABLE | BOOLEAN |
| notes | NULLABLE | STRING |
| notes_priv | NULLABLE | STRING |
| notes_pub | NULLABLE | STRING |
| currency_id | NULLABLE | STRING |
| currency_rate | NULLABLE | FLOAT |
| paid | NULLABLE | FLOAT |
| discount_client | NULLABLE | FLOAT |
| discount_group | NULLABLE | FLOAT |
| discount_levels | NULLABLE | FLOAT |
| discount_code | NULLABLE | FLOAT |
| code_id | NULLABLE | STRING |
| lang_id | NULLABLE | STRING |
| origin | NULLABLE | STRING |
| registered | NULLABLE | BOOLEAN |
| promo_code | NULLABLE | STRING |
| is_paid | NULLABLE | BOOLEAN |
| is_overpayment | NULLABLE | BOOLEAN |
| is_underpayment | NULLABLE | BOOLEAN |
| total_parcels | NULLABLE | INTEGER |
| total_products | NULLABLE | INTEGER |
| loyalty_cost | NULLABLE | INTEGER |
| loyalty_score | NULLABLE | INTEGER |
| shipping_tax_name | NULLABLE | STRING |
| shipping_tax_value | NULLABLE | FLOAT |
| shipping_tax_id | NULLABLE | STRING |
| delivery_address | NULLABLE | RECORD |
| ├─ delivery_address.address_id | NULLABLE | STRING |
| ├─ delivery_address.order_id | NULLABLE | STRING |
| ├─ delivery_address.type | NULLABLE | STRING |
| ├─ delivery_address.city | NULLABLE | STRING |
| ├─ delivery_address.postcode | NULLABLE | STRING |
| ├─ delivery_address.state | NULLABLE | STRING |
| ├─ delivery_address.country | NULLABLE | STRING |
| ├─ delivery_address.phone | NULLABLE | STRING |
| ├─ delivery_address.country_code | NULLABLE | STRING |
| ├─ delivery_address.tax_identification_number | NULLABLE | STRING |
| billing_address | NULLABLE | RECORD |
| ├─ billing_address.address_id | NULLABLE | STRING |
| ├─ billing_address.order_id | NULLABLE | STRING |
| ├─ billing_address.type | NULLABLE | STRING |
| ├─ billing_address.city | NULLABLE | STRING |
| ├─ billing_address.postcode | NULLABLE | STRING |
| ├─ billing_address.state | NULLABLE | STRING |
| ├─ billing_address.country | NULLABLE | STRING |
| ├─ billing_address.phone | NULLABLE | STRING |
| ├─ billing_address.country_code | NULLABLE | STRING |
| ├─ billing_address.tax_identification_number | NULLABLE | STRING |
Data schema for shoper_payments
| Field Name | Mode | Type |
|---|---|---|
| payment_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order | NULLABLE | STRING |
| install | NULLABLE | BOOLEAN |
| visible | NULLABLE | BOOLEAN |
| currencies | REPEATED | STRING |
| translations | REPEATED | RECORD |
| ├─ translations.language | NULLABLE | STRING |
| ├─ translations.translation_id | NULLABLE | STRING |
| ├─ translations.payment_id | NULLABLE | STRING |
| ├─ translations.title | NULLABLE | STRING |
| ├─ translations.description | NULLABLE | STRING |
| ├─ translations.vendor_description | NULLABLE | STRING |
| ├─ translations.active | NULLABLE | STRING |
| ├─ translations.notify | NULLABLE | STRING |
| ├─ translations.notify_mail | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
Data schema for shoper_producers
| Field Name | Mode | Type |
|---|---|---|
| producer_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| web | NULLABLE | STRING |
| gfx | NULLABLE | STRING |
| isdefault | NULLABLE | BOOLEAN |
| translations | REPEATED | RECORD |
| ├─ translations.language | NULLABLE | STRING |
| ├─ translations.translation_id | NULLABLE | STRING |
| ├─ translations.producer_id | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.description | NULLABLE | STRING |
| ├─ translations.seo_title | NULLABLE | STRING |
| ├─ translations.seo_description | NULLABLE | STRING |
| ├─ translations.seo_keywords | NULLABLE | STRING |
| ├─ translations.seo_url | NULLABLE | STRING |
Data schema for shoper_product_images
| Field Name | Mode | Type |
|---|---|---|
| gfx_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| main | NULLABLE | BOOLEAN |
| order | NULLABLE | STRING |
| unic_name | NULLABLE | STRING |
| hidden | NULLABLE | BOOLEAN |
| extension | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| ├─ translations.gfx_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
Data schema for shoper_products
| Field Name | Mode | Type |
|---|---|---|
| product_id | NULLABLE | STRING |
| type | NULLABLE | STRING |
| producer_id | NULLABLE | STRING |
| group_id | NULLABLE | STRING |
| tax_id | NULLABLE | STRING |
| category_id | NULLABLE | STRING |
| unit_id | NULLABLE | STRING |
| add_date | NULLABLE | TIMESTAMP |
| edit_date | NULLABLE | TIMESTAMP |
| other_price | NULLABLE | FLOAT |
| promo_price | NULLABLE | FLOAT |
| code | NULLABLE | STRING |
| dimension_w | NULLABLE | FLOAT |
| dimension_h | NULLABLE | FLOAT |
| dimension_l | NULLABLE | FLOAT |
| ean | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| is_product_of_day | NULLABLE | BOOLEAN |
| loyalty_score | NULLABLE | INTEGER |
| loyalty_price | NULLABLE | INTEGER |
| in_loyalty | NULLABLE | BOOLEAN |
| bestseller | NULLABLE | BOOLEAN |
| newproduct | NULLABLE | BOOLEAN |
| vol_weight | NULLABLE | FLOAT |
| gauge_id | NULLABLE | STRING |
| currency_id | NULLABLE | STRING |
| additional_isbn | NULLABLE | STRING |
| additional_kgo | NULLABLE | STRING |
| additional_bloz7 | NULLABLE | STRING |
| additional_bloz12 | NULLABLE | STRING |
| additional_gtu | NULLABLE | STRING |
| additional_producer | NULLABLE | STRING |
| related | REPEATED | STRING |
| options | REPEATED | STRING |
| categories | REPEATED | STRING |
| unit_price_calculation | NULLABLE | BOOLEAN |
| main_image | NULLABLE | RECORD |
| ├─ main_image.gfx_id | NULLABLE | STRING |
| ├─ main_image.order | NULLABLE | INTEGER |
| ├─ main_image.name | NULLABLE | STRING |
| ├─ main_image.unic_name | NULLABLE | STRING |
| ├─ main_image.hidden | NULLABLE | BOOLEAN |
| stock | NULLABLE | RECORD |
| ├─ stock.stock_id | NULLABLE | STRING |
| ├─ stock.product_id | NULLABLE | STRING |
| ├─ stock.extended | NULLABLE | BOOLEAN |
| ├─ stock.price | NULLABLE | FLOAT |
| ├─ stock.active | NULLABLE | BOOLEAN |
| ├─ stock.default | NULLABLE | BOOLEAN |
| ├─ stock.stock | NULLABLE | FLOAT |
| ├─ stock.warn_level | NULLABLE | FLOAT |
| ├─ stock.sold | NULLABLE | FLOAT |
| ├─ stock.code | NULLABLE | STRING |
| ├─ stock.ean | NULLABLE | STRING |
| ├─ stock.weight | NULLABLE | FLOAT |
| ├─ stock.weight_type | NULLABLE | STRING |
| ├─ stock.availability_id | NULLABLE | STRING |
| ├─ stock.delivery_id | NULLABLE | STRING |
| ├─ stock.gfx_id | NULLABLE | STRING |
| ├─ stock.package | NULLABLE | FLOAT |
| ├─ stock.price_wholesale | NULLABLE | FLOAT |
| ├─ stock.price_special | NULLABLE | FLOAT |
| ├─ stock.calculation_unit_id | NULLABLE | STRING |
| ├─ stock.calculation_unit_ratio | NULLABLE | FLOAT |
| special_offer | NULLABLE | RECORD |
| ├─ special_offer.promo_id | NULLABLE | STRING |
| ├─ special_offer.date_from | NULLABLE | TIMESTAMP |
| ├─ special_offer.date_to | NULLABLE | TIMESTAMP |
| ├─ special_offer.discount | NULLABLE | FLOAT |
| ├─ special_offer.discount_wholesale | NULLABLE | FLOAT |
| ├─ special_offer.discount_special | NULLABLE | FLOAT |
| children | REPEATED | RECORD |
| ├─ children.id | NULLABLE | STRING |
| ├─ children.bundle_id | NULLABLE | STRING |
| ├─ children.stock_id | NULLABLE | STRING |
| ├─ children.product_id | NULLABLE | STRING |
| ├─ children.stock | NULLABLE | FLOAT |
| ├─ children.order | NULLABLE | INTEGER |
| translations | REPEATED | RECORD |
| ├─ translations.language | NULLABLE | STRING |
| ├─ translations.translation_id | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.description | NULLABLE | STRING |
| ├─ translations.short_description | NULLABLE | STRING |
| ├─ translations.active | NULLABLE | BOOLEAN |
| ├─ translations.seo_title | NULLABLE | STRING |
| ├─ translations.seo_description | NULLABLE | STRING |
| ├─ translations.seo_keywords | NULLABLE | STRING |
| ├─ translations.seo_url | NULLABLE | STRING |
| ├─ translations.permalink | NULLABLE | STRING |
Data schema for shoper_shippings
| Field Name | Mode | Type |
|---|---|---|
| shipping_id | NULLABLE | STRING |
| cost | NULLABLE | FLOAT |
| depend_on_w | NULLABLE | STRING |
| tax_id | NULLABLE | STRING |
| max_weight | NULLABLE | FLOAT |
| min_weight | NULLABLE | FLOAT |
| free_shipping | NULLABLE | FLOAT |
| order | NULLABLE | STRING |
| pkwiu | NULLABLE | STRING |
| max_cost | NULLABLE | FLOAT |
| visible | NULLABLE | BOOLEAN |
| mobile | NULLABLE | BOOLEAN |
| engine | NULLABLE | STRING |
| zone_id | NULLABLE | STRING |
| callback_url | NULLABLE | STRING |
| warehouse_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| url | NULLABLE | STRING |
| description | NULLABLE | STRING |
| vendor_description | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| is_default | NULLABLE | BOOLEAN |
| lang_id | NULLABLE | STRING |
| countries | REPEATED | STRING |
| ranges | REPEATED | RECORD |
| ├─ ranges.range_id | NULLABLE | STRING |
| ├─ ranges.from | NULLABLE | STRING |
| ├─ ranges.to | NULLABLE | STRING |
| ├─ ranges.price | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| ├─ translations.language | NULLABLE | STRING |
| ├─ translations.translation_id | NULLABLE | STRING |
| ├─ translations.shipping_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.url | NULLABLE | STRING |
| ├─ translations.description | NULLABLE | STRING |
| ├─ translations.vendor_description | NULLABLE | STRING |
| ├─ translations.active | NULLABLE | STRING |
| ├─ translations.is_default | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| payments | REPEATED | RECORD |
| ├─ payments.cost | NULLABLE | FLOAT |
| ├─ payments.percent | NULLABLE | STRING |
| ├─ payments.payment_id | NULLABLE | STRING |
Data schema for shoper_statuses
| Field Name | Mode | Type |
|---|---|---|
| status_id | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| default | NULLABLE | BOOLEAN |
| color | NULLABLE | STRING |
| type | NULLABLE | STRING |
| order | NULLABLE | STRING |
| translations | REPEATED | RECORD |
| ├─ translations.trans_id | NULLABLE | STRING |
| ├─ translations.status_id | NULLABLE | STRING |
| ├─ translations.name | NULLABLE | STRING |
| ├─ translations.lang_id | NULLABLE | STRING |
| ├─ translations.message | NULLABLE | STRING |
| ├─ translations.message_html | NULLABLE | STRING |
Data schema for shoper_stock
| Field Name | Mode | Type |
|---|---|---|
| stock_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| extended | NULLABLE | BOOLEAN |
| price | NULLABLE | FLOAT |
| active | NULLABLE | BOOLEAN |
| default | NULLABLE | BOOLEAN |
| stock | NULLABLE | FLOAT |
| warn_level | NULLABLE | FLOAT |
| sold | NULLABLE | FLOAT |
| code | NULLABLE | STRING |
| ean | NULLABLE | STRING |
| weight | NULLABLE | FLOAT |
| weight_type | NULLABLE | STRING |
| availability_id | NULLABLE | STRING |
| delivery_id | NULLABLE | STRING |
| gfx_id | NULLABLE | STRING |
| package | NULLABLE | FLOAT |
| price_wholesale | NULLABLE | FLOAT |
| price_special | NULLABLE | FLOAT |
| price_type_special | NULLABLE | INTEGER |
| price_type_wholesale | NULLABLE | INTEGER |
| price_buying | NULLABLE | FLOAT |
| calculation_unit_id | NULLABLE | STRING |
| calculation_unit_ratio | NULLABLE | FLOAT |
| warehouses | REPEATED | RECORD |
| ├─ warehouses.id | NULLABLE | STRING |
| ├─ warehouses.stock | NULLABLE | FLOAT |
| options | REPEATED | RECORD |
| ├─ options.option_id | NULLABLE | STRING |
| ├─ options.value_id | NULLABLE | STRING |
Data schema for shoper_taxes
| Field Name | Mode | Type |
|---|---|---|
| tax_id | NULLABLE | STRING |
| value | NULLABLE | INTEGER |
| name | NULLABLE | STRING |
| class | NULLABLE | STRING |
