Forum Moderators: coopster
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
make sure your CSV has same schema as your table to which you are going to import. if it is the same then nothing will be messed up. However if it is not the same then you need to process your CSV to match with the csv schema
For CSV Processing Checkout These Classes [google.com]
