Retailers & Products
Hi folks,
I am designing a database that will hold many products from a variety of suppliers. The problem is that most of the products are the same i.e. I am entering the same products details in the product table 100 times or more from different suppliers.
The only difference is the price; I import the data from CSV files which can hold anything from 200,000 up to 700,000 records at a time. These CSV files are imported monthly.
If I use a product lookup table to populate the product table, this would be a nightmare, as I would need to manually enter each record.
At the current moment I just add the suppliers ID to each record within the spreadsheet then import directly to the product table, task accomplished within 5mins, just one big ugly product table busting at the seams.
Open to suggestion
Hi folks,
I am designing a database that will hold many products from a variety of suppliers. The problem is that most of the products are the same i.e. I am entering the same products details in the product table 100 times or more from different suppliers.
The only difference is the price; I import the data from CSV files which can hold anything from 200,000 up to 700,000 records at a time. These CSV files are imported monthly.
If I use a product lookup table to populate the product table, this would be a nightmare, as I would need to manually enter each record.
At the current moment I just add the suppliers ID to each record within the spreadsheet then import directly to the product table, task accomplished within 5mins, just one big ugly product table busting at the seams.
Open to suggestion
Last edited:
