SEEGEA

E-commerce price grid: structure, examples and editing tools

A price grid is, above all, an internal discipline. Without a clear framework, every promotion drifts, every new country adds inconsistency, and margin ends up leaking through rounding.

9 min readApril 17, 2026

A well-built price grid is the difference between a store that controls margin and one that suffers it. On Shopify or PrestaShop, the grid can live in a shared Google Sheet, in native price lists, or in a dedicated tool. What matters is that it formally exists and is actively maintained.

The 4 axes of an e-commerce price grid

A good grid crosses four dimensions:

  1. Product — SKU or family (manufacturer reference, category, line).
  2. Customer segment — B2C, pro, reseller, enterprise, partners.
  3. Channel — direct site, marketplace (Amazon, Cdiscount), outbound feeds (Google Shopping, Meta).
  4. Context — full price, scheduled promo, sales period, private sales.

Concrete examples: 3 grid models that work

Single-product DNVB grid

DTC brand with 30 SKUs, B2C only, 3 currencies (EUR, USD, GBP). Sheet grid with one column per currency, psychological rounding via formula, maintained by the CMO. Perfect up to 100-200 SKUs.

Hybrid B2C + B2B grid

Textile brand with 500 SKUs, 2 channels (Shopify B2C + PrestaShop B2B). Centralized Airtable grid with 2 price columns (B2C / B2B), weekly manual sync. Works but fragile beyond 500 SKUs.

Advanced multi-segment grid

Distributor with 3,000 SKUs, 5 customer segments (public, pro, craftsman, reseller, enterprise). Grid in a database (Seegea or PIM), native Shopify Plus price lists, daily ERP export. Tabular editing is essential at that scale.

Building your price grid in 6 steps

  1. List real segments — not marketing segments, but the ones where you already apply a different price (retail consumer, pro with VAT ID, reseller with partner code).
  2. Pick currencies — based on real markets. EUR + USD covers 80% of French DNVBs.
  3. Define rounding rules — psychological (.90, .99), commercial (.50, .00), or exact (daily FX rate). Document the rule per currency.
  4. Choose the support — Sheets below 200 SKUs, Airtable or Seegea above. Shopify Plus price lists are useful but do not replace a single source.
  5. Sync with the CMS — push to Shopify or PrestaShop. Avoid CSV roundtrips that silently drift.
  6. Set up a monthly audit — grid ↔ CMS ↔ outbound feed gap check. 30 min/month saves weeks of cleanup later.

The 3 mistakes that make a grid unusable

Mistake #1: no single source. If price lives in Shopify, Google Shopping, a Sheet and an ERP with no clear authority, you will spend 4 days per month fixing gaps.
Mistake #2: inconsistent rounding. 19.90 EUR becomes 20.67 USD without psychological rounding, breaking perception. A documented rule (19.95 USD or 19.99 USD) applied automatically removes guesswork.
Mistake #3: no trace of who changed what. Without history, impossible to audit a margin drift. Seegea keeps 365 days of per-product history, with user and full diff.

Seegea connects to your CMS

ShopifyPrestaShopMicrosoft ExcelGoogle Sheets

Price grid and Shopify Plus price lists: how they fit together

Shopify Plus offers market-level price lists (B2B catalog, multi-currency). Powerful, but not a replacement for a source grid. The Shopify Plus price list is the execution channel — it needs an external source that computes and pushes the right prices. Seegea plays that source + control role.

Price grid and PrestaShop: customer groups and specific prices

PrestaShop natively handles customer groups (B2C, Pro, Reseller) with distinct prices, and specific prices with start/end dates. Backoffice editing is viable up to 200-300 SKUs. Beyond that, the UI slows down and mass edits become tedious — Seegea edits 500 prices in minutes on PrestaShop too.

Comparison: tools to maintain a price grid

CriterionSheets + manual syncSeegea
Setup time1 hour48 hours (guided onboarding)
Editing 500 prices20 to 30 min + manual push3 min + auto push
Multi-currency with roundingComplex formulasConfigurable rules
Change history90 days (Google)365 days with diff
Rollback after mistakeManual, listing by listingCtrl+Z, full bulk
Immediate push to CMSCSV or ad hoc APINative, immediate
Per-segment pricesSeparate columnsDedicated views per segment

Structure your price grid with Seegea

30-min Google Meet · we model your grid live

Structure your price grid with Seegea

Price grid and SEO: the permanent-strikethrough trap

A healthy grid plans periods without promotion. Why? Because a permanent strikethrough (over 12 consecutive weeks) loses credibility, and because the Omnibus directive requires a reference price actually applied during the previous 30 days. If your grid always shows a discount, you no longer have a valid reference price — so no compliant strikethrough either.

Maintenance: the real topic

Building a grid is a project. Maintaining it is a ritual. The best teams we work with run a monthly audit (30 min) and a quarterly cleanup (2 hours). Without that rhythm, even the best grid degrades in 6 months.

Conclusion: the price grid is an asset, not a constraint

A clean, maintained grid becomes an operational asset that accelerates everything: new country launch, new line, flash promo, catalog refresh. Seegea was built in France, between Annecy and Chantilly, by e-commerce operators who know this work from the inside. If maintaining your grid is starting to weigh, a live demo will show you exactly what can be automated.

Created in France (Annecy – Chantilly) · Email & Google Meet support

FAQ

It is the reference that defines, for each product, its price in each context: channel (B2C, B2B, marketplace), customer segment (consumer, pro, reseller), currency (EUR, USD, GBP), and period (full price, scheduled promo, sales). A clean grid limits errors and eases margin audits.

See Seegea in action

Book a 30-min live demo on Google Meet. No commitment.

Book a demo