Update Product Prices (and more) via a Google Sheet #
The WP Price Updater App supports the updating of the product prices (actually the product variant prices) and meta fields in the Shopify store from data given by a Google Spreadsheet.
When everything is setup in the WP Price Updater App you can press “Update Prices” to update your prices in Shopify from the prices in the Google Spreadsheet.
Getting started #
After the first installation your are asked to either provide a link to a Google Sheet or to use a default Google Sheet provided by us.
Providing a link to a Google Sheet
#
#
When clicking providing a link to a Google Sheet the Setup page opens which allows to paste in the link to the Google Sheet. The sheet must be prepared as described below.
Make sure that the Google Sheet is shared with Anyone with the link.
Use a default Google Sheet
#
#
When using the default Google Sheet the app creates a shared Google Sheet in a sub directory on our Google Drive.
The link to the newly created Google Sheet is automatically stored for your store. The sheet will be overwritten if you export again to the Google Sheet.
Export to an Excel Sheet and upload 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 Prices. 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.
Update Metafields #
Setting up the Metafields#
Metafields can be defined in the Google Sheet within a region named Metafields. These region must consist of columns for Name, Value and Type.
The Type is optional and defaults to a simple string (single_line_text_field). The possible type values are defined by Shopify, see here. Alternativly you can set decimal for number_decimal and integer for numerical_integer.
The Google Sheet which is used is the one defined in the Google Sheet Setup.
After clicking on the button Update from Google Sheet the Metafields from the Google Sheet are available within Shopify.
If a metafield did not exist in Shopify so far it will be created. Existing metafields are updated.
To delete a metafield in Shopify just use the red delete button.
Use of Metafields in Liquid#
For the use of Metafields within Liquid see this blog
To use a Metafield in Liquid copy the value in the column Use in Liquid (you can use the copy button) and place it in the relvant liquid file.
Updating Metafields#
To update the metafields just click the button Update from Google Sheet and the current value from the Google Sheet will be transfered to Shopify.