Exporting data from the e-commerce site

image\btnseeal.gif

For the users' convenience, the e-commerce site has several features to export data to other applications.

image\notepin.gif Number Format: The number and currency format on the e-commerce site has to be the same as the Regional Settings format on your computer for the export functions of numeric data to work correctly.

LINE ITEMS

č   To export the basket's line items:

ˇ  use the right-click menu item copy on the basket grid (Basket Grid ON).

Click for detailed procedures to export and to import items and a description of the spreadsheet columns  

SEARCH RESULTS

č   To export the list of items on the Search Results page:

1 Search the product database with the search function on the left hand site.

2 Click view in excel above your search result items.

3 Save the view in spreadsheet format on your computer (File | Save As). 

MODEL SELECTIONS

č   To export a model and its break level selections:

Click the Excel icon on the Real Time Configurator

BASKET LIST

č   To export the list of baskets:

1 Click view in excel above the basket list on the Team Buy All Baskets page.

2 Save the view in spreadsheet format on your computer (File | Save As, file of type .xls).

See also how to create a report of open quotes

ORDER STATUS LIST - (not all e-commerce sites)

č   To export the Search Results from Order Status:

1 Click view in excel above the List of orders.

2 Save the view in spreadsheet format on your computer (File | Save As).

image\idea.gif Click "Show line item detail" link located at the top of the page to pull information related to your order to the spreadsheet. 

E-COMMERCE ORDERS

č   To export a user's orders placed on the e-commerce site:

1 Select My Orders | Web Order History on the menu.

2 Click view in excel above the list.

3 Save the view in spreadsheet format on your computer (File | Save As)