This video demonstrates how to bulk edit Shopify products using the Altera app and spreadsheets. It covers exporting product data, editing in Excel, and re-importing with safety tips like using the update command and keeping only necessary columns. Two demos show updating prices for a collection and removing specific tags from multiple products.
A short editorial from the VEONIB team on why this content matters.
The video provides a clear, safety-focused workflow for bulk editing Shopify products using Altera and spreadsheets, emphasizing the update command and minimal column selection.
Unlike many bulk edit tutorials, this video stresses data integrity and accidental overwrite prevention, which is crucial for maintaining SEO and product data consistency.
Shopify store owners and managers who need to efficiently update product prices, tags, or SEO should watch this video and adopt the export-edit-import method with Altera.
The process of updating multiple product details at once using a spreadsheet or app.
A Shopify app that enables exporting and importing product data for bulk edits.
A command in the import file that only modifies existing products, preventing duplicates.
A command that creates new products if no match is found, risking unwanted duplicates.
The original price shown alongside a sale price to indicate a discount.
A special column in Altera exports that allows adding, replacing, or deleting product tags.
Uploading a comma-separated values file to update product data in Shopify.
Downloading product data from Shopify into a spreadsheet for editing.
How do I bulk edit prices in Shopify?
Export products with Altera, edit the variant price and compare at price columns in Excel, set the command to update, and re-import.
What is the difference between update and merge in Shopify import?
Update only modifies existing products, while merge creates new products if no match is found, which can cause duplicates.
How can I remove a specific tag from multiple Shopify products?
Export products with the tags column, set the tags command to delete, enter the tag to remove, and re-import.
Why should I keep only necessary columns when bulk editing?
To speed up the import and prevent accidentally overwriting data that may have changed in Shopify.
Can I update multiple tags at once in Shopify?
Yes, you can include multiple tags in one cell separated by commas when using the tags command.
What happens if I use the merge command by mistake?
Merge can create new products if it can't find a match, leading to unwanted duplicates in your store.
How do I identify products for bulk update?
Use a unique identifier like SKU or product ID in your spreadsheet so the app knows which products to update.
Is there a way to preview bulk edits before applying?
Yes, Altera provides a live preview during import to verify changes before finalizing.
What app can I use to bulk edit Shopify products with a spreadsheet?
Altera is a Shopify app that allows exporting, editing, and importing product data via spreadsheets.
How do I put a collection of products on sale in Shopify?
Export the collection's products, update variant prices and compare at prices, set command to update, and re-import.