The Candleberry Company — Fundraiser Ordering

Log In

House-account customers and sales reps both log in here with their own email and password.

Create Account

Your email must match a house-account customer or sales rep on file. Contact info@candleberry.com if you can't sign up.

Select a Customer

You have 0 assigned customers.

View the order form without selecting a customer →

Select a customer or

Add New Customer

The new customer's order can be submitted but they will not be entered into the system until all the necessary documents have been received and approved by Candleberry.

Ordering for:

0 items Subtotal: $0.00 Shipping: $0.00 Total: $0.00

Main Tally Sheet(s)

Once the order is finalized, click this button to email it directly to yourself and to info@candleberry.com.

By submitting this order, we confirm all item quantities are accurate. We understand that once the Main Tally Sheet is submitted to Candleberry, no items can be added after processing.


      
    

Daily Order Export

Lists every order placed from the From date through the To date (inclusive); tick the ones you want and Download Excel exports just those: "Orders" has one row per item line (plus a SPACE row wherever the printed order shows one), "Notes" lists each customer with their order note and Substitutions answer; "New Customers" lists customers added through Add New Customer on the chosen orders, with the same columns as the Fundraiser Customer Contact List (the Notes sheet's New Customer column marks their orders). Orders are purged from this site after one month, so very old dates may come back empty.


Product descriptions for the export--upload new one if there is a change.

The export replaces each SKU in the "Item" column with its full description from your ProductsServicesList (matched on the first five digits). Upload the latest ProductsServicesList here whenever it changes — it is saved for everyone, so you only need to do this when the list is updated. Use the .csv exported from QuickBooks.

Checking...

Latest Products Upload

The site currently has … products (). Download the product list, edit it in Excel, and upload it. Each row is one product: SKU, Product name, Scent, Scent notes, Type, Product line, Season, Wholesale price, Retail price, Shipping, Order forms, Seasonal availability, Delete/Inactivate. Delete/Inactivate: put Inactivate to take a product off every order form but keep it on file (its order forms are remembered — clear the cell later to bring it back); put Delete to remove it from the site completely; leave it blank for an active product. Seasonal availability: put Yes for a product that is based on seasonal availability — the order form shows an asterisk (*) after its scent and “* Based on seasonal availability.” at the top of that form; leave it blank otherwise. Order forms lists the forms the product appears on, separated by commas: Top 10 Scents, Fresh Cargo, Kindred, Spring 2027, Fall 2027 (leave it blank to keep a product off every form). SKUs are 5 digits: the first two are the product type (40 Lg Jar, 41 Sm Jar, 42 Cookie Jar, 43 Tart, 44 Fresh Cargo, 50 Room Spray, 51 Kindred Lg Jar, 55 Kindred Travel Tin) and the last three are the scent number.

Fundraiser Pricing

Prices are set by item type. Each row's Retail Cost, Wholesale Cost and Shipping Charge apply to every product of that type (for example, Large Jar sets all … large jars). Total Cost charged to Fundraising Organization is Wholesale Cost + Shipping Charge; it is calculated, not uploaded. Shipping isn't charged if the order is picked up rather than shipped. Items not in the file keep their current prices; cabinets are priced one by one in Latest Products Upload. Fresh CarGo's retail shows on the order form as “$3 or 2/$5”.

Product Sequence Upload

The Product Sequence Required sets the order of items in order emails, Reports > Open and the Daily Order Export. The site is currently using …. Download it, edit it in Excel, and upload it.

Each row is one group, in the order the groups print; a “SPACE” line is added between groups automatically. Group is the group's name. Product types lists the product types in the group, separated by commas (the file's “Product types on the site” sheet shows the types in use). Order within group lists product lines (Pet Lovers, Kindred, …) or Reminiscent seasons (Year Round, Fall, Spring) in order, separated by commas; leave it blank to sort by product line, then name. Discounts and promotions always print last.

Sales Rep Upload

The site currently has … sales rep logins. The Sales Rep ID spreadsheet you upload becomes the whole list (Sales Rep Name, Sales Rep email address, Access, Sales Rep ID, File Maintenance). Put Y in File Maintenance for each person who may use Reports > File Maintenance; leave it blank for everyone else. The owners (ernie@, lauren@, nicole.mccane@ and sylke@candleberry.com) always have it. If the file has no File Maintenance column, everyone keeps the access they have. People who share an email, like Karen and Elizabeth, share one login.

Latest Customers Upload

The site currently has … customers. To replace the list, choose in QBO Custom Reports/Fundraisers--Customer Contact List-Ernie. You'll see a summary of the changes before anything is saved.

The columns Customer full name, Phone numbers, Email, Bill address, Ship address, Sales Representative and Terms are used when present (a column that is missing leaves those details unchanged). Customer full name is required. Deleted customers (marked “(deleted)” in QuickBooks) are not included.

Reports

Recent Orders