Rivalry2

HTML Diff

20 added 20 removed

Original 2026-01-01

Modified 2026-03-10

1 Solution Recipes are tutorials to achieve specific objectives in Klaviyo. They can also help you master Klaviyo, learn new third-party technologies, and come up with creative ideas. They are written mainly for developers & technically-advanced users.

2 - Note:We do our best to make sure any code and API references are accurate and current when this is published, but you might need to update code and it’s always a best practice to leverage our<a>latest API versions</a>. If you have questions, feel free to hop over to our<a>Developer Community</a>.

2 + Note:We do our best to make sure any code and API references are accurate and current when this is published, but you might need to update code and it’s always a best practice to leverage our<a>latest API versions</a>. If you have questions, feel free to hop over to our<a>Developer Community</a>.

3 What you’ll learn

4 How to use Google Sheets to backfill Back in Stock subscribers to Klaviyo as part of an onboarding or migration project.

5 Why it matters

6 Back in Stock subscribers have explicitly allowed you to contact them when a product that they want to purchase is available to buy. You do not want to lose these leads when migrating to Klaviyo. This guide will outline how easy it is to migrate the data.

7 Level of sophistication

8 Moderate

9 <h2>Introduction</h2>

10 Back in Stock notifications are hugely important in today’s retail environment as they signify that your product is in such demand that people want to be notified as soon as they are able to purchase it.

11 Due to the importance of these subscriber lists, it is imperative that we handle them with care. During any transformation project, be it migration to a new platform, or introduction of new markets or changes to the data model, data consistency is key.

12 - Here we will look at how to create a Google Script to push data from a Google Sheet of Back in Stock subscribers into Klaviyo by utilising the <a>Back in Stock API</a>.

12 + Here we will look at how to create a Google Script to push data from a Google Sheet of Back in Stock subscribers into Klaviyo by utilising the<a>Back in Stock API</a>.

13 <h2>Background</h2>

14 In order to import BiS (Back in Stock) into Klaviyo, it is important to understand how BiS works and its components:

15 <h3>Custom catalog</h3>

16 - Within Klaviyo, <a>custom catalog</a> items are stored as either ‘products’ or ‘variants’, depending on your integration method. The catalog becomes ‘inventory aware’ once <a>inventory data is added to the catalog feed</a>.

16 + Within Klaviyo,<a>custom catalog</a>items are stored as either ‘products’ or ‘variants’, depending on your integration method. The catalog becomes ‘inventory aware’ once<a>inventory data is added to the catalog feed</a>.

17 <h3>Back in Stock settings</h3>

18 - When the inventory level changes for a the subscribed item, a trigger is fired, and the flow will be initiated for that item. This in turn will then follow the rules defined in the <a>Back in Stock settings</a> for your Klaviyo account.

18 + When the inventory level changes for a the subscribed item, a trigger is fired, and the flow will be initiated for that item. This in turn will then follow the rules defined in the<a>Back in Stock settings</a>for your Klaviyo account.

19 <h3>Subscribing to Back in Stock via API</h3>

20 - Typically, BiS subscribers are subscribed to the variant item, as this is the physical item that will maintain inventory. The subscription event occurs through an <a>API call</a>:

20 + Typically, BiS subscribers are subscribed to the variant item, as this is the physical item that will maintain inventory. The subscription event occurs through an<a>API call</a>:

21 curl 'https://a.klaviyo.com/api/v1/catalog/subscribe' --data 'a=AccountID&email=test@klaviyo.com&variant=5000149172256&platform=api'<h2>Scenarios</h2>

22 <h3>Scenario 1 - The migration to Klaviyo</h3>

23 The business is looking to migrate to Klaviyo and has amassed a list of Back in Stock subscribers for their products. The business wants to bring these Back in Stock subscribers into Klaviyo to utilise Klaviyo’s powerful BiS flow based upon stock changes.

24 <h3>Scenario 2 - Product restructuring</h3>

25 The business has recently undertaken a product restructuring exercise, and as a result, many product and variant SKUs have changed. Given that the existing list of BiS subscribers are subscribed to now ‘defunct’ SKUs, the business would like to migrate them to the new SKU structure so they can ensure uninterrupted delivery.

