Hi guys, is there a way to schedule a pricing update import or only through the Mass Update?

One way to achieve this could be with a scheduled script. In particular, I'd encourage you to check out the SuiteAnswers topics "Scheduling a One Time or Recurring Scheduled Script Submission" and "task.CsvImportTask". However, I wouldn't advise going down this path unless this requirement is likely to continue to pop up in the future

Have you tried looking at the Effective Date Pricing Suite Solution?