The Scenario
It's the morning before a campaign goes live. You're the retail marketing manager and the promotion team changed the discount from 15% to 20% at 10 PM last night. You have an Excel workbook with 1,200 rows: pass IDs in column A from the original bulk creation, new discount percentages in column B. Every one of those coupon passes needs to reflect the new value before the campaign email lands in inboxes at noon.
The bad version:
- Open the Passcreator UI and try to update passes manually — you get through about eight before you realise this is going to take four hours.
- Export the pass ID list, write a script to loop through the API, discover the API credentials you copied from the developer docs have a typo, and spend 45 minutes on authentication before the first update goes through.
- Re-upload a CSV hoping Passcreator's import treats it as an update rather than a new creation — it doesn't, and now you have 1,200 duplicate passes to void.
The campaign email goes out at noon whether or not the passes are right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the pass ID and discount columns and talks to Passcreator on your behalf — updating every pass in the list without you touching a single record individually.
Bulk update all Passcreator passes listed in column A with the new discount value from column B using the pass IDs as the filter criteria
What You Get
- Each pass ID in column A updated with the corresponding discount value from column B.
- A status written into column C for each row: "updated", "not found", or the specific error.
- A summary: 1,200 attempted, 1,197 updated, 3 not found.
- Nothing touched outside the rows in the workbook.
What If the Data Is Not Quite Ready
The discount column has inconsistent formatting
Column B has a mix of "20%", "0.20", and "20" — Passcreator's API expects a decimal between 0 and 1.
Before updating, normalise column B: strip the "%" symbol and divide by 100 where the value is greater than 1. Then bulk update all passes in column A with the normalised discount value.
Some pass IDs have trailing spaces from the export
The original pass ID export had trailing whitespace on 80 rows, which will cause the API to return "not found" for those IDs even though the passes exist.
Trim whitespace from all values in column A before running the bulk update. Flag any rows where the post-trim ID is empty.
You need to apply different discounts based on a tier column in a second worksheet
The 'Tiers' worksheet maps membership level to discount percentage. Column A in the main worksheet has pass IDs, column B has membership tier.
Look up the discount for each row's membership tier (column B) in the 'Tiers' worksheet (tier in column A, discount in column B). Then bulk update the Passcreator passes in column A with the matched discount value. Flag any tiers that don't have a match.
Full normalise, join, and update in one shot
The pass ID column has whitespace issues, the discount needs to come from a tier lookup, and the campaign goes live in three hours.
Trim whitespace from all pass IDs in column A. Look up the discount for each tier in column B from the 'Tiers' worksheet. Normalise the resulting discount values to decimal format. Then bulk update all Passcreator passes using the cleaned IDs and matched discounts. Write the result into column C.
Try It
Get the 7-day free trial of SheetXAI and open the workbook with your live pass IDs and new field values, then ask it to push the update to Passcreator. See also: creating passes in bulk and the PassCreator integration overview.