I'm short on time and a current client has given me more work than I can find time to do. Here are the details:
Running Drupal 6:
Client wants to use data from an Excel file received from a separate e-commerce site to be included in search results on their non-e-commerce site. The file contains item details such as (among others):
a. Item Title
c. a link to the item on the e-commerce site
d. an image URL
When a user searches the non-e-com site, they could see these as search results. Clicking on one of the results would bring them to a View page (on the non-e-com page) that would display that item's details (using the image URL to display a picture of the item). There would also be a "Buy It" link/button that would reference the link to the item on the e-com site. Clicking the link would open a child window for that item on the e-com page.
I imagine the following:
1. create a custom table to store the import data
2. use Data or Table Wizard module to allow for connecting Views to this custom data
Other suggestions on how you might achieve this are welcome.