Etsy Seasonal Trends: A 12-Month Listing Calendar With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Etsy Seasonal Trends: A 12-Month Listing Calendar With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Etsy Seasonal Trends: A 12-Month Listing Calendar With AI.

Count back from each peak: publish about six to twelve weeks before buyers search hardest, longer when production takes weeks. Build the calendar from your own sales and search data, let ChatGPT or Claude organise it, and cap each listing by the capacity you actually have. Sources differ on exact lead time, so test it against last year.

The calendar is only worth building if it changes what you do in the next ninety days. A good one answers three questions for every month: what to list, when to publish it, and how many you can make. Most seasonal shops get the first right and miss the other two, publishing a Christmas design in the first week of December with stock for ten orders.

Follow me on Instagram@sagnikteaches

Why publish early: a new listing needs weeks to earn its place

Buyers search for a gift or an event weeks before it arrives. Search interest starts rising well ahead of the date itself, and your own Stats will show by how much: Etsy's help centre says shop stats go back to November 2017, and choosing Etsy search under How shoppers found you lists the terms people used to find your listings. A listing published on the day of the peak starts with no history, while one published earlier has time to collect views, favourites and first sales before the rush. Sellers' guides argue that Etsy's search favours listings with that history; treat it as their reading, not a published Etsy rule.

Connect on LinkedInSagnik Bhattacharya

There is no single agreed figure for the right number of weeks. Sellers' guides and SEO-tool blogs give ranges from about six to eight weeks before the buying peak up to eight to twelve weeks, and they rarely back the figure with Etsy data. The honest conclusion is a range of six to twelve weeks as a starting assumption, tested on your own numbers. Any holiday dates or seller offers Etsy announces change from year to year, so check Etsy's own seller pages each season rather than last year's article.

Subscribe on YouTube@sagnikteaches

Lead time has two parts, and a calendar must show both: the time buyers need to find you, and the time you need to make the item. A hand-poured candle may take a day a batch; a made-to-order embroidered piece may take three weeks. Add the production time to the discovery window, and you have the date you must start, not just the date you must list.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Gather your own evidence before asking AI anything

