Documentation How to Load O/PUS, Vendor Files
This page provides instructions for loading:
- O/PUS Quarterly Multivendor Database Updates and using associated software.
- Monthly Updates.
- Vendor-specific flyers, catalogs, promotions, and contracts.
Documentation for Loading O/PUS Quarterly Updates
- FYI² Notes Quarterly Newsletter
-
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.
See also O/PUS News This Quarter and Archives.
- O/PUS Quick Reference Checklist (TIP: Use a New One Every Quarter!)
-
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.
- SIMPLE Wizard: Loading O/PUS Multi-Vendor Quarterly Update
-
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 DDMS. 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
-
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).
- (+I) O/PUS Toolbox
-
O/PUS Toolbox (pdf) The O/PUS Toolbox is a collection of text-based (+I) programs for managing your DDMS 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.
- UpdateSPR and UpdateUNI MultiLoaders: Loading multiple price files at once
-
Load Multiple S.P. Richards Price Files At Once How to use the UpdateSPR multi-loader software.
Load Multiple United Stationers Price Files At Once How to use the UpdateUNI multi-loader software.
- PSNControl (O/PUS PSN, and what if "File Not Found")
-
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.
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).
- Super Store Data Update (SSD)
-
Super Store Data Update (pdf) Load the Super Store Data Update software and quarterly data into DDMS® . 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.
- Instant Contract Eraser (csICE)
-
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.
- MAC Codes (Manufacturer 3-digit codes in the Co or Company field of the Item record)
-
O/PUS MAC codes (pdf) Three-digit codes that identify manufacturers. The system displays these codes in the Company field of the Item record, or CO field in the (E) screen. (Revised 12/1/2009)
- Contract Wizard to Import Excel Spreadsheet
-
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 to convert Manufacturer product data & load into DDMS Direct Buy Records
-
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.
Monthly Price File Update Instructions
Vendors are increasingly moving to monthly pricing updates, in addition to the quarterly item updates. However, each vendor's file may require different loading options and methods:
Vendor Price File Loading Instructions
Vendor-specific flyers, catalogs, promotions, and contracts are available for download via the O/PUS PSN.
Supplemental
Vendors (listed below*) may not update their pricing files
on the same quarterly schedule as other suppliers. For additional
information, see O/PUS
Supplemental Vendor Information (pdf).
- All Value program: U_ALLV
- All Value Price Update Instructions
- * Arlington program: U_ARLI (pricing file last updated 12-28-2009)
- Arlington Update Instructions (pdf)
- Avery program: U_AVE
- Setting Up & Using the Avery PSN, Custom Binder Microsite (pdf)
- Azerty program: U_AZER
- Azerty Update Instructions (pdf)
- * Diversified Computer Supplies program: U_DCS (pricing file last updated 10/30/2009)
- Diversified Computer Supplies Update Instructions (pdf)
- * Doane Keyes program: U_DOAN (pricing file last updated 12-18-2009)
- Doane Keyes Update Instructions (pdf)
- * Educators Resource program: U_EDRES (pricing file last updated 1/19/2010)
- Educators Resource Update Instructions (pdf)
- * Equipment Distributors
- file names and instructions are available from Mike Prichard at 1-800-366-6636
- Forms & Supply
- (contact ECi Technical Support for these instructions).
- Hallmark program: U_HMK
- Hallmark Update Instructions (pdf)
- Horizon program: U_HORI
- Horizon Update Instructions (pdf)
- Image Star program: U_IMAG
- Image Star Update Instructions (pdf)
- is.group (Independent Stationers)
-
File names and instructions are available from their Web site: www.isgroup.org
After you log in, navigate to "Distribution", select the drop down arrow, choose "Distribution" and click "DDMS Processing and Maintaining Info."
- * Lagasse program: U_LAG (pricing file last updated 12/16/2009)
- Lagassse Update Instructions (pdf)
- * MeadWestvaco program: U_MWV (pricing file last updated 9/1/2009)
- Loading the MeadWestvaco Price File in DDMS (pdf), for your AAG Calendars & Planners Microsite on ECinteractive and Dealer Station
- Norwestra (now SPR Canada) program: U_SPR
- SPR Canada Update Instructions - text-based (pdf) (name changed as of 1Q 2004) or Load Multiple S.P. Richards Price Files At Once
- OF/USA
- Contact Ron Mayfield, 800-872-2728 xt. 130, for these instructions.
- Office Partners
- Contact ECi Technical Support for these instructions.
- * Pens Etc. program: U_PENE (pricing file last updated 12/30/2009)
- Pens Etc. Update Instructions (pdf)
- * Printer Essentials program: U_PRTESS (pricing file last updated 6/17/2009)
- Printer Essentials Item Catalog Update Instructions (pdf)
- S P Richards program: UPDATESPR or U_SPR
-
S.P. Richards Monthly Price Plan Update
Load Multiple S.P. Richards Price Files At Once (pdf)
S.P. Richards Update - text-based (pdf) or - DMI Supplies Network program: U_DMISN
-
In addition to the quarterly update using the SIMPLE wizard, Supplies Network provides a downloadable Price List file that contains item price changes and product information via their Web site, www.suppliesnetwork.com. ECi Content Services’ SNcustom program allows you to import the product information from the Supplies Network price file into the ECi™ DDMS® Item database. For detailed instructions, see SN Custom Price List (pdf).
- * Synnex program: U_SYNX (pricing file last updated 2/6/2009)
- Tech Data program: U_TECH
-
Price files and the ProdList.exe item file are available for download from www.techdata.com.
The O/PUS TechMapper application, available upon request from opus@ecisolutions.com, is required to convert TechData files to a format readable by your DDMS® system.
- TriMega Purchasing Association (TPA)
-
If you are a TriMega Purchasing Association member loading the TriMega Edition of the OPdb updatePSNControl 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).
- United Stationers program: UPDATEUNI or U_UNI
-
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.
United Stationers Monthly Price Plan Update
Load Multiple United Stationers Price Files At Once (pdf) - graphical
United Stationers Update - text-based (pdf) - Xstamper program: U_XSTAMP
-
Updated! Setting Up and Using the Xstamper PSN (pdf) Set up appropriate parameters to load items, transmit purchase orders and request acknowledgements via the PSN with Xstamper. Also learn how to update your Item files using PSNControl, and activate the Microsite in your legacy Web storefront.