Overview
A rapidly expanding retail and trade business operating across multiple depots was struggling with the daily operational overhead of managing stock, pricing updates, and product changes. Each morning, teams exported CSV files from separate systems, manually combined and cleaned them, adjusted formatting, and uploaded the results into WooCommerce.
This process was slow, repetitive, and prone to human error — often delaying updates, creating discrepancies across depots, and leaving staff frustrated and overloaded. As the business scaled, the inefficiency became a significant operational bottleneck.
To solve this, I designed and engineered a custom Stock Processing & Automation Plugin for WordPress that completely transformed the workflow. The result: consistently accurate stock updates, faster operations, and a scalable digital system that supports business growth.
The Challenge
The business faced several interconnected problems:
1. Multiple Depots, Multiple CSV Files
Each depot exported its own stock and pricing file.
Formats were inconsistent.
Column structures sometimes varied.
Not all products appeared in both files.
2. Manual Data Cleaning Every Morning
Staff had to:
- Combine CSV files
- Remove duplicate rows
- Validate columns
- Reformat fields
- Check for missing SKUs
- Identify new products
- Save final “clean” import files
This took between 30–60 minutes daily, depending on data volume and staff availability.
3. Risk of Human Error
Manual handling led to issues such as:
- Incorrect pricing
- Missing items
- Old stock lingering online
- New stock failing to display
- Upload failures due to formatting inconsistencies
4. No Visibility of New or Missing Products
The business needed to know which items had arrived or which products were referenced in CSV files but not yet created in WooCommerce.
There was no system to detect this — only guesswork.
5. Lack of Automation and Scalability
As stock volumes grew, the process became harder to manage.
The business needed something robust, repeatable, and effortless.
The Solution: Bespoke Stock Processing & Automation Plugin
I designed a custom WordPress plugin built specifically around the business’s operational workflow and data structure.
The plugin performs all of the critical tasks automatically — accurately, consistently, and in seconds.
Core Features Delivered
1. Automatic Multi-Depot File Merge
The plugin accepts CSV files from each depot and intelligently merges them into a single master file:
- Normalises field names
- Aligns column structures
- Handles missing fields
- Applies consistent formatting rules
2. Intelligent SKU Validation
Every record is scanned and compared against existing WooCommerce SKUs.
The plugin identifies:
- SKUs present in CSVs but not in the online store (missing products)
- Products in WooCommerce that no longer appear in CSVs
- Duplicate or malformed SKUs
- SKUs present in one depot but missing from the other
This instantly highlights issues that previously took hours to spot — or were missed entirely.
3. “What’s New” Detection
A major enhancement was the addition of a mechanism that compares today’s merged file against yesterday’s version.
Any new SKU is automatically flagged and exported into a What’s New file.
This gives the marketing or web team a ready-made list of items requiring:
- Product creation
- Photography
- SEO descriptions
- Category assignment
This simple addition alone has removed a huge amount of guesswork and planning friction.
4. Error Checking & Automated Clean-up
My plugin validates:
- Price fields
- Stock levels
- Missing or invalid identifiers
- Out-of-range values
- Empty rows
- Incorrect formatting
Anything suspicious triggers a diagnostic log for quick review.
5. One-Click Clean Export for WP All Import
Instead of staff preparing import files manually, the plugin outputs perfectly structured, ready-to-import datasets:
- taxable.csv (core stock file)
- missing_skus.csv
- whats_new.csv
- Additional logs
All formatted specifically for WP All Import, ensuring flawless imports every time.
The Impact
The transformation was immediate and measurable.
1. Daily Processing Time Reduced by 90%
A task that previously required:
30–60 minutes of manual work
→ now takes seconds.
Staff freed from repetitive tasks can now focus on more valuable work.
2. Stock Accuracy Improved Significantly
With automated validation and clean inputs:
- Incorrect pricing almost eliminated
- Missing items flagged instantly
- Errors reduced to near zero
- Website now consistently reflects true depot stock
3. Faster Online Updates
Stock and price changes can be completed before the business opens — instead of part way through the day.
Customers and staff benefit from more accurate, timely information.
4. Greater Operational Visibility
The new plugin provides insights that were previously invisible:
- What new stock has arrived
- What’s missing online
- What needs adding to the store
- What SKUs have dropped out
- Differences between depots
This improves planning, buying decisions, and prioritisation.
5. Scalable Digital Infrastructure
The new workflow can handle:
- Larger datasets
- More depots
- Multiple daily updates
- Future product expansions
The system is engineered to support long-term growth.
Conclusion
This project demonstrates the power of a well-designed custom solution: clear thinking, smart automation, and a tool built specifically around the way the business operates.
The Stock Processing & Automation Plugin replaces complexity with clarity and turns a daily manual task into a reliable, scalable digital system the business can depend on.
It’s a perfect example of where bespoke WordPress development goes far beyond “just a website” and becomes an operational advantage.