Prestashop

Prerequisites

• Access Key
• Shop URL
• Start date

Tables in the Prestashop connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	order_states	16	id	Full Refresh
2	addresses	23	id	Full Refresh, Incremental	date_upd	API Reference
3	order_slip	15	id	Full Refresh, Incremental	date_upd
4	suppliers	10	id	Full Refresh, Incremental	date_upd	API Reference
5	configurations	7	id	Full Refresh, Incremental		API Reference
6	taxes	5	id	Full Refresh		API Reference
7	shop_urls	8	id	Full Refresh
8	customer_threads	13	id	Full Refresh, Incremental	date_upd
9	product_customization_fields	7	id	Full Refresh
10	order_invoices	19	id	Full Refresh, Incremental	date_add
11	order_histories	5	id	Full Refresh, Incremental	date_add
12	cart_rules	34	id	Full Refresh, Incremental	date_upd
13	stock_movement_reasons	6	id	Full Refresh, Incremental	date_upd
14	product_feature_values	4	id	Full Refresh
15	carriers	22	id	Full Refresh		API Reference
16	customer_messages	11	id	Full Refresh, Incremental	date_upd
17	countries	12	id	Full Refresh		API Reference
18	zones	3	id	Full Refresh		API Reference
19	deliveries	8	id	Full Refresh		API Reference
20	tags	3	id	Full Refresh		API Reference
21	combinations	21	id	Full Refresh		API Reference
22	image_types	9	id	Full Refresh
23	product_options	7	id	Full Refresh
24	shops	7	id	Full Refresh		API Reference
25	messages	8	id	Full Refresh, Incremental	date_add	API Reference
26	orders	47	id	Full Refresh, Incremental	date_upd	API Reference
27	tax_rules	9	id	Full Refresh
28	employees	26	id	Full Refresh		API Reference
29	order_carriers	9	id	Full Refresh, Incremental	date_add
30	stock_availables	9	id	Full Refresh
31	weight_ranges	4	id	Full Refresh
32	order_details	47	id	Full Refresh
33	specific_prices	18	id	Full Refresh
34	states	6	id	Full Refresh		API Reference
35	products	71	id	Full Refresh, Incremental	date_upd	API Reference
36	specific_price_rules	13	id	Full Refresh
37	shop_groups	7	id	Full Refresh
38	product_features	3	id	Full Refresh
39	order_payments	12	id	Full Refresh, Incremental	date_add
40	categories	17	id	Full Refresh, Incremental	date_upd	API Reference
41	customers	34	id	Full Refresh, Incremental	date_upd	API Reference
42	stock_movements	22	id	Full Refresh, Incremental	date_add
43	languages	9	id	Full Refresh		API Reference
44	translated_configurations	7	id	Full Refresh
45	manufacturers	12	id	Full Refresh, Incremental	date_upd	API Reference
46	stores	18	id	Full Refresh, Incremental	date_upd	API Reference
47	groups	7	id	Full Refresh, Incremental		API Reference
48	content_management_system	11	id	Full Refresh
49	product_suppliers	7	id	Full Refresh
50	price_ranges	4	id	Full Refresh
51	carts	20	id	Full Refresh, Incremental	date_upd	API Reference
52	product_option_values	5	id	Full Refresh
53	guests	16	id	Full Refresh		API Reference
54	tax_rule_groups	6	id	Full Refresh, Incremental	date_upd
55	contacts	5	id	Full Refresh		API Reference
56	currencies	13	id	Full Refresh		API Reference

Table: order_states

No	Column Name	Type	Notes
1	unremovable	VARCHAR
2	template	VARCHAR
3	delivery	VARCHAR
4	hidden	VARCHAR
5	color	VARCHAR
6	pdf_invoice	VARCHAR
7	send_email	VARCHAR
8	pdf_delivery	VARCHAR
9	shipped	VARCHAR
10	deleted	VARCHAR
11	paid	VARCHAR
12	name	VARCHAR
13	id	INTEGER	Primary Key
14	module_name	VARCHAR
15	invoice	VARCHAR
16	logable	VARCHAR

Table: addresses

