Add Updates by Spreadsheet

  • Updated

Storefront allows users to upload a spreadsheet with all the metadata instead of entering it manually within the Create Update (1.0) module.

 

This article will cover the following topics:

Note: The Storefront only supports spreadsheets generated by the tool itself. Uploading a personal spreadsheet or altering the spreadsheet's format in any way may cause upload errors. 

Downloading the Template

To begin, click on “Spreadsheet” button and from the drop-down click on Download blank.

Filling Out The Template

A spreadsheet will then download to your local computer with the default filename “Updates template.xlsx”. The metadata fields selected in the tool will appear as columns in the spreadsheet.

Enter metadata beginning on Line 3. The territory/region field includes a drop-down menu to select from. All other fields are open text fields.

Please Note: 

  • Any column left blank will not be included in the update.

  • Updates will be added only from the “Updates” tab/sheet.

  • There is still an opportunity after upload that allows the user to add more data.
  • The data must align with Storefront and the Platform's (iTunes) data values.

Best Practices to fill out the Template :

  1. Any ''Date'' columns in the spreadsheet must follow MM/DD/YYYY format. Example: For the Price date range start date column, enter the date like 05/07/2025 for May 7th, 2025.
  2. Some metadata fields in the spreadsheet (e.g., Cleared for Sale, Cleared for VOD, etc...) required to fill with just Y or N instead of Yes and No.
  3. Make sure all the required metadata fields are filled in the spreadsheet. To avail a new territory for HD and SD BUY, the update should include the following metadata:
    • Title
    • Apple ID/Vendor ID
    • Territory/Region
    • HD Price
    • SD Price
    • Cleared for Sale
    • EST Date range Start date
    • Enable EST HD
    • Rating
    • Physical Release Date
    • Provider
    • Retailer
  4. Territory names entered in the spreadsheet must match the territory name that appears in the drop-down.
    • For territories like “Moldova, Republic Of” the spreadsheet territory drop-down will list this territory name as Moldova in short.
  5. By default, the cell's format in the spreadsheet will be ''Text'' even if you are entering the numbers or dates. Altering the spreadsheet's format in any way may cause upload errors.
  6. Always use only the ''Updates'' sheet in the spreadsheet to enter your metadata, creating an own sheet may cause upload errors.
  7. All rows, including hidden rows, will be added in Storefront when you upload a spreadsheet. Delete rows in the spreadsheet if you do not wish to upload the metadata.
  8. Different territories for the same title should be delivered in the same batch to avoid competing deliveries.
  9. iTunes has a quota limit on how much data can be delivered within 24 hours. Instead of delivering large batches, consider specifying them by Title, Territory, Tier, etc.

Uploading Template

  1. To upload the filled-out spreadsheet/template, click on Spreadsheet and from the drop-down click on Upload.

  2. Locate the completed spreadsheet on your local computer and click on open. Storefront will begin to upload the data from the spreadsheet, however the user should keep in mind that the more data, the slower it may process.
  3. After the spreadsheet upload completes, each update will populate in the UI and updates are listed in alphabetical order (by title name). At this time, it's still possible to add, remove, or edit any metadata field prior to adding the updates to a batch.


    Keep in mind that you may encounter errors when attempting to upload your spreadsheet, which our UI may flag to you. For example, if vendor IDs / Apple ID field in the spreadsheet is missing, then an error message will pop up as below.
    • Each error will typically provide the action item required for the user to rectify. The above error is telling the user to use an alternative ID if the other was utilized.

Please reach out to Storefront Support if the error message provided doesn't make sense.

(Return to the top)