Google Product Search - One item

In 2.8 you have to select "Default Google category"
- Save settings
- Generate feed

It is the same apparently in version 2.7 and it is what I did but it is still not working !

I have this message
"An error occurred while executing the command definition. See the inner exception for details."

I don't know what to do....

In Log are there any details?

Here is what I found :

Error while running the 'Froogle static file generation' schedule task. An error occurred while executing the command definition. See the inner exception for details.
Full message:   System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.GoogleProduct'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence) at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot) at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source) at Nop.Plugin.Feed.Froogle.Services.GoogleService.GetByProductVariantId(Int32 productVariantId) at Nop.Plugin.Feed.Froogle.FroogleService.GenerateFeed(Stream stream) at Nop.Plugin.Feed.Froogle.FroogleService.GenerateStaticFile() at Nop.Plugin.Feed.Froogle.StaticFileGenerationTask.Execute() at Nop.Services.Tasks.Task.Execute()

Seems you don't have GoogleProduct table in your db.

Check your database

This is mine:
------------------------------------------------------
CREATE TABLE [dbo].[GoogleProduct](
  [Id] [int] IDENTITY(1,1) NOT NULL,
  [ProductVariantId] [int] NOT NULL,
  [Taxonomy] [nvarchar](max) NULL,
  [Gender] [nvarchar](max) NULL,
  [AgeGroup] [nvarchar](max) NULL,
  [Color] [nvarchar](max) NULL,
  [Size] [nvarchar](max) NULL,
  [Material] [nvarchar](max) NULL,
  [Pattern] [nvarchar](max) NULL,
  [ItemGroupId] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED
(
  [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
------------------------------------------------------

thanks so much !

Hi ,

I run NOP 2.65
and i have installed PromotionFeed.Froogle 1.25

I click on the Save button and then generate Feed but i get only one product . Please find feed below

<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
<channel>
<title>FUTWIA Google Base</title>
<link>http://base.google.com/base/</link>
<description>Information about products</description>
<item>
<g:id>46</g:id>
<title>
<![CDATA[ Spence Slip On (UK 6 / 39) ]]>
</title>
<description>
<![CDATA[ SKU: 90001 ]]>
</description>
</item>
</channel>
</rss>

Please help!

Regards

Hi,

I also just checked out the froogle file in content->files-> importexport-> froogle_6168328932 and i can see all the products in the file  but when i add it to Google reader http://www.google.com.ng/reader/view/#stream/feed%2Fhttp%3A%2F%2Ffutwia.com%2Fcontent%2Ffiles%2Fexportimport%2Ffroogle_6168328932.xml

only one product is displayed.


Regards

a touch here and there and it Works fine now. Thanks

Unfortunately i can place my hands on what made it work