Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I need to update prices on 1500+ products and I'm facing issues with the up-loader tool.
I followed the instructions :
-export to excel file
-edit priced in said excel file
-upload said excel file with updated price (nothing else changed)
-made sure to click on the overwrite data box
Now half or so of my products updated correctly, however the rest created duplicates and they didn't update the matching existing product with the same product name and UGS (see attached screenshot).
I feel like this might be an error in the back endcode... In any case, I obviously need my products to update correctly as I am losing money daily till I get these updated.
Please let me know if there's a way for me to fix this.
Thank you.
You're on the right track with importing products and services, Pompaleau. However, it's important to note that QuickBooks Online can handle only up to 1000 rows of data at a time.
This could be the reason why only half of your items were updated.
Once done, I recommend splitting your spreadsheet into smaller files and importing them separately. Make sure that the names are correct and do not include the items that are already updated.
You can also use reports to see your sales and inventory status, your best sellers, the cost of goods, and more.
If you have any further questions about updating your item prices in QBO, please don't hesitate to let us know. We're here to assist you further.
Hi,
thank you for your reply.
I did import my products in small batches of ~500 products per file and I know for a fact that all
my products have their respective matching product names.
Also I had already made all the duplicates inactive.
Pretty sure the issue is with QB..
Please advise further instructions.
Thank you.
Thank you for sharing more details of your experience importing products and services in QuickBooks, @Pompaleau. Your explanation is greatly appreciated, as it provides valuable context to the situation. Let's find a solution to get everything back on track. We're in this together!
If you haven’t already, I recommend importing a smaller batch of products (for example, 100-200) to see if the issue persists. This step can help identify whether specific products are causing the issue or if there's a broader problem with the import process.
Additionally, I suggest clearing your browser's cache and cookies, as this can often resolve issues with web applications like QuickBooks Online (QBO). Once done, retry the import process.
If the problem persists after trying these steps, I strongly recommend contacting the QuickBooks Live Support team. They can address complex issues that may be beyond the scope of community assistance, ensuring you receive the most appropriate and effective solution.
Here’s how to connect with our live expert:
To ensure you connect at the best times, please check this link for their support hours: Get help with QuickBooks products and services.
For detailed info, feel free to review this article: Common questions about importing data to QuickBooks.
Moreover, I will share these resources that will assist you in recording customer payments and categorizing your items to maintain organized records:
I want to see you succeed with QBO, and my goal is to support you as you navigate this process, @Pompaleau. If you encounter any further errors or challenges importing products and services in QBO, please leave a comment below. We're always here to help you!
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