How to bulk add multiple locations to products

Technical Q&A
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.