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:
PRICES.CSV
AVAILABILITY.CSV
OFFERS.CSV
CUSTOMER_TO_OFFERS.CSV
CSV files format for exchanging data from ERP system and example data
- 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 works together with CUSTOMER_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
- CUSTOMER_TO_OFFERS.CSV file - contains matching of customers to offers (that is wholesale prices). Each time this file has to be uploaded before offers.csv
Format: OFE_NAME;CUSTOMER_ID
Data example:
OFE_NAME;CUSTOMER_ID
OFFER_GROUP_1;SE208687
OFFER_GROUP_1;SE121213
OFFER_GROUP_2;PL208687
OFFER_GROUP_3;NL993234
download CUSTOMER_TO_OFFERS.CSV example file