How can I bulk edit variant titles to remove extra colons?

Aleonor
Visitor
1 0 0

Hello, at the begging when I created the site I created variants and I added":" at the end of each variant. Now when you add the product in the cart it has double "::". i have 400 products on my shop, is there any way to remove the ":" at the end of the variant

Replies 5 (5)

WhiteWater_Web
Shopify Expert
457 17 42

Hi there, this could be done by running something against a product export of yours (using Excel, etc), by using an app (like Matrixify, Bulk Product Edit, etc), or via the Shopify API (a small app to do it).

 

Whatever you decide to do make sure to make a backup of your products before you do anything.

 

Let us know if you need a hand.

 

Cheers.

 

WhiteWater Web

A certified Shopify Partner and Expert, WhiteWater Web (WWW) is a premium digital solutions company specializing in advanced Shopify Dev, Usability/Design, and Online Strategy. WWW has been working with the Shopify platform since 2006.
info@whitewatersolutions.com

kensington
Shopify Partner
18 1 1

That's definitely not a desired result! But there's a pretty straightforward fix - you just need to edit the variant details in your Shopify admin. Go to Products > All products, and then click on the product that you want to edit. On the product details page, click on the "Variants" tab, and then click on the "Edit" button for the variant that you want to edit. From there, you can delete the extra ":" that was added to the variant name. Just be sure to click "Save" once you've made your changes. Does that make sense?

EasifyApps-Zoe
Shopify Partner
582 14 44

Hi @Aleonor,

I have a suggestion for you. To efficiently handle the removal of "::" from your variant names in a large inventory of 400 products, I recommend the following steps 😊:

  1. First, export all your products to a "CSV for Excel, Numbers, or other spreadsheet programs" file.

  2. Open the exported CSV file in Excel.

  3. Utilize the "Data > Text to Columns" feature to split the variant names containing "::" into 2 separate columns. This will effectively separate the text before and after "::".

  4. Once separated, you can simply delete the column containing "::", leaving you with the modified variant names.

  5. Save the file.

  6. Reimport this updated CSV file back into your Shopify store.

By following these steps, you can efficiently clean up your variant names without the need for any additional apps. This method should help you manage the task quickly and effectively.

EASIFY - MAKING SHOPIFY SIMPLE & SWEET!
Easify Product Options: Create custom product options 10X faster & easier!
Easify Product Attachments: Effortlessly add downloadable PDF files (or any other format) to Shopify pages!
Try for Free | 24/7 Live Chat Support
nd23123
Tourist
6 0 0

Hello, just wanted to ask if reimporting the updated csv file will duplicate the products, I want to replace multiple variant names.

Emily
Shopify Staff
1339 102 193

Hi, @nd23123.

 

Thank you for reaching out! 

 

Once you upload your CSV file you will see an option for the new CSV file to overwrite your currently one. 

Emily | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog