Format description for product data format BMEcat 1.2 for Meplato

Last modified: 12. January 2021

Overview of data formats

Here you will find an overview of available data formats and their corresponding contents:

FormatNameDescription
SUPPLIER_AIDSupplier article number (SKU)Your order number for the item must be entered here. This information is mandatory and must be unique. The permitted length depends on the target system. Spaces and upper and lower case letters are not considered distinguishing features
DESCRIPTION_SHORTShort item descriptionShort description or name of the product, max. 80 characters (specified by BMEcat)
Important! Max. 40 characters can be transferred to SAP. The first 40 characters should therefore be unique
DESCRIPTION_LONGItem descriptionDetailed item description, max. 2,000 characters (including spaces). The more detailed this information is, the easier it is to find this item via the keyword search.
Important!
Formatting characters such as line breaks etc. are not permitted
MANUFACTURER_NAMEManufacturerName of the product’s manufacturer
MANUFACTURER_AIDManufacturer article number (SKU)Article number provided by the manufacturer, max. 50 characters
PRICE_QUANTITYPrice quantityIntegers! Quantity of the underlying order unit. Only the following values can be used here: 1, 10, 100, 1,000, 10,000 or 100,000
ORDER_UNITOrder unitUnit of measurement of the order quantity. Describes the unit of measurement or the package unit in which the item is delivered. The price refers to one order unit. Only predefined ISO codes are permitted
NO_CU_PER_OUUnits containedNumber of units per order unit
CONTENT_UNITContent unit of measurementUnit of measurement for the contents specified.
Indicates the unit of measurement or package unit descriptor of the contents, i.e. the actual item. This field is of informative nature and is not related to the price. Only predefined ISO codes are permitted
LOWER_BOUND1Lowest price scale quantityMinimum purchase quantity for the standard price.
No decimals allowed, minimum >= minimum order quantity. When using scaled prices, PRICE_AMOUNT and LOWER_BOUND are given for each scale quantity
PRICE_AMOUNT1Standard priceNet price of the smallest scale quantity. No currency symbols!
LOWER_BOUND2Scale quantity 2Minimum purchase quantity for the scaled price amount 2.
No decimal places allowed, further scales must be defined in pairs (quantity and price) in separate columns, max. 9 pairs
PRICE_AMOUNT2Scaled price amount 2Net price for scale quantity 2.
No currency symbol, further scales must be defined in pairs (quantity and price) in separate columns, max. 9 pairs
CURRENCYCurrencyCurrency abbreviation
Symbols (such as € or $) are not allowed
QUANTITY_MINMinimum order quantityMinimum order quantity for the specified order unit,
minimum: 1
QUANTITY_INTERVALQuantity interval/stepIncrements in which the product can be ordered, starting from the minimum order quantity,
minimum: 1
DELIVERY_TIMEDelivery timeIndication in working days, no decimal places allowed
Attention! This can be overwritten during the ITscope export, half days possible
eCl@ss 5.1.4
eCl@ss 7.1
eCl@ss 8.1
eCl@ss 10.1
eCl@ss codeClassification of the product group according to the eCl@ss standard.
Project dependent! Either ECLASS, UNSPSC or both may be required
UNSCPSC 20.0601UNSPSC codeClassification of the product group according to the UNSPSC standard.
Project dependent! Either ECLASS, UNSPSC or both may be required
CATEGORY1
CATEGORY2
CATEGORY3
CATEGORY4
Category1
Category2
Category3
Category4
Classification system for product groups
Attention! Branch structure, hierarchy levels are defined in separate columns, max. 9 levels, each product must have at least one entry in CATEGORY1. Further hierarchy levels (CATEGORY5 etc.) possible. Max. 50 characters per CATEGORY
MIME_INFOImage file (normal)Two alternatives:
1) File is hosted in the Meplato Store: file name of the product image without path, recommended resolution 300×250 pixels, formats: *.jpg, *.gif
2) File is hosted externally: URL of the product image, use ‘https://’ protocol
DATASHEETDatasheet fileTwo alternatives:
1) File is hosted in the Meplato Store: File name of the product datasheet without path, formats: *.pdf, *.html
2) File is hosted externally: URL of the product datasheet, use ‘https://’ protocol
KEYWORDKeywords, synonyms, search termsTo allow better identification of the product. Separate terms with commas, max. 1,000 characters, max. 50 characters per term.
Attention! This can be overwritten during the ITscope export
TAXVAT rateRequired format: 0.XX
BUYER_AIDBuyer article number (SKU)SAP material number, or item number of the buyer, max. 50 characters
ERP_GROUP_BUYERBuyer ERP groupMax. 10 characters
FNAME1

FVALUE1
Feature name 1

Feature value 1
Features of an item can be defined via the feature name and value. Product features must be defined in pairs (name and value) in separate columns.
Max. 60 characters, max. 9 pairs
FNAME2

FVALUE2
Feature name 2

Feature value 2
Features of an item can be defined via the feature name and value. Product features must be defined in pairs (name and value) in separate columns.
Max. 60 characters, max. 9 pairs
EANEAN/GTINEuropean Article Number (GTIN/EAN) 8,12,13 or 14 digits
SPECIAL_TREATMENT_CLASS_TYPE1

SPECIAL_TREATMENT_CLASS1
Hazardous goods class 1

Hazardous goods label 1
Products containing dangerous substances must be labelled accordingly. Dangerous goods class and label must be defined in pairs in separate columns, max. 9 pairs
Caution! Products without hazardous substances do not require a label
SPECIAL_TREATMENT_CLASS_TYPE2

SPECIAL_TREATMENT_CLASS2
Hazardous goods class 2

