Post by porter943 » Tue Jan 19, 2016 3:36 am

Can anyone help me on how to create a google base product txt file to upload to google merchant center.
I have been trying to do this for the past week, not thing seems to work..

Thank You
All

New member

Posts

Joined
Fri Dec 11, 2015 11:35 pm

Post by EvolveWebHosting » Tue Jan 19, 2016 4:55 am

There is a feed built into the software to do this. Which version of OC are you using?

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhost.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by kagi » Thu Jan 21, 2016 2:53 am

I am having the same issue and as I looked at the error logs, this came up. I checked and the google_base_category_to_category table does not exist. This was a fresh install so how can I solve this?

2016-01-17 2:00:38 - PHP Notice: Error: Table 'table.ag_google_base_category_to_category' doesn't exist<br />Error No: 1146<br />SELECT google_base_category_id, (SELECT name FROM `ag_google_base_category` gbc WHERE gbc.google_base_category_id = gbc2c.google_base_category_id) AS google_base_category, category_id, (SELECT name FROM `ag_category_description` cd WHERE cd.category_id = gbc2c.category_id AND cd.language_id = '1') AS category FROM `ag_google_base_category_to_category` gbc2c ORDER BY google_base_category ASC in C:\Program Files (x86)\Ampps\www\system\storage\modification\system\library\db\mysqli.php on line 41
2016-01-17 2:00:38 - PHP Notice: Trying to get property of non-object in C:\Program Files (x86)\Ampps\www\catalog\model\feed\google_base.php on line 6
2016-01-17 2:00:38 - PHP Warning: Invalid argument supplied for foreach() in C:\Program Files (x86)\Ampps\www\catalog\controller\feed\google_base.php on line 22
2016-01-17 2:00:39 - PHP Notice: Error: Table 'table.ag_google_base_category_to_category' doesn't exist<br />Error No: 1146<br />SELECT google_base_category_id, (SELECT name FROM `ag_google_base_category` gbc WHERE gbc.google_base_category_id = gbc2c.google_base_category_id) AS google_base_category, category_id, (SELECT name FROM `ag_category_description` cd WHERE cd.category_id = gbc2c.category_id AND cd.language_id = '1') AS category FROM `ag_google_base_category_to_category` gbc2c ORDER BY google_base_category ASC in C:\Program Files (x86)\Ampps\www\system\storage\modification\system\library\db\mysqli.php on line 41
2016-01-17 2:00:39 - PHP Notice: Trying to get property of non-object in C:\Program Files (x86)\Ampps\www\catalog\model\feed\google_base.php on line 6
2016-01-17 2:00:39 - PHP Warning: Invalid argument supplied for foreach() in C:\Program Files (x86)\Ampps\www\catalog\controller\feed\google_base.php on line 22
2016-01-17 2:00:42 - PHP Notice: Error: Table 'table.ag_google_base_category_to_category' doesn't exist<br />Error No: 1146<br />SELECT google_base_category_id, (SELECT name FROM `ag_google_base_category` gbc WHERE gbc.google_base_category_id = gbc2c.google_base_category_id) AS google_base_category, category_id, (SELECT name FROM `ag_category_description` cd WHERE cd.category_id = gbc2c.category_id AND cd.language_id = '1') AS category FROM `ag_google_base_category_to_category` gbc2c ORDER BY google_base_category ASC in C:\Program Files (x86)\Ampps\www\system\storage\modification\system\library\db\mysqli.php on line 41
2016-01-17 2:00:42 - PHP Notice: Trying to get property of non-object in C:\Program Files (x86)\Ampps\www\catalog\model\feed\google_base.php on line 6
2016-01-17 2:00:42 - PHP Warning: Invalid argument supplied for foreach() in C:\Program Files (x86)\Ampps\www\catalog\controller\feed\google_base.php on line 22

New member

Posts

Joined
Wed Jun 13, 2012 11:19 pm

Post by kagi » Thu Jan 21, 2016 3:45 am

There is no such table even in the original Opencart 2.1.0.1. I just downloaded it again and did a search.

Am I missing something?

New member

Posts

Joined
Wed Jun 13, 2012 11:19 pm

Post by JNeuhoff » Fri Jan 22, 2016 6:01 am

These missing DB tables should have been created when you installed your Google Base feed.

I suggest you re-install your Google Base from your Opencart admin backend at

Extensions > Feeds > Google Base

and then try again with the upload of the latest Google category list, as per my previous email.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Qphoria » Fri Jan 22, 2016 6:10 am

JN Is correct. This happens when you upgrade from 1.5.x which already had Google base feed installed. In 2.x, there are new features that are added at install time, but since it was already installed, it skips that part. Simply uninstall/reinstall and you'll be set.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by kagi » Sat Jan 23, 2016 12:17 am

Perfect. Just uninstalled and reinstalled it again and it works now.

New member

Posts

Joined
Wed Jun 13, 2012 11:19 pm

Post by porter943 » Sat Feb 06, 2016 2:43 am

I have uninstalled and reinstalled it again and again, but still not working.
from Google:
No items processed
Uploaded at: February 5, 2016 at 3:00:00 AM CST
No items processed February 5, 2016 at 3:09:49 AM CST

No products are being submitted to Google.

Anyone Help on this?

Thank You

New member

Posts

Joined
Fri Dec 11, 2015 11:35 pm

Post by porter943 » Tue Feb 09, 2016 1:09 am

Google Base now working all products are being submitted.

New member

Posts

Joined
Fri Dec 11, 2015 11:35 pm

Post by hfxracing » Wed Mar 09, 2016 8:30 am

what did you do to make it work?

Newbie

Posts

Joined
Thu Mar 26, 2015 9:24 pm
Who is online

Users browsing this forum: Amazon [Bot] and 424 guests