Importing Addresses for Ship to Home Orders

Great News! We have a way for us to help you import addresses for Ship to Home Orders. A CSV template has been created for you to enter the necessary address information. Once the template is complete, we will import the data for you.

Reminder: The All Orders Ship to Home option and student addresses must be updated before you set the book to Print Ready.  Addresses which are not updated after turning on the ship to home option will ship to the address you confirm during the print ready process.  

The status of your student roster and orders will determine what procedure needs to be followed for updating addresses. Here are the different scenarios and procedures:

Orders have been placed for students who have already been added to your Students & Parents list.

  1. Make sure you have turned on the All Orders Ship to Home option
  2. Contact Customer Support to request the CSV template
  3. When you receive the template, complete it with the students' addresses
    Important!
    - DO NOT
    edit or remove any of the existing data in the template.
    - Only enter the addresses making sure the 2 letter abbreviation is used for the State column and that United States or Canada is spelled out for the Country column.
    - This template is auto filled with all the students who have placed orders but HAVE NOT updated their address. If a student is missing from the template it means that they have already updated their address. DO NOT add them back to the template.
    - If the zip codes begin with 0 you will need to change the Zip Code column to TEXT format. (If the column is formatted for a number, Excel automatically removes the 0 when a number begins with it.) 9 digit zip codes are acceptable in this format:  04092-3050.
  4. When the template is complete, send it to us by replying to the email which was previously sent to you with the template. We will import the addresses. If there are errors in the template only correct entries will be uploaded.

A bulk order has been placed for standard yearbooks. No students have been added to your Students & Parents list.

  1. Upload your Student Roster  Upload a Student Roster
  2. Now you can re-assign a book to all of the students  Re-Assigning an Order
  3. Turn on the All Orders Ship to Home option
  4. Contact Customer Support to request the CSV template
  5. When you receive the template, complete it with the students' addresses
    Make sure you follow the Important notes listed above
  6. When the template is complete, send it to us by replying to the email which was previously sent to you with the template. We will import the addresses. If there are errors in the template only correct entries will be uploaded.

Zero students have been added to the Students & Parents list and no orders have been placed.

  1. Upload your Student Roster  Upload a Student Roster
  2. Place orders for students  Placing Orders for Multiple Students
  3. Turn on the All Orders Ship to Home option
  4. Contact Customer Support to request the CSV template
  5. When you receive the template, complete it with the students' addresses
    Make sure you follow the Important notes listed above
  6. When the template is complete, send it to us by replying to the email which was previously sent to you with the template. We will import the addresses. If there are errors in the template only correct entries will be uploaded.

 

Can't find your answer in our Help Center? Our agents are available to assist you Monday - Friday from 6AM to 6PM Pacific Time.

(877) 755-TREE

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

2
  • Avatar
    Kristen Cerer

    Thanks! Is there a way to see who created custom pages? I have an entry that originally came up as norbert norbert. I edited his name in the people list to norbert zych, but in the bulk order list it's still showing as norbert norbert. I want to make sure I'm not messing up anyone with custom pages. Thanks!

  • Avatar
    Debbie

    Hi Kristen - I re-assigned the yearbook to the correct student name. You can see who created custom pages in Review All Student Pages. Here is an article to help you:
    https://treering.zendesk.com/hc/en-us/articles/360011555851-Reviewing-All-Students-Custom-Pages