Products & Variants

Sprout Import supports importing data to Craft Commerce Products Types with Product Fields and Variant Fields. Craft Commerce Products follow the same syntax as any other Element with the addition of a variants key. All of the same enhanced functionality like the related and updateElement keys are available when importing Craft Commerce Products.

Products & Variants

Similar to the Matrix Field, when importing Variants using the variants key, you can add an arbitrary number of variants using the convention new1, new2, new3, etc.

[   {     "@model": "barrelstrength\\sproutbase\\app\\import\\importers\\elements\\Product",     "attributes": {       "typeId": 1,       "slug": "useful-product",       "postDate": {         "date": "5/14/2016",         "time": "9:45 AM"       },       "enabled": 1,       "taxCategoryId": 1,       "shippingCategoryId": 1,       "freeShipping": "",       "promotable": 1,       "orderLanguage": "en-US"     },     "variants": {       "new1": {         "sku": "ABCD-123",         "price": 16,         "hasUnlimitedStock": 1,         "minQty": "",         "maxQty": "",         "length": "",         "width": "",         "height": "",         "weight": ""       },       "new2": {         "sku": "ABCD-124",         "price": 18,         "hasUnlimitedStock": 1,         "minQty": "",         "maxQty": "",         "length": "",         "width": "",         "height": "",         "weight": ""       }     },     "content": {       "title": "Useful Product",       "fields": {         "body": "Product information"       }     }   } ] 

In this example we use the related key to find a match for an Asset and Category Relation field to the Product, and an Asset Relation field for the Variant.

[   {     "@model": "barrelstrength\\sproutbase\\app\\import\\importers\\elements\\Product",     "attributes": {       "typeId": 1,       "slug": "useful-product",       "postDate": {         "date": "5/14/2016",         "time": "9:45 AM"       },       "enabled": 1,       "taxCategoryId": 1,       "shippingCategoryId": 1,       "freeShipping": "",       "promotable": 1,       "orderLanguage": "en-US"     },     "variants": {       "new1": {         "sku": "ABCD-123",         "price": 16,         "hasUnlimitedStock": 1,         "minQty": "",         "maxQty": "",         "length": "",         "width": "",         "height": "",         "weight": "",         "related": {           "relationsFieldHandle": {             "@model": "importer\\for\\target\\Element",             "params": { ... }           }         }       }     },     "content": {       "title": "Useful Product",       "fields": {         "body": "Product information"       },       "related": {         "relationsFieldHandle": {           "@model": "importer\\for\\target\\Element",           "params": { ... }         }       }     }   } ]