Skip to main content
K
komik37
November 26, 2024
Question

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.

  • November 26, 2024
  • 1 reply
  • 0 views
I use QB Online.

    1 reply

    G
    GlinetteC
    November 26, 2024

    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 import products into QBO, you'll need to map the field for purchase costs so that it is present in your file upload. Since the 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.



     

    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.

    K
    komik37Author
    November 26, 2024

    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.

    J
    JamesM4
    November 26, 2024

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

    Terms & ConditionsAccessibility statement