Wikidata:Property proposal/Coles Online product ID

From Wikidata
Jump to navigation Jump to search

Coles Online product ID[edit]

Originally proposed at Wikidata:Property proposal/Generic

   Not done
Descriptionunique identifier of a product sold via Coles Online
RepresentsColes Online product identifier (Q109361144)
Data typeExternal identifier
Domainproduct (Q2424752)
Allowed values\d{6,7}P+
Example 1iceberg lettuce (Q1310886)4584071P
Example 2bell pepper (Q1548030)4580208P
Example 3bell pepper (Q1548030)7214862P
Example 4Kalamata (Q6350358)5554156P
Formatter URLhttps://shop.coles.com.au/search/resources/store/20529/productview/$1
See alsoAmazon Standard Identification Number (P5749)
Applicable "stated in"-valueColes Online (Q5144658)
Distinct-values constraintyes
Wikidata projectWikiProject Australia (Q11036831)

Motivation[edit]

Provides information about mostly food products from one of the largest supermarket chains in Australia. This includes nutritional, price and occasionally usage and "market conditions" information. Dhx1 (talk) 14:02, 2 November 2021 (UTC)[reply]

Discussion[edit]

  • @99of9: Identifiers such as this are used by [1], [2], [3], [4] and other price comparison websites. This wasn't the main purpose of proposing this property however. The main purpose of this proposal is more in support of the goals of Open Food Facts (Q3353146) which aims to collect data on the type of food products sold and marketed over time, and the nutritional content of foods. These identifiers are also useful to automate calculation of metrics for consumer price inflation or compare consumer prices (particularly fresh produce) across different locations, similar to the methodology of [5] but admittedly without Internet Archive caching pages, there is no way (without using another service such as PriceHipster) to verify point in time pricing when prices change on a weekly basis. --Dhx1 (talk) 03:20, 4 November 2021 (UTC)[reply]
  •  Support OK, I'm in, mostly based on the change to the likely-stable product ID. The JSON is not very readable to humans, but this is Wikidata... it could have very interesting uses for computer analysis of pricing. --99of9 (talk) 07:21, 5 November 2021 (UTC)[reply]
  •  Comment Proposal updated to use product IDs rather than SEO friendly product strings. Formatter URL updated to JSON blob that returns product data including pricing (local to the selected store for the formatter URL which is Richmond South, Victoria chosen because it is closest to where the first Coles store was located in Collingwood, Melbourne), Global Trade Item Number (P3962)'s, supplier names, product weights, links to product images, ingredients, nutrition information, etc. Product IDs are used nationally. Per [6] it appears that Coles are supportive of allowing this data to be made accessible to various third party applications used for price comparisons hence the product IDs appear to be stable and planned to be made available for some time to come. The only issue I see is that Internet Archive is blocked from caching pages so if Coles did change/hide their product IDs in the future (e.g. in favour of the SEO friendly product strings) we wouldn't have any historical data for these IDs to link to. --Dhx1 (talk) 02:33, 4 November 2021 (UTC)[reply]