<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Mohammad</title>
    <description>The latest articles on DEV Community by Mohammad (@shoplocalnotes).</description>
    <link>https://dev.to/shoplocalnotes</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4205164%2F9546641b-bee3-4e8d-b551-5046860a3408.png</url>
      <title>DEV Community: Mohammad</title>
      <link>https://dev.to/shoplocalnotes</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/shoplocalnotes"/>
    <language>en</language>
    <item>
      <title>Your Search Console Export Hides Two-Thirds of Your Queries: A pandas Festival Calendar for 2027</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Sun, 01 Nov 2026 03:44:40 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/your-search-console-export-hides-two-thirds-of-your-queries-a-pandas-festival-calendar-for-2027-30hb</link>
      <guid>https://dev.to/shoplocalnotes/your-search-console-export-hides-two-thirds-of-your-queries-a-pandas-festival-calendar-for-2027-30hb</guid>
      <description>&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;&lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ&lt;/a&gt; is a small hyperlocal marketplace: shoppers find clothing shops near them, and shop owners list for free. Like most small sites, it has no analytics team. What it does have is a Google Search Console export: one &lt;code&gt;.xlsx&lt;/code&gt; file with the last 30 days to 27 October 2026.&lt;/p&gt;

&lt;p&gt;This post is the notebook I used to turn that one file into a content calendar for the 2026-27 festival and wedding season. All numbers below come from that export. The code works on any site's export.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Load the export
&lt;/h2&gt;

&lt;p&gt;Search Console → Performance → Export → Excel gives you one workbook with a sheet per tab.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="n"&gt;x&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;ExcelFile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;search_console_export.xlsx&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;sheet_names&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="c1"&gt;# ['Chart', 'Queries', 'Pages', 'Countries', 'Devices', 'Search appearance', 'Filters']
&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;  &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;columns&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;pos&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;p&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Pages&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;    &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;columns&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;page&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;pos&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;chart&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Chart&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. Gotcha: the Queries sheet is not your traffic
&lt;/h2&gt;

&lt;p&gt;The first thing I did was add up the Queries sheet. It did not match the total.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt; &lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;   &lt;span class="c1"&gt;# 6886 86
&lt;/span&gt;&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;                  &lt;span class="c1"&gt;# 2340 21
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The 333 query rows cover &lt;strong&gt;2,340 of 6,886 impressions (34%)&lt;/strong&gt; and &lt;strong&gt;21 of 86 clicks (24%)&lt;/strong&gt;. Google leaves out rare queries for privacy, and on a small, young site most queries are rare. If you plan content only from the Queries sheet, you plan from a third of the picture.&lt;/p&gt;

&lt;p&gt;The Pages sheet goes the other way: it sums to 8,165 impressions, more than the total, because Search Console counts a page-level impression for every URL shown, and one search can show two of your pages. So:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;use &lt;strong&gt;Chart&lt;/strong&gt; for totals,&lt;/li&gt;
&lt;li&gt;use &lt;strong&gt;Pages&lt;/strong&gt; to judge pages,&lt;/li&gt;
&lt;li&gt;use &lt;strong&gt;Queries&lt;/strong&gt; for the wording people type, not for volume.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  3. Bucket queries by intent (Hinglish and Hindi included)
&lt;/h2&gt;

&lt;p&gt;FRQ's audience types in English, Hinglish and Hindi script, so the patterns have to cover all three. A plain regex table was enough:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;

&lt;span class="n"&gt;buckets&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;seller&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;business|online store|sell|dukan online|apni dukan&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;when&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;        &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;\bkab\b|\bkb\b|date|muhurat|tithi|\btime\b|\btak\b|कब|मुहूर्त&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;price&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;       &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;price|kitne ka|cost|\brate\b|sasta|budget&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;what_to_buy&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;kya kharid|kya le|\blist\b|ideas|outfit|saman|सामान&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;where&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;       &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;near me|kahan|nearby|पास&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;how_to&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;how to|kaise|कैसे&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;bucket&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;pattern&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="n"&gt;buckets&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;items&lt;/span&gt;&lt;span class="p"&gt;():&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;search&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;pattern&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;I&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
            &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;other&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;

&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;bucket&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;apply&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;bucket&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;groupby&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;bucket&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;agg&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;queries&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;count&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
                        &lt;span class="n"&gt;impressions&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sum&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
                        &lt;span class="n"&gt;clicks&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sum&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)).&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;ascending&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;bucket&lt;/th&gt;
