Import invoice and shelf-ready data from MARC file
Basics of importing invoice and shelf-ready data
The following tables outline the information that should be included in the data files you receive from your vendor. The data files must be set up by you and your vendor before you can import data files into WorldShare Acquisitions. You can provide your vendor with the information on this page to confirm they can supply you with the data in these fields.
MARC invoice data
The following information should be included in the invoice 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.
Notes when setting up invoice data import
- You can only import service charges and shipping at the invoice item level using the MARC record format. For importing invoice-level service charges, use the EDIFACT format.
- Item level service charges are imported per unit. This means that the service charge will be multiplied by the quantity to calculate the full service charge for the item. This could result in higher-than-anticipated service charges if the quantity is greater than one.
- Item level taxes can only be imported as a percentage, not an amount.
MARC shelf-ready data
The following information should be included in the shelf-ready data file you receive from your vendor.
Import invoice and/or shelf-ready data instructions
Instructions vary, depending on the type of invoice you are importing (MARC or EDIFACT). If your invoice and shelf-ready data are included in one file, you will only need to import the file once. If your invoice and shelf-ready data are on two files, you will need to import each file.
Shelf-ready data only applies to single part monographs.
Upload file
A vendor must be marked as In Use in order to upload data.
- From the left navigation, expand Vendors.
- Search for the vendor whose data 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.
- On the Import Data window, from the Type list, select Import invoice / shelf-ready data (MARC).
- Click Choose File.
- Locate the invoice and/or shelf-ready data file on your computer. Click Open.
- 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.
- If you only uploaded invoice data, go to Review invoice and invoice items.
- If you also uploaded shelf-ready data, also go to Receive shelf-ready items.
Review invoice and invoice items
The file you uploaded appears in the first row of the Processing Log. If you do not see the file in the table, click the Refresh button () above the table. After you upload the file, you will also receive an email with the file's import details.
- The system creates an invoice for you based on the data you imported.
- The Details column links to the invoice created as a result of the upload. In the Details column of your invoice import, click the Invoice: link. This will bring you to the invoice with the items already added.
- The item amounts, discounts, service charges, and taxes will be populated if included in the invoice data file.
- You will also receive an email notification that will give the status of the import and of each item. This email text is also viewable in the Details column of the processing log.
- To pay the invoice, go to Pay invoice.
Receive shelf-ready items
There are two ways to receive shelf-ready items:
- Using the links in the Partner Exchange Services logs
- Using the Receive and Invoice screen
Receive shelf-ready items using the Partner Exchange Services logs
Follow the instructions below if you imported a shelf-ready data file.
- From the left navigation, expand Vendors.
- Search for the vendor whose files you imported.
- From the vendor search results, click the Vendor Name.
- In the vendor record, click the Partner Exchange Services accordion.
- In the Processing Log, in the Details column, click the first Receive: link. This will bring you to the Receiving screen.
- On the left navigation, under Receive and Invoice, in the Action list, select Receive.
- For each item:
- The call number and barcode of the item will be populated.
- Place your cursor in the Barcode field and press <Enter> to receive the item.
- The item appears in the Item(s) processed in this session section at the bottom of the screen. The item is received and a local holdings record is created.
- Repeat process if there are additional Receive: links listed in the Details column of the Processing Log.
Receive shelf-ready items using the Receive and Invoice screen
- From the left navigation, expand Receive and Invoice.
- Select Monograph from the Processing Type drop-down list.
- Select Receive from the Action drop-down list.
- Click View Items.
- Select Order Number from the Search drop-down list.
- Enter the order number (e.g., PO-20218-15) in the Search Text form field and press <Enter> to bring up all items on the order.
Or
Do one of the following for each item:- Select Title from the Search drop-down list and enter the title in the Search Text form field, then press <Enter>.
- Select ISBN from the Search drop-down list and enter the ISBN in the Search Text form field, then press <Enter>. The ISBN can be scanned from the UPC barcode.
- Select Barcode from the Search drop-down list and enter the Barcode of the item (if imported in the shelf-ready data) in the Search Text form field, then press <Enter>.
- For each item:
- The call number and barcode of the item will be populated. (You can verify the call number and barcode are correct.)
- Place your cursor in the Barcode field and press <Enter> to receive the item.
- The item appears in the Item(s) processed in this session section at the bottom of the screen. The item is received and a local holdings record is created.