O/PUS Quarter-End Procedure FAQs & Doc

O/PUS BPIR logo Each quarter, you load item and pricing updates from O/PUS®. Because you only do this four times a year, it's hard to remember the details. This page is your online resource for loading O/PUS. We've organized frequently asked questions according to the major stages of your quarterly procedures:

1. Pre-Load Steps (one week to 24 hours before loading O/PUS)
2. Loading O/PUS (immediately before loading O/PUS)
3. Post-Load Steps (when O/PUS load is 100% complete)
4. Troubleshooting O/PUS (anytime)

O/PUS Documentation

For late-breaking information, see the O/PUS Update Notes.

Pre-Load Steps

What do you need to set up for access to files via O/PUS PSN?

Using the O/PUS Private Supply Network (PSN), PSNControl software, and the (+IF) Communications Screen, you can access the quarterly OPdb® multivendor catalog update file, individual vendor pricing files and the loading programs required to process them. You need a DDMS Ensite Pro server with broadband Internet access, an active O/PUS account with Trade Services Co., an active ECI² (PSN) account, and access to the O/PUS PSN. For additional instructions, see these resources:

O/PUS PSN Introduction This one-page introduction provides an overview of the O/PUS® PSN services, formerly known as Business Products Information Resources (BPIR).
If you have not already set up your ECI² PSN (rare), complete ECI² PSN Registration and Phase I: Setting Up PSN (pdf) Set up the software and general parameters necessary to communicate faster and more reliably with vendors who offer services via the ECI² Private Supply Network (PSN).
If you already have ECI² PSN services set up, but do not yet subscribe to the O/PUS PSN, contact opus@eci2.com to set up your account and request a Communications ID and password for the (+IFI) screen. O/PUS PSN ID Setup gives brief steps to set up your (+IFI) ID parameters for access to the O/PUS PSN.
For detailed instructions to set up appropriate parameters, install and use O/PUS PSNControl software, and download the O/PUS Multi-Vendor Update, and then download and process additional vendor pricing files, flyers, programs, and catalogs, see Setting Up and Using the O/PUS PSN (pdf).

Training on O/PUS procedures is also highly recommended. More information is below.

Where can you get a checklist of O/PUS quarter-end procedures?

Updated! O/PUS Quick Reference (pdf). This two-page checklist includes: Pre-Load Steps (One week to 24 hours before loading O/PUS), Loading Steps (Immediately Before Loading O/PUS), Post-Load Steps (When O/PUS Load is 100% Complete), Optional Steps, and Additional resources & links.

What's New For This Quarter?

The latest quarter's news is posted online:

O/PUS Update Notes includes latest breaking information about this quarter's catalog update. In the weeks leading up to quarter-end, we publish a tentative schedule. When we release the OPUSInstall software update and OPdb®/OPdb2 catalog, we also post the announcement and link to the download page here. If wholesalers submit post-load changes to O/PUS, we publish instructions to ensure you have the latest item and pricing data. If several dealers report software or data issues, we will publish troubleshooting advice from ECI² Technical Support.

We also publish Mass Emails, including major company announcments and software release notes that affect a majority of dealers. In the weeks leading up to quarter-end, we publish reminders that discuss important enhancements to the data, software, and procedures, designed to help you plan your procedures. Closer to quarter-end, we announce the release of the OPUSInstall software update, OPdb®/OPdb2 catalogs, and the FYI² Notes newsletter. After quarter-end, we may announce late-breaking vendor changes or troubleshooting advice.

Where is the FYI² Notes newsletter?

The For Your Immediate Information — OPdb MultiVendor Update newsletter — a.k.a. "FYI² Notes (pdf)" and FYI² Canadian (pdf) — are published online quarterly when the current quarter's OPUSInstall software update and OPdb®/OPdb2 multi-vendor catalog update databases are ready for release. The newsletter includes information about software enhancements for the O/PUS PSNControl download software, the SIMPLE loading wizard, Super Store Data Update, and other software and services from O/PUS and ECI² Content Services. The newsletter also announces new vendors, shares important notes from vendors, and includes a chart of pricing programs, consumer price levels, and dealer cost levels for each vendor included in the OPdb or OPdb2 catalog update.

How do you get training on O/PUS procedures?

See if the new O/PUS Webdemo schedule is posted online.

Where is the documentation on O/PUS SIMPLE & the Toolbox?

Updated! Loading O/PUS Multi-Vendor Quarterly Update (pdf) This handout covers all of the basic quarterly catalog update concepts and procedures for Ensite Pro™. It includes the O/PUS Quick Reference, as well as detailed instructions for 1) downloading and running OPUSInstall to update all O/PUS software; 2) Using PSNControl to Download Quarterly Update Files and Vendor Pricing Files; 3) Running the SIMPLE Wizard to process the data; 4) viewing report messages; 5) processing price files; 6) keeping your database clean; and more. Along with the Toolbox handout, this document replaces the original Complete O/PUS Multi-Vendor Documentation and O/PUS Made SIMPLE.

O/PUS Toolbox (pdf) The O/PUS Toolbox is a collection of text-based (+I) programs for managing your Ensite Pro™ inventory catalog, costs, pricing, and purchasing preferences. Learn how to adjust costs, prices, dates, and profits; build or create vendor contracts; set and modify your purchasing vendor; move, modify, and classify your data; process vendor unit of measure (UOM) changes to recalculate costs, prices, contracts, inventory quantities, shipping weights, and history totals; view various reports; build SuperIndex; process vendor price files; implement page numbers from special catalogs; and more.

How do you know if your O/PUS Trade Service account is up to date?

Contact Trade Services. Your Trade Service account must be current in order for you to be able to receive the OPdb and pricing files via the O/PUS PSN. If you have questions about your O/PUS products, services, pricing, or account, please contact Trade Service directly at 1-800-701-7003.

How do you get catalog updates for supplemental vendors (not on the main O/PUS load)?

Supplemental Vendors are regional and specialty vendors whose item pricing updates are distributed via the O/PUS® Private Supply Network (PSN). Contact your vendor for access to their file. See also the O/PUS supplemental vendor subscription (pdf) for a list of vendors and special rules that apply. You can find the loading program instructions under Vendor Price File Loading Instructions.

What information do you get from your vendor(s) each quarter?

What price plan(s) to load (pdf)?
Which consumer price level to use per price plan?
Which dealer cost level or cost column to use (and password, if required)?
What items have buy unit of measure (UOM) changes that may mismatch your sell units? More information below...

When are vendor passwords required?

Have your vendor passwords ready when you begin loading your O/PUS update. Some vendors require a password to enter or update cost column settings.
Note: Cost column passwords are NOT available through ECI² Tech Support or O/PUS. To acquire your cost column password, contact your vendor. For example, Mid Continent requires a cost column password. At Mid Continent, contact Sue Schmidt, 1-913-279-5803 (or leave a detailed message with your name, company name, cost column, and phone number at 1-800-821-5197).

