custom attributes in separate coloumn while export? - Magento 2.0.8

Question

short description what I done:

1. create product attribute set (Chennai)
2. create 21 new product attributes
3. assign to Chennai attribute set
4. set value to attribute while create product
5. export (System->Export->Continue) csv

problem is my new attributes comes under additional_attributes column but I am expecting each attribute occupy one column.

Anything need to mention while creating attribute for export related things?

can anyone pointing to me right direction?

Answer 1

I found a free Magento 2 extension from BSS Commerce which helped me work around this:

• https://bsscommerce.com/blog/how-to-export-custom-product-attributes-in-magento-2/
• https://bsscommerce.com/custom-product-attribute-export-for-magento-2.html

It provides some override code for the Model\Export\Product core class which breaks out the additional_attributes field into separate columns. In my testing it works on Import and Export.

You do have to configure an Admin setting for the module to tell it which fields to break out into their own columns, but it was easy to set up.

This module saved me some time duplicating their efforts, which was nice, and now the client can provide a normal CSV with attributes in columns, without me having to transform it with a script :)

Answer 2

Solution :

For this Need to do some changes in vendor\magento\module-catalog-import-export\Model\Export\Product.php file or override same model file in your custom module .

In vendor\magento\module-catalog-import-export\Model\Export\Product.php file add custom_attributes code those you want in separate cell ( not in additional_attributes cell) in $_exportMainAttrCodes global array variable line no. 263.

For example :

if suppose your export csv file contained

"collection_year=2014,lining_color=Light,material=Cotton|Wool|Polyester,season=Winter" value under additional_attributes header field for particular product. so add collection_year, hanger, lining_color & material keys in this $_exportMainAttrCodes array variable like:

protected $_exportMainAttrCodes = [
    self::COL_SKU, 
    'name',
    'description',
    'short_description',
    'weight',
    'collection_year',
    'lining_color',
   'material'
   .......SO on

Answer 3

All custom attributes get appeared under "additional_attributes" header in the export separated by a comma (,). I am using Magento 2.0.7.

To make these attributes occupy a separate cell, we can add more columns to the CSV.

Answer 4

This formula works in Excel, assuming no values have commas.

=IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)))-1, LEN(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1))))), "")

Just replace H5 and "material" with the appropriate cell and key.