Update Product Variant Prices (and more) via a Google Sheet #
The WP Price Updater App supports updating product variant prices in your Shopify store from data in a Google Sheet.
When everything is set up you can press “Update product variants” to update your prices in Shopify from the prices in the Google Sheet.
Getting started #
In a first step you need to authorize WP Price Updater App to read an write Google Sheets. For that please input your Shopify shop name, the one before the .myshopify.com.
Start Google Authorization for your Shopify shop #
Setup the WP Price Updater App in your Shopify shop admin #
After installation you are taken to the Get Started screen. There are two ways to connect a Google Sheet:
Set up via the Google Sheet Setup page
#
#
Click By picking a Google Sheet in the Google Sheet Setup page to open the setup page. There you can either paste the URL of an existing Google Sheet directly into the URL field, or use the Pick a Google Sheet button to select a file from your Google Drive.
Make sure that the Google Sheet is shared with Anyone with the link, or that you are signed in with the Google account that owns the sheet.
Export to an Excel Sheet and upload it to a Google Sheet
#
#
Just download your product variants to an Excel Sheet and upload it to a Google Sheet
Make sure that the Google Sheet is shared with Anyone with the link.
Hint: Google Drive allows to upload Excel Sheets. They are not converted to Google Sheets and will not work with the WP Price Updater App directly. But you can save them as Google Sheet via File->Save as Google Sheet.
Preparing a Google Sheet #
Setup the Google Sheet #
The simplest setup for the Google Sheet is to use either of the Export ... possiblilites. For the WP Price Updater App only the two columns B and C (the variant id and the price) are used. These two columns also define the UpdateRegion, which is used for updating if no other region is defined.
The price field can contains formulas and links. These must evaluate to a number.
Setting up the Google Sheet#
To open the Google Sheet just click on the icon on the left side of the menu bar.
Why using Google Sheets #
Goggle Spreadsheet allows to calculate prices any way a user wants to, for example from exchange rates via the function `GOOGLEFINANCE'.
Update the prices in Shopify from the Google Sheet #
To update the prices for the product variants listed in the Google Sheet just click the button Update product variants. You can check the results in the Shopify store or by looking at the Update Reports.
Updating the prices#
Scheduled price updates #
Set the recalcultions interval in the Google Sheet #
To trigger recalculation in the Google Sheet adjust the setting in the Google sheet accordingly, for details see here
The menu entry ‘Schedule’ allows to setup regular updates. From the screen you may chose the months, days of months, days of week, hour and minute for the update. Currently only on schedule is supported for a customer and only one selected hour.
Scheduling a regular price update#
The email field is required.
When clicking submit a mail is sent to the provided email address with the requested price update. In addition a email is sent whenever an update is run reporting on the success or failure of the price updates.
Please be aware, that it might take up to 24 hours to set up the new schedule.
Current Limitations #
- At the moment only one update per day can be scheduled.