Changelog

You can now connect product inventories to one or more locations with a spreadsheet edit. Previously you could connect inventories to different locations with an in-app edit but using a spreadsheet can make it faster if you have a lot of unique combinations of products and locations.

To connect inventory just upload a spreadsheet with an identifier and the location's ID to the app and select 'Connect Inventory to Location' from the field drop down list:

You can also disconnect inventory locations with a spreadsheet, just use the 'Disconnect Inventory from Location' option instead.

Learn more about connecting product inventories to locations in Shopify.

When filtering for the products you want to edit there can be cases where you want to manually exclude one or two products from the search results. For example, you might want to edit all products in a collection except for two products that are a special case.

Previously you could add an aditional filter to remove these products but it could be time consuming if there wasn't any common, searchable, attribute between them.

Now you can remove products directly from the search results by clicking on a little icon on the right side:

This way you can quickly remove one or two products and move on to your edit.

Note that this icon will only appear if you already have a search in progress.

Previously, when you exported product data in CSV or Excel format the default file name would just be the name of the first column of the spreadsheet in lower case. For example, product_handle.csv. This naming convention could make it difficult to go back and find an downloaded export you were looking for.

We've updated the default file name for the exports so now they're in the format of:

Product Handles 2023-03-23_090807.csv

You can always override the file name when you generate an export but we hope this change in defaults will make it easier to find previous exports.

You can now delete an arbitrary set of products directly with a spreadsheet edit. To do so just upload a spreadsheet with two columns, one to identify the products or variants and the other containing the text 'delete'.

As with in-app edits to delete products, this action cannot be undone. In many cases is may be better to set the products to the 'Archived' state instead.

Learn more about bulk deleting products and variants in Shopify.

We've made two changes to the page where you configure spreadsheet edits. The first is the addition of a Clear All button to reset all column mappings at once. When you upload a spreadsheet the app will try to guess which columns you want to edit but if you only want to edit one column this will save you from having to de-select each column.

The second change is that we've removed the column showing the number of matching products. We did this to save space and remove the need for excessive scrolling. Now, a warning will show up if a product matches more than one product or if it doesn't match any products at all:

Learn more about editing Shopify products with a spreadsheet.

You can now export the 'Inventory Item ID' field to a CSV or Excel spreadsheet. When you're configuring your export, you'll find the field under the 'Variant Attributes' list.

In the Shopify API, the Inventory Item ID field tracks a one-to-one relationship between product variants and 'Inventory Items'. Inventory items store additional information about the variant and are also used for multi-location inventory.

You can now view and edit a product's Google Shopping fields directly on the product detail pages. From the product search page click on the product you're interested in. On the product's detail page, the 'Google Shopping' tab allows you to see and edit the Google Shopping fields:

While the app is primarily used for bulk editing some times you may need to quickly check or edit a product. We've created these product detail pages within the app so you won't have to wait for the Shopify admin to load in a new tab to view the products.

Learn more about bulk editing Google Shopping fields in Shopify.

We've added two options to in-app edits to make searching and replacing more powerful:

• You can now do a search and replace for individual elements within a metafield list of strings. This allows you to rename a single element in the metafield list regardless of its position.
• Searching and replacing text values now has the option to use a case-insensitive search. This makes it easier to standardize capitalization in your product titles or descriptions.

We've added the ability to save your product export configurations so you can retrieve them later. This way you won't need to reselect all the fields you want to export if you're switching between different export formats.

The export present will save your selection for all the fields you want to export as well as any delivery options to choose.

Learn more about saving product export configurations.

We've added a search filter to the Bulk Product Editor for duplicate barcodes. If you choose 'Has duplicate barcode' from the 'Filter' drop down you'll see a list of all products do not have a unique barcode.

This is similar to searching for duplicate SKUs and you can follow the same process to identify and fix duplicate barcodes.

If you're adding new variants to products you might find yourself in a situation where some variants of a product don't have a SKU set. You can now use the new "Product's first tag" placeholder to set these variants to have the same SKU as the other variants for a product.

When editing the SKU field just select "Product' first tag" from the "Add Placeholder" dropdown. This will set each variant's SKU to be the first non-blank SKU from you product.

When running a spreadsheet edit you can now use either the collection's title or the collection's handle when you are adding a removing a product from a collection. Previously we only supported collection titles. If the text in a cell matches on both a collection handle and title, priority will be given to the matching handle.

Learn more about bulk editing manual collections in Shopify.

You can now bulk edit Shopify rich text metafields in the app. These are metafield definitions with the type rich_text_field.

Shopify limits the HTML tags you can use in rich text descriptions. Basic formatting such as bold, italics and lists are available but you can't insert images or arbitrary HTML.

Learn more about bulk editing rich text metafields.

We've update the labels for managing a product's visibilty on the Online Store and Point of Sale channels. Before we had several different terms but in order to make them more consistent, internally and with Shopify, we've renamed them to the following:

• Visible on Online Store
• Visible on Point of Sale

Now, whether you're searching for products, editing the fields or exporting the data, these fields will have consistent labeling.

Lots of Shopify stores use tags to store different attributes for their products. For example, the tag "brand=Supply Depot" might indicate the original brand of the product. You can now use placeholders to extract the final portion of a tag and add it to another field. For example, you could set the vendor of the product to be whatever value comes after the "brand=" text.

To do so, select the Tag Suffix option from the placeholder dropdown and enter the fixed part of the tag you are looking for ('brand=' for example).

Learn more about using part of a tag as a placeholder.

We've made two updates to improve the experience of editing product reference list metafields. This metafield type contains a list of links to other products and is also used by the Shopify Search & Discovery app for the 'Related Products' field.

Previously you needed to enter the Shopify IDs of products you wanted to reference but now you can select them from a popup window.

We've also added an option to exclude the matching product from the list of products you're adding. If you select this option, the new product reference list won't include a reference to itself. You can use this to easily have a group of products all relating to each other, without any self-references.

In some cases product images would not be transfered from WooCommerce stores hosted on Wordpress.com. This was due to issues between the CDN used by Wordpress.com and Shopify's servers trying to download the images. We've made some improvements to the app which should allow Shopify to process the images correctly, even if they're hosted on Wordpress.com's CDN.

You can now tag orders based on the order note attribute. Depending on your use-case you can tag:

• Orders with no note
• Orders with a note
• Orders with a note that contains, or does not contain, certain words
• Orders with a note that matches, or does not match, an exact string of text

You can now cancel product exports in the Bulk Product Editor. To cancel an export go to History -> Export History in the left-hand menu and click on the export you want to cancel. Then, click the Cancel button at the top of the page.

While you don't need to cancel a product export if you've made a mistake configuring it, it may cause subsequent exports to run slightly faster. If you cancel and export and change your mind you can always recreate it by clicking on the Generate button at the top of the page.

Building off of yesterday's update, now you can add dynamic tags to an order for all SKUs that are in stock at one or more locations. When you're editing a rule click on the Add Dynamic Tag button and select 'Product SKUs (In Stock at Location)'. Then select the location(s) you want to include from the list below.

This will only match on products that have their inventory tracked by Shopify and have at least one unit of inventory at any of the selected locations.