Here you will find an overview of available data formats and their corresponding contents: <\/p>\n\n\n\n <\/p>\n\n\n\n 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.<\/p>\n\n\n\n Please also take note of the following:<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n Extensive information on BMEcat Version 1.2 can be found in the following document:<\/p>\n\n\n\n Overview of data formats Here you will find an overview of available data formats and their corresponding contents: Format Name Description SUPPLIER_AID Supplier article number (SKU) Your order number for …<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[174],"kbtag":[],"class_list":["post-6877","kb","type-kb","status-publish","hentry","kbtopic-api-export-data-formats-product-data"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/6877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/comments?post=6877"}],"version-history":[{"count":27,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/6877\/revisions"}],"predecessor-version":[{"id":6912,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/6877\/revisions\/6912"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=6877"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=6877"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=6877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Format<\/strong><\/td> Name<\/strong><\/td> Description<\/strong><\/td><\/tr> SUPPLIER_AID<\/td> Supplier article number (SKU)<\/td> 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<\/td><\/tr> DESCRIPTION_SHORT<\/td> Short item description<\/td> Short description or name of the product, max. 80 characters (specified by BMEcat)
Important!<\/strong> Max. 40 characters can be transferred to SAP. The first 40 characters should therefore be unique<\/td><\/tr>DESCRIPTION_LONG<\/td> Item description<\/td> Detailed 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!<\/strong>
Formatting characters such as line breaks etc. are not permitted<\/td><\/tr>MANUFACTURER_NAME<\/td> Manufacturer<\/td> Name of the product’s manufacturer<\/td><\/tr> MANUFACTURER_AID<\/td> Manufacturer article number (SKU)<\/td> Article number provided by the manufacturer, max. 50 characters<\/td><\/tr> PRICE_QUANTITY<\/td> Price quantity<\/td> Integers! Quantity of the underlying order unit. Only the following values can be used here: 1, 10, 100, 1,000, 10,000 or 100,000<\/td><\/tr> ORDER_UNIT<\/td> Order unit<\/td> Unit 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<\/td><\/tr> NO_CU_PER_OU<\/td> Units contained<\/td> Number of units per order unit<\/td><\/tr> CONTENT_UNIT<\/td> Content unit of measurement<\/td> Unit 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<\/td><\/tr>LOWER_BOUND1<\/td> Lowest price scale quantity<\/td> Minimum purchase quantity for the standard price.
No decimals allowed, minimum >= minimum order quantity. When using scaled prices<\/strong>, PRICE_AMOUNT and LOWER_BOUND are given for each scale quantity<\/td><\/tr>PRICE_AMOUNT1<\/td> Standard price<\/td> Net price of the smallest scale quantity. No currency symbols!<\/td><\/tr> LOWER_BOUND2<\/td> Scale quantity 2<\/td> Minimum 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<\/td><\/tr>PRICE_AMOUNT2<\/td> Scaled price amount 2<\/td> Net price for scale quantity 2.
No currency symbol, further scales must be defined in pairs (quantity and price) in separate columns, max. 9 pairs<\/td><\/tr>CURRENCY<\/td> Currency<\/td> Currency abbreviation
Symbols (such as \u20ac or $) are not allowed<\/td><\/tr>QUANTITY_MIN<\/td> Minimum order quantity<\/td> Minimum order quantity for the specified order unit,
minimum: 1<\/td><\/tr>QUANTITY_INTERVAL<\/td> Quantity interval\/step<\/td> Increments in which the product can be ordered, starting from the minimum order quantity,
minimum: 1<\/td><\/tr>DELIVERY_TIME<\/td> Delivery time<\/td> Indication in working days, no decimal places allowed
Attention!<\/strong> This can be overwritten during the ITscope export, half days possible<\/td><\/tr>eCl@ss 5.1.4
eCl@ss 7.1
eCl@ss 8.1
eCl@ss 10.1<\/td>eCl@ss code<\/td> Classification of the product group according to the eCl@ss standard.
Project dependent!<\/strong> Either ECLASS, UNSPSC or both may be required<\/td><\/tr>UNSCPSC 20.0601<\/td> UNSPSC code<\/td> Classification of the product group according to the UNSPSC standard.
Project dependent!<\/strong><\/strong> Either ECLASS, UNSPSC or both may be required<\/td><\/tr>CATEGORY1
CATEGORY2
CATEGORY3
CATEGORY4<\/td>Category1
Category2
Category3
Category4<\/td>Classification system for product groups
Attention!<\/strong> 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<\/td><\/tr>MIME_INFO<\/td> Image file (normal)<\/td> 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<\/td><\/tr>DATASHEET<\/td> Datasheet file<\/td> Two 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<\/td><\/tr>KEYWORD<\/td> Keywords, synonyms, search terms<\/td> To allow better identification of the product. Separate terms with commas, max. 1,000 characters, max. 50 characters per term.
Attention!<\/strong><\/strong> This can be overwritten during the ITscope export<\/td><\/tr>TAX<\/td> VAT rate<\/td> Required format: 0.XX<\/td><\/tr> BUYER_AID<\/td> Buyer article number (SKU)<\/td> SAP material number, or item number of the buyer, max. 50 characters<\/td><\/tr> ERP_GROUP_BUYER<\/td> Buyer ERP group<\/td> Max. 10 characters<\/td><\/tr> FNAME1
FVALUE1<\/td>Feature name 1
Feature value 1<\/td>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<\/td><\/tr>FNAME2
FVALUE2<\/td>Feature name 2
Feature value 2<\/td>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<\/td><\/tr>EAN<\/td> EAN\/GTIN<\/td> European Article Number (GTIN\/EAN) 8,12,13 or 14 digits<\/td><\/tr> SPECIAL_TREATMENT_CLASS_TYPE1
SPECIAL_TREATMENT_CLASS1
<\/td>Hazardous goods class 1
Hazardous goods label 1<\/td>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!<\/strong> Products without hazardous substances do not require a label<\/td><\/tr>SPECIAL_TREATMENT_CLASS_TYPE2
SPECIAL_TREATMENT_CLASS2<\/td>Hazardous goods class 2
Hazardous goods label 2<\/td>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!<\/strong> Products without hazardous substances do not require a label<\/td><\/tr>INTRASTAT_CODE
INTRASTAT_ORIGIN_COUNTRY
INTRASTAT_NET_WEIGHT
INTRASTAT_GROSS_WEIGHT
INTRASTAT_WEIGHT_UNIT
INTRASTAT_TRANSACTION_TYPE
INTRASTAT_MEANS_OF_TRANSPORT<\/td>INTRASTAT code
ISO code – country of origin
Net weight
Gross weight
ISO code – weight unit
Transaction type
Means of transport<\/td>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<\/td><\/tr><\/tbody><\/table>Table with three example products<\/h2>\n\n\n\n
<\/li><\/ul>\n\n\n\nFormat<\/strong><\/td> Example 1<\/strong><\/td> Example 2<\/strong><\/td> Example 3<\/strong><\/td><\/tr> SUPPLIER_AID<\/td> 643827<\/td> 601082<\/td> 723842<\/td><\/tr> DESCRIPTION_SHORT<\/td> Eraser, for pencils and crayons<\/td> Envelope C6, with window<\/td> Letter tray 1027 DIN C4, colour: blue<\/td><\/tr> DESCRIPTION_LONG<\/td> Soft rubber eraser for pencils and crayons on all types of paper<\/td> Format: 162x114mm, envelopes with grey inner print<\/td> Coloured letter trays for documents up to A4 format; dimensions (W\/D\/H): 25.5\/34.8\/6.5 cm<\/td><\/tr> MANUFACTURER_NAME<\/td> Example Inc.<\/td> Example Inc.<\/td> Example Inc.<\/td><\/tr> MANUFACTURER_AID<\/td> P7734<\/td> P4642<\/td> P6374<\/td><\/tr> PRICE_QUANTITY<\/td> 1<\/td> 1<\/td> 1<\/td><\/tr> ORDER_UNIT<\/td> PCE<\/td> PA<\/td> PA<\/td><\/tr> NO_CU_PER_OU<\/td> <\/td> 1000<\/td> 3<\/td><\/tr> CONTENT_UNIT<\/td> <\/td> PCE<\/td> PCE<\/td><\/tr> LOWER_BOUND1<\/td> 1<\/td> 1<\/td> 1<\/td><\/tr> PRICE_AMOUNT1<\/td> 0.52<\/td> 18.55<\/td> 3.64<\/td><\/tr> LOWER_BOUND2<\/td> 20<\/td> 5<\/td> 10<\/td><\/tr> PRICE_AMOUNT2<\/td> 0.44<\/td> 17.6<\/td> 3.48<\/td><\/tr> CURRENCY<\/td> EUR<\/td> EUR<\/td> EUR<\/td><\/tr> QUANTITY_MIN<\/td> 1<\/td> 1<\/td> 1<\/td><\/tr> QUANTITY_INTERVAL<\/td> 1<\/td> 5<\/td> 1<\/td><\/tr> DELIVERY_TIME<\/td> 1<\/td> 1<\/td> 3<\/td><\/tr> eCl@ss 5.1.4
eCl@ss 7.1
eCl@ss 8.1
eCl@ss 10.1<\/td>24-24-22-01<\/td> 24-26-23-01<\/td> 24-29-11-01<\/td><\/tr> UNSCPSC 20.0601<\/td> 44121804<\/td> 44121504<\/td> 44111503<\/td><\/tr> CATEGORY1<\/td> Office supplies, office equipment, office technology <\/td> Office supplies, office equipment, office technology<\/td> Office supplies, office equipment, office technology<\/td><\/tr> CATEGORY2<\/td> Writing utensils, sharpeners, erasers and correction fluid<\/td> Paper, foil, shipping packaging (office)<\/td> Organising, archiving<\/td><\/tr> CATEGORY3<\/td> Erasers<\/td> Envelopes, mailing bags, packing paper (office)<\/td> Letter trays, sorting baskets, standing file boxes<\/td><\/tr> CATEGORY4<\/td> <\/td> Envelopes<\/td> Letter trays, sorting baskets<\/td><\/tr> MIME_INFO<\/td> Eraser.jpg<\/td> Envelope.jpg<\/td> https:\/\/www.supplier.com\/media\/lettertray.jpg<\/td><\/tr> DATASHEET<\/td> <\/td> Envelope.pdf<\/td> https:\/\/www.supplier.com\/media\/lettertray.pdf<\/td><\/tr> KEYWORD<\/td> All-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 eraser<\/td> Envelope, envelope bundle, envelope bundle (airmail), envelope bundle (bereavement letter), airmail envelope,
letter envelope, bereavement letter envelope<\/td>Filing tray, letter tray, letter box, mail tray, desk accessory (letter tray)<\/td><\/tr> TAX<\/td> 0.19<\/td> 0.07<\/td> 0.19<\/td><\/tr> BUYER_AID<\/td> 1234<\/td> 1234<\/td> 1234<\/td><\/tr> ERP_GROUP_BUYER<\/td> <\/td> <\/td> <\/td><\/tr> FNAME1
FVALUE1<\/td>Preferred item
Yes<\/td>Country of origin
DE<\/td>Colour
blue<\/td><\/tr>FNAME2
FVALUE2<\/td>Width
10 cm<\/td><\/td> Weight
5 kg<\/td><\/tr>EAN<\/td> <\/td> <\/td> <\/td><\/tr> SPECIAL_TREATMENT_CLASS_TYPE1
SPECIAL_TREATMENT_CLASS1
<\/td><\/td> Hazardous item
F<\/td>Dangerous goods regulation (GGVS)
33 12003 Petrol<\/td><\/tr>SPECIAL_TREATMENT_CLASS_TYPE2
SPECIAL_TREATMENT_CLASS2<\/td><\/td> <\/td> Hazardous substance
XN<\/td><\/tr>INTRASTAT_CODE
INTRASTAT_ORIGIN_COUNTRY
INTRASTAT_NET_WEIGHT
INTRASTAT_GROSS_WEIGHT
INTRASTAT_WEIGHT_UNIT
INTRASTAT_TRANSACTION_TYPE
INTRASTAT_MEANS_OF_TRANSPORT<\/td>38220000
DE
0.8
1
KGM
11
3<\/td>38220000
AT
75
100
GRM
14
5<\/td><\/td><\/tr><\/tbody><\/table>