Reseller On The Web
Administration
Pricing
Options
Hosting
Options
Reseller on the Web Hosted by
ResellerAdvantage.com or an ISP
ResellerAdvantage.com can provide a turnkey solution to host
your web site with Reseller on the Web. We will provide the web server, the
Internet connections, the set up and configuration, the database integration and
the on-going maintenance.
Since the web server is located away from your business site
in this scenario, a copy of your Reseller Advantage database is needed to run
Reseller on the Web. The best way to keep your local Reseller Advantage database
synchronized with the hosted Reseller on the Web database is to use the
replication tools available with your Database Management System (DBMS). Data
replication will ensure that orders and product update changes from the Reseller
on the Web database are transferred to your local Reseller Advantage database.
Likewise, any new users, product attachments or other changes from your local
database are transferred to the hosted database.
In this hosted scenario, the periodic data downloads from
vendors should also be coordinated between your local database and the hosted
database. If you prefer to run the product loads from your local Reseller
Advantage database, you can then replicate the changes to the hosted database.
Otherwise, ResellerAdvantage.com can run the product loads for you on the hosted
database. You can then replicate the changes to your local database so that you
don't have to bother with the product loads at all.
When data is downloaded from your vendors and the products
are loaded into either the local or hosted database, a "mapping" should be done
as part of the database maintenance. Any changed product categories or
manufacturer names should be matched or "mapped" if possible to existing
categories or manufacturers already in the system. Any new categories or names
are added. This maintenance must be done on the same database from which the
product load is done. Therefore, if you have designated the product loads to be
done by ResellerAdvantage.com, we will also do the mapping maintenance for
you.
Go Back
Reseller on the Web Hosted by You
If you choose to host your own web site with
Reseller on the Web, then you only need one copy of your database and there is
no need for replication to synchronize copies. Reseller on the Web can access
the same copy of the database that your in-house users of Reseller Advantage
access. It is assumed that you have an adequate Internet connection available to
your place of business.
It is possible to use one server for your DBMS with your
database, Reseller Advantage, your web server and your web site with Reseller on
the Web. However, for web sites with any amount of significant traffic, you
improve web site performance by putting your web server and Reseller on the Web
on one machine and your DBMS along with your database and Reseller Advantage on
another machine. In this configuration, Reseller on the Web can still access the
Reseller Advantage database.
When data is downloaded from your vendors and the products
are loaded into your database, a "mapping" should be done as part of the
database maintenance. Any changed product categories or manufacturer names
should be matched or "mapped" if possible to existing categories or
manufacturers already in the system. Any new categories or names are added. In
this scenario, since the product loads are done in-house from Reseller
Advantage, your web site automatically accesses the changes in the
database.
Go Back
Reseller On
The Web Installation Instructions
- From your start menu -> Programs go into Windows
Explorer. Click on your CD ROM drive this allows you to view all files and
folders on the CD currently in the CD drive. Double click on the folder named
web.
Before running the installation program for Reseller on the
Web, please make sure that you have these four files together in the same
directory:
- Setup.exe
- Purchasing.cab
- Setup.lst
- Web_XX.zip (Where "XX" is the Reseller on the Web version
number)
- In Windows Explorer, double click on the "setup.exe" file
to run the installation program.
- When prompted, if you installed Reseller Advantage in a
directory other than " C:\reseller " then change the install directory from "
C:\reseller " to the directory that Reseller Advantage was initially installed
into.
- Create a sub-directory called "web" within the directory
that Reseller Advantage was installed into. (e.g. "C:\reseller\web")
Please Note:
You can also create this directory
off of your web root directory as well.
- Unzip the Web_XX.zip file and extract all the files
contained within the Zip file into the "web" directory you just created.
- Start up Microsoft Internet Information Server and create a
web site that points to the web directory created above. Make sure the site has
execute security.
- Start up Reseller Advantage and look to see if
there is a user in the system with a login ID of "GUEST" and a password of
"GUEST". If you don't find this user, add it.
NOTE: This login and password MUST be entered into Reseller
Advantage for Reseller on the Web to work properly, even if you only want to
allow visitors with a valid login ID and password into your
site.
- On the web server, make sure there is a system ODBC
(open database connectivity) entry with a data source name of "sfaservr" which
points to your Reseller Advantage database. If you don't find one, create
one.
- In order to have the web connect to the proper
database, please do the following:
- Start up Reseller Advantage.
- When the Login window appears, double click on the Reseller
Advantage logo in the top half of the Login window.
- Enter the password to open the Database Sign On Maintenance
window (the default is "guest").
- On the left side of the Database Sign On Maintenance window
in the Server Database section, enter the Data Source name (the ODBC entry) that
points to the Reseller Advantage database, the Sign On ID and the Password for
the database. Set the Date Format to the proper setting for your
database.
- Click "OK" to accept your entries and close the Database
Sign On Maintenance window.
- Close down Reseller Advantage.
- In Windows Explorer, locate the file named "sfauser.pro" in
the directory that Reseller Advantage was installed into. Make a copy of it (do
not move it) and paste it into your System directory which is typically
"Winnt\System32"
You are now ready to configure Reseller on the
Web.
Go Back
Reseller On The Web
Configuration
System
Requirements
Operating
System
Reseller On The Web runs on an NT 4.0 Server with IIS 3.0 or
4.0 installed and is accessed via Internet Explorer 4.x or Netscape Navigator
4.x. Reseller On The Web accesses the database via ODBC drivers installed on the
web server.
Database Management
System
Reseller On The Web does not come with a database management
system but instead utilizes any ODBC compliant database such as MS SQL Server or
Sybase SQL Anywhere. The ODBC compliant DBMS resides on a server, usually an NT
Server, and stores data used by Reseller On The Web.
Go Back
Configuring the Registration Request
E-Mail
The "Order Now" button confirms the order and sends 2
e-mail's via SMTP using an SMTP OCX from Distinct corporation. If the distinct
DLL's are not registered correctly or if the serial number and key code have not
been entered on this machine the Order Now may give an error or may not work.
You can download the runtime DLL's and the install program from http://www.resellerontheweb.com/ftpfiles/download/VIT401dRT.EXE.
Run this on your web server to install and register the distinct runtime DLL's.
This should have happened with our install but sometimes they do not register
correctly.
Go Back
Custom Web Settings
There is a directory under your Reseller on the Web
directory called Settings. You will find several INI and INC files in that
directory. These files are where you customize the text for your site. Each INI
file contains 1 line with the setting string in it. The INC files contain code
that needs to be modified for your site. The code to modify is enclosed in the
/* CHANGE THIS! */ comment. To modify these files, just double-click them and
make the change in Notepad. The descriptions of these Settings files are as
follows:
|
File Name |
Description |
|
cartjs.inc |
Contains the address to the SSL URL (Secure Socket Layer) for gathering
customer information. |
|
connect.ini |
Contains the ODBC connect string for accessing the database.
- Initial Catalog: Specifies the Database Name (NOT DSN NAME).
- Data Source: specifies the Server Name.
|
|
continueshop.inc |
Contains the web address to get out of SSL. |
|
desccontains.ini |
Contains the search method used when searching for products. FT means it is
doing a Full Text search (Valid only for SQL Server 7.0). |
|
email.ini |
Contains the email address for technical support questions. It is on the User
Login page. |
|
emailfrom.ini |
Contains the email address for the person that appears in the order
confirmation email. |
|
emailservice.ini |
Contains the email address for order problems and questions. It is on the
Order Confirmation page. |
|
freight.inc |
Contains the code used to calculate the freight costs. |
|
http.ini |
Contains the web address to get out of SSL.
Make sure your address ends with a back slash. |
|
https.ini |
Contains the address to the SSL URL (Secure Socket Layer)
for gathering customer information.
Make sure your address ends with a back slash. |
|
logging.ini |
Used for debugging. Should have a 0 in the first line for a live
site. |
|
mailserver.ini |
Contains the address to the SMTP mail server. |
|
mailtemp.txt |
Contains the email template that is sent out on all order
confirmations. |
|
name.ini |
Contains the name of your store. |
|
phone.ini |
Contains the phone number for your store. |
|
salesrep.ini |
Contains the default Sales Rep name if a Sales Rep isn’t
found. |
|
Searchpost.ini |
Contains the search string that gets appended on to all Description Contains
searches. The default is *. |
|
storeimg.ini |
Contains the file path/name for your store’s logo. |
|
storewww.ini |
Contains the URL for your store. |
|
userpro.ini |
Contains the file path/name for your store’s user
profile. |
There is another directory under your Reseller on the Web directory called
Custom. You will find a couple INC files in it. These are used to append to the
end of the Navigation Table on the left and also the Main page for the site.
These files can be used to place copyright info, banners, security services you
are registered with or any information you wish to provide to your visitors. If
Reseller Advantage.Com hosts your site, this directory will be setup with FTP
access.
|
File Name |
Description |
|
bottom.inc |
Contains the HTML that will be used to append to the bottom of the Main
page. |
|
nav.inc |
Contains the HTML that will be used to append to the bottom of the left hand
navigation bar. |
Go Back
Customizing your Reseller on
the Web site
You can readily modify and customize Reseller on the Web
because it is built with industry standard HTML and Active Server Pages (ASPs).
The ASPs utilize our proprietary business logic components, which are compiled
ActiveX DLL files that reside on the web server.
All the pages within Reseller on the Web are formatted into
two frames. A smaller frame or pane across the top is designed to be a
consistent space for displaying your company logo, banner ads, or links to
integrate other parts of your web site such as contact pages, policy and privacy
pages, FAQ pages, etc. The lower pane provides all the site functionality for
Reseller on the Web and is completely separate. With this format it is very easy
to integrate your existing web site with or build a new web site around Reseller
on the Web.
Go Back
A self-hosted or third party
hosted web site
If you host your own site or have a third party host your
site, you have direct access to all the HTML and ASP pages. With any common web
page editing tool, you can make modifications to meet the needs of your web site
visitors or to suit your own preferences.
Go Back
Your web site hosted by
ResellerAdvantage.com
If we host your site, you can perform basic
administration tasks such as configuring Sale Items and manufacturer logos by
logging onto the site with your User Profile that has System Administration
rights. In the near future you will also be able to maintain Accounts, Contacts,
Users and Pricing Profiles from the site.
For other modifications and customizations in this hosted
scenario, we will work with you to configure the site to meet your
needs.
Go Back
Reseller on the Web
Administration
Web site administration and
security
NOTE: To perform Reseller on the Web administration tasks
you must log onto the web site using a Reseller Advantage Logon ID and Password
that has "System Administration" rights. I.e. The User Profile must have "Access
Rights" enabled for "System Administration" in the "Reseller Advantage Security"
window.
To give a User Profile the ability to perform Reseller on
the Web administration tasks:
- Log onto Reseller Advantage with a User Profile that has
System Administration rights.
- Click on the "Contacts" tab from the main Reseller
Advantage window.
- Enter the last name in the "Last Name" field for the
Contact (User Profile) that you want to perform Reseller on the Web
administration tasks. Click the "Search" button.
- From the list of contacts displayed, double-click on the
appropriate Contact to open the Contact Processing window.
- Click on the "External Systems" tab.
- Click on the "Reseller Security" button to open the
"Reseller Advantage Security" window.
- In the "Access Rights" section, enable the "System
Administration" selection. Click "OK" to accept your changes and close the
Reseller Advantage Security window.
- Close the Contact Processing window and click the "Yes"
button to save your changes.
To perform Reseller on the Web administration
tasks:
- Go to your Reseller on the Web web site. At the top of the
Navigation bar on the left side of the page, click on the "User Log In"
link.
- Enter the Logon ID and Password that has System
Administration rights, then click the "Logon" button.
- Scroll down to the bottom of the Navigation bar on the left
side of the page. If you have successfully logged onto the web site with
administrative rights, you will see the administration links "Sale Items", "Mfg
Links", etc. below the "Tips" link. If these administration links do not appear,
the Logon profile you used does not have System Administration rights in
Reseller Advantage. Go back and perform the previous exercise "To give a User
Profile the ability to perform Reseller on the Web administration tasks".
Go Back
Web site visitors and on-line
registration
The default configuration for your Reseller on the Web web
site automatically assigns the GUEST user profile to all visitors. Guest users
can register for their own User ID and Password by clicking the "on-line
registration page" link from the User Login page.
When a visitor fills out the on-line registration form and
clicks the Submit button, an e-mail with the registration information is sent to
the person from your organization whom you designated during the setup process.
The recipient verifies the registration information, and then starts the
registration process.
Starting the registration process
- Log onto Reseller Advantage with a User Profile that has
Contact Processing rights.
- From the main window in Reseller Advantage, click on the
"Contacts" tab.
- Enter the last name for the registrant in the "Last Name"
field and click the "Search" button.
If a Contact entry for the registrant DOES display in the
list of Contacts, proceed to the next section. If the registrant DOES NOT appear
in the list of contacts, go to the section "Registering a web site visitor who
does not have a Contact entry in Reseller Advantage".
Registering a web site visitor who already has a Contact
entry in Reseller Advantage:
- Double-click on the appropriate Contact from the list of
Contact displayed to open the "Contact Processing" window.
- Click on the "External Systems" tab.
- Click on the "New" button to create a new system entry in
the "External Systems" section.
- Click on the blank "System" field for the new entry and
click on the list box arrow to display the available selections for the field.
Click on "Reseller-Advantage" in the list and make sure it is entered into the
System field.
- Enter a "Sign-on ID" and a "Password" in the appropriate
fields to create a User Profile for the Contact.
- Close the Contact Processing window and click the "Yes"
button to save your changes.
Registering a web site visitor who does not have a Contact
entry in Reseller Advantage:
- Click the "New" button on the Contact tab to open the
"Contact Processing" window.
- Enter the registrant's general information such as name,
company and phone number in the appropriate fields across the top of the
window.
- On the "Key Information" tab, enter the address information
and the e-mail address for the registrant.
- Click on the "External Systems" tab.
- Click on the "New" button to create a new system entry in
the "External Systems" section.
- Click on the blank "System" field for the new entry and
click on the list box arrow to display the available selections for the field.
Click on "Reseller-Advantage" in the list and make sure it is entered into the
System field.
- Enter a "Sign-on ID" and a "Password" in the appropriate
fields to create a User Profile for the Contact.
- Close the Contact Processing window and click the "Yes"
button to save your changes.
Your web site visitor is now registered in the system. You
can send the registrant an e-mail confirmation with the Logon ID and Password.
When the visitor logs onto the site:
- He/she will be able to save baskets.
- His/her default Bill To and Ship To addresses will
automatically be filled in for any on-line orders.
- The prices that the visitor sees on the web site will
reflect the appropriate Pricing Profile.
- The visitor's baskets and orders will be associated with
the sales person assigned to that Account in Reseller Advantage. The baskets and
on-line orders will show up as Deals and Sales Orders in Reseller Advantage so
that the sales person is aware of the on-line activity and can take any
appropriate follow up action.
Go Back
Assigning Pricing Profiles for web site visitors,
shopping carts and on-line Orders
The pricing profiles used by Reseller on the Web
are the same as those used by Reseller Advantage. If a Pricing Profile is
assigned to an Account in Reseller Advantage, all Deals started for that Account
or any of the Contacts associated with that Account automatically inherit the
Pricing Profile. Likewise, if a web site visitor logs on and the User profile is
associated with an Account, the Pricing Profile for that Account will be applied
to any shopping cart or on-line order that the visitor initiates.
On-line Order processing
The default configuration for your Reseller on the Web web
site allows the general public to access the site and place orders. If you
prefer, you can restrict access and ordering to only those visitors with
registered Logon IDs and Passwords.
When processing an on-line order, the system will
automatically fill in the default Bill To and Ship To information for registered
visitors. Visitors with a Guest Profile will have to enter this information for
each order.
The system will verify the number sequence for a specific
credit card type and reject bogus numbers. Actual credit card authentication and
fraud detection is not included in the standard product, but can be purchased
separately from third party vendors.
When all required fields on the Check Out page are entered
and verified, and the Confirm Order button is clicked, the on-line order is
saved into the database and a receipt page with an Order Number is displayed.
The Terms and Conditions on this page should be modified to meet your
requirements.
When an on-line order is confirmed, two e-mails containing
all the Order information are automatically generated - one to the visitor who
created the order and one to the sales person associated with the Contact's
Account in Reseller Advantage. Customers can track orders and review order
details by logging on to the web site, clicking on the "Order Status" link,
entering the Order Number or other order information and clicking the Search
button.
Go Back
Featured sale items
You can configure your Reseller on the Web web
site to display featured sale items. A picture, description, price, part number
and an "Add to Cart" button can be shown for each sale item. An item assigned to
the "General" category will appear on the default product search page. Items
assigned to specific categories or manufacturers in the system will appear on
the respective product search pages as visitors work their way through product
searches. The system can also be configured to display different sale items
depending on the search parameters that a visitor enters.
Go Back
Selecting
and adding featured sale items to specific search pages
- Log on to the web site with a User Profile that has System
Administration rights.
- Use the system as if you were shopping to find the
product(s) you want to feature as sale item(s). I.e. Search on the Product
Categories, Manufacturers, or part numbers in the system to display a list of
products. Click the "Add to Cart" button for the product(s) to be designated as
sale items.
- Scroll down the Navigation bar on the left side of the
window and click the "Sale Items" link at the bottom of the pane to display the
Sale Items page. The product(s) you added to your cart will appear in the
list.
- Select where you want the sale item(s) in the cart to be
displayed by selecting the Product Type, Category, or Manufacturer. For
instance, if you want the sale item(s) in the cart to appear when your customer
searches in the product category "Computers and Terminals", select "Computers
and Terminals" from the "Product Type" list box on the Sale Item page. Click the
"Assign" button to enter this configuration.
To see how your sale item(s) look, click the "Home" link at
the top of the Navigation bar and click on the Product Type, Category or
Manufacturer links to navigate to the search page you assigned the sale item(s)
to. The sale item(s) should appear on the search page below the list of product
categories.
Go Back
Viewing and
removing featured sale items
- To view the sale items that are currently featured for a
specific page, click the "Sale Items" link at the bottom of the Navigation
bar.
- Select the specific search page that the sale items
are configured to display on by using the list boxes to select the appropriate
Product Type, Category or Manufacturer.
- Click the "View" button and the list of sale items that are
currently being featured on that search page will be displayed. (Note that the
list of featured sale items will replace any items previously in the list
or cart.)
- To remove a featured sale item from the specified page,
click the "Remove" button for the appropriate item in the list.
Go Back
Adding
pictures for featured sale items
For each featured sale item on your web site, you can
display a related picture by using Reseller Advantage to associate a ".jpg" or
".GIF" file Attachment with the sale item product.
For each sale item that you want to display a picture
for:
- Start Windows Explorer.
- Locate the image file (.jpg or .GIF file) that you want to
use.
- Place a copy of the image file you will be using in the
"images" subdirectory of the directory where the Reseller on the Web files are
located. (The default directory to place copies of your image file is
"C:\reseller\web\images" as the default location for your Reseller on the Web
files is the "C:\reseller\web" directory.)
- Start up Reseller Advantage and log on with a User Profile
that has Attachment Administration rights.
- From the main Reseller Advantage window, click on the
"Attachments" tab.
- In the "Type" list box, select "Small Picture", and then
click the "New" button to display the "Attachment" window.
- Enter a name for the image file in the "Name" field
and a description in the "Description" field.
- Enable the "Point to File" selection and then click the
"Browse" button.
- In the "Open" pop up window, navigate to the "images"
directory where you placed a copy of the image file, click on the specific image
file for the picture you want, then click the "Open" button to accept your
selection and close the Open window.
- In the Attachment window, make sure that the file you
selected appears in the "File Name" field.
- Click on the "Associated Products" tab, and then click the
"Assign" button.
- In the "Assign Products" window, search for the
featured sale item that you want to link the image to. Highlight it, click the
"Assign" button and then click the "OK" button to accept your selection and
close the Assign Products window.
The image you associated with the product should now be
displayed on your web site whenever that product is selected as a featured sale
item.
To check your configuration:
- Go to your Reseller on the Web web site and log on with a
User Profile that has System Administration rights.
- Click on the "Sale Items" link at the bottom of the
Navigation bar.
- Select the Product Type, Category and Manufacturer for the
search page that will display the featured sale item for which you associated a
picture.
- Click the "View" button below the Manufacturer field to
display the featured sale items for that page in the cart list.
- From the list of sale items, click the "View" button for
the sale item that you associated the picture with. The image should appear
towards the bottom of the window.
- Click the "Home" link on the Navigation bar.
- Navigate to the search page that will display the sale item
that you associated the picture with. The image should appear below the sale
item.
Go Back
Displaying logos for manufacturer
You can help visitors with product searches and
improve the look of your web site by displaying logos for manufacturers at the
bottom of your product search screens.
Associating a logo to a manufacturers' Account in Reseller
Advantage
You can display a logo for a manufacturer by using Reseller
Advantage to associate a ".jpg" or ".GIF" file Attachment with the
manufacturer's Account.
For each manufacturer that you want to display a logo
for:
- Start Windows Explorer.
- Locate the image file (.jpg or .GIF file) that you want to
use.
- Place a copy of the image file you will be using in the
"images" subdirectory of the directory where the Reseller on the Web files are
located. (The default directory to place copies of your image file is
"C:\reseller\web\images" as the default location for your Reseller on the Web
files is the "C:\reseller\web" directory.)
Note: A few sample logos were included along with your Reseller on the Web
files. These logo files should already be in the "images" directory.
- Start up Reseller Advantage and log on with a User Profile
that has Attachment Administration rights.
- From the main Reseller Advantage window, click on the
"Attachments" tab.
- In the "Type" list box, select "Company Logo", and then
click the "New" button to display the "Attachment" window.
- Enter a name for the image file in the "Name" field and a
description in the "Description" field.
- Enable the "Point to File" selection and then click the
"Browse" button.
- In the "Open" pop up window, navigate to the "images"
directory where you placed a copy of the image file, click on the specific image
file for the logo you want, then click the "Open" button to accept your
selection and close the Open window.
- In the Attachment window, make sure the file you selected
appears in the "File Name" field.
- Click on the "OK" button to accept your entries and close
the Attachment window.
- In the main Reseller Advantage window, click on the
"Accounts" tab, enter the name of the manufacturer to associate the logo with
and click the "Search" button.
- From the list of displayed Accounts, double-click on the
appropriate Account to open the "Account Processing" window.
- Click the "Attachments" tab for the Account and then click
the "Assign" button to open the "Find Attachments" window.
- Select "Company Logos" In the "Attachment Type" list box
and click the "Search" button.
- From the list of Company Logo Attachments displayed,
highlight the correct logo to associate with the manufacturer by clicking on it.
Click the "Assign" button and then the "OK" button to accept you entries and
close the Find Attachments window.
The file for the manufacturer's logo should now appear in
the list of Attachments for the manufacturer's Account.
Adding and removing logos from your search pages on your web
site
- Go to your Reseller on the Web web site and log on with a
User Profile that has System Administration rights.
- Click on the "Mfg Logos" link at the bottom of the
Navigation bar.
- Select the Manufacturer that you assigned a logo to in
Reseller Advantage from the Manufacturers list box and click the "Assign"
button.
- A list of all the manufacturers with logos that will appear
on your search pages is displayed in the list.
- To remove a logo from the list, click the "Remove" button
for that manufacturer.
Go Back
NFR
(Not For Resale) Products
Specifying items as NFR will remove them from your online catalog, and
therefore will ensure that your customers cannot accidentally order these items
from your website.
- Start up the ResellerAdvantage software (not the website). From the main
screen, click on File, Administration, Move Products. You
must be logged in as an administrator to do this.
- Select the products you want to make NFR using one or more of: manufacturer,
category, and part#. Click Search.
- The products you selected are displayed in the grid. Click on the line items
that you wish to make NFR.
- When you have selected (highlighted) the line items that should be NFR,
click the Do Not Show On Web button. These products are now removed from
your online catalog.
- If you wish to make an entire category of products NFR, simply right-click
on the category at the left and select Do Not Show Category on Web.
- If you wish to make all the products for a manufacturer NFR, simply select
the manufacturer from the drop-down list. Right-click on the manufacturer and
select Do Not Show on Web.
NOTE that the same
process is used to 'undo' NFR products, or make them catalog items by selecting
the Show On Web option instead of the Do Not Show on Web
option.
Go Back
Pricing
Options
ResellerOnTheWeb offers you several options for configuring
the prices that your customers see. You can specify custom price profiles for
customers based on categories, manufacturers, or even specific part numbers.
Then, you can further customize your pricing strategy with vendor comparisons of
price and availability.
Go Back
Customer Price Profiles
ResellerOnTheWeb allows you to specify
customized pricing profiles for different customers based on product category,
manufacturer, and even specific part number. You may choose from gross profit or
markup, as well as specify effective dates so that the pricing will expire. To
set up pricing profiles, start up your ResellerAdvantage software, and from the
File menu, point to ‘Price Profiles’.
Go Back
Vendor Pricing
Since you procure inventory from multiple sources,
ResellerOnTheWeb allows you to base pricing on the highest, lowest, or average
price that YOU pay. For example, if you buy widgets from Ingram at $9.50 per
widget, TechData at $10.00 per widget, and Pinacor at $10.50 per widget, your
uplift-based pricing could vary depending on which cost you use.
ResellerOnTheWeb allows you to base your pricing on either the highest, lowest,
or average cost you pay. To do this, start up your ResellerAdvantage software,
and from the file menu select administration, then point to ‘ListBox Items’. On
the left side of the screen, scroll down to the table called ‘System Variables’,
and click on it. On the right side of the screen, look for an entry whose short
name is ‘BESTPRC’. (If it’s not there, add it using the ‘New’ button.) In the
long name, enter ‘HIGH’, ‘LOW’, or ‘AVG’ in capital letters. If you chose high,
your customers’ widget pricing will now be based on a cost of 10.50. If you do
not have this option set, the default of HIGH will be used.
Go Back
Vendor Availability
In addition to specifying high, low and average cost to base
your customer pricing, ResellerOnTheWeb can also limit pricing to vendors with
availability (qty available > 0) for that product. Using the example above,
assume you have bestprice set to high, but Pinacor has no availability for that
product. You may not want to use their cost since you cannot source it from
them. From the system variables screen described above, find the entry whose
short name is ‘HAVEONLY’ (if it’s not there, add it using the ‘New’ button). In
the long name specify ‘TRUE’ or ‘FALSE’ in capital letters. True means use only
vendors who have availability, false means do not take availability into
consideration. In our example, with bestprice set to HIGH and HAVEONLY set to
true, the Pinacor cost would not be used. The TechData cost, which is the next
closest, would be used instead.
Go Back
