Transfer products via file | Create OCI and cXML PunchOut Catalogues | PunchCommerce ![](//analytics.punchcommerce.de/matomo.php?idsite=1&rec=1) Transfer products via file ========================== You have the option of uploading your products to our system in several different file formats. We currently support the CSV, XLSX and XML formats. Please use the field or column names explained below in all formats. You can find a sample file containing product data in your customer account or via the links below: - **CSV:** - **Excel:** - **XML:** Field nameData typeDescriptionordernumber\*String (100)Product item numberbrandString (255)Manufacturerbrand\_ordernumber\*String (255)Manufacturer’s item numbercustomer\_ordernumberString (255)Customer’s item numbertitle\*String (255)Product namecategory\*String (255)Product categorydescription\*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\_pricesStringGraduated prices for this product (see below)purchase\_stepsIntegerProduct tiering (see below)min\_purchaseIntegerMinimum purchase quantity (see below)max\_purchaseIntegerMaximum purchase quantity (see below)currencyString(3)ISO 4217 currency codetax\_rate\*IntegerApplicable tax rate for this product (e.g. 7 or 19)purchase\_unitFloating-point numberSales unitreference\_unit1Floating-point numberReference quantity for base price calculationunit2String (255)Sales unit of measure (e.g. ml)unit\_name3String (255)Sales unit of measure (e.g. millilitres)packaging\_unit\*String (255)Sales unit (e.g. pieces)weightFloating-point numberWeight in kilograms, no further detailsshipping\_time\*IntegerDelivery time in daysclassification\_typeString (255)Classification system, e.g. UNSPSC or eClass (note the spelling)classificationString (255)Value in the classification system, e.g. 43232403 for ‘Enterprise application integration software’custom\_field1String (255)Any additional fieldcustom\_field2String (255)Any additional fieldcustom\_field3String (255)Any additional fieldcustom\_field4String (255)Any additional fieldcustom\_field5String (255)Any additional fieldcustom\_field6String (255)Any additional fieldcustom\_field7String (255)Any additional fieldcustom\_field8String (255)Any additional fieldcustom\_field9String (255)Any additional fieldcustom\_field10String (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 provided, the first value provided must be less than or equal to the value in the `min_purchase` field. ``` :;: ``` Example: 1:10.99;10:9.99;50:8.00 **Tiered pricing** The `purchase_steps` field is set to 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 when marking up items. A complete list of units can be found at 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 category can be specified as a path of categories. The individual category names must be separated by a "|". The path is interpreted from left to right as a nested structure. **Example:** ``` Home|Kitchen|Appliances ``` becomes - Home - Kitchen - 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!")