How-to guides

Step-by-step help for the Hullspark apps and for the chores they solve in Wix, Excel, Confluence and Jira, grouped by task.

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

Wix Stores: shipping, packing and accounting

• Japan Shipping Label CSV: Wix orders to Yamato B2, Click Post and Sagawa CSV
  A Wix app that turns unfulfilled orders into import CSV files for Yamato B2 Cloud, Japan Post Click Post and Sagawa e-Hiden III, and flags bad postal codes and over-long names before you download. The app screen is in Japanese.
• Shipping label CSV import error in Japan: address too long or bad postal code
  Why a Japanese shipping label CSV fails to import with an address too long or a postal code error, the field limits of Yamato B2 Cloud, Click Post and Sagawa e-Hiden III, and how to fix each one by hand.
• Print gift messages, buyer notes and custom fields on Wix packing slips
  What a Wix packing slip prints, what it leaves out (checkout custom fields, gift messages, buyer notes), and how to get them onto a printed page, with Wix Help Center sources.
• Packing Slips and Pick Lists (formerly Picking & Packing List): pick list and packing slips from Wix orders, with photos and barcodes
  Turns the orders waiting to ship into one combined pick list and a packing list per order. Prints the buyer note, checkout custom fields, delivery instructions and per-item custom text.
• How to print packing slips for multiple Wix orders at once
  Wix prints a packing slip from inside each order, one at a time. What the Print Orders button does, what users report about it, and how to get a packing list for every order in one file.
• How to print packing slips with product photos and barcodes in Wix
  What Wix prints on a packing slip, what it leaves out (product photos and barcodes are not in its help article), and how to add photos and Code 128 SKU barcodes with an app.
• How to get one pick list for all your unfulfilled Wix orders
  Wix has no list that adds up each product across your orders. What printing and exporting gives you, how to total it in a spreadsheet, and how to get one pick list.
• Sales Journal CSV: paid Wix orders as an accounting import CSV
  For shops in Japan: a CSV for Yayoi or freee, split by 10% and reduced 8% consumption tax, with no customer names or addresses. Japanese screen only. Free for up to 20 orders a month.
• How to add tracking numbers in bulk in Wix Stores (import a CSV)
  Wix adds tracking numbers one order at a time. What the built-in way does and cannot do, and how a CSV import with preview and dry run works.

Wix Stores: inventory and stock

• Low Stock Alert: Wix low stock notifications, a morning summary and an order note by supplier
  A Wix app that alerts your phone and dashboard bell when a product is low or out of stock. Free with no limit on products watched; no email is sent.
• 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.
• How to change the low stock number in Wix Stores
  The low stock message shows to shoppers below 10. Where the number can be changed, why it never alerts you, and how to get an alert at your own number.
• Can Wix send me a daily list of low-stock products?
  Wix can email an Analytics report on a schedule, but Low Inventory is a forecast. What you can set up, and how to get one morning message.
• 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.
• Stocktake: update Wix stock from a physical count in one go
  Type or paste the quantities you counted, see the gap to your Wix stock, confirm once and update. Before and after numbers are kept in a history you can export as CSV. Free for up to 30 products per update.
• 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.
• Product Shelf Notes: shelf codes and packing notes for every Wix product
  A shelf code, a packing note and a supplier next to each product, one list sorted by shelf code, and a CSV for picking or a stocktake.
• Sold-out to the End: move sold-out products to the end of a Wix Stores category
  Moves sold-out products to the end of the categories you switch on; a product returns to its place when the stock update arrives.
• Move sold-out products to the end of a category in Wix Stores
  Wix Stores has no setting that moves sold-out products to the back of a category. Reorder by hand, or use an app that does it when stock changes.
• Can Wix Stores hide out-of-stock products automatically?
  No setting hides them by itself. How to hide them by hand, keep them visible with back-in-stock and pre-orders, or move them to the end of the category.

Wix Stores: product SEO, info sections and plans

• Product SEO Bulk Edit: preview, rewrite and undo product SEO titles in bulk
  Write a title and description template, compare now and after, apply only the products you tick, and undo a run from its saved record. Free for up to 20 products per run.
