1. Products
  2. Inventory Control

Updating your quantities in bulk

A step-by-step guide on how to update quantities per Fulfillment Center in bulk

Using SellerActive you are able to manage the available quantities within your catalog one-by-one or in bulk. Normally we expect SellerActive to be the "quantity source" for your sales channels so it is important to understand how quantities can be updated and managed. You can update your quantities in bulk at any time with a flat file upload. 

We can establish your settings to allow for your integrated Sales Channels to update SellerActive with quantity. (Click Here for more information)

Uploading Steps: 

Before getting started:

Make sure that your Outbound settings are ON for updating quantities. 

Outbound_Quantity

Our import process does not accept .CSV files at this time. 

  1. Generate your flat file that will include the SKU, Quantity you need to replace or modify with, the Fulfillment Center (when applicable), and the Fulfillment Center Priority (when applicable). An optional column is Quantity Action which would Increment or decrement the quantity in your file to the quantity we have stored. 
    1.  CoverSheet
    2. There are a few ways you prepare your upload:
      1. Export an example template from the Import page (Products -> Import). You can then add the SKU's and quantities manually
        1. InventorySample
      2. Export your current Products (Products -> Export -> Inventory). This will give you the current list of available quantities and you can edit those quantities within the same file.
      3. Supply your own custom file or upload a file from your Vendor/Supplier/secondary source.
        1. SellerActive has a custom mapping tool that will help take any file you have (with column headers) and adapt it to the values within our system.
  2. Once you have your file, make sure that you have established column headers and that your columns are filled out correctly. 
  3. Go to Products -> Import -> Inventory and import your file. 
  4. Via the Mappings page, make sure that your columns are assigned to the correct field in our database. 
  5. Process your upload!

For more information on how to update quantities and prioritize them, please references these resources!

How to update your quantities and prioritize Fulfillment Centers (Video)

Updating Quantities in bulk (Detailed overview)

.Frequently Asked Questions

 I noticed a column/field marked as "Quantity Action". What does that mean?

The "Quantity Action" field is best used when you are trying to add (increase) or remove (decrease) from available inventory. For example, let's say you have 100 quantity for your product. You want to remove 25 of those available units (so you would have 75 avaialble). You can upload a file with "Quantity Action" = Decrease and "Quantity Available" = 25. This would leave the available quantity as 75. 

Quantity_Assignment

Another option you have is to avoid "Quantity Action" all together and instead just use "Quantity Available". So you would upload a file with SKU and the quantity 75 and assign 75 to "Quantity Available". 

Quantity_75

Do I always need to include the Fulfillment Center with my upload? 

If your SKU's have more then one Fulfillment Center assigned to them then you will need to specify which Fulfillment Center you're updating. 

If you only have one Fulfillment Center (your Default Warehouse) then you do not need to include the Fulfillment Center with your upload. You can just include SKU and quantity (and quantity action where applicable).