Hi there i have about 3000 products and about 250 product attributes across about 14 MYSQL databases and i have about 400 customer records with usernames/passwords & address details and order history.
I want all of these merged into one database please!
The estimated size of the MERGED DATABASE will be about 15MB
is this accpetable or too large for servers and web browsers to handle?
OR ALTERNATIVELY IS THERE ANY WAY THAT I CAN HAVE ONE DATABASE WHICH WILL STORE ALL MY CUSTOMERS USERNAMES AND PASSWORDS ETC SO THEY CAN LOG IN TO ANY OF THE STORES
AT THE MOMENT THEY HAVE TO REGISTER IN EACH INDIVIDUAL STORE WHICH IS A PAIN IN THE BUTT FOR THEM AND FOR ME!!
I DONT MIND HAVING SEPARATE DATABASES FOR EACH STORES PRODUCTS BUT ONE DATABASE FOR ALL CUSTOMER RECORDS WOULD BE NICE
IF THIS ISNT POSSIBLE THEN COMBINE ALL DATABASES INTO ONE
EACH STORE NAME WILL BE A PARENT CATEGORY AND ALSO EACH PRODUCT WILL HAVE TO BE LABELLED WITH THAT MANUFACTURER (STORE NAME)
SOME STORES WILL HAVE SIMIALR PRODCUT NAMES BUT USUALLY DIFFERENT PRICES
THIS MUST BE DONE TO A HIGH STANDARD
ALL PRODUCTS AND PRODUCT ATTRIBUTES MUST BE LINKED PROPERLY TO THE RELEVANT STORE
IF THIS IS TOO COMPLEX TELL ME AND MAYBE BETTER SOLUTION TO GO FOR PUTTING ALL CUSTOMERS IN ONE DATABASE