PrestaShopWebservice and an API key instead of SQL and scripts

PrestaShopwithout your own API

Instead of queries in the SQL Manager and your own Webservice script: create an API key with GET permissions and paste it into DataOrganizer. Orders, products and stock are ready for analysis and refreshed daily.

Try it free for 14 days See the app demo

No credit cardNo module and no changes to the store’s codeData refreshed daily

Today: exporting orders from PrestaShopevery week

SQL Manager, export to CSV

SELECT o.reference, o.date_add, o.current_state,
       o.total_paid_tax_excl - o.total_shipping_tax_excl AS net_revenue
FROM ps_orders o
WHERE o.date_add >= '2026-09-21'
  AND o.current_state IN (2, 4, 5);

Then, still by hand

  • products and stock: more queries
  • GA4 and campaign costs: pasted into a spreadsheet
  • new module or update: you fix the query
In DataOrganizer: paste the API key onceOrders, products and stock are ready every day, next to GA4 and campaigns.

This is how it looks in the app

PrestaShop connected,next to Google and Meta

A sample store, as of 28 September 2026. The “Data Availability” panel shows every source: the date range and the time of the last sync. PrestaShop sits next to Google Analytics, Search Console, Merchant Center, Google Ads and Meta Ads.

  1. PrestaShop in your data sourcesOrders and product data, with the date range and the time of the last sync.
  2. Google and Meta next to the storeAnalytics, Search Console, Merchant Center, Google Ads and Meta Ads in the same view.
  3. History rangeYou choose how much history to pull. The “Integrations” button takes you to the data sources.

How it works

Three steps. Only the first one needs you.

  1. 1Once, at the start

    You connect PrestaShop

    Paste the API key and store address into the source wizard. No changes to the store’s code.

  2. 2Daily, without you

    DataOrganizer syncs the data

    Once a day it pulls orders, products and stock, calculates net revenue and joins the store with GA4 and campaigns.

  3. 3Whenever you like

    Get the data out however you like

    Ready-made cards, table export, the Google Sheets add-on or MCP for Claude and other AI assistants.

    CSVExcelGoogle SheetsMCP

How to connect PrestaShop

Webservice and an API key.No module and no changes to the store’s code.

The connection uses the platform’s official API. DataOrganizer only reads data and changes nothing in your store.

PsIn the PrestaShop adminstore administrator

  1. Enable the Webservice.The API built into PrestaShop.
  2. Create an API key.Grant GET permissions to the required resources, i.e. read-only.
  3. Copy the key and store address.You paste these two values into DataOrganizer.

To copy

Store URLhttps://yourstore.com

API Key6Y8K••••••••••••Q2ZD

DOIn DataOrganizerdata source wizard

  1. Add a source.Choose the sales channel, then the PrestaShop platform.
    Data integrations → Data sources → Add source
  2. Paste the access details.Store URLAPI Key
  3. Choose the language and currency.If the wizard asks, pick the store version you want to analyse.
  4. Tick the statuses counted as revenue.In the channel’s “⋯” menu. Other orders are “outside analytics”.

PermissionsGET only, i.e. reading data

First synctakes the longest; data appears gradually

After thatonce a day; you can also run a sync manually

What goes into DataOrganizer

Orders without SQLand without writing exports

One tidy table instead of queries against ps_orders, ps_order_detail and ps_stock_available. Calculated the same way every day.

AreaWhat we pullHow we calculate

Ordersnumber, date, status and valueyou choose which statuses count as revenue

Revenuenet, excluding VAT and shipping costsVAT rates pulled from the platform

ProductsID, name, price, category and variantsthe “Products” and “Current prices” datasets

Stock levelsproduct stockevery night at approx. 2:00, if the platform provides stock

Payments and deliverypayment and delivery methodsshare of orders for each method

Discountscoupon codes and promotionsdiscount next to basket value

Customersnew and returning, purchase frequency, LTVonly aggregate figures in views and exports, without names, addresses, emails or phone numbers

In the app · Orders card

Orders in analytics

1,356 of 1,402 (96.7%). Skipped: 46.

StatusShareOrders

Completed74.8%1,048

Processing22.0%308

Cancelledoutside analytics2.1%29

Failedoutside analytics0.9%12

Awaiting paymentoutside analytics0.4%5

You choose the counted statuses in the channel’s “⋯” menu in Integrations. The rest doesn’t count as revenue.

History and refreshYou choose how much history to pull and can change it with the “Update data range” button. Data refreshes once a day, or manually when needed.

How you get the data out

CSV, Excel, Google Sheetsor MCP for your AI assistant

Data from PrestaShop and your other sources sits in tables on the cards. Export a table with one click, or connect a Google Sheet and an AI assistant that pulls the data itself.

  1. DatasetsProducts, Current prices, Daily Data and more. You pick the columns from the store, GA4 and combined data.
  2. ExportCSV and Excel contain every row, while copying to the clipboard takes only the visible page.
  3. MCPPaste the server address into Claude, ChatGPT, Gemini or Perplexity and sign in with your DataOrganizer account.
  4. Google Sheets add-onIn the sheet: Extensions → DataOrganizer. Data refreshes on the schedule you choose.

Who it’s for

PrestaShop connected once, data for the whole team

PrestaShop developer

No more queries in the SQL Manager

Today: you write an SQL query or a Webservice script to export orders to a spreadsheet, and fix it after every change in the store.

  • A GET key instead of a script. The store connected via the Webservice, no module.
  • Revenue calculated. Net, excluding VAT and shipping, from the statuses you choose.
  • The store next to GA4 and campaigns. No joining tables in a spreadsheet.
  • CSV, Excel, Sheets, MCP. Data in the format your team needs.
PrestaShop implementation specialist

Client reports without building your own integration

Today: you set up the Webservice and an API key for every external tool, and the sales report still ends up in Excel.

  • One connection. The API key and store address in the source wizard.
  • Several stores or countries. Separate sales channels for countries and brands.
  • Ready-made cards. Sales, products, customers and campaigns without building a dashboard.
  • Fresh data every day. A sync once a day, with nothing for you to do.

Integrations

Connectors you don’t have to write

Store platforms

  • PsPrestaShop
  • WoWooCommerce
  • MgMagento 2
  • IdIdoSell
  • ShShoper
  • SkSky-Shop
  • RcRedCart

Analytics, ads and affiliate

  • GAGoogle Analytics 4
  • AdGoogle Ads
  • MeMeta Ads
  • TtTikTok Ads
  • CrCriteo
  • TTTradeTracker

Google

  • MCMerchant Center
  • SCSearch Console

Can’t see your platform? Write to contact@dataorganizer.io and we’ll check its API.

Connect PrestaShop once.Get your data every day.

Paste the API key once and DataOrganizer does the rest. For 14 days you get everything free, with no credit card.

Try it free for 14 days See the app demo

14 daysfree,
no credit card

  • Every feature: cards, AI Assistant, MCP and exports
  • PrestaShop next to GA4, Google Ads and Meta Ads
  • Data refreshed once a day, no exports