Magento 2 ImportExport – Set All Product Infos to ‘Use Default Value’

With the default ImportExport CSV format you can set store specific values for single attributes if and only if you also import the default values.

Example:

sku, _store, name          , meta_title
xxx,       , "Default Name", "Default Title"
   , store2,               , "Store 2 Title"

Here the meta_title attribute will be saved with a specific value for store2, while the name attribute will be saved as "Use default" in store2. Also the default values will be overwritten for all given columns.

You could try inserting the data manually by exporting the data from your local database, and running a SQL command like this for each of the tables you need to import with the data from your local table.

INSERT INTO catalog_eav_attribute (attribute_id, frontend_input_renderer, is_global, is_visible, is_searchable, is_filterable, is_comparable, is_visible_on_front, is_html_allowed_on_front, is_used_for_price_rules, is_filterable_in_search, used_in_product_listing, used_for_sort_by, apply_to, is_visible_in_advanced_search, position, is_wysiwyg_enabled, is_used_for_promo_rules, is_required_in_admin_store, is_used_in_grid, is_visible_in_grid, is_filterable_in_grid, search_weight, additional_data) VALUES

There are obviously more than just one table that will require your attention, but this is the fastest solution that I found.