Fixing Messy CSV Product Feeds Automatically Using PHP

A supplier tells you they have a CSV feed ready for import. You open it, and it is a nightmare. HTML tags are bleeding into the product titles, sizes and colors are crammed into a single column, and the pricing includes currency symbols that break your database.

Most store owners waste hours opening these feeds in Excel every morning, running manual “Find and Replace” commands before uploading them. This manual data cleansing is tedious, error-prone, and completely unnecessary.

---

1. The Danger of Excel Formatting

Opening large supplier feeds in Microsoft Excel or Google Sheets actually destroys data. Excel notoriously strips leading zeros from SKUs (turning SKU 00459 into 459) and automatically converts specific product dimensions or model numbers into calendar dates.If you upload that corrupted file to WooCommerce, you will break product matching and orphan your inventory.

2. Programmatic Data Cleansing with PHP

Instead of touching the CSV manually, you can write a PHP parser using the native fgetcsv() function to read the raw, uncorrupted text data directly from the supplier’s URL.As the PHP script reads the file row by row, you can apply instantaneous data mutations:

• Cleaning Strings: Use strip_tags() to remove rogue HTML from titles, and preg_replace() to strip out unwanted trademark symbols or supplier branding.
• Fixing Pricing: Convert a string like “€45.99 MSRP” into a clean integer (45.99) and automatically multiply it by your 1.5x retail markup margin before it hits the database.
• Splitting Variations: If a column reads "T-Shirt | Large | Blue", PHP can use the explode() function to split that single string into properly mapped Size and Color attributes for WooCommerce variable products.

3. The Zero-Touch Pipeline

By shifting the data cleansing from a manual Excel task to a programmatic PHP script, the entire import process becomes headless. Your server downloads the messy CSV at 2:00 AM, the PHP script cleans and mutates the data in memory, and WooCommerce updates perfectly. You never have to look at a spreadsheet again.