No, I know it's not supported in powerstore, but I was hoping to get an idea of what I need to do or search for so that I could create an SQL query and do it directly into SQL with something along the lines of Sequel Pro or HeidiSQL.
Just to let you know, I am using a CSV file from the client to import the data, but it's without prices at he moment. I'm just mapping the columns from the CSV file to the columns of the DB when importing. I am having to do this as I have nearly 2,000 product to input into the database for when the site goes live. I will then have a further 3,000 once the site is up and running. I just don't know how to ensure that when a price update occurs across 5,000 products occurs, I am applying the right price to the right SKU... but I know it can be done.
