|
Tuesday 20 September 2005 7:20:11 am
Hi there, I was hoping someone might have an idea on approaching a request we've had from a client. They are an electronics distributor. Consequently, while their product series is not that large (say 500), within a series they could have a 1000 variants. I think their stock list is about 5000ish items at present... From their inhouse system, they can export a CSV file of stock name, number, and amount in stock. No price at the moment, so they aren't after ecommerce here. What they want to do is to allow clients to search for stock on their website and get information back on amount in stock etc. The most obvious solution would be to create an import script that grabs each line of the CSV file and imports it into a small stock class we could create, but:
- this would mean 1000's of data attributes in the backend, and
- from a previous project in which PaulF created an import script for jewellery stock items (about 300 items) we found PHP execute times wouldn't allow us to import the stock all in one go. So, I wondered if anyone has a suggestion for importing a large about of CSV data into Ez in such a way that it can be searched on, is easy to upload by the client, and stays away from creating too much dbase overhead? Any input would be greatly appreciated. Regards, Steve.
http://www.oneworldmarket.co.uk
|