feedaudit

Feed quality before publication

Audit and clean ecommerce product feeds before publishing

Find missing product fields, duplicate IDs, invalid price formats, inconsistent availability values and other common catalog errors in CSV or TSV files. Map columns, apply transparent reversible cleanup rules and export corrected product data straight from your browser.

Create an account Explore plans

Find feed data errors

Inspect a catalog export and identify incomplete attributes, duplicated identifiers, suspicious links and malformed prices. The report points to the rows that need review before you submit your products to a selling or advertising channel.

How feed audits work

Review Google Shopping feeds

Check common data-quality problems in product feeds used for Merchant Center. Feed Audit is an independent pre-validation tool; it does not connect to your Google account or guarantee feed approval.

Google Shopping feed checker

Clean CSV and TSV catalogs

Map source columns to product attributes, apply reversible normalization rules, compare changes and export new CSV files. Your routine audit runs locally: product rows are not uploaded to the cloud for processing.

CSV and TSV validator

Free audits and paid cloud plans

Begin with a free browser-based product feed audit. Starter, Pro and Agency subscriptions offer increasing limits for cloud projects, saved workflows and audit summaries. Choose monthly, six-month or annual pricing in USD. Hosted scheduled auditing is not currently part of the service.

View Starter, Pro and Agency pricing

Frequently asked questions

Do I need to upload my product catalog?

No. Standard CSV and TSV audits run in your browser and do not require a server upload of product rows. Account features may store optional project names, saved processes and aggregate audit summaries.

Does a passing result guarantee approval in Google Merchant Center?

No. Feed Audit performs independent pre-validation. Google and other sales channels set their own requirements and evaluate additional factors that cannot be checked from a local file alone.

Can agencies review multiple product feeds?

Yes. Feed Audit includes browser-based batch workflows and paid Agency capacity for a larger number of cloud projects and saved processes. Check the current plan limits before subscribing.

Catalog privacy / Privacidad del catálogo

EN: Your CSV/TSV is processed in the memory of this browser and is not uploaded. Your language preference and optionally saved rules and aggregate audit history may be stored in this browser, without product rows. Cloud accounts preview: catalogs remain local. Email authentication and optional cloud projects are available. Paid subscriptions, when enabled, are processed by Paddle.

ES: Tu CSV/TSV se procesa en la memoria del navegador y no se envía a ningún servidor. Tu preferencia de idioma y reglas e historial agregado opcionales pueden guardarse localmente, sin filas de productos. Vista previa de cuentas: los productos siguen siendo locales. Las cuentas por correo y los proyectos opcionales en la nube están disponibles. Los cobros, cuando están habilitados, se procesan mediante Paddle.

+amount+' · '+periodLabel[state.pendingPeriod]+''+tr('Create an account or sign in to continue. Your payment details will be displayed before you pay.','Crea una cuenta o inicia sesión para continuar. Verás los detalles del pago antes de pagar.')+''; } form+='

'+(recover?tr('Reset your password','Recupera tu contraseña'):register?tr('Create your account','Crea tu cuenta'):tr('Welcome back','Bienvenido de nuevo'))+'

'; form+='

'+(recover?tr('We will send a recovery link to your email.','Te enviaremos un enlace a tu correo.'):state.pendingPlan?tr('Access your account to finish your order.','Accede a tu cuenta para finalizar la compra.'):tr('Everything you need to manage your catalogs.','Gestiona tus catálogos desde un solo lugar.'))+'

'; if(!recover){ form+='
'; form+=''; form+='
'; } if(recover){ form+='
'; form+=''; }else{ form+='
'; if(register)form+=''; form+=''; form+=''; if(register)form+=''; form+='
'; if(register)form+='

'+tr('You may be asked to confirm your email.','Puede ser necesario confirmar tu correo electrónico.')+'

