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}]"
]
]
|