Editing Products by Spreadsheet

If you have a lot of different products to edit, it may be faster to upload a spreadsheet with those edits. This article will show you how to format your data and upload it to Ablestar Bulk Product Editor.

Step 1: Uploading Your Spreadsheet

From the Shopify dashboard, click to open Ablestar Bulk Product Editor, click the Edit with a spreadsheet button or the sidebar 'Spreadsheet edit' navigation menu

1. Choose the Drag and drop button to upload your file and a file selection screen will appear
2. Select the file to upload and a processing frame will appear

Once the file has been processed, a 'Column mapping' view will appear so you can preview and modify your data.

Most often, the system might recognize the column you are trying to map, but you may have to map and identify the fields yourself.

Identify mapping names for each of the columns:

The 'Search by' dropdown determines how the variables will be identified. Depending if you are editing variant-level or product-level data will make a difference for your first-column identifier.

Learn the subtle difference between product-level and variant-level identifier fields.

Step 2: Advanced Settings

Clicking the 'Advanced options' link during the upload allows you a few more options:

• Skip Unchanged Rows: is helpful to increase upload speed and bypass any rows on your spreadsheet without modifications
• Filter by Vendor: could also increase speeds by filtering only by specific vendors on upload

Step 3: Processing Changes

Once your data is confirmed, click the Run edit button to start processing and the progress bar will appear.

At any time while data is processing, you can click the cancel option:

No need to standby while data is processing, you can always close the tab or window and logout of Shopify and return later, once processing is complete.

Step 4: Download History

Once your data is processed you have two options to view the history of downloads and/or undo edits if needed:

1. From the 'Processing' view, click the Download log button to see a full report. Clicking the Undo button will completely revert your changes if you realize you need to try again.

2. From the 'History' navigation menu, clicking on any row will take you to the same 'Processing' view and the same Undo and Download log options

Learn about about the Undo function for bulk edits in this article.

✅ Tips and Troubleshooting

• Download a Sample CSV template to get an idea of proper formatting
• Once you map any data to a column name that you prefer, the system will remember your choice for future uploads!
• You can close the window while uploads are processing and revisit History anytime later!
• Undoing bulk edits is easy and quick for any bulk upload

(03.23)