GwilliamP

 DunWeb, on 04 April 2012, 12:19, said:

So, you can 'advertise' here but you can not ask people who advertise to contact you. Do you realise how stupid that sounds?

FTP upload (V3) problem - probably a Google issue.

Up to now I have been manually down/up loading my products file. I had not previously set up an FTP account. When I saw that V3 was announced I decided to bite the bullet and upgrade and also use FTP to simplify the process. Unfortunately the FTP side of things does not seem to be working. Here is what I have done so far.

• Upgrade to V3 (using DiffMerge to identify and migrate the settings to the new googlefeeder.php)
  
• Run a manual check to verify it is working "Create and do not upload a GoogleBase datafeed"
  
• Create an FTP account with Google (http://www.google.co.uk/merchants/ftpsettings)
  
• Wait 24 hours even though it stated only 15 minutes for account to become live
  
• Run Create and Upload a GoogleBase datafeed - no sign of errors, usual results page displayed
  
• Wait 24 hours even though a manual upload is processed within an hour or so
  
• Check the Google Merchant Centre Dashboard to see the current products status - STILL showing expiring products!
  
• Open a browser page for ftp://uploads.google.com/ - no file
  
• Access ftp://uploads.google.com/ with FileZilla to verify above - no file
  
• Manually FTP (FileZilla) upload the file. Transfer without errors but no file appeared at Google's end?

No matter what I do I can not see a file at ftp://uploads.google.com/. No errors, just no file!

One odd thing I did notice was a 'sort of' error from the FileZilla upload log

Status: File transfer successful, transferred 1,829,630 bytes in 39 seconds
Status: Retrieving directory listing...
Command: TYPE I
Response: 200 Type set to I.
Command: PASV
Response: 227 Entering Passive Mode (72,14,245,21,4,82)
Command: LIST
Response: 150 Opening BINARY mode data connection for directory listing.
Status: Invalid character sequence received, disabling UTF-8. Select UTF-8 option in site manager to force UTF-8.
Response: 226 Transfer complete.
Status: Directory listing successful

I am unsure about the UTF-8 message though the final result is a transfer and listing success. Where is the file?

Does anyone have any suggestions for the next step in debugging or fixing this?

standard12, on 13 March 2012, 11:59, said:

The UPI is a UNIQUE (global) code for your product. Bar Code number etc. Google Info Page. If your products have one then it needs to be included. My products never will so I contacted Google and got an exception which allowed the products to be listed and searchable. Exception Request Page. This is not best practice but got my products back in the listings.

Jack_mcs, on 11 January 2012, 15:10, said:

Thank you. File deleted and new reference file(s) created.

"WARNING: Database tables have changed."

After uploading new images and products to the store I decided to run "Delete Reference File" so that daily monitoring emails from a CRON job would only report valid changes. On opening the Site Monitor Admin page there was a Red line across the top of the page stating the above.

I downloaded a database backup and, using DiffMerge, compared it with the latest weekly backup I had stored locally. DiffMerge shows a huge number of differences but, as far as I can see, they all relate to normal activity such as new customer details, shopping cart content, orders, new products and associated entries in categories etc.

None of the Site Monitor text files on the server appear to contain any information to help me discover where the offending change might be. Am I missing something?

I could edit the backup files to remove all field data leaving the Drop Table/Create Table info to see if the structure has been tampered with but that is a big job I would prefer to avoid if possible as I am up to my neck in day to day stuff as it is.

Is there a way of determining what Site Monitor perceives as the change?

[Edit]
I just checked the Site Monitor configuration and logging is enabled but looking at the log the only occurrences of the term 'database' relate to PHP files.
[/Edit]

Does anyone have any suggestions on how to deal with this situation.