Can I upload an inventory with rack locations from an CSV or flat file?

I want to ensure this will be taken care of, @Sarraga. I'm here to share some info to help you upload the inventory data you need in QuickBooks Desktop (QBDT). 

In QBDT, you can only import certain lists such as items, price levels, shipping methods, etc. The option to upload a file for inventory items with rack locations is unavailable. As a workaround, you can utilize a third-party application that will let you import the specific data you need. To look for an app supported by the program, please visit the Apps for QuickBooks Desktop site. 

For reference, feel free to visit this article: Import and export data in QuickBooks Desktop. 

I've also added this helpful resource that you can use as a guide in case you need to manually set up locations to track your inventory: Multiple Inventory Sites.

Please don't hesitate to get back here if you have any other concerns managing your inventory data in QuickBooks. I'm just around the corner to help. Have a good one and keep safe. 

I am utilizing the multiple site option.  But need to parse out each of those sites by rack and bin location assignments.

How can enter inventory into a rack location within a specific site.   Even if a manual input and not an upload.

Thanks for your interest with the import feature in QuickBooks Desktop for inventories with rack locations, @Sarraga.

At the moment, the Excel file template for inventories does not include sites. You may check the following images to see how the template looks like:

You can, however, always change the site assigned to an inventory by doing an inventory transfer. For this, you can create sites for racks so you can to properly record the location of your inventories. 

I have an example for you. The rack here can be set up the same as the one highlighted on the screenshot:

You can pull up an Inventory Site QuickReport to track the items on a specific location. Here's how:

1. Go to the Inventory tab then select Inventory Site List.
2. Right-click on the site that you want to view. Let's use the In-Transit site for example.
   
3. On the report, you will see the running quantity of the selected site.
4. If for example you want to change the site of a transfer, just double-click the line that says Inventory Transfer.
   

I'll be adding some links to help you with the Inventory tracking in QuickBooks Desktop:

• Multiple Inventory Sites
• Site Operation

Let me know if you have any other questions about this so I can help you further with it. Just click the Reply button below to connect with me again. Have a nice day!