Home > SI5 Documentation > User Guide > Product Data > Editing Products > Exporting Products

Exporting Products

How to Export Products From Your Database

A way to edit multiple Products at one time is to export your data to an Excel spreadsheet.  This is particularly useful for updating prices for a large number of Products.

Open the MMPD interface and click the Product Grid tab.  The Product Grid screen will display:

File:Managing_Data/Adding_Products_to_Your_Database/Exporting_Products/image001.jpg

Use the tabs to filter your Products to the ones you want to export.  The Products will display in the grid:

File:Managing_Data/Adding_Products_to_Your_Database/Exporting_Products/image002.jpg

Click PDM Export to Excel.  The Export form will open.

File:Managing_Data/Adding_Products_to_Your_Database/Exporting_Products/image004.jpg

Accept the license agreement and click [Next]:

File:Managing_Data/Adding_Products_to_Your_Database/Exporting_Products/image005.jpg

Choose your path and filename and change the Field Delimiter if necessary.  When ready, click [Export].  If you left the “Open in Microsoft Excel after export” options checked, Excel will launch and the file will be ready for editing.

notes_50After you have made your modifications to the spreadsheet, follow the instructions in the Import Products section of this guide to import your changes.  See Importing Products

 

Last modified
13:53, 26 Nov 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.