use the smiley icon to insert emojis
you can also copy and paste from alternate sources. e.g.; http://emojipedia.org
ref: the real scoop on email emoji in subject lines
embed emojis in eblast subject-lines
Bulk Updating of Market Call (Phone) icons
Bulk update your Market Call (Phone) icons…
– complete the following form to authorize a specific userId/rep from your team
– once enabled you can filter by a specific Market Call (phone) icon 1st and next use the “time-bomb” icon to select and assign the new color – see attached/embedded screenshot below
Complete the following form…
BULK Update Order Reps and Commissions
bulk update your Rep and Commission assignments for Orders.
once the bulk update is executed, it cannot be undone.
to authorize a member of your team to access the BULK update feature, please email help@showroomexchange.com with the subject line “Authorize {userId or team-member-name} for Order Reps and Commissions BULK Update”
the feature is accessed (from the order tab) as an icon next to the rep column that is filtered.
it functions in 2 modes:
“Override all rep/comm fields with the following selection”
this will update all orders in your current search criteria based on the assigned values and regardless of their existing values..
“Override the comm value for the Selected rep column”
this will ONLY update the comm value for all orders in your current search criteria based on the rep column selection. e.g.; from the following below screenshot, if rep1 is selected, then 2% will be assigned to all comm1 field for the current filtered/displayed orders.
to finalize the bulk update, you must 1st click the “export current list” button, which will download a (pre-bulk-update) backup copy for future reference. once the file has downloaded and you have reviewed it, click the Proceed button to process the bulk update.
Schedule your eblasts (PBEs)
You can now schedule your eblasts (PBEs)…
After sending the Test, use the orange [Send On] button to assign a date & time.
Once scheduled, use the “Scheduled PBEs” option from the customer tab to make changes to scheduled eblasts.
a new checkbox, a new function – use the customer tab search result for reports
the new “use the customer selection from customer tab/view” checkbox that has been added to reports that have customer selection allows you to run reports using the current customer selection.
here is the process…
– visit the customer tab/view
– apply any filter(s), e.g.; by state, territory etc.
– go to the reports tab
– select a customer based reports, i.e.; reports that have a customer selection drop-down
– click to select the new “use the customer selection from customer tab/view” checkbox
the report will be generated using the customer selection from the customer tab/view
Customize Rankings
Admin users now have the ability to rename the default labels for the Ranking feature.
Now you can customize the purpose of the ranking feature while making its meaning clear to your whole team.
To customize your Ranking labels, click on the pencil next to “Ranking” at the top of the ranking column (as shown below). Enter your own labels and click save.
Import Excel Orders/POs Add-On
We’ve released a new add on that will allow showroom reps/users the ability to bulk import orders from excel sheets.
By entering your orders on an excel sheet, you not only save paper and make your business “greener,” but you can save time by not having to re-enter all of the information again into Showroom Exchange! Much like the Joor/NuOrder Import Module or the Invoice Import Module, you can import a large number of excel files at once, saving you time.
Once the feature is activated, go to the reports tab to import Excel Order Files
The following page is where you can select your Excel file or .zip file of multiple Excel files to import into Showroom Exchange.
A template of a PO Excel sheet is provided for your convenience, select the “Click Here” link to download the sample template file.
Below is the template Excel Order File that downloads when you click the link:
Excel Order Template
You can customize the Excel file for your showroom. you can change the logo, change the layout, etc.However ALL NAMED cells must also be included in your custom version. You can move these cells around, just make sure the name stays the same.
To be clear, the NAME of a cell is different than the value entered in the cell.
See the image below for a list of all of the cells with assigned names, as well as an example of a name in Excel.
Note: In the grid that contains the actual order, we use Excel mathematical equations to provide a unit total and an amount total to import into SE.
Once you have imported an excel file or a .zip file of Excel files, you will be taken to the page depicted below to verify your customer information and fill in any information that might have been missing from the Excel PO.
1) If the system is not recognizing a customer that is already an existing customer, select the “Assign” option to link the row to an existing customer.
2) “Map” means that this aspect of the customer has yet to be assigned. Click “Map” to select the correct value for the customer. If you try to save the customers and you see the warning “Please map customer data,” this suggests that there are still unassigned/missing values for the respective customer row.
3) Click “List Orders” to go to the next page
The order edit page is very similar to the previous page- here you can make edits, as well as add info that might not have been on the Excel PO, e.g.; rep, commission etc. Here too, you’ll find the “Map” option if something is missing on the excel order. If you can’t process the orders when you click “Import Orders,” look at the column on the far right to see an explanation as to why the order could not be imported. Make the edits to then properly save the orders.
After clicking “Import Orders”, you’ll be taken to a confirmation page where you can see if your orders and customers were imported or not.
Waze Your Road Trip with Showroom Exchange
Showroom Exchange’s driving directions feature now has an option to send your trip plan to your Waze app!
Waze is a GPS-based navigation app for smartphones which provides turn-by-turn information and route details
Select the customers you want to visit as you normally would in the driving directions app (visit: http://blog.showroomexchange.com/the-new-and-improved-driving-directions/ for more info). Rather than clicking on “display route,” click on “waze it.”
An email will be sent to you. Open it on your smart-phone and it will look something like this…
Each link represents a different customer location. Click them one at a time to open the location in your Waze app.
Update “Profile” and “Rating” in Bulk
If you ever need to change the “profile” or “ratings” field for multiple customers, you can do so quickly by editing those fields in bulk.
Click on the “bomb” icon next to either “rating” or “profile” to revise the contents of the respective column. The feature will edit the profiles of the customers that have been pulled-up by searches and filters, not the entire customer base.
The entire customer base WILL BE updated if no filter (search-criteria) has been entered.
There are three kinds of edits you can make:
– Find and Replace: Look for existing content and replace it with a new one.
– Replace Entire Field Contents: Replace the entire field, regardless of its current content.
– Clear All: Clear fields of all selected customers.
Click “Proceed” to save your edits.
Why the “bomb” icon?
There is no UNDO button!
Report Scheduling Reincarnated
This is a major improvement of our Report Scheduling tool.
What makes this special is the ability to use “relative dates” (aka. Multiple Periods), e.g.; Schedule a report “ONCE” to run (indefinitely) at the 1st of every month for the period of the preceding month.
Showroom Owners & Managers:
Relieve your reps & assistants from the task of generating reports for you on regular intervals. Showroom Exchange can do this for you.
You can now schedule automated reports within Showroom Exchange. Configure the settings once and have your reports emailed to you daily, weekly or monthly. The reports will be emailed to the address saved in your settings page. They will include a PDF and CSV/Excel link.
To schedule a report, enter report criteria/filters, then at the bottom of the report, click the “schedule this report” button.
Note: to use relative dates, date criteria entries are not considered for scheduled reports.
In the following pop-up, enter the title of the report (subject line of your email), then select the interval (frequency) of how often/how many times you want to receive the report.
Daily, Weekly, and Monthly reports become more detailed as you can choose to make them examine a static period or multiple periods (relative dates).
Selecting a static period means that the reports will examine the same date range (either order date or cancel date) every time a report is run. This is not the preferred date-criteria selection as the same period will be considered for the report over and over again. e.g.; a report scheduled to analyze Jan 2014 generated in Feb 2014 or anytime in the future, will always consider Jan 2014 as the date filter.
With Multiple Periods, every time the report is generated, it will examine a different date range based on the interval and period you select. For example, if you schedule a recurring Daily report for 9 am, with multiple periods, looking at the “Previous period”, you will receive reports that analyze the previous day. i.e.; you arrive at your desk to find yesterday’s activity in your Inbox.
There are more examples below for Daily, Weekly, and Monthly scheduled reports.
The report below is configured to run on Mondays and Fridays of every other week, analyzing sales with cancel dates in the following week. It will run ten times before stopping.
The example report below will run every day @ 11:59 PM forever, analyzing sales ordered on that day.
In the example below, the report will be generated on the first of every third month until 12/31/15 and will analyze sales with cancel dates in the previous month.
On the report page, click “maintain schedule reports” to delete or edit existing scheduled reports.
