Auction Close | NewMusicalsInc /* Mobile Menu Retract ---------------------------------*/

closing out auction items

 

1. SET UP WINNING BIDDER EMAIL FOR SHIPPABLE ITEMS

From the BiddingForGood site, go to CLOSE OUT/GET READY/WINNING BIDDER EMAIL), and set the Winning Bidder Email to say something like the following:

NOTE: You MUST add
tags to this when you insert it at BFG so that it will format clearly and not be a big jumble.

OPTIONAL TEXT BOX:
Thank you for making the online auction such a success for the Academy for New Musical Theatre.

ADDITIONAL TEXT BOX:
****DO NOT REPLY TO THIS EMAIL - NO ONE WILL SEE IT! REPLY TO ADMIN@NMI.ORG*****
If you would like us to ship your item(s) to you, you do not need to do anything further. We will add the shipping charge listed (includes shipping, handling, and certification) above to the cost of your item and take care of sending it to you by certified postal service, so we know you have received it.
NOTE: If you have won multiple items, we will consolidate shipping charges when we process your credit card.

NOTE: If the shipping charge above is shown as $0.00, this means either that the donor will be shipping the item free of charge, or your item will be delivered to you via an emailed gift certificate which will be arriving shortly.

If the shipping charge is greater than $0.00, and you would like to avoid this shipping charge, please let us know by Tue, Dec 10 at 10:00 am that you would like to pick up your item at New Musicals Inc. We are at 5628 Vineland in North Hollywood.
Auction items can be picked up from NMI during the following times:
          Thu, Dec 12 from 2:00 pm to 10:00 pm
          Fri, Dec 13 from 11:00 am to 7:00 pm
          Sat, Dec 14 from 10:00 am to 6:00 pm

Or call us at 818.506.8500 or email us at admin@nmi.org to coordinate a time which is convenient for you.

We will go ahead and ship your item(s) to you if we have not heard to the contrary from you by Tue, Dec 10 at 10:00 am.

Thanks.
2. AWARD SHIPPABLE ITEMS

Next, go to CLOSE OUT/AWARD ITEMS, and use the report below to AWARD the items with SHIPPING charges. (It will help if you order the list by LOT NUMBER ASCENDING.)

(If any of the items below have a shipping amount of $1000 - it means the item CANNOT BE SHIPPED - so change the shipping email accordingly.)

 

 

5031 $25 Gift Card for Art’s Delicatessen NMI 8.00
5036 Musical Windchime DONOR 15.00
5044 2 Tickets to SHE LOVES ME at South Coast Rep NMI 8.00
5049 2 Tickets to the Rubicon Theatre NMI 8.00
5083 2 Tickets to Matthew Bourne’s SWAN LAKE at the Ahmanson Theatre NMI 8.00
5108 $50 Gift Card for Casa Guadalajara Restaurant in Old Town San Diego NMI 8.00
6032 2 Tickets to THREE LA Theatre Works Performances NMI 8.00
6035 Christmas CD Collection NMI 15.00
6123 Sealy Posturepedic Luxury Queen-sized Feather Bed NMI 1000.00
6156 Coach Wallet NMI 12.00
6164 Kate Spade clear as crystal short floral necklace NMI 10.00
6197 2 tickets at the Geffen Playhouse NMI 8.00
6211 Go Puck 3X 4400 mAh Mobile Power Device GO5301 NMI 10.00
6226 $50 Gift Certificate for the Tam O’Shanter NMI 8.00
6236 BOOKS: Four Stephen King Novels NMI 25.00
6256 Books: A set of five children’s picture books by Susan Chodakiewitz DONOR 10.00
6257 Book: SALT FAT ACID HEAT by Samin Nosrat NMI 10.00
6259 Naxa NDC-404 12MP Waterproof 1080p Action Camera with Wi-Fi, Shiny Black NMI 15.00
6265 Christopher Radko HIGH ROLLER SNOWGLOBE (Archive – RARE) NMI 20.00
6267 Land’s End Women’s 3/4 Sleeve Supima Cotton Sweater Size XL (18) NMI 15.00
6271 Vera Bradley Campus Backpack in Nomadic Floral NMI 30.00
6272 Swarovski Crystallized Innocent Ring Silver Shade NMI 10.00
6276 COACH TOTE IN RANCH FLORAL PRINT NYLON NMI 20.00
6277 FLOYD’S GROOMING PACKAGE NMI 10.00
6278 House of Marley Liberate On-Ear Headphones (Saddle) With Mindy Project Season 2 on side of headphones NMI 15.00
6279 Family Game Night NMI 15.00
6284 Fine Jewelry Designer Sebastian, 30” Italian Sterling NMI 10.00
6285 Morganite Solitaire Earrings NMI 10.00
6288 Ruby Earrings NMI 10.00
6290 DVD – THE DRESSMAKER DONOR 10.00
6291 2 Tickets to ONCE ON THIS ISLAND at the Ahmanson Theatre + 2 complimentary drink tickets NMI 8.00
6292 2 Tickets to 1776 at the Ahmanson Theatre NMI 8.00
6294 Chair Dolly NMI 1000.00
6295 Godin Flat Five X hollowbody guitar. NMI 1000.00
6297 Framed Art: Penguin Photograph 2 NMI 20.00
6299 Rare Limited Edition LITTLE PRINCE Watch NMI 15.00
6301 Coffee Bean and Tea Leaf Gift Basket NMI 1000.00
6303 DVDs: SUSPENSE package of 4 NMI 10.00
6304 DVDs: Two by Shyamalan NMI 10.00
6305 DVDs – For the Kids NMI 10.00
3. REVISE WINNING BIDDER EMAIL FOR PDF ITEMS

