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.

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.


customize rankings

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

excel imports1



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.

excel imports4


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.

excel imports9




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

excel imports6




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.

excel imports 7






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.

excel imports8

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!

bulk update profile rating


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.



schedule report1




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.

schedule 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.

schedule report4



The example report below will run every day @ 11:59 PM forever, analyzing sales ordered on that day.

schedule report6



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.

schedule report7



On the report page, click “maintain schedule reports” to delete or edit existing scheduled reports.

schedule report5