Easypopulate Data Checker

This is a simple command line PHP script that will scan through an easypopulate csv datafile and check for common errors. Most of the types of errors it looks for are the kind of typical cut and paste problems created when using a spreadsheet (duplicate product numbers, blank product numbers, duplicate product names, 'EOREOR' present, etc etc).

If you want, it will also print a category tree for all the products. This is to provide a visual guide to make sure you've not made a spelling mistake and inadvertently put a product on its own in some bogus category somewhere. The tree isn't as tidy as it could be, but it's good enough.

To use it :-

1) unzip it

2) You may want to change the shebang at the top of the file to point to your PHP executable

3) There are also a few constants and control parameters defined at the top of the file that you may want to alter to match your system. The various checks can be switched on and off as required.

If you just run the script with no parameters it will print some help info

The idea is that you run the script after you have edited your easypopulate data in your spreadsheet, but before you upload it to your site; a sanity check before you try and add your data back into the database