Next, REVISE the automatic email (CLOSE OUT/GET READY/WINNING BIDDER EMAIL) to delete all info about shipping, and instead say something like the following:

(again - remember to add
for formatting)

OPTIONAL TEXT BOX:
Thank you for making the online auction such a success for the Academy for New Musical Theatre.

ADDITIONAL TEXT BOX:
****DO NOT REPLY TO THIS EMAIL - NO ONE WILL SEE IT! REPLY TO ADMIN@NMI.ORG*****
This item will be delivered to you in the form of an emailed gift certificate which will include instructions for redeeming your item.

If you have not received this email within 48 hours, please call us at 818.506.8500 or email us at admin@nmi.org so we can make sure we have your correct email address.

Thanks for your support!.

4. AWARD PDF ITEMS

Go to BFG’s CLOSE OUT/AWARD ITEMS and AWARD all of the PDF items from the chart below.

 

 

6126 $50 Gift Card for BARNEY’S BEANERY PDF 0
6127 $50 Gift Card for BARNEY’S BEANERY PDF 0
5027 1 Hour of Entertainment Law Advice from Michael Blaha PDF 0
5061 18 Hours of Studio Time at 36 Degrees Sound Studios PDF 0.00
5112 2 Season Tickets to the Sacred Fools Theatre Company PDF 0.00
6275 2 Tickets to ARSENIC AND OLD LACE at La Mirada Theatre for the Performing Arts PDF
5045 2 Tickets to East West Players PDF 0
5017 2 Tickets to ESCAPE TO MARGARITAVILLE at the Dolby Theatre PDF
5124 2 Tickets to FROZEN at the Pantages Theatre PDF
6189 2 Tickets to LA Kings Game – December 23 PDF 8.00
5114 2 Tickets to LA Kings Game – February 20 PDF 8.00
6307 2 Tickets to LA Kings Game – March 9 PDF 8.00
5082 2 Tickets to Musical Theatre West PDF
6245 2 Tickets to the Pasadena Playhouse PDF 0
5001 2 Tickets to THE SPONGEBOB MUSICAL at the Dolby Theatre PDF
5028 2 VIP Tickets to a Live Taping of Conan PDF 0.00
5029 2 VIP Tickets to a Live Taping of Conan PDF 0.00
5005 4 Songwriting Lessons (30 minutes each) by Harriet Schock PDF 0.00
5021 ANMT Script/Score Formatting Guidelines PDF 0.00
6308 Brass Tack Organization PDF 0
5013 Dodgers Tickets PDF 0.00
1001 Finding Your Voice: with Evelyn Halus PDF 0
102 One Hour Massage Therapy PDF
101 One Hour Massage Therapy PDF
5030 One Hour of Private Coaching with Joshua Finkel PDF 0.00
6309 Puppetry Lesson with Stacey Weingarten PDF
5032 Script Evaluation PDF 0.00
5034 Singing Lessons – 5 hours of lessons with Terri Weiss (Terri Baker) PDF 0.00
5109 VIP Warner Brothers Studio Tour PDF 0
5. CLOSE OUT UNSOLD ITEMS

Go to the Auction Admin Page and locate the items that are marked as UNSOLD at BFG.

Click to EDIT those items, and mark them as UNSOLD (which will trigger an email to the donor.)

Also mark each item in the CATEGORY for the current year. (The first time you do this, you will need to create the new category.) ****NOT SURE ABOUT THIS - if the current year category is already made, it will be harder to move everything all at once from CURRENT to the new year. Perhaps these should go to a category called UNSOLD?)

Finally, at BFG - AWARD each Unsold item to get them off the list.

6. PROCESS PDF ONLY

At BFG - go to CLOSE OUT and click on WINNING BIDDER EMAIL and now set it to NOT send a winning bidder email. (Now that you will be processing payments - you might have to re-award items if the shipping amount changes - and you don’t want to re-send a winning bidder email just because of that.)

THEN - go to CLOSE OUT and click on PROCESS PAYMENTS.

For each person, click to VIEW their items. If they ONLY have items with NO SHIPPING - you can go ahead and PROCESS their payment.

(If they have any shipping charges listed, then you need to wait until the Shipping Deadline to know if they want to have their item shipped or not.)