Why do you need to know if vendors changed their units of measure (UOM)?

Each quarter, and especially in the fourth quarter, major wholesalers typically change their buy unit of measure (UOM) each quarter on some items to reflect purchasing trends. They provide these changes in the quarterly O/PUS Update. Due to the changes, your selling units may not match your vendors’ new buying units. For additional details, see How UOM and Carton Quantity Affect P/O Quantity, Cost.

Using the SIMPLE wizard, you can opt to ensure your selling units match your vendors’ new buying units on the stock classes you specify. A special program called Make-Buys converts your selling units to buy units, and automatically recalculates costs, prices, contracts, inventory quantities, shipping weights, and history totals accordingly. To ensure that the UOM and pricing in the Scanalog (I-CAT database) match each item’s master record, follow the instructions in Handling Vendor UOM Changes with Make-Buys (pdf).

You may contact your vendors for a list of this quarter’s UOM changes:

S.P. Richards will make a list of items that will change UOM or be discontinued available from your S.P. Richards account representative.

United posts their UOM Changes on their Reseller Classified Zone at www.ussco.com. Member dealers can log in to the site and view the list

Why isn't there a global list of UOM changes every quarter?

Your vendors are the best source of that information, as advised in Handling Vendor UOM Changes With Make-Buys (pdf). Vendors prefer you contact them directly regarding price plans and UOM changes, and/or access your account resources on their Web sites. But you may have seen what looks like exceptions to the rule.

A few years ago, two wholesalers asked us to communicate the number of their UOM changes during a quarter such changes were extensive. Since then, quarterly UOM changes have not been as notable. Of course, major wholesalers typically change UOM en masse to reflect purchasing trends every October. So, every fourth quarter, we encourage you to take advantage of the Make-Buys program as needed. But it may not be necessary every quarter, depending on your particular item usage.

Later, as part of the Office Product Identification Standardization (www.opids.org) initiative, we provided a link to a list of items with extensive changes to MAC codes, item numbers, and units of measure. See the 1Q2007 FYI² Notes (pdf). O/PUS continues to partner with sources to meet OPIDS compliance, and will communicate with subscribers if any quarterly procedures need adjustment.

How do you know which vendor pricing files you can load?

See the Completely Updated! Determining Which Pricing Plans to Load (pdf) Before you load an O/PUS update, you need to find out from your vendor which pricing plans you should load. This document explains what you need to ask your vendor, where to find your pricing files and loading programs, and when to process them.
If you are an ASP dealer, see Determining Which Pricing Plans to Load for ASP (pdf)

Is your price plan in the main O/PUS file or individual O/PUS PSN files?

Check each vendor's charts in the FYI² Notes (pdf) and FYI² Canadian (pdf) quarterly newsletters. If your vendor price plans are listed in the newsletter, they are part of the main O/PUS load. If your vendors' price plans are not listed in the FYI² Notes newsletter, you may find them on the O/PUS PSN. Find the loading program name for each pricing plan under Vendor Price File Loading Instructions. For more information, see O/PUS PSN Price File Advice.

Where are the Supplies Network item update files and what is their abbreviation?

Supplies Network has joined the list of vendors who provide quarterly catalog updates within the O/PUS multi-vendor catalog update, as announced in the April 1, 2007 FYI² Notes. You no longer download an individual Supplies Network item file update from the O/PUS PSN. The Supplies Network catalog is available to ALL O/PUS customers using the SIMPLE wizard, whether you are loading the OPUS, OPUSISG, or OPUSTPA file.

To open an account with Supplies Network:

For TPA members, contact salesperson Mark Magasano (636-300-4000 x575)
For non-TPA members, contact salesperson Bob Mondschein (636-300-4000 x882)

Some OPUS tools, mass-changes, and reporting tools require a vendor abbreviation:

Their four character abbreviation is DMI-
(Note: you must include the dash at the end of DMI)
In larger fields that require the full vendor name, enter DMI-WHL

How do you know if the quarterly software update is released and ready to load?

O/PUS will announce via Mass Email when the software update is ready. The OPUSInstall software update page also indicates the current download's effective quarter, date, and version.

How do you get the quarterly software update?

Once you receive notice that the software update is released and ready to download, shut down TBL, and download and run the OPUSInstall software update.

When should you download vendor price plans — before or after updating software?

Any time after installing the current quarter's OPUSInstall software update.
Download vendor price plans and loading programs via PSN (but do NOT process until after loading O/PUS).

What if PSNControl says "File Not Found"?

For any files you could not download, use the PSN File Not Found (pdf) form to check availability for files with PSNControl software. If two business days have passed since your vendor representative has confirmed they sent the files to O/PUS, and PSNControl still indicates "File Not Found," submit this form. A technician will confirm file availability so you can update. You can even fill it out online and print for optimum readability! See online PDF form instructions. For even easier emailing, use the Word document version (doc).

Can PSN Control tell me the revision date a vendor price file has been updated?

O/PUS recently enhanced PSNControl to display the Vendor File Revision Date in the File Transfer List Window, after the file has been downloaded.

The Vendor File Revision Date is the last date that the file was revised by the vendor. This allows you to determine if the vendor has updated its pricing file or if O/PUS has revised the loading program since the last time you downloaded it.

This information should he especially helpful when downloading from vendors who distribute pricing files more frequently (such as monthly or even daily).

Also, when you select (or highlight) a downloaded file, the mouse-over tool tip displays:

"File Name / Status / Vendor File Revision Date"

Where can you find release notes before loading the O/PUS quarterly update?

Check Update Notes for any issues we find after releasing this quarter's update.
Check Mass Emails for important announcements.

Should I pack files to avoid hang-ups during the ;SPC:CHGIT or (+IY) processes?

Yes. In recent quarters, your ECI² Technical Support teams have noted a number of calls related to hangups during the ;SPC:CHGIT or (+IY) processes. We therefore recommend a pre-load procedure of compressing your Inventory and CONTRACTS files. This procedure may be done up to two weeks prior to your O/PUS load. For detailed instructions, see Compressing Files on the Windows Platform (pdf).

How do you clean up/erase contracts from DDMS Ensite Pro?

Updated! Removing O/PUS Price Plans (pdf) Learn to remove pricing plans or sales flyers that you loaded by mistake, using the O/PUS Tool Box option (+IK) Kill Records from I-CAT by Program ID.

Also consider the new Windows application: Using ECI² Content Services Instant Contract Eraser (csICE) (pdf) csICE is a new application for deleting contracts and price plans. It is designed to dramatically speed up the price file load process. OPUSInstall will install the standalone application on your system.

Can you set up item stock classes or departments for a vendor, program, or company?

