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.
GC.CART - CSV files format for exchanging data from ERP system with data examples
- PRICES.CSV file - Prices and erp keys matching.
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.
242054;;178.23;20;EUR;BOSCH;0 123 325 012;Oil filter
A6845F;;200;20;EUR;BOSCH;0 204 318 582:Brake pads
download PRICES.CSV example file
- AVAILABILITY,CSV file - information about products availability
Field BRANCH contains branch ID. It's description that GC.CATALOG user sees can be set in GC.CART additionally.
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.
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,
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.
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
In a file with discounts a header always has three positions separated by semicolons. Exemplary combinations of different discounts are shown below:
;;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.
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
;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
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