RQ4 Import Proceedure

Dearest Trax Client,
We are excited to announce the import functionality with RQ4 has been completed. Once you have gone through the one time set up then it takes only a moment to import your sales data into eTRAXsales.com each week. When you do Trax will provide you an Analytics platform (over 20 unique reports that are designed to help you dramatically improve sales and profitability).
This import should only take a few seconds to complete once you are set up but we will also be providing full API connectivity shortly.
Currently you will receive:
• Automatic emails of conversion ratios for each location,
• Profit Revenue averages for each customer that visits a location (if they purchased or not) with overall comparisons for the entire company.
• And the most amazing goals program ever invented for the wireless industry.

Open Your RQ Reports Module

RQ Reports Module

Locate Product Detail Report, by typing Detail in your search bar in the top right.

Product Detail Report

Then Choose Categories


RQ4categories

From Here we want to set up the Inventory Tree

Inventory tree

Then select all of your showrooms that have the TRAXsales Traffic Counter

Showroom select

Then Select the date range you want to import and hit [Run Report].

RQ4 select date range

Finally right click the top bar creating the edit drop down so you can remove the columns you do not need. Just un-check


RQ4 rightclick

Make sure only these 7 items are selected.


RQ4 select these 7

Finally select the Excel Button on the top right and your report is created.

RQ4 Excell button

Once you have the report set up the way you want it then go to the top left and select Add to Custom Reports and Call this new report Export to TraxSales and RQ will save all of your preferences so that all you need to do next time is select the date range you want.

RQ4 name your report

Once you have the finished Excel report then save it to a folder of your choice or your desktop so you can Import into eTRAXsales using the IQ Metrix Conversion Tool that is located here.
http://media.traxsales.com/TRAX.iQMetrix.exe
Please call 713.466.7177 if you have any questions. Select Browse and find the file you just created, then select Convert File. It will then create a new file on your desktop to be uploaded into eTRAXsales.

RQ4 IQmetrix

#3. Most importantly set up import of sales data. First find the report in your POS that gives you these five things Showroom ID, Salesperson ID, Date (by day), Sales Amount, # Transactions and save this in a CSV or Excel file on your desktop.

RQ4 import mapping

Example of an actual Excel file ready to import.

RQ4 Example export

Then please select Import RPG. Once set up this should take no more than 20 seconds.

RQ4 click to import

If you have any questions or problems with this please do not hesitate to call us immediately. 713.466.7177.
Our email is support@traxsales.com and we look forward to your feedback.
This is the most important part of the program and will insure that you will be delighted with this system for many wonderful years to come.

Verified by MonsterInsights