Need more info or you couldn't find what you were looking for, let us know by sending an email to: support@dancik.com.

Using CMS to Exchange Item Catalogs

Associated Files

Submitting a Price Catalog Request

Receiving an Item Catalog

Fields Included in the Item Catalog

Item Attribute Mass Update

Associated Files

Global Settings

Note:  The Partner Settings, accessed via CMS 20, override the Global Settings.

Adding Partners

Submitting a Price Catalog Request

Note: Use the link ‘IP address of server’/netdata/cms832extr.mbr/extract to request price catalogs as an administrator.

1. The next part of the process is to actually extract the information you want to send. This is done through the web portion of CMS.

2. Enter an Account Number, a Partner ID and Effective Date.

Note:  Effective dates do not consider information in the Future Price File (FIL 28). However, future promotional pricing is included.

3. Click one of the three selection parameters (Product Line, Manufacturer, Category). These options can only be used individually.

4. In the example shown below, manufacturers are selected. Note that when selected they are moved into the Selected column.

5. If this partner already has a catalog and you just want to send out new pricing, select Price Changes Only. Choose the delivery type; either FTP or CSV. If you choose CSV (e-mail) as the delivery method, you must enter an E-mail Address.

6. The email is sent with a return email address that is configured with ODS. To change this address, follow these steps:

• Enter the command ODSAUTHODS so you can update ODS files.

• On the ODS menu, select option 1 - Authorization Maintenance. This option lets you know if you are authorized to update ODS files.

• Return to the ODS menu and select option 2 - Initial Distribution Options.

• Press F9 and change the email address on the Work w/ E-Mail Defaults screen that appears.

7. The Scheduler settings become active depending on how you send the information, FTP or CSV/Email file, and if you elect to send a complete catalog or just pricing changes.

If you are extracting pricing changes, you can select a day, month, or time for CMS to automatically extract the changes.

8. Click Submit. Depending on your settings, a price catalog is created as a X12 or .CSV file. If it is an X12 document, it gets sent via FTP and a .CSV spreadsheet gets emailed.

Receiving an Item Catalog

The basic steps involved in receiving an item catalog from your suppliers are as follows:

• A CMS partner generates an X12 item catalog using established B2B formats. Once the catalog is developed, the manufacturer needs to submit it to the distributors. This can be done by several methods including: E-mail or through an IFS server.

• The receiving CMS partners must manually get the X12 catalog from wherever it was placed by the generating CMS partner.

• The X12 Item Catalog is converted to a spreadsheet using option 1 - Convert X12 Price Catalog to a Dancik format Spreadsheet on the CMS menu.

• Enter the directory where the X12 price catalog resides in the X12 Price Catalog Input File field.

• In the Output File field, enter the directory where you want to place the reformatted item catalog.

• Press Enter. The system converts the X12 formatted item catalog to a spreadsheet (.xls) that the Dancik system can easily read and use.

• The partners can then automatically update their records or they can modify the item data to better suit their needs.

Fields Included in the Item Catalog

The table below describes the fields that comprise the item catalog. These values are important to the CMS partner (usually a manufacturer) that generates the item catalog.