No	Column Name	Type	Notes
1	firstname	VARCHAR
2	other	VARCHAR
3	phone_mobile	VARCHAR
4	address2	VARCHAR
5	city	VARCHAR
6	id_customer	VARCHAR
7	vat_number	VARCHAR
8	address1	VARCHAR
9	postcode	VARCHAR
10	id_manufacturer	VARCHAR
11	id_supplier	VARCHAR
12	lastname	VARCHAR
13	date_add	VARCHAR
14	id_country	VARCHAR
15	deleted	VARCHAR
16	phone	VARCHAR
17	date_upd	VARCHAR	Incremental sync key
18	alias	VARCHAR
19	company	VARCHAR
20	id	INTEGER	Primary Key
21	id_state	VARCHAR
22	id_warehouse	VARCHAR
23	dni	VARCHAR

Table: order_slip

No	Column Name	Type	Notes
1	amount	VARCHAR
2	total_products_tax_excl	VARCHAR
3	shipping_cost	VARCHAR
4	id_customer	VARCHAR
5	total_shipping_tax_excl	VARCHAR
6	date_add	VARCHAR
7	id_order	VARCHAR
8	shipping_cost_amount	VARCHAR
9	total_products_tax_incl	VARCHAR
10	total_shipping_tax_incl	VARCHAR
11	order_slip_type	VARCHAR
12	date_upd	VARCHAR	Incremental sync key
13	id	INTEGER	Primary Key
14	conversion_rate	VARCHAR
15	partial	VARCHAR

Table: suppliers

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	meta_description	VARCHAR
3	meta_title	VARCHAR
4	name	VARCHAR
5	date_upd	VARCHAR	Incremental sync key
6	active	VARCHAR
7	description	VARCHAR
8	id	INTEGER	Primary Key
9	meta_keywords	VARCHAR
10	link_rewrite	VARCHAR

Table: configurations

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	name	VARCHAR
3	date_upd	VARCHAR
4	id_shop	VARCHAR
5	id	INTEGER	Primary Key
6	value	VARCHAR
7	id_shop_group	VARCHAR

Table: taxes

No	Column Name	Type	Notes
1	deleted	VARCHAR
2	rate	VARCHAR
3	name	VARCHAR
4	active	VARCHAR
5	id	INTEGER	Primary Key

Table: shop_urls

No	Column Name	Type	Notes
1	domain_ssl	VARCHAR
2	virtual_uri	VARCHAR
3	domain	VARCHAR
4	id_shop	VARCHAR
5	active	VARCHAR
6	main	VARCHAR
7	physical_uri	VARCHAR
8	id	INTEGER	Primary Key

Table: customer_threads

No	Column Name	Type	Notes
1	associations	VARCHAR
2	id_customer	VARCHAR
3	token	VARCHAR
4	date_add	VARCHAR
5	id_lang	VARCHAR
6	id_order	VARCHAR
7	id_product	VARCHAR
8	date_upd	VARCHAR	Incremental sync key
9	id_shop	VARCHAR
10	id	INTEGER	Primary Key
11	id_contact	VARCHAR
12	email	VARCHAR
13	status	VARCHAR

Table: product_customization_fields

No	Column Name	Type	Notes
1	id_product	VARCHAR
2	is_deleted	VARCHAR
3	is_module	VARCHAR
4	name	VARCHAR
5	id	INTEGER	Primary Key
6	type	VARCHAR
7	required	VARCHAR

Table: order_invoices

No	Column Name	Type	Notes
1	note	VARCHAR
2	total_discount_tax_incl	VARCHAR
3	total_paid_tax_excl	VARCHAR
4	total_wrapping_tax_incl	VARCHAR
5	total_shipping_tax_excl	VARCHAR
6	shipping_tax_computation_method	VARCHAR
7	shop_address	VARCHAR
8	date_add	VARCHAR	Incremental sync key
9	number	VARCHAR
10	id_order	VARCHAR
11	delivery_date	VARCHAR
12	total_wrapping_tax_excl	VARCHAR
13	total_discount_tax_excl	VARCHAR
14	total_paid_tax_incl	VARCHAR
15	total_shipping_tax_incl	VARCHAR
16	total_products_wt	VARCHAR
17	delivery_number	VARCHAR
18	id	INTEGER	Primary Key
19	total_products	VARCHAR

Table: order_histories

No	Column Name	Type	Notes
1	date_add	VARCHAR	Incremental sync key
2	id_order	VARCHAR
3	id_employee	VARCHAR
4	id	INTEGER	Primary Key
5	id_order_state	VARCHAR

Table: cart_rules

No	Column Name	Type	Notes
1	quantity_per_user	VARCHAR
2	code	VARCHAR
3	shop_restriction	VARCHAR
4	free_shipping	VARCHAR
5	id_customer	VARCHAR
6	reduction_exclude_special	VARCHAR
7	description	VARCHAR
8	gift_product	VARCHAR
9	minimum_amount_tax	VARCHAR
10	minimum_amount	VARCHAR
11	group_restriction	VARCHAR
12	country_restriction	VARCHAR
13	highlight	VARCHAR
14	cart_rule_restriction	VARCHAR
15	product_restriction	VARCHAR
16	gift_product_attribute	VARCHAR
17	id	INTEGER	Primary Key
18	quantity	VARCHAR
19	minimum_amount_currency	VARCHAR
20	active	VARCHAR
21	reduction_percent	VARCHAR
22	date_to	VARCHAR
23	priority	VARCHAR
24	date_add	VARCHAR
25	reduction_amount	VARCHAR
26	reduction_tax	VARCHAR
27	date_upd	VARCHAR	Incremental sync key
28	name	VARCHAR
29	minimum_amount_shipping	VARCHAR
30	carrier_restriction	VARCHAR
31	reduction_currency	VARCHAR
32	reduction_product	VARCHAR
33	partial_use	VARCHAR
34	date_from	VARCHAR

Table: stock_movement_reasons

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	deleted	VARCHAR
3	sign	VARCHAR
4	date_upd	VARCHAR	Incremental sync key
5	name	VARCHAR
6	id	INTEGER	Primary Key

Table: product_feature_values

No	Column Name	Type	Notes
1	custom	VARCHAR
2	id	INTEGER	Primary Key
3	value	VARCHAR
4	id_feature	VARCHAR

Table: carriers

No	Column Name	Type	Notes
1	max_depth	VARCHAR
2	id_reference	VARCHAR
3	active	VARCHAR
4	max_height	VARCHAR
5	shipping_handling	VARCHAR
6	shipping_external	VARCHAR
7	url	VARCHAR
8	max_width	VARCHAR
9	need_range	VARCHAR
10	max_weight	VARCHAR
11	deleted	VARCHAR
12	delay	VARCHAR
13	is_module	VARCHAR
14	shipping_method	VARCHAR
15	is_free	VARCHAR
16	grade	VARCHAR
17	name	VARCHAR
18	id_tax_rules_group	VARCHAR
19	id	INTEGER	Primary Key
20	range_behavior	VARCHAR
21	position	VARCHAR
22	external_module_name	VARCHAR

Table: customer_messages

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	private	VARCHAR
3	read	VARCHAR
4	file_name	VARCHAR
5	id_employee	VARCHAR
6	date_upd	VARCHAR	Incremental sync key
7	id	INTEGER	Primary Key
8	ip_address	VARCHAR
9	message	VARCHAR
10	id_customer_thread	VARCHAR
11	user_agent	VARCHAR

Table: countries

No	Column Name	Type	Notes
1	display_tax_label	VARCHAR
2	call_prefix	VARCHAR
3	id_zone	VARCHAR
4	contains_states	VARCHAR
5	name	VARCHAR
6	active	VARCHAR
7	zip_code_format	VARCHAR
8	id	INTEGER	Primary Key
9	id_currency	VARCHAR
10	iso_code	VARCHAR
11	need_zip_code	VARCHAR
12	need_identification_number	VARCHAR

Table: zones

No	Column Name	Type	Notes
1	name	VARCHAR
2	active	VARCHAR
3	id	INTEGER	Primary Key

Table: deliveries

No	Column Name	Type	Notes
1	id_carrier	VARCHAR
2	id_range_price	VARCHAR
3	id_zone	VARCHAR
4	price	VARCHAR
5	id_shop	VARCHAR
6	id	INTEGER	Primary Key
7	id_range_weight	VARCHAR
8	id_shop_group	VARCHAR

Table: tags

No	Column Name	Type	Notes
1	id_lang	VARCHAR
2	name	VARCHAR
3	id	INTEGER	Primary Key

Table: combinations

No	Column Name	Type	Notes
1	associations	VARCHAR
2	quantity	VARCHAR
3	isbn	VARCHAR
4	available_date	VARCHAR
5	ean13	VARCHAR
6	upc	VARCHAR
7	weight	VARCHAR
8	mpn	VARCHAR
9	supplier_reference	VARCHAR
10	unit_price_impact	VARCHAR
11	default_on	VARCHAR
12	reference	VARCHAR
13	minimal_quantity	VARCHAR
14	low_stock_threshold	VARCHAR
15	id_product	VARCHAR
16	price	VARCHAR
17	wholesale_price	VARCHAR
18	location	VARCHAR
19	ecotax	VARCHAR
20	id	INTEGER	Primary Key
21	low_stock_alert	VARCHAR

Table: image_types

No	Column Name	Type	Notes
1	manufacturers	VARCHAR
2	suppliers	VARCHAR
3	stores	VARCHAR
4	name	VARCHAR
5	width	VARCHAR
6	id	INTEGER	Primary Key
7	categories	VARCHAR
8	height	VARCHAR
9	products	VARCHAR

Table: product_options

No	Column Name	Type	Notes
1	is_color_group	VARCHAR
2	associations	VARCHAR
3	name	VARCHAR
4	id	INTEGER	Primary Key
5	group_type	VARCHAR
6	position	VARCHAR
7	public_name	VARCHAR

Table: shops

No	Column Name	Type	Notes
1	deleted	VARCHAR
2	id_category	VARCHAR
3	name	VARCHAR
4	theme_name	VARCHAR
5	active	VARCHAR
6	id	INTEGER	Primary Key
7	id_shop_group	VARCHAR

Table: messages

No	Column Name	Type	Notes
1	date_add	VARCHAR	Incremental sync key
2	id_order	VARCHAR
3	private	VARCHAR
4	id_customer	VARCHAR
5	id_employee	VARCHAR
6	id_cart	VARCHAR
7	id	INTEGER	Primary Key
8	message	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	id_address_invoice	VARCHAR
2	gift	VARCHAR
3	associations	VARCHAR
4	total_paid_tax_excl	VARCHAR
5	total_wrapping_tax_incl	VARCHAR
6	recyclable	VARCHAR
7	id_customer	VARCHAR
8	round_type	VARCHAR
9	invoice_date	VARCHAR
10	carrier_tax_rate	VARCHAR
11	valid	VARCHAR
12	total_discounts	VARCHAR
13	reference	VARCHAR
14	id_lang	VARCHAR
15	mobile_theme	VARCHAR
16	total_wrapping_tax_excl	VARCHAR
17	total_paid	VARCHAR
18	total_shipping_tax_incl	VARCHAR
19	secure_key	VARCHAR
20	total_products_wt	VARCHAR
21	total_shipping	VARCHAR
22	id_shop	VARCHAR
23	delivery_number	VARCHAR
24	payment	VARCHAR
25	id	INTEGER	Primary Key
26	id_currency	VARCHAR
27	invoice_number	VARCHAR
28	conversion_rate	VARCHAR
29	id_carrier	VARCHAR
30	total_discounts_tax_incl	VARCHAR
31	module	VARCHAR
32	current_state	VARCHAR
33	id_address_delivery	VARCHAR
34	total_shipping_tax_excl	VARCHAR
35	shipping_number	VARCHAR
36	date_add	VARCHAR
37	total_paid_real	VARCHAR
38	delivery_date	VARCHAR
39	total_paid_tax_incl	VARCHAR
40	id_cart	VARCHAR
41	date_upd	VARCHAR	Incremental sync key
42	total_wrapping	VARCHAR
43	total_products	VARCHAR
44	gift_message	VARCHAR
45	round_mode	VARCHAR
46	id_shop_group	VARCHAR
47	total_discounts_tax_excl	VARCHAR

Table: tax_rules

No	Column Name	Type	Notes
1	id_country	VARCHAR
2	zipcode_to	VARCHAR
3	id_tax_rules_group	VARCHAR
4	description	VARCHAR
5	id	INTEGER	Primary Key
6	id_state	VARCHAR
7	behavior	VARCHAR
8	id_tax	VARCHAR
9	zipcode_from	VARCHAR

Table: employees

No	Column Name	Type	Notes
1	firstname	VARCHAR
2	stats_compare_from	VARCHAR
3	reset_password_validity	VARCHAR
4	last_passwd_gen	VARCHAR
5	reset_password_token	VARCHAR
6	stats_compare_option	VARCHAR
7	id_lang	VARCHAR
8	stats_date_to	VARCHAR
9	bo_css	VARCHAR
10	stats_compare_to	VARCHAR
11	id	INTEGER	Primary Key
12	id_last_order	VARCHAR
13	email	VARCHAR
14	bo_theme	VARCHAR
15	active	VARCHAR
16	bo_menu	VARCHAR
17	stats_date_from	VARCHAR
18	default_tab	VARCHAR
19	lastname	VARCHAR
20	preselect_date_range	VARCHAR
21	id_last_customer	VARCHAR
22	passwd	VARCHAR
23	bo_width	VARCHAR
24	bo_color	VARCHAR
25	id_last_customer_message	VARCHAR
26	id_profile	VARCHAR

Table: order_carriers

No	Column Name	Type	Notes
1	date_add	VARCHAR	Incremental sync key
2	id_carrier	VARCHAR
3	id_order	VARCHAR
4	shipping_cost_tax_excl	VARCHAR
5	shipping_cost_tax_incl	VARCHAR
6	id_order_invoice	VARCHAR
7	weight	VARCHAR
8	tracking_number	VARCHAR
9	id	INTEGER	Primary Key

Table: stock_availables

No	Column Name	Type	Notes
1	out_of_stock	VARCHAR
2	id_product	VARCHAR
3	quantity	VARCHAR
4	id_product_attribute	VARCHAR
5	depends_on_stock	VARCHAR
6	id_shop	VARCHAR
7	location	VARCHAR
8	id	INTEGER	Primary Key
9	id_shop_group	VARCHAR

Table: weight_ranges

No	Column Name	Type	Notes
1	delimiter2	VARCHAR
2	id_carrier	VARCHAR
3	delimiter1	VARCHAR
4	id	INTEGER	Primary Key

Table: order_details

No	Column Name	Type	Notes
1	unit_price_tax_excl	VARCHAR
2	ecotax_tax_rate	VARCHAR
3	id_customization	VARCHAR
4	total_refunded_tax_incl	VARCHAR
5	product_quantity_in_stock	VARCHAR
6	product_upc	VARCHAR
7	download_nb	VARCHAR
8	download_hash	VARCHAR
9	product_weight	VARCHAR
10	product_mpn	VARCHAR
11	reduction_amount_tax_incl	VARCHAR
12	product_price	VARCHAR
13	total_shipping_price_tax_incl	VARCHAR
14	product_quantity	VARCHAR
15	id_order	VARCHAR
16	tax_computation_method	VARCHAR
17	total_price_tax_incl	VARCHAR
18	total_refunded_tax_excl	VARCHAR
19	product_id	VARCHAR
20	product_quantity_discount	VARCHAR
21	group_reduction	VARCHAR
22	id_shop	VARCHAR
23	id_tax_rules_group	VARCHAR
24	product_quantity_return	VARCHAR
25	id	INTEGER	Primary Key
26	download_deadline	VARCHAR
27	total_shipping_price_tax_excl	VARCHAR
28	discount_quantity_applied	VARCHAR
29	product_supplier_reference	VARCHAR
30	total_price_tax_excl	VARCHAR
31	product_reference	VARCHAR
32	id_order_invoice	VARCHAR
33	reduction_percent	VARCHAR
34	product_quantity_reinjected	VARCHAR
35	product_ean13	VARCHAR
36	product_name	VARCHAR
37	purchase_supplier_price	VARCHAR
38	unit_price_tax_incl	VARCHAR
39	reduction_amount	VARCHAR
40	product_isbn	VARCHAR
41	product_quantity_refunded	VARCHAR
42	product_attribute_id	VARCHAR
43	ecotax	VARCHAR
44	original_wholesale_price	VARCHAR
45	original_product_price	VARCHAR
46	id_warehouse	VARCHAR
47	reduction_amount_tax_excl	VARCHAR

Table: specific_prices

No	Column Name	Type	Notes
1	id_customer	VARCHAR
2	from_quantity	VARCHAR
3	id_product	VARCHAR
4	id_country	VARCHAR
5	id_product_attribute	VARCHAR
6	price	VARCHAR
7	reduction_tax	VARCHAR
8	id_cart	VARCHAR
9	reduction_type	VARCHAR
10	id_shop	VARCHAR
11	from	VARCHAR
12	id	INTEGER	Primary Key
13	id_currency	VARCHAR
14	to	VARCHAR
15	id_group	VARCHAR
16	id_specific_price_rule	VARCHAR
17	reduction	VARCHAR
18	id_shop_group	VARCHAR

Table: states

