const INTABL_SCRIPT_VERSION = '1.0.1';
const INTABL_API = 'https://api.intabl.com/api/v1';
const INTABL_ADMIN = 'https://admin.intabl.com';
function onOpen() {
  try{intablRefreshCatalogSheets_();intablCheckIds_(false);}catch(error){console.log(error.message);}
  SpreadsheetApp.getUi().createMenu('⚙️INTABL')
    .addItem('➕ Connect store', 'connectIntablShop')
    .addItem('🏪 Open store', 'openIntablShop')
    .addItem('👤 Open dashboard', 'openIntablAdmin')
    .addItem('📑 Refresh product sheets', 'refreshIntablCatalogSheets')
    .addItem('🔄 Update catalog for Google', 'syncIntablMarketplace')
    .addItem('🔎 Check product IDs', 'checkIntablIds')
    .addSeparator()
    .addItem('📁 Configure photo folder', 'configureIntablPhotos')
    .addItem('🖼️ Update product and category photos', 'updateIntablPhotos')
    .addSeparator()
    .addItem('🔓 Check catalog access', 'checkIntablCatalogue')
    .addItem('📡 Check connection', 'checkIntablConnection').addToUi();
}
function intablRequest_(path, method, payload, token) {
  const options={method:method || 'get',muteHttpExceptions:true,followRedirects:false,headers:{'X-Intabl-Script-Version':INTABL_SCRIPT_VERSION}};
  if(payload!==undefined){options.contentType='application/json';options.payload=JSON.stringify(payload);}
  if(token){options.headers.Authorization='Bearer '+token;}
  const response=UrlFetchApp.fetch(INTABL_API+path,options);
  let result;
  try{result=JSON.parse(response.getContentText());}catch(_){throw new Error('Unexpected server response. HTTP '+response.getResponseCode());}
  if(response.getResponseCode()<200 || response.getResponseCode()>=300 || !result.success){throw new Error(result.error && (result.error.code ? 'Request failed ('+result.error.code+'). Check your connection and try again.' : 'Request failed. Try again.') || 'Connection error. HTTP '+response.getResponseCode());}
  return result.data;
}
function intablProperties_() {
  const props=PropertiesService.getScriptProperties();
  // One-time compatibility migration for existing connected spreadsheets.
  const legacy='TIIBL_',current='INTABL_',stored=props.getProperties(),migrated={};
  Object.keys(stored).filter(key=>key.indexOf(legacy)===0).forEach(key=>{
    const next=current+key.slice(legacy.length);if(stored[next]===undefined)migrated[next]=stored[key];
  });
  if(Object.keys(migrated).length)props.setProperties(migrated);
  Object.keys(stored).filter(key=>key.indexOf(legacy)===0).forEach(key=>props.deleteProperty(key));
  const id=SpreadsheetApp.getActiveSpreadsheet().getId();
  if(props.getProperty('INTABL_SHEET_ID')!==id){
    Object.keys(props.getProperties()).filter(function(key){return key.indexOf('INTABL_')===0;}).forEach(function(key){props.deleteProperty(key);});
    props.setProperty('INTABL_SHEET_ID',id);
  }
  const savedUrl=props.getProperty('INTABL_SHOP_URL') || '';
  if(/^https:\/\/[a-z0-9-]+\.2828\.pp\.ua\/?$/.test(savedUrl)){
    props.setProperty('INTABL_SHOP_URL',savedUrl.replace('.2828.pp.ua','.intabl.com'));
  }
  return props;
}
function connectIntablShop() {
  try { intablCheckCatalogue_(); }
  catch(error) { SpreadsheetApp.getUi().alert(error.message); return; }
  const lock=LockService.getScriptLock();lock.waitLock(5000);
  let connectUrl;
  try{
    const props=intablProperties_();
    intablResetRevoked_(props);
    if(props.getProperty('INTABL_CREDENTIAL')){connectUrl=INTABL_ADMIN+'/?lang=en';}
    else {
      const now=Math.floor(Date.now()/1000);
      if(!props.getProperty('INTABL_NONCE') || Number(props.getProperty('INTABL_EXPIRES') || 0)<=now){
        props.setProperties({INTABL_NONCE:Utilities.getUuid().replace(/-/g,'')+Utilities.getUuid().replace(/-/g,''),INTABL_EXPIRES:String(now+1700)});
        props.deleteProperty('INTABL_CODE');
      }
      if(!props.getProperty('INTABL_CODE')){
        const installation=intablRequest_('/installations/start','post',{
          spreadsheet_id:props.getProperty('INTABL_SHEET_ID'),nonce:props.getProperty('INTABL_NONCE'),google_access_token:ScriptApp.getOAuthToken()
        });
        props.setProperties({INTABL_CODE:installation.code,INTABL_EXPIRES:String(installation.expires_at)});
      }
      connectUrl=INTABL_ADMIN+'/connect?lang=en&code='+encodeURIComponent(props.getProperty('INTABL_CODE'));
    }
  } finally {lock.releaseLock();}
  const view=HtmlService.createTemplateFromFile('Connect');view.connectUrl=connectUrl;
  SpreadsheetApp.getUi().showModalDialog(view.evaluate().setWidth(460).setHeight(380),'INTABL');
}
function pollIntablConnection() {
  const lock=LockService.getScriptLock();lock.waitLock(5000);
  try{
    const props=intablProperties_();
    const code=props.getProperty('INTABL_CODE'),nonce=props.getProperty('INTABL_NONCE');
    if(props.getProperty('INTABL_CREDENTIAL')){
      const shop=intablRequest_('/shop/connection','get',undefined,props.getProperty('INTABL_CREDENTIAL'));
      if(shop.spreadsheet_id!==props.getProperty('INTABL_SHEET_ID')){throw new Error('This key belongs to another spreadsheet.');}
      if(code && nonce){
        try{intablRequest_('/installations/'+code+'/ack','post',{},nonce);}catch(_){/* Credential is already safely saved; acknowledgement can expire. */}
      }
      return {status:'connected',shop_url:shop.shop_url};
    }
    if(!code || !nonce){throw new Error('Run Connect store again.');}
    const status=intablRequest_('/installations/'+code+'/status','get',undefined,nonce);
    if(status.status!=='approved'){return status;}
    const shop=intablRequest_('/installations/'+code+'/claim','post',{},nonce);
    if(shop.spreadsheet_id!==props.getProperty('INTABL_SHEET_ID')){throw new Error('This connection belongs to another spreadsheet.');}
    props.setProperties({INTABL_CREDENTIAL:shop.credential,INTABL_SHOP_URL:shop.shop_url,INTABL_SHOP_ID:String(shop.shop_id)});
    // Save first, acknowledge second: losing an HTTP response must not lose the credential.
    try{intablRequest_('/installations/'+code+'/ack','post',{},nonce);}catch(_){}
    return {status:'connected',shop_url:shop.shop_url};
  } finally {lock.releaseLock();}
}
function checkIntablConnection() {
  try{
    const props=intablProperties_();
    if(props.getProperty('INTABL_CREDENTIAL')){
      const shop=intablRequest_('/shop/connection','get',undefined,props.getProperty('INTABL_CREDENTIAL'));
      if(shop.spreadsheet_id!==props.getProperty('INTABL_SHEET_ID')){throw new Error('This key belongs to another spreadsheet.');}
      SpreadsheetApp.getUi().alert('Store connected: '+shop.shop_url+'\nProducts are loaded from goods* sheets.');
    }else{intablRequest_('/ready');SpreadsheetApp.getUi().alert('The Intabl connection is working. This spreadsheet is not connected to a store yet.');}
  }catch(error){SpreadsheetApp.getUi().alert(error.message);}
}
function checkIntablCatalogue() {
  try { intablCheckCatalogue_(); SpreadsheetApp.getUi().alert('The catalog is publicly accessible. You can connect your store.'); }
  catch(error) { SpreadsheetApp.getUi().alert(error.message); }
}
function intablCheckCatalogue_() {
  const ss=SpreadsheetApp.getActiveSpreadsheet();
  const parts=intablAllGoods_();intablRefreshCatalogSheets_();
  const goods=parts[0].sheet;
  if(!goods) { throw new Error('The goods sheet is missing. Copy the store template and keep this sheet name unchanged.'); }
  const expected=['id','name','description','price','image-url','tags'];
  const headers=goods.getRange(1,1,1,6).getDisplayValues()[0];
  if(expected.some(function(name,i){return headers[i]!==name;})) {
    throw new Error('Restore the first-row headers in goods: '+expected.join(', ')+'.');
  }
  // No Authorization header: test exactly the public access required by buyers.
  const url='https://docs.google.com/spreadsheets/d/'+encodeURIComponent(ss.getId())+'/gviz/tq?sheet='+encodeURIComponent(goods.getName())+'&range=A1%3AF1&headers=0&tqx=out%3Ajson';
  const response=UrlFetchApp.fetch(url,{method:'get',muteHttpExceptions:true,followRedirects:false});
  const match=response.getContentText().match(/google\.visualization\.Query\.setResponse\(([\s\S]*)\);?\s*$/);
  let result;
  try { result=match && JSON.parse(match[1]); } catch(_) { result=null; }
  const cells=result && result.table && result.table.rows && result.table.rows[0] && result.table.rows[0].c;
  if(response.getResponseCode()!==200 || !result || result.status!=='ok' || !cells || expected.some(function(name,i){return !cells[i] || cells[i].v!==name;})) {
    throw new Error('The catalog is not publicly accessible. Choose Share → Anyone with the link → Viewer, save and try again. Keep only public catalog information in this spreadsheet. If sharing is already enabled, try again later.');
  }
  return true;
}
function openIntablShop() {
  const url=intablProperties_().getProperty('INTABL_SHOP_URL');
  if(!url){SpreadsheetApp.getUi().alert('Connect your store first.');return;}
  intablLink_(url,'Open store');
}
function openIntablAdmin(){intablLink_(INTABL_ADMIN,'Open dashboard');}
function intablResetRevoked_(props){
  const token=props.getProperty('INTABL_CREDENTIAL');if(!token)return;
  const r=UrlFetchApp.fetch(INTABL_API+'/shop/connection',{method:'get',muteHttpExceptions:true,followRedirects:false,headers:{Authorization:'Bearer '+token,'X-Intabl-Script-Version':INTABL_SCRIPT_VERSION}});
  if(r.getResponseCode()===401){
    let body;try{body=JSON.parse(r.getContentText());}catch(_){return;}
    if(body.error && body.error.code==='INVALID_CREDENTIAL'){
      ['INTABL_CREDENTIAL','INTABL_CODE','INTABL_NONCE','INTABL_EXPIRES','INTABL_SHOP_ID','INTABL_SHOP_URL'].forEach(function(k){props.deleteProperty(k);});
    }
  }
}
function intablLink_(url,label){
  if(!/^https:\/\/[a-z0-9-]+\.intabl\.com\/?$/.test(url)){throw new Error('Invalid store address.');}
  SpreadsheetApp.getUi().showModalDialog(HtmlService.createHtmlOutput('<p style="font:16px Arial;padding:20px"><a target="_blank" rel="noopener noreferrer" href="'+url+'">'+label+' ↗</a></p>').setWidth(350).setHeight(120),'INTABL');
}


