This is the archive of the goodrelations dicussion list

-- apologies for resending, the original message was not delivered --

Dear all:

The new German E-Commerce legislation requires listing shipment and
delivery charges directly with the price per item.

This gives a nice showcase to illustrate the power of the GoodRelations
vocabulary for exchanging offer data for affiliate business.

With a simply query as shown below, you could get the unit price
(?pvalue) and the shipment charges (?svalue)  from your offer data.

# List offers that have unit price and delivery charge data

SELECT DISTINCT ?o, (?pvalue + ?svalue), ?pvalue, ?svalue, ?pcur WHERE {
?o a gr:Offering.
?o rdfs:label ?label.
?o gr:hasPriceSpecification ?p.
?p a gr:UnitPriceSpecification.
?p gr:hasCurrency ?pcur.
?p gr:hasCurrencyValue ?pvalue.
?o gr:hasPriceSpecification ?s.
?s a gr:DeliveryChargeSpecification.
?s gr:hasCurrency ?scur.
?s gr:hasCurrencyValue ?svalue.
FILTER (?pcur = ?scur)
}

You could also list all business entities whose offers are missing
delivery charge data for at least one offer:

# List business entities whise offers lack delivery charge data

SELECT DISTINCT ?b, ?name {
?b a gr:BusinessEntity.
?b gr:legalName ?name.
?b gr:offers ?o.
?o a gr:Offering.
?o gr:hasPriceSpecification ?p.
?p a gr:UnitPriceSpecification.
OPTIONAL
{?o gr:hasPriceSpecification ?s.
?s a gr:DeliveryChargeSpecification.
?s gr:hasCurrency ?scur.
?s gr:hasCurrencyValue ?svalue.
}
FILTER (!BOUND(?s))
}

For more recipes and examples, see the developer's wiki at

http://www.ebusiness-unibw.org/wiki/GoodRelations


Best wishes

Martin Hepp

PS: You can try those queries on a small subset of GoodRelations data via
http://loc.openlinksw.com/sparql

-- 
--------------------------------------------------------------
martin hepp
e-business & web science research group
universitaet der bundeswehr muenchen

e-mail:  mhepp at computer.org
phone:   +49-(0)89-6004-4217
fax:     +49-(0)89-6004-4620
www:     http://www.unibw.de/ebusiness/ (group)
          http://www.heppnetz.de/ (personal)
skype:   mfhepp
twitter: mfhepp

Check out GoodRelations for E-Commerce on the Web of Linked Data!
=================================================================

Webcast:
http://www.heppnetz.de/projects/goodrelations/webcast/

Recipe for Yahoo SearchMonkey:
http://tr.im/rAbN

Talk at the Semantic Technology Conference 2009:
"Semantic Web-based E-Commerce: The GoodRelations Ontology"
http://tinyurl.com/semtech-hepp

Talk at

Overview article on Semantic Universe:
http://tinyurl.com/goodrelations-universe

Project page:
http://purl.org/goodrelations/

Resources for developers:
http://www.ebusiness-unibw.org/wiki/GoodRelations

Tutorial materials:
CEC'09 2009 Tutorial: The Web of Data for E-Commerce: A Hands-on 
Introduction to the GoodRelations Ontology, RDFa, and Yahoo! SearchMonkey
http://tr.im/grcec09