The Scenario
You're setting up a Paystack storefront for your retail brand and launching next week. Your product manager put together a table of 20 products in an Excel workbook — product names, descriptions, prices in naira, and stock quantities. The launch checklist says "load products to Paystack storefront" and it's been on your to-do list for four days.
Your developer is handling payment routing. The product catalog is yours to handle.
The bad version:
- You open Paystack Commerce and click Create Product.
- You fill in the product name, paste the description, enter the price — and realize you need kobo, not naira, so you multiply by 100 on your phone's calculator and type the result.
- On product 6, the description is 280 characters and Paystack has a 200-character field limit you weren't expecting. You shorten it in Paystack but now the Paystack version and the Excel version say different things. You update Excel too, but now you're maintaining two sources of truth.
20 products. Three separate conversions. Two versions of each description. One week to launch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your product catalog and creates each Paystack product through the API — handling kobo conversion and storefront assignment — then writes a status back to the workbook so you know exactly what landed.
Read my Excel 'Products' table and for each row create a Paystack product with name, description, price, and quantity columns, then add all of them to my existing storefront ID in cell A1.
What You Get
- Each product created as a Paystack product with name, description, price, and quantity from the row
- Products added to the storefront ID referenced in cell A1
- Confirmation or error written to the Status column per row
- All 20 products loaded in one run — no dashboard entry, no unit conversion in your head
What If the Data Is Not Quite Ready
Prices are in naira and need to be in kobo
Read my 'Products' table and for each row create a Paystack product using name, description, price converted to kobo (multiplied by 100), and quantity — add each product to the storefront ID in cell A1.
Some descriptions are too long and need truncating
For each row in the 'Products' table, truncate the description to 200 characters if it's longer, then create a Paystack product with name, truncated description, price in kobo, and quantity — add to storefront ID in A1, and write 'TRUNCATED' to the Status column for any row where the description was shortened.
You need to create the storefront first, not reference an existing one
Create a new Paystack storefront called 'Lagos Retail Hub', then for each row in the 'Products' table create a product with name, description, price in kobo, and quantity — add all products to the new storefront.
Create storefront, convert prices, truncate descriptions, and load all products in one shot
Create a new Paystack storefront called 'Lagos Retail Hub', then for each row in the 'Products' table convert price to kobo, truncate description to 200 characters (marking 'TRUNCATED' in Status), create a Paystack product, and add it to the new storefront.
Loading all 20 products in one prompt means your developer can QA the storefront the next morning — not waiting three days while you work through the UI form by form.
Try It
Open the Excel workbook where your product catalog lives, then Get the 7-day free trial of SheetXAI and ask it to load your products into the Paystack storefront in bulk. For related workflows, see how to create payment pages for specific campaigns, or export your transaction history once sales start coming in.