You can import order data in MARC format using the 9xx fields in the MARC record. Before importing order data, however, you will need to set up importing with your vendor. This may include sending the MARC order data fields to the vendor.
This topic concerns importing order data for Plan orders (e.g., approval plans, DDA plans, etc.). For importing purchase orders, see Import purchase order data from MARC file.
Basics of importing order data
MARC order data
The following information should be included in the MARC order data file you receive from your vendor.
If decimal points are not used, the system adds them at the end. For example, 56 becomes 56.
- MARC order data - Table
MARC Element in Acquisitions Input type Description 035 $a OCLC Number OCLC number in this format: (OCoLC)1553114 The OCLC number is used to identify the bibliographic record in WorldCat that the order item is attached to. If you do not include an OCLC number, the system tries to find a matching record in WorldCat based on other values in the bibliographic record provided (e.g. title, author, ISBN). 949 $h Branch Integer User-entered value; represents the WorldCat Registry ID of the Home Branch Location of an item. 949 $l Shelving Location String User-entered value; represents the Shelving Location of the Home Branch Location of an item. 949 $p Fund Code String (Maximum: 40 characters) User-entered value representing the code of the fund used for encumbering.
- The items associated with the disabled fund will be imported.
- You will receive a warning for those items in the logs and an email notification informing you that the fund cannot be imported because it is disabled.
949 $q Copy Quantity Integer (Maximum: 999) Number of copies ordered. 980 $b Unit Price Decimal (Maximum: 9,999.99) Cost for a single unit of an item. (Do not include tax or discount, if you plan to include these as percentages in the 980 $h or $i.) 980 $c Service Charges (per unit) Decimal (Maximum: 999.99) Service charges for a single unit of an item (e.g. $1.00 for Quantity of 5 equals $5.00). 980 $h Tax Percentage Decimal (Maximum: 100.000) Percentage of tax applied to price by vendor.
- You can assign a percentage value up to three decimal places (e.g., 7.745%).
- Percentage values with four decimal places will be rounded off to three decimal places (e.g., 7.7454% will be rounded to 7.745%).
- By default, the percentage value has two decimal places unless a third decimal place is entered.
980 $i Discount Percentage Decimal (Maximum: 100.00) Percentage of discount applied to price by vendor. 980 $k ISBN Integer ISBN of item being ordered. Not used for matching. The bibliographic 020 field is used for matching. 980 $m ISSN Integer ISSN of item being ordered. Not used for matching. The bibliographic 022 field is used for matching. 980 $s Shipping and Handling (per unit) Decimal (Maximum: 999.99) Shipping and handling charges for a single unit. 980 $x Exchange Rate Decimal Exchange rate for the order, if currency is not the same as Library Currency. 980 $z Currency of PO ISO 4217 Three letter currency code ISO Currency Code - for Order 981 $a KB Collection Identifier String Identifier for the WorldCat knowledge base collection being ordered. 981 $b KB Title Identifier String Identifier for the WorldCat knowledge base title being ordered. 981 $e External Order ID String (Maximum 50 characters) Unique identifier for the order used by an external financial system.
Note: You can import your External Order ID using MARC order data by having your vendor add the External Order ID in field 981 subfield $e of your MARC order records. Once imported, the External Order ID will be inserted into new orders created as a result of the MARC file.
- If the value of 981 $e is greater than 50 characters, the input will not be imported and an error will display in the logs.
- If the value of 981 $e is different for two records on the same order, the first External Order ID will be used and an error will display in the logs.
981 $g Account Number String Account or customer number, used by library for ordering and invoicing. (Also called "Subaccount") 981 $i Library Item Note String (Maximum: 256 characters) Notes provided for an item. 981 $l Order Name String (Maximum: 256 characters) Text string, representing name of order or cart. 981 $n Vendor Order Number String (Maximum: 256 characters) Internal number used to identify order by vendor. Provided to library for tracking purposes. 981 $x Library Order Comment String (Maximum: 256 characters) Comment on an order.
Vendor Order Item Number
Required if importing invoice or shelf-ready data.
String (Maximum: 256 characters) Unique identifier provided by a vendor for specific item ordered.
Important note about plan order data
Plan orders are orders of any type other than Purchase Order. When importing plan order data, you will be adding order items to an existing order. This means:
- You must first create a plan in WorldShare Acquisitions. There are six different types of plans you can create in the system. See Order Types for details.
- You must have the vendor order number in the 981 $n field of your order data.
There are two different times at which your data can be delivered to you:
- Time of order (e.g., order data)
- Time of shipment (e.g., invoice data)
If you import order data at the time of shipment, there is a possibility of the order items not being grouped as they are on the order.
Your data also might be delivered to you:
- Directly from the vendor
- Through WorldCat Cataloging Partners
Import plan order data instructions
How orders are created from imported files
For importing plan orders, order creation should always be based on the vendor order number in field 981 $n. When the field 981 $n contains a vendor order number that matches an existing order, the system will add the items in the MARC file to the order.
If the field 981 $n is empty, the system will create an order of type Purchase order.
Create a plan
You must create a plan in the system before importing any order data associated with a plan. There are six types of plans you can create in WorldShare Acquisitions. See Order Types for details.
- On the left navigation, click Orders.
- On the Orders screen, click New Order.
- On the Add New Order window, enter an Order Name.
- From the Order Type list, select a plan. For details, see Order Types.
- Enter the Vendor whose order data you are importing. As you type, the field will suggest vendors. Select the Vendor from the list.
- Enter the Vendor PO # (Number).
- Each item in the order data file you import must have this number in the 981 $n subfield.
- If this number is missing from the plan, the system will group items onto new purchase orders. See How orders are created from imported order data above for details.
- Click Save.
Upload order data file
Follow the instructions below if you are importing an order data file only.
If your vendor provides you with order, invoice, and shelf-ready data on one file, you will need to upload the file twice (once in this step and once under step 4).
- On the left navigation, click Vendors.
- Search for the vendor whose files you are importing.
- From the vendor search results, click the Vendor Name.
- In the vendor record, click the Partner Exchange Services accordion.
- Click Upload File.
- In the Import Data window, from the Type list, select Import order data (MARC).
- Click Browse.
- Locate the order data file on your computer. Click Open.
- (Optional) Select the budget you want to use when importing the order data file from the Target Budget drop-down list. By default, the current budget period is selected.
- (Optional) Select the Display imported items in WorldCat check box if you want all imported items to appear with the status of On Order in WorldCat Local or WorldCat Discovery after the order is placed.
- (Optional) Select the Verify OCLC Numbers if provided check box if you want the system to use the OCLC number to find the WorldCat record and verify that the bibliographic information of the item matches the record.
- (Optional) Select the Include low confidence matches check box if you want the system to try to find a match in WorldCat for your record even if the normal matching protocols fail to find a match.
- Click Upload.
- The system confirms your file has been uploaded.
- Click Cancel or the x in the upper right corner to close the Import Data window.
Review order items
The file you uploaded appears as the first line in the Processing Log. The Processing Log is the table listing all of the files you have uploaded for the vendor. If you do not see the file in the table, click the Refresh button () above the table.
- In the Processing Log, view the status of the import in the Status column. If the upload fails, it will be noted here.
- The Details column links to any orders created as a result of the upload. Click the PO # link in the Details column to view the order (it will be the order number assigned to the purchase order or plan by the system, e.g. PO-2015-100).
- You will also receive an email notification that provides the status of the import and of each item. This email is also viewable by clicking the .html link in the details column of the processing log.
- Make any other edits to the order items, if needed.