Can't import product data CSV file

jskish · ‎January 23, 2021

I have followed the instructions for importing product data into QBO and it returns the following message:

"We didn't import some of your data because it's already in QBO. If you still want to import it, change the info in the highlighted fields and try again."

The cells it highlighted (all of them) are all part numbers and a similar file has been imported each year. Since pricing is new every year, I need it to replace the old data with the new but the part numbers will still be the same. I'm not sure what could be different than last year. There are 400+ parts. Please help!

RenjolynC · ‎January 24, 2021

I'd like to share a solution to help you import the product, jskish.

When you have the same item name, make sure to select the Overwrite all values for each product or service box. This will get rid of the error and let you import the part numbers.

I've got these sample screenshots for reference:

You can read this article for more information: Import products and services into QuickBooks Online.

I'm always around if you need more help with QuickBooks Online. Have a great day!

View solution in original post

RenjolynC · ‎January 24, 2021

I'd like to share a solution to help you import the product, jskish.

When you have the same item name, make sure to select the Overwrite all values for each product or service box. This will get rid of the error and let you import the part numbers.

I've got these sample screenshots for reference:

You can read this article for more information: Import products and services into QuickBooks Online.

I'm always around if you need more help with QuickBooks Online. Have a great day!

jskish · ‎January 24, 2021

Thank you - that was it! Would not have remembered to scroll down to the very bottom of 400+ items to check that box.

Topics

Training

Community

Resources

Can't import product data CSV file