Import Shopify Orders Into a Workshop Guest List

Selling a workshop through Shopify gives you an order record, but not necessarily a usable attendee list. This guide walks you through exporting paid workshop orders, checking who is actually attending, excluding refunded or canceled purchases, and preparing invitations your door team can use.

Separate payment records from attendance records

Shopify handles payment; your event guest list handles admission. Keep that distinction clear throughout the process. A paid order tells you that a purchase was completed, but the purchaser might be buying for a colleague, a team, or someone receiving a gift.

Before exporting anything, decide what a workshop purchase represents:

• A place for the purchaser.
• A party arriving together under a lead guest.
• Separate places for attendees who need their own invitations.
• A booking for a specific session, date, or location.

Write down the rule for your workshop. For example: Team purchases will receive a party invitation unless the buyer supplies individual attendee names and email addresses.

That decision affects how you interpret quantities, collect missing details, and manage arrival. Do not assume that every order equals an invitation or that every purchased item equals an attendee.

Export the paid orders for the correct workshop

Start in Shopify by identifying orders for the workshop you are preparing. Use the order information and filters available in your store to narrow the selection, then export the relevant orders.

Your selection should answer these questions:

• Does the order include the correct workshop product or variant?
• Does it belong to the correct date, session, and location?
• Is the workshop purchase paid?
• Has the order been refunded or canceled?
• Does the order include unrelated merchandise or another event?

An order date is not a workshop date. Someone may buy far ahead of the session, so purchase timing alone is not a reliable way to select attendees.

Save an untouched copy of the export before preparing your working file. Keep an order reference with your reconciliation notes so you can investigate a discrepancy without searching by name alone.

VenueWS supports Shopify orders exports: paid orders become invitations, while refunded or canceled orders are skipped. This is an export-based workflow, not a reason to assume later Shopify changes will automatically update an existing invitation.

Check attendee details before creating invitations

Review the export as an attendance document, not just a sales report. The most important question is: Will this invitation reach the person who should use it?

Confirm the purchaser is the attendee

For a straightforward personal purchase, the buyer's name and email may be appropriate. For gifts, assistant-booked registrations, and company purchases, ask for the actual attendee details.

A useful message is:

We’re preparing invitations for your workshop booking. Please confirm who will attend, the email address that should receive the invitation, and whether your group will arrive together.

Avoid substituting a shipping recipient or billing contact without checking. Those details can be useful clues, but they are not confirmation of attendance.

Resolve missing or questionable information

Check for:

• Missing names or email addresses.
• Obvious email typos or extra spaces.
• A company name where you need an attendee name.
• The same buyer appearing across several orders.
• A quantity that does not match the intended party size.
• Workshop details that conflict with the event you are preparing.

Keep unresolved purchases on a separate follow-up list rather than guessing. Preserve the original order reference when correcting attendee information, and confirm the required import fields before changing the export's structure.

Keep payment and RSVP status separate

Payment establishes the purchase. An RSVP tells you whether the invited guest currently plans to attend.

Do not treat a missing RSVP as proof that the person has not paid. Likewise, an affirmative RSVP should not override a refunded or canceled purchase.

Decide how to handle group purchases and repeat buyers

Group bookings are where a clean-looking spreadsheet can produce a confusing door list.

Use a party invitation for a group arriving together

A party invitation can suit a buyer bringing colleagues who will check in together. Confirm the lead guest and the admitted party size, and explain the arrival arrangement in your workshop instructions.

Guests can RSVP by party size from their personal page. Your operating rule should still be that the confirmed group matches the purchased workshop places; an RSVP is not an additional payment.

Use individual invitations for independent arrivals

If attendees need to arrive separately, collect their individual names and email addresses. This gives each person their own invitation rather than making everyone depend on the buyer's message.

Do not manufacture email addresses or duplicate the buyer's address to stand in for missing attendees. The same email never receives two invitations for an event, so repeated purchaser emails need review before import.

For a buyer with multiple valid orders, determine whether the purchases represent a larger party, different named attendees, or an accidental repeat purchase. Resolve the attendance arrangement without treating an email match as evidence that a purchase was unnecessary.

Reconcile refunds and cancellations before import

Review payment exceptions close to the time you prepare invitations. An export is a snapshot, and an order's status may have changed since you downloaded it.

Separate your records into practical working groups:

• Ready: Paid workshop purchases with confirmed attendee details.
• Excluded: Refunded or canceled orders.
• Needs review: Unclear payment status, missing attendee details, transfers, or mixed-order adjustments.

Partial refunds deserve particular attention. A refund might concern merchandise rather than the workshop, or it might reduce a group's purchased places. Do not assume an automated exclusion rule resolves that distinction; verify what workshop admission remains valid before proceeding.

If an order was changed to another session, check both events. The attendee should not retain an active invitation to the original workshop simply because an earlier export included it.

Keep exception notes short and useful: order reference, issue, decision, and the person responsible for resolving it. Avoid copying unnecessary payment or personal information into a file shared with door staff.

Import the orders and verify the resulting guest list

Create or select the event for the correct workshop before importing. Confirm its date, address, and arrival instructions so the resulting invitation leads guests to the right place.

Use the supported Shopify orders export workflow, then review the event's guest list before treating the import as complete. Do not assume the file's row count should equal the invitation count: line items, repeat buyers, and party bookings can make those totals differ.

Reconcile the guest list against your prepared records:

• Every eligible booking has the intended guest or party.
• Names and email addresses match your confirmed details.
• Group sizes reflect valid workshop places.
• Excluded purchases have not produced active admission.
• Unresolved records remain assigned for follow-up.

Invitations provide a signed, revocable QR code and a personal web page, with no guest app required. Email is supported; WhatsApp delivery is available if the venue enables it.

Make the message clear: this is the guest's workshop invitation and check-in information, not another request to pay. Workshop payments remain in Shopify; the guest-list software does not sell tickets or process ticket payments.

Recheck changes and prepare the door team

Before the workshop, compare your latest Shopify records with the event guest list. Review new purchases, cancellations, refunds, and attendee substitutions since the last export. Revoke invitations that no longer represent valid admission, and resolve uncertain records before guests arrive.

Give the door team a simple exception procedure:

1. Scan the guest's invitation using a paired phone or tablet.
2. Use the scanner's guest list when someone cannot find their invitation.
3. Refer payment disputes, transfers, and missing bookings to a designated organizer.
4. Record the resolution so another staff member does not have to repeat the investigation.

Do not rely only on a purchase-confirmation screenshot. It may predate a refund, cancellation, or session change.

For this workflow, VenueWS for workshops connects the prepared guest list with invitations and QR check-in. Scanners can work offline and sync later; pair devices in advance and make sure staff know who handles exceptions.

Close the loop from purchase to arrival

A reliable workshop guest list depends on clear attendance rules and careful reconciliation, not simply moving a file. Keep Shopify as the payment record, verify who each purchase admits, and review changes after import so your team can welcome the right people with fewer last-minute questions.