Booksellers – Creating Custom Order Exports

The Custom Exports feature lets you build your own report template for downloading order files from Edelweiss. If you use a POS system for which we don’t offer a pre-formatted export, this could be your first step to downloading your Edelweiss order and importing into your system. Or perhaps you simply would like to save and/or print your own customized version of your order.

The basic idea is that you pick a type of report – text, or Excel – and ‘rollup’ or not. A Rollup report is a type of pivot report that would only be used for a multi-store account’s order, where you want one row per title in the report that shows each store’s order quantity, along with an order quantity total.

To get started, click on your user icon in the top right hand corner and select Settings and Preferences.

Select Custom Exports.

Type a name and description for your file template, and click the save icon.

You’ll see your new format listed on the screen and can click into this in order to edit the format.

SNAG_Program-0094

You’ll now see a screen where you can customize your report.

Output Type: For a single store, or non-rolled up multi-store report, you must select either Text or Excel here. If you are creating a report to email to someone, print, or edit yourself, Excel is the best option here.

Delimiter: If you selected Text as your report type, you will have the further option to set a delimiter. A delimiter is a character that will distinguish one field from the next so that when it is imported into another program it can separate the fields. The options are comma, pipe (which is one of these lines | ), and tab character. **To export as a .csv file set the Output Type to Rollup – Text and the Delimiter to Comma**

Shared: if you check this box, other Edelweiss users at your store will have access to use (but not edit) your format. If other buyers at your store could find your new format useful, this is a way to save them from creating the same custom format separately. If you are not sure, you can come back here and change this later.

Header: This box is checked by default. It means your file will have the field name as a header at the top of each column. For importing into other systems, it’s sometimes better to have no header. But for viewing or printing in Excel it is usually helpful to see them.

Selecting fields: To select fields to export, you will need to drag and drop the names of the data elements you want to see from the Hide box to the Show box. By default, you will see that the Show box will include the EAN and a few other key data elements already. Drag other fields over to the Show box, and arrange them in the order you want them to appear in your exported file. Note: the drag and drop action on this screen is a bit touchy, so you may need to drop a column header towards the top of the contents in the Show box and then rearrange the headers once you’ve got them all there. The store’s order quantity is the field called ‘units’, so make sure you include that.

Most of the column headers you’ve got to choose from are self-explanatory, but there are a couple that warrant a brief note:

BIC is the title’s BIC (Book Industry Communication) subject code, as provided by the publisher

BIC Description is the title’s BIC (Book Industry Communication) subject description, as provided by the publisher

BISAC Category Code is the title’s BISAC (Book Industry Standards and Communications) subject code, as provided by the publisher

BISAC Category Code Description is the title’s BISAC (Book Industry Standards and Communications) subject description, as provided by the publisher

Catalog Sequence is the original numerical placement of the title in its Edelweiss catalog. If you include this in your export format, it gives you a way to re-sort the order later in Excel if you want to review the order in catalog sequence. Currently, orders will be exported in the sequence that corresponds to how the buyer entered the order, which may not be in catalog order. If the order contains items from several different catalogs, and you want to sort things in Excel into the original catalog orders within each catalog, then include export Catalog Name to use for sorting as well.

CLIL is the title’s CLIL (Content and Language Integrated Learning) code, as provided by the publisher

CLIL Description is the title’s CLIL (Content and Language Integrated Learning) description, as provided by the publisher

Format Code is the title’s format code, as provided by the publisher. Learn how to map your POS system’s format codes in Edelweiss here 

Format Description is the title’s format description, ie. Hardcover, Trade Paperback, Mass market, etc.

PO Number is the Purchase Order number assigned to the order. Note, on PO Numbers will only pull when you export using the Export Preview function on an order, and will not pull from a standard catalog export

Product Link will show the title’s Edelweiss URL

Publisher Code is the publisher or imprint code. Learn how to map your POS system’s publishing codes in Edelweiss here

Publisher Name is the publisher or imprint name as provided by the publisher

Vendor Code is the distributing publisher code. Learn how to map your POS system’s vendor codes in Edelweiss here

Store Category reflects the store’s own section/subject designation. Learn how to map your POS system’s category codes in Edelweiss here

Store ID reflects the store’s Edelweiss internal ID code which is probably only meaningful for Treeline client stores. You may want to include Store Name instead

Thema is the title’s Thema code, as provided by the publisher

Thema Description is the title’s Thema description, as provided by the publisher

Units on Order are the quantity you have on order. Note, on order quantities will only pull when you export using the Export Preview function on an order, and will not pull from a standard catalog export

Quick note, some title attributes, such as summary, marketing info, reviews/quotes, and images cannot be exported to an Excel or text file. For these attributes you can create a PDF

When you are done, click the Save button.

Then, you can click on Custom Exports to add other new formats.

At this point, your format becomes an option in the drop-down list of formats when you go to the Orders tab, and select Export Preview for an order. Once you select the format, then you can review the contents, and see if the report looks roughly the way you would like it to, and then click Download to create a file.

You can create as many of these Custom Export templates as you need, and can always come back and modify or delete your formats through the Administration tab.

If you have not set your POS system default or set it to “None of the Above”, your last used custom export will be saved as your preferred export type.

When you’re viewing the list view of a group of titles, either from within a catalog, a tag grouping, or search results, you may also select the titles you want to download and then choose Export from the Action menu at the top of the list view to download those titles and order quantities using a custom export.

Side note about comma delimited files: Comma-separated files will have quotes around the text fields like title and author. This is standard practice so that normal commas within these fields are not mistaken for delimiters, but the quotes will be removed as you import into another program.

Also, comma delimited files will be exported with a default filename extension of “.CSV” for “comma-separated values” which is a shortcut way for programs importing a file to know that it is comma-delimited. Excel will tend to automatically open CSV files even though they are not technically Excel files. If you do open a CSV file with Excel, you will notice that the EAN will look goofy – because it looks like just a very long number Excel converts it to scientific notation. To convert it into a readable EAN, select the column, right-click, and select ‘format cells.’ Then choose to format as a ‘number’ with 0 decimal places.

“Rollup” Reports for Multi-Store Accounts: Rollup report types are specifically designed for organizations with multiple stores: like a pivot report, each title appears as a single row with the individual and/or totaled (all store) orders positioned in distinct columns horizontally.

ReportType: For report type, select or Rollup_Text or Rollup_Excel. If you do pick the Text version of rollup, you may also select the ‘delimiter.’ If you are creating a report to email to someone, print, or edit yourself, Rollup_Excel is the best option here.