Microformats For Oscommerce, Microformats votes (Microformats ratings) for Oscommerce online shops Options

[Beleth]

Result: Error: TABLE_PRODUCTS_PRICES' doesn't exist

[Web Design Seo]

Your version of OSC is different. Tomorrow we will have fix for this version, just wait.

[Beleth]

Your version of OSC is different. Tomorrow we will have fix for this version, just wait.

Any news?

[Ivan Stamenov]

Any news?

Hi, Beleth.

I installed a fresh copy of osCommerce 2.2.RC2a on one of our servers and installed the MFV functionality. It worked "right out of the box". Then I dig into the 2.2RC2a's database structure. It was quite different from what I saw in the screenshots of your database structure you sent us. Your version is heavily modified - core fields are missing in the `products` table at least.

For security reasons you refused to give us temporary access to your database and FTP. It is perfectly OK, but that means that I have to develop custom changes in our plugin based on screenshots. Unfortunately I do not have the time ability to do that.

[Beleth]

Hi, Beleth.

I installed a fresh copy of osCommerce 2.2.RC2a on one of our servers and installed the MFV functionality. It worked "right out of the box". Then I dig into the 2.2RC2a's database structure. It was quite different from what I saw in the screenshots of your database structure you sent us. Your version is heavily modified - core fields are missing in the `products` table at least.

For security reasons you refused to give us temporary access to your database and FTP. It is perfectly OK, but that means that I have to develop custom changes in our plugin based on screenshots. Unfortunately I do not have the time ability to do that.

I think you are wrong, we haven't talk about my database structure or a ftp acces for a review and i haven't send you any screenshots, maybe some one else have you contacted with this problem and you think its me, my version its 2.2ms not 2.2rc2, and the table that shows error: TABLE_PRODUCTS_PRICES i'ts no avalaible in this version, its impossible to success in a clean installation. In 2.2 the prices are stored in TABLE_PRODUCTS in PRODUCTS_PRICE, not in TABLE_PRODUCTS_PRICES. Please confirm i have buy module because you say in site that its valid for my version.

Regards

[Web Design Seo]

What to say - we have download v.2.2 from oscommerce website and test our addon - is working. I found only small bug in css. But in this version is no such a database table

If you want to resolve your problem, you may need to give us ftp and database access to find your problem. Please, send this data in monday to our email from email used in your purchase.

[Beleth]

What to say - we have download v.2.2 from oscommerce website and test our addon - is working. I found only small bug in css. But in this version is no such a database table

If you want to resolve your problem, you may need to give us ftp and database access to find your problem. Please, send this data in monday to our email from email used in your purchase.

I have mailed my ftp information.

[Web Design Seo]

Problem is resolved. We found bug in our oscommerce addon and fixed them. Problem was shown only when you have product on promo price without end data of promotion.

All in your site is now ok, please, check. I send you also updated plugin.

Microformats votes for Oscommerce is updated in our file directory with new version. Addon is updated on 16 October 2012, latest version is v.1.2. Added are rel=author and rel=publisher parameters, and support for latest v.2.2.x of OsCommerce.

[Beleth]

Problem is resolved. We found bug in our oscommerce addon and fixed them. Problem was shown only when you have product on promo price without end data of promotion.

All in your site is now ok, please, check. I send you also updated plugin.

Now Works perfect!

[Beleth]

Now Works perfect!

One More Question:

In type: http://data-vocabulary.org/
The Description exported shows html code <P align=center><IMG src="xxx.jpg"></P> <P align=justify> etc and after the text of description. It's possible to export without html code? i have see that google indexes product with html code in description.

Regards, good work

[Web Design Seo]

Today, 22 October 2012 is added version 1.3 of OSC microformats plugin - added are new "meta tags in body" options to show meta tags in html body.

Example html 5 code on product page:

Код

