Retail products may need a package label, shelf identifier, price text, or a short stock reference. A spreadsheet gives a team a repeatable source for those values while preserving the product or inventory system as the record of truth.
Label Wizard prints supplied text into a chosen layout. It does not create a barcode or QR code, sync inventory, or set prices. Use the right stock for the shelf or package and confirm current values before sending a batch.
These product numbers and sizes come from the PrintGenius catalog. Check the package before printing.
A short product name and internal reference can help staff match a package to a stock list. Keep the reference text-only; machine-readable symbols remain in a separate system.
A shelf label can show a concise product or category name. Use the same vocabulary as the inventory record so staff can find the item without maintaining two naming schemes.
Use a spreadsheet field for the current price and proof it against the authorized price list. Avoid reprinting a shelf batch from an old workbook after a promotion ends.
A collection field can group a seasonal set or new-arrival run. Keep the package text distinct from internal stock notes so only the intended fields appear on the label.
Use one row for each product, container, or print variant. Keep changing values in separate columns so you can update a name or date without rebuilding the whole sheet. For fields that should never appear on the customer-facing label, retain them in a separate internal record rather than mapping them into the print layout.
| Product | Variant | SKU text | Price | Shelf | Collection |
|---|---|---|---|---|---|
| Stoneware cup | Sea glass | CUP-014 | $24.00 | Home · Shelf 2 | Coastline |
| Linen notebook | A5 | NOTE-022 | $18.00 | Paper · Bin 1 | Studio |
| Olive soap | Citrus | SOAP-008 | $9.00 | Bath · Shelf 4 | Daily |
Each row becomes a label in the selected layout. If a cell already contains the complete label, whole labels pasted into cells also work. Keep a copy of the reviewed source sheet and compare the first, middle, and last label with the package list before printing.
Store price and product fields in the approved workbook or export from your inventory source. Before printing, compare each price with the active promotion or price file. A text label can help identify a product, but it does not update point-of-sale records or reserve stock.
Independent retailers, makers, studio shops, and small product teams can use a consistent source sheet to keep names and batches aligned. The examples below are a starting point; measure the actual stock and check your approved package copy.
Separate customer-facing text from internal notes. A shelf label may need a product name and price; a package label may need a variant and batch. Keep internal supplier or margin information in a restricted inventory system rather than on the print sheet.
Use a consistent product naming convention across the shelf, package, and inventory list. If variants differ only by size or color, spell those values out in separate columns so the correct item is easy to confirm.
Prices change more often than a template. Put the value in a dedicated field and date the workbook export, then check it on the proof. A stale print file can outlive a sale or promotion if it is not labeled with its revision.
For a large assortment, print a small category at a time and compare it with the shelf map. This makes it easier to catch missing or duplicate labels before staff spend time rearranging products.
Label Wizard supports more than 1,400 catalog product numbers, custom sizes, one-label layouts, pasted lists, and spreadsheet input by row or by cell. It can bold lines, shrink text to fit, start at any label on a partly used sheet, and create a PDF, a new Google Doc, or output in the currently open Doc. On rectangular labels, upload, crop, and zoom your logo to place it on the left of the text; it is saved in your Google Drive for next time. Preview and print a test before the production run.
Label Wizard does not create barcodes, QR codes, product images, or color backgrounds. It does not certify product claims or replace a business’s own review process.
Upload, crop, and zoom an original logo, then place it on the left of your label text. The logo is saved in your own Google Drive for next time; this feature is for rectangular labels, not round labels.
PGRetail & price tagsProduct · batch · date
Yes. Keep price in a dedicated column and verify it against the current authorized list.
No. It prints text you provide and does not create barcode or QR graphics.
Yes. Use separate rows for the variants and check the row order.
You can reuse the spreadsheet, but use layouts and fields suited to each surface.
Date the source export, confirm promotions have ended or started as expected, and proof a small batch.
Yes. Use a separate category or filter so shelf and inventory labels do not get mixed.
Choose the matching template, review your rows, and test a page before printing.
Avery®-compatible layouts are identified by dimensions and sheet geometry, not by assuming that different brands are interchangeable. Confirm the number and measurements on your own package. PrintGenius is independent and is not affiliated with or endorsed by Avery or any label manufacturer.
