QuickBooks HelpQuickBooksHelpIntuit

Create new products and their variants

SOLVEDby QuickBooksQuickBooks Online6Updated November 04, 2022

Learn how to create products and their subsequent variants in QuickBooks Commerce.

QuickBooks Commerce is a one-stop-shop for managing your products. We’ll show you how.

QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.

What's the difference between a product and a variant?

Here's the difference between a product and a variant.

  • Product: The goods that make up your inventory.
  • Variant: A group of the same product with different categories (i.e. sizes, colors, price, etc.).

Note: Before you create products, set up the right initial cost and moving average costs (MAC). This ensures QuickBooks Commerce Intelligence gives the right info on your operating costs, when and what products to order, inventory value, and cost of goods sold (COGS). Learn about initial costs and moving average costs.

Create new products and variants

Here’s how to create a new product and its variants.

  1. In QuickBooks Commerce, go to Inventory, then select Products.
  2. From the Create New ▼ dropdown menu, select New Product.
  3. Fill in the product’s details.
    • To set up tracking for your product, select the checkbox for the following:
      • Manage stock level: This will indicate that you want QuickBooks Commerce to be the master of stock for this product. Otherwise, the product is listed with infinite stock availability.
      • Sellable: This indicates whether or not this product can be listed and sold.
      • Initial Cost: The dollar value of acquiring one unit of your inventory.
    • If your product has multiple variants (i.e. sold in multiple sizes, colors, or flavors), select the This product has multiple variants checkbox.
    • If your product has different pack sizes, select the This product is bought in and/or sold in packs checkbox.
  4. Select Continue to Summary.
  5. In the Product Summary window, add the info in the fields under the following columns:
    • SKU
    • Initial Stock
    • Initial Cost
    • Buy Price
    • Retail Price
    • Wholesale Price
    • Sellable
    • Indicate unit weight
  6. Select Create Product.

Edit variants under the new product

If you need to make any changes like add images, edit descriptions, change prices, locations, and more:

  1. Select the variant you want to modify.
  2. In the Products variant window, go to Details, then edit your product’s info.
  3. Go to Images to attach one or more images to each product.
  4. Go to Stock Locations if you want to do any of the following:
    • Input and make modifications to bin locations.
    • Set reorder points.
    • Set lead times.
    • Set safety stock levels.
    • Set stock cover values.
      Note: These attributes will help you locate your products. And, it feeds info to QuickBooks Commerce Intelligence for accurate reporting and forecasting.
  5. Go to Sales Channels to set the location where each product and variant publishes, lists, or links.
  6. Select Activity to review time-stamped activities of your products or variants.
    Note: You can get more details on activities:
    • From the Stock Movements ▼dropdown menu, choose:
      • Stock Movement
      • Open Sales Orders
      • Incoming Purchase Orders
    •  From the All Stock locations ▼dropdown menu, select location.

Import your new products and variants in bulk

To import products in bulk, download your product sheet, update the info, then upload it in Quickbooks Commerce.

Step 1: Download your product sheet

Follow these steps to download your product sheet from QuickBooks Commerce.

  1. In QuickBooks Commerce, go to Inventory, then select Products.
  2. From the Bulk Manage ▼ dropdown menu, select Import New Products.
  3. Select I need a product spreadsheet template.
  4. Specify if your product comes with multiple options or without options accordingly.
  5. On the attribute selection window, select the attributes to add to your CSV file.
  6. Select Build Product Template, then select Download Product Sheet to download the CSV file.
  7. Open the spreadsheet and enter all required details using Excel or Google sheets.
  8. If all is good, save the spreadsheet as a .csv file.

Step 2: Upload the product sheet

After editing the data in the downloaded CSV file, you can now upload the product sheet.

  1. Upload your product sheet:
    1. Select Upload filled CSV after downloading the file in the previous step, or
    2. Repeat steps 1 and 2 in Step 1: Download your product sheet, then select I have a spreadsheet with product data ready to upload option.
  2. Select Choose File, then select your file or drag the file into the green box.
  3. Select Upload.
  4. Select Import Data after completing the upload and confirming data for import.

Note: If there are any errors pertaining to vendors, country codes (you must use 2-character notations), or if the Initial Cost field is blank, an alert appears stating the issues so that you can correct them and re-upload the file.

If all is good, your product list uploads, and you can now view the products and variants in the Inventory section.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Commerce Core

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this