PrestaShop + Google Shopping

Where a PrestaShop Google Shopping feed comes from

PrestaShop's back office imports CSV but has no product feed export in the core. The two free sources are a module and the database. The gshoppingflux module (a fork of ps_googleshopping) is open source under the Apache 2.0 license, generates an XML feed for Google Merchant Center, supports Local Inventory and Product Reviews feeds, and has automatic cron generation; the README lists 1.6.0.6 through 9.1.5 as tested versions. The Addons marketplace also sells paid modules with more mapping options.

The second source is the SQL Manager under Advanced Parameters → Database. It only runs SELECT queries, which is what you want, and each saved query has an export icon that downloads the result as CSV with UTF-8 or ISO-8859-1 encoding. A query joining ps_product, ps_product_lang, ps_stock_available and ps_image gives you a flat product table. The download is manual, so it suits a first load or a store that schedules the same query on its own cron and serves the file by URL.

PrestaShop fields to Google Shopping attributes

Fixes between PrestaShop and Merchant Center

• Tax: PrestaShop stores prices without tax and shows them with tax. Google compares the feed price with the product page, so send the tax-inclusive price your customers see, or Merchant Center flags a mismatch.
• Combinations: each combination is a sellable item. Map the combination reference to id, id_product to item_group_id, and the attribute values (color, size) to Google's color and size.
• Multilingual stores: ps_product_lang has one row per language. Filter one id_lang per feed and build one feed per language and country; Textfinity's AI configs can translate titles and descriptions when a language has no copy of its own.
• HTML descriptions: the editor stores tags. One remove from regexp rule returns plain text.
• Inactive products and products with no image: filter active = 1 and a non-blank image URL column in the source so Google never sees them.

How Merchant Center fetches the feed

Merchant Center fetches product files from a URL added as a product source in its data sources settings. The URL must start with http, https, ftp or sftp and point at the file itself; you choose the fetch schedule and can add a login for protected files. Files can be up to 4 GB. This is done in Google's interface.

Textfinity rebuilds the Google feed on the shop's sync schedule and keeps it on one stable URL, so the URL is registered once; we do that in your Merchant Center with you, through access you give us or on a short call. Make sure the module's cron, or your SQL export cron, runs at least as often as the Textfinity sync so the chain PrestaShop → module URL → Textfinity → Merchant Center never serves stale stock.

SELECT p.id_product, p.reference, p.ean13, p.price, p.active,
       pl.name, pl.description_short, pl.link_rewrite,
       sa.quantity, m.name AS manufacturer
FROM ps_product p
JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_lang = 1
JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0
LEFT JOIN ps_manufacturer m ON m.id_manufacturer = p.id_manufacturer