Custom WooCommerce plugin for individual B2B customer pricing
Plantepakken needed differentiated prices per B2B customer in WooCommerce. Standard plugins couldn't handle thousands of pricing rules efficiently. I built a custom plugin with a dedicated database table, CSV import and automatic price display.
WordPress
WooCommerce
Custom plugin
B2B
Industry
B2B E-commerce
Services
- Plugin development
- WooCommerce
- Database design
- CSV integration
Timeframe
3 weeks
Problem
Plantepakken sells plants to business customers with individual pricing agreements. They had thousands of customer-specific pricing rules stored in ACF fields, which was slow and impossible to maintain. They needed a solution that could handle bulk import of prices, display correct prices in the shop and scale with business growth.
Baseline (before)
Price administration
Before: Manual via ACF fields
After: Bulk CSV import in seconds
Page load (shop)
Before: 3-5 sec (ACF lookups)
After: < 1 sec (custom table)
Pricing rules
Before: Hard to manage
After: Full customer overview with active discounts
Actions
- Analyzed existing ACF pricing structure and identified bottlenecks.
- Designed custom database table (wp_pp_customer_prices) optimized for fast lookups.
- Built admin interface with customer overview, price editing and status pages.
- Implemented CSV import/export for bulk updating thousands of pricing rules.
- Integrated with WooCommerce hooks so prices display correctly in shop, cart, checkout and order confirmations.
- Migrated existing ACF data to new table without data loss.
Results
- Price administration reduced from hours to minutes with CSV import.
- Shop performance significantly improved with custom database table.
- Staff can maintain customer prices without technical help.
- Plugin scales seamlessly with business growth.
What we learned
- Custom database tables significantly outperform post_meta/ACF at high data volumes.
- CSV import is the most effective method for bulk B2B price administration.
- WooCommerce has well-designed hooks that make it easy to customize price display throughout.
Ready for a website that works?
Book 15 min and let's figure out what creates the most value for you.