Guide
Turn your product sheet into a simple online catalogue
For this guide and its prompts we recommend:
- Shopify imports your product sheet as products and gives you a catalogue with filters and search. 3-day free trial · €1/month for the first 3 months on most plans (source)
- Gamma lays out a shareable catalogue page. Free plan (source)
- Fotor fixes the light and background of product photos. Free plan (source)
Offers checked 21 Oct 2026
You can now turn a sheet into a catalogue.
A browsable online catalogue built from your own product sheet, with clean photos, filters customers need and one sheet that stays the single source of prices and stock.
What you need
- Your product or stock sheet (names, prices, stock)
- Your own product photos
- Any AI chat assistant
- An online store builder or a presentation tool for the catalogue page
Recommended AI tools
ShopifyThe catalogue is built from data you alreadyTrial GammaThe catalogue is built from data you alreadyFree plan FotorThe catalogue looks like one setFree plan
Steps
Steps marked with a source come from public Instagram posts, read on 22 Oct 2026 (captions and spoken words only, no comments). The method here is rewritten for general use.
Pick the sheet and tidy it
Joshua starts from a plain inventory sheet with names, prices and stock levels. Use the sheet you already keep: one product per row, one column for each fact. Ask AI to find duplicates, empty cells and prices written in different ways.
ExampleHere are my sheet's column names and 20 sample rows. List duplicates, empty cells and inconsistent prices. Do not change any value; only list them.
Describe the catalogue in plain English
His second step is describing what you want in plain words. Say who will browse it, which filters they need (category, size, in stock) and what each product page shows. AI turns that and your columns into a list of fields and short product texts.
Clean the product photos
A catalogue is judged by its photos. Fix the light and the background of each photo so they look like one set, and check that colour and shape still match the real product.
Build it from the sheet and tweak
Import the sheet into an online store builder as products, or lay a shareable catalogue page out from it. Then tweak the look, filters and texts in the visual editor instead of rebuilding.
Publish, and keep the sheet as the one source
Publish, open it on a phone and fix what reads badly. When prices or stock change, change the sheet first and update the catalogue from it, so the two never disagree.
The full instruction
Copy it into any AI chat assistant and change only the first line.
Change only this line: PRODUCT = [handmade ceramic mugs for home cooks and gift buyers] You help me turn my product sheet into an online catalogue. My PRODUCT line above says what I sell and who browses it. My sheet's column names and 20 sample rows are pasted below. Do four things: 1. List duplicates, empty cells and inconsistent prices or units. Do not change any value. 2. Propose the catalogue fields and filters (for example category, size, in stock) and map each to a column. 3. Write a product text of at most 50 words for each sample row, using only facts from the sheet; mark anything missing as [MISSING?]. 4. Give me a checklist for publishing and for updating the catalogue from the sheet when prices or stock change. Start with step 1. Paste your material below this line:
What you end up with
A catalogue customers can browse on a phone, built from your sheet with clean photos and honest product texts, and one sheet you update first whenever something changes.
Common mistakes
- Fixing prices in the catalogue but not in the sheet, so the two disagree.
- Letting AI fill in missing sizes or materials instead of marking them.
- Using edited photos that change the product's colour or shape.
- Publishing without checking it on a phone.
Processes that need more than one tool
Each process below uses several tools, each for the job it does best. Any AI chat assistant works where one is named.
Pick the sheet and tidy it
Tools, in order: a spreadsheet → any AI chat assistant
- Make sure the sheet has one product per row and one column per fact.
- Ask a chat assistant to list duplicates, empty cells and inconsistent prices, then fix them in the sheet yourself.
Recommended approach for this step: a spreadsheet → any AI chat assistant
Quality: the catalogue starts from clean data
The prompt for this process
Check my product sheet before I turn it into a catalogue. Column names and 20 sample rows: [paste] List: duplicate products, empty cells, prices or units written in different ways and columns that mix two facts. Do not change any value; only list the problems with the row number. Then suggest clean column names. Start with duplicate products.
Describe the catalogue in plain English
Tools, in order: any AI chat assistant → a spreadsheet
- Describe who browses, the filters they need and what each product page shows.
- Ask for the field list and short product texts, and add the texts to the sheet as a new column.
Recommended approach for this step: any AI chat assistant → a spreadsheet
Time: product texts are written once, in the sheet
The prompt for this process
Plan the fields of my online catalogue from my sheet. Who browses it: [one line] Filters they need: [e.g. category, size, in stock] Column names: [paste] Sample rows: [paste 10] Map each catalogue field to a column. Then write a product text of at most 50 words for each sample row, using only facts in the sheet; mark anything missing as [MISSING?]. Start with the field map.
Clean the product photos
Tools, in order: Fotor → your phone camera
- Fix the light and remove a busy background from each product photo in Fotor.
- Compare every edited photo with the real product and retake any that changed it.
Recommended for this step: Fotor
Quality: the catalogue looks like one set
The prompt for this process
Give me a checklist for cleaning product photos for a catalogue, so they look like one set. Products: [what they are, colours, materials] Background I want: [e.g. plain light grey] List the light, background and sharpness fixes to make, the same crop for every photo and four things to compare between each edited photo and the real product. Start with the light.
Build it from the sheet and tweak
Tools, in order: Shopify → Gamma
- Import the cleaned sheet into Shopify as products, with the photos.
- Or lay a shareable catalogue page out from the sheet in Gamma.
- Tweak filters, texts and look in the editor instead of starting again.
Recommended for this step: Shopify + Gamma
Time: the catalogue is built from data you already keep
The prompt for this process
Help me prepare my product sheet for import into an online store builder. My columns: [paste] Required import columns of my store builder: [paste from its help page] Map my columns to the import columns, list any column I still need and flag rows that will fail (empty price, missing title). Do not invent values. Start with the column map.
Publish, and keep the sheet as the one source
Tools, in order: a spreadsheet → Shopify
- Publish and check the catalogue on a phone.
- When prices or stock change, change the sheet first and import the update.
Recommended for this step: Shopify
Quality: the sheet and the catalogue never disagree
The prompt for this process
Write me a short update routine for my catalogue. How often prices or stock change: [e.g. weekly] Who updates the sheet: [one line] Five steps at most, from changing the sheet to checking the catalogue on a phone. Include one check that catches a price that differs between the sheet and the catalogue. Start with step 1.
For this result we recommend these tools
This guide describes a result. These tools are one way to get there faster. Whether one pays for itself depends on your work, and we promise no result.
From Sandra’s story: Sandra: the shop she started with AI
ToolShopify
E-commerce platform for an online store: products, payments, delivery and selling in person, with built-in AI tools.
From €24 per month billed yearly (Basic); €32 per month on monthly billing (source, checked 2026-10-07)
Shopify is an online store builder with checkout, payments and hosting in one place. In this guide it is used in “Build it from the sheet and tweak” and “Publish, and keep the sheet as the one source”. Brands of every size run their stores on it; it stands out for its app store and a checkout buyers already know.
3-day free trial · €1/month for the first 3 months on most plans (source, checked 21 Oct 2026)
From Ema’s story: Ema designs invitations that spell correctly
ToolGamma
AI tool for creating presentations, documents and simple websites from prompts.
From $9 per seat per month, $108 per seat billed annually (Plus) (source, checked 2026-10-07)
Gamma is an AI tool that builds slide decks, one-page documents and simple web pages from an outline. In this guide it is used in “Build it from the sheet and tweak”. People use it for proposals, lesson slides and reports, and it stands out because the result is shared as a link that reads well on a phone.
Free plan (source, checked 21 Oct 2026)
Fotor
AI photo clean-up: background removal, light and sharpness.
From €2.83 per month (Pro, €33.99 billed yearly) (source, checked 2026-10-16)
Fotor is a browser photo editor with AI tools for background removal, light and sharpness. In this guide it is used in “Clean the product photos”. Shops and creators use it to make product and post photos look clean without a studio, and one click fixes light and background while the product stays as it is.
Free plan (source, checked 21 Oct 2026)
We recommend a specialised tool for each process rather than one tool that does everything. Tools that try to do everything rarely do any one job really well, because no single function gets perfected. It is the same in life, in business and in relationships: spread your attention over ten places and nothing gets done properly.
Forward, without brakes
Now that the Kailiniai Heroes exist, you can have your own. Create one hero or several, and use them for goals that used to need a whole team or a big budget.
