cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
komik37
Level 1

I want to import batch file with my products. I used the example file and used my products. When importing file, I can't see any cost related fields to upload.

I use QB Online.
3 Comments 3
GlinetteC
Moderator

I want to import batch file with my products. I used the example file and used my products. When importing file, I can't see any cost related fields to upload.

I understand the significance of having the cost-related fields when importing products into QuickBooks Online (QBO), komik37. Let me provide you with some insights into how importing works.

 

When you're importing products into QBO, a column for costs should be present. Since your file does not have this column, consider manually adding it to your Excel file to capture cost-related information effectively.  This serves as an effective workaround to ensure accurate financial tracking.


Screenshot 2024-11-26 215202.png

 

Check out these articles for more insights about importing data in QuickBooks Online:

 

 

Do you need assistance with adjusting the product and service item types after your import? Click on this link for a detailed guide that'll help you navigate the changes smoothly: Change product and service item types in QuickBooks Online.

 

I’m here for you if you need any more help about importing or have questions navigating QuickBooks. Please don't hesitate to tag me, komik37. I’m just a message away and always happy to assist.

komik37
Level 1

I want to import batch file with my products. I used the example file and used my products. When importing file, I can't see any cost related fields to upload.

Thank you for replying. 

here is a list of all the steps I did:

 

1- I manually entered a product on QuickBooks online, making sure to enter information in every fields associated with costs.

2- I downloaded this product to a CSV file.

3- I populated this file with my products information. I have 100+ products.

4- When I tried to upload the batch file, the only field options were related to typical product information. No fields were available to be map to costs, even though I have these columns in my document. 

I have searched and read a lot of articles about importing products. But I did not find anything with this particular issue.

JamesM4
QuickBooks Team

I want to import batch file with my products. I used the example file and used my products. When importing file, I can't see any cost related fields to upload.

Hello komik37. Are you able to see the cost column while using a private/incognito browser window?

Need to get in touch?

Contact us