Ticimax Connector Reference

35 metrics137 dimensions

Fields

The Ticimax connector exposes 172 fields (35 metrics, 137 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Ticimax Fields

Ticimax Brands fields

The Brands report of the Ticimax connector includes 13 fields.

ID	Type	Name	Description
brand_breadcrumb	TEXT	Brand Breadcrumb	Breadcrumb of the brand.
brand_content	TEXT	Brand Content	Content of the brand.
brand_created_date	DATE	Brand Created Date	Created Date of the brand.
brand_description	TEXT	Brand Description	Description of the brand.
brand_id	TEXT	Brand ID	ID of the brand.
brand_image	TEXT	Brand Image	Image of the brand.
brand_is_active	BOOLEAN	Brand Is Active	Is Active of the brand.
brand_order	NUMERIC	Brand Order	Order of the brand.
brand_seo_keyword	TEXT	Brand SEO Keyword	SEO Keyword of the brand.
brand_seo_page_description	TEXT	Brand SEO Page Description	SEO Page Description of the brand.
brand_seo_page_title	TEXT	Brand SEO Page Title	SEO Page Title of the brand.
brand_updated_date	DATE	Brand Updated Date	Updated Date of the brand.
brand_url	TEXT	Brand URL	URL of the brand.

Ticimax Categories fields

The Categories report of the Ticimax connector includes 13 fields.

ID	Type	Name	Description
category_code	TEXT	Category Code	Code of the category.
category_content	TEXT	Category Content	Content of the category.
category_description	TEXT	Category Description	Description of the category.
category_id	TEXT	Category ID	ID of the category.
category_is_active	BOOLEAN	Category Is Active	Is Active of the category.
category_parent_id	TEXT	Category Parent ID	Parent ID of the category.
category_seo_keyword	TEXT	Category SEO Keyword	SEO Keyword of the category.
category_seo_page_description	TEXT	Category SEO Page Description	SEO Page Description of the category.
category_seo_page_title	TEXT	Category SEO Page Title	SEO Page Title of the category.
category_show_in_category_menu	BOOLEAN	Category Show In Category Menu	Show In Category Menu of the category.
category_sort_order	NUMERIC	Category Sort Order	Sort Order of the category.
category_sub_category_count	NUMERIC	Category Sub Category Count	Sub Category Count of the category.
category_url	TEXT	Category URL	URL of the category.

Ticimax Currencies fields

The Currencies report of the Ticimax connector includes 6 fields.

ID	Type	Name	Description
currency_code	TEXT	Currency Code	Code of the currency.
currency_description	TEXT	Currency Description	Description of the currency.
currency_id	TEXT	Currency ID	ID of the currency.
currency_is_active	BOOLEAN	Currency Is Active	Is Active of the currency.
currency_rate	NUMERIC	Currency Rate	Rate of the currency.
currency_update_date	DATE	Currency Update Date	Update Date of the currency.

Ticimax ProductCategories fields

The ProductCategories report of the Ticimax connector includes 3 fields.

ID	Type	Name	Description
product_category_category_id	TEXT	Product Category Category ID	Category ID of the product category.
product_category_product_card_id	TEXT	Product Category Product Card ID	Product Card ID of the product category.
product_category_sort_order	NUMERIC	Product Category Sort Order	Sort Order of the product category.

Ticimax Products fields

The Products report of the Ticimax connector includes 71 fields.

Ticimax Products fields (product_added_date to product_main_category_id)

ID	Type	Name	Description
product_added_date	DATE	Product Added Date	Added Date of the product.
product_adwords_category	TEXT	Product Adwords Category	Adwords Category of the product.
product_adwords_description	TEXT	Product Adwords Description	Adwords Description of the product.
product_adwords_type	TEXT	Product Adwords Type	Adwords Type of the product.
product_assortment_group_id	TEXT	Product Assortment Group ID	Assortment Group ID of the product.
product_brand	TEXT	Product Brand	Brand of the product.
product_brand_id	TEXT	Product Brand ID	Brand ID of the product.
product_cargo_type	TEXT	Product Cargo Type	Cargo Type of the product.
product_cart_free_cargo	BOOLEAN	Product Cart Free Cargo	Cart Free Cargo of the product.
product_color_code	TEXT	Product Color Code	Color Code of the product.
product_custom_field1	TEXT	Product Custom Field 1	Custom Field 1 of the product.
product_custom_field2	TEXT	Product Custom Field 2	Custom Field 2 of the product.
product_custom_field3	TEXT	Product Custom Field 3	Custom Field 3 of the product.
product_custom_field4	TEXT	Product Custom Field 4	Custom Field 4 of the product.
product_custom_field5	TEXT	Product Custom Field 5	Custom Field 5 of the product.
product_description	TEXT	Product Description	Description of the product.
product_discounted_price_feature	NUMERIC	Product Discounted Price Feature	Discounted Price Feature of the product.
product_discounted_price_feature_stock1	NUMERIC	Product Discounted Price Feature Stock 1	Discounted Price Feature Stock 1 of the product.
product_discounted_price_feature_stock2	NUMERIC	Product Discounted Price Feature Stock 2	Discounted Price Feature Stock 2 of the product.
product_free_cargo	BOOLEAN	Product Free Cargo	Free Cargo of the product.
product_id	TEXT	Product ID	ID of the product.
product_integration_id	TEXT	Product Integration ID	Integration ID of the product.
product_is_active	BOOLEAN	Product Is Active	Is Active of the product.
product_is_cash_on_delivery_prohibited	BOOLEAN	Product Is Cash On Delivery Prohibited	Is Cash On Delivery Prohibited of the product.
product_is_fb_store_visible	BOOLEAN	Product Is Facebook Store Visible	Is Facebook Store Visible of the product.
product_is_foreign_visibility_closed	BOOLEAN	Product Is Foreign Visibility Closed	Is Foreign Visibility Closed of the product.
product_is_gift_tip	BOOLEAN	Product Is Gift Tip	Is Gift Tip of the product.
product_is_market_place_active	BOOLEAN	Product Is Marketplace Active	Is Marketplace Active of the product.
product_is_market_place_active2	BOOLEAN	Product Is Marketplace Active 2	Is Marketplace Active 2 of the product.
product_is_market_place_active3	BOOLEAN	Product Is Marketplace Active 3	Is Marketplace Active 3 of the product.
product_is_market_place_active4	BOOLEAN	Product Is Marketplace Active 4	Is Marketplace Active 4 of the product.
product_is_market_place_active5	BOOLEAN	Product Is Marketplace Active 5	Is Marketplace Active 5 of the product.
product_is_new_product	BOOLEAN	Product Is New Product	Is New Product of the product.
product_is_opportunity	BOOLEAN	Product Is Opportunity	Is Opportunity of the product.
product_is_points_usage_cancellation_active	BOOLEAN	Product Is Points Usage Cancellation Active	Is Points Usage Cancellation Active of the product.
product_is_showcase	BOOLEAN	Product Is Showcase	Is Showcase of the product.
product_is_showcase_order_fixed	BOOLEAN	Product Is Showcase Order Fixed	Is Showcase Order Fixed of the product.
product_is_suit_product	BOOLEAN	Product Is Suit Product	Is Suit Product of the product.
product_main_category	TEXT	Product Main Category	Main Category of the product.
product_main_category_id	TEXT	Product Main Category ID	Main Category ID of the product.

Ticimax Products fields (product_max_installment_count to product_type)

ID	Type	Name	Description
product_max_installment_count	NUMERIC	Product Max Installment Count	Max Installment Count of the product.
product_member_purchase_max	NUMERIC	Product Member Purchase Max	Member Purchase Max of the product.
product_member_purchase_min	NUMERIC	Product Member Purchase Min	Member Purchase Min of the product.
product_mobile_custom_field	TEXT	Product Mobile Custom Field	Mobile Custom Field of the product.
product_name	TEXT	Product Name	Name of the product.
product_order	NUMERIC	Product Order	Order of the product.
product_page_address	TEXT	Product Page Address	Page Address of the product.
product_pre_text	TEXT	Product Pre Text	Pre Text of the product.
product_publish_date	DATE	Product Publish Date	Publish Date of the product.
product_quantity_default_value	NUMERIC	Product Quantity Default Value	Quantity Default Value of the product.
product_quantity_minimum_value	NUMERIC	Product Quantity Minimum Value	Quantity Minimum Value of the product.
product_quantity_step_value	NUMERIC	Product Quantity Step Value	Quantity Step Value of the product.
product_rating_value	NUMERIC	Product Rating Value	Rating Value of the product.
product_related_product_image	TEXT	Product Related Product Image	Related Product Image of the product.
product_sale_unit	TEXT	Product Sale Unit	Sale Unit of the product.
product_search_keyword	TEXT	Product Search Keyword	Search Keyword of the product.
product_seo_no_follow	BOOLEAN	Product SEO No Follow	SEO No Follow of the product.
product_seo_no_index	BOOLEAN	Product SEO No Index	SEO No Index of the product.
product_seo_page_description	TEXT	Product SEO Page Description	SEO Page Description of the product.
product_seo_page_title	TEXT	Product SEO Page Title	SEO Page Title of the product.
product_seo_search_keyword	TEXT	Product SEO Search Keyword	SEO Search Keyword of the product.
product_show_in_list	BOOLEAN	Product Show In List	Show In List of the product.
product_suit_campaign_id	TEXT	Product Suit Campaign ID	Suit Campaign ID of the product.
product_supplier_code	TEXT	Product Supplier Code	Supplier Code of the product.
product_supplier_code2	TEXT	Product Supplier Code 2	Supplier Code 2 of the product.
product_supplier_commission_rate	NUMERIC	Product Supplier Commission Rate	Supplier Commission Rate of the product.
product_supplier_id	TEXT	Product Supplier ID	Supplier ID of the product.
product_tax_exemption_code	TEXT	Product Tax Exemption Code	Tax Exemption Code of the product.
product_technical_detail_group_id	TEXT	Product Technical Detail Group ID	Technical Detail Group ID of the product.
product_total_stock_quantity	NUMERIC	Product Total Stock Quantity	Total Stock Quantity of the product.
product_type	TEXT	Product Type	Type of the product.

Ticimax Suppliers fields

The Suppliers report of the Ticimax connector includes 5 fields.

ID	Type	Name	Description
supplier_description	TEXT	Supplier Description	Description of the supplier.
supplier_id	TEXT	Supplier ID	ID of the supplier.
supplier_is_active	BOOLEAN	Supplier Is Active	Is Active of the supplier.
supplier_mail	TEXT	Supplier Mail	Mail of the supplier.
supplier_note	TEXT	Supplier Note	Note of the supplier.

Ticimax Variants fields

The Variants report of the Ticimax connector includes 40 fields.

ID	Type	Name	Description
variant_barcode	TEXT	Variant Barcode	Barcode of the variant.
variant_brand_id	TEXT	Variant Brand ID	Brand ID of the variant.
variant_consignment_stock_quantity	NUMERIC	Variant Consignment Stock Quantity	Consignment Stock Quantity of the variant.
variant_currency_code	TEXT	Variant Currency Code	Currency Code of the variant.
variant_currency_description	TEXT	Variant Currency Description	Currency Description of the variant.
variant_currency_id	TEXT	Variant Currency ID	Currency ID of the variant.
variant_desi	NUMERIC	Variant Desi	Desi of the variant.
variant_desi2	NUMERIC	Variant Desi 2	Desi 2 of the variant.
variant_discounted_price	NUMERIC	Variant Discounted Price	Discounted Price of the variant.
variant_gtip_code	TEXT	Variant GTIP Code	GTIP Code of the variant.
variant_id	TEXT	Variant ID	ID of the variant.
variant_is_active	BOOLEAN	Variant Is Active	Is Active of the variant.
variant_is_market_place_active	BOOLEAN	Variant Is Marketplace Active	Is Marketplace Active of the variant.
variant_is_market_place_active2	BOOLEAN	Variant Is Marketplace Active 2	Is Marketplace Active 2 of the variant.
variant_is_market_place_active3	BOOLEAN	Variant Is Marketplace Active 3	Is Marketplace Active 3 of the variant.
variant_is_market_place_active4	BOOLEAN	Variant Is Marketplace Active 4	Is Marketplace Active 4 of the variant.
variant_is_market_place_active5	BOOLEAN	Variant Is Marketplace Active 5	Is Marketplace Active 5 of the variant.
variant_is_product_card_active	BOOLEAN	Variant Is Product Card Active	Is Product Card Active of the variant.
variant_manufacturing_currency_code	TEXT	Variant Manufacturing Currency Code	Manufacturing Currency Code of the variant.
variant_manufacturing_currency_description	TEXT	Variant Manufacturing Currency Description	Manufacturing Currency Description of the variant.
variant_manufacturing_currency_id	TEXT	Variant Manufacturing Currency ID	Manufacturing Currency ID of the variant.
variant_manufacturing_weight	NUMERIC	Variant Manufacturing Weight	Manufacturing Weight of the variant.
variant_market_price	NUMERIC	Variant Market Price	Market Price of the variant.
variant_negative_stock_quantity	NUMERIC	Variant Negative Stock Quantity	Negative Stock Quantity of the variant.
variant_product_card_id	TEXT	Variant Product Card ID	Product Card ID of the variant.
variant_product_depth	NUMERIC	Variant Product Depth	Product Depth of the variant.
variant_product_height	NUMERIC	Variant Product Height	Product Height of the variant.
variant_product_weight	NUMERIC	Variant Product Weight	Product Weight of the variant.
variant_product_width	NUMERIC	Variant Product Width	Product Width of the variant.
variant_purchase_price	NUMERIC	Variant Purchase Price	Purchase Price of the variant.
variant_sale_price	NUMERIC	Variant Sale Price	Sale Price of the variant.
variant_shipping_fee	NUMERIC	Variant Shipping Fee	Shipping Fee of the variant.
variant_stock_code	TEXT	Variant Stock Code	Stock Code of the variant.
variant_stock_quantity	NUMERIC	Variant Stock Quantity	Stock Quantity of the variant.
variant_stock_update_date	DATE	Variant Stock Update Date	Stock Update Date of the variant.
variant_supplier_code	TEXT	Variant Supplier Code	Supplier Code of the variant.
variant_supplier_code2	TEXT	Variant Supplier Code 2	Supplier Code 2 of the variant.
variant_supplier_commission_rate	NUMERIC	Variant Supplier Commission Rate	Supplier Commission Rate of the variant.
variant_vat_included	BOOLEAN	Variant VAT Included	VAT Included of the variant.
variant_vat_rate	NUMERIC	Variant VAT Rate	VAT Rate of the variant.

Ticimax other fields

The Ticimax connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Store domain the record belongs to.
account_name	TEXT	Account Name	Store domain the record belongs to.
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Record's date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors