Connectors
PrestaShop
Connectors
PrestaShop
Description
PrestaShop is an open-source e-commerce solution that powers more than 250,000 stores worldwide.
Connector Details
| Name | Value |
|---|---|
| Platform | PrestaShop |
| Auth Type | API Keys |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the PrestaShop connector.
| Table Name | Fields |
|---|---|
| addresses | id, id_customer, id_manufacturer, id_supplier, id_warehouse, id_country, id_state, alias, company, lastname, firstname, vat_number, address1, address2, postcode, city, other, phone, phone_mobile, dni, deleted, date_add, date_upd |
| categories | id, id_parent, level_depth, active, id_shop_default, is_root_category, position, date_add, date_upd, name, link_rewrite, description, meta_title, meta_description, meta_keywords |
| combinations | id, id_product, location, ean13, isbn, upc, quantity, reference, supplier_reference, wholesale_price, price, ecotax, weight, unit_price_impact, minimal_quantity, low_stock_threshold, low_stock_alert, default_on, available_date, associations |
| countries | id, id_zone, id_currency, call_prefix, iso_code, active, contains_states, need_identification_number, need_zip_code, zip_code_format, display_tax_label, name |
| currencies | id, iso_code, numeric_iso_code, precision, conversion_rate, deleted, active, name, symbol |
| order_carriers | id, id_order, id_carrier, id_order_invoice, weight, shipping_cost_tax_excl, shipping_cost_tax_incl, tracking_number, date_add |
| order_details | id, id_order, product_id, product_attribute_id, product_quantity_reinjected, group_reduction, discount_quantity_applied, download_hash, download_deadline, id_order_invoice, id_warehouse, id_shop, id_customization, product_name, product_quantity, product_quantity_in_stock, product_quantity_return, product_quantity_refunded, product_price, reduction_percent, reduction_amount, reduction_amount_tax_incl, reduction_amount_tax_excl, product_quantity_discount, product_ean13, product_isbn, product_upc, product_reference, product_supplier_reference, product_weight, tax_computation_method, id_tax_rules_group, ecotax, ecotax_tax_rate, download_nb, unit_price_tax_incl, unit_price_tax_excl, total_price_tax_incl, total_price_tax_excl, total_shipping_price_tax_excl, total_shipping_price_tax_incl, purchase_supplier_price, original_product_price, original_wholesale_price, associations |
| order_histories | id, id_employee, id_order_state, id_order, date_add |
| order_invoices | id, id_order, number, delivery_number, delivery_date, total_discount_tax_excl, total_discount_tax_incl, total_paid_tax_excl, total_paid_tax_incl, total_products, total_products_wt, total_shipping_tax_excl, total_shipping_tax_incl, shipping_tax_computation_method, total_wrapping_tax_excl, total_wrapping_tax_incl, shop_address, note, date_add |
| order_payments | id, order_reference, id_currency, amount, payment_method, conversion_rate, transaction_id, card_number, card_brand, card_expiration, card_holder, date_add |
| order_slips | id, id_customer, id_order, conversion_rate, total_products_tax_excl, total_products_tax_incl, total_shipping_tax_excl, total_shipping_tax_incl, amount, shipping_cost, shipping_cost_amount, partial, date_upd, date_add |
| order_states | id, unremovable, delivery, hidden, send_email, module_name, invoice, color, logable, shipped, paid, pdf_delivery, pdf_invoice, deleted, name, template |
| orders | id, id_address_delivery, id_address_invoice, id_cart, id_currency, id_lang, id_customer, id_carrier, current_state, module, invoice_number, invoice_date, delivery_number, delivery_date, valid, date_add, date_upd, shipping_number, id_shop_group, id_shop, secure_key, payment, recyclable, gift, gift_message, mobile_theme, total_discounts, total_discounts_tax_incl, total_discounts_tax_excl, total_paid, total_paid_tax_incl, total_paid_tax_excl, total_paid_real, total_products, total_products_wt, total_shipping, total_shipping_tax_incl, total_shipping_tax_excl, carrier_tax_rate, total_wrapping, total_wrapping_tax_incl, total_wrapping_tax_excl, round_mode, round_type, conversion_rate, reference, associations |
| product_option_values | id, id_attribute_group, color, position, name |
| products | id, id_manufacturer, id_supplier, id_category_default, new, cache_default_attribute, id_default_image, id_tax_rules_group, position_in_category, manufacturer_name, quantity, type, id_shop_default, reference, supplier_reference, location, width, height, depth, weight, quantity_discount, ean13, isbn, upc, cache_is_pack, cache_has_attachments, is_virtual, state, additional_delivery_times, delivery_in_stock, delivery_out_stock, on_sale, online_only, ecotax, minimal_quantity, low_stock_threshold, low_stock_alert, price, wholesale_price, unity, unit_price_ratio, additional_shipping_cost, customizable, text_fields, uploadable_files, active, redirect_type, id_type_redirected, available_for_order, available_date, show_condition, condition, show_price, indexed, visibility, advanced_stock_management, date_add, date_upd, pack_stock_type, meta_description, meta_keywords, meta_title, link_rewrite, name, description, description_short, available_now, available_later, associations |
| shops | id, id_shop_group, id_category, active, deleted, name, theme_name |
| stock_availables | id, id_product, id_product_attribute, id_shop, id_shop_group, quantity, depends_on_stock, out_of_stock, location |
| suppliers | id, link_rewrite, name, active, date_add, date_upd, description, meta_title, meta_description, meta_keywords |