Page 1 of 1

Preprocessor for products file

Posted: Sun Jun 03, 2007 9:28 pm
by BigAlnz
Hi Guys,

Hope someone here could help point me in the right direction for this little project.

I want to get a online computer store up and running.

I get files once weekly from about 12 different distributors. I might get ASUS video cards from one distributor and Albatron video cards from another. The problem I have when importing these files to oscommerce with easy populate is that one distributor might call video cards "VGA Cards" and another might call them "Graphics Card".

When I import the list of video cards I end up with two catagories, when in reality there should of course only be one. This happens on a variety of things, not just video cards.

I need to do some preprocessing to get the files having uniform groups before they are imported.

I think I can do this with php and some arrays, but its been a while since i have done php and a outline of the structure or even a few lines of code would be a great help.

All the files that I get from the distributors are in csv format.

Thanks heaps in advance,

-Al