Home · Blog · Makers
Article · Makers

AI for a small handmade business: the week before a market, and market day

17 NOV 2026 · 7 MIN READ · OPPERMIND PTY LTD
In short. On Monday, type last Saturday's packed and came-home counts into a market log in the Sheet editor and let it work out what sold. Check your materials against reorder points. Midweek, photograph new pieces on a plain background and tidy them in the Image editor. On Thursday, print a sheet of product labels from the Design editor. On market day, the same log opens on your phone at the stall. Ingredient lists and measurement rules are yours to get right, and the post points you to where they're set out.

A handmade business has two clocks. One runs on the market calendar, Saturday at the showgrounds or the second Sunday at the school. The other runs at the kitchen table, where clay, wax or yarn turns into stock. The week below follows a made-up maker, Saltbush & Clay, who sells mugs, small planters, beeswax wraps and lip balm. The business, its town, the markets, items, prices and counts are invented for this post.

Monday: tally the last market

Start with what came home in the tubs. Ask in the chat:

"Make a market log sheet. Columns: Date, Market, Item, Price, Packed, Came home, Sold, Takings. Sold is Packed minus Came home. Takings is Sold times Price. Add rows for last Saturday at Riverside Market: speckled mug A$38, small planter A$26, beeswax wrap set A$22, lip balm A$9."

It opens in the Sheet editor. After the counts go in, last Saturday might read:

DateMarketItemPricePackedCame homeSoldTakings
15 NovRiversideSpeckled mugA$3818513A$494
15 NovRiversideSmall planterA$261293A$78
15 NovRiversideBeeswax wrap setA$2220614A$308
15 NovRiversideLip balmA$9402218A$162

All markets, items, prices and counts are made up for this post.

Click a Sold cell and look at the formula bar before you trust the column. It should show a formula. If it shows a plain number, ask Lato to put the formulas in. When you add next week's rows, ask in the chat ("add rows for 22 Nov at Hilltop Market, same four items, same formulas") instead of dragging formulas down the column.

The business.gov.au guide to managing inventory calls counting by hand and updating a spreadsheet a "periodic system", and its advice for that kind of system is to record every sale and return. At a market the count you can trust is what came home, so that column does the work.

After a few markets the log gets long. Ask for a summary beside it: "Add a summary that totals Sold and Takings for each item across every market, using SUMIF." That's the line that tells you planters sell three a market and mugs sell a dozen, which decides what you make this week. To compare markets, use Filter from the right-click menu on the Market column. Pick the market names once with Data validation under More, as a List, and the Market column becomes a dropdown, so "Riverside" never turns into "riverside mkt".

Tuesday: check the materials

Business.gov.au sorts stock into raw materials, work in progress and finished goods. For a maker, the first of those is clay, glaze, wax, cotton and tins, and running out of one stops a whole product line.

Keep a second, shorter sheet for them: "Make a materials sheet. Columns: Material, Unit, On hand, Reorder point, Supplier. Rows for stoneware clay (10 kg bag), speckle glaze (litre), beeswax pellets (kg), cotton fabric (metre), 15 g balm tins (box of 50)."

A reorder point, in the same business.gov.au guide, is the smallest amount of an item you want on hand before you order more. Set yours from how long a supplier takes to deliver and how much you get through in that time. Then open Conditional format under More and add a rule that highlights any On hand cell lower than its reorder point, so Tuesday's check is a glance down one column. Freeze rows keeps the headings in view, and Export CSV gives you a file if a supplier asks for your order that way.

Midweek: photograph the new pieces

If a market application asks for product photos, these do that job, and your stall post needs a few too. Shoot on a phone near a window, on a sheet of plain card, and get each piece from more than one side. Then open each photo in the Image editor:

Keep the piece as it is. A chip, a pinhole in the glaze or a wrap that's a different blue in daylight should look that way in the photo, because the customer at the stall will be holding the piece itself. If you generate a picture instead, say a drawing of the stall for a banner, label it as an illustration wherever you post it. The image generator post covers the rest of the editing tools.

Thursday: print the labels and price cards

