eCommerce Project

[eluser]ray73864[/eluser]
i don't require the validation of the csv import (the information is coming from an Access Database that the client built for his store, and since i know him very well and work with him with his other business (i have a proper job too), he and I can work together on making sure the CSV file is already validated), however each week i would be importing a good 5000 records and i have to do several things, i have to check to see if the item exists in the DB and if it does update it otherwise add it, with the CSV importer that i was using, it choked at 7000 of 24000 records to import and even when i managed to stick a usleep() in there it was still going to take an hour or so to import all the records.

as for the shipping, calculating shipping in Australia is not easy, Australia Post (which is what the majority of parcels get delivered through) has a whole stack of rules, such as weight and then delivery location based on postcode where you then have to work out the difference, plus the only service they have for automatically calculating shipping has a whole lot of rules that go with it in order to use it.

same with a lot of the other courier type services, we Australian's haven't jumped onto the SOAP or webservices bandwagon as much as the USA so it is quite difficult to find a courier (that deals with the area the business is in) which also offers the ability to calculate all that stuff via web services.