Skip to main content

Google Shopping Store Management

The ECOSIRE Google Shopping Store Management module integrates your Google Merchant Center account with Odoo through the official Google Merchant API v1. Push your Odoo catalog to Google Merchant Center, sync stock and local inventory, review product approval issues, and import promotions — all from Odoo.

Compatibility: Odoo 17 / 18 / 19 Price: $499 (one-time) License: OPL-1 (Odoo Proprietary License); no activation key

Key Features​

  • Google Merchant API v1 client targeting merchantapi.googleapis.com (products, local + regional inventory, data sources, merchant accounts, programs, promotions, reviews, product issues, notifications)
  • OAuth2 refresh-token flow (client ID, client secret, refresh token) with automatic token refresh
  • Multi-instance support (one record per Merchant Center account)
  • Product export: title, description and price (offer ID = internal reference); product import matches Merchant Center GTIN to the Odoo barcode
  • Local inventory export per store code (/inventories/v1/.../localInventories:insert); regional inventory read on demand
  • Product approval status and per-issue explanations (Merchant Center product issues)
  • Performance Max and Conversion Action records for accounts that also run Google Ads (figures entered by you; no automatic Google Ads import yet)
  • Inbound webhook endpoint with HMAC-SHA256 shared-secret check
  • OWL real-time dashboard with KPIs and charts, auto-refresh every 60 seconds
  • No licence key or activation step

Prerequisites​

  • Odoo 17, 18, or 19 (Community or Enterprise)
  • A Google Merchant Center account (or sub-account under an MCA)
  • A Google Cloud project with the Merchant API enabled
  • An OAuth 2.0 client (client ID + client secret) and a refresh token authorised for the https://www.googleapis.com/auth/content scope by a user with access to your Merchant Center account

Installation​

  1. Download the module ZIP delivered with your purchase.
  2. Extract googleshopping_store_management/ into your Odoo addons directory.
  3. Restart Odoo and click Apps → Update Apps List.
  4. Search for Google Shopping Store Management and click Install.

Configuration​

Step 1: Set up Google Cloud + Merchant Center​

  1. In the Google Cloud Console create (or reuse) a project, then enable Merchant API.
  2. Create an OAuth client ID and note the client ID and client secret.
  3. Authorise the https://www.googleapis.com/auth/content scope with a Google user who has access to your Merchant Center account and keep the refresh token.
  4. Note your Merchant ID.

Step 2: Create an instance in Odoo​

  1. Navigate to Google Shopping → Configuration → Instances.
  2. Click Create and fill in:
    • Merchant ID
    • Client ID, Client Secret and Refresh Token
    • Data source name (the Merchant Center data source products are inserted into)
  3. Click Test Connection.
  4. Save.

Step 3: Product feed configuration​

  • What is sent — each exported product sends its title, description and price (instance currency); the offer ID is the product's internal reference. Products are sent with feed label US and content language en.
  • Sync cadence — the Googleshopping: Sync Products scheduled action runs every 30 minutes by default; stock runs every 10 minutes.

Initial Sync​

  1. Open Google Shopping → Operations → Run Operations.
  2. Choose Export Products (or Import Products to pull what Merchant Center already holds).
  3. Run it. Errors show up in Operations → Logs and the queue with Google's own rejection text.
  4. Use Explain Product Disapprovals for products Google rejects.

Dashboard​

The OWL dashboard renders:

  • KPI cards: products, average order value, queue jobs, sync health, sync success and sync errors, plus connection state
  • Charts: sales trend, order status, top products (Chart.js)
  • Auto-refresh every 60 seconds

Troubleshooting​

IssueLikely cause + fix
401 UNAUTHENTICATED from Merchant APIThe refresh token was revoked or issued for a user without Merchant Center access, or the client secret changed. Re-authorise and paste the new refresh token.
Many offers disapproved for missing identifiersThe connector does not send GTIN/MPN/brand; add them in Merchant Center (for example with a supplemental data source).
Pricing rejectedCurrency mismatch between Odoo price and Merchant Center country settings. Use a pricelist tied to the target country.
Webhook signature failedThe endpoint checks an X-Googleshopping-Hmac-SHA256 header against the instance's client secret (used as the shared secret); the sender must sign the body with that secret.

Support​

Last updated on