Yes. See Setting stock classes or departments by purchasing vendor (pdf). Learn to use the (+I-3) tool to set up a stock class or department for a particular purchasing vendor. You can also set them for individual purchasing vendor programs.
You can also set stock classes or departments by the CO prefix of an item key, using the (+I-D) Dept & Class by CO Field tool. See O/PUS Toolbox (pdf).

How do you safely remove a vendor and all its related files and records?

See Removing a Vendor (pdf) If you wish to remove a vendor from your inventory database for any reason, some of the procedures are best done when loading O/PUS.

How do you safely switch primary vendors?

Switching Your Primary Vendor During Quarterly O/PUS Updates (pdf). Understand an easily overlooked parameter and avoid cost discrepancies by ensuring O/PUS matches your inventory to your new primary vendor’s costs.

How do you request an O/PUS CD-ROM?

O/PUS ships the OPdb multi-vendor catalog updates via CD-ROM on request only to customers whose Trade Service accounts are current. Your Trade Service account must be current in order for you to be able to receive the OPdb and pricing files via the O/PUS PSN. If you have questions about your O/PUS products, services, pricing, or account, please contact Trade Service directly at 1-800-701-7003.

What happened to the (+IFD) Download a File option for BBS downloads via dial-up modem?

We have phased out O/PUS dial-up BBS modem connectivity. Previously, dealers could use the dial-up BBS to download vendor loading programs and pricing files. As of 2nd quarter 2007, the (+IFD) Download a File option (using the dial-up BBS) has been removed from the O/PUS Toolbox, and therefore, the BBS dial-up connection will no longer be available.

The reason for the BBS/(+IFD) discontinuation is three-fold.

First, the size and volume of quarterly pricing files from your wholesalers has grown tremendously over the years. As a result, each download takes longer for each dial-up connection to complete each quarter.
Second, the dial-up equipment and software will no longer be supported by our vendor, making it increasingly difficult for us to support, troubleshoot and repair.
Third, the majority of BPIR subscriber dealers are now using the O/PUS PSN on their broadband Internet connections. With only 10 subscribers who still rely strictly on the BBS modem, the decision has been made to streamline operations. Trade Service has contacted the affected dealers to discuss their alternatives.

This issue does NOT affect dealers who use PSNControl software to download files and programs from the O/PUS PSN via broadband Internet connections. Dealers who currently have a dial-up modem set up on the DDMS server may elect to keep it for wholesalers and other trading partners who allow modem transmissions for purchasing and invoicing.

To reflect these changes, we have completely revised related resources:

Return To Top

Loading O/PUS

Are all Pre-Load Steps completed?

See the O/PUS Quick Reference (pdf) two-page checklist, particularly the Pre-Load Steps (One week to 24 hours before loading O/PUS), and the Loading Steps (Immediately Before Loading O/PUS).

How and why do you dedicate your DDMS system?

You can merely check TBL Server to make sure no one else is using the DDMS system, as described in Protecting Your Data for Dedicated Procedures (pdf).

NOTE: The O/PUS load using SIMPLE does NOT require Maintenance Mode.

Some DDMS system maintenance functions must be done in a dedicated environment. Dedicated functions are procedures that can only be performed when no one else is using the system, or, if performed while others are using certain system files, can corrupt the files or lock up the system. Take appropriate steps to protect these files before you commence dedicated procedures.

How and why do you shut down your Web storefront site for maintenance?

During the O/PUS load and related procedures, you are updating inventory records and contracts. If your customers are ordering online from your integrated Web storefront during this time, it can affect whether orders complete properly.

For Dealer Station® or is.D-Force sites, see “Turning the Site Off and On for Maintenance” in Setting Up Dealer Station DDMS Edition Admin Pages (pdf).

For ecInteractive™ and is.D-Force2 sites, you can edit your Site News (Page Editor and Site Text) to inform visitors that your site will be offline for maintenance. You can even save a page to use as a template for future use.

How do you deactivate or disable procs?

You can adjust the (ZE7) Activities Scheduler to deactivate or disable any procs you have scheduled, and then reactivate them after you complete quarter-end procedures, as described in Disabling proc files (pdf).

How do you prepare the printer before loading O/PUS?

You must specify a valid printer in the SIMPLE Global Inventory Parameters, preferably a physical printer defined in your (L1) parameters. If you use a "file" printer, it must be one that prompts you to enter the path; otherwise, only the last report is available for review.

The O/PUS load will automatically print out reports that are crucial for troubleshooting problems and properly maintaining your database: your latest O/PUS Parameters, the Load and Update report (a.k.a. item exception report), any item duplicates and bad references, new records added/not added, items being updated, and other reports, depending on how you set up your parameters. The Load and Update "Item Exception" report can be set up to print to a timestamped file (OPMMDDHHMM where OP = OP, MM = Month, DD = Day, HH = Hour, and MM = Minute). The Make-Buys program creates an exceptions report named Make-Buys on your work unit.

Make sure the printer you plan to use is turned on, is online, loaded with paper, and ready to print at 17 cpi. If the printer stops during the load, the load stops until the printer is back online. If you specify to print optional item reports, and not just the mandatory Exceptions and Parameters Reports, you should use a high-speed printer.

Why should you shut down TBL Server before backing up DDMS files?

Occasionally, ECI² Technical Support receives calls from customers trying to restore DDMS files from a backup tape. In some cases, we have found that the customer's backup is incomplete, and the files cannot be restored. As you may know, the system will not back up any file that is currently being used. The cause of the incomplete backup is usually failure to complete a simple step: shutting down TBL Server before performing a backup. Many crucial DDMS files remain open when TBL Server is running, so it is important to shut down TBL Server to ensure a complete backup.

How do you back up the DDMS system?

For detailed instructions on backing up your DDMS files, see File #243: Backing Up Your DDMS Files in Microsoft(R) Windows 2000.
To learn how to verify that your backups are good, see the updated File #86: Making Sure Your Backups Are Good. Note: If your backup log shows errors or skipped files, contact Support.
To learn how to restore files from a backup tape, see File #92: Restoring From Backups under Windows 2000 or File #38: Restoring Files on UNIX Systems.

What if you haven't yet loaded the latest OPUSInstall?

If you have not already done so for this quarter, download and run OPUSInstall while TBL is shut down.

OPUSInstall avoids these top two mistakes. We keep seeing two big misconceptions every quarter that cost dealers a lot of time and confusion.

First, some dealers mistakenly think they can skip the OPUSInstall, assuming they meet all requirements when they previously loaded OPdb via PSN. However, you must still download OPUSInstall from our Web site and run it every quarter. The OPUSInstall software update will optimize your PSNControl software and ensure your SIMPLE wizard has all the latest vendor-specific enhancements.
Next, people assume that the OPUSInstall replaces the need to run the SIMPLE program. The truth is, the OPUSInstall ONLY updates the SIMPLE and PSNControl software. It does not replace the need to load the updated catalogs using PSNControl and SIMPLE.

