Sample Data Guidelines
Contents |
Introduction
The Openbravo Commerce solution is shipped with a pre-installed set of data, included in the folder referencedata/sampledata/The_White_Valley_Group. This data is intended to give an idea of what are the available functionalities and can also be used for demo purposes.
This document aims to explain the concepts in which this data was based and to provide some guidelines for those looking to add more data.
Data structure
The White Valley Group
The base layer for this data is our fictional company "The White Valley Group" a multinational outdoor equipment retailer based in Barcelona, Spain.
The group is composed of two companies, "White Valley Spain" for the company owned stores and "The White Valley Franchise" for the franchised stores.
 |
|
The stores
There are currently three stores (1)
- Vall Blanca, based in Barcelona, operates in the Eastern Pyrenees area
- Central Mountains, based in the Canary Islands, operates in the Central Pyrenees area
- Because of its location, Central Mountains sales benefit from tax-exemption when selling to continental Spain customers.
- Posets, based in Pamplona, operates in the Western Pyrenees area (2)(3)
 | (1a) TODO: There are actually six stores, but three of them with bad names
(1b) TODO: The "sample data with modules" dataset has other stores not taken into account here, it is still undecided what will be the approach on this. (2) TODO: The location of the stores do not match their current addresses. (3a) TODO: Explain what characteristics have the stores (PIT, PNIT, taxes, etc.) (3b) TODO: Based on 3a. check any required update to get all the required characteristics in each store. |
| |
|
The store's terminals
Each owned store has three POS terminals:
- Vall Blanca
- VBS-1
- VBS-2
- VBS-3
- Central Mountain
- CMS-1
- ??
- ??
While the franchise has only one:
- Posets
- PS-1
| | TODO: There are currently hundreds of terminals, check if all of them are required.
TODO: Check if CMS-2 and CMS-3 stores should exist. |
| |
|
Business Partners (Vendor/Customer)
Vendors
The company purchase the goods from two vendors, both defined at Company level:
- Vendors of The White Valley Group
- Outdoor Sports, for camping and clothing equipment and
- Mountains and Snow for mountaineering, skiing and climbing gear
Available sections open to new vendors (now loosely covered by the existent ones) are, but not limited to:
- Personal care (repellents, first aid kits, bandages)
- Electronics (cameras, compasses, GPS)
- Optics (sunglasses, magnifying glasses, lighting)
- Accessories for pets (harnesses, camping feeders, clothing)
- Library (books, maps, guides)
- Skiing (nordic, alpine, touring, snowboarding)
- Climbing (harnesses, ropes, belayers)
- Mountain biking (bikes, helmets, accessories)
- Fishing (hooks, lines, rods)
| |
|
Customers
Several customers exist in the Company's database. Because of their geographical influence, some stores may have their own customers, while others exist at Company level.
| |
|
Data Recommendations for Business Partners
- Do not use real data
- If the Partner is a company: Pick a name that provide a hint about the company's goods.
- If the Partner is a person: Use a generic name, try to relate the name with the person's address (French names for France, Spanish names for Spain and so on)
- If the Partner's address is relevant (ie. it is required to be from the Canary Islands to get an special tax discount), try to pick a real city, region and street. Pick a non existent number to not have an actual address.
- IE. if Paseo San Txiki is a real street and the numeration goes from 1 to 100, pick 123 for the address.
Products
The products that the company sell and purchase have to be consistent with a Mountaineering and Outdoor store. The products are within the same categories chosen for Vendors:
- General Outdoor activities: hiking, running, training
- General Camping gear: Tents, bedrolls, lighting.
- Personal care (repellents, first aid kits, bandages)
- Electronics (cameras, compasses, GPS)
- Optics (sunglasses, magnifying glasses, lighting)
- Accessories for pets (harnesses, camping feeders, clothing)
- Library (books, maps, guides)
- Skiing (nordic, alpine, touring, snowboarding)
- Climbing (harnesses, ropes, belayers)
- Mountain biking (bikes, helmets, accessories)
- Fishing (hooks, lines, rods)
| |
|
Data Recommendations for Products
- Do not use trademarked names
- Add an image to the product. Have in mind that the image should be free for distribution (public domain or CC0 and CC-by licenses are allowed, while the rest of the Creative Commons licenses (sa, nc, nd) are not allowed)
- Add all the attributes you may consider useful to describe the product. Not only for the purposes of a particular project but as if it were to be sold to the general public.