Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

displaying two product names rather than one?


Guest

Recommended Posts

Posted

Hi all, got a question that I really hope somebody can answer ...

 

I'm trying to set up OSC for an online music store. The database uses separate product name fields for Artist and Record. So, a given record has the following fields:

 

v_products_model

v_products_name_1

v_products_name_2

v_products_price

v_products_description

v_manufacturers_name

v_category

 

I had hoped to be able to use products_name_1 for band name, _2 for album title. But it appears that name_1 is tied to description_1, name_2 to description_2. Is there anyway to trick osc into displaying the fields listed above?

 

We're working from a database of about 1200 products, and I really don't want to have to go back and concatenate the artist and album title into one field. Also, I'd _really_ like to have artist name be clickable, and return a search of matching products.

 

Is this easy enough to do, or do I need to reengineer my tables to use only one product name field?

 

Best,

James

Posted

Can't you use the Manufacturer's name to hold the Artist information ?

I think this makes more sense, and you immediately get the functionality to see other products from the same manufacturer :)

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Posted
Can't you use the Manufacturer's name to hold the Artist information ?

I think this makes more sense, and you immediately get the functionality to see other products from the same manufacturer :)

I'm using the manufacturer field for the record label ... although I suppose I could discard record label info and put artist there. I'd rather not, though ...

 

I'm guessing that it's a matter of adding the name_2 tag in the proper files, but I'm just now beginning to learn the osc architecture ... any help sure would be appreciated.

 

Best,

James

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...