&lt;th&gt;queries&lt;/th&gt;
&lt;th&gt;impressions&lt;/th&gt;
&lt;th&gt;clicks&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;other&lt;/td&gt;
&lt;td&gt;163&lt;/td&gt;
&lt;td&gt;1,131&lt;/td&gt;
&lt;td&gt;13&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;when&lt;/td&gt;
&lt;td&gt;97&lt;/td&gt;
&lt;td&gt;918&lt;/td&gt;
&lt;td&gt;7&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;what_to_buy&lt;/td&gt;
&lt;td&gt;16&lt;/td&gt;
&lt;td&gt;114&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;seller&lt;/td&gt;
&lt;td&gt;37&lt;/td&gt;
&lt;td&gt;91&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;how_to&lt;/td&gt;
&lt;td&gt;13&lt;/td&gt;
&lt;td&gt;58&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;price&lt;/td&gt;
&lt;td&gt;6&lt;/td&gt;
&lt;td&gt;27&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;where&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Two things jumped out:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;"When" beats "where".&lt;/strong&gt; 97 different queries asked &lt;em&gt;when&lt;/em&gt; to shop ("karwa chauth ki shopping kab kare", "kb kre", "muhurat", the same question in Devanagari). Exactly one query had "near me" in it. For a "near me" product that is humbling, and useful: people plan festival shopping by the calendar first and pick the shop second.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Spelling variety is the long tail.&lt;/strong&gt; The same question showed up as karwa, karva, karwachauth and करवा चौथ. One page that answers the question well collects all of them; the regex table is how you see that they are one question.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  4. Find pages Google shows but nobody clicks
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;zero&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[(&lt;/span&gt;&lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;=&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;&amp;amp;&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;)].&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;ascending&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;zero&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;   &lt;span class="c1"&gt;# 27
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;27 pages had 20 or more impressions and zero clicks. These are the cheapest wins on the site: Google already ranks them (several sit at average position 6 to 10), so a better title and a direct answer in the first two lines can turn impressions into visits without a new URL. On FRQ that list included a wedding-season guide (47 impressions, position 6.4), a men's kurta measurement guide (45 impressions) and a saree packing guide (68 impressions).&lt;/p&gt;

&lt;h2&gt;
  
  
  5. Check the device split before you design anything
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Devices&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;device&lt;/th&gt;
&lt;th&gt;clicks&lt;/th&gt;
&lt;th&gt;impressions&lt;/th&gt;
&lt;th&gt;position&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Mobile&lt;/td&gt;
&lt;td&gt;69&lt;/td&gt;
&lt;td&gt;5,977&lt;/td&gt;
&lt;td&gt;7.08&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Desktop&lt;/td&gt;
&lt;td&gt;17&lt;/td&gt;
&lt;td&gt;878&lt;/td&gt;
&lt;td&gt;13.39&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Tablet&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;td&gt;31&lt;/td&gt;
&lt;td&gt;6.87&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;87% of impressions were on mobile, and mobile ranked about six places higher than desktop. Every page gets tested on a phone first.&lt;/p&gt;

&lt;h2&gt;
  
  
  6. Turn it into a calendar
&lt;/h2&gt;

&lt;p&gt;The pattern in the data: festival guides with the year and a Hinglish question in the title win, and the impressions arrive before the festival. Karwa Chauth fell on 29 October 2026 (Drik Panchang); in the 14 days up to 27 October FRQ had 5,271 impressions, against 1,615 in the 18 days before that, and the Karwa Chauth 2026 guide alone collected 3,537 impressions and 28 clicks. So the calendar is a list of peaks, with a publish-by date about 10 days earlier:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;from&lt;/span&gt; &lt;span class="n"&gt;datetime&lt;/span&gt; &lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;date&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;timedelta&lt;/span&gt;

