uStore Stores that use Worldline / Ogone / Ingenico?

[west-digital.fr]

Hello,

XMPie recently reminded that Worldline / Ogone / Ingenico (regardless the name) is expected to stop offering their current API on 31 Dec. 2025 (see full statement here).

As it's the case at several customers of us, if you have tons of Stores on your uStore platform, and no longer really remember, which of them are set to use Ogone, you could consider running a query such as this one:

USE [uStore];

WITH OgoneStores AS (
    SELECT DISTINCT SCC.StoreId
    FROM dbo.StoreClearingConfig AS SCC
    JOIN dbo.ClearingConfig AS CC
      ON CC.ClearingConfigId = SCC.ClearingConfigId
    WHERE EXISTS (
        SELECT 1
        FROM dbo.ConfiguredPluginDef AS CPD
        JOIN dbo.PluginDef AS PD
          ON PD.PluginDefId = CPD.PluginDefId
        WHERE CPD.ConfiguredPluginDefId IN (CC.ClearingConfPlugId, CC.DataCollectionConfPlugId)
          AND PD.PluginName LIKE N'%Ogone%'
    )
)
SELECT
    CI.StoreID,
    SC.Name           AS StoreName
FROM dbo.CultureInfo   AS CI
JOIN dbo.Store_Culture AS SC
  ON SC.StoreID  = CI.StoreID
 AND SC.CultureID = CI.BaseCultureId
WHERE
    CI.StatusID = 1
    AND CI.IsSetupCulture = 1
    AND CI.StoreID IN (SELECT StoreID FROM OgoneStores)
ORDER BY CI.StoreID;

Adapt and enjoy!

west-digital.fr