Exporting Inventory

Use the export function in the Product Search Results screen to export your PAYD Pro PlusTM inventory as a Comma Separated Values (CSV) text file.

The data included in an export is based on the search results displayed in the Product Search Results screen at the time of executing the export. This allows you to export your entire inventory or a selected sub-set of your inventory by narrowing results through a simple search or an advanced search.

You can also create a template for your inventory export. Refer to the Creating Inventory Export Templates section below for more information.

To use a saved inventory export template, refer to the Exporting Inventory Using a Saved Template section below for more information.

If you need to make changes during the export, click the Back button at the bottom of the wizard screen. You can also cancel the export at any time by clicking the Cancel button.

To export your inventory:

  1. On the PAYD Administration main screen, click Inventory.

  2. On the Inventory menu, under the Product heading, click Product List.
    The Product Search Results screen appears.

NOTE: To export your entire inventory, skip ahead to step 4.

  1. To select a sub-set of your inventory for export, search the inventory for the desired items to export.

  2. Click the Export button A white letter E, with a white arrow pointing up, on a teal button. at the top of the screen.

The Export Wizard appears.

  1. Click the Next button at the top of the screen.

The Fields Selection screen appears.

TIP: For information on creating an export template, refer to the Creating Inventory Export Templates section below.

  1. Click and drag fields from the Fields that can be exported box to the Order of fields in my file box. To remove a field from the Order of fields in my file box, click and drag it back to the Fields that can be exported box. To reorder the fields, click and drag them in the box as needed.

TIP: To select all the fields, click the Select All button.Double white arrows pointing to the right on a grey button. To remove all the fields from the Order of fields in my file box, click the Remove All button.Double white arrows pointing left on a grey button.

NOTE: For complete field descriptions, see Adding a New Product, Entering Additional Product Information and Editing the Default Product ID.

  1. To preview the export data, click the Next button. If you need to make any changes, click the Back button.

The Preview screen appears.

  1. Do one of the following:

  1. Click the Next button to export the data.

The Download screen appears displaying the name of the export file.

NOTE: If you are exporting a large amount of data, PAYD Pro Plus may need to create more than one export file (maximum 10,000 rows per file). If this is the case, PAYD Pro Plus lists all the export files with a separate Download button for each one. You then must download the files one at a time.

  1. Select the type of export file you'd like to create:

  1. Do one of the following:

  1. To exit the wizard and return to the Product Search Results screen, click Done at the top of the Export screen.

NOTE: To view and work with the exported data in Microsoft Excel, you must start Excel and import the file through the data import function.

 

Creating Inventory Export Templates

PAYD Pro Plus provides you with the ability to create an export template that you can re-use to export your inventory as often as you wish, without the need to perform the steps above each time you wish to export. The export template will save the fields that you drag over in the Fields Selection screen (performed in step 6 above).

To create an export template:

  1. On the PAYD Administration main screen, click Inventory.

  2. On the Inventory menu, under the Product heading, click Product List.
    The Product Search Results screen appears.

NOTE: To export your entire inventory, skip ahead to step 4.

  1. To select a sub-set of your inventory for export, search the inventory for the desired items to export.

  2. Click the Export button at the top of the screen.

The Inventory Export Wizard appears.

  1. Click the Next button at the bottom of the screen to select the data fields you want to include in the export.

The Fields Selection screen appears.

  1. Click and drag fields from the Fields that can be exported box to the Order of fields in my file box. To remove a field from the Order of fields in my file box, click and drag it back to the Fields that can be exported box. To reorder the fields, click and drag them in the box as needed.

TIP: To select all the fields, click the Select All button. To remove all the fields from the Order of fields in my file box, click the Remove All button.

NOTE: For complete field descriptions, see Adding a New Product, Entering Additional Product Information and Editing the Default Product ID.

  1. Click the New button beside the Templates drop-down menu (above the Fields that can be exported and Order of fields in my file boxes).
    The New Template dialog box appears.

  2. Enter a name for the template into the Name field and click Save.

  3. To preview the export data, click the Next button. If you need to make any changes, click the Back button.

The Preview screen appears.

  1. Do one of the following:

  1. Click the Next button to export the data.

The Download screen appears displaying the name of the export file.

NOTE: If you are exporting a large amount of data, PAYD Pro Plus may need to create more than one export file (maximum 10,000 rows per file). If this is the case, PAYD Pro Plus lists all the export files with a separate Download button for each one. You then must download the files one at a time.

  1. Select the type of export file you'd like to create:

  1. Do one of the following:

  1. To exit the wizard and return to the Product Search Results screen, click Done at the top of the Export screen.

NOTE: To view and work with the exported data in Microsoft Excel, you must start Excel and import the file through the data import function.

 

Exporting Inventory Using a Saved Template

Once an export template has been created and saved, it can be re-used subsequent times to export the same fields. As inventory information is updated through sales and purchase orders, you can access that information quickly using the saved template. Follow the steps below to access a saved inventory export template.

To export using a saved template:

  1. On the PAYD Administration main screen, click Inventory.

  2. On the Inventory menu, under the Product heading, click Product List.
    The Product Search Results screen appears.

NOTE: To export your entire inventory, skip ahead to step 4.

  1. To select a sub-set of your inventory for export, search the inventory for the desired items to export.

  2. Click the Export button at the top of the screen.

The Inventory Export Wizard appears.

  1. Click the Next button at the bottom of the screen to select the data fields you want to include in the export.

The Fields Selection screen appears.

  1. In the Fields Selection screen, click the Templates drop-down menu and select a saved template from the list.
    The Order of fields in my file box populates with the saved fields.

NOTE: You can choose to add or remove fields from your template if you wish. Click and drag fields from the Fields that can be exported box to the Order of fields in my file box. To remove a field from the Order of fields in my file box, click and drag it back to the Fields that can be exported box. To reorder the fields, click and drag them in the box as needed. Once the fields have been adjusted, click the Save button beside the Templates drop-down menu.

  1. To preview the export data, click the Next button. If you need to make any changes, click the Back button.

The Preview screen appears.

  1. Do one of the following:

  1. Click the Next button to export the data.

The Download screen appears displaying the name of the export file.

NOTE: If you are exporting a large amount of data, PAYD Pro Plus may need to create more than one export file (maximum 10,000 rows per file). If this is the case, PAYD Pro Plus lists all the export files with a separate Download button for each one. You then must download the files one at a time.

  1. Select the type of export file you'd like to create:

      • To export the inventory data file to an Excel spreadsheet, click the Excel button.
        OR

      • To export the inventory data file to a comma separated text file, click the CSV button.

  1. Do one of the following:

  1. To exit the wizard and return to the Product Search Results screen, click Done at the top of the Export screen.

NOTE: To view and work with the exported data in Microsoft Excel, you must start Excel and import the file through the data import function.

 

Related Topics: