Data formats in GC.Platform

It is possible to integrate price and product-availability data from CSV files. You can prepare such files yourself — for example, your ERP system can probably be configured to produce them — or prepare them manually in applications like Excel.

Files that can be imported:

GC.CART — erp_products.csv, prices.csv, availability.csv, profiles_prices.csv, profiles_customers.csv

GC.MDM — articles.csv, references.csv, numbers.csv, files.zip, criteria.csv

GC.CART — CSV file formats for exchanging ERP data

Info

Files with _sync delete all past data, leaving only the data from the file available to users — e.g. prices_sync.csv (full-sync type). Files without _sync compare against past data and add or change it, but do not delete data that is not in the file — e.g. prices.csv (upsert type).

erp_products.csv / erp_products_sync.csv

Links TECDOC articles to customer products. It is very important to maintain the exact file structure: proper placement of semicolons, and keeping the first line (header) unchanged. Also make sure the file is named exactly erp_products.csv.

Format:

ARTICLE_ERP_ID;ERP_NUMBER;NUMBER;MANUFACTURER;NAME;CORE_ERP_ID
  • ERP_NUMBER — the number of a customer product; it is the TECDOC equivalent of NUMBER.
  • MANUFACTURER — the name of a manufacturer in TECDOC.

Data example:

ARTICLE_ERP_ID;ERP_NUMBER;NUMBER;MANUFACTURER;NAME;CORE_ERP_ID
BOS0123325012;0 123 325 012;0 123 325 012;BOSCH;Oil filter
BOS0204318582;0 204 318 582;0 204 318 582;BOSCH;Brake pads
TRWGDB1330;GDB1330;GDB1330;TRW;Brake pads
DTX1026R;DTX1026R;DTX1026R;DAXTONE;Common rail injector;COREDTX1026R

Download erp_products.csv example file

prices.csv / prices_sync.csv — prices and ERP key matching

Format:

ARTICLE_ERP_ID;PRICE_TYPE;PRICE;VAT;CURRENCY

An empty Price type is the base price for the article.

Warning

The separator in prices must be . (a dot), not , (a comma).

Data example:

ARTICLE_ERP_ID;PRICE_TYPE;PRICE;VAT;CURRENCY
242054;;178.23;20;EUR
242054;;44.50;20;EUR
A6845F;;200.00;20;EUR
A6845F;;50.00;20;EUR

Download prices.csv example file

availability.csv / availability_sync.csv — product availability

Format:

ARTICLE_ERP_ID;BRANCH;QUANTITY;BRANCH_TYPE

The BRANCH field contains the branch ID. The description that the GC.CATALOG user sees can be set additionally in GC.CART.

Data example:

ARTICLE_ERP_ID;BRANCH;QUANTITY;BRANCH_TYPE
242054;S01;5;
A6845F;S01;17;
242054;S02;1;
A6845F;S02;3;

For non-GC.CATALOG from Inter Cars S.A. clients, the BRANCH field can also contain three specific constants: GREEN, YELLOW, ORANGE. They are used to show colours in GC.CATALOG when displaying product availability on the main product list. From a business perspective, these colours can convey information to the user — e.g. GREEN = available today, YELLOW = available tomorrow — not only the number of goods in stock.

Data example:

ARTICLE_ERP_ID;BRANCH;QUANTITY;BRANCH_TYPE
242054;S01;5;
A6845F;S01;17;
242054;S02;1;
A6845F;S02;3;
242054;S03;4;
A6845F;S03;20;
242054;S04;99;
A6845F;S05;15;

Download availability.csv example file

profiles_prices.csv / profiles_prices_sync.csv

Lets you define all final prices of articles for all the different price profiles.

Format:

PROFILE_NAME;ARTICLE_ERP_ID;PRICE;CURRENCY;VAT

Data example:

PROFILE_NAME;ARTICLE_ERP_ID;PRICE;CURRENCY;VAT
PROFILE_01;242054;45.50;EUR;20
PROFILE_02;A6845F;180.50;EUR;20
PROFILE_03;242054;50;EUR;20
PROFILE_04;A6845F;200;EUR;20
PROFILE_05;242054;63.25;EUR;20
PROFILE_06;A6845F;250;EUR;20

Download profiles_prices.csv example file

profiles_customers.csv / profiles_customers_sync.csv

Matches particular users with particular price profiles.

Format:

PROFILE_NAME;CUSTOMER_ID

CUSTOMER_ID is the same field as "Number in ERP" in GC.CART.

Data example:

PROFILE_NAME;CUSTOMER_ID
PROFILE_01;208687
PROFILE_02;121213
PROFILE_03;PL-5481111
PROFILE_04;993234

Importing new price profiles does not require sending the profiles_customers.csv file. If you want to replace all relationships between users and price profiles, upload a new profiles_customers_sync.csv file — this removes all previous relationships, and only the relationships from the new file remain.

Download profiles_customers.csv example file

GC.MDM — file formats for importing data

You import GC.MDM data files in GC.DASHBOARD, under MDM & PIM → Tools → Import. Click Select import type, choose the type matching your file and upload it.

The Import screen in GC.DASHBOARD. Select import type lists the available file types: articles, references, numbers, files and criteria.

articles.csv — importing articles

Format:

CODE;NUMBER;MANUFACTURER_ID;MANUFACTURER;NAME;DESCRIPTION;GROUP_ID;GROUP;USAGE_ID;USAGE;IMAGES;STATUS

Where:

  • CODE — article ID (optional)
  • NUMBER — article number
  • MANUFACTURER_ID — manufacturer ID (optional if MANUFACTURER is present)
  • MANUFACTURER — manufacturer name (optional if MANUFACTURER_ID is present)
  • NAME — own product name (optional)
  • DESCRIPTION — own short description (optional)
  • GROUP_ID — group ID (optional)
  • GROUP_NAME — group name (optional)
  • USAGE_ID — usage ID (optional)
  • USAGE — usage name (optional)
  • IMAGES — list of image paths (optional)
  • STATUS — product status

Data example:

;04.331ALU;;MARIX;;TŁUMIK MARIX 04.331ALU KOŃCOWY CITROEN C8, PEUGEOT 807 02-06;;;;;;A
;17.638ALU;;MARIX;;TŁUMIK MARIX 17.638ALU KOŃCOWY OPEL ZAFIRA B;;;;;;A
;17.386ALU;;MARIX;;TŁUMIK MARIX 17.386ALU ŚRODKOWY OPEL CORSA C;;;;;;A

Download articles.csv example file

references.csv — importing replacements and accessories

Links a primary article with a secondary article. There are two reference types:

  • REPLACEMENT — the secondary article is a replacement for the primary article. You can show this data, for example, as replacements or cross references.
  • ACCESSORY — the secondary article is an accessory to the primary article. You can show this data, for example, as "Customers also bought".

Format:

CODE_PRIMARY;NUMBER_PRIMARY;MANUFACTURER_PRIMARY;MANUFACTURER_ID_PRIMARY;CODE_SECONDARY;NUMBER_SECONDARY;MANUFACTURER_SECONDARY;MANUFACTURER_ID_SECONDARY;REF_TYPE;QUANTITY;STATUS

Where:

  • CODE_PRIMARY — primary article ID (optional if NUMBER_PRIMARY + MANUFACTURER_PRIMARY is present)
  • NUMBER_PRIMARY — primary article number (optional if CODE_PRIMARY is present)
  • MANUFACTURER_PRIMARY — primary article manufacturer name (optional if CODE_PRIMARY or MANUFACTURER_ID_PRIMARY is present)
  • MANUFACTURER_ID_PRIMARY — primary article manufacturer ID (optional if CODE_PRIMARY or MANUFACTURER_PRIMARY is present)
  • CODE_SECONDARY — secondary article ID (optional if NUMBER_SECONDARY + MANUFACTURER_SECONDARY is present)
  • NUMBER_SECONDARY — secondary article number (optional if CODE_SECONDARY is present)
  • MANUFACTURER_SECONDARY — secondary article manufacturer name (optional if CODE_SECONDARY or MANUFACTURER_ID_SECONDARY is present)
  • MANUFACTURER_ID_SECONDARY — secondary article manufacturer ID (optional if CODE_SECONDARY or MANUFACTURER_SECONDARY is present)
  • REF_TYPE — reference type: REPLACEMENT or ACCESSORY (required)
  • QUANTITY — quantity (e.g. 1)
  • STATUS — reference status (e.g. A)

You can identify each article — primary and secondary — in one of two ways:

  • by article ID — fill in only CODE_PRIMARY / CODE_SECONDARY. The secondary article with code CODE_SECONDARY is linked to the primary article with code CODE_PRIMARY.
  • by number and manufacturer — if you don't use article IDs, fill in the number together with the manufacturer: NUMBER_PRIMARY + MANUFACTURER_PRIMARY and NUMBER_SECONDARY + MANUFACTURER_SECONDARY.

Data example — articles identified by number and manufacturer:

