GET https://gshopping.idento.es/consulta-ecommerce/analitica

HTTP Client

3 Total requests
0 HTTP errors

Clients

http_client 3

Requests

GET https://gshopping.idento.es/gshoppingApp/api/gshopping/ecommerces/
Request options
[
  "base_uri" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/"
  "headers" => [
    "Authorization" => "08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA"
    "Content-Type" => "application/json"
  ]
]
Response 200
[
  "info" => [
    "header_size" => 123
    "request_size" => 461
    "total_time" => 0.029104
    "namelookup_time" => 0.000461
    "connect_time" => 0.000589
    "pretransfer_time" => 0.009166
    "size_download" => 43475.0
    "speed_download" => 1499137.0
    "starttransfer_time" => 0.027386
    "primary_ip" => "103.23.60.149"
    "primary_port" => 443
    "local_ip" => "103.23.60.149"
    "local_port" => 55946
    "http_version" => 3
    "protocol" => 2
    "scheme" => "HTTPS"
    "appconnect_time_us" => 9004
    "connect_time_us" => 589
    "namelookup_time_us" => 461
    "pretransfer_time_us" => 9166
    "starttransfer_time_us" => 27386
    "total_time_us" => 29104
    "start_time" => 1742201284.6714
    "original_url" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/ecommerces/"
    "pause_handler" => Closure(float $duration) {#509
      class: "Symfony\Component\HttpClient\Response\CurlResponse"
      use: {
        $ch: CurlHandle {#489 …}
        $multi: Symfony\Component\HttpClient\Internal\CurlClientState {#391 …}
        $execCounter: -9223372036854775808
      }
    }
    "debug" => """
      *   Trying 103.23.60.149:443...\n
      * TCP_NODELAY set\n
      * Connected to gshopping.idento.es (103.23.60.149) port 443 (#0)\n
      * ALPN, offering h2\n
      * ALPN, offering http/1.1\n
      * successfully set certificate verify locations:\n
      *   CAfile: /etc/ssl/certs/ca-certificates.crt\n
        CApath: /etc/ssl/certs\n
      * SSL connection using TLSv1.3 / TLS_AES_256_GCM_SHA384\n
      * ALPN, server accepted to use h2\n
      * Server certificate:\n
      *  subject: CN=idento.es\n
      *  start date: Jan 20 06:18:01 2025 GMT\n
      *  expire date: Apr 20 06:18:00 2025 GMT\n
      *  subjectAltName: host "gshopping.idento.es" matched cert's "*.idento.es"\n
      *  issuer: C=US; O=Let's Encrypt; CN=R11\n
      *  SSL certificate verify ok.\n
      * Using HTTP2, server supports multi-use\n
      * Connection state changed (HTTP/2 confirmed)\n
      * Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0\n
      * Using Stream ID: 1 (easy handle 0x55d3eab36610)\n
      > GET /gshoppingApp/api/gshopping/ecommerces/ HTTP/2\r\n
      Host: gshopping.idento.es\r\n
      authorization: 08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA\r\n
      content-type: application/json\r\n
      accept: */*\r\n
      user-agent: Symfony HttpClient (Curl)\r\n
      accept-encoding: gzip\r\n
      \r\n
      * old SSL session ID is stale, removing\n
      * Connection state changed (MAX_CONCURRENT_STREAMS == 128)!\n
      < HTTP/2 200 \r\n
      < server: nginx\r\n
      < date: Mon, 17 Mar 2025 08:48:04 GMT\r\n
      < content-type: application/json\r\n
      < x-powered-by: PleskLin\r\n
      < \r\n
      """
  ]
  "response_headers" => [
    "HTTP/2 200 "
    "server: nginx"
    "date: Mon, 17 Mar 2025 08:48:04 GMT"
    "content-type: application/json"
    "x-powered-by: PleskLin"
  ]
  "response_content" => [
    "[{"id":22,"nombre":"Perlighting","urlEcommerce":"https://perlighting.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"peowaw83tpazkwavcg78yg0m724spbn70ntxwkbotdghoai10y4fbnl4hikuoscogf2q830foemgyupyrm5h8hmwju40afarbpo1h012w7b2h79iirr3yj55g2ya38ps28bug49cs3cwrwyp59kuto7suwo3yj2d9ufavvs92gp1k302kh3l92ybkqlqce17po1j9k4upiooohic0zj57e6nxj7agy4k23juahg1dk36d7i4n4ria3jeobpnv7b9","urlSpreadsheetInformes":"","usuarios":{},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":2,"listadoMerchantFeeds":[{"merchantId":280040331,"idFeed":10098079424}]},{"id":76,"nombre":"Colchones Distar","urlEcommerce":"https://colchones.distar.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"bn23izu64f7499mk8khmrfl5w1l4h2s5k1vtmbaaxqamvayxmnk09n5t6yem3g6r5c9m2bna1r7gbwvyk3h6vpe1k1gpnpdlg26q7jriap7ixj890kzy2c50vxi0pvb79mpesdrnv0zmxolqncu3iqf7j6f28qmk3yjr6q4vpp6ow7xxq0nbulbl9coiaw31wcj8ox6kpoymqg1k4jj2fv71qq1nj8vedscgb0dqg7qmcg216z3fcp5m65vqfgiu","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1BV8YW6ecXULMud9JyA2yBr8RRmRGYKJG4sMg4ZResZ0/edit?gid=145523367#gid=145523367","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":708446085,"idFeed":10424690535}]},{"id":77,"nombre":"Mumuchu","urlEcommerce":"https://www.mumuchu.com/","tipoEcommerce":"MAGENTO","versionEcommerce":null,"habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"sb9nhbjoz53s4w5stf0jt1nq3vhkpcsa9p520x1jkgv2u79bcxfx8hquqe1mwjxvadtfrca5wvuz8m8vth5pw66sjoyx7yr02riw3leynyts9qwrmh828dgmd1dzretb7wu0pdqvf3eoknlc4gx1gdxcyflie321fkp60bpj9dyxphq5w66v6ah9we6qzwk2bishspk4lxyicrk3s2nf6tjmb3uxff9ui0cby8kcc43u017iafxsws64dbq2n5p0","urlSpreadsheetInformes":"","usuarios":{"34":"lleyva@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":340867057,"idFeed":10424811865}]},{"id":78,"nombre":"tienda prueba patrick","urlEcommerce":"https://123","tipoEcommerce":"PRESTASHOP","versionEcommerce":null,"habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"123","variableVariantes":"","versionPlugin":null,"tokenApi":"9k06uirhvfo14xzaqp3qze1lyuz77baisk6m7lximt3hp9mzgc0pckrubktojbo9jncb1gvv6jwszt99hjt5q61z2d9la2m1ujbdou3yows49aclwovnxh01rgow58zozuio7znm2sy9c8zjkehoia979243tmqe1c8ku213t4vbp5r4jamtthzqhxzm6xfbyws89yk74uhbu7yi6w2vh5gudrut5npuh5k5rw6h2u0osjrxltt0bmstvh5uifmz","urlSpreadsheetInformes":"123","usuarios":{"36":"pmoreno@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":123,"idFeed":123}]},{"id":68,"nombre":"Tienda del Soldado","urlEcommerce":"https://www.tiendadelsoldado.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.9","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"9w74z3ojow1rz6r5t2wwc5m1l9nkde7s8kreafxs7p1hpyuyanc19xnryugpay51l7uttj6yzufif3koew1v94zq8w9gqwtxg1pcug43o11nj97vvqtp3n6r2sjynmt0pkskumqswlqzvbum0tbxvm4gazdp3mmj4hxo7hutlrtswypl0zgj2cslub8e2ktitd9noaous8f9h1hrrl7n3y1q5c245x75wmsoy1w4pyuduwlscd40r2gjz8wq36x1","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/14yEFAaCvRWokg9LT7OxhqB5_wd730LLDqjbkSpl0v_Q/edit?gid=1649677236#gid=1649677236","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":140452675,"idFeed":10398314392}]},{"id":1,"nombre":"Farmacia Boticana","urlEcommerce":"https://www.boticana.es","tipoEcommerce":"PRESTASHOP","versionEcommerce":null,"habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":null,"versionPlugin":null,"tokenApi":"areml3o2e8qxafewqjt5u6qtz9m109lnflha34dp4alasqjghgcf28swzp57pflapfc19uxpy9xfup975tkt8n7tgewrdclo0hcesw0x1mtizq5v4434s9v986ot9qomwdtvq4dg18dltbmgp1g35cm4j1qbc9vprdquifmithg6t8zlpixy3mxsfixpshbjbw7k6njs0i2fllk8xdvo6hxvoxi4olimxc9d369m2r79e4gs0rj2rbkvjltp1kpf","urlSpreadsheetInformes":null,"usuarios":{"2":"clopez@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":9300764,"idFeed":9300764}]},{"id":4,"nombre":"Ortoespaña","urlEcommerce":"https://xn--ortopediaortoespaa-30b.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"OEES","variableVariantes":"v","versionPlugin":null,"tokenApi":"3peuzxo4gkgp8aks67ci50cy959pyool95sr5iq074smy57y7blpj2rojoczrb74hqgzh25hwt98gcuu08fiq7ply1fwzzgnnolt2x7a22y70bf944nk8k6wea1afipuvtwc2nialw1n9gpu3fe5jpq7hmli85z8kaupir2vasotj4qejcqhg0g9ceag8wu14qju5a6age0kmirgz1vgf3rwy4rdyme1irzd4w2o2ld10vjolkt4g5cpcd3t21pe","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1CAgUoPhzRDyFAD00s56cm3pi32WL-KeNmy8kui6O7HI/edit?pli=1&gid=0#gid=0","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":102443689,"idFeed":10097332708}]},{"id":23,"nombre":"Conely","urlEcommerce":"https://www.conely.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"n9zbpoi1fb9xxl6geig1i3ffp2v4gujdem4duyehx9mj0wkiq02dwgpn7xl7cy85nv5r2peekr1nou5icmozzsdo7pn9cwm8rfswbgvpfqui2stqy16fil03lpy09hngxldsf8qnco4tt3wcqvjgxbd4bcxvh9bez68sfeq8kk98cg5r7h5h5fjyb5115d503q08sriwmbfzdc66qgqnk1xdljfr19lf5u1usnlw84khs5630b8g4dslcgqr0afz","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1cy2ddoJxfextIeLXow8rlg9pslo3cgXKc-PM6I4e9IA/","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":124082022,"idFeed":10098699539}]},{"id":24,"nombre":"Arde Madrid","urlEcommerce":"https://www.ardemadrid.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.17","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"7b7sy5uk94zo3xeixz2kc7f8k5ntqc00n2jz6o0otdwrhr3pkuuttk64lacjkm6i7r8dx57rxxdll0grh4g7pkre473puvdcsfcfq2vxocictzknums3w7dyd5ro2ojzq221je2xzn4expjel4emn6jl9hsvssrjfox2l7v98ahb5619yvybycgl3kr24at5179egyf4eto3b9mw6zfw0ywsas86vkufvzq8qkgfzbfq06q1lvjzm8wnbhxkcn4a","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/17VRhyIMWKF-YQxh8vs2tuANeYdovRx9dgjLLdR-oOFI/edit?gid=385996217#gid=385996217","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":125930592,"idFeed":10102582723}]},{"id":25,"nombre":"Didinsky","urlEcommerce":"https://didinsky.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"2syd9k8cj6cwzwvab81762gfs0v4f8s7br59yx30pgzyczevwkf7knl02bhnt1ccn71nbcxtdebuodtfo3o8hfolw0q5tmydhwznabup0mcz48ou5qai3hwp7d97eryw3iv17wi4mbl0ckpt1ip7362y7ch94u3gw5fguvu9rbfe70u504h3bm54wxihebgk42ansi2ef5sygx1sb0l3ez1qu7v19uuqics3yzpi8sod0buyu6jtf8ixaz1pcr5j","urlSpreadsheetInformes":"","usuarios":{"27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":660521868,"idFeed":660521868}]},{"id":43,"nombre":"OptiGarden","urlEcommerce":"https://optigarden.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"2vo5lc5p0k100idr37itjd34pnvmqxn6dop6nocwsh9w408lfckosazc2vuit9wdfek5gdk3osqzqlhonuc79qrlgzy36rz0vropn8664zyz2yzp27bt09uchmaj9whlvu6tcqjbwaeafdtws52sewszq2j30swj0zlawuf80p1ruzygvvjhwkhyfbu4oggzphnvifbsy1u6in79q2rt9b9du4cfzhkd1cy37xdu93l31zecngzq5njv0y117dp4","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1Rv_sXAUYMecz7P74ZA09RIlJCAez8tki8vfTEfJOjlE","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":571766325,"idFeed":10108519893}]},{"id":49,"nombre":"PruebasGShopping","urlEcommerce":"https://pruebasprestashop.demos-idento.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"s9jybl8lqzde3gh3f74j3iivycir4kqwa1tcpbg0w0m5yqh925hcgko5xhl0km63k2tre6l7m8qnxavldtiuowefehgh41x1id05nfj47whc66ctm7dt3trvqfago41tz555ujv2a8zo2dkokbk4afcyfoaxcrlk8csdyo6x61yltqk4w1560r04zmwrs2480274ofjxek2lumq5jowg1ie1apxktp3vq40k1m0ptfpavgbuvyu85i15mw8y7g4z","urlSpreadsheetInformes":"","usuarios":{"1":"dgarrido@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1234,"idFeed":0}]},{"id":52,"nombre":"Tuclaboral","urlEcommerce":"https://tuclaboral.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"3wa42xh0ltw9850lr9lyi73bnptq4677vnj9dc8ssunlps2fevlwbv6ypg0lydb67xk1ilq0mse6a2b2x73y2nl6a663m2uudbq8wb85pjhj9zowdjby6siw3qgbvqtuxbxvx09orsjry0luqvlxf5ktn0scr4uk274xdzfydn008zwcxeo11twggq0lbq7z1t0uyvjgau8hijmzfcjg6n858yioditovhlqa4tcaer9fhd7ac402su3z6i867u6","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/11JId3Fu6gKYWQ69VExl22cDHuf4IlHNQpcIec6SJE8o/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":704848541,"idFeed":10108651569}]},{"id":53,"nombre":"Kayaks Online","urlEcommerce":"https://www.kayaksonline.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"KOES","variableVariantes":"","versionPlugin":null,"tokenApi":"9os234p2buzvju6zttiyvgtjyvv1psmpe8hexk667uxwfsmq5b4o3faw0fih7fuegaknqxxua6o1jz21b4gznt8poe47rtyqsb6nqe64wlw5e79rx9ad8u549jhv21ib7vqdxeabqnkbx8h9mbznuumz5jcorg4zd6b4boxol1co3fejs20pmo828akjqsp5lbfula6y7z3ch2185rw1howjg4syq17uox5lm4otknz4yh9ao1quypeykwx1k8um","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1pdaFiEuUYPnBjs8sVc2unSaMgiPZ0EkA1Yyhz9AnhMk/edit?gid=62819329#gid=62819329","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":129210142,"idFeed":10333605647}]},{"id":54,"nombre":"Mercapool","urlEcommerce":"https://www.mercapool.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"twfis8urms33us7nj1miboqyac53xj36j31bcvmlj799byemavof0xuq7sk8s6mez4kzh1yal7z9bbmzqka1c8n9hf70bsvdz4ejgopp3vo4ffuf8d5flt5dnve0azpoe5fbix67ix0lxa4qwghtl5a7ykfv6vjxm9ygpxm3q8b1g2nzhlawkn59ulw2nqgauyl9we51lxap6ezi3nkly4n0pqipvu92y8lvx171i50o2s0emmouz0h1qom7f8k4","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1PeiBFkT-fbgo4mKeny9ZU2bsL2v9O_0bdsVe2JbzRgc/edit?gid=907154910#gid=907154910","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":241488213,"idFeed":10364836367}]},{"id":55,"nombre":"Catunambu","urlEcommerce":"https://tienda.catunambu.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"ddxt3t5eczl6hqs2ph43c4bl75rrybbxdf1vpnq8sp8vp22u5j2rek6g916l0g6t9ytp80ztntnuurggk3ydl25jl6fnwu2wazfylutztky20e8alya89lntjvojblkxezmxu90ygb6qzlckpxkwxzfcslm9knbcvsv21lz19rxgwmu1g37fxguoqoulfgn7x5z33qsiajevyby9c77e74r03m0vqcn9ejif1masoml1lhlkrld9xxoxm89lu6pm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1ihP1vTk_gBbT1jKLGhbs-qboo_unPKRcFA4u78Dh1KA","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":441244698,"idFeed":10401388925}]},{"id":56,"nombre":"Artisan Gallery ES","urlEcommerce":"https://www.artisangallery.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"6omv2z89svre6s6q7ztib5qdpjzn5ygbfc9dpl4ddmn8b63atgakc5wuy27oga9aeauy4u5hacurpm58rw89ju83hgxice8en7oexvbye1dl7cb2ls9pce6dtmn1wqtjim7ypz9s5nmadxoiyet46rhhbffhik8d8vnmexr8afd00mt4q443hn34zmt7sczapybhc2zi12i23ltuadimwb6aw0fk8cwrzp8f0azstz91o7i0v7uvq9z5gd28cas7","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1J7aXfYproC2uagRmrDtPSilQZASw1lBcrIv0sWH6e7E/edit?gid=373733719#gid=373733719","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":9099774,"idFeed":10385774083}]},{"id":57,"nombre":"Mercapool DE","urlEcommerce":"https://www.mercapool.de/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"DE","variableVariantes":"v","versionPlugin":null,"tokenApi":"j73zu83g0eylas2tyf85ge6ybhygdw7qoahuzux3fa0wlibd4u0r7dnli5ea7308v5wgq81oz11l3f0l457osrkf0v2o2fal45848uscqr6ni27zqgpbqpxc6kzairurjexbbm5nw5lwth8u4or1trsl5eo4tvx9ijbkmfocnje01s68jw8fofjw2ae5soiv8za702sk7daz8gtbkjct4d9p31kjljxad70senfdeywzhaeojbtzbae0r9qa1ioa","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1m-3Bt5k6NDAGWdPxv7-A6VE6Ohj1cbTSwsNCjQnBJyk/edit?gid=675402185#gid=675402185","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":551761032,"idFeed":10385774188}]},{"id":58,"nombre":"Sakata 3D","urlEcommerce":"https://www.sakata3d.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"v","versionPlugin":null,"tokenApi":"bzrqpzce3nnhft4n5lwdj0t52ev1ncak5qplwe3oswp3ksgtahc6fo4kozqfsrwzpuxjuygdt8j4alwkxr3v8qac59l6t14zinr1vmlrvhc9yu2b8xx37lr4t5u1o4jcfl7uxlwnrau5rrpcmv3dg3m31cd0w80w8qt53itvq4w88xlzezdx1nfl6zvd8x3m9qwm389p49jw1auvc9s32gd60k68ry0g6lpnhwb5zv5uyw2rw1jxvz4749zgjpfu","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1nhu5xHx3f1UkDBkHRIeakpz6ToAi8Z6xTVEZYnRDu4I/edit","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":643240830,"idFeed":10401406563}]},{"id":59,"nombre":"Soul Natura","urlEcommerce":"https://soulnatura.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.5","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"3ghigpoha8k8vqetpgvl6o7xum8j1sjc8hbx32w0htrqcdf2wed1zbozbpg0199a9fpiynrf1ecb1ypdmqbmg8szivj8yvs1aab4ql5xo8f1ig0hb5yh3ledfrxyp9x07hpq7tfdvwg5hufs49943e3ulj1k2c7em42wjs48ro6wzc31fbiomnpjnd7jpfls973iovvivtq05poin1udm0581alcrh34vev5ngyjo5vfmpumg5yylq49hk1xt1f0","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1dQB2g2zitZ8219XQjnGbHkV4bEmTC7eJwT4ZJx3vk44/edit?gid=357621296#gid=357621296","usuarios":{"32":"creyes@idento.es","35":"mascaso@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":284557124,"idFeed":10401388877}]},{"id":60,"nombre":"Biodere","urlEcommerce":"https://biodere.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"7.5.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"k8c5zft87tyxj6nxujdarrzoto9ag5i0wz0rb1pdf2p3zl2w2kc00twyqzdf2e3pa1qhibeny4fl0cn0aak20nc2y73ptbtpovde8pq566xh7x4ju80wvkwoze78xt9ezv9gd911fru8qvug44m7oq5zrjnjwcbfn0ybqt5mjncastpnx8opdtxu0g7qxkyce8z23m5djqprrpdmwgxe2qmd6m68x6edq6qb75lgexwsxthcsav97e3fp4wd5xow","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/106AgUA9tgBwZVNCp_l2Npx029lVE4lp_RL6kRwA6OYU/edit?gid=0#gid=0","usuarios":{"5":"mpsanchez@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":551855641,"idFeed":10385600000}]},{"id":61,"nombre":"Joyerias Sanchez","urlEcommerce":"https://www.joyeriasanchez.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.0.4","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"jtekp55freyvy2vbe20kd5cw126agvmbljk4hsoaro42ckxw8np91k2of4zmg6q1v0zzlt17mwfts5h25q63m5ypclztuz1jg3jghl536mlzzpfayb2j9vx4e215flk4jxr1m3c6nfd2wltt3hzf7fn5dc9g30uyvzyb16pfschd5gzm0wiwc82nh4jwfzbyp2la2oj04k2o9k3nsax92cob0q1kqbi998tus5sbk16tj10l7a5491hshm7y0six","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1zdU_qUqYr4v9c54pPvA5Lkiv12u6avrZX4ZjvJrAjrk/edit","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":7409456,"idFeed":10385786314}]},{"id":62,"nombre":"Ilutop","urlEcommerce":"https://www.ilutop.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.5","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"zqhuankep5zq992ug0v9ezlmwf4wgyqbinakzduc3u87gkh3hklg54alf1ny5wztm423xd71jgtiw8692y4t3vb463z8sz2o25m435qnq2ytfwwqp3odn1usra4hadzkk4ru6hyx7w6g9qdzooxanvqrxt5mtjvithxvowukgwps0r6l9p2vwzt6xqxz42b3t9y7zxcxn2ibamse9varzisrp98ssz47uiifj765pu8thsdjrr5a0yoijao231js","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1XawtXBBonb_7Rf1j-zzEfER8Fh0amBgxs86iuuM8Lps","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":118297897,"idFeed":10385613305}]},{"id":63,"nombre":"Ortoitaliana","urlEcommerce":"https://ortoitaliana.it/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"IT","variableVariantes":"v","versionPlugin":null,"tokenApi":"bsmyqr0su69hdrx3vmv76z9me4nv8ns3191xiv7go3gscfxlrpdl3zznfmcu8carqmle4tr2ioafh4l30fj6f5lzpqk4gce9y4byobby7l9ayaby1vawpfzrr1f0mj7c82dcl4lqt1nczmgtepxwwmqxj8e3u0o4yysjjhvt7uzo1wjhji993v78d63x7txbru5frj890cukkwczgmzmmk05yhvi7spqxkbur1w1na9lsc7c67reto5fg2f2uero","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bVgC7gooH3cNsSruqQLRPOP_QIwilLYPaD_ZvpgCyKs/edit?gid=2099155284#gid=2099155284","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":781760186,"idFeed":10388051967}]},{"id":64,"nombre":"El Rocío","urlEcommerce":"https://www.elrocio.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"ou1lu8j7pbw9x6xmg7bv17muwql57ph2jglftzn54ri3mjzykggot45htkwmeqgx9q3wmkgyose6s7780g2wyvkdrkb93iib7oejpupee9g2oak0stkeym01bikn7yhv4nttk8sthrdmrlmf9u4bc1n9ow0006g1vhuxsjb4eyoe925r6ilu4mfp3xi3zx3irvbjymoggk9y5n6abf16ulvhyf85s5b9xxp3ff6byj3miw30b3wx4l972ucg2r94","urlSpreadsheetInformes":"","usuarios":{"34":"lleyva@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":14060101,"idFeed":10388386906}]},{"id":65,"nombre":"El Rayo","urlEcommerce":"https://elrayo.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"mux8umf8v1f8sw21c8sji0yfxd3ghsycpxd02vi39ozxqp5qsc17jqisnj9ldmmiqi8q7ylj6mit0c54if4gwk4kry7omtoudwyqrzmjfb7hrl5wjyjanv62k2xgstzk6i2kbarpy65czcwg0ij5r65psk63i6u9muj0gv6vjqvdcqujwii7zq6o7sm457hn60xie1y7egbbvb5ifa8fkbl5x1q8mciz5setuddcbg0bl4xykrwzxdfpi2bbfl8u","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/15cR_CPuxADHIM5Z4H3OO5Yfnsf6Xzma0XetK38b_DZI/edit?gid=2108298972#gid=2108298972","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":113730391,"idFeed":10390765646}]},{"id":66,"nombre":"BPro Audio Store","urlEcommerce":"https://bproaudiostore.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"4f3cgm6z63su8j39qjfnekfsi1d5epcm81glzymmar78vjm6ye48jgampk1c97aqydtz2zbjh6lgksh7hr5nwnegtzixvh93xmhhq9mrs9ikjdilc8ihtwhbqh5095eq6gqm9q7wg8cc0v0494b5hlegme3yzxqq9fl7zzxrrbpmrsgag0zq3128z31c0c32teqg2frp2mmjut223vrua8dayfkpld7ih5bkqve77ybavbji2b5ij6i2rxrlc8ib","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/12-lu9cbMXaNJVx259GCo2SfkmY9l6wPSNcaiD6KbVmE/edit?gid=1674336303#gid=1674336303","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":126150908,"idFeed":10394642426}]},{"id":67,"nombre":"Vecosolar","urlEcommerce":"https://vecosolar.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.7","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"v","versionPlugin":null,"tokenApi":"vxl7uhp2bhds0z3qnske1guzhzsf8vjotylgwnyihz21gdeyr676nlyccq2qdlqa1mkuy00ih20szdx0ypgpq697k0lftx11nugb1dkaxhphltsduq7olytg8t81g9g0hyzdep6hxraxaakecenusb91p36owxvf2o7w3xvo87fm8m2foeigm5rjibdydfg45vp558a3jig4zb6hp6164ygyubfy4lez1pw0hhepgup0ofk9ds7pf0biunl7w11r","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1lxuvoXyyDx6_UEvPG5DkKlAC-SZTm3xfaQYWieuKHx8/edit?gid=1319728250#gid=1319728250","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":795141877,"idFeed":10401387059}]},{"id":69,"nombre":"Taine","urlEcommerce":"https://www.taine.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"3ll1u9t8l0aciy6v0zvtl1zcd3slw2pi0gurajwbxgnq1j3in12s195ieu16a5zxwifg14us6m8x5phdd68xesh8njqdexo6yzejgeiy6tjhv5do3dzx0xztvskrjnnnx1qoupb1saf0jokq7qpvotrlxhr180pyqdzl8wurm2mp2xnlka4rsmqxakcpg96sv2vabefkesod978kk82zbwt1mjeboxuqlf1wnpaysrlianhskr1odnjbguotc3c1","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1MWiFpPGn1ZHbS4LnnB3IZSJUu092tCr2wibbbxq9rp0/edit?gid=406095437#gid=406095437","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":238095762,"idFeed":10398331597}]},{"id":70,"nombre":"Locos por las Piscinas","urlEcommerce":"https://locosporlaspiscinas.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"qayfzvuf1e1g8iyu935yq6l5qywmmwjf69a3ffxzp66k87fplslxm28u9ef01typ86wfqcr05s7zass6qwxaf5hi4w52zi1xvq45mlgxk8lh2bqaanj4vuapevfbm0pe52lmxum3y5d2pedgzauma9q5b9x84t5mjpsk0hqu1wii5p3aflhdsggh3mq9l1xmv41wufsib4w9te3c7xrhb3nd71biu9zruljobxzcxwp80ry8pyznvb55qt5nqf6l","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1mY1VeblNY9ti8mJEp9Tzae2zN0FeLeRfHokHCe4WswY","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":359082605,"idFeed":10333616918}]},{"id":72,"nombre":"Solo Camion","urlEcommerce":"https://solocamionrepuestos.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"a7cap40c3u1s0pb6qhq1jc8bx4czc89d37rjovk3tvk2lzjbwc3aj4ehdwyb15swh79degv3tr5t4gmu9hq4f1q2hskqm5jxb2fboewh5wzwxdh3otzda8ydj7roopdynakkkggqdk7thz460vvkrdbaodqerqbmj1bgdlkxmj7u1f85zvy2li3iqql6ato9tb0xw92ie89277a4b7nocbi6ugy8ep5swl4xzgixhuyvzi6c12fw9b5kup0zxe1t","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/19yprZmzyQjQdOCPYJQP8bJRBFzESM-sE7TzKNwIWG9o/edit?gid=603332496#gid=603332496","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":111111,"idFeed":0}]},{"id":73,"nombre":"Whim Cycling","urlEcommerce":"https://whimcycling.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"acapw134ouzgrldr8sgs3ulgsv5lcvtefwpk7nck20ao35aqi0vi1t0jeh2a3dxaz6t044fbarprjrb1bc4r1oi1vj20v3e35ww6ceacbb02x70p2y1mrik3sj7jtbiunohvp4n7n5113vw0mncvtd19gy44g17zfp9cl2d8bby4c38z8pj7bk7z7uiwuwp44oerasfad3wxfej17mjzbjzo39vqiiks4hf78t1qt26p9kgz7f699jo6ikzvbe7d","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/154jnJsicVV9ybeIqWbtGiQp3N4l4bA3DOuFztgYbkLc/edit?gid=200368787#gid=200368787","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1111111,"idFeed":0}]},{"id":74,"nombre":"Artisan Gallery FR","urlEcommerce":"https://www.artisangallery.fr/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"effw83gi61ah37s1n4frhl2mi7swrucj6p6un91m2x0m0npf12ce7rp88o0ke7ns73k9mk0aqm8uzc6dcgb8wyjw6dq6ru9upzqf7wquxbvqbjz4i3q2h1c6gf1emb2mxdj2rsku1d99ecz3ge3jjf9rph5i6out5kp586u8qas5p4iaz6wddffdqv9zwc6u9ret6dbsxm4hbhytd8asvaecy2bramnlxrjg0f59z6tt8wnu3u8zrtvhlt2f1ijl","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1iCjcFEz73Etl6M_8Dse1xGeLaPVRA2hAULM1KYnED7Y/edit?gid=849717025#gid=849717025","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":111222333,"idFeed":0}]},{"id":75,"nombre":"Matismo","urlEcommerce":"https://www.motorespersianas.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"58t5mmnxa26r2oatdh00x3kkztdoftfwb9bfuknp2m3rdtm27l4dba8al9lib3u8wd7lb5630cidirxeco9w4r569ay1cpwjqlo78m98n9j3us4rvx8ohdjzbp5bg6hjxthr1ky3dx8mkswi34pn8d49tfnwdszs2vcdghmm5sscrabcinai0fv43na4337sbcywvynl46vsyo8a3d9vao5bzjurpc2geak649tr7vxhxw0w0fe47yjbpp7eekui","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1-hlUZq9Bg3PN7w4xFMW5hvdsDiRit3BJMelEVv1bGpU/","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":109944519,"idFeed":10424182793}]},{"id":85,"nombre":"Medical Europa","urlEcommerce":"https://medicaleuropa.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.0.4","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"z41u5ncxk72f5lph42vyr55x2tgmmfhq6pcvb2pupuyqyfho2kote7tp8ki7ehf2a42c6vq4m7idqz2twuheu4jntxbrwb1jkpripdlt9cxtz0g46h79a19zv5cgan3uypq8r1qc1hxrttyxpja4gnihl4f5q2h0ffe84j53s4e8xjf57bavubcejg3mm5oetzjngdhr6zvy6lylq0dab1yk1mxc9jxvscxa74v26n6o6usgzi2ral5hrtwhsqjb","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1h7sJRuaGdBAZP4_gyJMqinzhCKcxygoGwYUjuAoERBE/edit?gid=2071547258#gid=2071547258","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":766078283,"idFeed":10429194045}]},{"id":87,"nombre":"Ruster","urlEcommerce":"https://rusterfitness.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"6yv5hrqjx5ttb8hs3jb3pp3x89j2kqdn34r4a87i0j6qaall7adg137ya6m7nrga9i4q30nhqqzd3xlr3ny4ehyzhtpywlfusx8mq5rmh0fwlldc7zwb9x6ecm67ffqa1zaym7pu9ms1brhx51ffktsvdnxlu9gfg16146ilt5csnp3l39y9z38h472q8vb2kjpwewl1u8y1dzhfrlbrjhbc1ej1e8kvh1vrjjxyeo9yssak52hbhsbsggp6h6ey","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bhQSDyfYz1Qm8YwcUHxQp3XZ_vzszZCvhbDijqNuz64/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1037770266,"idFeed":10444650309}]},{"id":88,"nombre":"Promoshark","urlEcommerce":"https://promoshark.eu/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"-","versionPlugin":null,"tokenApi":"xs4b5ks7u2hxu0md1i1mi1z6job7fyve7yprgkt1ncucmo8qsj31yi179dwydgkgf9f37n2nyqc0h41g4abm60zuj1meqf0jldytxk6r44clsyq8opssim7spkhiaqgdpakqbfp4dyg57n44iazleo4dbst9zka5l7nionhhf44zzp18zycqm76ozq79m68ag4sv8drmy4gyn7k4r62qd904svd2wn009x5v9hu54tc420krvm39flp8iz3wuc0d","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1MgK2LDqvIhBL8krXZJmfeUg2GgzrFsgt0HncHEzdFeg","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1146551694,"idFeed":10445121600}]},{"id":92,"nombre":"bodegas duquesa","urlEcommerce":"https://ecastillo.demos-idento.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"8.1.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"19a76akpcboc0ek5l404qfocf7dstomwysamkxdy310dd571qqkxnm1cneei8awcg38bsx0xb38ksbjip4egu03no2yw7htsifmd0z2htkfh3lzkm39izl12ei9aognxtkllqmzes7mcqg5lg8lg7xytr8qs0698llu0i21hy3oejtf43ptt0upufkgz4kxlhux0gbyo7irqt2eg5hd9o8i48yon4xianndlqjhvlvzjvdx5obzw3v5ju913vmnm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1u3IfQqa-tzAbwPwtfJVLB3ofF-6j1V4qf6xtHQHS3lc/","usuarios":{"36":"pmoreno@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":123456789,"idFeed":12345678}]},{"id":93,"nombre":"Maria Lunarillos","urlEcommerce":"https://www.marialunarillos.com/","tipoEcommerce":"MAGENTO","versionEcommerce":"","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"korwdsh1ji1jxsj22j8him3krxiqzj86wbn5nv7rpqdofipg2ff3za1q98sxtyvu40zosnseqguh0o42xiv0hcxi7j5ebyifm5rumtl075puyb9jrw5ab7l4rx3ixpddylj4wacy567f34f1z9pb9t07ulgwxo2hum1m5g37sjf3faztdqlb5a9e8ojkwkngmoajnajeqqojr97ksqqfomwtqwpa5ro3sc4w4imue8l6sanskq9s31bjye8w18jf","urlSpreadsheetInformes":"","usuarios":{"34":"lleyva@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":331231402,"idFeed":10089870885}]}]"
  ]
]
GET https://gshopping.idento.es/gshoppingApp/api/gshopping/consultas/analitica
Request options
[
  "base_uri" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/"
  "headers" => [
    "Authorization" => "08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA"
    "Content-Type" => "application/json"
  ]
]
Response 200
[
  "info" => [
    "header_size" => 123
    "request_size" => 469
    "total_time" => 0.014822
    "namelookup_time" => 2.8E-5
    "connect_time" => 2.8E-5
    "pretransfer_time" => 0.000117
    "size_download" => 41117.0
    "speed_download" => 2936928.0
    "starttransfer_time" => 0.014381
    "primary_ip" => "103.23.60.149"
    "primary_port" => 443
    "local_ip" => "103.23.60.149"
    "local_port" => 55946
    "http_version" => 3
    "protocol" => 2
    "scheme" => "HTTPS"
    "appconnect_time_us" => 28
    "connect_time_us" => 28
    "namelookup_time_us" => 28
    "pretransfer_time_us" => 117
    "starttransfer_time_us" => 14381
    "total_time_us" => 14822
    "start_time" => 1742201284.7015
    "original_url" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/consultas/analitica"
    "pause_handler" => Closure(float $duration) {#484
      class: "Symfony\Component\HttpClient\Response\CurlResponse"
      use: {
        $ch: CurlHandle {#505 …}
        $multi: Symfony\Component\HttpClient\Internal\CurlClientState {#391 …}
        $execCounter: -9223372036854775802
      }
    }
    "debug" => """
      * Found bundle for host gshopping.idento.es: 0x55d3eab00b60 [can multiplex]\n
      * Re-using existing connection! (#0) with host gshopping.idento.es\n
      * Connected to gshopping.idento.es (103.23.60.149) port 443 (#0)\n
      * Using Stream ID: 3 (easy handle 0x55d3eaa5fc40)\n
      > GET /gshoppingApp/api/gshopping/consultas/analitica HTTP/2\r\n
      Host: gshopping.idento.es\r\n
      authorization: 08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA\r\n
      content-type: application/json\r\n
      accept: */*\r\n
      user-agent: Symfony HttpClient (Curl)\r\n
      accept-encoding: gzip\r\n
      \r\n
      < HTTP/2 200 \r\n
      < server: nginx\r\n
      < date: Mon, 17 Mar 2025 08:48:04 GMT\r\n
      < content-type: application/json\r\n
      < x-powered-by: PleskLin\r\n
      < \r\n
      """
  ]
  "response_headers" => [
    "HTTP/2 200 "
    "server: nginx"
    "date: Mon, 17 Mar 2025 08:48:04 GMT"
    "content-type: application/json"
    "x-powered-by: PleskLin"
  ]
  "response_content" => [
    "[{"id":20,"nombre":"WC Categorías de productos más vendidos (últimos 5 meses)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.1.1","0","7.1.0"],"consulta":"SELECT oi.order_id, oi.order_item_name, oi.order_item_id, opl.product_id, COALESCE((SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id), 0) AS ingreso_neto, COALESCE((SELECT MAX(CASE WHEN oim.meta_key = '_qty' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id), 0) AS cantidad, COALESCE((SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id), 0) AS ingreso_neto, COALESCE(((SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id) + (SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal_tax' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id)), 0) AS ingreso_total, GROUP_CONCAT(DISTINCT t.name SEPARATOR ', ') AS categorias FROM prefijoTabla/wc_order_stats os INNER JOIN prefijoTabla/woocommerce_order_items oi ON (os.order_id = oi.order_id) INNER JOIN prefijoTabla/woocommerce_order_itemmeta oim ON (oi.order_item_id = oim.order_item_id) INNER JOIN BZmAVqcWX_wc_order_product_lookup opl ON (oi.order_item_id = opl.order_item_id) LEFT JOIN prefijoTabla/term_relationships tr ON (opl.product_id = tr.object_id) LEFT JOIN prefijoTabla/term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) LEFT JOIN prefijoTabla/terms t ON (tt.term_id = t.term_id) WHERE os.date_created >= DATE_SUB(NOW(), INTERVAL 5 MONTH) AND tt.taxonomy = 'product_cat' AND os.status = 'wc-completed' GROUP BY oi.order_id, oi.order_item_id LIMIT 15;"},{"id":26,"nombre":"WC Descarga últimos 15 pedidos","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.2.1","8.1.1","7.5.1","1"],"consulta":"SELECT os.order_id AS id_pedido, COALESCE(os.total_sales, '-') AS total, COALESCE(os.status, '-') AS estado, COALESCE(p.post_name, '-') AS referencia, COALESCE(cl.customer_id, '-') AS id_cliente, COALESCE((SELECT MAX(CASE WHEN pm.meta_key = '_payment_method_title' THEN pm.meta_value END) FROM prefijoTabla/postmeta AS pm WHERE pm.post_id = os.order_id), '-') AS forma_pago, COALESCE((SELECT MAX(CASE WHEN pm.meta_key = '_billing_country' THEN pm.meta_value END) FROM prefijoTabla/postmeta AS pm WHERE pm.post_id = os.order_id), '-') AS ciudad, COALESCE(MONTH(os.date_created), '-') AS mes, COALESCE(YEAR(os.date_created), '-') AS año, COALESCE(cl.date_registered, '-') AS fecha_registro, COALESCE(IF(DATEDIFF(NOW(), cl.date_registered) < 7, 1, 0), '-') AS usuario_creado_en_ultima_semana FROM prefijoTabla/wc_order_stats AS os INNER JOIN prefijoTabla/wc_customer_lookup AS cl ON (os.customer_id = cl.customer_id) INNER JOIN prefijoTabla/posts AS p ON (os.order_id = p.ID) GROUP BY os.order_id LIMIT 15;"},{"id":27,"nombre":"PS Descarga últimos 15 pedidos","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["8.0.4","1.7.6.7","1.7.6.3","1.7.8.3","1.6.1.17","1.6.1.9","4","8.1.5"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF(DATEDIFF(NOW(), c.date_add) <= 7, 1, 0) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(pa.city, '-') AS 'Entrega/Ciudad', COALESCE(cl.name, '-') AS 'Entrega/País', COALESCE(o.total_paid, 0) AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Año' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang ORDER BY o.id_order DESC LIMIT 15;"},{"id":28,"nombre":"PS Listado de productos más vendidos (últimos 5 meses)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.7.3","1.7.7.1","1.7.6.7","8.0.4","1.7.6.3","0","1.6.1.9","8.1.5","1.6.1.17"],"consulta":"SELECT p.id_product AS 'ID Producto', COALESCE(pl.name, '-') AS 'Nombre producto', COALESCE(SUM(od.product_quantity), 0) AS 'Unidades vendidas (cantidad)', COALESCE(SUM(od.product_quantity * od.total_price_tax_incl), 0) AS 'Ingresos totales', COALESCE(SUM(od.product_quantity * od.total_price_tax_excl), 0) AS 'Ingreso neto' FROM prefijoTabla/orders o INNER JOIN prefijoTabla/order_detail od ON o.id_order = od.id_order INNER JOIN prefijoTabla/product p ON od.product_id = p.id_product LEFT JOIN prefijoTabla/product_lang pl ON p.id_product = pl.id_product WHERE o.date_add >= DATE_ADD(CURDATE(), INTERVAL -5 MONTH) GROUP BY p.id_product, pl.name ORDER BY SUM(od.product_quantity * od.total_price_tax_incl) DESC LIMIT 15;"},{"id":29,"nombre":"WC Listado de productos más vendidos  (max 15)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.2.1","8.1.1","7.5.1","1"],"consulta":"SELECT oi.order_id, COALESCE(oi.order_item_name, '-') AS order_item_name, oi.order_item_id, COALESCE(opl.product_id, '-') AS product_id, COALESCE((SELECT MAX(CASE WHEN oim.meta_key = '_qty' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id), '-') AS cantidad, COALESCE((SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id), '-') AS ingreso_neto, COALESCE(((SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id) + (SELECT MAX(CASE WHEN oim.meta_key = '_line_subtotal_tax' THEN oim.meta_value END) FROM prefijoTabla/woocommerce_order_itemmeta AS oim WHERE oi.order_item_id = oim.order_item_id)), '-') AS ingreso_total FROM prefijoTabla/wc_order_stats os INNER JOIN prefijoTabla/woocommerce_order_items oi ON (os.order_id = oi.order_id) INNER JOIN prefijoTabla/woocommerce_order_itemmeta oim ON (oi.order_item_id = oim.order_item_id) INNER JOIN prefijoTabla/wc_order_product_lookup opl ON (oi.order_item_id = opl.order_item_id) LEFT JOIN prefijoTabla/term_relationships tr ON (opl.product_id = tr.object_id) LEFT JOIN prefijoTabla/term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) LEFT JOIN prefijoTabla/terms t ON (tt.term_id = t.term_id) WHERE os.date_created >= DATE_SUB(NOW(), INTERVAL 5 MONTH) AND tt.taxonomy = 'product_cat' AND os.status = 'wc-completed' GROUP BY oi.order_id, order_item_id LIMIT 15;"},{"id":34,"nombre":"PS Marcas de productos más vendidos","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.7.3","1.7.7.1","","1.7.6.7","8.0.4","1.6.1.24","1.7.6.3","1.6.1.9","8.1.5"],"consulta":"SELECT m.name AS 'Marca', COALESCE(SUM(od.product_quantity), 0) AS 'Unidades vendidas (cantidad)', COALESCE(SUM(od.product_quantity * od.total_price_tax_incl), 0) AS 'Ingresos totales', COALESCE(SUM(od.product_quantity * (od.total_price_tax_excl / (1 + o.conversion_rate))), 0) AS 'Ingreso neto (sin IVA y envío)' FROM prefijoTabla/orders o INNER JOIN prefijoTabla/order_detail od ON o.id_order = od.id_order INNER JOIN prefijoTabla/product p ON od.product_id = p.id_product INNER JOIN prefijoTabla/manufacturer m ON p.id_manufacturer = m.id_manufacturer WHERE o.date_add >= DATE_SUB(NOW(), INTERVAL 5 MONTH) AND o.current_state IN (5, 6) GROUP BY m.name ORDER BY 'Unidades vendidas (cantidad)' DESC LIMIT 15;"},{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":39,"nombre":"WC Descarga pedidos 2024 (máx 7000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.3","9.3.1","0","9.0.2","8.9.2"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, COALESCE(CASE WHEN um1.meta_value IS NULL THEN 'Yes' ELSE 'No' END, '-') AS NuevoCliente, COALESCE(p.post_author, '-') AS idCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm2.meta_key = '_order_total' THEN pm2.meta_value END), 'es_ES'), '-') AS Total, '-' AS ColumnaVacia, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS year FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_shipping_country' LEFT JOIN prefijoTabla/postmeta pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_order_total' LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND DATE(p.post_date) >= '2024-01-01' GROUP BY p.ID, p.post_title, p.post_author, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},{"id":40,"nombre":"WC Descarga pedidos 9 meses (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_customer_user' THEN pm1.meta_value END), '-') AS cliente_id, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END), 2, 'es_ES'), '-') AS Total, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 9 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},{"id":41,"nombre":"WC Consulta identificación Cliente nuevo-recurrente","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT COALESCE(meta_value, '-') AS id_cliente, COALESCE(COUNT(post_id), 0) AS numero_pedidos, CASE WHEN COALESCE(COUNT(post_id), 0) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/postmeta WHERE meta_key = '_customer_user' GROUP BY meta_value ORDER BY numero_pedidos DESC LIMIT 10000;"},{"id":43,"nombre":"Últimos pedidos 400 días máximo10000 Prestashop","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":[],"consulta":"SELECT o.id_order AS 'ID pedido', o.reference AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as 'Nuevo cliente', o.id_customer AS 'ID cliente', cl.name as 'Entrega/Pais', FORMAT(o.total_paid,2,'es_ES') AS 'Total', o.payment AS 'Forma de Pago', os.name AS 'Estado', o.date_add AS 'Fecha', MONTH(o.date_add) AS 'Mes', YEAR(o.date_add) AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang=o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang AND DATE(o.date_add)>= DATE_SUB(CURDATE(), INTERVAL 400 DAY) order by o.date_add asc LIMIT 50000;"},{"id":44,"nombre":"Últimos pedidos 400 días Woocommerce Limit 10000","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[],"consulta":"SELECT p.ID as idPedido, p.post_title as Referencia, CASE WHEN um1.meta_value IS NULL THEN 'Yes' ELSE 'No' END as NuevoCliente, p.post_author as idCliente, MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END) as paisEntrega, FORMAT(MAX(CASE WHEN pm2.meta_key = '_order_total' THEN pm2.meta_value END),'es_ES') as Total, '-', p.post_status as estadoPedido, p.post_date as fechaPedido, MONTH(p.post_date) as mesPedido, YEAR(p.post_date) as añoPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_shipping_country' LEFT JOIN prefijoTabla/postmeta pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_order_total' LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND DATE(p.post_date)>= DATE_SUB(CURDATE(), INTERVAL 400 DAY) GROUP BY p.ID, p.post_title, p.post_author, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 50000;"},{"id":45,"nombre":"Últimos pedidos 90 días prestashop LIMIT 10000","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":[],"consulta":"SELECT o.id_order AS 'ID pedido', o.reference AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as 'Nuevo cliente', o.id_customer AS 'ID cliente', cl.name as 'Entrega/Pais', FORMAT(o.total_paid,2,'es_ES') AS 'Total', o.payment AS 'Forma de Pago', os.name AS 'Estado', o.date_add AS 'Fecha', MONTH(o.date_add) AS 'Mes', YEAR(o.date_add) AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang=o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang AND DATE(o.date_add)>= DATE_SUB(CURDATE(), INTERVAL 90 DAY) order by o.date_add asc LIMIT 50000;"},{"id":46,"nombre":"Últimos pedidos 90 días woocommerce LIMIT 10000","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[],"consulta":"SELECT p.ID as idPedido, p.post_title as Referencia, CASE WHEN um1.meta_value IS NULL THEN 'Yes' ELSE 'No' END as NuevoCliente, p.post_author as idCliente, MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END) as paisEntrega, FORMAT(MAX(CASE WHEN pm2.meta_key = '_order_total' THEN pm2.meta_value END),'es_ES') as Total, '-', p.post_status as estadoPedido, p.post_date as fechaPedido, MONTH(p.post_date) as mesPedido, YEAR(p.post_date) as añoPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_shipping_country' LEFT JOIN prefijoTabla/postmeta pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_order_total' LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND DATE(p.post_date)>= DATE_SUB(CURDATE(), INTERVAL 90 DAY) GROUP BY p.ID, p.post_title, p.post_author, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 50000;"},{"id":47,"nombre":"Pedidos desde el 1 de Enero de 2023 Prestashop","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.8.11"],"consulta":"SELECT o.id_order AS 'ID pedido', o.reference AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as 'Nuevo cliente', o.id_customer AS 'ID cliente', cl.name as 'Entrega/Pais', FORMAT(o.total_paid,2,'es_ES') AS 'Total', o.payment AS 'Forma de Pago', os.name AS 'Estado', o.date_add AS 'Fecha', MONTH(o.date_add) AS 'Mes', YEAR(o.date_add) AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang=o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang AND DATE(o.date_add)>='2023-01-01' order by o.date_add asc LIMIT 50000;"},{"id":48,"nombre":"WC Descarga pedidos desde 1 enero de 2023 (límite 5000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.1.1","9.4.2","9.3.3","9.4.1"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, (CASE WHEN (SELECT COUNT(*) FROM prefijoTabla/posts o LEFT JOIN prefijoTabla/postmeta pm ON o.ID = pm.post_id WHERE o.post_type = 'shop_order' AND pm.meta_key = '_customer_user' AND pm.meta_value = pm1.meta_value) = 1 THEN 'SI' ELSE 'NO' END) AS NuevoCliente, COALESCE(pm1.meta_value, '-') AS cliente_id, COALESCE(pm2.meta_value, '-') AS paisEntrega, COALESCE(FORMAT(pm3.meta_value, 2, 'es_ES'), '-') AS Total, '-' AS ColumnaVacia, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_customer_user' LEFT JOIN prefijoTabla/postmeta pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_shipping_country' LEFT JOIN prefijoTabla/postmeta pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_order_total' WHERE p.post_type = 'shop_order' AND DATE(p.post_date) >= '2023-01-01' AND DATE(p.post_date) < '2024-01-01' ORDER BY p.post_date ASC LIMIT 5000;"},{"id":49,"nombre":"Consulta con WP_ORDERS obtener Clientes Nuevos WooCommerce","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[],"consulta":"SELECT customer_id as id_cliente, COUNT(id) as numero_pedidos, CASE WHEN COUNT(id) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/wc_orders GROUP BY customer_id ORDER BY numero_pedidos DESC LIMIT 10000;"},{"id":50,"nombre":"Consulta WP_ORDERS obtener Pedidos WooCommerce","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[],"consulta":"SELECT orders.id AS idPedido, meta_value AS Referencia, '-' AS NuevoCliente, orders.customer_id AS cliente_id, address.country AS paisEntrega, FORMAT(orders.total_amount, 'es_ES') AS Total, orders.status AS estadoPedido, orders.date_created_gmt AS fechaPedido, MONTH(orders.date_created_gmt) AS mesPedido, YEAR(orders.date_created_gmt) AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta_key = \"_order_number_formatted\" LIMIT 5000;"},{"id":51,"nombre":"Consulta nuevos pedidos 1 copy","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[],"consulta":"SELECT p.ID as idPedido, p.post_title as Referencia,'-' as NuevoCliente, CASE WHEN pm1.meta_key='_customer_user' THEN pm1.meta_value END as cliente_id, MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END) as paisEntrega, FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END),'es_ES') as Total, p.post_status as estadoPedido, p.post_date as fechaPedido, MONTH(p.post_date) as mesPedido, YEAR(p.post_date) as yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},{"id":52,"nombre":"WC Descarga pedidos 3 meses (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.3.1","9.0.2","7.5.1","9.4.3","9.1.4","9.4.2","9.1.2","9.2.3","9.2.1","9.3.3","8.2.1"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_customer_user' THEN pm1.meta_value END), 'No viene cliente id') AS cliente_id, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END), 2, 'es_ES'), '-') AS Total, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},{"id":54,"nombre":"WP_ORDERS  obtener pedidos woocommerce","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":[""],"consulta":"SELECT orders.id AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM wp_wc_orders orders LEFT JOIN wp_wc_order_addresses address ON orders.id = address.order_id LEFT JOIN wp_wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" LIMIT 100;"},{"id":55,"nombre":"WC (versión 2 wp_orders) Consulta cliente nuevo-recurrente (limite 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT COALESCE(customer_id, '-') AS id_cliente, COALESCE(COUNT(id), '-') AS numero_pedidos, CASE WHEN COUNT(id) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/wc_orders GROUP BY customer_id ORDER BY numero_pedidos DESC LIMIT 10000;"},{"id":56,"nombre":"WC (versión 2 wp_orders) Descarga pedidos desde 1 julio 2024 (máx 7000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT DISTINCT COALESCE(orders.id, '-') AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 2, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" WHERE YEAR(orders.date_created_gmt) >= 2024 AND orders.date_created_gmt >= '2024-07-01'  AND orders.total_amount > 0 LIMIT 7000;"},{"id":57,"nombre":"PS Descarga pedidos con fecha personalizada (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', FORMAT(COALESCE(o.total_paid, 0), 2, 'es_ES') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-30' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":58,"nombre":"PS Descarga pedidos 2 meses (límite 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.6.3","1.7.8.9","1.7.8.7","1.6.1.9","8.1.2","1.7.8.11","1.7.8.3","8.0.4","1.6.1.24","1.6.1.17","1.7.7.3","1.7.7.2","1.7.7.1","1.7.6.7"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= DATE_SUB(NOW(), INTERVAL 2 MONTH) ORDER BY o.date_add ASC LIMIT 10000;"},{"id":59,"nombre":"WooCommerce Versión 2, Pedidos de 3 meses","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.1.1","9.3.3"],"consulta":"SELECT DISTINCT COALESCE(orders.id, '-') AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 2, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" WHERE orders.date_created_gmt >= DATE_SUB(CURRENT_DATE, INTERVAL 3 MONTH) AND orders.total_amount > 0 LIMIT 7000;"},{"id":60,"nombre":"Consulta pedidos telefono  15 Octubre 2024","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', o.id_customer AS 'ID cliente', FORMAT(o.total_paid, 2, 'es_ES') AS 'Total', COALESCE(NULLIF(a.phone, ''), '-') AS 'telefono', COALESCE(NULLIF(a.phone_mobile, ''), '-') AS 'telefono_movil', COALESCE(os.name, '-') AS 'Estado', o.date_add AS 'Fecha' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address WHERE o.date_add >= '2024-10-15' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":61,"nombre":"PS Descarga pedidos desde 1 Enero 2024 (Max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-01-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":62,"nombre":"Consutla pedidos telefono Enero 2024","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', o.id_customer AS 'ID cliente', FORMAT(o.total_paid, 2, 'es_ES') AS 'Total', COALESCE(NULLIF(a.phone, ''), '-') AS 'telefono', COALESCE(NULLIF(a.phone_mobile, ''), '-') AS 'telefono_movil', COALESCE(os.name, '-') AS 'Estado', o.date_add AS 'Fecha' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address WHERE o.date_add >= '2024-01-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":63,"nombre":"PS DEBUG Consulta pedidos email y telefono SHA256 Enero 2024","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":[],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', o.id_customer AS 'ID cliente', FORMAT(o.total_paid, 2, 'es_ES') AS 'Total', COALESCE(CASE WHEN a.phone IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone) LIKE '+%' THEN TRIM(a.phone) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) END, '-') AS 'telefono', COALESCE(NULLIF(SHA2(CASE WHEN a.phone IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone) LIKE '+%' THEN TRIM(a.phone) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) END, 256), ''), '-') AS 'telefono_hash',COALESCE(CASE WHEN a.phone_mobile IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone_mobile) LIKE '+%' THEN TRIM(a.phone_mobile) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) END, '-') AS 'telefono_movil', COALESCE(NULLIF(SHA2(CASE WHEN a.phone_mobile IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone_mobile) LIKE '+%' THEN TRIM(a.phone_mobile) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) END, 256), ''), '-') AS 'telefono_movil_hash',COALESCE(NULLIF(SHA2(cu.email, 256), ''), '-') AS 'email', COALESCE(os.name, '-') AS 'Estado', o.date_add AS 'Fecha' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/customer cu ON cu.id_customer = o.id_customer WHERE o.date_add >= '2024-01-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":64,"nombre":"PS Consulta pedidos email y telefono SHA256 Enero 2024","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":[],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', o.id_customer AS 'ID cliente', FORMAT(o.total_paid, 2, 'es_ES') AS 'Total', COALESCE(NULLIF(SHA2(CASE WHEN a.phone IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone) LIKE '+%' THEN TRIM(a.phone) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone, ' ', ''), '(', ''), ')', ''), '-', ''))) END, 256), ''), '-') AS 'telefono_hash', COALESCE(NULLIF(SHA2(CASE WHEN a.phone_mobile IS NULL OR LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) < 9 THEN '-' WHEN TRIM(a.phone_mobile) LIKE '+%' THEN TRIM(a.phone_mobile) WHEN LENGTH(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) = 9 THEN CONCAT('+34', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) ELSE CONCAT('+', TRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.phone_mobile, ' ', ''), '(', ''), ')', ''), '-', ''))) END, 256), ''), '-') AS 'telefono_movil_hash',COALESCE(NULLIF(SHA2(cu.email, 256), ''), '-') AS 'email', COALESCE(os.name, '-') AS 'Estado', o.date_add AS 'Fecha' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/customer cu ON cu.id_customer = o.id_customer WHERE o.date_add >= '2024-01-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":65,"nombre":"PS DEBUG -SIN TRATA-TELEFONOS Consulta pedidos email y telefono SHA256 Enero 2024","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["","1.7.7.1"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', o.id_customer AS 'ID cliente', FORMAT(o.total_paid, 2, 'es_ES') AS 'Total', COALESCE(NULLIF(TRIM(REPLACE(REPLACE(REPLACE(a.phone, '(', ''), ')', ''), '-', '')), ''), '-') AS 'telefono', COALESCE(NULLIF(TRIM(REPLACE(REPLACE(REPLACE(a.phone_mobile, '(', ''), ')', ''), '-', '')), ''), '-') AS 'telefono_movil', COALESCE(NULLIF(SHA2(cu.email, 256), ''), '-') AS 'email', COALESCE(os.name, '-') AS 'Estado', o.date_add AS 'Fecha' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/customer cu ON cu.id_customer = o.id_customer WHERE o.date_add >= '2024-01-01' ORDER BY o.date_add ASC LIMIT 10000;"},{"id":66,"nombre":"Pedidos PS Implantación OrtoItalia","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.7.1"],"consulta":"SELECT 'sp_venta' AS Tipo, SHA2(CASE WHEN COALESCE(a.phone_mobile, '') <> '' THEN CASE WHEN TRIM(a.phone_mobile) LIKE '+%' THEN TRIM(REGEXP_REPLACE(a.phone_mobile, '[^0-9+]', '')) ELSE CONCAT('+39', TRIM(REGEXP_REPLACE(a.phone_mobile, '[^0-9]', ''))) END WHEN COALESCE(a.phone, '') <> '' THEN CASE WHEN TRIM(a.phone) LIKE '+%' THEN TRIM(REGEXP_REPLACE(a.phone, '[^0-9+]', '')) ELSE CONCAT('+39', TRIM(REGEXP_REPLACE(a.phone, '[^0-9]', ''))) END ELSE '' END, 256) AS Telefono_Hash, SHA2(c.email, 256) AS Email_Hash, DATE_FORMAT(o.date_add, '%d/%m/%Y %H:%i:%s') AS Fecha, ROUND(o.total_paid, 2) AS Importe FROM prefijoTabla/orders o JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state JOIN prefijoTabla/country co ON a.id_country = co.id_country WHERE os.name IN ('Spedito', 'Consegnato') AND co.iso_code = 'IT' AND o.date_add >= DATE_SUB(NOW(), INTERVAL 90 DAY) AND o.date_add >= '2025-02-26' LIMIT 10000;"}]"
  ]
]
GET https://gshopping.idento.es/gshoppingApp/api/gshopping/consultaecommerce/analitica/-1
Request options
[
  "base_uri" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/"
  "headers" => [
    "Authorization" => "08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA"
    "Content-Type" => "application/json"
  ]
]
Response 200
[
  "info" => [
    "header_size" => 123
    "request_size" => 480
    "total_time" => 0.217118
    "namelookup_time" => 2.7E-5
    "connect_time" => 2.7E-5
    "pretransfer_time" => 0.000116
    "size_download" => 121928.0
    "speed_download" => 561880.0
    "starttransfer_time" => 0.213862
    "primary_ip" => "103.23.60.149"
    "primary_port" => 443
    "local_ip" => "103.23.60.149"
    "local_port" => 55946
    "http_version" => 3
    "protocol" => 2
    "scheme" => "HTTPS"
    "appconnect_time_us" => 27
    "connect_time_us" => 27
    "namelookup_time_us" => 27
    "pretransfer_time_us" => 116
    "starttransfer_time_us" => 213862
    "total_time_us" => 217118
    "start_time" => 1742201284.7168
    "original_url" => "https://gshopping.idento.es/gshoppingApp/api/gshopping/consultaecommerce/analitica/-1"
    "pause_handler" => Closure(float $duration) {#479
      class: "Symfony\Component\HttpClient\Response\CurlResponse"
      use: {
        $ch: CurlHandle {#503 …}
        $multi: Symfony\Component\HttpClient\Internal\CurlClientState {#391 …}
        $execCounter: -9223372036854775798
      }
    }
    "debug" => """
      * Found bundle for host gshopping.idento.es: 0x55d3eab00b60 [can multiplex]\n
      * Re-using existing connection! (#0) with host gshopping.idento.es\n
      * Connected to gshopping.idento.es (103.23.60.149) port 443 (#0)\n
      * Using Stream ID: 5 (easy handle 0x55d3eaa633f0)\n
      > GET /gshoppingApp/api/gshopping/consultaecommerce/analitica/-1 HTTP/2\r\n
      Host: gshopping.idento.es\r\n
      authorization: 08IPdnPZUWlzdYvyaeZDn-C8GOjW2df6qRwaOQIErcpIKVTrcFMOXSDakz3nngSNKaUUELDvnfKuOPrPxWnPhAZ4oaQ4OR3hZ_D6QVJdf7ogfVWBR29sHGjg8fbtISy7VJTzK1qNHjfdJZ3p1zMvqkFixPbRgiwxv0BylNn2-MJL9UH-xhgpKTpGNkXKytkHSsFicc2pNfsjsbcoYE-_YyFZPjA7xGmtkVSWY-p4aferidpl9xUhc_NoIaemeCKA\r\n
      content-type: application/json\r\n
      accept: */*\r\n
      user-agent: Symfony HttpClient (Curl)\r\n
      accept-encoding: gzip\r\n
      \r\n
      < HTTP/2 200 \r\n
      < server: nginx\r\n
      < date: Mon, 17 Mar 2025 08:48:04 GMT\r\n
      < content-type: application/json\r\n
      < x-powered-by: PleskLin\r\n
      < \r\n
      """
  ]
  "response_headers" => [
    "HTTP/2 200 "
    "server: nginx"
    "date: Mon, 17 Mar 2025 08:48:04 GMT"
    "content-type: application/json"
    "x-powered-by: PleskLin"
  ]
  "response_content" => [
    "[{"id":{"idConsulta":28,"idEcommerce":55},"consulta":{"id":28,"nombre":"PS Listado de productos más vendidos (últimos 5 meses)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.7.3","1.7.7.1","1.7.6.7","8.0.4","1.7.6.3","0","1.6.1.9","8.1.5","1.6.1.17"],"consulta":"SELECT p.id_product AS 'ID Producto', COALESCE(pl.name, '-') AS 'Nombre producto', COALESCE(SUM(od.product_quantity), 0) AS 'Unidades vendidas (cantidad)', COALESCE(SUM(od.product_quantity * od.total_price_tax_incl), 0) AS 'Ingresos totales', COALESCE(SUM(od.product_quantity * od.total_price_tax_excl), 0) AS 'Ingreso neto' FROM prefijoTabla/orders o INNER JOIN prefijoTabla/order_detail od ON o.id_order = od.id_order INNER JOIN prefijoTabla/product p ON od.product_id = p.id_product LEFT JOIN prefijoTabla/product_lang pl ON p.id_product = pl.id_product WHERE o.date_add >= DATE_ADD(CURDATE(), INTERVAL -5 MONTH) GROUP BY p.id_product, pl.name ORDER BY SUM(od.product_quantity * od.total_price_tax_incl) DESC LIMIT 15;"},"ecommerce":{"id":55,"nombre":"Catunambu","urlEcommerce":"https://tienda.catunambu.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"ddxt3t5eczl6hqs2ph43c4bl75rrybbxdf1vpnq8sp8vp22u5j2rek6g916l0g6t9ytp80ztntnuurggk3ydl25jl6fnwu2wazfylutztky20e8alya89lntjvojblkxezmxu90ygb6qzlckpxkwxzfcslm9knbcvsv21lz19rxgwmu1g37fxguoqoulfgn7x5z33qsiajevyby9c77e74r03m0vqcn9ejif1masoml1lhlkrld9xxoxm89lu6pm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1ihP1vTk_gBbT1jKLGhbs-qboo_unPKRcFA4u78Dh1KA","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":441244698,"idFeed":10401388925}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":30,"second":30,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"datosGshopping","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":23},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":23,"nombre":"Conely","urlEcommerce":"https://www.conely.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"n9zbpoi1fb9xxl6geig1i3ffp2v4gujdem4duyehx9mj0wkiq02dwgpn7xl7cy85nv5r2peekr1nou5icmozzsdo7pn9cwm8rfswbgvpfqui2stqy16fil03lpy09hngxldsf8qnco4tt3wcqvjgxbd4bcxvh9bez68sfeq8kk98cg5r7h5h5fjyb5115d503q08sriwmbfzdc66qgqnk1xdljfr19lf5u1usnlw84khs5630b8g4dslcgqr0afz","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1cy2ddoJxfextIeLXow8rlg9pslo3cgXKc-PM6I4e9IA/","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":124082022,"idFeed":10098699539}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":30,"second":36,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":24},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":24,"nombre":"Arde Madrid","urlEcommerce":"https://www.ardemadrid.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.17","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"7b7sy5uk94zo3xeixz2kc7f8k5ntqc00n2jz6o0otdwrhr3pkuuttk64lacjkm6i7r8dx57rxxdll0grh4g7pkre473puvdcsfcfq2vxocictzknums3w7dyd5ro2ojzq221je2xzn4expjel4emn6jl9hsvssrjfox2l7v98ahb5619yvybycgl3kr24at5179egyf4eto3b9mw6zfw0ywsas86vkufvzq8qkgfzbfq06q1lvjzm8wnbhxkcn4a","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/17VRhyIMWKF-YQxh8vs2tuANeYdovRx9dgjLLdR-oOFI/edit?gid=385996217#gid=385996217","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":125930592,"idFeed":10102582723}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":null,"resultadoUltimaEjecucion":null,"habilitado":false,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":53},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":53,"nombre":"Kayaks Online","urlEcommerce":"https://www.kayaksonline.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"KOES","variableVariantes":"","versionPlugin":null,"tokenApi":"9os234p2buzvju6zttiyvgtjyvv1psmpe8hexk667uxwfsmq5b4o3faw0fih7fuegaknqxxua6o1jz21b4gznt8poe47rtyqsb6nqe64wlw5e79rx9ad8u549jhv21ib7vqdxeabqnkbx8h9mbznuumz5jcorg4zd6b4boxol1co3fejs20pmo828akjqsp5lbfula6y7z3ch2185rw1howjg4syq17uox5lm4otknz4yh9ao1quypeykwx1k8um","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1pdaFiEuUYPnBjs8sVc2unSaMgiPZ0EkA1Yyhz9AnhMk/edit?gid=62819329#gid=62819329","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":129210142,"idFeed":10333605647}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":30,"second":52,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":54},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":54,"nombre":"Mercapool","urlEcommerce":"https://www.mercapool.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"twfis8urms33us7nj1miboqyac53xj36j31bcvmlj799byemavof0xuq7sk8s6mez4kzh1yal7z9bbmzqka1c8n9hf70bsvdz4ejgopp3vo4ffuf8d5flt5dnve0azpoe5fbix67ix0lxa4qwghtl5a7ykfv6vjxm9ygpxm3q8b1g2nzhlawkn59ulw2nqgauyl9we51lxap6ezi3nkly4n0pqipvu92y8lvx171i50o2s0emmouz0h1qom7f8k4","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1PeiBFkT-fbgo4mKeny9ZU2bsL2v9O_0bdsVe2JbzRgc/edit?gid=907154910#gid=907154910","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","5":"mpsanchez@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":241488213,"idFeed":10364836367}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":31,"second":5,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":55},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":55,"nombre":"Catunambu","urlEcommerce":"https://tienda.catunambu.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"ddxt3t5eczl6hqs2ph43c4bl75rrybbxdf1vpnq8sp8vp22u5j2rek6g916l0g6t9ytp80ztntnuurggk3ydl25jl6fnwu2wazfylutztky20e8alya89lntjvojblkxezmxu90ygb6qzlckpxkwxzfcslm9knbcvsv21lz19rxgwmu1g37fxguoqoulfgn7x5z33qsiajevyby9c77e74r03m0vqcn9ejif1masoml1lhlkrld9xxoxm89lu6pm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1ihP1vTk_gBbT1jKLGhbs-qboo_unPKRcFA4u78Dh1KA","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":441244698,"idFeed":10401388925}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":31,"second":15,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":56},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":56,"nombre":"Artisan Gallery ES","urlEcommerce":"https://www.artisangallery.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"6omv2z89svre6s6q7ztib5qdpjzn5ygbfc9dpl4ddmn8b63atgakc5wuy27oga9aeauy4u5hacurpm58rw89ju83hgxice8en7oexvbye1dl7cb2ls9pce6dtmn1wqtjim7ypz9s5nmadxoiyet46rhhbffhik8d8vnmexr8afd00mt4q443hn34zmt7sczapybhc2zi12i23ltuadimwb6aw0fk8cwrzp8f0azstz91o7i0v7uvq9z5gd28cas7","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1J7aXfYproC2uagRmrDtPSilQZASw1lBcrIv0sWH6e7E/edit?gid=373733719#gid=373733719","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":9099774,"idFeed":10385774083}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":null,"resultadoUltimaEjecucion":null,"habilitado":false,"tabSpreadsheet":"GShoppingAuxVentasES","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":57},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":57,"nombre":"Mercapool DE","urlEcommerce":"https://www.mercapool.de/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"DE","variableVariantes":"v","versionPlugin":null,"tokenApi":"j73zu83g0eylas2tyf85ge6ybhygdw7qoahuzux3fa0wlibd4u0r7dnli5ea7308v5wgq81oz11l3f0l457osrkf0v2o2fal45848uscqr6ni27zqgpbqpxc6kzairurjexbbm5nw5lwth8u4or1trsl5eo4tvx9ijbkmfocnje01s68jw8fofjw2ae5soiv8za702sk7daz8gtbkjct4d9p31kjljxad70senfdeywzhaeojbtzbae0r9qa1ioa","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1m-3Bt5k6NDAGWdPxv7-A6VE6Ohj1cbTSwsNCjQnBJyk/edit?gid=675402185#gid=675402185","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":551761032,"idFeed":10385774188}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":31,"second":30,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":58},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":58,"nombre":"Sakata 3D","urlEcommerce":"https://www.sakata3d.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"v","versionPlugin":null,"tokenApi":"bzrqpzce3nnhft4n5lwdj0t52ev1ncak5qplwe3oswp3ksgtahc6fo4kozqfsrwzpuxjuygdt8j4alwkxr3v8qac59l6t14zinr1vmlrvhc9yu2b8xx37lr4t5u1o4jcfl7uxlwnrau5rrpcmv3dg3m31cd0w80w8qt53itvq4w88xlzezdx1nfl6zvd8x3m9qwm389p49jw1auvc9s32gd60k68ry0g6lpnhwb5zv5uyw2rw1jxvz4749zgjpfu","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1nhu5xHx3f1UkDBkHRIeakpz6ToAi8Z6xTVEZYnRDu4I/edit","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":643240830,"idFeed":10401406563}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":31,"second":44,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":59},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":59,"nombre":"Soul Natura","urlEcommerce":"https://soulnatura.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.5","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"3ghigpoha8k8vqetpgvl6o7xum8j1sjc8hbx32w0htrqcdf2wed1zbozbpg0199a9fpiynrf1ecb1ypdmqbmg8szivj8yvs1aab4ql5xo8f1ig0hb5yh3ledfrxyp9x07hpq7tfdvwg5hufs49943e3ulj1k2c7em42wjs48ro6wzc31fbiomnpjnd7jpfls973iovvivtq05poin1udm0581alcrh34vev5ngyjo5vfmpumg5yylq49hk1xt1f0","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1dQB2g2zitZ8219XQjnGbHkV4bEmTC7eJwT4ZJx3vk44/edit?gid=357621296#gid=357621296","usuarios":{"32":"creyes@idento.es","35":"mascaso@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":284557124,"idFeed":10401388877}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":13,"hour":9,"minute":31,"second":40,"dayOfWeek":"THURSDAY","dayOfYear":72,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":false,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":62},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":62,"nombre":"Ilutop","urlEcommerce":"https://www.ilutop.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.5","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"zqhuankep5zq992ug0v9ezlmwf4wgyqbinakzduc3u87gkh3hklg54alf1ny5wztm423xd71jgtiw8692y4t3vb463z8sz2o25m435qnq2ytfwwqp3odn1usra4hadzkk4ru6hyx7w6g9qdzooxanvqrxt5mtjvithxvowukgwps0r6l9p2vwzt6xqxz42b3t9y7zxcxn2ibamse9varzisrp98ssz47uiifj765pu8thsdjrr5a0yoijao231js","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1XawtXBBonb_7Rf1j-zzEfER8Fh0amBgxs86iuuM8Lps","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":118297897,"idFeed":10385613305}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":31,"second":58,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":63},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":63,"nombre":"Ortoitaliana","urlEcommerce":"https://ortoitaliana.it/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"IT","variableVariantes":"v","versionPlugin":null,"tokenApi":"bsmyqr0su69hdrx3vmv76z9me4nv8ns3191xiv7go3gscfxlrpdl3zznfmcu8carqmle4tr2ioafh4l30fj6f5lzpqk4gce9y4byobby7l9ayaby1vawpfzrr1f0mj7c82dcl4lqt1nczmgtepxwwmqxj8e3u0o4yysjjhvt7uzo1wjhji993v78d63x7txbru5frj890cukkwczgmzmmk05yhvi7spqxkbur1w1na9lsc7c67reto5fg2f2uero","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bVgC7gooH3cNsSruqQLRPOP_QIwilLYPaD_ZvpgCyKs/edit?gid=2099155284#gid=2099155284","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":781760186,"idFeed":10388051967}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":32,"second":11,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":65},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":65,"nombre":"El Rayo","urlEcommerce":"https://elrayo.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"mux8umf8v1f8sw21c8sji0yfxd3ghsycpxd02vi39ozxqp5qsc17jqisnj9ldmmiqi8q7ylj6mit0c54if4gwk4kry7omtoudwyqrzmjfb7hrl5wjyjanv62k2xgstzk6i2kbarpy65czcwg0ij5r65psk63i6u9muj0gv6vjqvdcqujwii7zq6o7sm457hn60xie1y7egbbvb5ifa8fkbl5x1q8mciz5setuddcbg0bl4xykrwzxdfpi2bbfl8u","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/15cR_CPuxADHIM5Z4H3OO5Yfnsf6Xzma0XetK38b_DZI/edit?gid=2108298972#gid=2108298972","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":113730391,"idFeed":10390765646}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":32,"second":25,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":66},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":66,"nombre":"BPro Audio Store","urlEcommerce":"https://bproaudiostore.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"4f3cgm6z63su8j39qjfnekfsi1d5epcm81glzymmar78vjm6ye48jgampk1c97aqydtz2zbjh6lgksh7hr5nwnegtzixvh93xmhhq9mrs9ikjdilc8ihtwhbqh5095eq6gqm9q7wg8cc0v0494b5hlegme3yzxqq9fl7zzxrrbpmrsgag0zq3128z31c0c32teqg2frp2mmjut223vrua8dayfkpld7ih5bkqve77ybavbji2b5ij6i2rxrlc8ib","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/12-lu9cbMXaNJVx259GCo2SfkmY9l6wPSNcaiD6KbVmE/edit?gid=1674336303#gid=1674336303","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","5":"mpsanchez@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":126150908,"idFeed":10394642426}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":null,"resultadoUltimaEjecucion":null,"habilitado":false,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":67},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":67,"nombre":"Vecosolar","urlEcommerce":"https://vecosolar.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.7","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"v","versionPlugin":null,"tokenApi":"vxl7uhp2bhds0z3qnske1guzhzsf8vjotylgwnyihz21gdeyr676nlyccq2qdlqa1mkuy00ih20szdx0ypgpq697k0lftx11nugb1dkaxhphltsduq7olytg8t81g9g0hyzdep6hxraxaakecenusb91p36owxvf2o7w3xvo87fm8m2foeigm5rjibdydfg45vp558a3jig4zb6hp6164ygyubfy4lez1pw0hhepgup0ofk9ds7pf0biunl7w11r","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1lxuvoXyyDx6_UEvPG5DkKlAC-SZTm3xfaQYWieuKHx8/edit?gid=1319728250#gid=1319728250","usuarios":{"32":"creyes@idento.es","5":"mpsanchez@idento.es","37":"eclemente@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":795141877,"idFeed":10401387059}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":32,"second":35,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":68},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":68,"nombre":"Tienda del Soldado","urlEcommerce":"https://www.tiendadelsoldado.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.9","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"9w74z3ojow1rz6r5t2wwc5m1l9nkde7s8kreafxs7p1hpyuyanc19xnryugpay51l7uttj6yzufif3koew1v94zq8w9gqwtxg1pcug43o11nj97vvqtp3n6r2sjynmt0pkskumqswlqzvbum0tbxvm4gazdp3mmj4hxo7hutlrtswypl0zgj2cslub8e2ktitd9noaous8f9h1hrrl7n3y1q5c245x75wmsoy1w4pyuduwlscd40r2gjz8wq36x1","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/14yEFAaCvRWokg9LT7OxhqB5_wd730LLDqjbkSpl0v_Q/edit?gid=1649677236#gid=1649677236","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":140452675,"idFeed":10398314392}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":32,"second":48,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":69},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":69,"nombre":"Taine","urlEcommerce":"https://www.taine.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"3ll1u9t8l0aciy6v0zvtl1zcd3slw2pi0gurajwbxgnq1j3in12s195ieu16a5zxwifg14us6m8x5phdd68xesh8njqdexo6yzejgeiy6tjhv5do3dzx0xztvskrjnnnx1qoupb1saf0jokq7qpvotrlxhr180pyqdzl8wurm2mp2xnlka4rsmqxakcpg96sv2vabefkesod978kk82zbwt1mjeboxuqlf1wnpaysrlianhskr1odnjbguotc3c1","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1MWiFpPGn1ZHbS4LnnB3IZSJUu092tCr2wibbbxq9rp0/edit?gid=406095437#gid=406095437","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":238095762,"idFeed":10398331597}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":32,"second":59,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":72},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":72,"nombre":"Solo Camion","urlEcommerce":"https://solocamionrepuestos.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"a7cap40c3u1s0pb6qhq1jc8bx4czc89d37rjovk3tvk2lzjbwc3aj4ehdwyb15swh79degv3tr5t4gmu9hq4f1q2hskqm5jxb2fboewh5wzwxdh3otzda8ydj7roopdynakkkggqdk7thz460vvkrdbaodqerqbmj1bgdlkxmj7u1f85zvy2li3iqql6ato9tb0xw92ie89277a4b7nocbi6ugy8ep5swl4xzgixhuyvzi6c12fw9b5kup0zxe1t","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/19yprZmzyQjQdOCPYJQP8bJRBFzESM-sE7TzKNwIWG9o/edit?gid=603332496#gid=603332496","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":111111,"idFeed":0}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":10,"hour":9,"minute":40,"second":28,"dayOfWeek":"MONDAY","dayOfYear":69,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Error en la ejecución: Falló la Task que Ejecuta Consultas Analitica de analitica después de 3 intentos. No se pudo obtener info del ecommerce. Codigo: 503. Error: <!doctype html>\n<html lang=\"\">\n\n  <head>\n    <meta charset=\"utf-8\">\n    <meta http-equiv=\"x-ua-compatible\" content=\"ie=edge\">\n\n    \n      <title></title>\n      <meta name=\"description\" content=\"\">\n      <meta name=\"keywords\" content=\"\">\n    \n    <meta name=\"viewport\" content=\"width=device-width, ini","habilitado":false,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":3},{"id":{"idConsulta":38,"idEcommerce":73},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":73,"nombre":"Whim Cycling","urlEcommerce":"https://whimcycling.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.1.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"acapw134ouzgrldr8sgs3ulgsv5lcvtefwpk7nck20ao35aqi0vi1t0jeh2a3dxaz6t044fbarprjrb1bc4r1oi1vj20v3e35ww6ceacbb02x70p2y1mrik3sj7jtbiunohvp4n7n5113vw0mncvtd19gy44g17zfp9cl2d8bby4c38z8pj7bk7z7uiwuwp44oerasfad3wxfej17mjzbjzo39vqiiks4hf78t1qt26p9kgz7f699jo6ikzvbe7d","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/154jnJsicVV9ybeIqWbtGiQp3N4l4bA3DOuFztgYbkLc/edit?gid=200368787#gid=200368787","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1111111,"idFeed":0}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":33,"second":11,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":74},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":74,"nombre":"Artisan Gallery FR","urlEcommerce":"https://www.artisangallery.fr/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.6.1.24","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"effw83gi61ah37s1n4frhl2mi7swrucj6p6un91m2x0m0npf12ce7rp88o0ke7ns73k9mk0aqm8uzc6dcgb8wyjw6dq6ru9upzqf7wquxbvqbjz4i3q2h1c6gf1emb2mxdj2rsku1d99ecz3ge3jjf9rph5i6out5kp586u8qas5p4iaz6wddffdqv9zwc6u9ret6dbsxm4hbhytd8asvaecy2bramnlxrjg0f59z6tt8wnu3u8zrtvhlt2f1ijl","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1iCjcFEz73Etl6M_8Dse1xGeLaPVRA2hAULM1KYnED7Y/edit?gid=849717025#gid=849717025","usuarios":{"32":"creyes@idento.es","1":"dgarrido@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":111222333,"idFeed":0}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":null,"resultadoUltimaEjecucion":null,"habilitado":false,"tabSpreadsheet":"GShoppingAuxVentasFR","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":75},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":75,"nombre":"Matismo","urlEcommerce":"https://www.motorespersianas.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.6.3","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"58t5mmnxa26r2oatdh00x3kkztdoftfwb9bfuknp2m3rdtm27l4dba8al9lib3u8wd7lb5630cidirxeco9w4r569ay1cpwjqlo78m98n9j3us4rvx8ohdjzbp5bg6hjxthr1ky3dx8mkswi34pn8d49tfnwdszs2vcdghmm5sscrabcinai0fv43na4337sbcywvynl46vsyo8a3d9vao5bzjurpc2geak649tr7vxhxw0w0fe47yjbpp7eekui","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1-hlUZq9Bg3PN7w4xFMW5hvdsDiRit3BJMelEVv1bGpU/","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":109944519,"idFeed":10424182793}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":33,"second":26,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":85},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":85,"nombre":"Medical Europa","urlEcommerce":"https://medicaleuropa.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.0.4","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"z41u5ncxk72f5lph42vyr55x2tgmmfhq6pcvb2pupuyqyfho2kote7tp8ki7ehf2a42c6vq4m7idqz2twuheu4jntxbrwb1jkpripdlt9cxtz0g46h79a19zv5cgan3uypq8r1qc1hxrttyxpja4gnihl4f5q2h0ffe84j53s4e8xjf57bavubcejg3mm5oetzjngdhr6zvy6lylq0dab1yk1mxc9jxvscxa74v26n6o6usgzi2ral5hrtwhsqjb","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1h7sJRuaGdBAZP4_gyJMqinzhCKcxygoGwYUjuAoERBE/edit?gid=2071547258#gid=2071547258","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":766078283,"idFeed":10429194045}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":33,"second":37,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":38,"idEcommerce":88},"consulta":{"id":38,"nombre":"PS Descarga pedidos desde 1 julio 2024 (max 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.6.1.24","1.7.8.7","8.1.5","1.7.6.7","1.6.1.17","1.7.8.3","1.7.7.3","1.7.6.3","1.7.7.1","1.7.8.11","1.6.1.9","8.1.2","8.0.4","1.7.7.2","1.7.8.9"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= '2024-07-01' ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":88,"nombre":"Promoshark","urlEcommerce":"https://promoshark.eu/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"-","versionPlugin":null,"tokenApi":"xs4b5ks7u2hxu0md1i1mi1z6job7fyve7yprgkt1ncucmo8qsj31yi179dwydgkgf9f37n2nyqc0h41g4abm60zuj1meqf0jldytxk6r44clsyq8opssim7spkhiaqgdpakqbfp4dyg57n44iazleo4dbst9zka5l7nionhhf44zzp18zycqm76ozq79m68ag4sv8drmy4gyn7k4r62qd904svd2wn009x5v9hu54tc420krvm39flp8iz3wuc0d","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1MgK2LDqvIhBL8krXZJmfeUg2GgzrFsgt0HncHEzdFeg","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1146551694,"idFeed":10445121600}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":33,"second":45,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":40,"idEcommerce":52},"consulta":{"id":40,"nombre":"WC Descarga pedidos 9 meses (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_customer_user' THEN pm1.meta_value END), '-') AS cliente_id, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END), 2, 'es_ES'), '-') AS Total, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 9 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},"ecommerce":{"id":52,"nombre":"Tuclaboral","urlEcommerce":"https://tuclaboral.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"3wa42xh0ltw9850lr9lyi73bnptq4677vnj9dc8ssunlps2fevlwbv6ypg0lydb67xk1ilq0mse6a2b2x73y2nl6a663m2uudbq8wb85pjhj9zowdjby6siw3qgbvqtuxbxvx09orsjry0luqvlxf5ktn0scr4uk274xdzfydn008zwcxeo11twggq0lbq7z1t0uyvjgau8hijmzfcjg6n858yioditovhlqa4tcaer9fhd7ac402su3z6i867u6","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/11JId3Fu6gKYWQ69VExl22cDHuf4IlHNQpcIec6SJE8o/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":704848541,"idFeed":10108651569}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":34,"second":6,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":40,"idEcommerce":70},"consulta":{"id":40,"nombre":"WC Descarga pedidos 9 meses (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_customer_user' THEN pm1.meta_value END), '-') AS cliente_id, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END), 2, 'es_ES'), '-') AS Total, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 9 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},"ecommerce":{"id":70,"nombre":"Locos por las Piscinas","urlEcommerce":"https://locosporlaspiscinas.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"qayfzvuf1e1g8iyu935yq6l5qywmmwjf69a3ffxzp66k87fplslxm28u9ef01typ86wfqcr05s7zass6qwxaf5hi4w52zi1xvq45mlgxk8lh2bqaanj4vuapevfbm0pe52lmxum3y5d2pedgzauma9q5b9x84t5mjpsk0hqu1wii5p3aflhdsggh3mq9l1xmv41wufsib4w9te3c7xrhb3nd71biu9zruljobxzcxwp80ry8pyznvb55qt5nqf6l","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1mY1VeblNY9ti8mJEp9Tzae2zN0FeLeRfHokHCe4WswY","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":359082605,"idFeed":10333616918}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":34,"second":34,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":40,"idEcommerce":87},"consulta":{"id":40,"nombre":"WC Descarga pedidos 9 meses (max 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(MAX(CASE WHEN pm1.meta_key = '_customer_user' THEN pm1.meta_value END), '-') AS cliente_id, COALESCE(MAX(CASE WHEN pm1.meta_key = '_shipping_country' THEN pm1.meta_value END), '-') AS paisEntrega, COALESCE(FORMAT(MAX(CASE WHEN pm1.meta_key = '_order_total' THEN pm1.meta_value END), 2, 'es_ES'), '-') AS Total, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND (pm1.meta_key = '_shipping_country' OR pm1.meta_key = '_order_total' OR pm1.meta_key = '_customer_user') LEFT JOIN prefijoTabla/users u ON p.post_author = u.ID LEFT JOIN prefijoTabla/usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_order_date' WHERE p.post_type = 'shop_order' AND p.post_date >= DATE_SUB(CURDATE(), INTERVAL 9 MONTH) GROUP BY p.ID, p.post_title, p.post_status, p.post_date, um1.meta_value ORDER BY p.post_date ASC LIMIT 10000;"},"ecommerce":{"id":87,"nombre":"Ruster","urlEcommerce":"https://rusterfitness.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"6yv5hrqjx5ttb8hs3jb3pp3x89j2kqdn34r4a87i0j6qaall7adg137ya6m7nrga9i4q30nhqqzd3xlr3ny4ehyzhtpywlfusx8mq5rmh0fwlldc7zwb9x6ecm67ffqa1zaym7pu9ms1brhx51ffktsvdnxlu9gfg16146ilt5csnp3l39y9z38h472q8vb2kjpwewl1u8y1dzhfrlbrjhbc1ej1e8kvh1vrjjxyeo9yssak52hbhsbsggp6h6ey","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bhQSDyfYz1Qm8YwcUHxQp3XZ_vzszZCvhbDijqNuz64/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1037770266,"idFeed":10444650309}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":34,"second":54,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":41,"idEcommerce":52},"consulta":{"id":41,"nombre":"WC Consulta identificación Cliente nuevo-recurrente","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT COALESCE(meta_value, '-') AS id_cliente, COALESCE(COUNT(post_id), 0) AS numero_pedidos, CASE WHEN COALESCE(COUNT(post_id), 0) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/postmeta WHERE meta_key = '_customer_user' GROUP BY meta_value ORDER BY numero_pedidos DESC LIMIT 10000;"},"ecommerce":{"id":52,"nombre":"Tuclaboral","urlEcommerce":"https://tuclaboral.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"3wa42xh0ltw9850lr9lyi73bnptq4677vnj9dc8ssunlps2fevlwbv6ypg0lydb67xk1ilq0mse6a2b2x73y2nl6a663m2uudbq8wb85pjhj9zowdjby6siw3qgbvqtuxbxvx09orsjry0luqvlxf5ktn0scr4uk274xdzfydn008zwcxeo11twggq0lbq7z1t0uyvjgau8hijmzfcjg6n858yioditovhlqa4tcaer9fhd7ac402su3z6i867u6","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/11JId3Fu6gKYWQ69VExl22cDHuf4IlHNQpcIec6SJE8o/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":704848541,"idFeed":10108651569}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":35,"second":3,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas2","numeroErrores":0},{"id":{"idConsulta":41,"idEcommerce":70},"consulta":{"id":41,"nombre":"WC Consulta identificación Cliente nuevo-recurrente","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT COALESCE(meta_value, '-') AS id_cliente, COALESCE(COUNT(post_id), 0) AS numero_pedidos, CASE WHEN COALESCE(COUNT(post_id), 0) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/postmeta WHERE meta_key = '_customer_user' GROUP BY meta_value ORDER BY numero_pedidos DESC LIMIT 10000;"},"ecommerce":{"id":70,"nombre":"Locos por las Piscinas","urlEcommerce":"https://locosporlaspiscinas.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"qayfzvuf1e1g8iyu935yq6l5qywmmwjf69a3ffxzp66k87fplslxm28u9ef01typ86wfqcr05s7zass6qwxaf5hi4w52zi1xvq45mlgxk8lh2bqaanj4vuapevfbm0pe52lmxum3y5d2pedgzauma9q5b9x84t5mjpsk0hqu1wii5p3aflhdsggh3mq9l1xmv41wufsib4w9te3c7xrhb3nd71biu9zruljobxzcxwp80ry8pyznvb55qt5nqf6l","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1mY1VeblNY9ti8mJEp9Tzae2zN0FeLeRfHokHCe4WswY","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":359082605,"idFeed":10333616918}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":35,"second":20,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas2","numeroErrores":0},{"id":{"idConsulta":41,"idEcommerce":87},"consulta":{"id":41,"nombre":"WC Consulta identificación Cliente nuevo-recurrente","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.2.1","9.6.2","9.6.1","9.6.0","9.3.3","9.3.2","9.3.1","8.2.1","9.0.2","9.4.3","9.4.2","9.4.1","9.1.4","7.5.1","9.1.2","9.5.2","9.5.1","9.2.3"],"consulta":"SELECT COALESCE(meta_value, '-') AS id_cliente, COALESCE(COUNT(post_id), 0) AS numero_pedidos, CASE WHEN COALESCE(COUNT(post_id), 0) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/postmeta WHERE meta_key = '_customer_user' GROUP BY meta_value ORDER BY numero_pedidos DESC LIMIT 10000;"},"ecommerce":{"id":87,"nombre":"Ruster","urlEcommerce":"https://rusterfitness.com/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.2","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"6yv5hrqjx5ttb8hs3jb3pp3x89j2kqdn34r4a87i0j6qaall7adg137ya6m7nrga9i4q30nhqqzd3xlr3ny4ehyzhtpywlfusx8mq5rmh0fwlldc7zwb9x6ecm67ffqa1zaym7pu9ms1brhx51ffktsvdnxlu9gfg16146ilt5csnp3l39y9z38h472q8vb2kjpwewl1u8y1dzhfrlbrjhbc1ej1e8kvh1vrjjxyeo9yssak52hbhsbsggp6h6ey","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bhQSDyfYz1Qm8YwcUHxQp3XZ_vzszZCvhbDijqNuz64/edit?gid=0#gid=0","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es","30":"sbustos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":1037770266,"idFeed":10444650309}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":35,"second":32,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas2","numeroErrores":0},{"id":{"idConsulta":47,"idEcommerce":65},"consulta":{"id":47,"nombre":"Pedidos desde el 1 de Enero de 2023 Prestashop","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.8.11"],"consulta":"SELECT o.id_order AS 'ID pedido', o.reference AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as 'Nuevo cliente', o.id_customer AS 'ID cliente', cl.name as 'Entrega/Pais', FORMAT(o.total_paid,2,'es_ES') AS 'Total', o.payment AS 'Forma de Pago', os.name AS 'Estado', o.date_add AS 'Fecha', MONTH(o.date_add) AS 'Mes', YEAR(o.date_add) AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang=o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang AND DATE(o.date_add)>='2023-01-01' order by o.date_add asc LIMIT 50000;"},"ecommerce":{"id":65,"nombre":"El Rayo","urlEcommerce":"https://elrayo.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.8.11","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"ES","variableVariantes":"v","versionPlugin":null,"tokenApi":"mux8umf8v1f8sw21c8sji0yfxd3ghsycpxd02vi39ozxqp5qsc17jqisnj9ldmmiqi8q7ylj6mit0c54if4gwk4kry7omtoudwyqrzmjfb7hrl5wjyjanv62k2xgstzk6i2kbarpy65czcwg0ij5r65psk63i6u9muj0gv6vjqvdcqujwii7zq6o7sm457hn60xie1y7egbbvb5ifa8fkbl5x1q8mciz5setuddcbg0bl4xykrwzxdfpi2bbfl8u","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/15cR_CPuxADHIM5Z4H3OO5Yfnsf6Xzma0XetK38b_DZI/edit?gid=2108298972#gid=2108298972","usuarios":{"32":"creyes@idento.es","34":"lleyva@idento.es","37":"eclemente@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":113730391,"idFeed":10390765646}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":35,"second":40,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"Gshopping AuxVentas 2","numeroErrores":0},{"id":{"idConsulta":48,"idEcommerce":92},"consulta":{"id":48,"nombre":"WC Descarga pedidos desde 1 enero de 2023 (límite 5000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.1.1","9.4.2","9.3.3","9.4.1"],"consulta":"SELECT p.ID AS idPedido, COALESCE(p.post_title, '-') AS Referencia, (CASE WHEN (SELECT COUNT(*) FROM prefijoTabla/posts o LEFT JOIN prefijoTabla/postmeta pm ON o.ID = pm.post_id WHERE o.post_type = 'shop_order' AND pm.meta_key = '_customer_user' AND pm.meta_value = pm1.meta_value) = 1 THEN 'SI' ELSE 'NO' END) AS NuevoCliente, COALESCE(pm1.meta_value, '-') AS cliente_id, COALESCE(pm2.meta_value, '-') AS paisEntrega, COALESCE(FORMAT(pm3.meta_value, 2, 'es_ES'), '-') AS Total, '-' AS ColumnaVacia, COALESCE(p.post_status, '-') AS estadoPedido, COALESCE(p.post_date, '-') AS fechaPedido, COALESCE(MONTH(p.post_date), '-') AS mesPedido, COALESCE(YEAR(p.post_date), '-') AS yearPedido FROM prefijoTabla/posts p LEFT JOIN prefijoTabla/postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_customer_user' LEFT JOIN prefijoTabla/postmeta pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_shipping_country' LEFT JOIN prefijoTabla/postmeta pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_order_total' WHERE p.post_type = 'shop_order' AND DATE(p.post_date) >= '2023-01-01' AND DATE(p.post_date) < '2024-01-01' ORDER BY p.post_date ASC LIMIT 5000;"},"ecommerce":{"id":92,"nombre":"bodegas duquesa","urlEcommerce":"https://ecastillo.demos-idento.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"8.1.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"19a76akpcboc0ek5l404qfocf7dstomwysamkxdy310dd571qqkxnm1cneei8awcg38bsx0xb38ksbjip4egu03no2yw7htsifmd0z2htkfh3lzkm39izl12ei9aognxtkllqmzes7mcqg5lg8lg7xytr8qs0698llu0i21hy3oejtf43ptt0upufkgz4kxlhux0gbyo7irqt2eg5hd9o8i48yon4xianndlqjhvlvzjvdx5obzw3v5ju913vmnm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1u3IfQqa-tzAbwPwtfJVLB3ofF-6j1V4qf6xtHQHS3lc/","usuarios":{"36":"pmoreno@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":123456789,"idFeed":12345678}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":60,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":8,"hour":9,"minute":50,"second":33,"dayOfWeek":"SATURDAY","dayOfYear":67,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Error en la ejecución: Falló la Task que Ejecuta Consultas Analitica de analitica después de 1 intentos. No se pudo limpiar el contenido de la pestaña GShoppingAuxVentasWooCommerce2","habilitado":false,"tabSpreadsheet":"GShoppingAuxVentasWooCommerce2","numeroErrores":1},{"id":{"idConsulta":55,"idEcommerce":43},"consulta":{"id":55,"nombre":"WC (versión 2 wp_orders) Consulta cliente nuevo-recurrente (limite 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT COALESCE(customer_id, '-') AS id_cliente, COALESCE(COUNT(id), '-') AS numero_pedidos, CASE WHEN COUNT(id) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/wc_orders GROUP BY customer_id ORDER BY numero_pedidos DESC LIMIT 10000;"},"ecommerce":{"id":43,"nombre":"OptiGarden","urlEcommerce":"https://optigarden.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"2vo5lc5p0k100idr37itjd34pnvmqxn6dop6nocwsh9w408lfckosazc2vuit9wdfek5gdk3osqzqlhonuc79qrlgzy36rz0vropn8664zyz2yzp27bt09uchmaj9whlvu6tcqjbwaeafdtws52sewszq2j30swj0zlawuf80p1ruzygvvjhwkhyfbu4oggzphnvifbsy1u6in79q2rt9b9du4cfzhkd1cy37xdu93l31zecngzq5njv0y117dp4","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1Rv_sXAUYMecz7P74ZA09RIlJCAez8tki8vfTEfJOjlE","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":571766325,"idFeed":10108519893}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":35,"second":56,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas2","numeroErrores":0},{"id":{"idConsulta":55,"idEcommerce":76},"consulta":{"id":55,"nombre":"WC (versión 2 wp_orders) Consulta cliente nuevo-recurrente (limite 10000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT COALESCE(customer_id, '-') AS id_cliente, COALESCE(COUNT(id), '-') AS numero_pedidos, CASE WHEN COUNT(id) > 1 THEN 'NO' ELSE 'SI' END AS nuevoCliente FROM prefijoTabla/wc_orders GROUP BY customer_id ORDER BY numero_pedidos DESC LIMIT 10000;"},"ecommerce":{"id":76,"nombre":"Colchones Distar","urlEcommerce":"https://colchones.distar.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"bn23izu64f7499mk8khmrfl5w1l4h2s5k1vtmbaaxqamvayxmnk09n5t6yem3g6r5c9m2bna1r7gbwvyk3h6vpe1k1gpnpdlg26q7jriap7ixj890kzy2c50vxi0pvb79mpesdrnv0zmxolqncu3iqf7j6f28qmk3yjr6q4vpp6ow7xxq0nbulbl9coiaw31wcj8ox6kpoymqg1k4jj2fv71qq1nj8vedscgb0dqg7qmcg216z3fcp5m65vqfgiu","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1BV8YW6ecXULMud9JyA2yBr8RRmRGYKJG4sMg4ZResZ0/edit?gid=145523367#gid=145523367","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":708446085,"idFeed":10424690535}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":16,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas2","numeroErrores":0},{"id":{"idConsulta":56,"idEcommerce":43},"consulta":{"id":56,"nombre":"WC (versión 2 wp_orders) Descarga pedidos desde 1 julio 2024 (máx 7000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT DISTINCT COALESCE(orders.id, '-') AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 2, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" WHERE YEAR(orders.date_created_gmt) >= 2024 AND orders.date_created_gmt >= '2024-07-01'  AND orders.total_amount > 0 LIMIT 7000;"},"ecommerce":{"id":43,"nombre":"OptiGarden","urlEcommerce":"https://optigarden.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"2vo5lc5p0k100idr37itjd34pnvmqxn6dop6nocwsh9w408lfckosazc2vuit9wdfek5gdk3osqzqlhonuc79qrlgzy36rz0vropn8664zyz2yzp27bt09uchmaj9whlvu6tcqjbwaeafdtws52sewszq2j30swj0zlawuf80p1ruzygvvjhwkhyfbu4oggzphnvifbsy1u6in79q2rt9b9du4cfzhkd1cy37xdu93l31zecngzq5njv0y117dp4","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1Rv_sXAUYMecz7P74ZA09RIlJCAez8tki8vfTEfJOjlE","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":571766325,"idFeed":10108519893}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":25,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":56,"idEcommerce":76},"consulta":{"id":56,"nombre":"WC (versión 2 wp_orders) Descarga pedidos desde 1 julio 2024 (máx 7000)","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["9.6.1","9.5.2","9.4.3","9.5.1","9.4.2","9.3.3","9.4.1","9.3.1"],"consulta":"SELECT DISTINCT COALESCE(orders.id, '-') AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 2, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" WHERE YEAR(orders.date_created_gmt) >= 2024 AND orders.date_created_gmt >= '2024-07-01'  AND orders.total_amount > 0 LIMIT 7000;"},"ecommerce":{"id":76,"nombre":"Colchones Distar","urlEcommerce":"https://colchones.distar.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"9.6.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"bn23izu64f7499mk8khmrfl5w1l4h2s5k1vtmbaaxqamvayxmnk09n5t6yem3g6r5c9m2bna1r7gbwvyk3h6vpe1k1gpnpdlg26q7jriap7ixj890kzy2c50vxi0pvb79mpesdrnv0zmxolqncu3iqf7j6f28qmk3yjr6q4vpp6ow7xxq0nbulbl9coiaw31wcj8ox6kpoymqg1k4jj2fv71qq1nj8vedscgb0dqg7qmcg216z3fcp5m65vqfgiu","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1BV8YW6ecXULMud9JyA2yBr8RRmRGYKJG4sMg4ZResZ0/edit?gid=145523367#gid=145523367","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","25":"imolero@idento.es","29":"rnavarro@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":1,"listadoMerchantFeeds":[{"merchantId":708446085,"idFeed":10424690535}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":34,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShoppingAuxVentas","numeroErrores":0},{"id":{"idConsulta":58,"idEcommerce":4},"consulta":{"id":58,"nombre":"PS Descarga pedidos 2 meses (límite 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.6.3","1.7.8.9","1.7.8.7","1.6.1.9","8.1.2","1.7.8.11","1.7.8.3","8.0.4","1.6.1.24","1.6.1.17","1.7.7.3","1.7.7.2","1.7.7.1","1.7.6.7"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= DATE_SUB(NOW(), INTERVAL 2 MONTH) ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":4,"nombre":"Ortoespaña","urlEcommerce":"https://xn--ortopediaortoespaa-30b.es/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"OEES","variableVariantes":"v","versionPlugin":null,"tokenApi":"3peuzxo4gkgp8aks67ci50cy959pyool95sr5iq074smy57y7blpj2rojoczrb74hqgzh25hwt98gcuu08fiq7ply1fwzzgnnolt2x7a22y70bf944nk8k6wea1afipuvtwc2nialw1n9gpu3fe5jpq7hmli85z8kaupir2vasotj4qejcqhg0g9ceag8wu14qju5a6age0kmirgz1vgf3rwy4rdyme1irzd4w2o2ld10vjolkt4g5cpcd3t21pe","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1CAgUoPhzRDyFAD00s56cm3pi32WL-KeNmy8kui6O7HI/edit?pli=1&gid=0#gid=0","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":102443689,"idFeed":10097332708}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":40,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":58,"idEcommerce":61},"consulta":{"id":58,"nombre":"PS Descarga pedidos 2 meses (límite 10.000)","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.6.3","1.7.8.9","1.7.8.7","1.6.1.9","8.1.2","1.7.8.11","1.7.8.3","8.0.4","1.6.1.24","1.6.1.17","1.7.7.3","1.7.7.2","1.7.7.1","1.7.6.7"],"consulta":"SELECT o.id_order AS 'ID pedido', COALESCE(o.reference, '-') AS 'Referencia del pedido', IF((SELECT so.id_order FROM prefijoTabla/orders so WHERE so.id_customer = a.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) AS 'Nuevo cliente', COALESCE(o.id_customer, '-') AS 'ID cliente', COALESCE(cl.name, '-') AS 'Entrega/Pais', COALESCE(FORMAT(o.total_paid, 2, 'es_ES'), '-') AS 'Total', COALESCE(o.payment, '-') AS 'Forma de Pago', COALESCE(os.name, '-') AS 'Estado', COALESCE(o.date_add, '-') AS 'Fecha', COALESCE(MONTH(o.date_add), '-') AS 'Mes', COALESCE(YEAR(o.date_add), '-') AS 'Year' FROM prefijoTabla/orders o LEFT JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer LEFT JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address LEFT JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = o.id_lang LEFT JOIN prefijoTabla/order_payment pm ON o.payment = pm.id_order_payment INNER JOIN prefijoTabla/address pa ON o.id_address_delivery = pa.id_address INNER JOIN prefijoTabla/country_lang cl ON pa.id_country = cl.id_country AND cl.id_lang = o.id_lang WHERE DATE(o.date_add) >= DATE_SUB(NOW(), INTERVAL 2 MONTH) ORDER BY o.date_add ASC LIMIT 10000;"},"ecommerce":{"id":61,"nombre":"Joyerias Sanchez","urlEcommerce":"https://www.joyeriasanchez.com/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"8.0.4","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"jtekp55freyvy2vbe20kd5cw126agvmbljk4hsoaro42ckxw8np91k2of4zmg6q1v0zzlt17mwfts5h25q63m5ypclztuz1jg3jghl536mlzzpfayb2j9vx4e215flk4jxr1m3c6nfd2wltt3hzf7fn5dc9g30uyvzyb16pfschd5gzm0wiwc82nh4jwfzbyp2la2oj04k2o9k3nsax92cob0q1kqbi998tus5sbk16tj10l7a5491hshm7y0six","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1zdU_qUqYr4v9c54pPvA5Lkiv12u6avrZX4ZjvJrAjrk/edit","usuarios":{"32":"creyes@idento.es","37":"eclemente@idento.es","5":"mpsanchez@idento.es","27":"lgalan@idento.es","28":"dtrillos@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":7409456,"idFeed":10385786314}]},"etiqueta":null,"valorEtiqueta":"","frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":45,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"GShopping AuxVentas","numeroErrores":0},{"id":{"idConsulta":59,"idEcommerce":92},"consulta":{"id":59,"nombre":"WooCommerce Versión 2, Pedidos de 3 meses","tipoConsulta":"ANALITICA","tipoEcommerce":"WOOCOMMERCE","versionesCompatibles":["8.1.1","9.3.3"],"consulta":"SELECT DISTINCT COALESCE(orders.id, '-') AS idPedido, COALESCE(meta.meta_value, '-') AS Referencia, '-' AS NuevoCliente, COALESCE(orders.customer_id, '-') AS cliente_id, COALESCE(address.country, '-') AS paisEntrega, COALESCE(FORMAT(orders.total_amount, 2, 'es_ES'), '-') AS Total, COALESCE(orders.status, '-') AS estadoPedido, COALESCE(orders.date_created_gmt, '-') AS fechaPedido, COALESCE(MONTH(orders.date_created_gmt), '-') AS mesPedido, COALESCE(YEAR(orders.date_created_gmt), '-') AS yearPedido FROM prefijoTabla/wc_orders orders LEFT JOIN prefijoTabla/wc_order_addresses address ON orders.id = address.order_id LEFT JOIN prefijoTabla/wc_orders_meta meta ON meta.order_id = orders.id AND meta.meta_key = \"_order_number_formatted\" WHERE orders.date_created_gmt >= DATE_SUB(CURRENT_DATE, INTERVAL 3 MONTH) AND orders.total_amount > 0 LIMIT 7000;"},"ecommerce":{"id":92,"nombre":"bodegas duquesa","urlEcommerce":"https://ecastillo.demos-idento.es/","tipoEcommerce":"WOOCOMMERCE","versionEcommerce":"8.1.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"","variableVariantes":"","versionPlugin":null,"tokenApi":"19a76akpcboc0ek5l404qfocf7dstomwysamkxdy310dd571qqkxnm1cneei8awcg38bsx0xb38ksbjip4egu03no2yw7htsifmd0z2htkfh3lzkm39izl12ei9aognxtkllqmzes7mcqg5lg8lg7xytr8qs0698llu0i21hy3oejtf43ptt0upufkgz4kxlhux0gbyo7irqt2eg5hd9o8i48yon4xianndlqjhvlvzjvdx5obzw3v5ju913vmnm","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1u3IfQqa-tzAbwPwtfJVLB3ofF-6j1V4qf6xtHQHS3lc/","usuarios":{"36":"pmoreno@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"wp-json/modules/obtenerCambios","urlPluginConsultas":"wp-json/modules/obtenerProductos","urlPluginVersionEcommerce":"wp-json/modules/obtenerVersion","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":123456789,"idFeed":12345678}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":-1,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":14,"hour":9,"minute":30,"second":0,"dayOfWeek":"FRIDAY","dayOfYear":73,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":null,"resultadoUltimaEjecucion":null,"habilitado":false,"tabSpreadsheet":"GShoppingAuxVentasBodegasDuquesa","numeroErrores":0},{"id":{"idConsulta":66,"idEcommerce":63},"consulta":{"id":66,"nombre":"Pedidos PS Implantación OrtoItalia","tipoConsulta":"ANALITICA","tipoEcommerce":"PRESTASHOP","versionesCompatibles":["1.7.7.1"],"consulta":"SELECT 'sp_venta' AS Tipo, SHA2(CASE WHEN COALESCE(a.phone_mobile, '') <> '' THEN CASE WHEN TRIM(a.phone_mobile) LIKE '+%' THEN TRIM(REGEXP_REPLACE(a.phone_mobile, '[^0-9+]', '')) ELSE CONCAT('+39', TRIM(REGEXP_REPLACE(a.phone_mobile, '[^0-9]', ''))) END WHEN COALESCE(a.phone, '') <> '' THEN CASE WHEN TRIM(a.phone) LIKE '+%' THEN TRIM(REGEXP_REPLACE(a.phone, '[^0-9+]', '')) ELSE CONCAT('+39', TRIM(REGEXP_REPLACE(a.phone, '[^0-9]', ''))) END ELSE '' END, 256) AS Telefono_Hash, SHA2(c.email, 256) AS Email_Hash, DATE_FORMAT(o.date_add, '%d/%m/%Y %H:%i:%s') AS Fecha, ROUND(o.total_paid, 2) AS Importe FROM prefijoTabla/orders o JOIN prefijoTabla/customer c ON o.id_customer = c.id_customer JOIN prefijoTabla/address a ON o.id_address_delivery = a.id_address JOIN prefijoTabla/order_state_lang os ON o.current_state = os.id_order_state JOIN prefijoTabla/country co ON a.id_country = co.id_country WHERE os.name IN ('Spedito', 'Consegnato') AND co.iso_code = 'IT' AND o.date_add >= DATE_SUB(NOW(), INTERVAL 90 DAY) AND o.date_add >= '2025-02-26' LIMIT 10000;"},"ecommerce":{"id":63,"nombre":"Ortoitaliana","urlEcommerce":"https://ortoitaliana.it/","tipoEcommerce":"PRESTASHOP","versionEcommerce":"1.7.7.1","habilitado":false,"idNegocioIsaga":null,"estadoNegocioIsaga":null,"prefijoMerchant":"IT","variableVariantes":"v","versionPlugin":null,"tokenApi":"bsmyqr0su69hdrx3vmv76z9me4nv8ns3191xiv7go3gscfxlrpdl3zznfmcu8carqmle4tr2ioafh4l30fj6f5lzpqk4gce9y4byobby7l9ayaby1vawpfzrr1f0mj7c82dcl4lqt1nczmgtepxwwmqxj8e3u0o4yysjjhvt7uzo1wjhji993v78d63x7txbru5frj890cukkwczgmzmmk05yhvi7spqxkbur1w1na9lsc7c67reto5fg2f2uero","urlSpreadsheetInformes":"https://docs.google.com/spreadsheets/d/1bVgC7gooH3cNsSruqQLRPOP_QIwilLYPaD_ZvpgCyKs/edit?gid=2099155284#gid=2099155284","usuarios":{"32":"creyes@idento.es","2":"clopez@idento.es","37":"eclemente@idento.es","27":"lgalan@idento.es"},"consultas":null,"stockPrecio":false,"analitica":false,"etiquetado":false,"urlPluginStockPrecio":"modules/gshoppingidento/api/index.php/changes","urlPluginConsultas":"modules/gshoppingidento/api/index.php/products","urlPluginVersionEcommerce":"modules/gshoppingidento/api/index.php/version","incidenciasNoRevisadas":0,"listadoMerchantFeeds":[{"merchantId":781760186,"idFeed":10388051967}]},"etiqueta":null,"valorEtiqueta":null,"frecuencia":1440,"proximaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":18,"hour":9,"minute":30,"second":0,"dayOfWeek":"TUESDAY","dayOfYear":77,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"ultimaEjecucion":{"nano":0,"year":2025,"monthValue":3,"dayOfMonth":17,"hour":9,"minute":36,"second":51,"dayOfWeek":"MONDAY","dayOfYear":76,"month":"MARCH","chronology":{"id":"ISO","calendarType":"iso8601"}},"resultadoUltimaEjecucion":"Se han actualizado los datos","habilitado":true,"tabSpreadsheet":"ConversionesDestinoCruda","numeroErrores":0}]"
  ]
]