Transfer products via file | PunchCommerce                       ![](//analytics.punchcommerce.de/matomo.php?idsite=1&rec=1)

  [Skip to content](#main-content)

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; may 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 calculating the base priceunit2String (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 specificationshipping\_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 format. If `min_purchase` is provided, the first value specified must be less than or equal to the value in the `min_purchase` field.

```
:;:
```

Example:

1:10.99;10:9.99;50:8.00

**Price Tiering**

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 path of categories can be specified as the category. The individual category names must be separated by a "|". The path is interpreted from left to right as a nested structure.

**Example:**

```
Home|Kitchen|Electrical appliances
```

becomes

- Home
    - Kitchen
        - Electrical appliances

 PunchCommerce® is a product of [ ![netzdirektion | Gesellschaft für digitale Wertarbeit mbH](https://www.punchcommerce.de/static/netzdirektion-logo.png) (opens in a new window) ](https://netzdirektion.de) ![DEKRA seal: quality management according to ISO 9001](https://www.punchcommerce.de/static/dekra-netzdirektion-iso-9001.png) **ISO 9001:2015**
certified quality management

 netzdirektion | Gesellschaft für digitale Wertarbeit mbH · © 2020 - 2026
