Back to blog

When Size and Color Aren't Enough: Metafield-Based Targeting for B2B Catalogs

A B2B catalog that refused to fit inside size and color led to Metafield-Based Targeting: discount rules that read your own variant metafields, synced from your ERP, and stay correct as the catalog changes.

Discount Prime Team
Discount Prime Team
· 9 min read
When Size and Color Aren't Enough: Metafield-Based Targeting for B2B Catalogs

The feature that became Metafield-Based Targeting did not start on a roadmap. It started in a meeting with a B2B business whose catalog refused to fit inside size and color.

We sat down with a wholesale business that runs its catalog out of an ERP. Their products were not simply "Small, Medium, Large." A single SKU carried a stack of attributes that mattered to pricing: a wholesale tier, a minimum order quantity, an account type, a material, a season code, a lead time, a customs code. None of that fits Shopify's idea of a variant, which is built around options like size and color. Yet every one of those attributes was something they wanted to run a promotion against.

That meeting is the reason Metafield-Based Targeting exists. It lets you target discounts dynamically from your own metafields, at the variant level, across the B2B campaign types: Tiered Unit, Wholesale / B2B, and Dropshipping Pricing. Your rules stay correct automatically as your catalog changes.

Why tags and collections were not enough

Most Shopify discount tools target products by collection, tag, vendor, or product type. That works until your catalog has real depth, and then two problems show up fast.

First, those signals live at the product level, not the variant level. A B2B catalog often needs the opposite: this exact variant is Gold tier, that one is Bronze; this SKU has a minimum order quantity of 12, that one does not. Product-level targeting cannot see inside the product.

Second, tags and collections are a snapshot that someone has to maintain by hand. The moment your ERP adds a season, changes a tier, or updates a lead time, your tag-based audience is stale, and nobody notices until a promotion prices the wrong things.

The data the business needed was already in Shopify. It was sitting in metafields, synced from the ERP. Nothing was acting on it.

What we built: rules that read your own metafields

Metafield-Based Targeting adds a new product source to the campaign builder: a variant metafield rule. Instead of picking a collection, you write a condition against any metafield you have, grouped by namespace, with the operator that fits its type.

Pick a field (wholesale tier, minimum order quantity, account type, material, season, lead time, weight, inventory on hand, anything you store), pick an operator (is equal to, is greater than, is before, contains, is true), and set a value. Numbers, money, enums, booleans, dates, and text each get the right comparison. Combine several conditions and choose whether a variant has to match all of them or any of them. The match runs at the variant level, live, with a running count of exactly how many variants and products are in.

Because the rule reads the same metafields your ERP writes, the targeting speaks your business's own language instead of Shopify's. "Discount every Gold-tier variant with a lead time under 30 days" becomes a sentence you build in the campaign, not a tagging project.

The design decisions that keep it safe

A rule engine that touches pricing has to be careful. Three choices matter most.

Auto-update keeps the campaign in sync. When a product's metafield changes, the match re-runs, so as your ERP pushes new tiers, costs, or attributes, the promotion follows automatically. The manual monthly audit disappears.

The live preview shows the truth before you save. Every matched variant is listed under its product, with a count, and products where only some variants match are flagged in amber, so you can see at a glance that a SKU is only partially included. No silent surprises at checkout.

Exclusions only ever subtract. You can remove individual variants or exclude by collection, tag, price, or specific products, but an exclusion can never quietly add a variant the rule did not match. Off-rule variants stay off. That single guardrail prevents the most dangerous failure mode in any targeting system: discounting something you never meant to.

Metafield-Based Targeting is a Prime-plan feature, and it works the same way across Tiered Unit, Wholesale / B2B, and Dropshipping Pricing, so the targeting you learn in one campaign type carries to the others.

Who this is for

This is built for catalogs that are too detailed for size and color. It is most valuable when your products carry real per-SKU attributes (tier, MOQ, account type, material, season, customs code, lead time, inventory state), when those attributes already live in metafields synced from an ERP or a PIM, and when your catalog is large enough that maintaining tags by hand is not realistic.

If you sell a handful of products with simple options, you do not need this, and standard collection and tag targeting will serve you well. Metafield-Based Targeting earns its place exactly when the catalog gets complicated.

The ERP reality behind the request

