Importing new price and discount records from Excel

Use these instructions to import records from an Excel spreadsheet. Include only those records that you want to process in the import file. If you specify a customer/ship to for the import set, that value is used. It overrides the customer/ship to specified in the import file. If you do not specify a customer/ship to, the customer/ship to from the imported file is used.
Note: If you encounter time-out errors when you load a selected set or when you select Import Excel to load pricing records from an Excel file, you can enable batch call processing for the service interface calls that are used by this function. When you select Use Advanced Polling Interface Logic for Designated Service Interface Calls in SA Administrator Options-System-General, you can select these service interface calls from the Available Advanced Polling Calls list:
  • PDEM Import From Excel to Set (Type 1, 5, 7) - pdemexcelimportupdtpdsc1
  • PDEM Import From Excel to Set (Type 2) - pdemexcelimportundtpdsc2
  • PDEM Import From Excel to Set (Type 3, 4, 6, 8) - pdemexcelimortupdtpdsc3
  • PDEM Import From Excel to Set (Rebates) - pdemexcelimportupdtpdsr
  • PDEM Load Data From Set (Type 1, 5, 7) - pdemloadpdsc1
  • PDEM Load Data From Set (Type 2) - pdemloadpdsc2
  • PDEM Load Data From Set (Type 3, 4, 6, 8) - pdemloadpdsc3
  • PDEM Load Data From Set (Rebates) - pdemloadpdsr
  • PDEM Update Set Data Column Override (Type 1, 5, 7) - pdemgridupdatepdsc1
  • PDEM Update Set Data Column Override (Type 2) - pdemgridupdatepdsc2
  • PDEM Update Set Data Column Override (Type 3, 4, 6, 8) - pdemgridupdatepdsc3
  • PDEM Update Set Data Column Override (Rebates) - pdemgridupdatepdsr
  1. Select Pricing and Discounting > EntryMass Maintenance.
  2. Click Import Excel with New Records.
  3. Specify the import file information and click OK.
  4. Specify the information for the import set and click Add.
  5. After you create all of your import sets, click OK.
  6. A message is displayed indicating that the set import is complete; click Close. You can now process the set.
  7. If the import fails, the errors are displayed in a message window. Correct the errors in the spreadsheet and repeat the import.
Related topics