integration

Catalog Data Model

The full AStoreShop catalog is available within 11 CSV files and logos.

Here is the UML relationship between 7 of them:

Files & Scheduling

You need to download the CSV file from Accor's SFTP server and import it into your database. To import the catalog following the SQL integrity constraint, we recommend importing CSV files in this order:

Data Type	Type	Updated (GMT)	File in the sFTP server
Companies	FULL	8am 1pm	{lang}-{COUNTRY}/company/company_YYYY-MM-DD-hh-mm-ss.csv
Company's addresses	FULL	8am 1pm	{lang}-{COUNTRY}/company/address_YYYY-MM-DD-hh-mm-ss.csv
Shops	FULL	8am 1pm	{lang}-{COUNTRY}/shop_YYYY-MM-DD-hh-mm-ss.csv
Delivery Calendars	FULL	8am 1pm	{lang}-{COUNTRY}/delivery_calendar/YYYY-MM-DD-hh-mm-ss.csv
Categories	FULL	8am 1pm	{lang}-{COUNTRY}/catalog/category_YYYY-MM-DD-hh-mm-ss.csv
Catalogs	DELTA	8am 1pm	{lang}-{COUNTRY}/catalog/catalog_YYYY-MM-DD-hh-mm-ss.csv
Specific Prices	DELTA	8am 1pm	{lang}-{COUNTRY}/catalog/pricing_YYYY-MM-DD-hh-mm-ss.csv
Logos	FULL	8am 1pm	/logos/ folder PNG files (~200) : {logo_code}.png Brand logos : brand/{brand}.png Special logos : special/{logo}.png Reference CSVs : - accor_label_YYYY-MM-DD-hh-mm-ss.csv - brand_selection_YYYY-MM-DD-hh-mm-ss.csv - sustainability_certifications_YYYY-MM-DD-hh-mm-ss.csv - origin_or_quality_sign_YYYY-MM-DD-hh-mm-ss.csv
Attributes & Options	FULL	8am 1pm	collection/attributes_options_YYYY-MM-DD-hh-mm-ss.csv

LOCALE can be:

• fr-BE
• nl-BE
• de-DE
• es-ES
• fr-FR
• pl-PL
• pt-PT
• nl-NL
• en-UK

Files are updated once per day.

Entities

Company

Companies are your hotels. You are responsible for account management of hotels.

Column	Type	Description	Nullable	Unique
MEGA_CODE	VARCHAR(255)	Primary Key	NO	YES
TARS_CODE	VARCHAR(255)	Partial Key Reserved for future usage	YES	NO
COMPANY_NAME	VARCHAR(40)		NO	NO
COUNTRY	VARCHAR(40)	Example: France	NO	NO
COUNTRY_ISO2	VARCHAR(2)	Example: FR	NO	NO
STATUS	VARCHAR(20)	Possible values: - Blocked - Pending Approval - Rejected - Actif	NO	NO
CUSTOMER_SEGMENTATIONS	VARCHAR(255)	Comma separated fields of customer's segmentation Segmentation filter Example: FRANCHISEES,FR-MERCURE	YES	NO
CUSTOMER_GROUP_IDS	VARCHAR(255)	Comma separated fields of specific price's segmentation Segmentation filter Example: CITADINES,partners	YES	NO
BRAND_SELECTION	VARCHAR(255)	Example: Azureva	YES	NO
CATCHMENT_AREA	VARCHAR(255)	Example: 75 Segmentation filter	YES	NO
DELIVERY_DAYS	VARCHAR(255)	Example: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday	YES	NO
ADMIN_EMAIL	VARCHAR(255)		NO	NO
FIRSTNAME	VARCHAR(255)		NO	NO
LASTNAME	VARCHAR(255)		NO	NO
PROFESSION	VARCHAR(255)		YES	NO

Company's Address

Addresses of Hotels.

It is not allowed to modify or update address.

If you need to modify an address for any hotel, you need first to contact Accor.

