Mastering WooCommerce Sales: Ditch Per-Product Editing for Smart Rules

Running a sale on a handful of products is easy. But when your catalog grows past a hundred items—like my wife Lena’s art store at artbylena.com—editing each product individually becomes a soul-crushing chore. Lena spent an entire evening setting sale prices on 40 flower paintings for Mother’s Day, only to repeat the process when the sale ended. That’s when we discovered a smarter approach: rule-based discounts. Instead of writing prices onto each product, you define a rule that applies automatically. Below, we answer the most common questions about this game-changing method.

Why is per-product sale pricing unsustainable for a large catalog?

WooCommerce’s default sale model lets you set a sale price, start date, and end date directly on each product. This works fine for one or two items, but it does not scale. Lena’s catalog of over 120 paintings requires editing each piece individually—opening the product, entering the sale price, setting the window, and saving. For her 40-flower painting sale, that meant 40 repetitive edits. Worse, she had to track original prices in a separate spreadsheet, which introduced errors. After the sale ended, she needed to manually clear every sale price. This approach is time-consuming, error-prone, and demoralizing for anyone managing a growing product line.

How does thinking of a sale as a rule instead of a price change everything?

When you treat a sale as a rule, you stop modifying product data. Instead, you create a condition: “If product is in Flowers category, apply 20% discount from May 1 to May 11.” The rule lives alongside your products, not inside them. At display time, the system calculates the correct price based on the rule. No prices are overwritten, so when the window closes, prices revert automatically—because nothing was ever changed. For Lena, setting up the rule took two clicks: select the category, type “20”, and pick the dates. The 40 paintings were instantly on sale. She never touched a single product page.

What is TIV Sales Assistant and how does it implement rule-based discounts?

TIV Sales Assistant is a WooCommerce extension that replaces per-product sale editing with a rule engine. It lets you define filters (categories, tags, price ranges, etc.), discount type (percentage or fixed amount), a time window, and a priority order for when multiple rules apply. The plugin computes the discounted price on the fly—at product display or cart time—without writing anything to the database. This means zero cleanup after the sale. It’s a set-and-forget solution that scales effortlessly from 10 to 10,000 products.

What are the shortcomings of WooCommerce’s built-in bulk editor for sales?

WooCommerce’s bulk product editor does have a “Set sale price” action. But it has two critical flaws. First, it only sets prices—it does not remove them. When your sale ends, you must manually bulk-edit again to restore original prices. If you saved original prices in a spreadsheet, that spreadsheet becomes your source of truth—and the database inevitably drifts. Second, the bulk editor’s filtering is imprecise. To target “all flower paintings done in oil,” you must pre-filter by the oil tag. If you forget that step, you end up discounting every flower painting, not just the oil ones. Mistakes from lossy filters can cost you real revenue.

How do rule-based discounts handle sale expiration and price reversion?

Because a rule-based system never writes the sale price into the product’s database entry, there is nothing to revert. The rule includes an end date and time. When that moment passes, the rule stops applying. The product’s displayed price returns to its regular price automatically. Lena doesn’t need to log in at midnight to clear prices. The system does it for her. There is no “debris” in the database—no stale sale prices lingering and no need to run a cleanup script. It’s a clean, worry-free expiration process.

Can rule-based discounts handle complex conditions like multiple categories or tags?

Yes, rules can combine multiple filters using AND/OR logic. For example, you could create a rule: “20% off products that are in the Flowers category AND tagged with Oil” or “15% off all items in either the Landscapes category OR the Music series.” You can also add priority levels to resolve conflicts when a product matches more than one rule. This flexibility lets you run simultaneous promotions without double-discounting or missing products. The rule engine evaluates all active rules and applies the highest-priority one, or the most generous, depending on your settings.

What are the main advantages of not writing sale prices to products?

Not writing sale prices to products eliminates data pollution. Your product database always retains the original price, giving you a single source of truth. There’s no risk of a sale price accidentally becoming permanent if you forget to clear it. It also makes analytics cleaner—historical data isn’t cluttered with old sale values. For store owners, it saves hours of manual work: no more batch editing before and after every promotion. And because the rule lives independently, you can schedule sales weeks in advance, start and stop them with confidence, and even run recurring sales without touching the products again.