{"id":12504,"date":"2024-12-13T20:09:09","date_gmt":"2024-12-13T20:09:09","guid":{"rendered":"https:\/\/www.getmesa.com/blog\/?p=12504"},"modified":"2025-12-22T23:20:44","modified_gmt":"2025-12-22T23:20:44","slug":"update-shopify-product-prices-csv-ftp","status":"publish","type":"post","link":"https:\/\/www.getmesa.com/blog\/update-shopify-product-prices-csv-ftp\/","title":{"rendered":"How to Update Shopify Product Prices from a CSV File on an FTP Server"},"content":{"rendered":"\n<p>Managing product prices and data in Shopify becomes more complex as your inventory grows. Manual updates are time-consuming, error-prone, and can disrupt operations\u2014especially when updating Shopify prices using a CSV file on an FTP server.<\/p>\n\n\n\n<p>Automated workflows with FTP file exports streamline the process, reducing manual effort and improving accuracy. By exporting product CSV files directly to an FTP server, you can keep your data organized and updates more efficient across systems.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-cyan-bluish-gray-color has-alpha-channel-opacity has-cyan-bluish-gray-background-color has-background is-style-dots\"\/>\n\n\n\n<p><br><strong>TL;DR: Skip the step-by-step tutorial.\u00a0<\/strong>Use this template to update prices from a CSV file with just a few clicks.<\/p>\n\n\n<div class=\"mesa-template-backend frontend-hidden\">\n    <p><strong>MESA Template ID<\/strong><\/p>\n    <p>update-shopify-product-price-from-csv-ftp<\/p>\n<\/div>\n\n<div class=\"mesa-template\" data-template=\"update-shopify-product-price-from-csv-ftp\"><\/div>\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\t\t<style>.mesa-template-backend {\n    background: rgba(139, 139, 150, 0.1);\n    padding: 22px;\n}\n\n.mesa-template-backend h5,\n.mesa-template-backend p {\n    margin: 0 0 5px;\n}\n\n.mesa-template-backend p {\n    font-size: 16px;\n}\n\n.mesa-template-backend p:last-child {\n    display: inline-block;\n    background: #fff;\n    padding: 5px 10px;\n}\n\n.mesa-template-backend p strong {\n    font-size: 12px;\n}<\/style>\n\t\t\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">In this article:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.getmesa.com/blog\/update-shopify-product-prices-csv-ftp\/#Step-by-step-guide-Shopify-CSV-price-updates\" >Step-by-step guide: Shopify CSV price updates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.getmesa.com/blog\/update-shopify-product-prices-csv-ftp\/#Popular-uses-for-FTP-and-CSV-files-to-update-product-prices-in-Shopify\" >Popular uses for FTP and CSV files to update product prices in Shopify<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.getmesa.com/blog\/update-shopify-product-prices-csv-ftp\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-step-by-step-guide-shopify-csv-price-updates\"><span class=\"ez-toc-section\" id=\"Step-by-step-guide-Shopify-CSV-price-updates\"><\/span>Step-by-step guide: Shopify CSV price updates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"schema-how-to wp-block-yoast-how-to-block\"><p class=\"schema-how-to-total-time\"><span class=\"schema-how-to-duration-time-text\">Time needed:&nbsp;<\/span>5 minutes<\/p><p class=\"schema-how-to-description\">This workflow connects to your FTP server, retrieves the CSV file containing price updates, and processes the data. It then matches the updates to the correct products in Shopify and applies the new prices automatically. First, make sure you have access to the FTP server where your price update CSV file is stored.<br><br>To format your CSV, include columns for Product ID and Variant ID, which aren\u2019t part of Shopify\u2019s default export. Start by exporting a CSV from your Shopify admin as a base template. Then, manually add columns for Product ID and Variant ID, pulling these values directly from your Shopify admin.<br><br>To find these IDs, go to your Shopify admin, open a product, and check the URL. The Product ID and Variant ID will be visible in the URL\u2014copy these values into your <a href=\"https:\/\/admin.shopify.com\/store\/my-shopify-id\/products\/000-product-id-000\/variants\/000-variant-id-000\" target=\"_blank\" rel=\"noreferrer noopener\">sample CSV file<\/a>.<br><\/p> <ol class=\"schema-how-to-steps\"><li class=\"schema-how-to-step\" id=\"how-to-step-1733947402061\"><strong class=\"schema-how-to-step-name\">Fetch the CSV file from the FTP server\u00a0<\/strong> <p class=\"schema-how-to-step-text\">Kick off the workflow by adding the <a href=\"https:\/\/www.getmesa.com\/apps\/shopify\/integrate\/ftp\">built-in FTP tool<\/a> and choosing the Fetch CSV File trigger. Enter the file name and path for the CSV file, then validate the connection by clicking the<strong> \u201c<\/strong>Check for CSV\u201d button.<img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"705\" class=\"wp-image-12506\" alt=\"Fetch the CSV File from the FTP Server \" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/trigger-fetch-csv-file-a.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/trigger-fetch-csv-file-a.png 670w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/trigger-fetch-csv-file-a-285x300.png 285w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1733947615134\"><strong class=\"schema-how-to-step-name\">Loop over the file contents\u00a0<\/strong> <p class=\"schema-how-to-step-text\">Add the <a href=\"https:\/\/www.getmesa.com\/apps\/shopify\/integrate\/loop\">built-in Loop step<\/a> to iterate over the rows in the CSV file. Enter {{ftp}} in the \u201cValues to loop over\u201d field to process each row.<img loading=\"lazy\" decoding=\"async\" width=\"728\" height=\"444\" class=\"wp-image-12507\" alt=\"Loop over the CSV file contents \" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-loop-csv.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/action-loop-csv.png 728w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/action-loop-csv-300x183.png 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1733947733594\"><strong class=\"schema-how-to-step-name\">Update Product Variant based on the CSV file data\u00a0<\/strong> <p class=\"schema-how-to-step-text\">While still in the Loop step, add Shopify and select the \u201cUpdate Product Variant\u201d action.<img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"402\" class=\"wp-image-12508\" alt=\"Update product variant based on the CSV file data \" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-shopify-update-product-variant.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/action-shopify-update-product-variant.png 628w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/action-shopify-update-product-variant-300x192.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1733947835496\"><strong class=\"schema-how-to-step-name\">Assign data variables to configure the data mapping<\/strong> <p class=\"schema-how-to-step-text\">To set up the Product ID and Variant ID fields, select Custom value and use the Variable Selector to choose the correct ID values. Under &#8216;More options,&#8217; find the Price field and link it to the Variant Price variable.<img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"658\" class=\"wp-image-12509\" alt=\"Update product variant based on the CSV file data \" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-product-variant.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/end-shopify-product-variant.png 628w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/end-shopify-product-variant-286x300.png 286w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1733948766730\"><strong class=\"schema-how-to-step-name\">Test, then turn \u201cOn\u201d<\/strong> <p class=\"schema-how-to-step-text\">Give your workflow a test run to confirm it\u2019s ready, then activate it to respond automatically to trigger events.<img loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"907\" class=\"wp-image-12515\" alt=\"Test and turn on \" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-inventory-updates-csv.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/end-shopify-inventory-updates-csv.png 726w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/end-shopify-inventory-updates-csv-240x300.png 240w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/p> <\/li><\/ol><\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-cyan-bluish-gray-color has-alpha-channel-opacity has-cyan-bluish-gray-background-color has-background is-style-dots\"\/>\n\n\n\n<p><br><strong>Save yourself the setup. <\/strong>Use this template instead:<\/p>\n\n\n<div class=\"mesa-template-backend frontend-hidden\">\n    <p><strong>MESA Template ID<\/strong><\/p>\n    <p>update-shopify-product-price-from-csv-ftp<\/p>\n<\/div>\n\n<div class=\"mesa-template\" data-template=\"update-shopify-product-price-from-csv-ftp\"><\/div>\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-popular-uses-for-ftp-and-csv-files-to-update-product-prices-in-shopify\"><span class=\"ez-toc-section\" id=\"Popular-uses-for-FTP-and-CSV-files-to-update-product-prices-in-Shopify\"><\/span>Popular uses for FTP and CSV files to update product prices in Shopify<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Updating prices in Shopify can be time-consuming, but FTP and CSV workflows simplify the task. You can save time, reduce errors, and maintain consistent pricing across your store by automating updates from ERP systems, suppliers, or promotional files. Here are some popular use cases:<\/p>\n\n\n\n<p><strong>Automated Price Updates from ERP Systems<\/strong><strong><br><\/strong>ERP systems frequently generate daily CSV files with updated pricing data for inventory and orders. Stored on an FTP server, these files can be fetched automatically, ensuring consistent and up-to-date pricing in Shopify.<\/p>\n\n\n\n<p><strong>Wholesale Price Adjustments Based on Supplier Costs<\/strong><strong><br><\/strong>Suppliers often send daily or weekly CSV files with wholesale price updates, allowing merchants to adjust prices based on cost changes. By linking these files to Shopify through an automated workflow, price updates happen seamlessly, eliminating the need for manual input and reducing the chance of mistakes.<\/p>\n\n\n\n<p><strong>Dynamic Pricing for Seasonal Promotions<\/strong><strong><br><\/strong>Seasonal promotions, such as Black Friday or holiday sales, can also benefit from automation. You can create CSV files with discounted prices, upload them to an FTP server, and let a workflow handle the bulk price updates in Shopify, making it easy to manage sales without manually editing each product.<\/p>\n\n\n\n<p><strong>Bulk Price Adjustments for Regional Pricing Differences<br><\/strong>FTP and CSV workflows are a great fit for merchants with region-specific pricing strategies. Store region-specific prices in a CSV and auto-update Shopify pricing by segment\u2014no more manual adjustments needed.<\/p>\n\n\n\n<p><strong>Regular Price Syncing for High-Volume Product Catalogs<\/strong><strong><br><\/strong>Large product catalogs can also pose challenges for maintaining accurate pricing. Merchants with thousands of products often manage their main catalog in a PIM system. By exporting updated prices to an FTP-based CSV file, a workflow can sync these updates with Shopify, keeping the store\u2019s catalog accurate and up-to-date with minimal effort.<\/p>\n\n\n\n<aside class=\"section-single-related\" aria-labelledby=\"related-heading-7211\">\n\t<p id=\"related-heading-7211\">\n\t\tRelated article:\n\t<\/p>\n\n\t<article class=\"card-aside\">\n\t\t<a href=\"https:\/\/www.getmesa.com/blog\/how-to-connect-ftp-inventory-feed-to-update-shopify-products\/\" class=\"card-aside__link\">\n\t\t\t<figure class=\"card__image\">\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-1024x576.jpg\" class=\"attachment-large size-large wp-post-image\" alt=\"tutorial ftp to shopify inventory\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-1024x576.jpg 1024w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-300x169.jpg 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-768x432.jpg 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-553x311.jpg 553w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-356x200.jpg 356w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-764x430.jpg 764w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify-284x160.jpg 284w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial-ftp-inventory-feed-shopify.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t<\/figure><!-- \/.card__image -->\n\n\t\t\t<p class=\"card__title\">\n\t\t\t\t<strong>How To Connect FTP Inventory Feed To Update Shopify Products<\/strong>\n\t\t\t<\/p><!-- \/.card__title -->\n\n\t\t\t<span class=\"btn btn--outline card__btn card__btn--alt\" aria-hidden=\"true\">\n\t\t\t\tRead article\t\t\t<\/span>\n\t\t<\/a>\n\t<\/article>\n<\/aside>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>With the right tools, updating Shopify product prices becomes simple and efficient. Using FTP and CSV workflows allows you to automate updates, minimize errors, and save time. Whether you\u2019re managing seasonal promotions, supplier cost changes, or a large catalog, automation ensures your store stays accurate without the hassle of manual updates.<\/p>\n\n\n\n<p>Workflows that fetch and process CSV files make handling price adjustments seamless and accurate. With consistent, automated updates, you\u2019ll spend less time on tedious tasks and more on growing your business.<\/p>\n\n\n\n<div class=\"card-next-steps\">\n\t<div class=\"card__content\">\n\t\t<h4>What to do next&#8230;<\/h4>\n<p>The fastest way to see automation working in your store is to start with a single workflow.<\/p>\n<ol>\n<li><a href=\"https:\/\/www.getmesa.com\/pricing\"><strong>Try MESA free<\/strong><\/a> \u2014 start a 7-day free trial and get your first workflow running.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/templates\"><strong>Browse the template library<\/strong><\/a> \u2014 pre-built workflows for the most common Shopify automation tasks.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/yedric\"><strong>Talk to Yedric<\/strong><\/a> \u2014 describe what you want to automate, and let our AI assistant build it for you.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/support\"><strong>Get free workflow setup<\/strong><\/a> \u2014 MESA&#8217;s team will build your first workflow at no cost.<\/li>\n<\/ol>\n\t<\/div><!-- \/.card__content -->\n\n\t\n<div class=\"socials card__socials\">\n\t<ul>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/twitter.com\/getmesa\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/twitter-icon.svg\" class=\"attachment-small size-small\" alt=\"icon: twitter\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/www.youtube.com\/@getmesa\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/youtube-icon.svg\" class=\"attachment-small size-small\" alt=\"icon: youtube\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/company\/9754608\/\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/linkedin-icon.svg\" class=\"attachment-small size-small\" alt=\"linkedin icon\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n<\/div><!-- \/.socials -->\n<\/div><!-- \/.card-next-steps -->\n","protected":false},"excerpt":{"rendered":"<p>Managing product prices and data in Shopify becomes more complex as your inventory grows. Manual updates are time-consuming, error-prone, and&#8230;<\/p>\n","protected":false},"author":1,"featured_media":12505,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[245],"class_list":["post-12504","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-workflow-tutorials","tag-ftp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.8 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Shopify: Update Product Prices with CSV Files via FTP<\/title>\n<meta name=\"description\" content=\"Update Shopify product prices using CSV files from an FTP server. Simplify price adjustments with clear steps for efficient store management.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Update Shopify Product Prices from a CSV File on an FTP Server\" \/>\n<meta property=\"og:description\" content=\"Managing product prices and data in Shopify becomes more complex as your inventory grows. Manual updates are time-consuming, error-prone, and can disrupt\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/\" \/>\n<meta property=\"og:site_name\" content=\"MESA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/web.facebook.com\/mesabyshoppad\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-13T20:09:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-22T23:20:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/tutorial_csv-shopify.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ryan ODonnell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@getmesa\" \/>\n<meta name=\"twitter:site\" content=\"@getmesa\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ryan ODonnell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/\"},\"author\":{\"name\":\"Ryan ODonnell\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/person\\\/5ed8ee9c6f19090c4d5acb4f45efacb4\"},\"headline\":\"How to Update Shopify Product Prices from a CSV File on an FTP Server\",\"datePublished\":\"2024-12-13T20:09:09+00:00\",\"dateModified\":\"2025-12-22T23:20:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/\"},\"wordCount\":827,\"publisher\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/tutorial_csv-shopify.png\",\"keywords\":[\"ftp\"],\"articleSection\":[\"Workflow Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/\",\"name\":\"Shopify: Update Product Prices with CSV Files via FTP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/tutorial_csv-shopify.png\",\"datePublished\":\"2024-12-13T20:09:09+00:00\",\"dateModified\":\"2025-12-22T23:20:44+00:00\",\"description\":\"Update Shopify product prices using CSV files from an FTP server. Simplify price adjustments with clear steps for efficient store management.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/tutorial_csv-shopify.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/tutorial_csv-shopify.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Update Shopify Product Prices from a CSV File on an FTP Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\",\"name\":\"MESA\",\"description\":\"Discover how to automate your Shopify growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\",\"name\":\"MESA - AI automation Platform\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/mesa-shoppad.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/mesa-shoppad.jpeg\",\"width\":225,\"height\":225,\"caption\":\"MESA - AI automation Platform\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/web.facebook.com\\\/mesabyshoppad\\\/\",\"https:\\\/\\\/x.com\\\/getmesa\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/shoppad\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCqsf_WhcGEsZMvms1idivyw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/person\\\/5ed8ee9c6f19090c4d5acb4f45efacb4\",\"name\":\"Ryan ODonnell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g\",\"caption\":\"Ryan ODonnell\"},\"sameAs\":[\"https:\\\/\\\/www.getmesa.com\"],\"jobTitle\":\"Director of Marketing\",\"worksFor\":\"MESA\"},{\"@type\":\"HowTo\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#howto-1\",\"name\":\"How to Update Shopify Product Prices from a CSV File on an FTP Server\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#article\"},\"description\":\"This workflow connects to your FTP server, retrieves the CSV file containing price updates, and processes the data. It then matches the updates to the correct products in Shopify and applies the new prices automatically. First, make sure you have access to the FTP server where your price update CSV file is stored.&lt;br>&lt;br>To format your CSV, include columns for Product ID and Variant ID, which aren\u2019t part of Shopify\u2019s default export. Start by exporting a CSV from your Shopify admin as a base template. Then, manually add columns for Product ID and Variant ID, pulling these values directly from your Shopify admin.&lt;br>&lt;br>To find these IDs, go to your Shopify admin, open a product, and check the URL. The Product ID and Variant ID will be visible in the URL\u2014copy these values into your &lt;a href=\\\"https:\\\/\\\/admin.shopify.com\\\/store\\\/my-shopify-id\\\/products\\\/000-product-id-000\\\/variants\\\/000-variant-id-000\\\" target=\\\"_blank\\\" rel=\\\"noreferrer noopener\\\">sample CSV file&lt;\\\/a>.&lt;br>\",\"totalTime\":\"P0DT0H5M\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#how-to-step-1733947402061\",\"name\":\"Fetch the CSV file from the FTP server\u00a0\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Kick off the workflow by adding the built-in FTP tool and choosing the Fetch CSV File trigger. Enter the file name and path for the CSV file, then validate the connection by clicking the \u201cCheck for CSV\u201d button.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#schema-image-99e8eaf6e1fdae3212e4918db773ba54\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/trigger-fetch-csv-file-a.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/trigger-fetch-csv-file-a.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#how-to-step-1733947615134\",\"name\":\"Loop over the file contents\u00a0\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Add the built-in Loop step to iterate over the rows in the CSV file. Enter {{ftp}} in the \u201cValues to loop over\u201d field to process each row.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#schema-image-4dbd725014d17cd94418ff9e7fad8df8\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/action-loop-csv.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/action-loop-csv.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#how-to-step-1733947733594\",\"name\":\"Update Product Variant based on the CSV file data\u00a0\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"While still in the Loop step, add Shopify and select the \u201cUpdate Product Variant\u201d action.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#schema-image-5efa6a90433dccc6a8bbda3ef49512c1\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/action-shopify-update-product-variant.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/action-shopify-update-product-variant.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#how-to-step-1733947835496\",\"name\":\"Assign data variables to configure the data mapping\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"To set up the Product ID and Variant ID fields, select Custom value and use the Variable Selector to choose the correct ID values. Under 'More options,' find the Price field and link it to the Variant Price variable.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#schema-image-4a57a4b199ecbd22ce706029b1b98073\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/end-shopify-product-variant.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/end-shopify-product-variant.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#how-to-step-1733948766730\",\"name\":\"Test, then turn \u201cOn\u201d\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Give your workflow a test run to confirm it\u2019s ready, then activate it to respond automatically to trigger events.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/update-shopify-product-prices-csv-ftp\\\/#schema-image-d4a1f98c0446807b461bc01e9b40f9de\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/end-shopify-inventory-updates-csv.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/end-shopify-inventory-updates-csv.png\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Shopify: Update Product Prices with CSV Files via FTP","description":"Update Shopify product prices using CSV files from an FTP server. Simplify price adjustments with clear steps for efficient store management.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/","og_locale":"en_US","og_type":"article","og_title":"How to Update Shopify Product Prices from a CSV File on an FTP Server","og_description":"Managing product prices and data in Shopify becomes more complex as your inventory grows. Manual updates are time-consuming, error-prone, and can disrupt","og_url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/","og_site_name":"MESA","article_publisher":"https:\/\/web.facebook.com\/mesabyshoppad\/","article_published_time":"2024-12-13T20:09:09+00:00","article_modified_time":"2025-12-22T23:20:44+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/tutorial_csv-shopify.png","type":"image\/png"}],"author":"Ryan ODonnell","twitter_card":"summary_large_image","twitter_creator":"@getmesa","twitter_site":"@getmesa","twitter_misc":{"Written by":"Ryan ODonnell","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#article","isPartOf":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/"},"author":{"name":"Ryan ODonnell","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/person\/5ed8ee9c6f19090c4d5acb4f45efacb4"},"headline":"How to Update Shopify Product Prices from a CSV File on an FTP Server","datePublished":"2024-12-13T20:09:09+00:00","dateModified":"2025-12-22T23:20:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/"},"wordCount":827,"publisher":{"@id":"https:\/\/www.getmesa.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial_csv-shopify.png","keywords":["ftp"],"articleSection":["Workflow Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/","name":"Shopify: Update Product Prices with CSV Files via FTP","isPartOf":{"@id":"https:\/\/www.getmesa.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#primaryimage"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial_csv-shopify.png","datePublished":"2024-12-13T20:09:09+00:00","dateModified":"2025-12-22T23:20:44+00:00","description":"Update Shopify product prices using CSV files from an FTP server. Simplify price adjustments with clear steps for efficient store management.","breadcrumb":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#primaryimage","url":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial_csv-shopify.png","contentUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/tutorial_csv-shopify.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.getmesa.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Update Shopify Product Prices from a CSV File on an FTP Server"}]},{"@type":"WebSite","@id":"https:\/\/www.getmesa.com\/blog\/#website","url":"https:\/\/www.getmesa.com\/blog\/","name":"MESA","description":"Discover how to automate your Shopify growth","publisher":{"@id":"https:\/\/www.getmesa.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.getmesa.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.getmesa.com\/blog\/#organization","name":"MESA - AI automation Platform","url":"https:\/\/www.getmesa.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/mesa-shoppad.jpeg","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/mesa-shoppad.jpeg","width":225,"height":225,"caption":"MESA - AI automation Platform"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/web.facebook.com\/mesabyshoppad\/","https:\/\/x.com\/getmesa","https:\/\/www.linkedin.com\/company\/shoppad\/","https:\/\/www.youtube.com\/channel\/UCqsf_WhcGEsZMvms1idivyw"]},{"@type":"Person","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/person\/5ed8ee9c6f19090c4d5acb4f45efacb4","name":"Ryan ODonnell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/62bb965c979cc1de4c6f046fb47a28a57bc194da441ebe43b3dfbe2f2f893563?s=96&d=mm&r=g","caption":"Ryan ODonnell"},"sameAs":["https:\/\/www.getmesa.com"],"jobTitle":"Director of Marketing","worksFor":"MESA"},{"@type":"HowTo","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#howto-1","name":"How to Update Shopify Product Prices from a CSV File on an FTP Server","mainEntityOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#article"},"description":"This workflow connects to your FTP server, retrieves the CSV file containing price updates, and processes the data. It then matches the updates to the correct products in Shopify and applies the new prices automatically. First, make sure you have access to the FTP server where your price update CSV file is stored.&lt;br>&lt;br>To format your CSV, include columns for Product ID and Variant ID, which aren\u2019t part of Shopify\u2019s default export. Start by exporting a CSV from your Shopify admin as a base template. Then, manually add columns for Product ID and Variant ID, pulling these values directly from your Shopify admin.&lt;br>&lt;br>To find these IDs, go to your Shopify admin, open a product, and check the URL. The Product ID and Variant ID will be visible in the URL\u2014copy these values into your &lt;a href=\"https:\/\/admin.shopify.com\/store\/my-shopify-id\/products\/000-product-id-000\/variants\/000-variant-id-000\" target=\"_blank\" rel=\"noreferrer noopener\">sample CSV file&lt;\/a>.&lt;br>","totalTime":"P0DT0H5M","step":[{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#how-to-step-1733947402061","name":"Fetch the CSV file from the FTP server\u00a0","itemListElement":[{"@type":"HowToDirection","text":"Kick off the workflow by adding the built-in FTP tool and choosing the Fetch CSV File trigger. Enter the file name and path for the CSV file, then validate the connection by clicking the \u201cCheck for CSV\u201d button."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#schema-image-99e8eaf6e1fdae3212e4918db773ba54","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/trigger-fetch-csv-file-a.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/trigger-fetch-csv-file-a.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#how-to-step-1733947615134","name":"Loop over the file contents\u00a0","itemListElement":[{"@type":"HowToDirection","text":"Add the built-in Loop step to iterate over the rows in the CSV file. Enter {{ftp}} in the \u201cValues to loop over\u201d field to process each row."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#schema-image-4dbd725014d17cd94418ff9e7fad8df8","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-loop-csv.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-loop-csv.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#how-to-step-1733947733594","name":"Update Product Variant based on the CSV file data\u00a0","itemListElement":[{"@type":"HowToDirection","text":"While still in the Loop step, add Shopify and select the \u201cUpdate Product Variant\u201d action."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#schema-image-5efa6a90433dccc6a8bbda3ef49512c1","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-shopify-update-product-variant.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/action-shopify-update-product-variant.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#how-to-step-1733947835496","name":"Assign data variables to configure the data mapping","itemListElement":[{"@type":"HowToDirection","text":"To set up the Product ID and Variant ID fields, select Custom value and use the Variable Selector to choose the correct ID values. Under 'More options,' find the Price field and link it to the Variant Price variable."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#schema-image-4a57a4b199ecbd22ce706029b1b98073","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-product-variant.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-product-variant.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#how-to-step-1733948766730","name":"Test, then turn \u201cOn\u201d","itemListElement":[{"@type":"HowToDirection","text":"Give your workflow a test run to confirm it\u2019s ready, then activate it to respond automatically to trigger events."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/update-shopify-product-prices-csv-ftp\/#schema-image-d4a1f98c0446807b461bc01e9b40f9de","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-inventory-updates-csv.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/end-shopify-inventory-updates-csv.png"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/12504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/comments?post=12504"}],"version-history":[{"count":11,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/12504\/revisions"}],"predecessor-version":[{"id":17339,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/12504\/revisions\/17339"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/media\/12505"}],"wp:attachment":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/media?parent=12504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/categories?post=12504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/tags?post=12504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}