I have multiple locations on my Shopify (currently it's 6 locations). is there any way to automatically assign products to a specific location when doing import product via template?
It's not possible to assign products to locations with the product CSV import but using an inventory CSV file import, you can effectively "assign" products to specific locations by setting the inventory levels for each product variant at each location. In the CSV file, you specify the handle or SKU of the product variant, the name of the location, and the quantity available at that location.
Is this what you're looking for?
Does that mean that whenever I upload a new product via template I need to go through 2 steps? Upload product and then upload inventory?
If you're just using admin features then correct, you'd need to import products and then update inventory. However you could automate this process by creating a custom app that would access the InventoryLevel resource and would allow you to automatically set inventory for products - possibly based on tags, or metafields? Here's some examples of how to work with this endpoint in our developer docs.
Hope this helps,