bigyiin

I have wrote a php script which grabs 1000's of products from an xml feed reformats the data to suit prestashop's product information updates the data into a locally hosted database table it then splits the data into a products table and a combinations table and grabs out a products and combinations.csv. I would like to set it up so my local database update's into my prestashop data base resulting in a fully automated product import. I am just learning how to do this as i go along so Could you elaborate and describe the objects you mention? where might they be found? and which ones am i interested in?

Same problem stops at 69-70

It would be nice to see a solution to this issue without having to disable half the prestashop modules which makes prestashop an attractive full featured ecommerce solution.

Fixed it by disabling geo location. it was having the effect of blocking facebook scraper and gtmetrix. hence the 503 unavailable errors.

Thanks for posting this.

same problem plz help us.

Hi Nemo, I managed to fix this. it was basically a resource issue on my machine. so i done some pc maintenance and cleared cache's etc. Also want to say thanks for posting this video. http://blog.arvixe.com/prestashop-migration-local-to-live/ it has really made things a millions times easyer and faster using this method to update my site. 1. Uploading .csv to my shared hosting was impossible due to a fixed max connection timer. 2. Uploading my combinations locally with presta/xampp installed on my HDD took over 24 hours before i stopped it. at 75%. 3. Uploading my combinations locally with presta/xampp installed on 4g Ramdisk is super fast in comparison. 1606 products in an hour including image regen and only 2 hours to upload the 6000 combinations. Using method 3 is just so much faster and your video allowed me to perform my changes locally then just swap out the database and webspace. circumventing that annoying 30sec max connection timer at the same time. One happy camper here 8)

I have this same problem. it occurs only after i uploaded my combinations csv around 5000 total combinations. I have set my php.ini max execution timer to -1 and the page is still not loading. I doubt the connection is slow I have Xampp prestashop installed on a 4gig Ramdisk via localhost. Hmm seems the page just loaded up after about 2 min's.

I have came accross a problem building my shop. I Prestashop installed on localhost and running via Xampp, and have successfully uploaded 1606 products however when i upload my combinations csv everything seems to be fine on the back office. there are no errors returned the csv upload is successful and i am able to visit the product links separately and see that the products now show the appropriate options. but there is a problem somewhere as I am no longer able to browse to the shop homepage. The back office is fine. I turned on error reporting and was returned the below error. Fatal error: Maximum execution time of 30 seconds exceeded in Z:\XAMPP\htdocs\prestashop\classes\db\DbPDO.php on line 91 I have already tried regenerating the htaccess file Can anyone advise me how to fix this problem? Bellow is the php.info pertaining to PDO PDO PDO support enabled PDO drivers mysql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.8.3.1

When you login to prestashop admin. tick the little "keep me logged in box" 8) doh! And when uploading images. Do it via ftp client direct to your server. its way faster. Also. If your host is 1and1. i suggest going to 1and1 login and install prestashop via the 1and1 webapp area. you might benefit from increased compatibility as result.