Trying to do something I don't know can be done

[Guest]

Hello,

 

I have been working with OS for quite some time now and I've got to grips with the bits an pieces and now I am taking on a much much bigger commerce solution for an entire road in the west midlands.

 

heres my question

 

for instance I have 40 stores, you can view each one of them separately, their products are held in different databases, NOW, i want a search on the front end of the umbrella company allowing you to search all of the stores simultaneously and when the result is clicked go to that store, is there anything out there that does that or similar or would I have to learn how and do it myself?? please don;t let it be the last one.

 

many thanks

-Dave Robilliard

Tired and stressed

[♥FWR Media]

My initial thought is ..

 

the search includes a file via $_GET that has like ..

 

$refArray = array(
							   //requests for searches (ref=)
								 'site1' => array('thissite.com'),
								 'site2' => array('thissite2.com'),
								 'site3' => array('thissite3.com'),
																		 );

if (isset($_GET['ref']) && isset($refArray[$_GET['ref']])) {
Do this search
}

 

Just a quick thought, but may give some ideas.

[spax]

I am a little out of my depth with this one but, even if you managed to code for recursively connecting to, selecting, searching through and displaying the results of 40 databases, by the time your user had the results, it would have been quicker to nip down the high street and take a look.

 

I haven't used this but have you seen the Multi-Stores multiple shop system contribution? It maybe an easier solution, unless one of the Gurus on here know how it can be done. Which of course they will do. >_<

[♥bruyndoncx]

I would run individual cron jobs to populate a products table in your umbrella db that is optimized for searches.

First thing to do is figure out what you want to be searched upon or what kind of filtering you want to offer.

 

If you click on the results you are then taken to the individual store.

[Guest]

Was just thinking (scary).

 

Perhaps have a look at oscmall. It allows you to create multiple stores within the one arena, and uses just 1 database. Might make it easier to apply the solutions listed above.

http://www.oscdevshed.com/oscmall_download.php

[Guest]

Cheers for the support, I didn't mention that just to be more specific, the websites name is http://www.smith-street.co.uk

 

after that each shop has a sub domain under that, the shops and admins are located in the admin page and the databases are all on the same DB server and I am wondering if there is anyway to link them all so one master DB sees them all, but I will look into those solutions.

 

the other question I had, does anyone know of a quick way to make OS commerce individual without me having to do too much leg work uploading files, so I almost go into a look and feel manager and I can quick upload the logo, change the basic colour and I'm done?

 

is there a way maybe to populate some sort of Java applet with the results giving visual feedback loading the info, a bit like the macromedia exchange site where it loads all of the downloads one at a time and sorts them, I'm just throwing ideas about.

[Guest]

Just a quick note, OSCMALL looks perfect for what I want to do. it rules, Cheers for that.

[Guest]

:thumbsup:

[Guest]

 

 

 

[Guest]

however, a small problem has arisen, whilst testing OSCMALL I can;t get passed the install. I get to it and then when I try and get into the admin it sais

 

 

Warning: main(includes/functions/mall_setup.php) [function.main]: failed to open stream: No such file or directory in /home/sites/smith-street.co.uk/public_html/_STORES/mall_admin/includes/application_top.php on line 96

 

Warning: main(includes/functions/mall_setup.php) [function.main]: failed to open stream: No such file or directory in /home/sites/smith-street.co.uk/public_html/_STORES/mall_admin/includes/application_top.php on line 96

 

Warning: main(includes/functions/mall_setup.php) [function.main]: failed to open stream: No such file or directory in /home/sites/smith-street.co.uk/public_html/_STORES/mall_admin/includes/application_top.php on line 96

 

Fatal error: main() [function.require]: Failed opening required 'includes/functions/mall_setup.php' (include_path='.:/usr/share/pear') in /home/sites/smith-street.co.uk/public_html/_STORES/mall_admin/includes/application_top.php on line 96

[Guest]

this is a problem cus the OSCMALL site seams to have a problem and I can;t join the forum and ask there.

[Rachael w.]

I tried oscmall at one point, didnt seem to work as well as I had hoped, lots of errors, little support.