No	Column Name	Type	Notes
1	id_country	VARCHAR
2	id_zone	VARCHAR
3	name	VARCHAR
4	active	VARCHAR
5	id	INTEGER	Primary Key
6	iso_code	VARCHAR

Table: products

No	Column Name	Type	Notes
1	id_default_combination	INTEGER
2	id_default_image	VARCHAR
3	type	VARCHAR
4	reference	VARCHAR
5	low_stock_threshold	VARCHAR
6	advanced_stock_management	VARCHAR
7	price	VARCHAR
8	wholesale_price	VARCHAR
9	id	INTEGER	Primary Key
10	state	VARCHAR
11	redirect_type	VARCHAR
12	height	VARCHAR
13	delivery_out_stock	VARCHAR
14	new	VARCHAR
15	quantity_discount	VARCHAR
16	visibility	VARCHAR
17	meta_title	VARCHAR
18	indexed	VARCHAR
19	text_fields	VARCHAR
20	weight	VARCHAR
21	upc	VARCHAR
22	delivery_in_stock	VARCHAR
23	active	VARCHAR
24	mpn	VARCHAR
25	id_manufacturer	VARCHAR
26	pack_stock_type	VARCHAR
27	online_only	VARCHAR
28	meta_description	VARCHAR
29	condition	VARCHAR
30	additional_delivery_times	VARCHAR
31	name	VARCHAR
32	low_stock_alert	VARCHAR
33	cache_is_pack	VARCHAR
34	is_virtual	VARCHAR
35	associations	VARCHAR
36	additional_shipping_cost	VARCHAR
37	id_type_redirected	VARCHAR
38	show_condition	VARCHAR
39	isbn	VARCHAR
40	customizable	VARCHAR
41	ean13	VARCHAR
42	description	VARCHAR
43	available_now	VARCHAR
44	supplier_reference	VARCHAR
45	meta_keywords	VARCHAR
46	id_supplier	VARCHAR
47	minimal_quantity	VARCHAR
48	unity	VARCHAR
49	cache_default_attribute	VARCHAR
50	id_tax_rules_group	VARCHAR
51	unit_price_ratio	VARCHAR
52	id_category_default	VARCHAR
53	on_sale	VARCHAR
54	link_rewrite	VARCHAR
55	cache_has_attachments	VARCHAR
56	position_in_category	VARCHAR
57	quantity	VARCHAR
58	available_later	VARCHAR
59	uploadable_files	VARCHAR
60	available_date	VARCHAR
61	show_price	VARCHAR
62	manufacturer_name	VARCHAR
63	available_for_order	VARCHAR
64	date_add	VARCHAR
65	description_short	VARCHAR
66	depth	VARCHAR
67	width	VARCHAR
68	date_upd	VARCHAR	Incremental sync key
69	location	VARCHAR
70	ecotax	VARCHAR
71	id_shop_default	VARCHAR

Table: specific_price_rules

No	Column Name	Type	Notes
1	from_quantity	VARCHAR
2	id_country	VARCHAR
3	price	VARCHAR
4	reduction_tax	VARCHAR
5	name	VARCHAR
6	reduction_type	VARCHAR
7	id_shop	VARCHAR
8	from	VARCHAR
9	id	INTEGER	Primary Key
10	id_currency	VARCHAR
11	to	VARCHAR
12	id_group	VARCHAR
13	reduction	VARCHAR

Table: shop_groups

No	Column Name	Type	Notes
1	deleted	VARCHAR
2	share_stock	VARCHAR
3	share_order	VARCHAR
4	name	VARCHAR
5	active	VARCHAR
6	id	INTEGER	Primary Key
7	share_customer	VARCHAR

Table: product_features

No	Column Name	Type	Notes
1	name	VARCHAR
2	id	INTEGER	Primary Key
3	position	VARCHAR

Table: order_payments

No	Column Name	Type	Notes
1	transaction_id	VARCHAR
2	date_add	VARCHAR	Incremental sync key
3	card_holder	VARCHAR
4	amount	VARCHAR
5	card_number	VARCHAR
6	order_reference	VARCHAR
7	card_brand	VARCHAR
8	card_expiration	VARCHAR
9	id	INTEGER	Primary Key
10	id_currency	VARCHAR
11	conversion_rate	VARCHAR
12	payment_method	VARCHAR

Table: categories

No	Column Name	Type	Notes
1	associations	VARCHAR
2	meta_title	VARCHAR
3	active	VARCHAR
4	description	VARCHAR
5	id_parent	VARCHAR
6	is_root_category	VARCHAR
7	meta_keywords	VARCHAR
8	level_depth	VARCHAR
9	date_add	VARCHAR
10	meta_description	VARCHAR
11	nb_products_recursive	VARCHAR
12	date_upd	VARCHAR	Incremental sync key
13	name	VARCHAR
14	id	INTEGER	Primary Key
15	position	VARCHAR
16	id_shop_default	VARCHAR
17	link_rewrite	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	birthday	VARCHAR
2	associations	VARCHAR
3	newsletter	VARCHAR
4	note	VARCHAR
5	firstname	VARCHAR
6	max_payment_days	VARCHAR
7	is_guest	VARCHAR
8	outstanding_allow_amount	VARCHAR
9	optin	VARCHAR
10	reset_password_validity	VARCHAR
11	last_passwd_gen	VARCHAR
12	siret	VARCHAR
13	reset_password_token	VARCHAR
14	show_public_prices	VARCHAR
15	id_lang	VARCHAR
16	ape	VARCHAR
17	secure_key	VARCHAR
18	id_gender	VARCHAR
19	id_shop	VARCHAR
20	company	VARCHAR
21	id	INTEGER	Primary Key
22	email	VARCHAR
23	website	VARCHAR
24	active	VARCHAR
25	ip_registration_newsletter	VARCHAR
26	lastname	VARCHAR
27	id_risk	VARCHAR
28	date_add	VARCHAR
29	newsletter_date_add	VARCHAR
30	deleted	VARCHAR
31	passwd	VARCHAR
32	id_default_group	VARCHAR
33	date_upd	VARCHAR	Incremental sync key
34	id_shop_group	VARCHAR

Table: stock_movements

No	Column Name	Type	Notes
1	last_wa	VARCHAR
2	id_stock	VARCHAR
3	id_supply_order	VARCHAR
4	current_wa	VARCHAR
5	sign	VARCHAR
6	ean13	VARCHAR
7	upc	VARCHAR
8	mpn	VARCHAR
9	management_type	VARCHAR
10	product_name	BOOLEAN
11	reference	VARCHAR
12	date_add	VARCHAR	Incremental sync key
13	id_order	VARCHAR
14	id_product	VARCHAR
15	id_product_attribute	VARCHAR
16	id_employee	VARCHAR
17	id_stock_mvt_reason	VARCHAR
18	physical_quantity	VARCHAR
19	id	INTEGER	Primary Key
20	id_currency	VARCHAR
21	id_warehouse	VARCHAR
22	price_te	VARCHAR

Table: languages

No	Column Name	Type	Notes
1	language_code	VARCHAR
2	date_format_full	VARCHAR
3	name	VARCHAR
4	active	VARCHAR
5	id	INTEGER	Primary Key
6	is_rtl	VARCHAR
7	iso_code	VARCHAR
8	locale	VARCHAR
9	date_format_lite	VARCHAR

Table: translated_configurations

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	date_upd	VARCHAR
3	name	VARCHAR
4	id_shop	VARCHAR
5	id	INTEGER	Primary Key
6	value	VARCHAR
7	id_shop_group	VARCHAR

Table: manufacturers

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	associations	VARCHAR
3	short_description	VARCHAR
4	meta_description	VARCHAR
5	meta_title	VARCHAR
6	name	VARCHAR
7	date_upd	VARCHAR	Incremental sync key
8	active	VARCHAR
9	description	VARCHAR
10	id	INTEGER	Primary Key
11	meta_keywords	VARCHAR
12	link_rewrite	VARCHAR

Table: stores

No	Column Name	Type	Notes
1	note	VARCHAR
2	hours	VARCHAR
3	city	VARCHAR
4	address2	VARCHAR
5	address1	VARCHAR
6	latitude	VARCHAR
7	postcode	VARCHAR
8	active	VARCHAR
9	date_add	VARCHAR
10	id_country	VARCHAR
11	phone	VARCHAR
12	date_upd	VARCHAR	Incremental sync key
13	name	VARCHAR
14	id	INTEGER	Primary Key
15	id_state	VARCHAR
16	fax	VARCHAR
17	email	VARCHAR
18	longitude	VARCHAR

Table: groups

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	price_display_method	VARCHAR
3	date_upd	VARCHAR
4	name	VARCHAR
5	id	INTEGER	Primary Key
6	reduction	VARCHAR
7	show_prices	VARCHAR

