Guides index

Hullspark's English pages, grouped by topic. Each title and summary is the one on the page itself.

Japanese pages (Wix shipping, inventory and accounting, Wix Bookings, Excel and more) are on 使い方ガイド一覧.

Wix Stores: shipping, inventory, SEO

• How to get low stock alerts in Wix Stores: your options
  Wix Stores does not email you when stock runs low. What Wix gives you instead, where it falls short, and your options for a real low stock alert, with Wix Help Center sources.
• Wix inventory reorder list: how to find what to restock
  Wix has no one-click reorder list. Use the Low Inventory report, or export your products, keep what is at its reorder point, and group the order by supplier. Steps, formulas, a sample memo, sources.
• How to do a stocktake in Wix Stores: update stock from a physical count
  After counting the shelves, how do you get real quantities into Wix Stores? What the Inventory tab and CSV import do, where they stop, and your options, with Wix Help Center sources.
• How to bulk edit product SEO titles and descriptions in Wix Stores
  How far Wix Stores lets you edit product SEO titles and meta descriptions in bulk: one by one, a variable-based default for every product, the products list, and why a CSV does not work.

Wix Bookings

• How to stop Wix Bookings taking bookings on holidays and closure days
  Wix Bookings has no vacation mode. Here is Wix's own workaround: blocked time on each staff calendar, with the steps and the limits on existing bookings and classes.
• How to print your Wix Bookings list or export bookings to CSV
  Wix Bookings has no schedule print button. Here is Wix's workaround: export the Booking List or Booking Calendar to CSV, with the steps and limits.

Wix Restaurants

• How to show allergen information on a Wix Restaurants menu
  A Wix Restaurants menu has no allergen field. Here is Wix's label workaround and its 5-label limit, plus Japan's 9 mandatory and 20 recommended allergen items.

Excel, Word and Office

• Unmerge cells in all sheets and many Excel files at once
  How to unmerge cells across many sheets and many Excel files: what sheet grouping and Power Query's folder combine cover, and what they do not. Microsoft sources included.
• Flatten an Excel table: unmerge and fill down, combine header rows, unpivot
  Turn Excel tables with merged cells, multi-row headers or crosstabs into one row per record: unmerge and fill down, join header rows, Power Query unpivot. Menu names included.
• Can't find external links in Excel? Where they hide and how to look
  Excel keeps warning about external links, or Break Link does nothing? Check these places in order: names, conditional formatting, data validation, charts, shapes. Menu paths included.
• Extract images from .xlsx, .docx and .pptx files at original quality (free)
  A Windows app that extracts the pictures in Excel, Word and PowerPoint files as the original data, in bulk. The free edition does 20 pictures from one file; names with sheet and cell or slide number are in the full edition.
• Collect comments and tracked changes from many .docx files into one table
  A Windows app that lists the comments, replies and tracked changes of .docx files in one table, with filters, CSV and copy. Microsoft Word is not needed.

Confluence and Jira

• Label Sweep: merge duplicate Confluence labels
  Find duplicate labels in Confluence (how-to, how_to, howto), then merge, rename or delete them across pages and blog posts. Dry run first. 30-day free trial.
• Getting started with Label Sweep
  Your first label merge with Label Sweep for Confluence in four steps: open the app, find labels that mean the same thing, preview the merge, run it. Plus how to undo, what the limits are and short answers. English and Japanese.
• Attachment Sweep: unused Confluence attachments
  Find the attachments no Confluence page uses, see how much space they take, check with a dry run, then move them to the trash. Nothing is purged. 30-day free trial on the Atlassian Marketplace.
• Getting started with Attachment Sweep
  Your first cleanup with Attachment Sweep for Confluence in four steps, with real screenshots: open the app, scan, select files, move them to the trash. Plus how to restore a file and why your storage number does not drop right away. English and Japanese.
• Page Review Reminders: Confluence review dates
  Set a reviewer and a due date on any Confluence page. A banner shows on the page and the reviewer is @mentioned when it is due. Works on every plan. 30-day free trial on the Atlassian Marketplace.
• Getting started with Page Review Reminders
  Your first review date with Page Review Reminders for Confluence in four steps: open the page menu, set a reviewer and a due date, check the byline, mark the page as reviewed. Plus how a reminder looks, how to undo, the limits and short answers. English and Japanese.
• How to find stale and outdated pages in Confluence and get them reviewed
  Which Confluence pages are stale? What the content manager, task reports and approvals do, where they stop, and your options, with Atlassian documentation sources.
• How to audit Jira custom fields and clean up the ones nobody uses
  Too many custom fields in Jira Cloud? What the Fields screen, the 700-per-space limit, delete and restore, and the Site optimizer do, where they stop, and your options, with Atlassian sources.
• Field Sweep for Jira: find unused custom fields
  Find which Jira custom fields saved filters, boards and dashboards use, and which fields nothing uses. Scans only read. After a review, admins can move unused fields to Jira’s trash and restore them.
• Getting started with Field Sweep
  Your first scan with Field Sweep for Jira in four steps: open the app, run a scan, read the Overview, check the Fields list. Plus what it does not do, how to clean up a field in Jira and short answers. English and Japanese.

Windows

• Markshot: free screenshot annotator for Windows
  Press Ctrl+Shift+4, drag over the screen, add arrows, boxes, text and step numbers, blur what you can't show, and save as PNG. Free on the Microsoft Store. Your images are never uploaded.
• Add arrows and text to a screenshot on Windows: what Snipping Tool can do
  Need arrows or text on a Windows screenshot? Snipping Tool has arrows under Shapes; text goes in through Edit with Paint. Steps, limits and a free option.
• Path too long or invalid file name? Find the files that will not copy
  A Windows app that lists the paths that are too long and the file names that cannot be used, before you move or back up a folder. Enter the destination to see lengths after the move.