INSERT INTO `shops` (`id`, `address`, `average_rating`, `created_at`, `description`, `latitude`, `longitude`, `name`, `opening_hours`, `phone`, `review_count ...

Over my forty years or so in and around dealing rooms and financial markets, I have heard many theories as to how to approach that problem and have settled on a process that has worked for me.