A store administrator can import product-specific attributes in 2 different ways:

Using a products.csv file, you'll import products along with the product-specific attributes if they have them. Product-specific attribute value column has the format of [attribute_name](field:product).

See the example below:

Suppose you want to update a product with product-specific attributes skipping the rest of the product-related info (like memberships, productClass, taxClass, enabled, shippable, categories, inventoryTracking, etc.). In that case, you'll need to include only the sku, name, and [attribute_name](field:product) tables in your import file.

It's also possible to import product-specific attributes for products separately. Here, you'll need to use a product-attributes.csv file for the purpose.

See the example below:

The 'owner' field in a product-attributes.csv file defines whether an attribute is product specific or not. All attributes that have "YES" set for the 'owner' field are product-specific. The 'value' field defines the actual value of a product-specific attribute. It can vary depending on the 'name' (responsible for a text representation of the attribute). Each real value of a product-specific attribute should be defined in a separate row.

If you want to import product-specific attributes only, the import file's required fields will be productSKU, type, name, owner, and value.

Related pages: