Skip to main content

Product Export Formats

The following section describes the product export formats available under the Print menu in the Product resource.

Excel Format​

The properties used for the Excel format are described below. Each product is comprised of up two three row types product, variant and image. The file does not have headers as each type has a different format.

Product Properties​

Each product row is made up of 14 fields. The table below indentifies the property in each field by column number.

ColExample DataDescription
1"product"Indicates the row record type
2"5FAC51..."The internal system product id
3"ACC002"The product code as uploaded
4"MINI CLASP PURSE BAG"The product title
5""???
6"ACC BAGS"The product category
7"AW20"The season
8"CHINA"The country of origin
9""The product composition
10""The product care instructions
11""The product comodity code
12"LA Fashion"The brand name as imported
13"New"The product status
14"2020-09-14T15:45:38"The date/time the product was uploaded

Variant Properties​

Each variant row is made up of 9 fields. The table below indentifies the property in each field by column number.

ColExample DataDescription
1"variant"Indicates the row record type
2"9F9D36..."The internal system variant id
3"ACC002003__A"The variant code
4"5052011221429"The variant barcode
5"Blue"The variant colour
6"ONE"The variant size
7"25.00"The variant rrp
8"False"The vatable flag true or false
9"1"The variant sequence within the product

Image Properties​

Each image row is made up of 7 fields. The table below indentifies the property in each field by column number.

ColExample DataDescription
1"image"Indicates the row record type
2"9F9D36..."The internal system image id
3""The image code
4""The image code type
5"https://imageurl/16164_01.jpg"The image url
6""The image note
7"1"The image sequence

JSON Format​

The JSON export outputs all selected products in a single file. An example JSON product file is shown below with single product:

{
    "products": [
        {
            "id": "6DACBC957FAA874BB2E5510218292AE5",
            "code": "16164",
            "title": "Ana Dress",
            "description": "Embrace looks from decades past with this pretty mini dress, featuring a striking retro floral print. Freeing relaxed fit with a graceful silhouette. Stylish high neckline. Gathered cuffs.",
            "category": "Dresses",
            "season": "SS20",
            "origin": "China",
            "composition": "58% cotton, 32% polyamide and 10% wool",
            "careInstructions": "",
            "commodityCode": "",
            "productBrand": "LaFashion",
            "status": "",
            "createdDate": "",
            "variants": [
                {
                    "id": "1FCD54357981C94D93158162FFF3D1BA",
                    "code": "16164036   A",
                    "barcode": "5060409818847",
                    "colour": "Teal",
                    "size": "8",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 1,
                },
                {
                    "id": "C884252CC285E445BA38E36A043028A8",
                    "code": "16164036   B",
                    "barcode": "5060409818854",
                    "colour": "Teal",
                    "size": "10",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 2,
                },
                {
                    "id": "BD8538FA1783BD4C99B780D58EA1EBE2",
                    "code": "16164036   C",
                    "barcode": "5060409818861",
                    "colour": "Teal",
                    "size": "12",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 3,
                },
                {
                    "id": "3574B7E2F6B72A419211E2630407E23B",
                    "code": "16164036   D",
                    "barcode": "5060409818878",
                    "colour": "Teal",
                    "size": "14",
                    "rrp": 033,
                    "vatable": false,
                    "sequence": 4,
                },
                {
                    "id": "B9581F5DF64A2D4B8C73BE7821B50A10",
                    "code": "16164038   A",
                    "barcode": "5060409818892",
                    "colour": "Midnight",
                    "size": "8",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 1,
                },
                {
                    "id": "F3BE2F8E8FCA6641B40891C4C5E95E9D",
                    "code": "16164038   B",
                    "barcode": "5060409818908",
                    "colour": "Midnight",
                    "size": "10",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 2,
                },
                {
                    "id": "CE10E4BBEC53AA40A947F85510156890",
                    "code": "16164038   C",
                    "barcode": "5060409818915",
                    "colour": "Midnight",
                    "size": "12",
                    "rrp": 33,
                    "vatable": false,
                    "sequence": 3,
                },
                {
                    "id": "897C71B08CED0A44A3080851D7F43D75",
                    "code": "16164038   D",
                    "barcode": "5060409818922",
                    "colour": "Midnight",
                    "size": "14",
                    "rrp": 033,
                    "vatable": false,
                    "sequence": 4,
                }
            ],
            "images": [
                {
                    "id": "204A7A60B69A584C91E6069E70AD4E99",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164_01.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "0E85F440AF7B73498AFB0D5D3CF2863B",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164_02.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "A808BC34452B3041BC7BEADA39C1E020",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164038/16164038_01.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "2F8F844AD7D4C94082D803A7E318BAE9",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164038/16164038_02.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "EC7C5EE5590F9F499E9E8CCD74259D64",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164038/16164038_03.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "657F4C36F477264CAEE5E5352EE16980",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164038/16164038_04.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "5E575A22F3A00B40AFED75FBF6EF66EA",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164036/16164036_01.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "EC60FA5BB29ED840B586A15FA576DFC3",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164036/16164036_02.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "6CA7801BD9A4544AB6B946692A410B24",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164036/16164036_03.jpg",
                    "note": "",
                    "sequence": 0
                },
                {
                    "id": "2696C937BC12D54B844B332B34363869",
                    "code": "",
                    "type": "",
                    "url": "https://demo.ourb2b.co.uk/images/42AF7F4A7922D0418A2F3D1E2F3F429F/16164/16164036/16164036_04.jpg",
                    "note": "",
                    "sequence": 0
                }
            ]
        }
    ]
}