// Only public sheet names. No product copies, credentials or personal data.
function intablGoodsSheets_() {
  const sheets=SpreadsheetApp.getActiveSpreadsheet().getSheets().filter(s=>s.getName().startsWith('goods'));
  if(!sheets.length)throw new Error('Add at least one sheet whose name starts with goods.');
  if(sheets.length>20)throw new Error('Up to 20 goods sheets are supported.');
  return sheets;
}
function intablCategoryParts_() {
  const sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName('category');
  if(!sheet)return [];
  const height=Math.max(1,sheet.getLastRow()),width=Math.max(1,sheet.getLastColumn());
  if(height>1001||width>26)throw new Error('category: up to 1000 categories and 26 columns.');
  const values=sheet.getRange(1,1,height,width).getValues(),headers=values.shift();
  if(!headers.some(v=>String(v).trim().toLowerCase()==='id'))throw new Error('category: missing id column');
  const idCol=headers.map(v=>String(v).trim().toLowerCase()).indexOf('id');
  values.forEach((row,index)=>{const id=String(row[idCol]??'').trim();if(['hit','new','sale'].includes(id.toLowerCase()))throw new Error('category — row '+(index+2)+': ID «'+id+' is reserved for a product badge. Change the category ID and its references in tags.');});
  return [{sheet,headers,rows:values}];
}
function intablRefreshCatalogSheets_() {
  const ss=SpreadsheetApp.getActiveSpreadsheet(),names=intablGoodsSheets_().map(s=>[s.getName()]);
  let manifest=ss.getSheetByName('_intabl_catalog');
  if(manifest && manifest.getRange(1,1).getValue()!=='intabl-catalog-v1')throw new Error('The name _intabl_catalog is reserved. Rename your sheet.');
  const rows=[['intabl-catalog-v1'],...names];
  if(manifest && JSON.stringify(manifest.getRange(1,1,Math.max(1,manifest.getLastRow()),1).getValues())===JSON.stringify(rows))return;
  if(!manifest)manifest=ss.insertSheet('_intabl_catalog');
  const writeRows=rows.concat(Array.from({length:Math.max(0,manifest.getLastRow()-rows.length)},()=>['']));
  manifest.getRange(1,1,writeRows.length,1).setValues(writeRows);
  manifest.hideSheet();
}
function refreshIntablCatalogSheets() {
  try{intablRefreshCatalogSheets_();SpreadsheetApp.getUi().alert('Product sheet list updated. Changes will appear after Google refreshes its cache.');}
  catch(error){SpreadsheetApp.getUi().alert(error.message);}
}
function onEdit(e) {
  if(!e || !e.range || !(e.range.getSheet().getName().startsWith('goods') || e.range.getSheet().getName()==='category'))return;
  intablRefreshCatalogSheets_();
  const sheet=e.range.getSheet(),headers=sheet.getRange(1,1,1,Math.max(1,sheet.getLastColumn())).getValues()[0];
  const col=headers.map(v=>String(v).trim().toLowerCase()).indexOf('id')+1;
  if(e.range.getRow()===1 || (col && e.range.getColumn()<=col && e.range.getLastColumn()>=col))intablCheckIds_(false);
}
function intablAllGoods_() {
  const sheets=intablGoodsSheets_();let count=0;
  const parts=sheets.map(sheet=>{
    const height=Math.max(1,sheet.getLastRow()),width=sheet.getLastColumn();count+=height-1;
    if(count>5000||width>26)throw new Error('Catalog: up to 5000 rows across all goods sheets and 26 columns per sheet.');
    const values=sheet.getRange(1,1,height,Math.max(1,width)).getValues(),headers=values.shift();
    const keys=headers.map(v=>String(v).trim().toLowerCase()),idCol=keys.indexOf('id');
    for(const key of ['id','name','price'])if(!keys.includes(key))throw new Error(sheet.getName()+': missing column '+key);
    return {sheet,headers,rows:values};
  });
  const checked=parts.concat(intablCategoryParts_());
  const duplicates=intablDuplicateIds_(checked);intablMarkDuplicateIds_(checked,duplicates);
  if(duplicates.length)throw new Error(intablDuplicateMessage_(duplicates));
  return parts;
}

