This tutorial is for developers.
In this snippet, we’ll show you how to add a link to the WooCommerce category and tag pages in the front end, that will appear for administrators, and it will open the WP Sheet Editor with a filter to show rows related to the current category or tag.
The link will appear below the category/tag description, and it’s a good way to provide a shortcut to your administrators to quickly edit the products when they’re viewing the shop catalog in the front end.
<?php
add_action( "woocommerce_archive_description", "add_edit_archive_link_for_admins", 10, 0 );
function add_edit_archive_link_for_admins()
{
if (
current_user_can("manage_options") &&
(is_product_category() || is_product_tag())
) {
$term_id = get_queried_object_id();
$taxonomy = get_queried_object()->taxonomy;
$term = get_term($term_id, $taxonomy);
$slug = $term->slug;
$spreadsheet_url = add_query_arg(
[
"wpse_custom_filters" => [
"apply_to" => [$taxonomy . "--" . $slug],
],
],
// Replace this URL with the URL of your WP Sheet Editor
"http://site.com/wp-admin/admin.php?page=vgse-bulk-edit-product"
);
echo '<a href="' . esc_url_raw($spreadsheet_url) . '" style="display:block; margin-top:15px;">Edit This Archive</a>';
}
}