Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
annkaye71
Level 1

How can I batch import product costs?

I have successfully imported all of my products into QBO via .csv file, but I have not been able to include the cost associated with each product. Is there any way around having to manually input costs for my 500+ products? Thanks!

Solved
Best answer 3 weeks ago

Best Answers
ThomasJosephD
QuickBooks Team

How can I batch import product costs?

You have the option to re-upload your CSV file to ensure that the purchase cost is included before uploading, annkaye71. Allow me to guide you through importing product into QuickBooks Online (QBO).

 

Please note that the feature to directly upload a CSV file that includes purchase costs is only available in the Plus and Advanced versions of QBO. If you are currently using the Simple Start or Essentials version, we recommend importing your file via Google Sheets if available. Alternatively, consider upgrading to a higher version to take advantage of the direct upload feature and other advanced functionalities.

 

Before we begin, please ensure that the purchase cost is included to your CSV file. Here are the steps to upload your CSV file:

  1. Navigate to Gear icon and select Products and Service.
  2. Click the New dropdown, then Import.
  3. Select Browse to upload the CSV file, then click Next.
  4. Review the mapping of the column headers, and click Next.
  5. On the import stage, tick the Check this box to overwrite details of existing items with the same name and category.
    image.png
  6. Click Save.

 

Using this method, you can efficiently upload your products along with their purchase costs while preventing duplication of existing products.

 

Here's the reference I'll provide for your guidance: Import products and services into QuickBooks Online.

 

With QuickBooks Live Assisted, you’re not just uploading data; you’re setting the stage for cleaner, more organized financial management. Get started today and experience seamless integration of your products and services with QuickBooks Online!

 

Additionally, you are able to configure pricing rules within your products and services, a feature that may prove useful in future steps. For more insight, check out the article linked:

 

We're always here to help you ensure that your CSV file includes the purchase cost before uploading it for accurate data management in QBO. Should you have any more inquiries or need further help, please reply. We are committed to assisting you promptly.

View solution in original post

1 Comment 1
ThomasJosephD
QuickBooks Team

How can I batch import product costs?

You have the option to re-upload your CSV file to ensure that the purchase cost is included before uploading, annkaye71. Allow me to guide you through importing product into QuickBooks Online (QBO).

 

Please note that the feature to directly upload a CSV file that includes purchase costs is only available in the Plus and Advanced versions of QBO. If you are currently using the Simple Start or Essentials version, we recommend importing your file via Google Sheets if available. Alternatively, consider upgrading to a higher version to take advantage of the direct upload feature and other advanced functionalities.

 

Before we begin, please ensure that the purchase cost is included to your CSV file. Here are the steps to upload your CSV file:

  1. Navigate to Gear icon and select Products and Service.
  2. Click the New dropdown, then Import.
  3. Select Browse to upload the CSV file, then click Next.
  4. Review the mapping of the column headers, and click Next.
  5. On the import stage, tick the Check this box to overwrite details of existing items with the same name and category.
    image.png
  6. Click Save.

 

Using this method, you can efficiently upload your products along with their purchase costs while preventing duplication of existing products.

 

Here's the reference I'll provide for your guidance: Import products and services into QuickBooks Online.

 

With QuickBooks Live Assisted, you’re not just uploading data; you’re setting the stage for cleaner, more organized financial management. Get started today and experience seamless integration of your products and services with QuickBooks Online!

 

Additionally, you are able to configure pricing rules within your products and services, a feature that may prove useful in future steps. For more insight, check out the article linked:

 

We're always here to help you ensure that your CSV file includes the purchase cost before uploading it for accurate data management in QBO. Should you have any more inquiries or need further help, please reply. We are committed to assisting you promptly.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us