CODE_PRIMARY;NUMBER_PRIMARY;MANUFACTURER_PRIMARY;MANUFACTURER_ID_PRIMARY;CODE_SECONDARY;NUMBER_SECONDARY;MANUFACTURER_SECONDARY;MANUFACTURER_ID_SECONDARY;REF_TYPE;QUANTITY;STATUS
;0 12 300 12;TESTMANUFACTURER;;;AB1234;TESTMAN;;REPLACEMENT;1;A
;0 12 300 12;TESTMANUFACTURER;;;BC230P;TESTMAN;;REPLACEMENT;1;A
;0 12 300 12;TESTMANUFACTURER;;;WWOC;TESTMAN;;REPLACEMENT;1;A
;0 12 300 12;TESTMANUFACTURER;;;12442;TESTWOMAN;;ACCESSORY;1;A
;0 12 300 12;TESTMANUFACTURER;;;12443;TESTWOMAN;;ACCESSORY;1;A

Data example — articles identified by article ID:

CODE_PRIMARY;NUMBER_PRIMARY;MANUFACTURER_PRIMARY;MANUFACTURER_ID_PRIMARY;CODE_SECONDARY;NUMBER_SECONDARY;MANUFACTURER_SECONDARY;MANUFACTURER_ID_SECONDARY;REF_TYPE;QUANTITY;STATUS
123456;;;;234567;;;;REPLACEMENT;1;A
123456;;;;224455;;;;ACCESSORY;1;A

Download references.csv example file

numbers.csv — importing additional numbers

Links additional numbers (each with its manufacturer) to an article.

Format:

CODE;NUMBER;MANUFACTURER;MANUFACTURER_ID;OTHER_NUMBER;OTHER_NUMBER_MANUFACTURER;STATUS

Where:

  • CODE — article ID (optional if NUMBER + MANUFACTURER is present)
  • NUMBER — article number (optional if CODE is present)
  • MANUFACTURER — manufacturer name (optional if CODE or MANUFACTURER_ID is present)
  • MANUFACTURER_ID — manufacturer ID (optional if CODE or MANUFACTURER is present)
  • OTHER_NUMBER — number linked to the article (required)
  • OTHER_NUMBER_MANUFACTURER — manufacturer of the linked number (required)
  • STATUS — number status (e.g. A)

You can identify the article in one of two ways:

  • by article ID — fill in only CODE; OTHER_NUMBER + OTHER_NUMBER_MANUFACTURER are linked to the article with this code.
  • by number and manufacturer — fill in the base NUMBER + MANUFACTURER; OTHER_NUMBER + OTHER_NUMBER_MANUFACTURER are added to it.

Data example:

CODE;NUMBER;MANUFACTURER;MANUFACTURER_ID;OTHER_NUMBER;OTHER_NUMBER_MANUFACTURER;STATUS
;P 85 017;TESTMANUFACTURER;;9010051;AATEST;A
;P 85 017;TESTMANUFACTURER;;FDB4691QS;TESTMAN;A
123456;;;;FCD4455;TESTMAN;A

Download numbers.csv example file

files.zip — importing files linked to articles

You can also import files linked to particular articles, such as images. In this case, all files must be compressed and put into a single files.zip file.

The file names should comply with the following format:

<MANUFACTURER_NAME>_<NUMBER>_<SORT_NUMBER>.<EXTENSION>

For example: TRW_GDB1330_1.jpg

criteria.csv — importing article criteria

When you need to assign technical criteria to a large number of articles at once, prepare a criteria.csv file and import it.

Format:

CODE;NUMBER;MANUFACTURER;MANUFACTURER_ID;GROUP_ID;CRITERION_KEY;CRITERION_VALUE;CRITERION_VALUE_LANG;STATUS

Where:

  • CODE — article ID (optional if NUMBER + MANUFACTURER is present)
  • NUMBER — article number (optional if CODE is present)
  • MANUFACTURER — manufacturer name (optional if MANUFACTURER_ID is present)
  • MANUFACTURER_ID — manufacturer ID (optional if MANUFACTURER is present)
  • GROUP_ID — article group ID — the GRU code of the group the criterion belongs to (required)
  • CRITERION_KEY — criterion key — the KRY code of the criterion (required)
  • CRITERION_VALUE — the value of the criterion for this article (required)
  • CRITERION_VALUE_LANG — language code of the criterion value (only required if the criterion is translatable)
  • STATUS — criterion status

Warning

Closed-list values must already exist. If a criterion uses a closed list of values (e.g. Tyre Type: All Season Tyres / Summer Tyres / Winter Tyres / Off-road tyres), the value must first be created manually in GC.MDM under Criteria for article groups. Only after the value exists in the list can it be used in a criteria.csv import.

Data example:

Example criteria.csv content opened in Excel. Two articles (NUM-100020, NUM-100021) each receive two criteria: Tyre Type (KRITNR_1427) and Rim Size (KRITNR_75).

Download criteria.csv example file

Previous
GC.AUTH — application access
Next
FTP data integration — for Inter Cars shops