Purchase summary

FMCG prices in France Consumer Purchasing

The database contains actual prices of 8,700 fast moving consumer goods sold by 24 chain stores in more than 6,700 points of sale accross France. There are more than 13,500,000 unique prices (price of every good may vary depending on point of sale, even within the same chain store). Prices are collected since the beginning of May 2017 from the retailer’s websites, but the process of building records is performed by people, as only people can recognize the same product in different online shops. The result is complete history of price changes for every product in every localization, and the current state of the FMCG market. Database is updated on a daily basis.  Database consists of three tables (Stores, Prices  and Products) but may be flattened to one table if there is a need. These tables are described below. Provided samples are not compatible – there is no connection between sampled products in sampled stores with sampled price. 

 

 

 

Database details

 

 

Stores table

 

 

 

Field Name

 

Field Description

 

 

 

id_store (integer)

 

ID of unique point of sale

 

 

 

Name (string)

 

Name of unique point of sale

 

 

 

Merchant (string)

 

Name of chain store

 

 

 

Latitude (decimal)

 

Geographical latitude (if applicable)

 

 

 

Longitude (decimal)

 

Geographical longitude (if applicable)

 

 

 

City (string)

 

Name of city given POS is located in

 

 

 

Postal code (integer)

 

Postal code - part of given POS address

 

 

 

Street (string)

 

Street – part of given POS address

 

 

 


 

 

Prices table

 

 

Field Name

Field Description

 

 

id_price (integer)

ID of unique price of unique product (described by id_product

 

below in the same table)

 

 

Date (string)

Date of last price check

 

 

id_store (integer)

ID of unique POS in which given product is sold for given price

 

 

Price (decimal)

The unique price itself expressed in euros

 

 

id_product (integer)

ID of unique product which this price is related to

 

 

 

Products table

 

 

Field Name

Field Description

 

 

id_product (integer)

ID of unique product

 

 

EAN (integer)

EAN value of this unique product

 

 

Name (string)

Name of this unique product

 

 

Brand (string)

This unique product’s brand

 

 

Volume (string)

Volume (for liquids and loose bodies), or number of items in the

 

single packaging, or weight net

 

 

Volume_text (string)

Description of volume and packaging like “1.5 l bottle”

 

 

Unit (string)

Unit of volume

 

 


 

 

 

Confidentiality Notice

 

The material contained herein, including but not limited to all software, design, drawings, technical specifications and other confidential information (”Material”), is the exclusive property of q Data Exchange (“q”) and its suppliers. The Material is classified as strictly confidential, and is internationally protected by copyright, trademark and other related laws. The Material is provided to you for internal use only and shall only be used as expressly instructed by q. Any copying, reproduction, modification or distribution not in accordance with an express written agreement with q is expressly prohibited, and may result in significant civil damages and/or criminal penalties. q actively and aggressively enforces its intellectual property rights to the fullest extent of the law. The depicted third party services are only for illustrative purposes to show how potential services might look on a platform or device. Any such illustration does not imply any existing or anticipated relationship between q and any content owner or service provider.

 

 

 

 

 

 

For more information please contact us at contact@q-dx.com

 

Ask Seller For Quote