WooCommerceREST API keys instead of your own scripts

WooCommercewithout scripts

Instead of a script that pages through the REST API, or an SQL query against the WordPress database: generate REST API keys with Read permission and paste them into DataOrganizer. Orders and products are ready for analysis and refreshed daily.

Try it free for 14 days See the app demo

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

Today: exporting orders from WooCommercenightly cron

export script, REST API

# page by page, 100 orders at a time
GET /wp-json/wc/v3/orders?per_page=100&page=7
    &after=2026-09-21T00:00:00
    &status=completed,processing
Authorization: Basic ck_…:cs_…

Then, still by hand

  • net: subtract VAT and shipping costs
  • products and variants: separate queries
  • GA4 and campaigns: pasted into Google Sheets
In DataOrganizer: paste the REST API keys onceOrders, products and stock are ready every day, next to GA4 and campaigns.

This is how it looks in the app

WooCommerce 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. WooCommerce sits next to Google Analytics, Search Console, Merchant Center, Google Ads and Meta Ads.

  1. WooCommerce 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 WooCommerce

    Paste the REST API keys 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 WooCommerce

REST API keys.No plugin 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.

WoIn the WooCommerce adminWordPress administrator

  1. Set permalinks to anything other than “Plain”.The WooCommerce REST API doesn’t work with the Plain setting.
    Settings → Permalinks
  2. Add a REST API key with Read permission.Read means read-only.
    WooCommerce → Settings → Advanced → REST API
  3. Copy the Consumer Key and Consumer Secret.WooCommerce shows them once, right after they’re generated.

To copy

Store URLhttps://yourstore.com

Consumer Keyck_4f1a•••••••••••9c2e

Consumer Secretcs_b07d•••••••••••31fa

DOIn DataOrganizerdata source wizard

  1. Add a source.Choose the sales channel, then the WooCommerce platform.
    Data integrations → Data sources → Add source
  2. Paste the access details.Store URLConsumer KeyConsumer Secret
  3. Tick the statuses counted as revenue.In the channel’s “⋯” menu. Other orders are “outside analytics”.

PermissionsRead 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 paging through /wc/v3/orders and separate queries for products and variants. 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 WooCommerce 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

WooCommerce connected once, data for the whole team

WooCommerce developer

No more REST API scripts

Today: you write a script or an SQL query against the WordPress database to export orders to a spreadsheet, and keep an eye on it after every update.

  • Read keys instead of a script. No plugin and no changes to the store’s code.
  • 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.
Reporting person

WooCommerce orders in Google Sheets

Today: every week you export orders to CSV, paste them into a sheet and add data from GA4 and campaigns.

  • Google Sheets add-on. Extensions → DataOrganizer, refreshing on the schedule you choose.
  • Scope before import. You choose dates, columns and filters.
  • Several sources in one table. Store, GA4 and campaigns side by side.
  • Fresh data every day. No manual export.

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 WooCommerce once.Get your data every day.

Paste the REST API keys 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
  • WooCommerce next to GA4, Google Ads and Meta Ads
  • Data refreshed once a day, no exports