7. EXPORT/IMPORT AWARDED ITEMS DETAIL

At BFG - go to REPORTS and click on AWARDED ITEMS.

Click the EXCEL button on the report to download the Awarded Items Report.

OPEN the Excel file and replace the column headers and contents as follows:

Close Date = csv_post_type (and change all entries to auction-winner)
Item Name = csv_post_title
Lot = wpcf-auction-lot-number (and then format column as number with no decimals)
Cost = csv_ctax_auction-category (and then replace whole column with “,CURRENT”)
Purchase Method = wpcf-auction-item-delivery-status (and then replace whole column with “NONE”)
Amount = wpcf-auction-item-winning-bid (and then format column as number with no decimals)
Shipping = wpcf-auction-item-shipping-charged (and then format column as number with no decimals)
Total = wpcf-auction-item-total (and then format column as number with no decimals)
Bidder Number = wpcf-auction-bidder-number (and then format column as number with no decimals)
First Name = wpcf-first-name
Last Name = wpcf-last-name
Email = wpcf-contact-email
Phone = wpcf-contact-phone
Mailing Line1 = wpcf-contact-address1
Mailing Line2 = wpcf-contact-address2
Mailing City = wpcf-contact-city
Mailing State/Province = wpcf-contact-state
Mailing ZIP/Postal Code = wpcf-contact-zip
Mailing Country = wpcf-contact-country
Card Type = wpcf-auction-item-card-type

NEXT : go through these columns and make sure they aren’t initial lower case or all caps

NEXT: delete the items at the end that are “NOT SOLD”

NEXT: SAVE THE FILE AS A CSV

NEXT: IMPORT into NMI using Tools/CSV Importer Improved

8. COLLECT ITEMS NOT CURRENTLY AT NMI
The following is a list of people who have donated items that are not currently at NMI. Send an email to each donor to request that they get the item to NMI at some point this week.

NOTE: This won't work properly unless you have finished Step #7 above.

ALSO NOTE: Check to see if there are multiples for one person so you can group them into one email if possible.


=====================================================================================================

elise@nmi.org

NMI Auction Donation Item Request

Dear Elise Dewsberry,

We have good news - an item that you donated to our online auction has sold!

Since the item is still in your possession, we now need to make arrangements for you to get the following item either to NMI or to the winning bidder as soon as possible:

ITEM: Musical Windchime

Please email us at admin@nmi.org, or give us a call at 818-506-8500 to make arrangements for this item. (Also note that we will be available for you to drop off items at NMI on Tuesday morning and Wednesday afternoon.)

Thanks again for your support!

New Musicals Inc.
5628 Vineland Avenue
North Hollywood, CA 91601
www.nmi.org
818-506-8500



=====================================================================================================

mendivelesy1@gmail.com

NMI Auction Donation Item Request

Dear Yolanda Mendiveles,

We have good news - an item that you donated to our online auction has sold!

Since the item is still in your possession, we now need to make arrangements for you to get the following item either to NMI or to the winning bidder as soon as possible:

ITEM: DVD – THE DRESSMAKER

Please email us at admin@nmi.org, or give us a call at 818-506-8500 to make arrangements for this item. (Also note that we will be available for you to drop off items at NMI on Tuesday morning and Wednesday afternoon.)

Thanks again for your support!

New Musicals Inc.
5628 Vineland Avenue
North Hollywood, CA 91601
www.nmi.org
818-506-8500



=====================================================================================================

susanchodak@gmail.com

NMI Auction Donation Item Request

Dear Susan Chodakiewitz,

We have good news - an item that you donated to our online auction has sold!

Since the item is still in your possession, we now need to make arrangements for you to get the following item either to NMI or to the winning bidder as soon as possible:

ITEM: Books: A set of five children’s picture books by Susan Chodakiewitz

Please email us at admin@nmi.org, or give us a call at 818-506-8500 to make arrangements for this item. (Also note that we will be available for you to drop off items at NMI on Tuesday morning and Wednesday afternoon.)

Thanks again for your support!

New Musicals Inc.
5628 Vineland Avenue
North Hollywood, CA 91601
www.nmi.org
818-506-8500



9. ATTEMPT TO PREDICT SHIPPING CHARGES/PLAN BOXES

In 2016 I was told “if shipping within CA, do NOT use Priority Flat Rate boxes”

In 2017 - a regular letter with the green CERTIFICATION runs about $3.84 (could easily charge $5 instead of $8)

Small Flat Rate Box – $7.15
8 11/16″ x 5 7/16″ x 1 3/4″

Medium Flat Rate Box – (top-loading) – $13.60
11″ x 8 1/2″ x 5 1/2″

Medium Flat Rate Box – (side-loading) – $13.60
13 5/8″ x 11 7/8″ x 3 3/8″

Large Flat Rate Box – $18.85
12″ x 12″ x 5 1/2″

 

 

THERE ARE NO REMAINING ITEMS IN THIS CATEGORY