Firstly what a great forum and site alot of the threads on here have helped me over the past couple of months create and update alot of sites.
So here is my problem,
I have a importer which imports a feed (csv file) from a supplier (no problem importing it) but the feed layout is different to wat i usually get from other suppliers. Here is the layout once imported:
Supplier table model | partno | products_name | buy_price | rrp | vendor | product_type | category
Now my problem is that the categories are set in the models column a line above the groupings of the products in that group. Eg.
HEWLETT-PACKARD - Pavilion Series
*list of pavilion series computers*
HEWLETT-PACKARD - HP Series - xw4600
*list of hp series - xw4600 computers*
What i would like to do is take the category out from above the groups and place into the category column.
If anyone has an idea on how i would go about doing this please let me know i dont expect code (but would help) but what functions to use to go about doing this?