{"id":661,"date":"2026-04-04T20:18:35","date_gmt":"2026-04-04T16:18:35","guid":{"rendered":"https:\/\/hostatto.com\/?p=661"},"modified":"2026-06-18T12:56:23","modified_gmt":"2026-06-18T08:56:23","slug":"fix-missing-category-ids-invalid-store-id","status":"publish","type":"post","link":"https:\/\/hostatto.com\/blog\/fix-missing-category-ids-invalid-store-id.html","title":{"rendered":"Store Import\/Export Tool:  Fix Missing category_ids and Invalid store_id Errors"},"content":{"rendered":"<div class=\"minimalist-article\">\n<p>If you are encountering errors while importing categories into <strong><a href=\"https:\/\/hostatto.com\/\" target=\"_blank\" rel=\"noopener\">Hostatto<\/a><\/strong>, it usually means your spreadsheet has formatting issues or data mismatches between tabs. This guide provides a step-by-step solution for the following common error logs:<\/p>\n<ul>\n<li><code>Export\/Import: Missing category_ids in worksheet 'CategorySEOKeywords'!<\/code><\/li>\n<li><code>Export\/Import: Invalid store_id='' used in worksheet 'CategorySEOKeywords'!<\/code><\/li>\n<\/ul>\n<hr \/>\n<h3>1. Removing \"Ghost\" Rows<\/h3>\n<p>The error <b><code>Invalid store_id=''<\/code><\/b> (empty store_id) almost always indicates \"invisible\" activity in the file below your actual data rows. The importer detects these empty cells and expects valid data, resulting in a failure.<\/p>\n<ul>\n<li><b>The Issue:<\/b> Your spreadsheet might have residual formatting in the rows below your data (e.g., from row 13 to 1000).<\/li>\n<li><b>The Action:<\/b> Select all rows below your last category (e.g., from row 13 to the very bottom).<\/li>\n<li><b>The Method:<\/b> Right-click the selected row numbers and choose <b>\"Delete Rows\"<\/b>.<\/li>\n<\/ul>\n<blockquote><p><b>Note:<\/b> Simply pressing <code>Backspace<\/code> or <code>Delete<\/code> on your keyboard is not enough. You must physically remove the rows from the spreadsheet structure to clear the \"ghost\" data.<\/p><\/blockquote>\n<h3>2. Filling Mandatory Fields<\/h3>\n<p>The module requires a corresponding row in the <b>CategorySEOKeywords<\/b> tab for every category listed in the main <b>Categories<\/b> tab. If a row is missing or a cell is empty, you will see the <b><code>Missing category_ids<\/code><\/b> error.<\/p>\n<ul>\n<li><b>category_id:<\/b> Ensure all IDs listed in the <b>Categories<\/b> tab are also present here. If you have 11 categories total, you must have exactly 11 rows in the SEO tab.<\/li>\n<li><b>store_id:<\/b> Every category must have a <b>0<\/b> in the <code>store_id<\/code> column (representing the default store). The <code>Invalid store_id=''<\/code> error confirms that this cell was left blank.<\/li>\n<li><b>keyword:<\/b> This column must exist. We recommend filling it with Latin characters (e.g., <code>laptops<\/code>, <code>phones<\/code>), as the tool may reject the file if the keyword field is entirely empty.<\/li>\n<\/ul>\n<h3>3. Data Consistency and Matching<\/h3>\n<p>If your <b>Categories<\/b> tab uses updated IDs (e.g., <code>1, 2, 3... 11<\/code>), but the <b>CategorySEOKeywords<\/b> tab still contains old IDs (like 25, 26, etc.) or they are out of order, the system will trigger a mismatch error.<\/p>\n<ul>\n<li><b>Sync:<\/b> Always update the IDs on all secondary tabs (<code>CategoryFilters<\/code>, <code>CategorySEOKeywords<\/code>) whenever you change them on the main tab.<\/li>\n<li><b>Sort:<\/b> O\u0441art requires IDs to be in <b>ascending order<\/b> (1, 2, 3...). Use the \"Sort A-Z\" feature on the <code>category_id<\/code> column for every tab in your file.<\/li>\n<\/ul>\n<hr \/>\n<h3>Final Pre-Upload Checklist<\/h3>\n<ul>\n<li>The <b>CategorySEOKeywords<\/b> tab has the exact same number of rows as the <b>Categories<\/b> tab.<\/li>\n<li>The <b>store_id<\/b> column is filled with <b>0<\/b> (no empty cells).<\/li>\n<li>All rows are sorted by <b>category_id<\/b> in ascending order.<\/li>\n<li>All empty \"ghost\" rows below the table have been physically deleted.<\/li>\n<\/ul>\n<p>By ensuring the IDs match across all tabs and removing hidden empty rows, your category import should complete successfully.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>...<\/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,92,86,90,87],"class_list":["post-661","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-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\/661","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=661"}],"version-history":[{"count":9,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts\/661\/revisions"}],"predecessor-version":[{"id":782,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/posts\/661\/revisions\/782"}],"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=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/categories?post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostatto.com\/blog\/wp-json\/wp\/v2\/tags?post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}