function intablDuplicateIds_(parts){
  const ids=new Map();
  for(const part of parts){const col=part.headers.map(v=>String(v).trim().toLowerCase()).indexOf('id');if(col<0)continue;
    part.rows.forEach((row,i)=>{const id=String(row[col]??'').trim();if(!id)return;if(!ids.has(id))ids.set(id,[]);ids.get(id).push({sheet:part.sheet,row:i+2,col:col+1});});
  }
  return Array.from(ids,([id,cells])=>({id,cells})).filter(item=>item.cells.length>1);
}
function intablDuplicateMessage_(duplicates){
  return 'Duplicate product IDs:\n'+duplicates.slice(0,20).map(item=>'«'+item.id+'»: '+item.cells.slice(0,20).map(cell=>cell.sheet.getName()+' — row '+cell.row).join('; ')+(item.cells.length>20?' …':'')).join('\n')+(duplicates.length>20?'\nAnd '+(duplicates.length-20)+' more duplicate IDs.':'')+'\nFix the IDs highlighted in red. IDs must be unique across goods* and category sheets.';
}
function intablMarkDuplicateIds_(parts,duplicates){
  const marker='intabl-duplicate-id-v1',bySheet=new Map();
  duplicates.forEach(item=>item.cells.forEach(cell=>{if(!bySheet.has(cell.sheet))bySheet.set(cell.sheet,[]);bySheet.get(cell.sheet).push(cell);}));
  for(const part of parts){
    const sheet=part.sheet,old=sheet.getConditionalFormatRules();
    const rules=old.filter(rule=>{const condition=rule.getBooleanCondition();return !condition || !condition.getCriteriaValues().some(value=>String(value).includes(marker));});
    const cells=bySheet.get(sheet)||[];
    if(cells.length){
      const column=n=>{let name='';for(;n;n=Math.floor((n-1)/26))name=String.fromCharCode(65+(n-1)%26)+name;return name;};
      const ranges=sheet.getRangeList(cells.map(cell=>column(cell.col)+cell.row)).getRanges();
      rules.unshift(SpreadsheetApp.newConditionalFormatRule().whenFormulaSatisfied('=N("'+marker+'")=0').setBackground('#fce8e6').setFontColor('#b91c1c').setRanges(ranges).build());
    }
    if(cells.length || rules.length!==old.length)sheet.setConditionalFormatRules(rules);
  }
}
function intablCheckIds_(showMessage){
  const parts=intablGoodsSheets_().map(sheet=>{const height=Math.max(1,sheet.getLastRow()),width=Math.max(1,sheet.getLastColumn());const headers=sheet.getRange(1,1,1,width).getValues()[0],col=headers.map(v=>String(v).trim().toLowerCase()).indexOf('id');if(col<0)throw new Error(sheet.getName()+': missing id column');const values=height>1?sheet.getRange(2,col+1,height-1,1).getValues():[];return {sheet,headers:['id'],rows:values,actualCol:col+1};});
  for(const part of intablCategoryParts_()){part.actualCol=part.headers.map(v=>String(v).trim().toLowerCase()).indexOf('id')+1;parts.push(part);}
  const duplicates=intablDuplicateIds_(parts);duplicates.forEach(item=>item.cells.forEach(cell=>{cell.col=parts.find(part=>part.sheet===cell.sheet).actualCol;}));
  intablMarkDuplicateIds_(parts,duplicates);
  if(showMessage)SpreadsheetApp.getUi().alert(duplicates.length?intablDuplicateMessage_(duplicates):'No duplicate IDs. Checked goods* and category.');
  return duplicates;
}
function checkIntablIds(){try{intablCheckIds_(true);}catch(error){SpreadsheetApp.getUi().alert(error.message);}}


