Data formats
It is possible to integrate prices and products availability data from CSV files. You can prepare such files by yourself - for example your ERP system probably can be prepared to produce such files. You can also prepare them manually in applications like Excel.
Files possible to import:
GC.CART
PRICES.CSV
AVAILABILITY.CSV
OFFERS.CSV
CUSTOMERS_TO_OFFERS.CSV
DISCOUNTS.CSV
GC.MDM
ARTICLES.CSV
ARTICLES_CROSS.CSV
GC.CART - CSV files format for exchanging data from ERP system with data examples
- PRICES.CSV file - Prices and erp keys matching.
Format: ARTICLE_ERP_ID;PRICE_TYPE;PRICE;VAT;CURRENCY;MANUFACTURER;NUMBER;NAME
MANUFACTURER and NUMBER fields are optional and they are used to match ARTICLE_ERP_ID with article in MDM system. Name is optional and used to help later match articles that didn't match automatically.
Empty Price type is base price for article.
If you use in you business one wholesale price for all customers you can use WP (Wholesale Price) price type. If your business model for wholesale prices is more advanced you'll probably won't use this Price Type field.
Data example:
ARTICLE_ERP_ID;PRICE_TYPE;PRICE;VAT;CURRENCY;MANUFACTURER;NUMBER;NAME
242054;;178.23;20;EUR;BOSCH;0 123 325 012;Oil filter
242054;WP;44.5;20;EUR
A6845F;;200;20;EUR;BOSCH;0 204 318 582:Brake pads
A6845F;WP;50;20;EUR
download PRICES.CSV example file - AVAILABILITY,CSV file - information about products availability
Format: ARTICLE_ERP_ID;BRANCH;QUANTITY
Field BRANCH contains branch ID. It's description that GC.CATALOG user sees can be set in GC.CART additionally.
Data example
ARTICLE_ERP_ID;BRANCH;QUANTITY
242054;S01;5
A6845F;S01;17
242054;S02;1
A6845F;S02;3
Following applies for 'non-GC.CATALOG from Inter Cars S.A.' clients:
BRANCH field can also contain three specific constants: "GREEN", "YELLOW", "ORANGE". They are used to show colors in GC.CATALOG when showing products availability on main product list. From the business perspective these colors can be used to show some informations to user like GREEN - available today, YELLOW - available tomorrow, ect., not only the number of goods on stock.
Data example
ARTICLE_ERP_ID;BRANCH;QUANTITY
242054;S01;5
A6845F;S01;17
242054;S02;1
A6845F;S02;3
242054;GREEN;4
A6845F;GREEN;20
242054;ORANGE;99
A6845F;ORANGE;15
download AVAILABILITY.CSV example file
- OFFERS.CSV file - Use this and next file if you want to have special-offers-based wholesale pricing. It can work together with CUSTOMERS_TO_OFFERS.CSV file. OFFERS.CSV file contains offers and prices belonging to that offers,
Format: OFE_NAME;ARTICLE_ERP_ID;PRICE;CURRENCY
Data example:
OFE_NAME;ARTICLE_ERP_ID;PRICE;CURRENCY
OFFER_GROUP_1;242054;45.50;EUR
OFFER_GROUP_1;A6845F;180.50;EUR
OFFER_GROUP_2;242054;50;EUR
OFFER_GROUP_2;A6845F;200;EUR
OFFER_GROUP_3;242054;63.25;EUR
OFFER_GROUP_3;A6845F;250;EUR
download OFFERS.CSV example file
- CUSTOMERS_TO_OFFERS.CSV file - contains matching of customers to offers (that is wholesale prices). CUSTOMER_ID is the same field as "Number in ERP" in GC.CART.
Format: OFE_NAME;CUSTOMER_ID
Data example:
OFE_NAME;CUSTOMER_ID
OFFER_GROUP_1;208687
OFFER_GROUP_1;121213
OFFER_GROUP_2;208687
OFFER_GROUP_3;993234
The "CUSTOMERS_TO_OFFERS.CSV" file defines which user is associated with a particular offer. Importing new offers does not require sending the "CUSTOMERS_TO_OFFERS.CSV" file.
If you want to replace all the relationships among buyers and offers, upload a new "CUSTOMERS_TO_OFFERS.CSV" file. This will remove all the previous relationships and only the relationships from a new file will be left.
download CUSTOMERS_TO_OFFERS.CSV example file
- DISCOUNTS
In a file with discounts a header always has three positions separated by semicolons. Exemplary combinations of different discounts are shown below:
CUSTOMER_ID;MANUFACTURER;DISCOUNT
;;20 - All customers are getting 20% discount on all manufacturers
10401;;30 - Customer 10401 is getting on all manufacturer 30% discount
;BOSCH;35 - All customers are getting 35% discount on the selected manufacturer, e.g.: Bosch
10401;BOSCH;40 - Customer 10401 is getting 40% discount on Bosch only
GC.MDM - CSV files formats for importing data to GC.MDM with data examples
- ARTICLES.CSV file - importing articles to GC.MDM.
Format: CODE;NUMBER;MANUFACTURER_ID;MANUFACTURER;NAME;DESCRIPTION;GROUP_ID;GROUP;USAGE_ID;USAGE;IMAGES;STATUS
where:
CODE - GC.MDM article ID (optional)
NUMBER - GC.MDM article number
MANUFACTURER_ID - GC.MDM manufacturer ID - (optional i MANUFACTURER is present)
MANUFACTURER - GC.MDM manufacturer name - (optional i MANUFACTURER_ID is present)
NAME - GC.MDM own product name (optional)
DESCRIPTION - GC.MDM own shot description (optional)
GROUP_ID - GC.MDM group ID (optional)
GROUP_NAME - GC.MDM group name (optional)
USAGE_ID - GC.MDM usage ID (optional)
USAGE - GC.MDM usage name (optional)
IMAGES - GC.MDM list of images path (optional)
STATUS - GC.MDM 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 - ARTICLES_CROSSED.CSV file - importing cross-references and other linked articles to GC.MDM
Format: TYPE;CODE;CODE_2;NUMBER;NUMBER_2;MANUFACTURER;MANUFACTURER_2;QUANTITY;STATUS
where:
TYPE - cross-reference type
CODE - GC.MDM article ID (optional if pair NUMBER+MANUFACTURER is present)
CODE_2 - cross-reference article ID (optional if pair NUMBER_2+MANUFACTURER_2 is present)
NUMBER - GC.MDM article number
NUMBER_2- cross-reference GC.MDM article number
MANUFACTURER - GC.MDM manufacturer name
MANUFACTURER_2 - cross-reference GC.MDM manufacturer name
QUANTITY - leave empty
STATUS - leave empty
Data example:
download ARTICLES_CROSSED.CSV