“Batch-import products & services NEW” :: Disappointment in Conflicting Documentation

JPP_Accounts · ‎November 20, 2024

The documentation appears to be conflicting in a number of areas around the “Batch-import products & services NEW” as well as the “Common questions about importing data to QuickBooks Online” help article.

1. The “Common questions about importing data to QuickBooks Online” help article indicates upload of 1,000 rows of data, while the Batch-import products & services NEW process only allows 200 records per file.
a. 200 records is a relatively small number of “batch” records in my opinion so I would like to be able to batch-import 1,000 records in ALL areas of the application.

2. The Products & Services data doesn’t appear to have a clear unique key, or it is at least not exposed to users, which causes confusion with the conflicting documentation a) support documentation both online and withing the application screen itself vs the actual functionality of the Check Box for the import process.

a. For example: if a data-savvy user needed to remove/clear out/make null the Category field values for 5,000ish products, they might thing that they could run the Batch-import products & services NEW process five times (five 1,000 record .csv files), ensuring each time to set the Check Box to Yes so that the existing data was OVERRIDDEN…however they would be very sorry by the end. First, that would take 25 runs of the process as only 200 records per file appear to be supported in this batch-import process. Second, without exposing the unique record key, the composite key the batch-import process appears to use includes the exact value (Category) that the user intends to remove/clear out/make null, thus not only wasting time, but actually loading 5,000 NEW records into the table exacerbating the initial problem the clean-up effort was to achieve.

3. Why is the Status field not part of the “Batch-import products & services NEW” fields for uploading? Bulk Inactivation would be a very nice tool in the toolbox to have. This would also help rectify the above examples problems with another 25 upload runs.

jenop2

Thanks for taking the time to share your valuable feedback regarding the Import and Batch Action features in QuickBooks Online, Lynn69. We truly appreciate when users provide insights into their experiences with our software.

Your comments about needing more comprehensive and precise documentation on data importing in QBO are well-received. We understand that clear, detailed guidance can significantly enhance user experience and reduce potential confusion or errors during the import process. This kind of feedback is crucial in helping us identify areas where we can improve our product and support materials.

We also have a dedicated engineering team that reviews all user feedback as part of our ongoing commitment to enhancing the QuickBooks experience. While we carefully consider all suggestions, we also encourage users to directly submit feature requests to ensure their ideas are formally logged and evaluated.

To this end, I'd like to guide you on how to submit an official feature request directly from your QBO account. Here's how:

Go to the Gear icon and select Feedback.
Type in your feedback and suggestions about making changes or adding more options when importing products and services in QBO.
Click Next to submit them.

Your insights could play a crucial role in developing features that benefit you and other users facing similar challenges.

We sincerely thank you for your engagement and for helping us make QuickBooks Online a better tool for all our users. Don't hesitate to visit us again if you need anything else when moving data in QBO. We're always here to help.

JPP_Accounts

Feedback has been provided.

Are there any alternative/workarounds to impact the product & services data in bulk? Such as an API connector? The ability to connect to the back-end database via an SQL connector? Any options for a scripting language to do table updates (Bash, Groovy, JavaScript, Perl, PHP, PowerShell, Python, R, Ruby, VBA, VBScript)?

Erika_K

Thank you for taking the time to share your feedback, Lynn. Let’s collaborate closely to explore various channels where you can find alternatives for importing your products and services, ensuring a clear and organized importation process.

While we cannot recommend a specific application directly, I can guide you through the menu and suggest some filters to help you easily find an application that best suits your business needs.

Let me walk you through the step-by-step process:

Navigate to the Apps menu and choose Find apps.
On the Search tab, key in some keywords (e.g. bulk importer).
You may also Browse categories or Browse industries, depending on your preferences.
Select a specific app, then review the other app information.
Once you've chosen an application, click Get app now.

You can also explore the app's Reviews section for valuable insights into customer feedback and experiences. Reading these reviews will help you understand how other users have interacted with the app, its strengths and weaknesses, and its suitability for your business needs, helping you make an informed decision.

Additionally, we offer a dedicated and separate forum where our customers can connect directly with our developer team to discuss API-related topics. This ensures that all inquiries are addressed by our designated experts.

Here’s how you can get in touch with them:

Visit this link: https://help.developer.intuit.com/s/.
Choose QuickBooks Online under What do you need help with?
Click Ask a Question.
Log into your existing Intuit Developer Account or create a new one.
Key in your concern, and then hit Ask.

Lastly, I’ll include these articles that guides you in effectively managing your products and services within QuickBooks Online (QBO):

Your inquiries are important, and we want to ensure you have all the information needed for a smooth import process. If you have any questions or need clarification about transferring your data or other QBO matters, please let me know in the comments section below.

Topics

Training

Community

Resources

“Batch-import products & services NEW” :: Disappointment in Conflicting Documentation