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
Active Member
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
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
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.
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
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
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
Who is online
Users browsing this forum: Amazon [Bot] and 424 guests