'; if(!register)form+=''; } content=form+''; }else{ const projects=state.cloudProjects.map(pr=>``).join(''); const listed=state.cloudProjects.map(pr=>`
  • ${h(pr.name)}
  • `).join(''); const paid=state.cloudSubscriptions.find(s=>['active','trialing'].includes(s.status) && s.current_period_end && Date.parse(s.current_period_end)>Date.now()); const tier=paid?.plan||'free'; const cloudQuota={free:[1,12,200],starter:[10,40,1000],pro:[50,200,5000],agency:[200,1000,25000]}[tier]||[3,12,200]; const planLabel=paid?tr('Active plan','Plan activo')+' '+h(paid.plan.toUpperCase()):tr('Free plan','Plan gratuito'); let planPanel=`

    ${tr('My cloud plan','Mi plan en la nube')}

    ${planLabel}

    ${tr('Projects','Proyectos')}: ${state.cloudProjects.length}/${cloudQuota[0]} · ${tr('Saved workflows','Procesos guardados')}: ${state.cloudWorkflows.length}/${cloudQuota[1]} · ${tr('Monthly audit summaries','Resúmenes mensuales')}: ${cloudQuota[2]}

    ${state.billingReady?tr('You can upgrade or manage your subscription at any time.','Puedes mejorar o gestionar tu suscripción cuando quieras.'):tr('Paid checkouts are not available yet. Cloud limits are enforced by the server, not browser buttons.','Los cobros todavía no están disponibles. Los límites se aplican en el servidor, no mediante botones del navegador.')}

    `; if(state.billingReady&&planPanel.endsWith('')){ const payButtons=paid?'':['starter','pro','agency'].map(tier=>'').join(' '); const manage=paid?'':''; planPanel=planPanel.slice(0,-6)+'
    '+payButtons+manage+'

    '+tr('Paddle shows the final price, taxes and renewal details before payment.','Paddle muestra el precio final, impuestos y condiciones de renovación antes del pago.')+'

    '; } const adminCatalogPanel=cloudClient?.user?.id==='47a1d35c-fbc8-4352-b682-b9ace8bd6e99' ?'

    '+tr('Paddle Sandbox catalog ready','Catálogo Paddle Sandbox listo')+'

    3 / 9

    '+tr('Sandbox test catalog is separate from Paddle Live subscriptions.','El catálogo Sandbox está separado de las suscripciones reales.')+'

    ' :''; const sandboxPanel=cloudClient?.user?.id==='47a1d35c-fbc8-4352-b682-b9ace8bd6e99'?('

    '+tr('Paddle test checkout','Prueba de pagos Paddle')+'

    SANDBOX

    '+tr('Test purchases only. No real money is charged and test plans never activate production subscriptions.','Solo compras simuladas. No se cobra dinero real ni se activan planes de producción.')+'

    '+['starter','pro','agency'].map(tier=>'').join(' ')+'

    '+tr('Buttons become functional after the Paddle sandbox catalog and secure keys are configured.','Los botones funcionarán cuando se configuren el catálogo y las claves seguras del sandbox de Paddle.')+'

    '):''; content=`

    ${tr('My secure projects','Mis proyectos seguros')}

    ${h(cloudClient.user.email)}

    ${link('cloud-signout',tr('Sign out','Cerrar sesión'),'btn btn-ghost')}

    ${tr('Only optional summary metrics and explicitly saved workflows are stored. Products and catalogs remain in your browser.','Solo se guardan métricas generales y procesos que autorices. Los productos y catálogos permanecen en tu navegador.')}

    ${planPanel}
    ${adminCatalogPanel}${sandboxPanel}
    ${link('cloud-refresh',tr('Refresh projects','Actualizar proyectos'),'btn btn-ghost')}

    ${tr('Your projects','Tus proyectos')}

    ${state.result&&state.cloudProjects.length?`

    ${tr('Save current audit summary to cloud','Guardar resumen actual en la nube')}

    ${tr('This action sends only counters and quality score, never the product rows.','Esta acción envía solo totales y puntuación, nunca las filas de productos.')}

    ${link('cloud-save-audit',tr('Save audit summary','Guardar resumen'),'btn btn-primary')}
    `:''}

    ${tr('Saved cloud audits','Revisiones guardadas en nube')}

    ${nf(state.cloudRuns.length)} ${tr('recent summary records','registros recientes de resumen')}

    ${tr('Cloud workflows','Procesos en la nube')}

    ${tr('Save reusable rules for a specific project. Never uploads product rows.','Guarda reglas reutilizables para un proyecto. Nunca se envían filas de productos.')}

    ${state.cloudProjects.length&&(state.table||state.savedWorkflow)?`${link('cloud-save-workflow',tr('Save current workflow','Guardar proceso actual'),'btn btn-primary')}`:''}
    `; } const recoveryOnly='

    '+tr('Choose a new password','Elige una contraseña nueva')+'

    '+tr('Enter a new password to restore access to your Feed Audit account.','Ingresa una contraseña nueva para recuperar tu cuenta de Feed Audit.')+'

    '; const planTotals={starter:{monthly:19,semiannual:99,annual:179},pro:{monthly:49,semiannual:259,annual:469},agency:{monthly:99,semiannual:529,annual:949}}; const planTotal=state.pendingPlan&&planTotals[state.pendingPlan]?planTotals[state.pendingPlan][state.pendingPeriod]:null; const planName=state.pendingPlan?state.pendingPlan[0].toUpperCase()+state.pendingPlan.slice(1):''; const planPeriod=state.pendingPeriod==='semiannual'?tr('6 months','6 meses'):state.pendingPeriod==='annual'?tr('Yearly','Anual'):tr('Monthly','Mensual'); const purchaseOnly='
    '+tr('YOUR SUBSCRIPTION','TU SUSCRIPCIÓN')+'

    '+tr('Review your plan','Revisa tu plan')+'

    '+h(planName)+' · '+h(planPeriod)+'US$'+h(planTotal)+'

    '+tr('You will see the final total before confirming.','Verás el total final antes de confirmar.')+'

    '; const selectedInfo=state.pendingPlan&&!cloudClient?.user&&!state.passwordRecovery?'
    '+tr('YOUR PLAN','TU PLAN')+''+h(planName)+' · '+h(planPeriod)+'
    US$'+h(planTotal)+'
    ':''; return `${nav()}
    ${selectedInfo}

    ${state.pendingPlan?tr('Complete your subscription','Finaliza tu contratación'):tr('My account','Mi cuenta')}

    ${link('home',tr('← Home','← Inicio'),'btn btn-ghost')}
    ${toast()}${state.passwordRecovery?recoveryOnly:(state.pendingPlan&&cloudClient?.user?purchaseOnly:content)}
    ${footer()}`; } async function completeSelectedPurchase(){ if(!state.pendingPlan||!cloudClient?.user)return; if(!['starter','pro','agency'].includes(state.pendingPlan))throw Error('Invalid selected plan.'); if(!['monthly','semiannual','annual'].includes(state.pendingPeriod))throw Error('Invalid selected period.'); if(!state.billingReady)throw Error('Secure payment is temporarily unavailable. Please retry.'); if(state.cloudSubscriptions.some(s=>['active','trialing'].includes(s.status)&&s.current_period_end&&Date.parse(s.current_period_end)>Date.now()))throw Error('You already have an active plan. Use Manage subscription.'); await cloudClient.ensureSession(); const res=await window.fetch(BILLING_ORIGIN+'/api/checkout',{method:'POST',credentials:'omit',redirect:'error',headers:{authorization:'Bearer '+cloudClient.session.access_token,'content-type':'application/json'},body:JSON.stringify({plan:state.pendingPlan,period:state.pendingPeriod})}); const data=await res.json().catch(()=>({})); if(!res.ok)throw Error(String(data.error||'Checkout unavailable.').slice(0,180)); const target=new URL(data.checkout_url); if(target.origin!==BILLING_ORIGIN||target.pathname!='/checkout'||!/^txn_[a-z0-9]{26}$/.test(target.searchParams.get('_ptxn')||''))throw Error('Invalid payment link.'); state.pendingPlan=null;sessionStorage.removeItem('fa-order-plan');sessionStorage.removeItem('fa-order-period');localStorage.removeItem('fa-order-plan');localStorage.removeItem('fa-order-period'); window.location.assign(target.href); } async function refreshCloudRecords(){ if(!cloudClient?.user)return; const [projects,runs,workflows,subscriptions]=await Promise.all([cloudClient.listProjects(),cloudClient.listRuns(),cloudClient.listWorkflows(),cloudClient.listSubscriptions()]); state.cloudProjects=Array.isArray(projects)?projects:[]; state.cloudRuns=Array.isArray(runs)?runs:[]; state.cloudWorkflows=Array.isArray(workflows)?workflows:[]; state.cloudSubscriptions=Array.isArray(subscriptions)?subscriptions:[]; try{ const res=await window.fetch(BILLING_ORIGIN+'/api/status',{method:'GET',mode:'cors',credentials:'omit',cache:'no-store',redirect:'error'}); const info=res.ok?await res.json():null; state.billingReady=Boolean(info?.acceptingPayments===true&&info?.environment==='production'); }catch{state.billingReady=false;} } function runCloud(task,done){ if(state.cloudBusy)return; state.cloudBusy=true;render(); Promise.resolve().then(task).then(()=>{message(done||tr('Cloud operation completed.','Operación en la nube completada.'));}) .catch(error=>{message(String(error.message||error),true);}) .finally(()=>{state.cloudBusy=false;render();}); } function render(){app.innerHTML=state.page==='home'?home():state.page==='upload'?uploadPage():state.page==='batch'?batchPage():state.page==='history'?historyPage():state.page==='account'?cloudAccountPage():workspace();translateUI(app,state.lang);const privacy=document.getElementById('privacy-info');if(privacy)privacy.hidden=state.page==='account';} function message(text,bad=false){state.toast=text;state.bad=bad;} function recompute(){ if(!state.table)return; const base=audit(state.table,{mapping:state.mapping}); state.originalStats=base.stats; const updated=applyRules(base.rows,state.rules); state.changes=updated.changes; state.result=audit(state.table,{mapping:state.mapping,rows:updated.rows,fields:base.fields}); if(state.previous)state.comparison=compareCatalogs(state.previous,state.result,{priceThreshold:state.changeThreshold}); } function loadPrevious(text,name){ try{const table=parseCSV(text);if(table.records.length>100000)throw new Error('This audit supports up to 100,000 data rows.'); if(autoMap(table.headers).id===undefined)throw new Error('The older catalog must contain a product ID column.'); if(state.mapping.id===undefined)throw new Error('Map a current product ID column before comparing.'); state.previous=table;state.previousName=name;state.tab='changes';recompute();message(tr('Older catalog loaded. Review the changes below.','Catálogo anterior cargado. Revisa los cambios más abajo.'));render(); }catch(err){message(err.message,true);render();} } function applyWorkflowFile(workflow){ try{const picked=resolveWorkflow(workflow,state.table.headers); if(!Object.keys(picked.mapping).length)throw new Error('This workflow has no matching columns in the current catalog.'); state.mapping=picked.mapping;state.rules=picked.rules;recompute(); message(picked.missing.length?tr(`Applied with ${picked.missing.length} missing column(s) and ${picked.omittedRules} skipped rule(s). Review mapping.`,`Aplicado con ${picked.missing.length} columna(s) faltante(s) y ${picked.omittedRules} regla(s) omitida(s). Revisa el mapeo.`):tr('Workflow applied. Review the changes before export.','Proceso aplicado. Revisa los cambios antes de exportar.'),!!picked.missing.length); state.tab=picked.missing.length?'mapping':'workflows';render(); }catch(err){message(err.message,true);render();} } function loadText(text,name){ try{const table=parseCSV(text);if(table.records.length>100000)throw new Error('This audit supports up to 100,000 data rows.'); state.table=table;state.filename=name;state.mapping=autoMap(table.headers);state.rules=[];state.previous=null;state.previousName='';state.comparison=null;state.tab='overview';state.filter='all';state.search='';state.productSearch='';state.limit=75;state.page='workspace';recompute();message(`Loaded ${nf(state.result.stats.products)} products. Analysis completed in your browser.`);render();window.scrollTo(0,0); }catch(err){state.page='upload';message(err.message,true);render();} } function download(text,filename,type='text/csv;charset=utf-8'){ const blob=new Blob([text],{type});const url=URL.createObjectURL(blob);const anchor=document.createElement('a');anchor.href=url;anchor.download=filename;document.body.append(anchor);anchor.click();anchor.remove();setTimeout(()=>URL.revokeObjectURL(url),1000); } function filename(part,ext){const clean=(state.filename||'catalog').replace(/\.(csv|tsv)$/i,'').replace(/[^a-z0-9_-]+/gi,'-').slice(0,70);return `${clean}-${part}.${ext}`;} function action(name){ if(name==='cancel-purchase'){state.pendingPlan=null;sessionStorage.removeItem('fa-order-plan');sessionStorage.removeItem('fa-order-period');localStorage.removeItem('fa-order-plan');localStorage.removeItem('fa-order-period');state.page='home';render();setTimeout(()=>document.getElementById('pricing')?.scrollIntoView(),0);return;} if(['auth-login','auth-register','auth-recover'].includes(name)){state.authMode=name.slice(5);state.toast='';render();return;} if(name&&name.startsWith('subscribe-')){const plan=name.slice(10);if(!['starter','pro','agency'].includes(plan))return;const period=document.getElementById('select-'+plan)?.value||'monthly';state.pendingPlan=plan;state.pendingPeriod=['monthly','semiannual','annual'].includes(period)?period:'monthly';sessionStorage.setItem('fa-order-plan',plan);sessionStorage.setItem('fa-order-period',state.pendingPeriod);localStorage.setItem('fa-order-plan',plan);localStorage.setItem('fa-order-period',state.pendingPeriod);state.page='account';state.toast='';if(cloudClient?.user){runCloud(async()=>{await refreshCloudRecords();await completeSelectedPurchase();},tr('Opening secure checkout…','Abriendo el pago seguro…'));}else{render();}window.scrollTo(0,0);return;} if(name==='continue-purchase'&&cloudClient?.user){runCloud(async()=>{await refreshCloudRecords();await completeSelectedPurchase();},tr('Opening secure checkout…','Abriendo el pago seguro…'));return;} if(name==='lang'){state.lang=state.lang==='en'?'es':'en';saveLocale(state.lang);render();return;} if(name==='home'){state.page='home';state.toast='';render();window.scrollTo(0,0);return;} if(['features','pricing','how'].includes(name)){state.page='home';render();setTimeout(()=>document.getElementById(name==='how'?'how-it-works':name)?.scrollIntoView(),0);return;} if(name==='account'){state.page='account';state.toast='';render();window.scrollTo(0,0);return;} if(name==='cloud-signout' && cloudClient){runCloud(async()=>{await cloudClient.signOut();state.cloudProjects=[];state.cloudRuns=[];state.cloudWorkflows=[];state.cloudSubscriptions=[];state.billingReady=false;},tr('Signed out.','Sesión cerrada.'));return;} if(name==='cloud-refresh' && cloudClient?.user){runCloud(refreshCloudRecords,tr('Projects updated.','Proyectos actualizados.'));return;} if(name==='sandbox-create-catalog' && cloudClient?.user?.id==='47a1d35c-fbc8-4352-b682-b9ace8bd6e99'){ runCloud(async()=>{ await cloudClient.ensureSession(); const res=await window.fetch(PADDLE_SANDBOX_ORIGIN+'/api/catalog/bootstrap',{method:'POST',mode:'cors',credentials:'omit',redirect:'error',headers:{authorization:'Bearer '+cloudClient.session.access_token,'content-type':'application/json'},body:'{}'}); const result=await res.json().catch(()=>({})); if(!res.ok)throw Error(String(result.error||'Paddle catalog setup failed').slice(0,190)); if(result.products!==3||result.prices!==9||Object.keys(result.catalog?.prices||{}).length!==9)throw Error('Paddle catalog returned an incomplete price map.'); state.sandboxCatalog=result.catalog; },tr('Paddle Sandbox catalog ready: 3 products and 9 prices.','Catálogo Paddle Sandbox listo: 3 productos y 9 precios.')); return; } if(name.startsWith('sandbox-buy-') && cloudClient?.user){ const tier=name.slice('sandbox-buy-'.length); if(!['starter','pro','agency'].includes(tier))return; const selectedPeriod=document.getElementById('billing-period')?.value||'monthly'; runCloud(async()=>{ await cloudClient.ensureSession(); const res=await window.fetch(PADDLE_SANDBOX_ORIGIN+'/api/checkout',{method:'POST',mode:'cors',credentials:'omit',redirect:'error',headers:{'authorization':'Bearer '+cloudClient.session.access_token,'content-type':'application/json'},body:JSON.stringify({plan:tier,period:selectedPeriod})}); const obj=await res.json().catch(()=>({})); if(!res.ok)throw Error(String(obj.error||'Sandbox checkout is not configured yet.').slice(0,200)); const url=new URL(obj.checkout_url); if(url.origin!==PADDLE_SANDBOX_ORIGIN||url.pathname!='/checkout'||!/^txn_[a-z0-9]{26}$/.test(url.searchParams.get('_ptxn')||''))throw Error('Invalid sandbox checkout URL.'); window.location.assign(url.href); },tr('Opening Paddle sandbox','Abriendo Paddle sandbox'));return; } if(name.startsWith('billing-') && cloudClient?.user){ if(!state.billingReady)return; const kind=name==='billing-portal'?'portal':'checkout'; const tier=kind==='checkout'?name.slice(8):null; if(kind==='checkout'&&!['starter','pro','agency'].includes(tier))return; const selectedPeriod=document.getElementById('billing-period')?.value||'monthly'; runCloud(async()=>{ await cloudClient.ensureSession(); const res=await window.fetch(BILLING_ORIGIN+'/api/'+kind,{method:'POST',mode:'cors',credentials:'omit',redirect:'error',headers:{'authorization':'Bearer '+cloudClient.session.access_token,'content-type':'application/json'},body:JSON.stringify(kind==='checkout'?{plan:tier,period:selectedPeriod}:{})}); const body=await res.json().catch(()=>({})); if(!res.ok)throw Error(String(body.error||'Payment service is unavailable.').slice(0,180)); const target=new URL(kind==='checkout'?body.checkout_url:body.portal_url); const valid=kind==='checkout'?(target.origin===BILLING_ORIGIN&&target.pathname==='/checkout'&&/^txn_[a-z0-9]{26}$/.test(target.searchParams.get('_ptxn')||'')):(target.protocol==='https:'&&['customer-portal.paddle.com','sandbox-customer-portal.paddle.com'].includes(target.hostname)); if(!valid)throw Error('Untrusted billing URL.'); window.location.assign(target.href); },tr('Opening secure payment…','Abriendo el pago seguro…'));return; } if(name==='cloud-save-workflow'&&cloudClient?.user){ const projectId=document.getElementById('cloud-workflow-project')?.value; runCloud(async()=>{ const workflow=state.table?createWorkflow(state.table.headers,state.mapping,state.rules,state.savedWorkflow?.name||'Feed Audit workflow'):state.savedWorkflow; if(!workflow)throw new Error('Load a catalog or saved local workflow first.'); await cloudClient.saveWorkflow(projectId,readWorkflow(JSON.stringify(workflow))); await refreshCloudRecords(); },tr('Workflow saved for this project.','Proceso guardado para este proyecto.'));return; } if(name==='cloud-load-workflow'&&cloudClient?.user){ const item=state.cloudWorkflows.find(w=>w.id===state.selectedCloudWorkflowId); if(item?.definition&&state.table)applyWorkflowFile(readWorkflow(JSON.stringify(item.definition))); return; } if(name==='cloud-delete-workflow'&&cloudClient?.user){ const id=state.selectedCloudWorkflowId; if(!id||!window.confirm(tr('Remove this cloud workflow?','¿Eliminar este proceso de la nube?')))return; runCloud(async()=>{await cloudClient.deleteWorkflow(id);await refreshCloudRecords();},tr('Cloud workflow deleted.','Proceso eliminado de la nube.'));return; } if(name==='cloud-save-audit' && cloudClient?.user && state.result){ const projectId=document.getElementById('cloud-project-select')?.value; const status=evaluatePreflight(state.result,{comparison:state.comparison}).status; runCloud(async()=>{await cloudClient.saveAudit(projectId,state.result.stats,status);await refreshCloudRecords();},tr('Aggregate metrics saved securely. No product rows uploaded.','Métricas guardadas. No se enviaron productos.'));return; } if(name==='upload'){state.page='upload';state.toast='';render();window.scrollTo(0,0);return;} if(name==='batch'){state.page='batch';state.toast='';render();window.scrollTo(0,0);return;} if(name==='history'){if(state.result){state.page='workspace';state.tab='history';}else{state.page='history';}state.toast='';render();window.scrollTo(0,0);return;} if(name==='history-back'){state.page='workspace';state.tab='overview';render();return;} if(name==='history-save'){ if(!state.result){message(tr('Load a catalog before saving an audit.','Carga un catálogo antes de guardar una revisión.'),true);render();return;} try{ const project=document.getElementById('history-project')?.value||''; const preflight=evaluatePreflight(state.result,{comparison:state.comparison}); const record=makeSnapshot({project,stats:state.result.stats,status:preflight.status}); const updated=addHistoryRecord(state.history,record); localStorage.setItem(HISTORY_STORAGE_KEY,JSON.stringify(updated)); state.history=updated;message(tr('Audit totals saved locally. No product rows were stored.','Totales de auditoría guardados localmente. No se almacenaron productos.')); }catch(error){message(String(error.message||error),true);}render();return; } if(name==='history-delete'){ const id=state.historyDeletingId; if(!id)return; try{const updated=state.history.filter(r=>r.id!==id);localStorage.setItem(HISTORY_STORAGE_KEY,JSON.stringify(updated));state.history=updated;message(tr('One snapshot deleted.','Se eliminó una revisión.'));} catch(error){message(error.message,true);}state.historyDeletingId=null;render();return; } if(name==='history-clear'){ if(!window.confirm(tr('Delete all audit history stored in this browser? This cannot be undone.','¿Eliminar todo el historial guardado en este navegador? No se puede deshacer.')))return; try{localStorage.removeItem(HISTORY_STORAGE_KEY);state.history=[];message(tr('Local history deleted.','Historial local eliminado.'));}catch(error){message(error.message,true);}render();return; } if(name==='history-csv'){download(exportHistoryCSV(state.history),'feed-audit-history.csv');return;} if(name==='history-json'){download(exportHistoryJSON(state.history),'feed-audit-history-backup.json','application/json;charset=utf-8');return;} if(name==='batch-example'){try{state.batchResult=auditBatch([{name:'shop-one.csv',content:EXAMPLE_CSV},{name:'shop-two.csv',content:EXAMPLE_CSV.replaceAll('SKU-','CAT-')}],{language:state.lang});message(tr('Example agency batch complete. Download the ZIP to inspect reports.','Lote de agencia listo. Descarga el ZIP para revisar los informes.'));}catch(err){message(err.message,true)}render();return;} if(name==='batch-download'&&state.batchResult){download(state.batchResult.zip,'feed-audit-agency-batch.zip','application/zip');return;} if(name==='sample'){loadText(EXAMPLE_CSV,'sample-product-feed.csv');return;} if(name==='template'){download(EXAMPLE_CSV,'feed-audit-sample.csv');return;} if(name==='previous-sample'){loadPrevious(PREVIOUS_SAMPLE_CSV,'example-previous-feed.csv');return;} if(name==='workflow-forget'){try{localStorage.removeItem(WORKFLOW_STORAGE_KEY);state.savedWorkflow=null;message(tr('Saved workflow removed from this browser.','Proceso guardado eliminado de este navegador.'));}catch{message(tr('Browser storage is unavailable.','No se puede acceder al almacenamiento local.'),true);}render();return;} if(name==='workflow-load'&&state.savedWorkflow){applyWorkflowFile(state.savedWorkflow);return;} if(name==='workflow-export'||name==='workflow-save'){ try{const customName=document.getElementById('workflow-name')?.value||'My catalog workflow'; const workflow=createWorkflow(state.table.headers,state.mapping,state.rules,customName); if(name==='workflow-save'){localStorage.setItem(WORKFLOW_STORAGE_KEY,JSON.stringify(workflow));state.savedWorkflow=workflow;message(tr('Workflow saved locally in this browser.','Proceso guardado localmente en este navegador.'));render();} else download(JSON.stringify(workflow,null,2),filename('workflow','json'),'application/json;charset=utf-8'); }catch(err){message(err.message,true);render();}return; } if(name==='change-report'&&state.comparison){download(changeReportCSV(state.comparison),filename('changes','csv'));return;} if(name==='viewissues'){state.tab='issues';render();return;} if(name==='moreissues'){state.limit+=75;render();return;} if(name==='undorule'&&state.rules.length){state.rules.pop();recompute();message('Last rule removed. The catalog has been recalculated from the original file.');render();return;} if(!state.result)return; if(name==='exportcsv'||name==='safeexport'){const safe=name==='safeexport';download(encodeCSV(state.result.rows,state.result.fields,{spreadsheetSafe:safe}),filename(safe?'spreadsheet-safe':'normalized','csv'));return;} if(name==='issuescsv'){download(issuesCSV(state.result.issues),filename('issues','csv'));return;} if(name==='preflightcsv'){download(preflightCSV(evaluatePreflight(state.result,{comparison:state.comparison})),filename('preflight','csv'));return;} if(name==='exporthtml'){download(renderAuditReport({result:state.result,source:state.filename,originalStats:state.originalStats,comparison:state.comparison,language:state.lang} ),filename('report','html'),'text/html;charset=utf-8');return;} if(name==='exportjson'){download(JSON.stringify({meta:{source:state.filename,createdAt:new Date().toISOString(),sourceRows:state.table.records.length,localOnly:true,disclaimer:caption},stats:state.result.stats,preflight:evaluatePreflight(state.result,{comparison:state.comparison}),mapping:state.mapping,issues:state.result.issues,rules:state.rules,changes:state.changes},null,2),filename('audit','json'),'application/json;charset=utf-8');} } app.addEventListener('click',e=>{ const el=e.target.closest('[data-action],[data-tab]');if(!el)return; if(el.matches('a'))e.preventDefault(); if(el.dataset.tab){state.tab=el.dataset.tab;state.toast='';render();return;} if(el.dataset.action==='history-delete')state.historyDeletingId=el.dataset.recordId; if(['cloud-load-workflow','cloud-delete-workflow'].includes(el.dataset.action))state.selectedCloudWorkflowId=el.dataset.workflowId; action(el.dataset.action); }); app.addEventListener('change',e=>{ if(e.target.dataset.planSelect){const plan=e.target.dataset.planSelect,period=e.target.value;const prices={starter:{monthly:19,semiannual:99,annual:179},pro:{monthly:49,semiannual:259,annual:469},agency:{monthly:99,semiannual:529,annual:949}};if(!prices[plan]||!Object.hasOwn(prices[plan],period))return;const amount=document.getElementById('plan-price-'+plan),cycle=document.getElementById('plan-cycle-'+plan);if(amount)amount.textContent=String(prices[plan][period]);if(cycle)cycle.textContent=period==='semiannual'?tr('every 6 months','cada 6 meses'):period==='annual'?tr('per year','al año'):tr('per month','al mes');return;} if(e.target.id==='history-import'){const f=e.target.files?.[0];if(!f)return;if(f.size>200000){message(tr('History backup exceeds 200 KB.','La copia supera 200 KB.'),true);render();return;}f.text().then(text=>{const imported=importHistoryJSON(text);const updated=sanitizeHistory([...imported,...state.history]);localStorage.setItem(HISTORY_STORAGE_KEY,JSON.stringify(updated));state.history=updated;message(tr('Aggregate history imported locally.','Historial de totales importado localmente.'));render();}).catch(error=>{message(String(error.message||error),true);render();});return;} if(e.target.id==='batch-input'){const items=Array.from(e.target.files||[]);if(!items.length)return; if(items.length>BATCH_LIMITS.files||items.some(f=>f.size>BATCH_LIMITS.eachBytes)||items.reduce((n,f)=>n+f.size,0)>BATCH_LIMITS.totalBytes){message(tr('Maximum: 8 files, 5 MB each, 24 MB combined.','Máximo: 8 archivos, 5 MB cada uno y 24 MB en total.'),true);render();return;} state.batchBusy=true;message(tr('Auditing catalogs in your browser…','Revisando catálogos en tu navegador…'));render(); Promise.all(items.map(async f=>({name:f.name,content:await f.text()}))).then(entries=>{state.batchResult=auditBatch(entries,{language:state.lang});message(tr('Batch processed. Download the ZIP with all results.','Lote procesado. Descarga el ZIP con todos los resultados.'));}).catch(err=>message(String(err.message||err),true)).finally(()=>{state.batchBusy=false;render();});return;} if(e.target.id==='csv-input'){ const f=e.target.files?.[0];if(!f)return; if(f.size>MAX_BYTES){message('Files up to 15 MB are supported.',true);render();return;} f.text().then(t=>loadText(t,f.name)).catch(()=>{message('Unable to read this local file.',true);render();});return; } if(e.target.id==='previous-feed-input'){const f=e.target.files?.[0];if(!f)return;if(f.size>MAX_BYTES){message('Files up to 15 MB are supported.',true);render();return;}f.text().then(t=>loadPrevious(t,f.name)).catch(()=>{message('Unable to read this local file.',true);render();});return;} if(e.target.id==='workflow-import-input'){const f=e.target.files?.[0];if(!f)return;if(f.size>100000){message('Workflow file is too large.',true);render();return;}f.text().then(t=>applyWorkflowFile(readWorkflow(t))).catch(err=>{message(err.message,true);render();});return;} if(e.target.id==='change-threshold'){state.changeThreshold=Number(e.target.value);if(state.previous)recompute();render();return;} if(e.target.dataset.map){const field=e.target.dataset.map;const selected=e.target.value; if(selected==='')delete state.mapping[field];else state.mapping[field]=Number(selected); state.rules=[];recompute();message('Field mapping updated. Cleanup rules have been cleared to prevent unintended changes.');render();return; } if(e.target.id==='issue-filter'){state.filter=e.target.value;state.limit=75;render();return;} }); app.addEventListener('input',e=>{ if(e.target.id==='issue-search'||e.target.id==='product-search'){ const field=e.target.id==='issue-search'?'search':'productSearch';state[field]=e.target.value; const selection=e.target.selectionStart;render(); const next=document.getElementById(e.target.id);if(next){next.focus();next.setSelectionRange(selection,selection);} } }); app.addEventListener('submit',e=>{ if(['cloud-credentials-form','cloud-recovery-form','cloud-password-reset-form','cloud-project-form'].includes(e.target.id)){ e.preventDefault(); if(!cloudClient)return; const form=new FormData(e.target); if(e.target.id==='cloud-credentials-form'){ const email=String(form.get('email')||'').trim(),pass=String(form.get('password')||''); state.cloudEmail=email; if(state.authMode==='register'){ if(pass.length<8||pass.length>72){message(tr('Use a password with 8 to 72 characters.','Usa una contraseña de 8 a 72 caracteres.'),true);render();return;} if(pass!==String(form.get('confirm_password')||'')){message(tr('Passwords do not match.','Las contraseñas no coinciden.'),true);render();return;} const name=String(form.get('display_name')||'').trim().slice(0,80); runCloud(async()=>{const active=await cloudClient.signUpWithPassword(email,pass,name);if(active){await refreshCloudRecords();await completeSelectedPurchase();}else{state.authMode='login';}},tr('Account created. Please verify your email, then sign in.','Cuenta creada. Confirma tu correo y luego inicia sesión.')); }else{ runCloud(async()=>{await cloudClient.signInWithPassword(email,pass);await refreshCloudRecords();await completeSelectedPurchase();},tr('Welcome back to Feed Audit.','Bienvenido de nuevo a Feed Audit.')); } }else if(e.target.id==='cloud-recovery-form'){ const email=String(form.get('email')||'').trim();state.cloudEmail=email; runCloud(async()=>{await cloudClient.sendRecovery(email);state.authMode='login';},tr('If the account exists, a recovery link will arrive by email.','Si la cuenta existe, llegará un enlace de recuperación a tu correo.')); }else if(e.target.id==='cloud-password-reset-form'&&cloudClient.user&&state.passwordRecovery){ const pass=String(form.get('password')||''),confirm=String(form.get('confirm_password')||''); if(pass.length<8||pass.length>72||pass!==confirm){message(tr('Check the new password and confirmation (8–72 characters).','Comprueba la contraseña nueva y su confirmación (8 a 72 caracteres).'),true);render();return;} runCloud(async()=>{await cloudClient.setNewPassword(pass);state.passwordRecovery=false;await refreshCloudRecords();await completeSelectedPurchase();},tr('Password updated. Your account is ready.','Contraseña actualizada. Tu cuenta está lista.')); }else if(e.target.id==='cloud-project-form'){ const name=String(form.get('name')||''); runCloud(async()=>{await cloudClient.addProject(name);await refreshCloudRecords();},tr('Project created.','Proyecto creado.')); } return; } if(e.target.id!=='rule-form')return;e.preventDefault(); const data=new FormData(e.target);const rule=Object.fromEntries(data.entries()); if(rule.action==='normalize_availability'&&rule.field!=='availability'){message('Normalize availability can only operate on the availability attribute.',true);render();return;} if(['equals','contains'].includes(rule.filter)&&!rule.match){message('Enter match text for this condition.',true);render();return;} if(rule.action==='replace'&&!rule.find){message('Enter text to find before applying a replacement rule.',true);render();return;} if(['prefix','suffix','set_if_empty'].includes(rule.action)&&!rule.value){message('Enter a value for this rule.',true);render();return;} state.rules.push(rule); try{recompute();message(`Rule added. ${nf(state.changes.length)} total value changes are now included in the preview.`);render();} catch(err){state.rules.pop();recompute();message(err.message,true);render();} }); app.addEventListener('dragover',e=>{if(e.target.closest('#drop-zone')){e.preventDefault();e.target.closest('#drop-zone').classList.add('drag');}}); app.addEventListener('dragleave',e=>{if(e.target.closest('#drop-zone'))e.target.closest('#drop-zone').classList.remove('drag');}); app.addEventListener('drop',e=>{const zone=e.target.closest('#drop-zone');if(!zone)return;e.preventDefault();zone.classList.remove('drag');const f=e.dataTransfer?.files?.[0];if(!f)return;if(f.size>MAX_BYTES){message('Files up to 15 MB are supported.',true);render();return;}f.text().then(t=>loadText(t,f.name)).catch(()=>{message('Unable to read this local file.',true);render();});}); app.addEventListener('keydown',e=>{if(e.target.id==='drop-zone'&&(e.key==='Enter'||e.key===' ')){e.preventDefault();document.getElementById('csv-input')?.click();}}); // Complete an email magic link if Supabase redirects to this exact URL. // Remove URL fragments immediately, before doing any asynchronous request. if(cloudClient&&typeof window!=='undefined'){ const callbackHash=window.location.hash; if(callbackHash.includes('access_token=')||callbackHash.includes('error=')){ window.history.replaceState(null,'',window.location.pathname+window.location.search); state.page='account'; try{ if(cloudClient.consumeMagicLinkFragment(callbackHash)){ state.passwordRecovery=new URLSearchParams(callbackHash.slice(1)).get('type')==='recovery'; runCloud(async()=>{await cloudClient.validateUser();await refreshCloudRecords();if(!state.passwordRecovery)await completeSelectedPurchase();},tr('Email verified. Welcome to Feed Audit.','Correo verificado. Bienvenido a Feed Audit.')); } }catch(error){message(String(error.message||error),true);} }else if(cloudClient.session){ state.page='account'; runCloud(async()=>{await cloudClient.validateUser();await refreshCloudRecords();await completeSelectedPurchase();},tr('Session restored.','Sesión recuperada.')); } } render(); })();