Hazardous goods label 2
Products containing dangerous substances must be labelled accordingly. Dangerous goods class and label must be defined in pairs in separate columns, max. 9 pairs
Caution! Products without hazardous substances do not require a label
INTRASTAT_CODE

INTRASTAT_ORIGIN_COUNTRY


INTRASTAT_NET_WEIGHT

INTRASTAT_GROSS_WEIGHT

INTRASTAT_WEIGHT_UNIT


INTRASTAT_TRANSACTION_TYPE

INTRASTAT_MEANS_OF_TRANSPORT
INTRASTAT code

ISO code – country of origin

Net weight

Gross weight

ISO code – weight unit

Transaction type

Means of transport
Information on the INTRASTAT data for the product:

Fields INTRASTAT_CODE and INTRASTAT_ORIGIN_COUNTRY are mandatory if you want to provide INTRASTAT data for your product.

CODE: INTRASTAT code, e.g. 38220000
ORIGIN_COUNTRY: ISO code for the country of origin, e.g. DE
NET_WEIGHT: net weight, e.g. 102.10
GROSS_WEIGHT: gross weight, e.g. 108.50
WEIGHT_UNIT: ISO code for the unit of the weight information provided, e.g. KGM
TRANSACTION_TYPE: type of transaction, e.g. 11 for purchase or 14 for leasing
MEANS_OF_TRANSPORT: means of transport for the product, e.g. 3 for road transport or 5 for mail items
Summary table data formats BMEcat1.2 for Meplato

Table with three example products

Below you will find an exemplary representation of some product information adapted to BMEcat1.2 for Meplato. This can be used as a template for structuring a table file complying with BMEcat1.2 rules.

Please also take note of the following:

  • Consider customer-specific requirements
  • the designators in the “format” column must not be changed or adapted. Further columns for additional product information can be added if required
  • format fields that are not used can be removed (SUPPLIER_AID etc…)
  • the more product information is provided, the better.
FormatExample 1Example 2Example 3
SUPPLIER_AID643827601082723842
DESCRIPTION_SHORTEraser, for pencils and crayonsEnvelope C6, with windowLetter tray 1027 DIN C4, colour: blue
DESCRIPTION_LONGSoft rubber eraser for pencils and crayons on all types of paperFormat: 162x114mm, envelopes with grey inner printColoured letter trays for documents up to A4 format; dimensions (W/D/H): 25.5/34.8/6.5 cm
MANUFACTURER_NAMEExample Inc.Example Inc.Example Inc.
MANUFACTURER_AIDP7734P4642P6374
PRICE_QUANTITY111
ORDER_UNITPCEPAPA
NO_CU_PER_OU10003
CONTENT_UNITPCEPCE
LOWER_BOUND1111
PRICE_AMOUNT10.5218.553.64
LOWER_BOUND220510
PRICE_AMOUNT20.4417.63.48
CURRENCYEUREUREUR
QUANTITY_MIN111
QUANTITY_INTERVAL151
DELIVERY_TIME113
eCl@ss 5.1.4
eCl@ss 7.1
eCl@ss 8.1
eCl@ss 10.1
24-24-22-0124-26-23-0124-29-11-01
UNSCPSC 20.0601441218044412150444111503
CATEGORY1Office supplies, office equipment, office technology Office supplies, office equipment, office technologyOffice supplies, office equipment, office technology
CATEGORY2Writing utensils, sharpeners, erasers and correction fluidPaper, foil, shipping packaging (office)Organising, archiving
CATEGORY3ErasersEnvelopes, mailing bags, packing paper (office)Letter trays, sorting baskets, standing file boxes
CATEGORY4EnvelopesLetter trays, sorting baskets
MIME_INFOEraser.jpgEnvelope.jpghttps://www.supplier.com/media/lettertray.jpg
DATASHEETEnvelope.pdfhttps://www.supplier.com/media/lettertray.pdf
KEYWORDAll-purpose eraser, lead eraser, colour pencil eraser, foil eraser, gel pen eraser, rubber eraser, combination eraser, copy pencil eraser, plastic eraser, marker eraser, rubber eraser, foam eraser, ink eraser, drawing eraserEnvelope, envelope bundle, envelope bundle (airmail), envelope bundle (bereavement letter), airmail envelope,
letter envelope, bereavement letter envelope
Filing tray, letter tray, letter box, mail tray, desk accessory (letter tray)
TAX0.190.070.19
BUYER_AID123412341234
ERP_GROUP_BUYER
FNAME1

FVALUE1
Preferred item

Yes
Country of origin

DE
Colour

blue
FNAME2

FVALUE2
Width

10 cm
Weight

5 kg
EAN
SPECIAL_TREATMENT_CLASS_TYPE1

SPECIAL_TREATMENT_CLASS1
Hazardous item

F
Dangerous goods regulation (GGVS)

33 12003 Petrol
SPECIAL_TREATMENT_CLASS_TYPE2

SPECIAL_TREATMENT_CLASS2
Hazardous substance

XN
INTRASTAT_CODE

INTRASTAT_ORIGIN_COUNTRY

INTRASTAT_NET_WEIGHT

INTRASTAT_GROSS_WEIGHT

INTRASTAT_WEIGHT_UNIT

INTRASTAT_TRANSACTION_TYPE

INTRASTAT_MEANS_OF_TRANSPORT
38220000

DE

0.8

1

KGM

11

3
38220000

AT

75

100

GRM

14

5
Summary table with three example products, data format BMEcat1.2 for Meplato

Extensive information on BMEcat Version 1.2 can be found in the following document:

Was this article helpful?
Dislike 0
Views: 441