function intablOptionColumns_(headers){
 const groups=[],costs=new Map(),seen=new Set();
 for(let index=0;index<headers.length;index++){
  const match=String(headers[index]).trim().match(/^(?:(price|pice)-)?(select|radio)\s*(?::\s*(.*))?$/i);if(!match)continue;
  const kind=match[2].toLowerCase(),title=(match[3]||'').trim(),key=kind+(title?':'+title:'');
  if([...title].length>40)throw new Error('Option name is too long: '+title);
  if(match[1]){if(costs.has(key))throw new Error('Duplicate surcharge column: '+key);costs.set(key,index);}
  else{if(seen.has(key))throw new Error('Duplicate option column: '+key);seen.add(key);groups.push({key,kind,title,index});}
 }
 for(const [key,index] of costs){let group=groups.find(g=>g.key===key);
  if(!group&&!key.includes(':')){const matches=groups.filter(g=>g.kind===key);if(matches.length===1)group=matches[0];}
  if(!group||group.costIndex!==undefined)throw new Error('Ambiguous surcharge column: '+key+'. Use the same name as the option column.');group.costIndex=index;
 }
 return groups;
}
function intablProductOptions_(field,money,id,columns=null,row=null){
 const result={};
 for(const group of columns??[{key:'select',kind:'select',title:''},{key:'radio',kind:'radio',title:''}]){
  const {key,kind,title}=group;
  const raw=String(columns?row[group.index]??'':field(kind)??'').trim(),cost=columns?String(row[group.costIndex]??'').trim():(String(field('price-'+kind)??'').trim()||String(field('pice-'+kind)??'').trim());
  if(!raw){if(cost)throw new Error('Product '+id+': surcharges without '+key+'.');continue;}
  const labels=raw.split(';').map(v=>v.trim()),prices=cost?cost.split(';').map(v=>v.trim()):labels.map(()=> '0');
  if(labels.length>50||labels.some(v=>!v||[...v].length>40)||new Set(labels).size!==labels.length||prices.length!==labels.length)throw new Error('Product '+id+': check '+key+' and the number of surcharges (one per option).');
  result[key]=labels.map((label,i)=>{const extra=money(prices[i]);if(extra===null)throw new Error('Product '+id+': invalid surcharge '+key+'.');return {label,extra};});
 }
 return result;
}
// Public product index only. No descriptions, contacts, orders or credentials in rows.
function intablMarketRows_(headers, rows) {
  const keys=headers.map(function(v){return String(v).trim().toLowerCase();});
  ['id','name','price'].forEach(function(k){if(keys.indexOf(k)<0)throw new Error('Missing column in goods: '+k);});
  const field=function(row,k){const i=keys.indexOf(k);return i<0?'':row[i];};
  const columns=intablOptionColumns_(headers);
  const out=[],seen=new Set();
  rows.forEach(function(row,index){
    const id=String(field(row,'id') || '').trim(),name=String(field(row,'name') || '').trim();
    if(!id && !name)return;
    if(!id || !name || seen.has(id))throw new Error('Check the product ID and name in row '+(index+2)+'. IDs must be unique.');
    seen.add(id);
    const available=String(field(row,'available')).toLowerCase().trim(),stock=String(field(row,'stock')).trim();
    if(['false','off','no','0','ні'].indexOf(available)>=0 || (stock!=='' && Number.isFinite(Number(stock)) && Number(stock)<=0))return;
    const price=String(field(row,'price')).replace(/[\s\u00a0]/g,'').replace(',','.');
    if(!/^\d{1,8}(\.\d{1,2})?$/.test(price) || Number(price)>10000000)throw new Error('Check the price in row '+(index+2));
    const money=function(v){const x=String(v).replace(/[\s\u00a0]/g,'').replace(',','.');return /^\d{1,8}(\.\d{1,2})?$/.test(x)&&Number(x)<=10000000?Math.round(Number(x)*100):null;};
    const options=intablProductOptions_(k=>field(row,k),money,id,columns,row);
    const minimum=Math.round(Number(price)*100)+Object.values(options).reduce((sum,choices)=>sum+Math.min(...choices.map(o=>o.extra)),0);
    if(minimum>1000000000)throw new Error('Check the total price including surcharges for product '+id);
    const image=String(field(row,'image-url') || '').trim();
    const categoryIds=[...new Set(String(field(row,'tags')||'').split(/[;,|]/).map(v=>v.trim()).filter(v=>v&&!['hit','new','sale'].includes(v.toLowerCase())))];
    if(categoryIds.length>30||categoryIds.some(v=>[...v].length>128))throw new Error('Product '+id+': up to 30 categories, IDs up to 128 characters.');
    out.push({id:id,name:name,price_minor:minimum,category_ids:categoryIds,category:String(field(row,'tags') || '').trim().slice(0,120),image_url:/^https:\/\//.test(image)?image:''});
  });
  return out;
}
function syncIntablMarketplace() {
  const lock=LockService.getScriptLock();
  if(!lock.tryLock(1000)){SpreadsheetApp.getUi().alert('An update is already running. Please wait.');return;}
  let message,total=null,confirmed=0,transferStarted=false;
  try {
    const props=intablProperties_(),token=props.getProperty('INTABL_CREDENTIAL');
    if(!token)throw new Error('Connect your store first.');
    const state=intablRequest_('/marketplace/state','get',undefined,token);
    if(state.spreadsheet_id!==props.getProperty('INTABL_SHEET_ID'))throw new Error('This connection belongs to another spreadsheet.');
    intablCheckCatalogue_();
    intablRefreshCatalogSheets_();
    const categories=intablCategoryParts_().flatMap(part=>{
      const keys=part.headers.map(v=>String(v).trim().toLowerCase()),idCol=keys.indexOf('id'),nameCol=keys.indexOf('name');
      return part.rows.map(row=>({id:String(row[idCol]??'').trim(),name:String(row[nameCol]??'').trim()||String(row[idCol]??'').trim()})).filter(c=>c.id);
    });
    intablRequest_('/marketplace/categories','post',{categories:categories},token);
    const rows=intablAllGoods_().flatMap(part=>intablMarketRows_(part.headers,part.rows));
    rows.forEach(function(row){if(Utilities.newBlob(JSON.stringify(row)).getBytes().length>3000)throw new Error('Shorten the name or photo URL for product '+row.id+': the record exceeds 3000 bytes.');});
    total=rows.length;
    const digest=Utilities.computeDigest(Utilities.DigestAlgorithm.SHA_256,JSON.stringify(rows),Utilities.Charset.UTF_8).map(function(b){return ('0'+((b+256)%256).toString(16)).slice(-2);}).join('');
    const run=intablRequest_('/marketplace/start','post',{generation:state.generation,digest:digest,count:rows.length},token);
    if(run.unchanged){message='The catalog is already up to date. No upload is needed.';}
    else {
      transferStarted=true;confirmed=Math.min(rows.length,run.next_batch*20);
      const started=Date.now();
      for(let batch=run.next_batch;batch<Math.ceil(rows.length/20);batch++){
        if(Date.now()-started>220000)throw new Error('Not all products were transferred in one run.');
        intablRequest_('/marketplace/batch','post',{generation:state.generation,run_id:run.run_id,batch:batch,rows:rows.slice(batch*20,batch*20+20)},token);
        confirmed=Math.min(rows.length,(batch+1)*20);
      }
      const result=intablRequest_('/marketplace/finish','post',{generation:state.generation,run_id:run.run_id},token);
      message='Google search catalog updated. Products: '+result.count+'.'+(state.enabled?' ':' ');
    }
  } catch(error){message=error.message+(transferStarted?'\n\nConfirmed: '+confirmed+' of '+total+' products.\n'+(confirmed<total?'Still to confirm: '+(total-confirmed)+'.':'Publication needs to be completed.')+'\n\nTo continue, click OK and choose INTABL → Update catalog for Google again within 30 minutes of starting. Do not edit products during the update.\n\nProducts appear after the whole transfer finishes. An existing catalog remains visible until then.':'');}
  finally {lock.releaseLock();}
  SpreadsheetApp.getUi().alert(message);
}