Great post Pixxi! Very clear description of the troubleshooting/deduction process. Your explanation should become a sticky. :thumbsup:Quote:
Originally Posted by Pixxi
Woody
Printable View
Great post Pixxi! Very clear description of the troubleshooting/deduction process. Your explanation should become a sticky. :thumbsup:Quote:
Originally Posted by Pixxi
Woody
I reset admin>store manager>Reset ALL Products Master Categories ID
I managed to process a feed that is 13.02 MB but now I get this error in the feed window:
I already have the following set in admin> config > my storeQuote:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/public_html/googlefroogle.php on line 249
Quote:
Admin Session Time Out in Seconds 7200
Admin Set max_execution_time for processes 3600
That was also something I suggested via PM that you try. - and it looks like it might have worked ... :smile:
Ok. If you haven't changed your passwords yet, I'll go back in and add a line of code to your googlefroogle.php file to see if we can get over that.
Let me know - it's 2am here so I'm not up much longer ... :smile:
Ok - maybe continue tomorrow.... :sleep1:
I already deleted all my temp username and passwords, but I will create new ones identical to the old ones.
I've just taken another look in your admin, and I'm not getting a timeout when I try to generate a feed - instead the pop-up window is collapsing after about 58 seconds with no errors showing - even with error reporting turned on.
When the feed file generates, I'm getting 7357 records (approx. 11Mb).
Have you made any changes to your database or shop since you got that timeout message yesterday?
Have you used easy populate since then?
Can you backup your database and then run the admin>store manager>Reset ALL Products Master Categories ID again, and then (on the same page) the 'update all products price sorter'. I'll take another look when I get back in a couple of hours.
I've been following the latest conversation and have manage d to weed out a fix for my problem, which was the *.txt file only showing the first 12 records.
First I tried to merely reset the "Reset ALL Products Master Categories ID" but that didn't work.
Then i played a bit more and:
1) I uninstalled and reinstalled the sql from 1.33
2) I reuploaded the entire 1.33 package (downgrade from 1.33a, which shouldn't have been different--I"ve only done this 100 times in the last month!)
3) Under ADMIN>Tool>Store Manager, I reset ALL Products master category id (nothing changed, still only 12 products) so I updated the All Products' Attribute Sort Orders and then Updated ALL Products Price Sorter and then reset ALL Products master category id again (all under store manager).
4) manually ran googlefroogle feed from within the admin panel and uploaded to google. No timeouts and all products were shown. Google accepted the feed with no errors, making all products active.
My Cron job ran at the 2 a.m. and was also successful in uploading.
I've created the feed no less than 100 times last night and this morning and it has contained all products ever time!
Now on to integrating google checkout!
Just wondering if anyone else has this issue. I have an email from Google, saying my product_type left as other has meant my feed has been disapproved until i put it to something more appropriate.
At present, everything can simply be changed, to glassware, but as the shop grows the number of categories will expand. I have found this problematic in the past, mapping large databases to affiliate feeds.
Here is a snip from the email:
Quote:
Irrelevant product type: We noticed that some of the product_type values
you included are not relevant to your items. For example, for your item
titled "Crystal White Wine Glass," you included "other" as the
product_type. A more relevant product_type value for that item would be
"glassware."
Including irrelevant information may cause your products to be
miscategorised and adversely affect your items' placement. For a list of
examples product_type values, please visit
http://base.google.co.uk/base/help/product_types.html
Well, I don't know what I did right this time but it worked!!!
Sent it on to froogle, now I'm competing with my ebay froogle postings. haha. Gotta get those outta there.
Now when I get the feed to generate, it collapses on me. It stops at about 1 mb. Any suggestions?