We are currently using the products_url field to point to an audio sample file in our music store.

I would like to continue to use the products_url for these samples with a single product type. However, to simplify the input for my client, I'm hoping that I can code the url to point to the local /media directory so that they only have to type in the filename rather than the full url.

Can someone point me in the right direction or let me know if, for some reason, this is a bad idea.

Before anyone suggests that we just use the media manager, let me explain why we don't. The client sells music singles (accompaniment tracks) so each product only has one sample. Creating a media collection for each of the 6000 tracks is just way too inefficient.

Anyway, any guidance would be greatly appreciated.

Thanks.