Use the inventory import wizard in PAYD Pro PlusTM to add new products to your inventory and update details of existing products. You access the wizard from the Inventory menu.
NOTE: Based on your PAYD account type, you may encounter a limit to the number of product profiles that can be imported into the inventory database. Once the limit is reached, you will not be able to save additional product profiles unless previously created profiles are removed from the database to create space for new ones. For more information on increasing this limit, please visit us at getpayd.com/paydproplus or call us at 1-855-423-PAYD (7293) to upgrade today.
NOTE: Products imported using PAYD Pro Plus are specific to that store. Products imported using PAYD Pro Plus Multi Location Administration are available for all the stores in your enterprise (multi-store environment only).
Importing inventory is as easy as 1, 2, 3:
Troubleshoot (if necessary)
NOTE: All completed inventory imports are logged in the Inventory Imports Log.
To import your inventory, you must create an import file that meets the following requirements:
PAYD Pro Plus does not support files saved as xlsx (Excel). If importing inventory from an Excel spreadsheet, the file must be saved as an Excel 2003 format (*.xls). OR The file must be a text file containing one product record per line (row). Field (column) values in each row must be separated by commas (,) and enclosed in quotation marks ("). If your import file is not a text file, your data may be imported incorrectly.
The first row in the file does not need to contain field names. If your file does contain a first row with field names, make sure to indicate this during the import.
The file must contain the Product ID field, a unique alphanumeric ID used to identify the product. If you are adding a new product, you must provide a unique ID. A missing or blank field will produce an error. If you are updating an existing product, the field must contain the exact Product ID.
NOTE: For detailed help on the format of the inventory import file, see Creating the Inventory Import File.
NOTE: It is also possible to use an import template provided by Moneris. See Downloading the Inventory Import Template and Importing Inventory from a Template for more information.
Once you have created your import file, you are ready to import the inventory data. If you need to make changes during the import, click the Back button at the top of the wizard screen. You can also cancel the import at any time by clicking the Cancel button.
NOTE: You do not need to be logged in to PAYD Pro Plus while an inventory import is in progress. Once you start an import, you can log out and PAYD Pro Plus will complete the import as usual. Once you log back in, you can view the results of the import in the Inventory Imports Log.
TIP: You cannot use any other PAYD Pro Plus functionality while an inventory import is in progress. It is therefore recommended that you import inventory data during off hours.
On the PAYD Administration main screen, click Inventory.
On the Inventory menu, under the Inventory heading, click Import.
The Inventory Import wizard appears displaying the File Selection screen.
In the Import Type section, select the appropriate radio button to indicate whether you are adding new products only (Add only), updating existing products only (Update only) or both adding and updating products (Add and update). The default is Add and update.
NOTE: If you select Add only, PAYD Pro Plus skips any records for existing products. If you select Update only, PAYD Pro Plus skips any new product records.
To select the inventory import file you created, click the button under the Source File section.
In the Choose file dialogue, find and select the file, and then click Open.
NOTE: To change the selected file, click the Remove button () below the file name and select the new file as above.
Click the Next button at the top of the screen.
The Field Mapping screen appears.
If the first row in the import file contains field names, click to select the First Row Contains Field Names checkbox.
NOTE: If the first row in the file does contain field names and you do not select the checkbox, PAYD Pro Plus will attempt to import the first row as a product record, which will produce errors upon validation. Conversely, if the first row in the file does not contain field names and you do select the checkbox, the import will skip the first record (row) in the file.
Click and drag fields from the Fields that can be imported box to the Order of the fields in my file box. Select only those fields that are in the import file and make sure to order the fields following the order in the import file. To remove a field from the Order of the fields in my file box, click and drag it back to the Fields that can imported box.
NOTE: Mapping the fields incorrectly will produce an error and you will not be able to proceed with the import. If the field mapping order is not correct, the data will be imported correctly.
TIP: To select all the fields, click the Select All button. To remove all the fields from the Order of the fields in my file box, click the Remove All button. Use the Up and Down arrow buttons to reposition a field once it has been moved over to the Order of the fields in my file box.
To preview the imported data, click the Next button.
A popup appears asking if you want to add in-stock quantities to current inventory for the products that already exist. Click Ok to add the in-stock quantities OR Click No to overwrite the current in-stock quantities with the new quantities from the import.
The Mapping Sample screen appears.
Do one of the following:
If you are satisfied with the results of the mapping, go to step 2 below.
If results are incorrect, click the Back button to make the necessary corrections as above and repeat.
Click the Next button to confirm the mapping.
The Import Validation screen appears.
Review the results of the validation and do one of the following:
If the validation is successful (no errors), go to step 4 below.
If the validation produces any errors, go to Troubleshooting the Import below.
Click the Next button.
The Backup screen appears.
Select your backup type:
Click the Excel button to backup your current inventory to an Excel spreadsheet.
OR
Click the CSV button to backup your current inventory to a comma-separated text file.
A File Download dialogue appears at the bottom of the browser.
Click Save.
The file saves on your hard drive in the Downloads folder.
At the top of the wizard's Backup screen, click the Import now button.
A bar on the screen shows you the progress of the import and the amount of time left to complete it.
NOTE: While the import is in progress, you cannot use any other PAYD Pro Plus functionality. However, you can cancel the import by clicking the Cancel button next to the progress bar.
Once the data is imported, the Import Results screen appears notifying you that the import is complete and displaying a summary of results.
To exit the wizard and return to the Product Search Results screen, click Close at the top of the screen.
NOTE: You can view the results of a completed import at any time through the Inventory Imports Log.
If the validation of your imported inventory data produces errors (see To confirm the mapping and validate the import above), you should troubleshoot the inventory import file and make the necessary corrections. You can also choose to continue with the import regardless of errors.
The Inventory Import wizard displays these errors and generates an error log for you to view and save.
On the wizard's Import Validation screen, click the Next button at the top of the screen and proceed with the import as normal.
NOTE: The system skips any rows with errors.
On the wizard's Import Validation screen, click the Save Error Log button.
A File Download dialogue appears at the bottom of your browser.
Click the Open button.
The Error Log appears in your default text editor (e.g., Notepad).
Print or save the Error Log as needed and exit.
On the wizard's Import Validation screen, click the Cancel button at the top of the screen.
Make the necessary corrections to your inventory import file following the guidelines in this topic. For more detailed help, see Creating the Inventory Import File.
Re-import the file following the guidelines in this topic.
If your import seems stuck while in process, it is possible to abort the import by pressing the Cancel button at the top of the screen at any time. A warning message appears to notify you to check your inventory database prior to beginning another import. It is possible that the import may have completed while the screen was frozen.
Entering Additional Product Information