• Auto Order Tagger: tag Wix orders automatically when they are approved
  Set a rule such as an order total of at least an amount and approved orders get the tags. Private tags, an Activity log, Free for 2 rules. On the Wix App Market.
• How to tag Wix orders automatically
  What Wix's built-in order tags do (by hand, one or many orders, filter by tag), where they stop, and how to have tags added on their own.
• 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.
• How to export Wix product SEO titles and meta descriptions to a spreadsheet
  Wix cannot export the SEO text saved on your products, and the product CSV leaves it out. What Wix offers instead, and how to get one spreadsheet.
• How to find Wix products with a missing or duplicate SEO title or description
  Wix does not list products with a blank or repeated SEO title or description. What the products list and a crawler show, and how to get a list to fix.
• How to find and replace text in Wix product SEO titles and descriptions
  Wix has no find and replace for the SEO title and description of products. What the default settings can fix, and how to replace the text on many products in one run with a preview and undo.
• How to add alt text to Wix Stores product images in bulk, and find the ones missing it
  Wix edits alt text one product at a time, with Copy to all for that product only, and its help describes no filter for missing alt text. What Wix offers, and how to count, fill and undo in bulk.
• Info Section Bulk Manager: remove or replace info sections on many Wix products
  Remove or replace info sections on many products in one run, after a preview, with undo from the history.
• How to remove or replace an info section on many Wix Store products at once
  Wix Stores can remove or swap an info section on many products at once on the newer product page, but not on the previous one. The exact More Actions steps, the limits, Catalog V1 vs V3 and how to tell which you have, with Wix sources.
• Does Wix Stores keep a history of product price and stock changes?
  Wix says Stores cannot track a product’s price or inventory history. What the Inventory over Time report shows, and how to keep dated exports of your own.
• Plan Switch Guard: find Wix members who hold two pricing plans at once
  Lists members with overlapping pricing plans, shows the two orders side by side, and ends the old order after you confirm.

Wix Bookings and calendars

• Bookings Bulk Editor: edit Wix Bookings services in bulk and export to CSV
  List services, export to CSV, change prices, names and visibility for the selected ones, and read a before-and-after table first.
• Closure Days for Bookings: block new Wix Bookings on holidays, Obon and New Year
  Pick dates or a Japanese-holiday preset, see existing bookings, then stop new bookings for every staff member and room.
• 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.
• Booking List Print & CSV: day and week sheets from Wix Bookings
  Print by staff member as an A4 PDF or export a CSV. Customer names are not read.
• 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.
• How to print each staff member's daily schedule from Wix Bookings
  The Staff view has no print button. What Wix offers (Booking List filter, CSV), where it stops, and one sheet per person on Letter or A4.
• Wix Bookings CSV export: how to get a clean list for the month
  The two export routes, why the file can look empty or messy, and a CSV of date, time, service, staff and head count without client details.
• Monthly Booking Calendar: show Wix Bookings classes as a month grid
  Tap a date to see that day's classes and the seats left. Classes only.
• How to print a monthly class schedule from Wix Bookings
  Wix Bookings has no schedule print button; its CSV export is a booking list. What the app prints on one A4 or Letter page, and the limits.
• Does Wix Bookings have a monthly calendar view for classes?
  On your site Wix shows class times by the week and lists a monthly view of classes as a feature request. What you can do today, and how to show a month grid.
• How can I show all my Wix Bookings classes for the whole month?
  Why a Services page may show only a few days, why one-time classes can be missing, and how to show the month with seats left.
• Can the Wix Bookings calendar show how many spots are left?
  Wix says the Class Timetable and Daily Agenda show spots left but the Booking Calendar does not yet. What each view shows, and how to see seats left across a month.
• How to edit many Wix Bookings services at once
  Wix Bookings edits services one at a time and has no service import or export. What Wix says, a read-only CSV route through the CMS, and an option for bulk changes.
• How to create many Wix Bookings services from a CSV
  Wix Bookings has no CSV import for services. What Wix says, what owners ask in its forum, and how a spreadsheet import of appointment services works.
• Business Day Calendar: a Wix calendar with Japanese holidays and your closing days
  For shops in Japan: marks weekly closing days and national holidays on your site and shows the next closure. Pro adds one-off closing days and a next-shipment line.

Wix Blog