The business in that meeting is not unusual. Across the Canadian market, B2B sellers run their operations on an ERP, and the ERP, not Shopify, is the system of record for what a SKU actually is.

The spectrum is wide. Large enterprises run Oracle NetSuite, Oracle, or SAP. Mid-market and smaller businesses increasingly run leaner systems like Odoo, Microsoft Dynamics 365 Business Central, Acumatica, or Sage. We compared these systems for Shopify in our guide to the best ERP integrations for Shopify B2B and wholesale. Whatever the system, the pattern is the same: the ERP holds the rich attributes (cost, tier, account eligibility, lead time, compliance codes), and the storefront needs a way to act on them without re-keying anything.

This is where Shopify's design becomes interesting. Metafields are the bridge. They let an ERP push structured, typed attributes onto products and variants, and they turn Shopify from a simple storefront into a channel that can carry an enterprise catalog's logic. Metafield-Based Targeting is what finally lets a promotion engine read across that bridge, so the ERP's definition of a SKU drives the discount directly.

What the research says about Shopify Plus, SME, and SMB

Our partner team at J Trade Help studied why merchants of every size keep choosing Shopify as their B2B channel, and the answer maps cleanly onto plan structure. Their analysis is worth reading in full (Why Shopify and a real B2B discount migration case study), but the short version matters here.

Shopify reserves its deepest B2B machinery for Shopify Plus: company accounts, customer-specific catalogs, price lists, payment terms, draft orders, checkout extensibility, and Functions-level customization are Plus features. For an enterprise replatforming from Magento or SAP commerce, that is the tier. For an SMB or mid-market brand, the same research names the honest trade-off: complex contract pricing and SKU-level discount logic have historically needed either custom code or a partner app, because the native tools on lower plans do not reach that deep.

That is the gap Metafield-Based Targeting is designed to close. The SKU-level pricing logic that used to require Plus-only customization or a fragile custom build now runs in a configurable app layer a support team can own, on the plan the business already has. A growing wholesaler does not have to jump to Plus just to discount by tier or MOQ. The case study that prompted that research described exactly this: a B2B brand asking to move off custom-coded, SKU-level discount logic into something operations could manage safely. Metafield-Based Targeting is our answer to the same request.

Where this leaves you

Most discount tools target the catalog Shopify can see: collections, tags, vendors, sizes, colors. Metafield-Based Targeting targets the catalog your business actually runs on, the one defined by your ERP and stored in your metafields, and it keeps that targeting correct as the catalog moves. For a B2B store of any size, that is the difference between maintaining a promotion and trusting it.


Metafield-Based Targeting is available on the Prime plan in Discount Prime, across Tiered Unit, Wholesale / B2B, and Dropshipping Pricing.

Sources


Related on Discount Prime: Wholesale pricing · B2B pricing

ShopifyB2BMetafieldsWholesaleERPPricing
Discount Prime Team

About the author

Written by the Discount Prime Team - the people building and supporting Discount Prime, the smart discount and pricing app for Shopify. We share what we learn from helping merchants run volume discounts, tiered pricing, and high-converting promotions every day.

Frequently asked questions

What is metafield-based targeting for Shopify discounts?

It lets you target a discount to the exact variants that match your own metafields, such as wholesale tier, minimum order quantity, or account type, by writing rule conditions, instead of only using collections, tags, or size and color variants.

Why isn't tag or collection targeting enough for B2B catalogs?

Tags and collections work at the product level and go stale as the catalog changes. B2B catalogs synced from an ERP carry SKU-level attributes that do not fit Shopify's size and color variant options, so you need variant-level rules that read those metafields directly.

Does the rule update when my ERP changes a product's metafields?

Yes. Auto-update re-runs the match when a metafield changes, so as your ERP syncs new costs, tiers, or attributes, the campaign keeps targeting the right variants without manual edits.

Do I need Shopify Plus to use metafield-based B2B targeting?

No. Shopify Plus gates native B2B primitives, Functions, and checkout extensibility, but Discount Prime runs the SKU-level pricing logic in a configurable app layer, so SMB and mid-market stores can target by tier or MOQ without upgrading to Plus.

Run profit-first promotions on Shopify

Discount Prime brings eight discount types, margin analytics, and conflict detection into one Shopify-native app.

See pricing

Or see it live in our demo store and watch every feature working on a real Shopify store.

Related articles