Custom WooCommerce plugin for individual B2B customer pricing
3–5 s → under 1 sshop page load
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
Page load (shop)
Pricing rules
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.
Need help?
I offer professional help with what you just read about.
Ready for a website that works?
Answer two quick questions and see which solution fits you — with a price. No meeting to book.