How to bulk add multiple locations to products

Technical Q&A

Topic summary

A user needed to bulk assign a newly created location to multiple products, as the interface only allowed individual product editing.

Proposed Solutions:

  • Use third-party Shopify apps for bulk location updates
  • Export/import CSV files with location data
  • Use Shopify’s API for programmatic updates

Working Solution:
The issue was resolved by exporting inventory data (not product data) as CSV, adding the new location column with stock quantities, then re-importing. Shopify’s official documentation on bulk inventory editing was referenced.

Alternative Tool:
Ablestar Bulk Product Editor app was suggested, offering:

  • Advanced filtering options (vendor, tags, inventory location status)
  • “Connect inventory to locations” feature for bulk operations
  • Free plan with five edits monthly (unlimited products per edit)
  • Screenshots demonstrate the filtering and connection interface

Additional Request:
One user inquired about bulk creating 416 warehouse bay locations. The app developer confirmed this feature doesn’t exist but offered manual API assistance for CSV-based location creation.

Note: A user reported the app’s free plan now limits edits to 10 items per task, contradicting earlier pricing descriptions.

Summarized with AI on October 28. AI used: claude-sonnet-4-5-20250929.
1

I just added a new location, but how do i add that location to my products in bulk?

I can only see a way to do this individually…I have to click on “edit Locations” and then select all locations.

How can I do this in bulk?

screen shot added - https://www.screencast.com/t/DLOUiXhi4CF

2

Hello Crowshed,

There are a few ways you can add a new location to your products in bulk:

  1. Use a Shopify app: There are a variety of apps available on the Shopify App Store that can help you bulk update your product’s locations. Some apps allow you to update products based on specific criteria, such as product type or vendor.

  2. Use Shopify’s CSV import/export feature: You can export your product data to a CSV file, then edit the file to include the new location, and then re-import the file to update your products. This process can be used to update any product information in bulk.

  3. Use Shopify’s API: You can use Shopify’s API to update your products in bulk by making a PUT request to the /admin/api/2021-01/products/{product_id}.json endpoint.

It’s important to test the process with a few products before applying it to all products to avoid any errors.

3

for option #2…I dont see a column where i can update this info?

4

In Shopify, the location information for a product is not included as a separate column in the products CSV file by default

  1. Create a new column called “Location” or “Inventory Location” and insert the new location name for each product.

  2. Select the updated CSV file, and then click on "Start import.

5

I tried that, but did not work

6

Go to the product section and then select the inventory then export the csv and add the location in that and on that location add the product stock.

For more info you can check the below link

https://help.shopify.com/en/manual/products/inventory/managing-inventory-quantities/bulk-editing-inventory#step-2-select-product-variant-properties-to-edit-in-bulk

1 Like
7

Do you have an example of the spreadsheet and how it should look?

8

that worked

1 Like
9

Hello,

It looks like you’ve figured it out but if you need more control connecting the inventory it’s something you can do for free with our Ablestar Bulk Product Editor.

After you install the app you can filter for the products you want to edit. We support a lot of options like vendor, tags etc.. but also more advanced ones like “inventory is not connected to location x”:

DanielAblestar_0-1674116863246.png
DanielAblestar_0-1674116863246.png936×499 38.6 KB

Once you’ve filtered for the products to edit, we have a “Connect inventory to locations” option that you can use to connect (or disconnect) inventory:

DanielAblestar_1-1674116940603.png
DanielAblestar_1-1674116940603.png951×493 33.8 KB

Once you click on Run Edit the app will process everything in the background for you.

Our free plan includes five edits every month (with no limit on the number of products) so it should be plenty if you just need to make a few changes.

If you want to try it you can find it on the app store: https://apps.shopify.com/bulk-product-editor

Best,

Daniel

10

Does this app allow you to bulk create locations too @Ablestar_Daniel ? We have 416 bays in our warehouse we need to create locations for and assign our products to these bays. Website: Stories Flooring

11

Hi @Will-Woolley , currently we don’t have a way create locations in the app but I can see how it’d be useful and I’ve added it to our feature request list. I can follow up if we add it.

That said, if you have a CSV of the locations we would be happy to create them for you on our end through the API. If you’d like to do that just install the app (free plan is fine) and send an email to support@ablestar.com mentioning this thread.

Best,

Daniel

12

Your pricing no longer accords with the description you provided in this post. The free option now only allows 10 items to be edited per task.