Export to CSV, import to Google Shopping

Attached is the error report from Google. I exported the .csv file from Hika Shop, and uploaded it to Google.

Pwease help

You can't export the CSV via the products listing and import it in Google shopping.
Google does not recognize that format.

For google shopping, you need to go in the options of the google products plugin via the joomla plugin manager and click on the download link there. It's explained in the documentation:
www.hikashop.com/en/support/documentatio...google-products.html

So, I setup a Cron thingy, and created it, and saved it. But I got this error.

Going on www.therollerskate.com/index.php?option=com_hikashop&ctrl=cron
I can see that your cron was triggered.
So it seems to be working.
You can check that in more details by following the documentation there:
www.hikashop.com/en/support/documentatio...cron-task.html#check

So... I got the cron and the Google Plugin working (I think).

Now all I wanna do is get it correctly integrated with Google.

It seems that Google Merchant is requiring a URL for the xml file. Where would I find that for mine?

Google Merchant does not require a URL for the xml file. The xml file is uploaded automatically by your server to google's via FTP. So I'm not sure of what you're talking about.

Ah... I was looking at "Data Feeds", which I assumed is what I needed. But apparently not, that may be just for bulk uploads.

I did find the FTP area in Google Merchant under Settings. I'm guessing this is where my FTP will have to be set. Will I need to create a new FTP account direct that to any specific folder? If so, which one?

You indeed need to create a FTP account in Google Merchant. Then, you can enter the credentials of that account in the options of the plugin so that it can connect to the FTP server of Google to upload the xml file automatically.

I'm not sure why you're talking about folders. I don't remember about a folder setting for that.

Ah...Ok. I was confusing things and making this a lot more complicated. I was under the impression that I was creating an FTP account at my web host (1and1) and then using that. But no, the ftp account is created with Google and then those entered into the Hikashop google plugin. I get it now! yay.

Are you sure that you cron is working ?
Did you set the cron system to send you an email each time it is triggered and did you receive the emails ?
Could you do a screenshot of the plugin's options (you can grey out the password/username)

I think I got everything setup correctly now, but I still don't see any products in Google Merchant. I feel like I may have missed something.

No, I am not receiving the cron emails, even though it is saying that it is working by giving a last run time. Attached is the plugin screen shot.

What if you update your google products on your merchant account using the xml that you can download via the trigger link on that screen ? Does it displays any errors ?
Do you have any errors or messages regarding that photos.xml file on your google merchant account ?

So, i DID have an error when I did the cron thing, which I did provide a screen shot. But, when I tried uploading it manually, it didn't give me any errors.

And upon further inspection, it says this in Google "0 of 25 items inserted (View errors)"

And here are the "Item Warnings"

"Missing recommended attribute: brand (25 warnings)"

"Missing recommended attribute: mpn (25 warnings)"

"Missing recommended attribute: google product category (25 warnings)"

The mpn attribute is only added when the "add product code" option is turned on in the plugin so you should do that.
the brand attribute is only added when you have something in the "brand" input field of the plugin's options. I see that you had it filled in your screenshot. Did you empty it since then ?

The "google product category" option is not implemented at all in the plugin. That's because like for the other two parameters they are optional. It's strange that you get these errors.
For that last warning, the only way to remove it will be to add a line like this:
$xml.="\t".'<g:google_product_category>CATEGORY</g:google_product_category>'."\n";
where CATEGORY is the name of your category based on the explanations there (you need to choose between the list of possible categories on that page):
www.google.com/support/merchants/bin/ans...?answer=160081&hl=en

You can place that line of code just before the line:
$xml.="\t".'<g:shipping_weight>'.$product->product_weight.' '.$product->product_weight_unit.'</g:shipping_weight>'."\n";
in the file plugins/hikashop/google_product.php

Then, try to download again the xml and import it in google again. These error messages should not display anymore.

And where do I edit the file "google_product.php", or is this an FTP process?

Yes, you need to use FTP for that.

Ok, now that I added that code, I get this error:


Parse error: syntax error, unexpected T_VARIABLE, expecting T_FUNCTION in /homepages/13/d369589260/htdocs/website3/plugins/hikashop/google_products/google_products.php on line 318

Perhaps I messed the code up, attached is the .php file I updated.

er, no it's not. apparenlty it wouldn't let me attach a .php file