Keep an eye out for our announcement when the OPUSInstall and OPdb files are ready to download, and follow each of the steps outlined in the message.

How do you open TBL Server (or take DDMS out of maintenance mode)?

NOTE: O/PUS procedures do NOT require Maintenance Mode. In order for SIMPLE to load your quarterly update, TBL Server must be running Utilities, and the system may need to be rebooted out of maintenance mode. To learn how to do so, see the instructions for Level R (Reboot) Shutdown and Start Utilities in Protecting Your Data for Dedicated Procedures (pdf).

How do you check for late-breaking news on this quarter's O/PUS Update?

Check Update Notes for any issues we find after releasing this quarter's update.
Check Mass Emails for important announcements.

How do you get the OPUS file, the OPdb® multi-vendor update?

After we announce the file is released, and after you've run the quarterly OPUSInstall software update, download the “OPUS” multi-vendor update file using the PSNControl program. For detailed instructions, see Setting Up & Using the O/PUS PSN (pdf).

How do you launch SIMPLE to load the O/PUS Update?

If you have completed all the preceding pre-load and loading steps, you can launch the O/PUS SIMPLE wizard as follows:

Make sure TBL Server is running.
Navigate to the Windows Start menu, then click Programs, then click the SIMPLE program group, and then click the SIMPLE program icon.
Modify your parameters as needed and begin your quarterly update as you normally do.

For detailed instructions, see the Completely Updated ! Loading O/PUS Multi-Vendor Quarterly Update (pdf). This handout, along with the Toolbox handout, replaces the original Complete O/PUS Multi-Vendor Documentation and O/PUS Made SIMPLE. It covers all of the basic quarterly catalog update concepts and procedures for Ensite Pro™. It includes the O/PUS Quick Reference, as well as detailed instructions for 1) downloading and running OPUSInstall to update all O/PUS software; 2) Using PSNControl to Download Quarterly Update Files and Vendor Pricing Files; 3) Running the SIMPLE Wizard to process the data; 4) viewing report messages; 5) processing price files; 6) keeping your database clean; and more.

How do you load the O/PUS ISG Update?

If you are an is.group member loading the is.ezTrade Edition of the OPdb update, the PSNControl instructions and password are available at www.isgroup.org under the DDMS tab, by clicking File Load Instructions.

How do you load the O/PUS TPA Update?

