
If a vendor distributes a new price sheet in an Excel spreadsheet, then there is a good chance that you will be able to import the products and prices in OrderWiz and it will not require any special programming.
In order to be able to use this feature, you must remove any formatting from the spreadsheet.

Also, all product ID’s, product descriptions, price, quantity break, etc. must be in their same column.
Extraneous rows and columns can often be removed using this feature.
|
Feature |
Description |
|
Removing Extraneous Rows and Columns |
Extraneous rows and columns can often be removed using this feature. The removal is done in memory, thus not affecting the source Excel spreadsheet. |
|
Product Added |
Products not already in OrderWiz are simply added. |
|
Product Descriptions Updated |
You can choose to update the product descriptions on products already in OrderWiz. |
|
Duplicate Entry Handled |
Duplicate products are detected. If all of the information is the same, then the second and subsequent entries are ignored. If different, then all entries for a product are marked as being in error. |
|
Speed |
It can take only a few minutes to import a new price sheet, or update an existing one |
OrderWiz is
the dream manufacturer rep system. Flexibility is the key to its programming
design, by responding to vendor and a customer’s requirements in a variety of
ways. Gone are the days of “tricking” and “patching” your system every time a
vendor has a new promotion
OrderWiz is
comprised of nine main modules: Vendors, Customers, Organizational Data, Order
Entry, Invoicing, Commission Reconciliation, Month End Processing, Payroll, and
Sales Reports. The Order Entry and Sales Reports modules can be operate
effectively at the home office or on the road by using Dial Up
Networking, or a VPN.
© Robert E. Flaherty 2008