An assistant has no live view of Etsy search. It will happily "recall" which products trend in which month, and the answer will sound confident and be unreliable. Give it your numbers instead. Build a simple table with one row per month for the last twelve to twenty-four months:

  • Orders and revenue by month, from your Shop Manager orders or sales reports.
  • Views and visits by month, from your shop stats.
  • Top search terms by month, from Stats: choose Etsy search under How shoppers found you, set the date range to one month, and copy the terms into a spreadsheet month by month (Etsy's help article on Stats does not mention an export).
  • Top five listings by orders per month.
  • Your own notes: stock-outs, sales you ran, a viral post, a long dispatch time, a holiday closure.

Add outside demand with Google Trends: search each of your core terms (for example "wedding favours" or "christmas card") over five years and note the month where interest starts to climb and the month it peaks. Trends scores are relative: Google's help centre says each point is the term's share of all searches for the time range you choose, rescaled from 0 to 100, so use them to compare timing, not size. If you have a new shop with no history, use Trends and the marketplace data Etsy publishes, and plan smaller, then update after your first year.

Paste only totals and terms into the assistant. You do not need to upload buyers' names or order details, and you should not.

Prompt: turn the table into a seasonal map

I run a small Etsy shop selling printed wall art and greeting cards. Below is my monthly data for the last 24 months: orders, revenue, top five search terms, and notes.

1. For each month, identify the seasonal driver you can see in MY data (a recurring jump in orders or in a search term). Do not use outside knowledge about trends; if the data does not show a pattern, say so.
2. For each pattern, show the month where views started rising and the month where orders peaked. Calculate the gap in weeks.
3. List months where my orders fell and the likely reason from my notes.
4. List any term that appeared in the top five in only one of the two years (possible one-off).
Return a table, then a short list of questions I should answer before planning.

DATA:
...

This works because every conclusion has to point to a row of your data. Check two or three of its calculations yourself, as assistants occasionally miscount weeks or confuse the two years. For wider guidance on getting reliable analysis from exports, see what ChatGPT reads well from PDFs and spreadsheets.

What two years of card-shop data showed

Say a small shop selling printed cards and wall art finds, in two years of its own data, that views start climbing in mid-September and orders peak in the first half of December; that the Valentine's period shows a smaller bump with views rising in early January; and that spring has a modest bump around the middle of April (a gift-giving day whose date moves each year). The gap between views rising and orders peaking is about twelve weeks for Christmas, about five weeks for Valentine's. The assistant's table puts that in front of you. What you fix: it may state that "Easter" drives April when your data only shows a rise; check the dates against last year's orders before naming a cause.

Counting back from each peak

Take the peak order date from your data, then count back with this simple formula for each season:

Publish date = peak order date
             - buyer discovery window (your data, test 6 to 12 weeks)
             - photography and listing time (1 to 2 weeks)
Production start = first order date likely
             - make time per batch
Last order date = delivery deadline
             - dispatch time
             - transit time

Apply it to the Christmas peak. Say orders peak on 6 December and your data shows views start rising in the second week of September. The listing should be live by early September at the latest; photography and drafting happen in August; stock for the first batch is ready by the end of the month. The same shop's Valentine's design peaks in the first week of February, with views rising in early January, so it goes live around the end of November or early December, and is drafted and photographed in November, at the time Christmas orders are heaviest. That clash is why a calendar matters: the work for the next season always falls inside the busy period of the current one.

Put all dates into a single spreadsheet with columns: event, peak date, discovery window, publish date, photo date, production start, last order date, units planned. Ask the assistant to check the arithmetic and flag any date that falls inside a period you have marked as unavailable, such as holiday closures or a craft fair.

The twelve-month calendar for a small card and print shop

Here is an illustrative calendar, not a recommendation for your shop; your own data decides the dates. It assumes the shop sells printed cards and wall art, with a week's production time per batch.

MonthMain jobWhat to publish or refresh
JanuaryReview the year, fulfil Valentine'sCheck the Valentine's range published in late November; restock it and renew the best seller
FebruaryFulfil, then plan springDraft spring and Easter-week designs; photograph
MarchSpring listings go livePublish spring cards, graduation-season prints; refresh photos on evergreen items
AprilFulfil spring; prepare summer eventsDraft wedding-season and summer-gift items
MayWedding and summer peakPublish summer travel prints; renew wedding listings
JuneMid-year reviewCompare against last year; set the autumn plan
JulyBack-to-school and early Christmas draftsDraft Christmas designs; order materials
AugustBuild Christmas stockPhotograph Christmas items; write listings; run the shop-tidy pass
SeptemberPublish Christmas rangePublish Christmas and autumn items; schedule Halloween
OctoberHalloween and early giftsKeep Christmas stock topped up; set last-order dates
NovemberPeak run-upPublish the Valentine's range; set holiday-sale plans
DecemberFulfil and close offRemove or pause listings past the last-order date; plan the January review

For a shop selling something other than cards, the months change but the rhythm holds: draft early, photograph in a quiet month, publish well before the peak, pause at the cut-off. A plumbing firm's marketing calendar, as in this 12-month posts and offers plan, follows the same backwards logic with different seasons.

Production capacity: the number that stops you overselling

A seasonal peak is a capacity test. Work it out before publishing, not after the orders arrive.

LineIllustrative figure
Production hours available per week in the run-up20
Hours per finished unit (print, trim, pack)0.25
Units possible per week80
Weeks available (mid-October to 15 December)8
Capacity before other orders640
Core-range orders expected (from last year)260
Capacity left for the Christmas range380

If last year's Christmas range sold 300 units but you planned 380, you have headroom; if your data suggests 500, you either need more hours, a production partner (which has its own disclosure duties, covered in the tutorial on Etsy Creativity Standards removals) or a smaller range. Set the listing's stock to what you can make. For made-to-order items, quote honest dispatch times that include your queue, and switch off a listing at the cut-off rather than letting orders slip.

Materials matter too. Ask the assistant to turn the capacity table into a materials list with lead times from your suppliers, then compare it with your stock. The method in how small shops forecast stock and reorder with AI carries over directly.

Testing an earlier Christmas launch for a card shop

Say a small shop sold 520 cards and prints in November and December last year at an average price of $9, which is about $4,680. Its data shows 70 percent of those sales came after the first week of December, which is the late-order surge when buyers worry about delivery. Views began rising on 12 September. Last year it published its Christmas range on 20 November, about ten weeks after views began rising.

This year it applies the calendar: Christmas range drafted in July, photographed in the first half of August, published on 1 September, eleven days before views started rising last year. The owner has no evidence that the earlier date raises sales; it is a test, and she keeps last year's figures to compare. If the earlier listings gather 20 to 30 percent more orders in October than last year, the difference is worth keeping; if October is flat, she learns the discovery window for her shop is shorter and reverts to a later date. The cost of the test is a few days' work, and the recorded results are the real return.

Capacity check: 80 units a week over eight weeks gives 640; core orders take 260; the Christmas range can have 380. Last year's 520 included 150 core items, so the range sold about 370. She plans 380 and sets a last-order date of 14 December for standard delivery. These numbers are illustrative.

Write the seasonal listings with the assistant, without spamming

When it is time to write, give the assistant the listing's facts and your keyword research, not a request to "write a Christmas listing". Reuse your shop's tone, vary titles across listings, and avoid stuffing the same words into forty items. The Etsy titles, tags and descriptions tutorial covers the mechanics, and the search-ranking tutorial explains how AI-written text affects it. Check that each listing states honestly who designed and produced the item, which Etsy's Creativity Standards require.

Seasonal wording needs care: do not promise delivery by a date unless your last-order date, dispatch time and carrier time support it. Put the cut-off in the first lines of the description and in the shop announcement.

Before and after: a seasonal title and tag set

Illustrative: a card titled "Christmas Card" with tags "card, christmas, gift" becomes "Linocut Robin Christmas Card, Blank Inside, Recycled Paper" with tags that describe the style, the recipient and the use (for example "robin card", "blank christmas card", "recycled paper card"). Ask the assistant for twenty options, then pick and check each against what the item really is. Never accept a tag that describes a feature your product lacks.

Where the calendar breaks, and how it shows up

The three cases below are illustrative, built from the ways a seasonal plan typically goes wrong rather than from particular shops.

The year the trend moved

A seller built her calendar from one good year and planned a Halloween range for early September. Orders arrived two weeks later than last year, because the previous year had a viral post that pulled demand forward. Her second year's data would have shown a flat October. The lesson: use at least two years where you can, mark one-off spikes in the notes column, and give no single month more than a one-year pattern's weight.

The listing that sat unseen

Another seller published a spring range in February, six weeks before the peak, but forgot to renew the tags and photos from the previous year. Views stayed low until she refreshed the listing in March. Seasonal items need a fresh check each year of tags, price, photos and stock, not just a publish date.

The sale that doubled the queue

A shop ran a promotion in the same week as its largest batch of orders, doubling the queue and pushing dispatch from three days to nine. Reviews dropped. Put promotions on the calendar beside capacity, and ask the assistant to flag any promotion that falls in a week where planned units exceed 80 percent of capacity. If you use paid ads to push a peak, put the ad weeks on the same calendar and judge them by your own Stats, not by the ad dashboard alone.

What to do with listings after the peak

The week after a peak is when most sellers stop. It is also the best time to learn. Within fourteen days of the cut-off, do four things and put them in the calendar as a recurring task.

  1. Pause or hide the seasonal listings that cannot ship in time for the next occasion, or change the dispatch wording so no buyer expects delivery by a date you cannot meet. Keep the listing; its history is worth more than a rewrite.
  2. Record the real numbers in the same table as last year: orders per week, the week of the peak, and any stock left. A five-minute entry now saves guesswork in twelve months.
  3. Write a short post-mortem of three lines: what sold faster than planned, what sat, what ran out. Ask the assistant to compare it with the plan and list the three biggest differences, using only your figures.
  4. Decide the leftovers. Unsold seasonal stock can be kept for next year if it does not date, discounted on a clear schedule, or reworked into an evergreen product (a Christmas card pack repackaged as a plain winter set).

Illustrative case: after December, the card shop has 90 robin cards left. It keeps 60 for next year (the design does not date), reprices 30 into a January bundle with a blank notebook, and logs that the robin sold out of its first batch two weeks before the cut-off. Next year's plan raises that batch by about a quarter, capped by the capacity table. That is the whole loop: plan, publish, count, adjust.

Keep the calendar alive through the year

A calendar that is never revisited drifts. Set a fifteen-minute review on the first of each month with three questions: did last month's listings meet their targets, what is two months out that needs drafting now, and has capacity changed. Paste that month's numbers into the same chat or Project and ask for a comparison with the plan. Record what you learned in a notes column, and at the end of the year rebuild the table with the new data. After two cycles, you will have your own seasonal map, better than any general trend list because it reflects your shop, your products and your buyers.

If you would rather set this up with someone, working from your own export and capacity numbers, that is covered in an AI implementation consultation. And remember the limits: AI organises and checks; your data decides the dates, and your production capacity decides the quantities.

Seasonal planning questions from Etsy sellers

How early should I publish seasonal Etsy listings?

A common starting rule is six to twelve weeks before the peak buying window, longer for items with a big production time. Sources differ, so treat it as a hypothesis and test it against your own search and sales data from last year.

Where does the search data come from?

Your own Etsy shop stats for past search terms and sales by month, Etsy's seller guidance and marketplace reports where it publishes them, and Google Trends for outside demand. Export what you can and give the assistant your numbers instead of asking it to recall trends.

Can ChatGPT or Claude tell me what will trend next year?

No. It can organise last year's data, suggest which events to plan for and flag gaps, but it cannot see Etsy's live search. Anything it says about future demand is a guess until your own data supports it.

Do I list new items or renew old ones for each season?

Both work. Keep a listing for a recurring item and refresh its photos, title and stock before each peak, and add new listings for genuinely new designs. Compare last year's results for each before deciding.

What if I cannot make enough to meet the peak?

Work backwards from capacity: units per week times weeks available, minus other orders. Then limit stock, switch to made-to-order with honest dispatch times, or close off listings at a cut-off date. Overselling harms reviews more than missing a few sales.

Further reads

Sources: Etsy Help Center article on Etsy Stats; Google Trends Help on how scores are scaled; sellers' published timing advice (which differs between sources).

Want a calendar you can reuse every year?

On a 1:1 call we can set up a yearly calendar from your own sales data, with production limits built in, and decide which parts to automate.

Book a 1:1 call with me