• How to add a table of contents to a Wix blog post
  Wix says a table of contents cannot be added to a blog post, but anchors can make one by hand. The steps, their limits, and an automatic option.
• Table of Contents by Hullspark: an automatic table of contents for Wix Blog
  Built from each post's headings, Japanese headings included. Blog posts only.

Wix Events

• Choose the columns of a Wix Events guest list and print a check-in sheet
  The Wix export steps, then how to choose and order the columns, group by ticket and print a sign-in sheet. 日本語
• Guest List Builder: choose the columns and print a check-in list for Wix Events
  Pick the columns of your guest list, group by ticket type, download a CSV or print a sign-in sheet.

Wix Restaurants

• Allergen Chart for Restaurants: a filterable allergen chart for your Wix site
  A Wix app that turns the Contains, Does not contain and Not entered status you set for each dish into a chart on your site. Free for up to 30 dishes. A display aid, not legal advice.
• 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.
• How to compare two Excel sheets or files for differences
  Side by side, a formula, conditional formatting and Spreadsheet Compare: where each stops, and how to get one list of changed cells, added rows and removed rows.
• How to split an Excel sheet into multiple files by column value
  Filter and copy, PivotTable filter pages and macros: what each gives you, where it stops, and how to cut one file per person or branch in one step.
• Excel file size too large? How to find why and reduce it
  Save as .xlsb, compress pictures, the pivot cache and excess formatting, where they stop, and how to see what the size is made of before you clean.

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.
• How to merge duplicate labels in Confluence
  Confluence has no merge for labels. The built-in way to fix how-to, how_to and howto page by page, where it stops, and how to merge a whole group at once.
• How to rename or delete a label on many Confluence pages
  Confluence has no rename for labels and no site-wide delete. The manual steps from Atlassian Support, where they stop, and how to rename or delete a label across all pages.
• 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.
• Change History Limit: show only the latest versions of a Confluence page
  A macro that lists the last 3 to 50 versions of a page or blog post, with minor edits, a time window and authors as options.
• How to limit the Confluence Change History macro to the last N versions
  What Atlassian documents for the macro, what suggestion CONFCLOUD-32315 asks for, and one way to show only the latest versions.
• How to find the largest attachments in Confluence Cloud and free up storage
  What the storage page, Atlassian Support and delete-and-purge do, where they stop, and a way to list unused attachments by size.
• How to see how much Confluence storage you can free up before deleting attachments
  Confluence shows storage totals, not what a cleanup would free. What the built-in views tell you, the gap before you delete, and a read-only way to see reclaimable size by space, type and age.
• 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 find and clean up unused components in Jira Cloud
  Jira Cloud has no screen that lists components with zero issues. Here is how to find them with the Components page, JQL and the REST API, what deleting a component does to its issues, and a read-only script, with Atlassian sources.
• How to apply a default permission scheme, category and assignee to every new Jira project
  Jira Cloud has no setting that gives every new project the same permission scheme, category and default assignee. The built-in routes (sharing settings at creation, editing by hand), where they stop, and how New Project Defaults for Jira does it on creation.
• 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.
• How to find unused custom fields in Jira Cloud and check where a field is used
  What the Fields screen, the Site optimizer, a JQL search and delete-and-restore tell you, and how to check filters, boards and dashboards at once.

Windows

• Fix garbled characters in a CSV file: free methods with Excel and Notepad
  Why a CSV opens garbled in Excel (Shift_JIS, UTF-8, BOM) and how to fix it, with Microsoft's documentation cited.
• 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. 日本語
• Sheet Compare: compare two .xlsx files and list the differences
  Pick two .xlsx files and get changed cells, added rows, removed rows and column changes in one list, with a side-by-side view. Offline. 日本語
• Spreadsheet Splitter: one file per person or branch
  Split an .xlsx into separate files by the values in a column, by sheet or every N rows. Formatting stays. Offline. 日本語
• Workbook Link Finder: where does an Excel file link to other files?
  Lists the places that point to another workbook, with sheet, position, content and target. Read-only, without starting Excel. 日本語
• Reduce xlsx File Size: see what makes a workbook big
  Shows what each .xlsx is made of, then writes a smaller checked copy named name_small.xlsx. The original is never changed. 日本語
• 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.