Peruttu

merge mySQL database entries

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

STRUCTURE

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

-------------------------------------------------------------------------------------------------------------

OK at the moment if i register and login to 1 store and then go to another store i have to register again for first time

i want to just register once on 1 store and then my information gets COPIED to all the other stores there and then so if i come back later i can login to any of the stores using same login detials

all stores use exactly same platform and SQL structure

Taidot: tiedonsyöttö, PHP, Ostoskärryt

Näytä lisää: merge mysql, merge mysql databases, merge mysql database, mysql database merge, merge product mysql database, structure stores, mysql customer database, manufacturer register, manufacturer prices, manufacturer order, linked in log in, data structure solution, data entry pain, mysql data structure merge, merge database mysql, check database entries mysql, php mysql merging database records database, merge mysql database mysql, merge complete mysql databases, merge mysql data, mysql merging structures, database maitainence, parent, my entries, manufacturer a product for me

Tietoa työnantajasta:
( 2 arvostelua ) Glasgow, United Kingdom

Projektin tunnus: #436157