LinkyFlow — autonomous agents and live business data in Excel or on the webLinkyFlow
WooCommerce coupons loaded in LinkyFlow before new codes are created in bulk (demo data)

Create WooCommerce coupon codes in bulk from Excel

In LinkyFlow, open WHAT, go to its last group, Create, and pick Create Coupon. Fill one row per code: code, discount_type (percent, fixed_cart or fixed_product), amount, and if you want them, an expiry, a usage limit, a minimum spend and whether it can be combined. Click Publish: each row becomes a WooCommerce coupon. Then load Coupons to see how many times each code has been used.

Lila Studio, chapter 4 of 4: launch weekend. The example follows Léa's demo WooCommerce shop; the screenshots show the LinkyFlow web app on demo data.

What you need

The columns of Create Coupon

ColumnWhat it does
code (required)what the customer types at checkout, e.g. WINTER10
discount_type (required)percent, fixed_cart (off the cart total) or fixed_product (off each product)
amount10 is 10 % on a percent code, or 10 in your currency on a fixed one
date_expireswhen it stops working
usage_limithow many times it can be redeemed in all
minimum_amountthe cart total it needs
individual_useTRUE: it cannot be combined with other codes

Create coupons in five steps

  1. Load Coupons first (FROM your store, WHAT Coupons) to see the codes that already exist, so you don't reuse one.
  2. In WHAT, go to the Create group and pick Create Coupon: a blank grid, one column per field above.
  3. Fill the rows. For a series of unique codes, build them in a free column with a formula, such as ="LILA-"&UPPER(A2), paste the values into code, and fill the type, amount and limit down every row.
  4. Read the Changes panel, then Publish. The rows go out in WooCommerce batch calls; a row WooCommerce refuses is shown with its error, and the others are created.
  5. Load Coupons again: the new codes are there, and Usage Count tells you, as the days go by, how many times each one has been used.

Change a coupon later

Load Coupons and click Edit: the code, the discount type, the amount, the expiry and the usage limit can be changed and published. The minimum spend and individual use are set when the coupon is created; change them in WooCommerce afterwards.

A promotion with no code is a price, not a coupon: edit Sale Price on Products and publish (Catalog & bulk pricing).

The Lila Studio example: launch weekend

The winter collection goes live Saturday. Léa has the products (chapter 3), the stock (chapter 2), and for the first time, the nerve to actually push a launch.

A launch needs offers. Not one — several:

  • a public code for the newsletter: 10% off the weekend.
  • a little welcome discount for first-time buyers.
  • and the ambitious one: a unique code for each of the thirty micro-influencers she's sending a scarf to, so she can see whose audience actually shows up.

Thirty-two coupons. In the WooCommerce admin that's thirty-two trips through the "Add coupon" form, each with a code, a type, an amount, an expiry. By Thursday night she'd hate the collection. She knows there's a better way now, because by chapter four, the better way is just the way.

Look before you leap

Old habit, good habit: before creating, she loads what's already there so she doesn't reuse a code by accident. Lila Studio → Coupons → Load.

Existing WooCommerce coupons loaded in the LinkyFlow web app: code, amount, discount type, expiry and usage count (demo data)

One tidy table: codes, amounts, types, expiries, how often each was used. She scans it, confirms WINTER10 is free, and moves on. (That read-then-write rhythm is the same one she's had since chapter 1.)

The wall of coupons

She opens What again and picks Create Coupon, in its last group, Create. Blank grid, coupon fields as columns. And now the spreadsheet does the thing spreadsheets are for.

The two simple ones she just types:

code: WINTER10   | discount_type: percent     | amount: 10 | date_expires: 2026-12-07 | usage_limit: 1000
code: WELCOME5   | discount_type: fixed_cart  | amount: 5  | minimum_amount: 35       | individual_use: true

WINTER10: 10% off, dies Sunday night, capped so a screenshot leak can't drain it. WELCOME5: €5 off a €35 cart, and individual_use so it won't stack on top of the weekend code.

Then the influencers. Thirty unique codes would be a nightmare by hand, but it's a column, and columns are easy. She drops her list of thirty names beside the grid, builds LILA- + each name with a formula, pastes the codes in, fills the type and amount down all thirty rows in one drag, and just like that she has thirty distinct codes she can track one by one.

code: LILA-MAYA   | discount_type: percent | amount: 15 | usage_limit: 50
code: LILA-NOAH   | discount_type: percent | amount: 15 | usage_limit: 50
code: LILA-INES   | discount_type: percent | amount: 15 | usage_limit: 50
...

Thirty-two coupons, sitting in rows, none of them live yet.

One publish

She clicks Publish. Every row becomes a real coupon in WooCommerce, and the familiar Changes published. confirms it. She reloads Coupons and there they all are — WINTER10, WELCOME5, and the thirty LILA- codes — ready to paste into a newsletter and thirty messages.

Had a code been refused, that row would have shown its error and the rest would have been created. It wasn't. The whole campaign existed in about the time it takes to write one coupon by hand.

Next Monday, she'll do the thing she couldn't do before: load Coupons, sort by Usage Count, and see whose code actually sold. Maya's was used twelve times; half the list, never. That's not a guess anymore — it's a column.

The same trick, in Excel, every launch

Léa built the influencer wall in Excel — names, a formula, a drag — and published from the same panel. A campaign that would be a slog in the admin became a column she filled once. For the next sale, she'll duplicate the sheet, change the codes, and publish.

Four chapters later

Look back at Léa's week. She started buried under eleven browser tabs, unable to even see her shop. By Saturday she can:

Same shop, same spreadsheet she always loved, now wired to WooCommerce, every change published over its REST API. No CSV round-trips. No import plugins. No eleven tabs.

FAQ

Can I create unique WooCommerce coupon codes in bulk? Yes: one row per code in the Create Coupon template, built with a formula if you like, then one Publish.

Can I change a coupon after creating it? Yes: its code, discount type, amount, expiry and usage limit, from the Coupons sheet. The minimum spend and individual use are set at creation.

How do I see which codes were used? Load Coupons with Usage Count, and sort it. The Coupon Totals report counts the coupons by type.

Get started

LinkyFlow for WooCommerce lists every WooCommerce resource and the three setup steps; coupons and customers are covered in Customers & coupons. Connect your store with a Read/Write key (setup guide), then install the Excel add-in: the Free plan connects one store. New to the series? Start where Léa did: read your WooCommerce store in Excel.