Labels for a small run are a grid of the same design on one A4 page. Ask: "Make an A4 sheet of 12 product labels, three across and four down, for Saltbush & Clay beeswax wraps. Each label has the product name, the size, 'Handmade in Ballarat', care instructions in one line and a space for the price."

The design opens in the Design editor at the A4 Poster size (check under Sizes). Fix one label by hand first. Then select it, press Ctrl+D to duplicate it, drag the copies into rows and use Distribute H and Distribute V under More to even the gaps. Print with Ctrl+P, or export a PDF from More for a print shop. Before you feed a sheet of label stock through the printer, print once on plain paper and hold it over the label sheet against a window, because a printer can place the page slightly off where the design puts it. Duplicate page in the page bar gives you a second page for the next product with the same layout.

Price cards for the table are the same job at a bigger size, with two lines of text large enough to read from the front of the stall.

Ingredient lists. If you make lip balm, bath salts or anything else that counts as a cosmetic, Product Safety Australia's page on the cosmetics ingredients labelling mandatory standard says ingredients go on the container (or on the product if there's no container), generally in descending order by mass or volume. Where a container is too small to label, the page says the list should be displayed prominently alongside the product. If your tins are too small to label, that display could be a small printed card on the table, made in the same design. Quantities and percentages aren't required for most cosmetics. General information, not legal advice. Check the standard itself and Product Safety Australia's page (modified 17 February 2026) for your products.

Selling by weight. Business.gov.au's market stall page says that if you sell by weight, length or volume you must follow trade measurement laws, which cover how you measure and label your goods and the measuring tools, such as scales, that you use. The page adds that requirements can differ by product and quantity, and points to the trade measurement rules to check. General information, not legal advice.

The Design editor sets whatever text you give it and doesn't check ingredient lists or weights against any rule.

Market day: the log on your phone

The market log opens in the mobile browser and in the iOS and Android apps, so it can sit on the stall in your pocket. Some makers keep a paper tally under the cash tin and copy it in at pack-down, and that works fine with the same sheet. Either way, the number that matters is the one you type into Came home as the tubs go back in the car. Sold and Takings follow from it, and so does next Monday's tally.

If a customer brings something back, add it to Came home on that row and ask Lato for a Notes column to say why ("1 mug returned, chip"), so Sold matches what stayed sold. Last week's version stays in Version history if a count gets typed over.

The tubs come home on Saturday, and Monday's tally starts from what's in them.

Make the market log sheet and type in the counts from your last market.

Frequently asked questions

Where do card payments fit in?

They stay on whatever card reader or till you already use. The log records what left the stall, and you can type the reader's daily total into a spare cell to check it against Takings.

What if I sell at three different markets?

Keep one log and add a row block per market day. The Market dropdown and Filter separate them when you want to compare Riverside against Hilltop.

Do I need a new design for each product's labels?

One label design per product line is enough. Duplicate the page, change the name, size and care line, and the grid stays where it was.

Can a friend minding the stall use the log?

Share the sheet with them and you can both edit it at once. Agree who types Came home at pack-down, so the count only goes in once.

Related reading

Oppermind is not affiliated with, endorsed by, or sponsored by Product Safety Australia, the ACCC or business.gov.au.

Sources

  1. Cosmetics ingredients labelling mandatory standard. Product Safety Australia (ACCC). Page modified 17 February 2026 (from the page's article:modified_time, no date printed on the page). productsafety.gov.au. Accessed 2026-11-17. Used for: ingredients on the container or product, descending order by mass or volume (or the 1% split), display alongside the product when the container is too small, quantities not required except alcohol in hand sanitiser (the ingredient-list paragraph and its not-advice line only).
  2. Set up a market stall. business.gov.au (Australian Government). No date shown on the page. business.gov.au. Accessed 2026-11-17. Used for: selling by weight, length or volume means following trade measurement laws on measuring, labelling and tools such as scales, and requirements may differ by product and quantity (the selling-by-weight paragraph and its not-advice line).
  3. Manage your inventory. business.gov.au (Australian Government). Page shows 19 November 2025. business.gov.au. Accessed 2026-11-17. Used for: "periodic system" (counting by hand and updating a spreadsheet), record each sale and return, the three inventory types, reorder point defined as the smallest amount you want before ordering more.