BulkCSV SEO / Case study

CASE STUDY

How we run more than 21,000 location pages on one Shopify store.

Everything we offer was tried on our own store first. This is what we did, what changed, and what we would tell another store owner to expect.

21,000+location pages on the store
998pages rewritten with unique local content and FAQ schema
20,616pages repriced in 37 batches in one evening
4,930web search clicks since August 11, 2026 (Search Console)
Google Search Console performance chart: 4,930 total web search clicks, rising from August to November 2026
Search Console performance for the store, August to November 2026. The store name is hidden.

The starting point

The store is a Canadian online retailer that we own and run. It serves customers across the country, so it has a location page for each community it delivers to: more than 21,000 of them.

At that size, two problems show up that small stores never see. The first is indexing. In June 2026, Search Console listed about 13,000 of the pages as "Discovered, currently not indexed", which means Google knew the pages existed and had not bothered to crawl them. The second is maintenance. A price change or a brand correction has to be made on every page, and doing that by hand is not possible.

What we did

1. Made the pages worth indexing

We rewrote 998 location pages so each one has its own content: local history for the place, written for that page only, at about 500 words. Each page also carries a set of questions and answers with FAQ schema.

2. Removed what did not help

Filler was stripped from the pages, such as region labels that no visitor read, so the useful content comes first.

3. Built a way to change everything at once

Every page is generated from data and imported as a CSV batch. When prices changed, we regenerated the pages and imported 20,616 of them in 37 batches in a single evening. Each file was validated and previewed before it ran, and every row was confirmed after.

The numbers so far

These are measurements, not a controlled test. The work happened in stages over several months, and we do not claim that any single change produced a specific number.

What we learned

The honest limits

This is one store, and it is ours. The figures come from our own Search Console and import logs as of mid 2026. Results vary from site to site, and no one can promise rankings. What we can promise is the method: useful pages, valid markup, safe imports and open reporting.

FAQ

Common questions.

Which store is this?

It is a Canadian online retail store that we own and operate. We keep the name private.

How long did the indexing improvement take?

The drop from about 13,000 to 5,210 pages waiting to be indexed happened between June and mid July 2026.

Would my store see the same results?

We cannot say without looking at it. Results depend on your market, your competition and the quality of the pages. The free audit is how we find out what is realistic.

Want the same process on your store?

Tell us your store address and what you sell. We reply with a short audit and a plan.

Request your free audit