How can I bulk edit shoe sizes in my online store?

Hi, I need to edit 140 shoes in my Shopify store, i need to put sizes but I’m not capable to do. When I opened the csv file in Execel i didn’t understand anything, can someone help me? I need to put 12 sizes, same for all shoes

Hello @Alessionicita10 ,

Our Bulk Product Editor app allows you to update variants and any of the product fields in bulk with either an in-app edit, or a spreadsheet edit.

It’s a little easier to use than the main Shopify import/export utility, and it has the added benefits of being able to ‘undo’ edits. There is also a free version available that allows for 5 free edits every 30 days.

This help article explains how you can bulk edit variants in our app: https://support.ablestar.com/article/92-editing-individual-variants

If you have any questions about the app or it’s capabilities you can reach us directly at support@ablestar.com.

Certainly! Here’s a concise guide:

  1. Open CSV in Excel:
  • Open the CSV file in Excel or Google Sheets.
  1. Identify Columns:
  • Identify product-related columns like “Title.”
  1. Add Size Column:
  • Create a “Size” column.
  1. Enter Sizes:
  • Enter sizes for one product, then copy for others.
  1. Save Changes:
  • Save the CSV file.
  1. Upload to Shopify:
  • In Shopify admin, go to “Products” > “Import.”
  1. Map Columns:
  • Map the “Size” column.
  1. Complete Import:
  • Follow prompts to finish.
  1. Verify Changes:
  • Check product listings for added sizes.

Tips:

  • Backup: Keep a backup of the original CSV.
  • Formatting: Ensure correct CSV format.
  • Documentation: Consult Shopify’s documentation for guidance.