Column	Type	Description	Nullable	Unique
ADDRESS_CUSTOMER_ID	VARCHAR(255)	Primary Key Alpha-Numeric	NO	YES
MEGA_CODE	VARCHAR(255)	Foreign Key Company of this address	NO	YES
COMPANY_NAME	VARCHAR(40)		NO	NO
HIDE_FROM_SHIPING_LIST	BOOL	Non-logistical addresses, such as a Headquarters (HQ) or a Billing Office	YES	NO
ADDRESS_NAME	VARCHAR(255)	Quick description of the address	YES	NO
ADMIN_EMAIL	VARCHAR(255)		NO	YES
COUNTRY	VARCHAR(40)	Example: France	NO	NO
CITY	VARCHAR(255)		NO	NO
POSTCODE	VARCHAR(30)		NO	NO
REGION	VARCHAR(40)		YES	NO
STREET	TEXT		YES	NO
TELEPHONE	VARCHAR(255)		YES	NO
VAT_ID	VARCHAR(40)		YES	NO
DEFAULT_BILLING	BOOL	Possible values: FALSE or TRUE	YES	NO
DEFAULT_SHIPPING	BOOL	Possible values: FALSE or TRUE	YES	NO

Shop

Column	Type	Description	Nullable	Unique
SHOP_ID	NUMBER	Primary Key	NO	YES
SHOP_NAME	VARCHAR(255)		NO	NO
SUPPLIER_CODE	NUMBER		YES	NO
SHOP_STATE	VARCHAR(20)	Possible values: - OPEN - CLOSE - SUSPENDED - TERMINATED	NO	NO
CURRENCY_ISO_CODE	VARCHAR(3)	Example: EUR	NO	NO
CHANNEL	VARCHAR(20)	Example: FR	NO	NO
SHIPPING_COUNTRY(3)	VARCHAR(3)	Example: FRA	NO	NO
SUPPLIER_NAME	VARCHAR(255)		NO	NO
SUPPLIER_REGISTRATION_NUMBER	VARCHAR(30)		NO	NO
VAT_NUMBER	VARCHAR(30)		YES	NO
SHIPPING_TYPE_CODES	VARCHAR(100)	List separated by ','	YES	NO
SUPPLIER_GROUP_CODE	VARCHAR(100)	Foreign Key to Shop.SUPPLIER_CODE	YES	NO
MINIMAL_ORDER_AMOUNT	NUMBER		YES	NO
MINIMAL_ORDER_QUANTITY	NUMBER		YES	NO
MINIMUM_ORDER_PACKAGING_UNIT	VARCHAR(255)	Examples: Unit, Bottle, Cardboard_box	YES	NO
MINIMUM_ORDER_PACKAGING	NUMBER		YES	NO
SHIPPING_SETTING_UNIT	VARCHAR(255)	Examples: - NULL - price - packaging_unit -quantity	YES	NO
SHIPPING_PRICE_THRESHOLD	VARCHAR(255)	Example: <0-165>;60/<165-330>;35/<330-440>;25/<440->;0 Means: up to 165 costs 60 € up to 330 costs 35 € up to 440 costs 25 € above 440 € with free shipping	YES	NO
DELIVERY_DAY_BEFORE	NUMBER		YES	NO
PRODUCT_CATEGORIES	VARCHAR(255)	List of category codes separated by ',' Example: kitchen,high_tech,bedding	YES	NO
ACTIVE_LOGISTIC_DAYS	VARCHAR(255)	List of days separated by ',' Example: Monday,Tuesday,Wednesday,Thursday,Friday	YES	NO
EXCLUDED_GROUPS	VARCHAR(255)	Segmentation filter	YES	NO
CATCHMENT_AREA	VARCHAR(255)	List of catchment areas separated by ',' Example: 06,83,98 Segmentation filter	YES	NO

Delivery Calendar

Delivery Round is a specific delivery method where Shop and Hotel make a deal on:

• cut-off time
• logistic delay
• days of the week for possible delivery

Field	Type	Description	Nullable	Unique
MEGA_CODE	VARCHAR(255)	Foreign key to Company.MEGA_CODE	NO	YES
COMPANY_NAME	VARCHAR(40)		NO	NO
SHOP_ID	NUMBER	Foreign key to Shop.SHOP_ID	NO	YES
SHOP_NAME	VARCHAR(255)		NO	NO
LOGISTIC_DELAY	NUMBER		YES	NO
CUTOFF_TIME	BOOL	Example: 13:00	YES	NO
MONDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
TUESDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
WEDNESDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
THURSDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
FRIDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
SATURDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
SUNDAY	BOOL	Possible values: TRUE or FALSE	YES	NO
DAYS_OFF_EXCEPTIONS	TEXT	List of days separated by ';' Holidays days where the supplier is still working Example: 08/05/2024;09/05/2024	YES	NO

Category

Field	Type	Description	Nullable	Unique
CODE (P.K)	VARCHAR(100)		NO	NO
PARENT	VARCHAR(100)	Foreign key to Category.CODE	YES	NO
LABEL	VARCHAR(255)		NO	NO
UPDATED	DATETIME		YES	NO

Catalog

Field	Type	Description	Nullable	Unique
SKU_ACCOR	VARCHAR(64)		NO	YES
GTIN	VARCHAR(255)		YES	NO
GTIN_TYPE	VARCHAR(10)	Possible values: EAN, VN, MPN, ISBN, UPC	YES	NO
OFFER_ID	NUMBER		NO	YES
OFFER_SKU	VARCHAR(255)		NO	YES
CATEGORIES	VARCHAR(255)	List category codes separated by ','	NO	NO
PRODUCT_NAME	VARCHAR(255)		NO	NO
PRODUCT_BRAND	VARCHAR(255)		YES	NO
MANUFACTURER	VARCHAR(255)		YES	NO
LONG_PRODUCT_DESCRIPTION	TEXT		YES	NO
SELLING	NUMBER		YES	NO
SELLING_UNIT	VARCHAR(255)	Example: selling_unit_cardboard_box (***)	YES	NO
PACKAGING	NUMBER		YES	NO
PACKAGING_UNIT	VARCHAR(255)	Example: bottle (***)	YES	NO
ALLERGEN_FREE_PRODUCT	VARCHAR(255)	Example: allergen_free_product_yes	YES	NO
ALLERGEN	TEXT	List of allergens separated by ',' Example: milk,soya	YES	NO
ALLERGEN_TRACES	TEXT		YES	NO
ORIGIN_OR_QUALITY_SIGN	VARCHAR(255)	Example: ["local_product"]	YES	NO
SUBSTAINABILITY_CERTIFICATIONS	VARCHAR(255)		YES	NO
ACCOR_LABELS	VARCHAR(255)		YES	NO
COUNTRY_OF_ORIGIN	VARCHAR(255)	Example: France	YES	NO
SHOP_NAME	VARCHAR(255)		NO	NO
SHOP_ID	NUMBER	Foreign Key to Shop.SHOP_ID	NO	YES
LEADTIME_TO_SHIP	NUMBER		YES	NO
AVAILABLE_START_DATE	DATETIME	Example: 2024-03-24 23:00:00.000	YES	NO
AVAILABLE_END_DATE	DATETIME	Example: 2025-03-24 23:00:00.000	YES	NO
CURRENCY_ISO_CODE	VARCHAR(3)	Example: EUR	YES	NO
ACTIVE	BOOL	Possible values: TRUE or FALSE	NO	NO
QUANTITY	NUMBER		YES	NO
BRAND_SELECTION	VARCHAR(255)	List of brand codes separated by ',' Example: brand_selection_ibis,brand_selection_ibis_styles Segmentation filter	YES	NO
OFFER_BRAND_SELECTION	VARCHAR(255)		YES	NO
EXCLUSIVE_BRAND_SELECTION	VARCHAR(255)	List of brand codes separated by ',' Segmentation filter	YES	NO
EXCLUDED_GROUP	VARCHAR(255)	List of groups separated by ',' Segmentation filter	YES	NO
LOCALE	VARCHAR(255)	Example: fr_FR	YES	NO
CHANNEL	VARCHAR(10)	Example: FR	YES	NO
SHIPPING_TYPE_CODE	VARCHAR(20)	Possible values: - delivery-rounds - STD (Standard Delivery) - EXP (Express Delivery)	YES	NO
PRODUCT_UPDATED_DATE	DATETIME	Example: 2025-12-29 23:00:00.000	YES	NO
OFFER_UPDATED_DATE	DATETIME	Example: 2025-12-29 23:00:00.000	YES	NO
MAIN_IMAGE	VARCHAR(255)	Url	YES	NO
IMAGE_2	VARCHAR(255)	Url	YES	NO
IMAGE_3	VARCHAR(255)	Url	YES	NO
IMAGE_4	VARCHAR(255)	Url	YES	NO
IMAGE_5	VARCHAR(255)	Url	YES	NO
MAINTENANCE_MANUAL	VARCHAR(255)	Url, can be image, PDF, etc	YES	NO
OTHER_DOCUMENTATION	VARCHAR(255)	Url, can bi image, PDF, etc	YES	NO
PMR_STANDARD	VARCHAR(255)	Url, can be image, PDF, etc	YES	NO
TECHNICAL_DATA_SHEET	VARCHAR(255)	Url, can be image, PDF, etc	YES	NO
USER_MANUAL	VARCHAR(255)	Url, can be image, PDF, etc	YES	NO

*** See Quantity computation in "Specific Rules" section.

Specific Price

Specific Prices are negotiated between groups of buyers and sellers.

Field	Type	Description	Nullable	Unique
SHOP_ID	NUMBER	Foreign Key to Shop.SHOP_ID	NO	YES
SHOP_NAME	VARCHAR(255)		NO	NO
PRODUCT_SKU	VARCHAR(64)		NO	YES
OFFER_SKU	VARCHAR(255)	Foreign Key to Catalog.OFFER_SKU	NO	YES
OFFER_ID	NUMBER		NO	YES
PRICE	NUMBER		NO	NO
PRICE_RANGES	TEXT	Tier Prices: Pricing structures where the cost per unit decreases as the quantity purchased increases	YES	NO
DISCOUNT_PRICE	NUMBER		YES	NO
DISCOUNT_RANGES	VARCHAR(255)	Tier Prices	YES	NO
DELIVERY_METHOD	VARCHAR(25)	Possible values: - delivery-rounds - STD (Standard Delivery) - EXP (Express Delivery)	YES	NO
DISCOUNT_START_DATE	DATETIME	YYYY-MM-DD hh:ii:ss	YES	NO
DISCOUNT_END_DATE	DATETIME	YYYY-MM-DD hh:ii:ss	YES	NO
CUSTOMER_GROUP_ID	VARCHAR(255)	List of Customer Group IDs separated by ',' Segmentation filter, Targets Company.CUSTOMER_GROUP_IDS	YES	NO
AVAILABLE_START_DATE	DATETIME	YYYY-MM-DD hh:ii:ss	YES	NO
AVAILABLE_END_DATE	DATETIME	YYYY-MM-DD hh:ii:ss	YES	NO

Attributes & Options

Field	Type	Description	Nullable	Unique
PIM_ATTRIBUTE_CODE	VARCHAR(255) (P.K)	(For internal use only)	NO	YES
ATTRIBUTE_CODE	VARCHAR(255)	attribute code	NO	NO
OPTION_CODE	VARCHAR(255)	option code	NO	NO
OPTION_ADMIN_LABEL	VARCHAR(255)	option label (admin value mostly in French)	NO	NO
OPTION_DE_LABEL	VARCHAR(255)	option label (deutch value)	NO	NO