<span itemscope itemtype="http://schema.org/Product">
<meta itemprop="brand" content="onlinemerchant" />
<meta itemprop="name" content="Pro PHP Security - 1590595084" />
<meta itemprop="url" content="http://onlinemerchant/index.php?Products&pro_php_security" />
<meta itemprop="productID" content="upc:1" /><meta itemprop="image" content="http://onlinemerchant/public/products/product_info/pro_php_security.jpg" /><meta itemprop="description" content=".... my product description" />
<span itemprop="offers" itemscope itemtype="http://schema.org/Offer">
<meta itemprop="price" content="44.99" />
<meta itemprop="priceCurrency" content="USD" />
<link itemprop="availability" href="http://schema.org/InStock" />
<span itemprop="seller">
<span itemscope itemtype="http://schema.org/Organization">
<meta itemprop="name" content="onlinemerchant" />
<meta itemprop="url" content="http://onlinemerchant/index.php" />
</span>
</span>
</span>
<span itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">
<meta itemprop="itemReviewed" content="Pro PHP Security - 1590595084" />
<meta itemprop="ratingValue" content="0" />
<meta itemprop="bestRating" content="5" />
<meta itemprop="worstRating" content="1" />
<meta itemprop="ratingCount" content="0" />
</span>
</span>

In this way you can show in different way ratings with microformats on product page.

[Web Design Seo]

Today, 13.12.2012 is released v.1.4 of microformats for Oscommerce.

Added is support for Oscommerce 2.3 and for OsCommerce 3.0! Tested on Osc 2.3.3 and Osc 3.0.2.

Now you can use our Oscommerce microformats add-on in all Osc versions.

[Beleth]

Hi Again, before months i saw that my Rich Snippets doesn't works fine and i downloaded your last version.

(Oscommerce v.2.2ms)

I see 2 errors:

When test Rich Snippets in google test page i get 2 differents errors:

When product don't have reviews and votes:

Item
type: http://data-vocabulary.org/review-aggregate
property:
itemreviewed: NAME OF PRODUCT OF MY SITE
rating:
Item 2
count: 0
Error: count field is 0.
Error: Rating could not be normalized.
Error: Please provide best and worst.

And when the product have reviews and votes:

Item
type: http://data-vocabulary.org/review-aggregate
property:
itemreviewed: NAME OF PRODUCT OF MY SITE
rating:
Item 2
count: 3
Error: If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes. More information about aggregate reviews.

Any solution?

Regards!

This post has been edited by Beleth: Feb 16 2014, 01:11 PM

[Web Design Seo]

Error: If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes.

You must have at least two votes.

[Beleth]

You must have at least two votes.

There are no solution for this error when no votes or reviews avalaible?

In other side i have ask your people about other issue:

Product with votes and reviews shows this issue:

Error: If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes. More information about aggregate reviews.

[Web Design Seo]

Please, post here link to your page with at least two votes to check in monday. If you don't want to post here link to your site, send me Personal message.

[pavelKukov]

Only valid format of microdata for google search engine is "META Microdata".
If your target is google you must set "Rich Snippets Format" to "META Microdata".

[Beleth]

Only valid format of microdata for google search engine is "META Microdata".
If your target is google you must set "Rich Snippets Format" to "META Microdata".

Hi, i have change to META MICRO DATA but still receiving same message from Google Webmasters Tools when manual entering a product link for try the new configuration:

When no votes or comments:

Error: count field is 0.
Error: Rating could not be normalized.
Error: Please provide best and worst.

When votes and comments:

Error: If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes. More information about aggregate reviews.

[Web Design Seo]

Error: count field is 0.

I send you answer previous time: You must have at least two votes.

Код

http://www.google.com/webmasters/tools/richsnippets?q=http%3A%2F%2Fwww.licorea.com%2Fsantiago-de-cuba-a%C3%B1ejo-cuba-p-975.html

I see your page in test tool ok. Text "If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes." is just notice.

Anyway, I will test your site little more tomorrow morning.

[pavelKukov]

Hi, i have change to META MICRO DATA but still receiving same message from Google Webmasters Tools when manual entering a product link for try the new configuration:

When no votes or comments:

Error: count field is 0.
Error: Rating could not be normalized.
Error: Please provide best and worst.

When votes and comments:

Error: If count is specified in review aggregate, page should contain reviews. Otherwise you may want to use votes. More information about aggregate reviews.

I can see in source code of your site at url:

Код

removed by user request

that you have not changed data format.

Now is

Код

<span itemscope itemtype="http://data-vocabulary.org/Product">

but in META Microdata will be

Код

<span itemscope itemtype="http://schema.org/Product">

Go in the backend (admin panel): Configuration => My Store and set the following settings:
a) Rich Snippets Format - set this to 'META Microdata'