How it works

Follow these 3 simple steps to update your product prices from CSV files on your FTP server

ftp icon

Fetch CSV File
App connector: FTP • Time to complete: 2 minutes
Why this matters: This trigger monitors your FTP server for CSV files containing updated product pricing data and kicks off the entire workflow when new files are detected.

You'll configure the file path on your FTP server where MESA should look for price update files. Enter the exact filename or use wildcards to match multiple files (like "product-prices-*.csv"). The CSV must include columns for Product ID, Variant ID, and Variant Price - these are required for the workflow to function. MESA checks your FTP server hourly by default and processes any matching CSV files it finds.

Loop
App connector: Loop • Time to complete: 0 minutes (Auto-configured)
Why this matters: This step processes each row in your CSV file individually, ensuring every product price gets updated even if your file contains hundreds of products.

The loop automatically iterates through each row of data from your CSV file. It takes the Product ID, Variant ID, and Variant Price from each row and makes them available for the next step. Without this loop, only the first row of your CSV would be processed, leaving the rest of your price updates incomplete.

Shopify logo icon

Update Product Variant
App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This action applies the new price from your CSV to the corresponding product variant in your Shopify store, completing the price update process.

For each row processed by the loop, this step finds the specific product variant in Shopify using the Variant ID from your CSV and updates its price with the new value. The step handles the Shopify API connection and ensures each price change is properly saved to your store. If a Variant ID doesn't exist in your store, that particular update will be skipped while others continue processing.

Make it your own

Customize this workflow even further:

Add conditional price rules
Set up filters to only update prices that meet certain criteria, like increasing prices by more than 10% or updating specific product categories.
Include inventory updates
Extend the workflow to also update stock levels by adding inventory quantity columns to your CSV and connecting to Shopify's inventory endpoints.
Send confirmation notifications
Add email or Slack notifications after each batch of price updates completes, including a summary of how many products were successfully updated.
Archive processed files
Move completed CSV files to a "processed" folder on your FTP server to keep your file structure organized and prevent duplicate processing.

Frequently asked questions

What happens if my CSV has the wrong column names?
The workflow requires exact column names: "Product ID", "Variant ID", and "Variant Price". If your CSV uses different headers like "SKU" or "Price", the workflow won't be able to map the data correctly and updates will fail. Check your CSV headers before uploading.
Can I update prices for products that don't exist in my store yet?
No, the workflow only updates existing product variants. If a Variant ID in your CSV doesn't match any variant in your Shopify store, that row will be skipped. Make sure all variants exist in Shopify before including them in your price update file.
Will partial CSV files cause problems if my FTP upload is interrupted?
Yes, if MESA processes an incomplete CSV file, it will only update the products it can read from the partial file. To avoid this, consider uploading your CSV with a temporary filename first, then renaming it to the target filename once the upload is complete.
What is a template?
MESA templates are fully pre-configured workflows built and vetted by Shopify Experts. Unlike competitor templates that provide basic scaffolds requiring extensive setup, MESA templates come with all data variables properly mapped, required fields configured, and steps ready to activate. You can turn them on immediately and start automating.
Can I customize a template?
Absolutely! While our templates work out-of-the-box, every step can be personalized to match your exact business requirements. Add conditional logic, integrate additional apps, or build more sophisticated workflows. MESA's templates provide a solid foundation that you can expand as needed.
Are templates free?
Yes! Our entire library of expert-built, production-ready templates is free to use. Unlike platforms that charge for premium templates or provide only basic scaffolds, MESA gives you access to hundreds of fully-configured, vetted workflows at no additional cost.

Related templates you'll love

Recommended workflows that pair well with this template

Ready to update your product prices from CSV files on your FTP server?

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Start with this template — It's free
7-day free trial • 4 min setup • Cancel anytime