Table: content_management_system

No	Column Name	Type	Notes
1	id_cms_category	VARCHAR
2	meta_description	VARCHAR
3	meta_title	VARCHAR
4	indexation	VARCHAR
5	active	VARCHAR
6	id	INTEGER	Primary Key
7	position	VARCHAR
8	meta_keywords	VARCHAR
9	head_seo_title	VARCHAR
10	link_rewrite	VARCHAR
11	content	VARCHAR

Table: product_suppliers

No	Column Name	Type	Notes
1	id_product	VARCHAR
2	product_supplier_reference	VARCHAR
3	id_product_attribute	VARCHAR
4	id	INTEGER	Primary Key
5	id_currency	VARCHAR
6	product_supplier_price_te	VARCHAR
7	id_supplier	VARCHAR

Table: price_ranges

No	Column Name	Type	Notes
1	delimiter2	VARCHAR
2	id_carrier	VARCHAR
3	delimiter1	VARCHAR
4	id	INTEGER	Primary Key

Table: carts

No	Column Name	Type	Notes
1	id_address_invoice	VARCHAR
2	gift	VARCHAR
3	associations	VARCHAR
4	id_carrier	VARCHAR
5	allow_seperated_package	VARCHAR
6	recyclable	VARCHAR
7	id_customer	VARCHAR
8	id_address_delivery	VARCHAR
9	date_add	VARCHAR
10	id_lang	VARCHAR
11	mobile_theme	VARCHAR
12	secure_key	VARCHAR
13	date_upd	VARCHAR	Incremental sync key
14	id_shop	VARCHAR
15	id	INTEGER	Primary Key
16	id_currency	VARCHAR
17	id_guest	VARCHAR
18	gift_message	VARCHAR
19	id_shop_group	VARCHAR
20	delivery_option	VARCHAR

Table: product_option_values

No	Column Name	Type	Notes
1	id_attribute_group	VARCHAR
2	color	VARCHAR
3	name	VARCHAR
4	id	INTEGER	Primary Key
5	position	VARCHAR

Table: guests

No	Column Name	Type	Notes
1	windows_media	VARCHAR
2	id_web_browser	VARCHAR
3	id_customer	VARCHAR
4	adobe_director	VARCHAR
5	screen_color	VARCHAR
6	id_operating_system	VARCHAR
7	javascript	VARCHAR
8	real_player	VARCHAR
9	screen_resolution_x	VARCHAR
10	screen_resolution_y	VARCHAR
11	mobile_theme	VARCHAR
12	sun_java	VARCHAR
13	apple_quicktime	VARCHAR
14	adobe_flash	VARCHAR
15	accept_language	VARCHAR
16	id	INTEGER	Primary Key

Table: tax_rule_groups

No	Column Name	Type	Notes
1	date_add	VARCHAR
2	deleted	VARCHAR
3	name	VARCHAR
4	date_upd	VARCHAR	Incremental sync key
5	active	VARCHAR
6	id	INTEGER	Primary Key

Table: contacts

No	Column Name	Type	Notes
1	name	VARCHAR
2	description	VARCHAR
3	customer_service	VARCHAR
4	id	INTEGER	Primary Key
5	email	VARCHAR

Table: currencies

No	Column Name	Type	Notes
1	symbol	VARCHAR
2	precision	VARCHAR
3	pattern	VARCHAR
4	active	VARCHAR
5	names	VARCHAR
6	deleted	VARCHAR
7	name	VARCHAR
8	modified	VARCHAR
9	id	INTEGER	Primary Key
10	iso_code	VARCHAR
11	numeric_iso_code	VARCHAR
12	conversion_rate	VARCHAR
13	unofficial	VARCHAR

External Resources

• Switched On
• Documentation
• Content Management System
• Image Types
• Order Details
• Order States
• Price Ranges
• Product Customization Fields
• Product Feature Values
• Product Features
• Product Option Values
• Product Suppliers
• Shopgroups
• Shopurls
• Specific Price Rules
• Specific Prices
• Stock Availables
• Tax Rules
• Translated Configurations
• Weight Ranges
• Cart Rules
• Customer Messages
• Customer Threads
• Order Carriers
• Order Histories
• Order Invoices
• Order Payments
• Order Slip
• Stock Movement Reasons
• Stock Movements
• Tax Rule Groups

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.