Connectors

/

PrestaShop

Data replication

Sync PrestaShop data anywhere.

PrestaShop is an open-source e-commerce platform whose cutting-edge technology powers over 300,000 e-commerce businesses globally. The PrestaShop mission is to allow the open-source community to “put their heads together” to develop superior eCommerce software—which they achieved in 2016, winning CMS Critic Award for Best eCommerce Software. The perfect solution for creating and growing an online business, PrestaShop provides all the features needed to achieve success.

  • Standard
  • Beta
  • 55 streams
Sync PrestaShop dataRead the docs
PrestaShop

One connector

Everything PrestaShop can do in Airbyte

  • Sync to your warehouse

    Land 55 PrestaShop tables in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate PrestaShop once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the PrestaShop connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync PrestaShop

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version1.2.7
  • Release stageBeta

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

  1. First, you need to obtain the necessary credentials to connect your PrestaShop source connector. This includes your PrestaShop URL, API key, and API secret key. You can find these credentials in your PrestaShop account under the "Advanced Parameters" tab.
  2. Once you have your credentials, open the Airbyte dashboard and click on "Sources" in the left-hand menu.
  3. Click on the "Create a new connection" button and select "PrestaShop" from the list of available connectors.
  4. In the "Connection Configuration" page, enter your PrestaShop URL, API key, and API secret key in the appropriate fields.
  5. Click on the "Test" button to ensure that your credentials are correct and that Airbyte can connect to your PrestaShop account.
  6. If the test is successful, click on the "Save & Continue" button to proceed to the next step.
  7. In the "Schema Selection" page, select the tables that you want to replicate from your PrestaShop account.
  8. Click on the "Save & Continue" button to proceed to the final step.
  9. In the "Sync Configuration" page, configure the replication settings for your PrestaShop data. This includes the frequency of data replication, the destination for your data, and any transformations that you want to apply to your data.
  10. Click on the "Save & Test" button to finalize your PrestaShop source connector configuration. Your data will now be replicated from your PrestaShop account to your destination according to your configured settings.

55 streams

Every table you can sync from PrestaShop

  • Carriers

  • Combinations

  • Contacts

  • Content Management System

  • Countries

  • Currencies

  • Deliveries

  • Employees

  • Guests

  • Image Types

  • Languages

  • Order Details

  • Order States

  • Price Ranges

  • Product Customization Fields

  • Product Feature Values

  • Product Features

  • Product Option Values

  • Product Suppliers

  • ShopGroups

  • ShopUrls

  • Shops

  • Specific Price Rules

  • Specific Prices

  • States

  • Stock Availables

  • Tags

  • Tax Rules

  • Taxes

  • Translated Configurations

  • Weight Ranges

  • Zones

  • Addresses

  • Cart Rules

  • Carts

  • Categories

  • Configurations

  • Customer Messages

  • Customer Threads

  • Customers

  • Groups

  • Manufacturers

  • Messages

  • Order Carriers

  • Order Histories

  • Order Invoices

  • Order Payments

  • Order Slip

  • Orders

  • Products

  • Stock Movement Reasons

  • Stock Movements

  • Stores

  • Suppliers

  • Tax Rule Groups

Authentication

Authenticate PrestaShop once

  • Access Key

    Your PrestaShop access key. See the docs for info on how to obtain this.

Explore

Related connectors

PrimetricFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
PrintifyFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
ProductiveFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
QuickBooksFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
RailzFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
RechargeFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

PrestaShop's API provides access to a wide range of data related to e-commerce stores. The following are the categories of data that can be accessed through PrestaShop's API:

1. Products: Information related to products such as name, description, price, stock, images, and categories.
2. Customers: Data related to customers such as name, email, address, and order history.
3. Orders: Information related to orders such as order number, customer details, products ordered, and payment information.
4. Categories: Data related to product categories such as name, description, and parent categories.
5. Manufacturers: Information related to manufacturers such as name, description, and logo.
6. Suppliers: Data related to suppliers such as name, address, and contact information.
7. Carriers: Information related to shipping carriers such as name, description, and shipping rates.
8. Employees: Data related to employees such as name, email, and access permissions.
9. Languages: Information related to languages used in the store such as name, code, and translations.
10. Currencies: Data related to currencies used in the store such as name, code, and exchange rates.

1. First, you need to obtain the necessary credentials to connect your PrestaShop source connector. This includes your PrestaShop URL, API key, and API secret key. You can find these credentials in your PrestaShop account under the "Advanced Parameters" tab.
2. Once you have your credentials, open the Airbyte dashboard and click on "Sources" in the left-hand menu.
3. Click on the "Create a new connection" button and select "PrestaShop" from the list of available connectors.
4. In the "Connection Configuration" page, enter your PrestaShop URL, API key, and API secret key in the appropriate fields.
5. Click on the "Test" button to ensure that your credentials are correct and that Airbyte can connect to your PrestaShop account.
6. If the test is successful, click on the "Save & Continue" button to proceed to the next step.
7. In the "Schema Selection" page, select the tables that you want to replicate from your PrestaShop account.
8. Click on the "Save & Continue" button to proceed to the final step.
9. In the "Sync Configuration" page, configure the replication settings for your PrestaShop data. This includes the frequency of data replication, the destination for your data, and any transformations that you want to apply to your data.
10. Click on the "Save & Test" button to finalize your PrestaShop source connector configuration. Your data will now be replicated from your PrestaShop account to your destination according to your configured settings.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving PrestaShop data today

Free for 14 days on Airbyte Cloud. Set up the PrestaShop connector once and let Airbyte keep it in sync.

Try it freeTalk to sales