If you are a TriMega Purchasing Association member loading the TriMega Edition of the OPdb update, the PSNControl instructions and the O/PUS User Direct-Buy Information Password are available at www.trimega.org, in the member center, on the TriMega Catalogs page (https://www.trimega.org/members/programs/catalogs.asp).

How do you load the O/PUS Canadian Update?

The Canadian multi-vendor update database is usually released a couple of weeks later than the standard update. For detailed instructions on loading and maintaining your inventory with O/PUS' Canadian edition, see Canadian Multi-Vendor documentation (pdf), (rev 12/01). Also see FYI² Notes for O/PUS Canadian Customers (fyi2_Canada.pdf; Revised 4/11/2007).

How do you load the O/PUS ASP Update?

ASP customers: see information about loading item files through the ASP service.

Does SIMPLE create Reference Items Whenever the SKU Changes?

Yes. Starting first quarter 2007, SIMPLE will create references from an old number (or old company) to the new item in your inventory when the item number OR the items' company changes.

How does Make-Buys automate adustments when vendors change item UOM?

Handling Vendor UOM Changes With Make-Buys (pdf) Each quarter major wholesalers change their buy unit of measure (UOM) for some items to reflect purchasing trends. Using the SIMPLE wizard, you can opt to ensure your selling units match your vendors’ new buying units on the stock classes you specify. The Make-Buys program converts your selling units to the new buy units, and automatically recalculates costs, prices, contracts, inventory quantities, shipping weights, and history totals accordingly.

Should you set “Update Items to Primary Vendor Whenever Possible”?

When setting SIMPLE global parameters, our support call statistics indicate that we get a high volume of calls related to switching primary vendors during fourth quarter every year.

If you leave this box unchecked, the program will attempt to match on the existing primary wholesaler record in your system for each item. It will update each item record based on the information from that vendor.
If you check the box, the program disregards the item’s existing primary wholesaler record. It will update item records using the information from the primary wholesaler you selected in your O/PUS parameters. If no match is found, it will update your items based on the priority of your secondary vendors. The first vendor who carries that item will determine how the program updates the item record.
Setting this parameter can have a major impact on your purchasing. Let’s say that last quarter, your first-call vendor didn’t carry a particular pen. But your second-call vendor did carry the pen, and thus appears as the primary wholesaler for that item. This quarter, your first call vendor now carries the pen. If you leave this parameter unchecked, your second-call vendor will still be the primary wholesaler for this item. However, if you check the parameter, the pen’s primary wholesaler record will be updated with your first call vendor’s information.
Here’s another example. Let’s say that last quarter, Vendor A was your first-call vendor, and Vendor B was your second-call vendor. This quarter, you’ve decided to switch to Vendor B as your primary vendor, and indicate this on the vendor priority list in your O/PUS parameters. If you leave this parameter unchecked, your item number and primary wholesaler will not change to your new first call vendor’s information. Your system will still show Vendor A as your primary wholesaler for those items.
In our experience, most dealers prefer to check this parameter’s box. For more information on switching primary vendors, see File #219: Switching Your Primary Vendor During Quarterly O/PUS Updates.

Return To Top

Post-Loading Steps

Where's that checklist of O/PUS quarter-end procedures?

Review the O/PUS Quick Reference (pdf) two-page checklist, particularly the Post-Load Steps (When O/PUS Load is 100% Complete), Optional Steps, and Additional resources & links.

How do you verify the O/PUS Load is done?

Verify that the end of the printout says 100% complete.
If you chose any re-indexing options, they run after printout says 100% complete.
If you chose to rebuild SuperIndex, it will run after re-indexing is complete.
To learn how to check if all reports and batches are finished, see the instructions for interpreting the TBL Server window on page 1 of Protecting Your Data for Dedicated Procedures (pdf).

Did you shut down and restart TBL Server?

If you have not yet done so after running SIMPLE, shut down and restart TBL Server. To learn how to do so, see the instructions for Level R (Reboot) Shutdown and Start Utilities in Protecting Your Data for Dedicated Procedures (pdf).

What do you do with the Item Exception Report (aka Load and Update Report)?

After you load an O/PUS update, the system automatically prints the OPdb Load and Update Report (sometimes called the O/PUS Exceptions report). This report lists items that were not added or updated, along with the reasons. If you see a list price variance on this report, follow these instructions to correct it. For detailed instructions, see Correcting List Price Variances after Loading O/PUS (pdf).

What if you still need to get price files and loading programs from the O/PUS PSN?

You can download vendor price files and loading programs any time after installing the current quarter's OPUSInstall software update.

Find the loading program name for each pricing plan under Vendor Price File Loading Instructions, and dDownload vendor price plans and the required loading programs via the O/PUS PSN.

How do you process vendor price files?

You can process your vendor price files any time after using SIMPLE to load O/PUS quarterly updates. For additional instructions, see O/PUS PSN
Price File Advice. For detailed instructions on each vendor, see Vendor Price File Loading Instructions.

What optional post-load procedures should be run BEFORE setting purchasing vendor?

Before setting your purchasing vendor based on pricing, you may wish to complete the following optional procedures:

(+I-$) Round off Catalog & List Price is used to eliminate invoice confusion when the third digit does not print, but is used for extended calculations. The list price of the I-PRICE file and the catalog price of the I-WHL file for all your items are rounded to the nearest penny. See O/PUS Toolbox (pdf) for instructions.
(+I-A) Create Vendor Contract lets you create a vendor contract from a flyer contract, or transfer information to another vendor contract, with the option to update the I-PRICE pricing record. It also gives you the option to Update the Price Only if the New Price is Greater Than the Old Price. See O/PUS Toolbox (pdf).
(+IK) Remove Records from I-CAT by Program ID cleans up unwanted records, and may be used in conjunction with the contract eraser. For instance, it may be used when you loaded a pricing plan you do not actually use. Or you wanted to create a contract from a pricing plan, but did not want to use the pricing plan’s costs. Or your vendor released an updated flyer that has fewer or different SKUs. See Removing O/PUS Price Plans (pdf) and Using ECI² Content Services Instant Contract Eraser (csICE) (pdf).
(+I-%) Adjusting Flyer Costs By a Percentage (pdf) is used when a dealer wants to increase the flyer/catalog cost. to cover overhead expenses, or to decrease the flyer/catalog cost if the wholesaler gives you a better price than the already discounted item cost.
(+I-&) Build Contract for a Vendor (pdf) builds a contract from I-WHL and I-CAT for a vendor you specify. It is used when the dealer wants to create a contract using a vendor’s catalog as the basis for the item listings and pricing, adjusting cost as needed.
Using ECI² Content Services Instant Contract Eraser (csICE) (pdf) is recommended for cleaning up contracts and price plans if you haven't already done so, and removing pricing plans or sales flyers that you may have loaded by mistake. This Windows program is designed to dramatically speed up the price file load process, and will also speed up other procedures.
Viewing Page Numbers From Special Catalogs (pdf) Several vendors print special consumer-priced catalogs. The (+I-U) tool is designed to allow a vendor’s supplemental catalog page number to be displayed in the Order Entry screen instead of the general line catalog page number. If you wish to view page numbers for both the General Line catalog and the special consumer-price catalogs, do not use (+I-U). Instead, use the Multiple Vendor Screen.
FileMapper (pdf) The FileMapper™ program for Microsoft® Windows® NT/2000 lets you quickly convert price update files from manufacturers into a format that can be read by the DDMS system. It lets you maintain current prices from such manufacturers as Smead and Fellowes, for example, in your DDMS Item database. Once FileMapper has formatted the data, you move the formatted file to a DDMS system folder on the DDMS server and run the O/PUS™ program U_MFG to complete the process.
Removing a Vendor (pdf) If you wish to remove a vendor from your inventory database, we recommend doing so before setting purchasing vendor.

How do you make sure DDMS displays special catalog pages?

Viewing Page Numbers From Special Catalogs (pdf) Several vendors print special consumer-priced catalogs. The (+I-U) tool is designed to allow a vendor’s supplemental catalog page number to be displayed in the Order Entry screen instead of the general line catalog page number. If you wish to view page numbers for both the General Line catalog and the special consumer-price catalogs, do not use (+I-U). Instead, use the Multiple Vendor Screen.

Should you remove unwanted vendors now?

Yes. See Removing a Vendor (pdf). If you wish to remove a vendor from your inventory database, we recommend doing so before setting purchasing vendor.

How do you set purchasing vendor using (+IL) (+IZ) or (+IT)?

There are several approaches to purchasing. Deciding which is right for you is
an important factor to your company's success.
(+IL) Lowest Cost for Vendor from Scanalog
(+IZ) Set Item Cost from Scanalog
(+I-T) Dealer Enhanced Cost Tool
See Setting and Modifying Your Purchasing Vendor Information in O/PUS Toolbox (pdf) for further instructions.

What optional post-load procedures should be run AFTER setting purchasing vendor?

(+I-1) Reset Purch Vendor to Primary Whl is used if you make a mistake trying to set your purchasing vendor. See O/PUS Toolbox (pdf) for instructions.
(+I-G) Set Gross Profit from Costs is used to recalculate the gross profit percentage. This gross profit percentage can be based on the average cost (set in the I-PRICE record), the replacement cost (set in the I-WHL record), or the purchasing vendor.
Changing contract prices (pdf) Learn how to raise or lower contract prices. The method described here uses a percentage to change prices, and gives you the option of changing particular items or an entire contract, and limiting to a specific vendor, such as the purchasing vendor, primary wholesaler, or secondary vendor.
Setting contract percentages after loading O/PUS (pdf) After loading contracts through O/PUS, get the system to display the gross profit and discount percentages. Most dealers specify purchasing vendor cost when setting the (ET) contract figure type.
File # 246: O/PUS Contract Wizard (pdf) This a free Windows-based application will allow you to convert/import an Excel spreadsheet into a DDMS contract. This document provides instructions for installation, running Contract Creator for the first time, what columns to create in Excel, and how to import the spreadsheet into your DDMS Contract.
Super Store Data Update (pdf) Load the Super Store Data Update software and quarterly data into DDMS® Ensite Pro™. The standard edition (filename SSDitems) includes super store name and SKU. The premium edition (filename SSDpricing) includes everything in the standard edition, but also includes pricing, units of measure, and packaging information; the premium pricing edition requires authorization from Trade Services. TIP: To prevent overwriting your SSD Updates, you must run the SSD Update as an optional post-load procedure, after running SIMPLE. TBL Server must be running for the import to work properly, as with all other pricing files and catalog updates. You must rebuild Super Index (+I-I) so that the Order Entry, Purchasing, and integrated Web storefronts such as Dealer Station® and is.D-Force® will accept the input of the superstore item numbers.

Can you raise or lower contract prices at this point?

Changing contract prices (pdf) Learn how to raise or lower contract prices. The method described here uses a percentage to change prices, and gives you the option of changing particular items or an entire contract, and limiting to a specific vendor, such as the purchasing vendor, primary wholesaler, or secondary vendor.

How do you set contract percentages by purchasing vendor cost?

Setting contract percentages after loading O/PUS (pdf) After loading contracts through O/PUS, get the system to display the gross profit and discount percentages. Most dealers specify purchasing vendor cost when setting the (ET) contract figure type.

Can you convert/import an Excel spreadsheet into a DDMS contract?

File # 246: O/PUS Contract Wizard (pdf) This a free Windows-based application will allow you to convert/import an Excel spreadsheet into a DDMS contract. This document provides instructions for installation, running Contract Creator for the first time, what columns to create in Excel, and how to import the spreadsheet into your DDMS Contract.

How do you load Super Store Data (SSD) item SKUs and pricing?

Super Store Data Update (pdf) Load the Super Store Data Update software and quarterly data into DDMS® Ensite Pro™. The standard edition (filename SSDitems) includes super store name and SKU. The premium edition (filename SSDpricing) includes everything in the standard edition, but also includes pricing, units of measure, and packaging information; the premium pricing edition requires authorization from Trade Services.

TIP: To prevent overwriting your SSD Updates, you must run the SSD Update as an optional post-load procedure, after running SIMPLE. TBL Server must be running for the import to work properly, as with all other pricing files and catalog updates. You must rebuild Super Index (+I-I) so that the Order Entry, Purchasing, and integrated Web storefronts such as Dealer Station® and is.D-Force® will accept the input of the superstore item numbers.

NOTE: Super Store Data will NOT automatically synchronize with the SQL database. After loading the Super Store Data Update, and completing other post-load procedures including Inventory Housekeeping, affected dealers should re-import inventory contracts as instructed in Using the EnsiteEBS Utility (pdf).

How do you load Super Store "private brand" item references?

The Super Store Data Update was recently enhanced to load super store private-branded items that have been cross-referenced to SPRichards, United, and ActionEmco branded items. To load these references, select Load Super Store Branded Items when you load the latest quarterly SSD file. You can specify SPRichards, United, and/or ActionEmco in the order of your wholesaler preference.

For detailed instructions on installing and using the Super Store Data, see Super Store Data Update (pdf).

What other inventory housekeeping is recommended for "deleted" records?

Inventory housekeeping (pdf) Mass delete item records that O/PUS marks as deleted.

How do you view Matrix catalog page numbers?

Several vendors print special consumer-priced catalogs. (For example, United and S.P. Richards publish "matrix" catalogs). In most cases, these printed publications have page numbers that differ from the vendor's general line catalog.

Situation: You may want these specially priced catalogs' page numbers to appear in the Order Entry screen in addition to the vendor's General Line catalog page numbers. The Commercial Order Entry screen displays the item's page number from the Primary Wholesaler record (the I-WHL file), but catalogs loaded through pricing plans are not loaded into that file during O/PUS procedures.
Solution: The Multiple Vendor Screen is the only place these additional catalog page numbers will appear in DDMS. To view these page numbers, you must update Scanalog when loading the price file via O/PUS procedures. So, when processing the special catalog's pricing file that you've downloaded from the O/PUS PSN, type "Y" when prompted to update Scanalog. This will put an entry in the I-CAT file that will allow the consumer catalog page numbers to appear in the Multiple Vendor Screen.
Result: Assuming you've properly processed the special catalog's pricing file, you can then view these additional catalog page numbers during order entry. In graphical order entry, viewing page numbers is simple: after entering the stock number, look for page numbers on the bottom right of the Item Detail tab. In text-based software, after entering the stock number, enter a "V" in the ORDER Quantity field. This will display all the records in the Multiple Vendor Screen, including the page numbers for each record.
Alternative: What if you only want to see the special catalog page number? After loading your quarterly update and the special pricing file, you can replace the general line catalog page number using the (+IU) tool. Note: This will REMOVE the general line page number. If you run (+IU) by mistake, the only ways to recover the general line page number is to re-load the OPdb catalog or to restore from a backup made immediately prior to running (+IU).

What if you need to update sales journals not listed in (LGA) parameters?

Updating Sales Journals After Loading O/PUS (pdf) If you have sales journals that are not listed in your (LGA) Sales Journals Parameters screen, follow these instructions to run ;SPCCHGIT to update them after your O/PUS load. If you are using EnsiteEBS SQL applications such as Customer Price Plans and Price Modeling, you may need to re-import the sales journals Using the EnsiteEBS Utility. Additional information is in the Re-Import FAQ below.

Do you need to Re-Import SQL data in EnsiteEBS after quarter-end Housekeeping ?

Yes. Changes made during the O/PUS load will NOT automatically synchronize with the SQL database in Ensite Pro™ Version 8.11 or higher. This issue only affects dealers who are using EnsiteEBS SQL applications such as Customer Price Plans and Price Modeling.

When. For affected dealers, this post-load step is required: Assuming you have previously validated and imported your SQL data, re-import your updated inventory data using the EnsiteEBS Utility. Our O/PUS Quick Reference Checklist suggests using the EnsiteEBS Utility during post-load steps AFTER:

Rebuilding SuperIndex
Processing vendor pricing files
Completing optional post-load steps (including Super Store Data)
Setting Purchasing Vendor (+IL, +IZ or +IT)
Completing Inventory Housekeeping to delete items O/PUS marked as deleted (R-CAT1, +EE).

How. To expedite the process once other post-load steps are complete, you can limit the import to the following files affected by quarter-end procedures: ALL inventory files, Contracts, and Sales Journals listed in LGA. If you are also running the Change-It program on sales journals other than those listed in LGA, you will also need to import those files as well.

What Files to Re-Import. When you use the EnsiteEBS Import Data Into SQL tool every quarter, you may just accept the default and re-import all files. Or, you may select specific checkboxes for item, contracts, and purchasing files that have been converted by the CHANGE-IT program during your O/PUS load: I-MASTER, I-MFG, I-WHL, I-PRICE, I-COLUMNS, I-CAT, I-AUX, I-AUXSUP, CONTRACTS, CON-VENDOR, I-ALIAS, P-MASTER, P-SPECIAL, P-LINE, and P-LINE2.

Note: Some files converted by CHANGE-IT (I-AUX-BIN, I-HISTORY, I-REMARKS, I-JANSAN, I-UOM, ALIAS INDEX, I-BOM, ITEMSUB, PO-MASTER, PO-INDEX, PO-SPECIAL, P-LNEDI, P-COMMENT, LOST-SALES, JOUR-S, other sales journals in (LGA), JOUR-U, JOUR-PO, JOUR-PO SPECIAL, and JOUR-UC) are not currently used by EnsiteEBS applications, and therefore may not need to be imported.

When you use the Sales Journal Import tool, accept the defaults to import JOUR-S and even your monthly journals according to your (LGA) Sales Journal Parameters. Even though each quarter you may have three new months of sales journal data, the sales journal import tool automatically validates your data.

You also use the Sales Journal Selective Import to include older archives not already listed, and specify a number of months to include. The system defaults to 12 months.

For detailed instructions, see Using the EnsiteEBS Utility. If you need assistance addressing exceptions, contact your support team.

Return To Top

Troubleshooting O/PUS

What if PSNControl says "File Not Found"?

Where are release notes and troubleshooting advice on this quarter's software and data?

Check Update Notes for any issues we find after releasing this quarter's update.
Check Mass Emails for important announcements.

What do I do if my vendor is transitioning to LOP private branding?

A few vendors have begun transitioning their private branded items to a new LOP brand. Some vendors are depleting stock on the previous brand prior to switching to the new LOP brand, but some are using other methods. Due to the different manners of transition, O/PUS is not able to perform an automatic reference from the vendors' previous brand to the new LOP brand during this quarter's update.

Therefore, we recommend that you contact your vendor and request a list of their previous branded to LOP brand items and make your own decision on how and when to modify the vendors' previous branded items. The affected vendors include Action, Emco, O Henry, PPI Wholesale, and ISGroup.

What should you send/fax to Support to troubleshoot cost and pricing issues?

See Reporting Item Data Issues To ECI² Technical Support (pdf). Learn which screens in Microsoft Windows® to email or fax to DDMS Support for help in resolving issues with cost or price. Screen shots (Alt+PrtScr) may include (+I-R) Report Items to O/PUS, (+I-V) View O/PUS Parameters, Order Entry Item Detail tab, Customer Order Entry tab, (LG3) Order Entry Pricing Parameters, and your Item database's affected Inventory Contracts, and should be emailed to support@eci2.com or faxed to 682-831-9909.

How do you translate CO fields and MAC codes into manufacturer company names?

Updated! O/PUS MAC codes (pdf) Three-digit codes that identify manufacturers. The system displays these codes in the CO field in the (E) screen. (Revised 9/20/2007)

How do you correct dates for contracts and flyers after loading O/PUS?

Correcting Contract Dates after O/PUS Loads (pdf) You set the effective dates for contracts and sales flyers when loading OPUS. If you forget to change these dates when loading your update, follow these instructions to correct it.

How do you avoid EDI transmission problems due to asterisks in item descriptions?

(+I-C) Clear Asterisk from Items is used in case item descriptions contain asterisks. When using EDI, these asterisks can cause transmissions to terminate. (+I-C) lets you remove asterisks from item descriptions. See O/PUS Toolbox (pdf).

Which United Consumer Pricing column do I load for tier "level" consumer pricing?

When you are loading your United pricing files, the O/PUS loading program will prompt you to enter a United Consumer Pricing Column.

Each quarter, United Stationers publishes a spreadsheet called Price Plan Code Chart. You can use that chart of price plans to help you determine which United Consumer Pricing Column corresponds to the "consumer level" you need to load. To view United’s latest Price Plan Code Chart, link to www.ussco.com, log into the Classified Zone, and select the “Item File/Unitape” page.

How do you look up 4-digit page numbers (greater than 999)?

As you may know, the DDMS system's vendor catalog page number field in the wholesaler record only holds 3 characters. O/PUS uses a lettering scheme to designate page numbers greater than 999:

Page numbers between 1000 and 1099 appear as "M##," where the Roman numeral M represents 1000 and ## represents the last 2 digits of the page number. For example, page 1057 would be M57.
Page numbers in the 1100 - 1199 range appear as "E##" where the letter E represents 11 hundred.
Page numbers in the 1200 - 1299 range appear as "T##," where the letter T represents 12 hundred.
Page numbers in the 1300 - 1399 range appear as "H##," where the letter H represents 13 hundred.
Page numbers in the 1400 - 1499 range appear as "F##," where the letter F represents 14 hundred.
Page numbers in the 1500 - 1599 range appear as "V##," where the letter V represents 15 hundred.

What if you find duplicate stock numbers?

As a result of manufacturer mergers and acquisitions, the same item number is sometimes used for two different products. In some cases, this causes one product to get updated with information from a different product that has the same number. In 2Q2003, we began reporting affected stock numbers. Check your inventory records for each stock number, and make corrections if necessary. For detailed instructions, see Correcting Duplicate Stock Numbers.

Are ActionEmco costs of $9999.99 a little unusual?

Although a cost of $9999.99 for certain ActionEmco items seems exorbitant, rest assured that those costs are not true dealer costs. Below, Ed Ritsema of ActionEmco explains why:

"The Catalog files (R7, M7, and C7) as well as all our Matrix files (1KA, 1KB . . . . 1ZA, 1ZB, 1ZC) all have the costs set to a high amount (9999). This is because these files are provided only to supply Consumer Pricing. They are not used to set dealer costs. So by setting the cost in them high, the prices in the file should not interfere with their system finding their true best cost on any given item."

How do you change the Co (company) field for all affected item keys?

(+I-B) Build NEW-C-ITEM is used to to change the Co (company) portion of the item key (which contains the item number and Co fields). This tool changes the I-MASTER record and creates the NEW-C-ITEM file on your inventory unit. The NEW-C-ITEM file can then be used by the Ensite Pro program ;SPCCHG_IT to change the item keys in all related files, with two exceptions: Short-buys and Receipts. When this process is complete, run the (MLQ) ;SPCCHGIT program to perform the item key changes procedure. See O/PUS Toolbox (pdf) and the (MLQ) section of Updating Sales Journals After Loading O/PUS (pdf).

How do you use customer and wholesaler minimums to avoid breaking cartons?

(+I-M) Move I-WHL PER field to I-PRICE MIN Field sets your customer’s minimum order amount (from your pricing record) to equal your wholesaler's minimum purchase amount, so you can avoid having broken cartons of non-stock items on your shelves. The PER field of the I-WHL record indicates how many of your selling units, set in the I-MASTER record, are needed to make up the minimum buying unit set in the I-WHL record. See O/PUS Toolbox (pdf).

How do you swap item keys from NEW-C-ITEM to I-CAT?

(+I-N) NEW-C-ITEM Key Swap for Scanalog updates the keys of the I-CAT file (used in the Scanalog) with changes contained in the NEW-C-ITEM file. See O/PUS Toolbox (pdf).

How do you reset contract quantity breaks?

(+I-W) Set Quantity Breaks in Contract to 1 can be used to create or overwrite a contract with one that has only single quantity breaks. See O/PUS Toolbox (pdf).

How do you create Reference Only items?

(+I-X) Cross Reference Prefix in Item creates Reference Only items that let you access items using the item’s prefix and item number. Notes: You cannot limit the item information. Running this procedure affects all the items in your inventory. See O/PUS Toolbox (pdf).

How do you use Make-Buys to make adustments when vendors change item buy UOM?

See the completely revised! Handling Vendor UOM Changes With Make-Buys (pdf) Each quarter major wholesalers change their buy unit of measure (UOM) for some items to reflect purchasing trends. Using the SIMPLE wizard, you can opt to ensure your selling units match your vendors’ new buying units on the stock classes you specify. The Make-Buys program converts your selling units to the new buy units, and automatically recalculates costs, prices, contracts, inventory quantities, shipping weights, and history totals accordingly.
The (+I-Y) Make-Buys program can also be run manually (not recommended). See O/PUS Toolbox (pdf).

How do you view an item's I-CAT records and the program IDs that set the pricing?

(+I-E) Electronic Catalog (O/PUScanalog) displays the specified item's record from I-MASTER, I-PRICE, and I-WHL, along with I-CAT records for any other vendors you have loaded who carry the item you specified, indicating the program ID where its pricing comes from. See O/PUS Toolbox (pdf).

How do you hold list/cost changes when updating prior to the beginning of the quarter?

(+I-P) Item Updating, Viewing, Reporting From OPS-CHANGE lets the dealer keep item information changes to help facilitate business decisions, price label printing, and item reporting. It can be used by those dealers who want to update their item files prior to the actual beginning of the upcoming quarter, but not allow the List Price and Cost to be updated. See O/PUS Toolbox (pdf).

How do you use the Electronic Ribbon Locator program?

See See The ERL Manual (pdf) for documentation for the Electronic Ribbon Locator program.

Can you import/ export data to and from DDMS with Contract Wizard or FileMapper?

Yes. This letter about importing and exporting information from your I-CAT file (pdf) discusses the legal and practical issues involved in importing and exporting information from O/PUS's I-CAT and I-MFG files. See also:

File # 246: O/PUS Contract Wizard (pdf) This a free Windows-based application will allow you to convert/import an Excel spreadsheet into a DDMS contract. This document provides instructions for installation, running Contract Creator for the first time, what columns to create in Excel, and how to import the spreadsheet into your DDMS Contract.
FileMapper documentation (pdf) Do you have inventory data including Direct Buy Costs from manufacturers such as Smead, 3M, Fellowes, and so on? The O/PUS FileMapper program for Windows lets you quickly convert manufacturers’ product data into a DDMS-compatible format. You can then use the U_MFG loading program to load the data into your DDMS system’s I-MFG Direct Buy Record.

To obtain the Contract Wizard or FileMapper software, contact O/PUS at opus@eci2.com.

Return To Top

Documentation

FYI² Notes (pdf) and FYI² Canadian (pdf) The For Your Immediate Information — OPdb MultiVendor Update newsletters are published online quarterly when the current quarter's OPUSInstall software update and OPdb®/OPdb2 multi-vendor catalog update databases are ready for release. The newsletter includes information about software enhancements for the O/PUS PSNControl download software, the SIMPLE loading wizard, Super Store Data Update, and other software and services from O/PUS and ECI² Content Services. The newsletter also announces new vendors, shares important notes from vendors, and includes a chart of pricing programs, consumer price levels, and dealer cost levels for each vendor included in the OPdb or OPdb2 catalog update.

Updated! O/PUS Quick Reference (pdf) This two-page checklist includes: Pre-Load Steps (One week to 24 hours before loading O/PUS), Loading Steps (Immediately Before Loading O/PUS), Post-Load Steps (When O/PUS Load is 100% Complete), Optional Steps, and Additional resources & links.

New! Loading O/PUS Multi-Vendor Quarterly Update (pdf) This handout, along with the Toolbox handout, replaces the original Complete O/PUS Multi-Vendor Documentation and O/PUS Made SIMPLE. It covers all of the basic quarterly catalog update concepts and procedures for Ensite Pro™. It includes the O/PUS Quick Reference, as well as detailed instructions for 1) downloading and running OPUSInstall to update all O/PUS software; 2) Using PSNControl to Download Quarterly Update Files and Vendor Pricing Files; 3) Running the SIMPLE Wizard to process the data; 4) viewing report messages; 5) processing price files; 6) keeping your database clean; and more.

