Transfer products by file | Create OCI and cXML PunchOut Catalogues | PunchCommerce ![](//analytics.punchcommerce.de/matomo.php?idsite=1&rec=1) Transfer products by file ========================= You have the option of transferring your products to our system in several different file formats. We currently support the CSV, XLSX and XML formats. Please use the field and column names explained below in all formats. You will find a sample file with product data for each of your customers or under the following links: - **CSV:** - Excel:\*\* - **XML:** field namedata typedescriptionordernumber\*character string (100)article number of the productbrandcharacter string (255)manufacturerbrand\_ordernumber\*character string (255)manufacturer article numbercustomer\_ordernumbercharacter string (255)customer article numbertitle\*character string (255)name of the productcategory\*Character string (255)Category of the productdescription\*textShort description of the product as unformatted textdescription\_longTextLong description of the product, can be formatted using HTMLimage\_urlString (255)HTTPS address of the image to be displayed for this productprice\*Floating point numberNet price of the productgraduated\_pricescharacter stringgraduated prices for this product (see below)purchase\_stepsIntegerGraduated price of the product (see below)min\_purchaseIntegerMinimum purchase quantity (see below)max\_purchaseIntegerMaximum purchase quantity (see below)currencycharacter string(3)ISO4217 currency abbreviationtax\_rate\*IntegerValid tax rate for this product (e.g. 7 or 19)purchase\_unitfloating point numbersales quantityreference\_unit1Floating point numberReference quantity for base price calculationunit2character string (255)sales unit (e.g. ml)unit\_name3character string (255)sales unit (e.g. millilitre)packaging\_unit\*character string (255)sales unit (e.g. piece)weightfloating point numberweight in kilograms without further specificationshipping\_time\*integerdelivery time in daysclassification\_typecharacter string (255)classification system e.g. UNSPSC or eClass (note spelling)classificationcharacter string (255)value in classification system e.g. 43232403 for "Enterprise application integration software"custom\_field1Character string (255)Any additional fieldcustom\_field2Character string (255)Any additional fieldcustom\_field3Character string (255)Any additional fieldcustom\_field4Character string (255)Any additional fieldcustom\_field5Character string (255)Any additional fieldcustom\_field6Character string (255)Any additional fieldcustom\_field7Character string (255)Any additional fieldcustom\_field8Character string (255)Any additional fieldcustom\_field9Character string (255)Any additional fieldcustom\_field10Character string (255)Any additional fieldactive\*Boolean value (0/1)Display of the product in the catalogue\* This field is mandatory. 1 This field is required if the purchase\_unit field has been specified. 2 This field is required if the reference\_unit field has been specified. 3 This field is required if the unit field has been specified. Graduated prices ---------------- Graduated prices must be specified in the graduated\_prices field according to the following scheme. If min\_purchase is passed, the first value passed must be less than or equal to the min\_purchase field. ``` :;: Example: 1:10,99;10:9,99;50:8,00 ``` **Staggering** The purchase\_steps field is pre-assigned the value 1 by default. The value of the min\_purchase field must be equal to purchase\_steps or a multiple of purchase\_steps. The value of the max\_purchase field must be greater than min\_purchase and a multiple of purchase\_steps. Units of measure ---------------- We recommend using UN/CEFACT units for labelling items. You can call up a complete list of units under the following link: [https://unece.org/fileadmin/DAM/cefact/recommendations/rec20/rec20\_rev3\_Annex3e.pdf](https://unece.org/fileadmin/DAM/cefact/recommendations/rec20/rec20_rev3_Annex3e.pdf) Categories ---------- A path of categories can be specified as a category. The individual category names must be separated from each other by a "|". The path is interpreted as nesting from left to right. **Example:** ``` Living|Kitchen|Electrical appliances ``` becomes - Living - Kitchen - Electrical appliances [ PunchCommerce® ist ein Produkt der ![Netzdirektion GmbH](https://www.punchcommerce.de/static/netzdirektion-logo.png "PunchCommerce® ist ein Produkt der netzdirektion | Gesellschaft für digitale Wertarbeit mbH") ](https://netzdirektion.de) [Give feedback now - your opinion helps us to become even better!](https://easy-feedback.de/umfrage/1883200/5FuM95 "Your opinion helps us to become even better!")