I have requirement to import products in bulk from CSV file which have multiple custom attributes of different type (Multiple Select, Dropdown, Text, etc.). Standard Import/Export option for Magento gets complicated for custom attributes as it groups all custom attribute in one column "additional_attributes". To simplify this I have two requirements.
Export and Import product based on Attribute Set. What I am looking for is to export all products within Attribute Set so that each attributes associated with Attribute Set including custom attributes show up as a separate column. For import, I want to upload products which have each custom attribute as separate column.
I am looking for some way to get list of values for attributes which are of Multiple Select, Dropdown and Yes/No types so basically, I can verify the values before I upload data for such attributes.
I tried to search for any extension which can help simplify this but couldn't find one which meets the need. Any thoughts or suggestion would be great help.