Canadian Multi-Vendor documentation (pdf), (rev 12/01) For detailed instructions on loading and maintaining your inventory with O/PUS' Canadian edition. Also see FYI² Notes for O/PUS Canadian Customers (fyi2_Canada.pdf; Revised 4/11/2007).

New! O/PUS Toolbox (pdf)The O/PUS Toolbox is a collection of text-based (+I) programs for managing your Ensite Pro™ inventory catalog, costs, pricing, and purchasing preferences. Learn how to adjust costs, prices, dates, and profits; build or create vendor contracts; set and modify your purchasing vendor; move, modify, and classify your data; process vendor unit of measure (UOM) changes to recalculate costs, prices, contracts, inventory quantities, shipping weights, and history totals; view various reports; build SuperIndex; process vendor price files; implement page numbers from special catalogs; and more.

Updated! Setting Up and Using the O/PUS® PSN (pdf) Learn how to set up appropriate parameters, install and use O/PUS PSNControl software, and download and process vendor pricing files, flyers, programs, and catalogs. Also learn how to download the quarterly Multi-Vendor Catalog Update database via PSN, and schedule your PSN downloads with PSNControl.

Super Store Data Update (pdf) Load the Super Store Data Update software and quarterly data into DDMS® Ensite Pro™. Important notes: SSD import software is installed and/or updated via your quarterly OPUSInstall software update, which must be downloaded and run from the ddms.com Web site after it is released each quarter. The quarterly SSD database file must be downloaded using PSNControl. The standard edition (filename SSDitems) includes super store name and SKU. The premium edition (filename SSDpricing) includes everything in the standard edition, but also includes pricing, units of measure, and packaging information; the premium pricing edition requires authorization from Trade Services. TIP: To prevent overwriting your SSD Updates, you must run the SSD Update as an optional post-load procedure, after running SIMPLE. TBL Server must be running for the import to work properly, as with all other pricing files and catalog updates. You must rebuild Super Index (+I-I) so that the Order Entry, Purchasing, and integrated Web storefronts such as Dealer Station® and is.D-Force® will accept the input of the superstore item numbers.

Using ECI² Content Services Instant Contract Eraser (csICE) (pdf) Instant Contract Eraser (csICE) is a new application for deleting contracts and price plans. It is designed to dramatically speed up the price file load process. OPUSInstall will install the standalone application on your system.

PSN "File Not Found" (pdf) If you are using the O/PUS PSN, use the instructions on this form to check availability for files with PSNControl software. If two business days have passed since your vendor representative has confirmed they sent the files to O/PUS, and PSNControl still indicates "File Not Found," submit this form. A technician will confirm file availability so you can update. You can even fill it out online and print for optimum readability! See online PDF form instructions. For even easier emailing, use the Word document version (file: PSNFileDownload.doc).

Updated! O/PUS MAC codes (pdf) Three-digit codes that identify manufacturers. The system displays these codes in the CO field in the (E) screen. (Revised 9/20/2007)

FileMapper documentation (pdf) Do you have inventory data including Direct Buy Costs from manufacturers such as Smead, 3M, Fellowes, and so on? The O/PUS FileMapper program for Windows lets you quickly convert manufacturers’ product data into a DDMS-compatible format. You can then use the U_MFG loading program to load the data into your DDMS system’s I-MFG Direct Buy Record.