by FredW » Wed Jun 05, 2013 12:49 pm
Jim,
The content our custom program was going to generating is a table of old part numbers the part we are selling replaces. See sample here:http://keithdemo.keithspecialty.com/k/fw-st9120u1011.htm - this sample has an html table with the content in it statically created in more information product information field. But we want to dynamically create it at generation time using a custom program.
Since these old part numbers are used in more than one page in our website, we wanted to maintain it in an SQL database and use it to be the source for the html code used for the pages that need it. Here is another page where the same content shows up: http://keithdemo.keithspecialty.com/hvac.xref.oem.Honeywell.htm. This page is one over 147 pages in our classic site containing the cross reference content. We also have over 5500 product pages that contain content like this. To manually copy and past that data into a product shopsite field is not feasible. I can build a excel file to import the data to a product field, but there are two problems with that: One is that the import content would have to have html wraped around it for ease of display and two we can't maintain it easy in one place.
We can get the conent into a SQL database easily which is the best place to maintain it. Invoking a program to read it from the SQL database and generate html code sounded like a great idea (actually Lauren suggested this), but my testing shows that content is not indexed by shopsite.
I'm open to alternative ideas.
Fred