QB Issue Resolution:

Setting up the initial cost of the product is done manually through Products and Services. The quicker way is to map it in an Excel spreadsheet file and import it to QuickBooks.

You can download the sample template to guide you in the mapping process. From there, enter the item’s initial cost under the Purchase Cost column. Then, check the Overwrite all values for each product or service that you import with the identical name box to avoid duplicates.

Here’s how:

  1. Go to the Gear icon, then select Import Data.
  2. Select Products and Services.
  3. On the Import Products and Services page, select Browse.
  4. Find and choose your Excel file.
  5. Select Open, then Next.
  6. Map the information on the file, then click Next.
  7. Mark the Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.) checkbox to replace your existing list.
  8. Select Import.

The transactions that have been created will not be affected after performing the suggested steps above. If your product has categories and sub-categories, items and sub-items, please make sure the format is correct. Here’s an article you can refer to: Import Products and Services from Excel.

Resolution for Issue 'Hi, is there a way to add the initial value of each item but in a massive way? I need to asign the intial cost to each of them.' available: Yes (Solved).
Source: Intuit Community forum.

Hi, is there a way to add the initial value of each item but in a massive way? I need to asign the intial cost to each of them.: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.

Support for Gear icon
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!

Error Recovery for Gear icon [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.

Get 50% off Quickbooks Online

Click Here for 50% off!

Additional Support Options: