Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Having an issuing of importing an Inventory list to a new file.... From what I read, I have to copy and paste it into the file rather just importing it from the Excel? Please advise, thank you!
Items & Services > Excel > Import Items > Tried 2 Find it Now/file, but it says its not a QB format... or Advanced Import > Brown file > Choose correct sheet > then it comes to Mapping...?
Thanks for letting us know about your concern, @Erss. Let me help you export your inventory list successfully.
Importing an Inventory list from Excel is possible in QuickBooks Desktop (QBDT). To import an Excel file correctly, ensure it is in CSV format and verify its content. For detailed instructions, please refer to Steps 3 and 4 outlined in this article: Import or export MS Excel files.
After that, you can then prepare to import the Excel spreadsheet file. First, create a backup of the company file. Then, proceed to import the Excel/Spreadsheet by following the steps below:
Additionally, if you encounter the Duplicate Record Found error, you'll be prompted with these messages:
To fix the errors, select the appropriate option and then choose "Apply" or "Apply to All." You will receive a notification indicating the number of successful imports and any possible errors. If errors occur, select "Save" to create an error log and review it to identify the necessary actions to resolve them. Afterward, re-import the list as needed.
Moreover, you can generate a report detailing your business performance, including products sold, revenue, and profit margins. This data will help you make informed strategic decisions and identify areas for improvement.
Keep me posted if you have other questions about managing the list. I'll be around to help. Have a good one.
Also, why doesn't QB allow us to download the Subitem of?
I appreciate your follow up queries, Erss. I can provide further information to help you import inventory parts into your account so you can manage your items efficiently.
Beforehand, may I know what specific errors you've received when these inventories were imported into your file? Any additional details are much appreciated.
In QuickBooks Desktop, deleting of inventory items is possible in your file if these hasn't been used to any of your transactions. Also, the option of making them inactive is when you want to hide an item to remove them from the list but not from your books.
With that, I recommend reviewing your entries individually to review the items linked to it. Please know that you're unable to delete inventories in bulk. You'll have to remove them manually. Before doing so, make sure you create a backup of your company file for future use.
Moreover, when importing inventory part with parent-child relationships using the Advanced Import feature, you can utilize the ListID field to establish these items during the import process.
Instead of mapping the SUBITEM IF field directly, ensure that each child item includes the ListID of its parent item in the ParentRefListID column in your Excel file. Doing so will help link the child items to their respective parent items.
Then, during the mapping process, look for the ParentRefListID field and map them to the corresponding column in your Excel file that contains the ListID of the parent items. However, before importing them,it's best to double-check your Excel file to ensure ParentRefListID contains the ListIDs of the parent items for each child item.
If you continue to encounter issues, you can consider reaching out to our Customer Care Team. They can perform a screen-sharing session to help you further with the import process.
Furthermore, here's a reference you can utilize to help review the accuracy of your data entered into your file: Understand reports
I'll be on this thread anytime you require additional assistance when importing inventories in your account. Stay safe and have a good one!
If we were going to do Copy and Paste it in.
Right now we have this issue below:
(in red, Under Item Name)DESK:Table123 = This means that this item here needs a subitem of. When we tried to add Subitem of "DESK" It is still red....
How do we add this manually?
If we create an item in the Item List, it can't be added onto the Subitem. If we add it in the Subitem, the red in the item name does not go away.
Thanks for providing further details, Erss. I appreciate you following the recommendation provided by my colleague. I understand the importance of correctly importing your inventory list, especially when it involves items with sub-items.
When manually adding inventory items with sub-items in QuickBooks Desktop, create the parent before linking and creating any sub. This process ensures they are accurately associated.
If this is your case and you're unable to link them. Let's take some troubleshooting steps using the verify and rebuild data tool. It helps resolve common issues in your company file that prevent you from adding or linking the sub-item to the item name you created.
Before we begin the troubleshooting steps, create a backup copy of your company file to prevent potential losses due to unforeseen circumstances.
Now, here's how to verify your company data:
After that, follow these steps to rebuild your company data:
If the issue continues, I recommend contacting our technical support. Our expert team can further examine this through a screen-sharing session, ensuring you'll get past the error and the red display in the item name.
Moreover, I'm adding these additional resources to manage and adjust your inventories:
I want to ensure your experience with QuickBooks is as smooth and seamless as possible. I'll be happy to hear updates from you soon, Erss.
Do you need to migrate Item Assembly data or else?
Assembly Item Name | Parent Item Name | Income Account | COGS Account | Asset Account | Purchase Cost | Purchase Description | Sales Price | Sales Description | Build Point | Component Item Name | Component Item Qty | Unit of Measure |
Kit1 | General Sales | Cost of Goods Sold | Inventory Asset | 56 | Sample Kit | 90 | Sample Kit | Carpeting | 1 | |||
Kit1 | General Sales | Cost of Goods Sold | Inventory Asset | 56 | Sample Kit | 90 | Sample Kit | Pad | 1 | |||
Kit2 | General Sales | Cost of Goods Sold | Inventory Asset | 60 | Sample Kit | 105 | Sample Kit | Wood Door | 1 | |||
Kit2 | General Sales | Cost of Goods Sold | Inventory Asset | 60 | Sample Kit | 105 | Sample Kit | Toilet | 1 | |||
Kit2 | General Sales | Cost of Goods Sold | Inventory Asset | 60 | Sample Kit | 105 | Sample Kit | Sink | 1 |
The whole reason why we are importing inventory is that the can no long repair itself. It just gets more and more corrupted, and we get more and more ads about upgrades....
So if the file that we are getting the inventory from is corrupted, then there is no way to import that into a new company with the Subitem of?
Yes migrate item assembly data, and other items that have Subitems.
You can use an importer tool as a workaround. It's a $199 one time license and you can get $100 cashback to purchase via a partner.
https://get.transactionpro.com/qbd
Any work arounds on not able to transfer over Subitems?
Hi there, Erss. I'll share insights about the error message you've received to ensure you can save the item name in QuickBooks.
The program doesn't recognize the colon character, causing the error message you've received when saving the item. You can remove or use another character to save the item. If you need to connect a subaccount with a special character, consider using different letters or symbols.
Here is a list of accepted characters:
Also, I'll be sharing links that will help you manage your items, such as combining, editing, and creating multiple lists. It also contains instructions on how to modify the value of your inventory in QuickBooks:
If you have any other concerns besides adding items or importing your inventories, please let me know. We're always available to assist you.
the : is breaking down the item and subitem. Without ":", how can it break down the Subitem?
Do we need to just have an item, then in the subitem, we need to manually selected it? Once it has been added, then it will show that the item is a subitem?
Good day, Erss.
I appreciate your update about the ability to add the subitem manually. Though you can copy and paste, you also can change the colon (:) to another character. This will break down your subitem in QuickBooks Desktop.
Also, to help with keeping track of your inventory and the adjustments you need, you can click on these links:
If you have any other concerns about your inventories or questions about QuickBooks, count me in. I'm here to help and will get back to you promptly. Take care and have a great day!
So again, there is no way to copy and paste in the Subitems? We have to manually select what the subitem's main item is? Also, we have to manually delete all the Categories from our previous file? example Ball:Basketball? We have to delete "Ball:", then manually add in Ball in the subitem of?
Importing all your inventory items into QuickBooks Desktop helps save time, Erss.
At this time, QuickBooks Desktop allows you to copy and paste your items. However, the system won't recognize whether this item is a sub-item of the main item. That is why you'll need to select and edit the name when adding the details.
I can see the importance of having this functionality improve your experience of the program. I recommend sending a feature request directly to our Product Development team.
Here's how:
Additionally, I've included an article that'll help you assign a unit of measure in QuickBooks. This ensures you can easily track your items: Show Quantities, Prices, Rates, and Costs for an Item.
I'm only a few clicks away if you need assistance in managing your inventory in QuickBooks. It's always my pleasure to help you out.
LOL, the function used to work, feedback doesn't matter since you guys don't support Desktop anymore, but some how we still get advertisements.
How would you manually import Assembled items? Where do we put the different items that makes the Assembled item?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here