Protuct Type music/general

[readysketty]

Hi, I am using: v1.3.9h
I am completely stressed out.
We bought this store with zen cart from someone as part of a business deal. He showed us how to add new products and so on, as we had never used zen cart before. I have become more comfortable with zencart since that. I have realized that when he showed us how to add a new product, he did not have me select "product - music" but instead had me keep it "product - general" I have added about 80 products & realized, I need them entered in as music, so I can have the "music genre" option.
Is there any way to switch them all over to "products - music" or will I have to re-enter each one as a new product?

Thank You

[misty]

See previous thread at
http://www.zen-cart.com/forum/showthread.php?t=141906

[readysketty]

Thank you!
That thread sent me to this thread: http://www.zen-cart.com/forum/showthread.php?t=140489
I am still confussed by the responses. It seems like at first it is saying how to do it, then it seem it say that it is not safe to do for music.
I'm sorry, I am confussed what the right thing to do is........

[Ajeh]

Changing to a Music Product type is very difficult as Product - Music uses additional tables compared to the other Product Types ...

Just changing the products_type to the value for the Product - Music is not the only thing to update ...

The table product_music_extra needs to be populated with 1 record per products_id ...

[Ajeh]

If I wrote this right, this may work for you ...

Turn ALL products to products music

BACKUP DATABASE FIRST ...

UPDATE products SET products_type = 2;
insert into product_music_extra (products_id) 
select products_id 
from products where products_type = 2 and products_id not in (
select products_id
 from product_music_extra);

NOTE: if you are NOT trying to update ALL Products to be Product Music ... do not do this ...

[readysketty]

Ok, I tried that, All of my products are still in the store, and on my product list in the zen cart. However, whenever I click to edit a CD, it opens a new page, like when you enter a new product. There is no way to edit any of the old products.

Any suggestions?