&lt;span class="n"&gt;peaks&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Diwali outfits and shopping list&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;11&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;8&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Shaadi season opens (Dev Uthani Ekadashi)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;11&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Wedding guest outfits (Feb weddings)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;  &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2027&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Christmas and New Year party wear&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;     &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;12&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="n"&gt;cal&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;DataFrame&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;[(&lt;/span&gt;&lt;span class="n"&gt;topic&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nf"&gt;timedelta&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;days&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;topic&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="n"&gt;peaks&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;items&lt;/span&gt;&lt;span class="p"&gt;()],&lt;/span&gt;
    &lt;span class="n"&gt;columns&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;topic&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;peak&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;publish_by&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;
&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;publish_by&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;topic&lt;/th&gt;
&lt;th&gt;peak&lt;/th&gt;
&lt;th&gt;publish by&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Diwali outfits and shopping list&lt;/td&gt;
&lt;td&gt;8 Nov 2026&lt;/td&gt;
&lt;td&gt;29 Oct 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Shaadi season opens&lt;/td&gt;
&lt;td&gt;20 Nov 2026&lt;/td&gt;
&lt;td&gt;10 Nov 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Christmas and New Year party wear&lt;/td&gt;
&lt;td&gt;25 Dec 2026&lt;/td&gt;
&lt;td&gt;15 Dec 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Wedding guest outfits (Feb weddings)&lt;/td&gt;
&lt;td&gt;2 Feb 2027&lt;/td&gt;
&lt;td&gt;23 Jan 2027&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Festival dates come from a panchang, not from the data. Dev Uthani Ekadashi on 20 November 2026 and the first February 2027 wedding date are from Drik Panchang's calendars; Diwali on 8 November is from FRQ's own Diwali guide. Ten days is the lead time we chose to test, not something the export proves.&lt;/p&gt;

&lt;h2&gt;
  
  
  What we're doing with it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Writing festival and wedding-season guides on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;'s own blog first, in English and Hinglish, because the site's own pages are where the clicks are.&lt;/li&gt;
&lt;li&gt;Answering the "when" question in the first two lines of every guide.&lt;/li&gt;
&lt;li&gt;Rewriting the titles of the 27 zero-click pages before writing anything new.&lt;/li&gt;
&lt;li&gt;Re-running this notebook every month through the wedding season into 2027.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you run a local shop and want to try it: listing on FRQ is free at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;, and shoppers can browse local markets at &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;market.frq.in&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

</description>
      <category>python</category>
      <category>seo</category>
      <category>datascience</category>
      <category>ecommerce</category>
    </item>
    <item>
      <title>How a Hyperlocal Fashion Marketplace Works: List Free, Get Found (2027 Guide)</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Thu, 29 Oct 2026 14:25:17 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/how-a-hyperlocal-fashion-marketplace-works-list-free-get-found-2027-guide-43c3</link>
      <guid>https://dev.to/shoplocalnotes/how-a-hyperlocal-fashion-marketplace-works-list-free-get-found-2027-guide-43c3</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Funu60oz8k1neb86jk9cb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Funu60oz8k1neb86jk9cb.png" alt="FRQ business model: local clothing shops each with a map pin, linked to the same pins on a phone showing frq.in, shoppers walking between the shops" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Every Diwali the same thing happens. A shopper types "kurta shop near me" or "saree shop near me with price" a few days before Dhanteras, gets a list of big brands and directory pages, and the small clothing shop two streets away, with exactly the outfit they wanted, never shows up.&lt;/p&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;This post explains, in plain terms, how a &lt;strong&gt;hyperlocal fashion marketplace&lt;/strong&gt; closes that gap, using &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ (Find Retailers Quickly)&lt;/a&gt; as the worked example, and ends with a short checklist a shop owner can finish before Dhanteras (6 November 2026).&lt;/p&gt;

&lt;h2&gt;
  
  
  The problem: online discovery, offline purchase
&lt;/h2&gt;

&lt;p&gt;Most Indian shoppers still want to touch the fabric, try the fit and pay at a counter they trust, especially for festive and wedding wear. But the &lt;em&gt;search&lt;/em&gt; now starts on the phone. If a shop has no page with its products and prices, it is invisible at the exact moment the shopper decides where to go.&lt;/p&gt;

&lt;p&gt;Big marketplaces solve discovery by shipping the product to you. A hyperlocal marketplace solves it differently: it sends &lt;strong&gt;you to the shop&lt;/strong&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How the model works, step by step
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;1. The shop lists for free.&lt;/strong&gt; A clothing shop owner signs up at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;, adds the shop's details and uploads products with photos and prices. FRQ's own FAQ describes a free Starter plan (up to 50 products, 0% commission), so a small shop can start without paying anything.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;2. Each shop gets its own page and link.&lt;/strong&gt; The shop's catalogue lives on its own address on frq.in, which the owner can share on WhatsApp, print as a QR code at the counter, or put in a social bio. The same page is what search engines can find.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;3. Shoppers search by what and where.&lt;/strong&gt; On &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt; and &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;market.frq.in&lt;/a&gt; a shopper browses categories and nearby markets, compares a few local shops' products and prices, and picks one, all before leaving home.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;4. The sale happens in the shop.&lt;/strong&gt; The shopper visits, tries it on and pays at the counter. Where the shop offers it, the shopper can reserve a piece first and try it in the shop. No courier, no return shipping, no commission on the sale for the shop.&lt;/p&gt;

&lt;p&gt;That loop, &lt;em&gt;list free → get found on the map → shopper walks in&lt;/em&gt;, is the whole business model, and it is why it suits clothing so well: fit and fabric matter, and local shops already have the stock.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why this works better for festivals than a generic directory
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Prices are visible.&lt;/strong&gt; "Near me with price" searches are common because shoppers hate walking in blind. A product page with a price answers that question; a directory listing with only a phone number does not.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Stock changes weekly in festive season.&lt;/strong&gt; A shop page the owner updates from the phone keeps up with new Diwali and wedding stock.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;It is clothing only.&lt;/strong&gt; A focused marketplace is easier for a shopper to trust for "lehenga" or "kurta set" than a list that mixes clothes with plumbers and caterers.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  A pre-Dhanteras checklist for clothing shop owners
&lt;/h2&gt;

&lt;p&gt;If you run a small clothing shop, this takes about an hour and can be done today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;List the shop&lt;/strong&gt; on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt; with correct timings and contact details.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Add your 10–20 best festive pieces&lt;/strong&gt; with clear phone photos in daylight and a real price on each. "Price on request" loses most shoppers.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Write one honest line per product&lt;/strong&gt;: fabric, sizes available, and whether it can be altered.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Share your shop link&lt;/strong&gt; on WhatsApp status and with your regular customers, and print it as a QR code for the counter.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update it twice a week&lt;/strong&gt; until Diwali (8 November) and keep doing it through the 2026–2027 wedding season. Fresh stock is the reason shoppers come back.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  For developers reading this
&lt;/h2&gt;

&lt;p&gt;If you build sites for local shops, the same principles apply on any stack: one canonical page per shop, one page per product with a visible price, a mobile-first layout (most "near me" searches are on phones), and &lt;code&gt;ClothingStore&lt;/code&gt; plus &lt;code&gt;Product&lt;/code&gt; structured data. I wrote a copy-paste version of that markup earlier: &lt;a href="https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa"&gt;structured data for a small clothing shop&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;What is a hyperlocal fashion marketplace?&lt;/strong&gt;&lt;br&gt;
An app or site that shows clothing from shops near you, so you can compare online and then buy in person at the shop.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Is listing a clothing shop on FRQ free?&lt;/strong&gt;&lt;br&gt;
Yes. FRQ's FAQ lists a free Starter plan with up to 50 products and 0% commission.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do shoppers pay anything to use frq.in?&lt;/strong&gt;&lt;br&gt;
No. Browsing local shops and their products on frq.in is free.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can I reserve clothes online and try them in the shop?&lt;/strong&gt;&lt;br&gt;
Where the shop offers it, yes. Here is a longer guide: &lt;a href="https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf"&gt;reserve online, try in the shop&lt;/a&gt;.&lt;/p&gt;




&lt;p&gt;Shopping for Diwali? Find local clothing shops near you on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;. Running a shop? List it free on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;. (I help out with FRQ.)&lt;/p&gt;

</description>
      <category>ecommerce</category>
      <category>smallbusiness</category>
      <category>seo</category>
      <category>india</category>
    </item>
    <item>
      <title>Can I Reserve Clothes Online and Try Them in Store? A 2027 Guide to Reserve-and-Try at Local Shops</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Tue, 27 Oct 2026 17:38:02 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf</link>
      <guid>https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf</guid>
      <description>&lt;p&gt;&lt;strong&gt;Yes, you can reserve clothes online and try them in store.&lt;/strong&gt; Many local clothing shops now put their stock online, and on a marketplace like FRQ (frq.in) you can reserve a piece free for 48 hours, walk into the shop, try it on and pay at the counter only if you like it. No card, no booking fee, no delivery. (I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;This guide explains how reserve-and-try works, what it costs, what to check before you leave home and where it beats both pure online shopping and walking from shop to shop. It is written for the 2027 wedding and festive season, when most of us are buying a kurta, a saree or a lehenga and do not want to guess.&lt;/p&gt;

&lt;h2&gt;
  
  
  What "reserve online, try in store" actually means
&lt;/h2&gt;

&lt;p&gt;There are three common ways to buy clothes today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Buy online, get it delivered.&lt;/strong&gt; You pay first, wait for delivery, and if the size or colour is wrong you start a return.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Walk in cold.&lt;/strong&gt; You go to the market, move from counter to counter, and hope the piece you want is in stock in your size.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Reserve online, try in store.&lt;/strong&gt; You look at real stock and real prices from shops near you on your phone, ask one shop to keep a piece aside, then go and try it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The third option is sometimes called "buy online, pick up in store" or "click and collect". The difference with reserve-and-try is that you do not pay online at all. You only pay after you have touched the fabric and checked the fit.&lt;/p&gt;

&lt;h2&gt;
  
  
  How reserve-and-try works on frq.in, step by step
&lt;/h2&gt;

&lt;p&gt;Here is the flow on FRQ (Find Retailers Quickly), as it works on the site today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Pick your market.&lt;/strong&gt; Open &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;https://frq.in/&lt;/a&gt; in your phone's browser. There is no app to install.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Search or browse.&lt;/strong&gt; Type what you want, such as "silk saree" or "kurta set", and see which shops have it, with photos and the price next to each one.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Reserve it free.&lt;/strong&gt; Ask the shop to keep it aside. The reservation is held for 48 hours. There is nothing to pay and no card to enter.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Walk in, try, pay.&lt;/strong&gt; The same page shows the shop's address, opening hours and directions. Try the piece on. If it is right, pay the shopkeeper at the counter. If it is not, you simply do not buy it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The shopkeeper confirms the stock and the final price, so it is worth one quick look at your reservation before you leave home.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does it cost?
&lt;/h2&gt;

&lt;p&gt;For shoppers, nothing extra. Browsing, comparing prices and reserving are free, and you pay the shop its own price at the counter with no fee added on top.&lt;/p&gt;

&lt;p&gt;To give you a feel for real prices, this is what a search on frq.in showed on 27 October 2026:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Kurtas:&lt;/strong&gt; from ₹539&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Sarees:&lt;/strong&gt; ₹919 to ₹4,229&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Women's lehengas:&lt;/strong&gt; ₹3,389 to ₹7,819&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Prices change as shops update their stock, so treat these as a snapshot, not a promise. The point is that you see the number before you go, instead of discovering it at the counter.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why reserve-and-try beats the other two options
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Versus ordering online:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;You see the true colour in daylight, not on a screen.&lt;/li&gt;
&lt;li&gt;You feel the fabric. A "silk blend" can mean many things.&lt;/li&gt;
&lt;li&gt;You check the fit on your body, not on a size chart.&lt;/li&gt;
&lt;li&gt;There is no return to arrange. If it does not suit you, you leave it at the shop.&lt;/li&gt;
&lt;li&gt;You can wear it the same evening if you need to.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Versus walking in cold:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;You know the piece is there before you put your shoes on.&lt;/li&gt;
&lt;li&gt;You can compare the same item across several shops first.&lt;/li&gt;
&lt;li&gt;You avoid the "come back tomorrow, new stock is coming" trip.&lt;/li&gt;
&lt;li&gt;You spend your time in one shop, trying, not in five shops, asking.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Reserve karke shop par try karna: kab sabse kaam aata hai
&lt;/h2&gt;

&lt;p&gt;Reserve-and-try is most useful when:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;The outfit is for a function.&lt;/strong&gt; A lehenga or saree for a wedding has to fit and photograph well. Reserve two options in two shops and try both on the same day.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;You are buying for someone else.&lt;/strong&gt; Reserve, then take them along to try.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Sizes are tricky.&lt;/strong&gt; Kurtas and blouses vary a lot between makers. Trying beats measuring.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Time is short.&lt;/strong&gt; A reservation in the morning can be on you by the evening.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Budget matters.&lt;/strong&gt; Seeing prices across shops first stops you from overpaying at the first counter you walk into.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What to check before you reserve
&lt;/h2&gt;

&lt;p&gt;A reservation is only as good as the details behind it. Before you tap reserve:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Photos:&lt;/strong&gt; Are they of the actual piece, from more than one angle?&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Price:&lt;/strong&gt; Is it the final price, or "starting from"? Ask if unsure.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Size and colour:&lt;/strong&gt; Pick the exact one you want to try.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Opening hours:&lt;/strong&gt; Make sure the shop is open when you plan to go.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Return or exchange terms:&lt;/strong&gt; These are set by each shop. Ask before you pay, and keep your bill.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What happens if you can't make it in 48 hours?
&lt;/h2&gt;

&lt;p&gt;The reservation is held for 48 hours. After that, the shop can sell the piece to someone else. If your plans change, it is fair to the shopkeeper to cancel or simply not go. If you still want it, check the listing again. It may still be in stock, and you can reserve it once more.&lt;/p&gt;

&lt;p&gt;A good habit: reserve only what you genuinely plan to try. Shopkeepers set the piece aside for you, so a reservation is a small promise on both sides.&lt;/p&gt;

&lt;h2&gt;
  
  
  Tips for trying clothes in the shop
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Go in daylight&lt;/strong&gt; if colour matters. Shop lights can change how a shade looks.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Wear or carry the right undergarments and footwear&lt;/strong&gt; for a lehenga or saree trial.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Check the stitching&lt;/strong&gt; at the seams, hem and zip, not just the front.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Move in it.&lt;/strong&gt; Sit, raise your arms and walk. A wedding outfit has to work for hours.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Ask about alterations.&lt;/strong&gt; Many local shops can adjust the fit for you.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  For shop owners: why this matters to you
&lt;/h2&gt;

&lt;p&gt;If you run a clothing shop, reserve-and-try brings you shoppers who already know what they came for. They have seen your price and chosen your shop, and the sale still happens at your counter. On FRQ's Starter plan a shop can list products at ₹0 a month with 0% commission, and there is no delivery or online payment to manage. You can read more on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;https://shop.frq.in/&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Quick FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Can I reserve clothes online and try them in store?&lt;/strong&gt;&lt;br&gt;
Yes. On frq.in you reserve a piece free, it is held for 48 hours, and you try it in the shop before paying.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do I pay online to reserve?&lt;/strong&gt;&lt;br&gt;
No. You pay the shopkeeper directly at the counter, after you have tried the item.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Is there a fee for reserving?&lt;/strong&gt;&lt;br&gt;
No. Reserving is free for shoppers, and no fee is added to the shop's price.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do I need an app?&lt;/strong&gt;&lt;br&gt;
No. FRQ works in the browser on any phone.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Who handles returns or exchanges?&lt;/strong&gt;&lt;br&gt;
The shop you bought from, under its own terms. Keep your bill.&lt;/p&gt;

&lt;h2&gt;
  
  
  Further reading
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;What FRQ is, in 17 short questions and answers: &lt;a href="https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/" rel="noopener noreferrer"&gt;https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;The shopper guide to finding local shops online: &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;https://market.frq.in/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Browse shops and reserve: &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;https://frq.in/&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;em&gt;Prices quoted were checked on frq.in on 27 October 2026. (I help out with FRQ.)&lt;/em&gt;&lt;/p&gt;

</description>
      <category>ecommerce</category>
      <category>smallbusiness</category>
      <category>beginners</category>
      <category>productivity</category>
    </item>
    <item>
      <title>Shop ko Google par kaise dale? A free 2027 guide for small clothing shops</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Tue, 27 Oct 2026 12:05:57 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3</link>
      <guid>https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3</guid>
      <description>&lt;p&gt;&lt;strong&gt;Shop ko Google par kaise dale? Short answer: create a free Google Business Profile for your shop, verify it, and give Google a web page that lists what you sell with prices.&lt;/strong&gt; That is the whole job. Everything below is the detail, written for a small clothing shop owner who has a phone, a counter and no developer.&lt;/p&gt;

&lt;p&gt;I wrote this because "shop ko google par kaise dale" is one of the most common questions shop owners type into Google, and most answers stop at step one. Step one gets you on the map. The steps after it decide whether anyone actually walks in. (I help out with FRQ.)&lt;/p&gt;

&lt;h2&gt;
  
  
  Why being on Google matters for a clothing shop
&lt;/h2&gt;

&lt;p&gt;People now search before they step out. They type things like "saree shop near me with price" or "kurta shop near me". If your shop is not on Google, you are not in that list, even if you have the best stock in the market. If you are on Google but show no products and no prices, the shop next to you that does show them usually gets the visit.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 1: Make a free Google Business Profile
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Search "Google Business Profile" and open Google's own page for it.&lt;/li&gt;
&lt;li&gt;Sign in with a Google account (make one just for the shop if you can).&lt;/li&gt;
&lt;li&gt;Add the shop name exactly as it is written on your board.&lt;/li&gt;
&lt;li&gt;Pick a category. For most of us that is "Clothing store", "Saree store" or "Women's clothing store".&lt;/li&gt;
&lt;li&gt;Add the address, phone number and opening hours.&lt;/li&gt;
&lt;li&gt;Google will ask you to prove you own the shop. The options it gives differ from shop to shop (a short video, a code by phone or email, or a postcard). Follow what it shows you on the screen.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;A Business Profile is free. Nobody needs to be paid to "put your shop on Google".&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 2: Fill the profile like a shop window
&lt;/h2&gt;

&lt;p&gt;An empty profile is like a shutter that is half down. Add:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;10 or more clear photos: the board outside, the counter, the racks, and a few best-selling pieces.&lt;/li&gt;
&lt;li&gt;Your real opening hours, including the weekly off day.&lt;/li&gt;
&lt;li&gt;A short description: what you sell, for whom, and the price range.&lt;/li&gt;
&lt;li&gt;Updates when new stock comes in (the profile lets you post short updates).&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 3: Give Google a page with your products and prices
&lt;/h2&gt;

&lt;p&gt;This is the step most shops skip. Google likes to send people to a page that answers their question, and a shopper's question is usually "do they have it, and how much?"&lt;/p&gt;

&lt;p&gt;You have three choices:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Your own website.&lt;/strong&gt; Best if you have time and money for it.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A social media page.&lt;/strong&gt; Better than nothing, but it is hard for Google to read prices from posts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A free shop page on a local marketplace.&lt;/strong&gt; For example, &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;frq.in's free shop website&lt;/a&gt; gives a shop its own address like yourshop.frq.in, a product catalogue and counter billing. Its page says the Starter plan is ₹0 a month and it takes 0% commission (read on 27 Oct 2026). You put that address in the "Website" field of your Google Business Profile.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;On frq.in, shoppers can see your items with prices, reserve one free for 48 hours, and then try it and pay at your counter. So a search turns into a walk-in, not a courier parcel.&lt;/p&gt;

&lt;h2&gt;
  
  
  Google par dukan dikhane ke 3 asaan kadam (jo log bhool jaate hain)
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Naam, pata, phone har jagah ek jaisa rakho.&lt;/strong&gt; Board, Google profile, WhatsApp and your shop page should all show the same name, address and number. Mixed details confuse Google.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Asli customers se review maango.&lt;/strong&gt; After a happy sale, ask the customer to leave a review. Never buy fake reviews; Google removes them and the profile can suffer.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Daam chhupao mat.&lt;/strong&gt; Shoppers search "with price". Show a price, or at least a "from ₹…" range, for your main items.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Step 4 (optional, for the techie in the family): add structured data
&lt;/h2&gt;

&lt;p&gt;If you do have your own website, a small block of JSON-LD tells Google exactly what the page is about. A minimal example:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"@context"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://schema.org"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"@type"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"ClothingStore"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Your Shop Name"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"telephone"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"+91-00000-00000"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"openingHours"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Mo-Sa 10:00-21:00"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://yourshop.example"&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;I went through the full version, with five common mistakes, in &lt;a href="https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa"&gt;an earlier post on ClothingStore schema&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How long does it take to show on Google?
&lt;/h2&gt;

&lt;p&gt;Honestly, it varies. The profile can show up once it is verified, and Google's own help pages say a new web page can take from a few days to a few weeks to be crawled. Keep adding photos, products and real reviews in the meantime; an active profile does better than one that was made and forgotten.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Shop ko Google par dalne ka kitna paisa lagta hai?&lt;/strong&gt;&lt;br&gt;
Nothing. Google Business Profile is free. A free shop page (for example on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;) costs ₹0 on its Starter plan, per its own page on 27 Oct 2026.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Website ke bina Google par shop dikh sakti hai?&lt;/strong&gt;&lt;br&gt;
Yes. The Business Profile works without a website. But a page with your products and prices helps shoppers decide to visit, so it is worth adding one.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Free listing on Google kaise kare?&lt;/strong&gt;&lt;br&gt;
Make a Google Business Profile (Step 1 above). That is Google's own free listing for a shop.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can shoppers reserve my clothes before visiting?&lt;/strong&gt;&lt;br&gt;
On &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;the frq.in market&lt;/a&gt;, yes: a shopper can reserve an item free for 48 hours and then try it and pay at your counter.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;(I help out with FRQ.) If you run a small clothing shop and try these steps, tell me in the comments what got stuck. I'll add the answer here.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>seo</category>
      <category>smallbusiness</category>
      <category>beginners</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Structured Data for a Small Clothing Shop: a Copy-Paste ClothingStore Schema (and 5 Mistakes to Avoid)</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Sat, 24 Oct 2026 17:08:41 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa</link>
      <guid>https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fk176eof4wfp59r2c3udx.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fk176eof4wfp59r2c3udx.png" alt="FRQ (Find Retailers Quickly) poster for clothing shop owners" width="800" height="1000"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fow18e3pf1rytz3s97znl.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fow18e3pf1rytz3s97znl.png" alt="FRQ poster in Hindi for clothing shop owners" width="800" height="1000"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Posters: &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ (Find Retailers Quickly)&lt;/a&gt;&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;By Mohammad&lt;/p&gt;

&lt;p&gt;If you've ever built a site for a relative's or neighbour's shop, you know the pattern: the site looks fine, but Google shows the wrong hours, no price range, and the map pin points at the next lane. For small clothing shops in India this matters a lot right now, because wedding and festive shoppers start on their phones.&lt;/p&gt;

&lt;p&gt;Most of that information comes from the shop's Google Business Profile, but the website can help too. A small block of &lt;strong&gt;schema.org structured data&lt;/strong&gt; tells search engines exactly what the shop is, where it is, and when it's open. Here is a copy-paste version for a clothing shop, and the mistakes I keep seeing.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Use the right type: &lt;code&gt;ClothingStore&lt;/code&gt;
&lt;/h2&gt;

&lt;p&gt;schema.org has a specific type for this, &lt;code&gt;ClothingStore&lt;/code&gt;, which is a subtype of &lt;code&gt;Store&lt;/code&gt; → &lt;code&gt;LocalBusiness&lt;/code&gt;. Use it instead of a generic &lt;code&gt;Organization&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight html"&gt;&lt;code&gt;&lt;span class="nt"&gt;&amp;lt;script &lt;/span&gt;&lt;span class="na"&gt;type=&lt;/span&gt;&lt;span class="s"&gt;"application/ld+json"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@context&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://schema.org&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;ClothingStore&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;name&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Sharma Garments&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;image&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://example.com/photos/shopfront.jpg&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;url&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://example.com/&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;telephone&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;+91-98xxxxxx10&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;priceRange&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;₹300–₹6000&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;address&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;PostalAddress&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;streetAddress&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Shop 14, Main Bazaar Road&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressLocality&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Indore&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressRegion&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;MP&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;postalCode&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;452002&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressCountry&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;IN&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
  &lt;span class="p"&gt;},&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;geo&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;GeoCoordinates&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;latitude&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;22.7196&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;longitude&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;75.8577&lt;/span&gt;
  &lt;span class="p"&gt;},&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;openingHoursSpecification&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;OpeningHoursSpecification&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;dayOfWeek&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Monday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Wednesday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Thursday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Friday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Saturday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Sunday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;opens&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;10:30&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;closes&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;21:30&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;],&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;sameAs&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://www.instagram.com/example&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://wa.me/9198xxxxxx10&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
  &lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;/script&amp;gt;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. The five fields that actually matter for a small shop
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;openingHoursSpecification&lt;/code&gt;&lt;/strong&gt;: many market shops close one weekday (often Tuesday). Leave that day out of &lt;code&gt;dayOfWeek&lt;/code&gt; instead of writing "closed" somewhere in text.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;geo&lt;/code&gt;&lt;/strong&gt;: take the coordinates from the shop's own Google Maps pin, not from the street name. In crowded markets the street-level guess is often 100 metres off.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;priceRange&lt;/code&gt;&lt;/strong&gt;: shoppers filter on budget. A real range ("₹300–₹6000") is more useful than "$$".&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;telephone&lt;/code&gt;&lt;/strong&gt;: use the number the shop actually answers, ideally the WhatsApp Business number, in international format.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;image&lt;/code&gt;&lt;/strong&gt;: a real shopfront photo helps people recognise the shop when they arrive.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  3. Keep it consistent everywhere
&lt;/h2&gt;