26 <h2>Ingredients</h2>

27 <ul><li>A catalog synced to Klaviyo with an inventory field</li>

28 <li>Google Sheets</li>

29 <li>Google Scripts</li>

30 </ul><h2>Instructions</h2>

31 <h3>Step 1 - Organise your subscriber data</h3>

32 As mentioned above, profiles are typically subscribed to the physical variant item, the one that maintains the inventory levels.

33 Within your Google Sheet, the following columns will be required:

34 <ul><li>email</li>

35 <li>variant</li>

36 <li>synced</li>

37 - </ul>Now, you will need to rename the Sheet tab from Sheet 1 to BackInStock.

37 + </ul>Now, you will need to rename the Sheet tab fromSheet 1toBackInStock.

38 Finally, you’ll need to add all your subscribers.

39 <h3>Step 2 - Prepare your catalog feed</h3>

40 - Assuming that you are using a custom catalog feed, the variant items will need to ensure that they are <a>inventory-aware</a>.

40 + Assuming that you are using a custom catalog feed, the variant items will need to ensure that they are<a>inventory-aware</a>.

41 You will need to ensure that there is an inventory quantity, and an inventory policy flag set for each item.

42 The inventory quantity will contain the stock level

43 - The inventory policy flag determines how Klaviyo will handle out of stock items. A 1 means that the item will not appear until the product is back in stock, even when out of stock, whereas a 2 means that Klaviyo can still use the item in product blocks and recommendations.

43 + The inventory policy flag determines how Klaviyo will handle out of stock items. A1means that the item will not appear until the product is back in stock, even when out of stock, whereas a2means that Klaviyo can still use the item in product blocks and recommendations.

44 <h3>Step 3 - Map the catalog data within Klaviyo</h3>

45 Now that you’ve added these new attributes, you will need to adjust your catalog feed mapping within Klaviyo.

46 It’s important that these new fields are mapped to the correct Klaviyo attributes so that they can be utilised for BiS.

47 - To do this, you will need to navigate to Products -> Custom Catalog Sources, then locate your feed, and select Update.

47 + To do this, you will need to navigate toProducts -> Custom Catalog Sources, then locate your feed, and selectUpdate.

48 - One the subsequent mapping screen, you will need to map your newly created attributes with the attributes $inventory_quantity & $inventory_policy.

48 + One the subsequent mapping screen, you will need to map your newly created attributes with the attributes$inventory_quantity&$inventory_policy.

49 Once updated, hit save and re-sync the feed.

50 <h3>Step 4 - Configure BiS trigger and flow rate</h3>

51 - <a>Klaviyo’s Back in Stock Settings</a> allows you to adjust under what level of stock the BiS will trigger, and the flow rate at which people should be notified.

51 + <a>Klaviyo’s Back in Stock Settings</a>allows you to adjust under what level of stock the BiS will trigger, and the flow rate at which people should be notified.

52 - This can configured within Settings -> BiS settings.

52 + This can configured withinSettings -> BiS settings.

53 <h3>Step 5 - Add a Google Script to push the subscriber data to Klaviyo</h3>

54 - In your BackInStock sheet, select Extensions -> Apps Script

54 + In your BackInStock sheet, selectExtensions -> Apps Script

55 Now paste the following script:

56 - //Pull environment variables const public_key = "PUBLIC_KEY"; function seedBackInStock(){ const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('BackInStock'); const data = sheet.getDataRange().getValues(); const headers = data[0]; const emailIndex = headers.indexOf("email"); const variantIndex = headers.indexOf("variant"); const syncIndex = headers.indexOf("synced"); //Throttle that can be lowered if you're getting errors with large volume of subscribers. const reqsPerSecond = 50; //Restricting to 20,000 URL Requests/day as per https://developers.google.com/apps-script/guides/services/quotas. If you have a Workspace account, this can be increased to 100,000. const maxHTTPrequests = 20000; const numRows = data.length-1 if(numRows>maxHTTPrequests){ alertMessage('Too many rows. This script supports up to 20,000 rows'); }else{ data.slice(1).forEach(function (row, index) { if(row[syncIndex]!="synced"){ Utilities.sleep(1000/reqsPerSecond); subscribeBis(row[emailIndex], row[variantIndex]); let cell = columnToLetter(syncIndex+1)+(index+2); sheet.getRange(cell).setValue('synced'); } }); } } function subscribeBis(email, variant){ const options = { 'method': 'POST', 'payload': { 'a':public_key, 'email':email, 'variant':variant, 'platform':'api' } } UrlFetchApp.fetch('https://a.klaviyo.com/api/v1/catalog/subscribe', options) } function columnToLetter(column){ let temp, letter = ''; while (column > 0){ temp = (column - 1) % 26; letter = String.fromCharCode(temp + 65) + letter; column = (column - temp - 1) / 26; } return letter; } function alertMessage(message) { SpreadsheetApp.getUi().alert(message); }Replacing PUBLIC_KEY with your accounts Public Key

56 + //Pull environment variables const public_key = "PUBLIC_KEY"; function seedBackInStock(){ const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('BackInStock'); const data = sheet.getDataRange().getValues(); const headers = data[0]; const emailIndex = headers.indexOf("email"); const variantIndex = headers.indexOf("variant"); const syncIndex = headers.indexOf("synced"); //Throttle that can be lowered if you're getting errors with large volume of subscribers. const reqsPerSecond = 50; //Restricting to 20,000 URL Requests/day as per https://developers.google.com/apps-script/guides/services/quotas. If you have a Workspace account, this can be increased to 100,000. const maxHTTPrequests = 20000; const numRows = data.length-1 if(numRows>maxHTTPrequests){ alertMessage('Too many rows. This script supports up to 20,000 rows'); }else{ data.slice(1).forEach(function (row, index) { if(row[syncIndex]!="synced"){ Utilities.sleep(1000/reqsPerSecond); subscribeBis(row[emailIndex], row[variantIndex]); let cell = columnToLetter(syncIndex+1)+(index+2); sheet.getRange(cell).setValue('synced'); } }); } } function subscribeBis(email, variant){ const options = { 'method': 'POST', 'payload': { 'a':public_key, 'email':email, 'variant':variant, 'platform':'api' } } UrlFetchApp.fetch('https://a.klaviyo.com/api/v1/catalog/subscribe', options) } function columnToLetter(column){ let temp, letter = ''; while (column > 0){ temp = (column - 1) % 26; letter = String.fromCharCode(temp + 65) + letter; column = (column - temp - 1) / 26; } return letter; } function alertMessage(message) { SpreadsheetApp.getUi().alert(message); }ReplacingPUBLIC_KEYwith your accounts Public Key

57 Give it a name, and save it.

58 <h3>Step 6 - Run the script</h3>

59 - Ensure that the seedBackInStock function is selected, then hit Run.

59 + Ensure that theseedBackInStockfunction is selected, then hitRun.

60 If this is your first time running this script, you will be asked to provide the Script permission to access your Google Sheet.

61 - Select Review permissions and login to the correct account and grant access.

61 + SelectReview permissionsand login to the correct account and grant access.

62 After this, the script will complete.

63 When you return to the Google Sheet, you should see ‘synced’ status appear in the ‘synced’ column:

64 That’s it!

65 <h2>BONUS - Make a button!</h2>

66 To make this a bit more re-usable, you can create a button to run the script.

67 - To do this, click Insert -> Drawing

67 + To do this, clickInsert -> Drawing

68 Then create a Button shaped object, and add some text:

69 - Next, assign the seedBackInStock script to this button by tapping on the three dots when hovering over the button image:

69 + Next, assign theseedBackInStockscript to this button by tapping on the three dots when hovering over the button image:

70 - And enter seedBackInStock

70 + And enterseedBackInStock

71 That’s it. You can now tap this button, and it will perform the sync!

72 <h2>Learn more</h2>

73 - If you’re interested in learning more about Klaviyo’s developer experience and capabilities, check out <a>developers.klaviyo.com</a>!

73 + If you’re interested in learning more about Klaviyo’s developer experience and capabilities, check out<a>developers.klaviyo.com</a>!