{"id":636,"date":"2026-04-04T16:12:51","date_gmt":"2026-04-04T12:12:51","guid":{"rendered":"https:\/\/hostatto.com\/?p=636"},"modified":"2026-06-17T16:13:59","modified_gmt":"2026-06-17T12:13:59","slug":"launch-your-online-store-in-1-hour-automated-product-management-via-google-sheets","status":"publish","type":"post","link":"https:\/\/hostatto.com\/blog\/launch-your-online-store-in-1-hour-automated-product-management-via-google-sheets.html","title":{"rendered":"Launch Your Online Store in 1 Hour: Automated Product Management via Google Sheets"},"content":{"rendered":"

Stop wasting days on manual data entry. With hostatto.com<\/a><\/b>, you can build a professional online store and manage your entire inventory directly from Google Sheets<\/b> using our automated synchronization technology.<\/p>\n

Changing product IDs or updating thousands of items shouldn't be a headache. This guide shows you how to use our \"drag-and-fill\" method to keep your entire database perfectly synchronized.<\/p>\n

Step-by-Step Instructions<\/h2>\n

1. Install the Automation Script<\/h3>\n
    \n
  • Open your inventory Google Sheet.<\/li>\n
  • Navigate to Extensions<\/b> > Apps Script<\/b>.<\/li>\n
  • Delete any existing code and paste the Bulk ID Updater<\/b> script provided below.<\/li>\n<\/ul>\n
    function onOpen() {\r\n  SpreadsheetApp.getUi()\r\n    .createMenu('ID Management')\r\n    .addItem('Bulk Update IDs', 'bulkUpdateIds')\r\n    .addToUi();\r\n}\r\n\r\nfunction bulkUpdateIds() {\r\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\r\n  const sheet = ss.getSheets()[0];\r\n  \r\n  const lr = sheet.getLastRow();\r\n  if (lr < 2) return;\r\n\r\n  const data = sheet.getRange(2, 1, lr - 1, 2).getValues();\r\n  const idMap = {};\r\n  let hasChanges = false;\r\n\r\n  for (let i = 0; i < data.length; i++) { const oldId = String(data[i][0]).trim(); const newId = String(data[i][1]).trim(); if (oldId && newId && oldId !== newId) { idMap[oldId] = newId; hasChanges = true; } } if (!hasChanges) { SpreadsheetApp.getUi().alert(\"No new IDs detected. Please fill Column B with your new IDs.\"); return; } const allSheets = ss.getSheets(); allSheets.forEach(targetSheet => {\r\n    if (targetSheet.getName() === sheet.getName()) return;\r\n    \r\n    const targetLr = targetSheet.getLastRow();\r\n    if (targetLr > 1) {\r\n      const targetRange = targetSheet.getRange(2, 1, targetLr - 1, 1);\r\n      const values = targetRange.getValues();\r\n      let changed = false;\r\n\r\n      for (let i = 0; i < values.length; i++) { const currentId = String(values[i][0]).trim(); if (idMap[currentId]) { values[i][0] = idMap[currentId]; changed = true; } } if (changed) targetRange.setValues(values); } }); const finalColumnA = data.map(row => [row[1] !== \"\" ? row[1] : row[0]]);\r\n  sheet.getRange(2, 1, finalColumnA.length, 1).setValues(finalColumnA);\r\n  sheet.deleteColumn(2);\r\n  \r\n  SpreadsheetApp.getUi().alert(\"Success! Your online store database is synchronized.\");\r\n}\r\n<\/pre>\n
      \n
    • Click Save<\/b> and name it \"Store ID Manager\".<\/li>\n<\/ul>\n
      2. Refresh & Initialize<\/h3>\n
        \n
      • Refresh your browser tab.<\/li>\n
      • A new menu called ID Management<\/b> will appear at the top navigation bar.<\/li>\n<\/ul>\n
        3. Mass Update Your Products<\/h3>\n
          \n
        • On your main product sheet, right-click Column A<\/b> (product_id<\/code>) and select Insert 1 column right<\/b>.<\/li>\n
        • In the new Column B<\/b>, enter your new ID sequence.<\/li>\n
        • Note:<\/b> Keep the old IDs in Column A<\/b> so the script can find and update them.<\/li>\n<\/ul>\n
          4. Run the Sync<\/h3>\n
            \n
          • Click ID Management<\/b> > Bulk Update IDs<\/b>.<\/li>\n
          • The script will instantly update every page of your store's database.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
            ...<\/p>\n","protected":false},"author":1,"featured_media":771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84],"tags":[89,88,91,93,85,92,86,90,87],"class_list":["post-636","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ecommerce-usa","tag-create-online-shop","tag-e-commerce","tag-google-sheets","tag-import-excel","tag-ocart","tag-online-store","tag-online-store-builder","tag-shopify-alternative","tag-small-business-tools"],"_links":{"self":[{"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts\/636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/comments?post=636"}],"version-history":[{"count":17,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":680,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts\/636\/revisions\/680"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/media\/771"}],"wp:attachment":[{"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/media?parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/categories?post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/tags?post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}