&lt;p&gt;Search engines cross-check. The name, address and phone number (NAP) in your JSON-LD should match the Google Business Profile, the signboard, and any marketplace or directory page the shop has, character for character. "Shop 14, Main Bazaar Rd" in one place and "14 Main Bazar" in another is the most common reason a small shop's details look unreliable.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Validate before you ship
&lt;/h2&gt;

&lt;p&gt;Paste the page URL into Google's Rich Results Test and the Schema Markup Validator (validator.schema.org). Fix every error; most are a missing comma or a time written as "10.30" instead of "10:30".&lt;/p&gt;

&lt;h2&gt;
  
  
  5. What if the shop has no website at all?
&lt;/h2&gt;

&lt;p&gt;Plenty of small clothing shops don't, and building one just for schema isn't worth it. The practical options are a complete Google Business Profile plus a free shop page on a local marketplace. One I help with is FRQ, short for Find Retailers Quickly (&lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;): a clothing shop can make its own page with products and prices at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;https://shop.frq.in/&lt;/a&gt;, and shoppers browse local shops at &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;https://market.frq.in/&lt;/a&gt;. (I help out with FRQ.) Whatever you pick, keep the same name, address and phone number as above.&lt;/p&gt;

&lt;h2&gt;
  
  
  Quick checklist
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;[ ] &lt;code&gt;@type&lt;/code&gt; is &lt;code&gt;ClothingStore&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;[ ] Address matches the signboard and Google Business Profile&lt;/li&gt;
&lt;li&gt;[ ] &lt;code&gt;geo&lt;/code&gt; taken from the real map pin&lt;/li&gt;
&lt;li&gt;[ ] Weekly closed day left out of &lt;code&gt;openingHoursSpecification&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;[ ] Real &lt;code&gt;priceRange&lt;/code&gt; in ₹&lt;/li&gt;
&lt;li&gt;[ ] WhatsApp number in international format&lt;/li&gt;
&lt;li&gt;[ ] Passed the Rich Results Test&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you've done this for a family shop, I'd like to hear which field caused you the most trouble.&lt;/p&gt;

&lt;h2&gt;
  
  
  Further reading (2027)
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3"&gt;Shop ko Google par kaise dale? A free 2027 guide for small clothing shops&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/" rel="noopener noreferrer"&gt;What is FRQ (frq.in)? 2027 questions and answers about the local fashion marketplace&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

</description>
      <category>webdev</category>
      <category>seo</category>
      <category>beginners</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
