cancel
Showing results for 
Search instead for 
Did you mean: 
QuickBooksHelp
Intuit

Create new products and their variants

Learn how to create purchased or manufactured products and their its subsequent variants in QuickBooks Commerce.

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

What are product and variants?

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

  • Product: The goods that make up your inventory. Learn more about products.
  • Variant: It’s a group of the same product with different categories (sizes, colors,price, etc.). Learn more about variants.

What are purchased products and manufactured products?

A Purchased Product and its subsequent variants are bought directly from a vendor as finished goods. Its variants can either be sold in their final form or used as components to assemble Manufactured Products.

A Manufactured Product and its subsequent variants are assembled from various components, which are variants of Purchased Products. Its variants (e.g. manufactured variants) can either be sold in their final form or used as components to assemble Manufactured Products.

Note: Before you create products, you need to 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, Stock on Hand Value, and Cost of Goods Sold (COGS). Learn about initial costs and moving average costs.

Create new purchased product and variants

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

  1. In QuickBooks Commerce, go to Inventory, then select Products.
  2. From the Create New ▼ dropdown menu, select New Purchased Product.
  3. Fill in the purchased product’s details.
    1. To set up tracking for your product, mark the checkbox for:
      • Manage stock level: this will indicate that you want QuickBooks Commerce to be the master of stock for this product otherwise the product will be listed with infinite stock availability
      • Sellable: this will indicate whether or not this product can be listed and sold
      • Initial Cost: the dollar value of acquiring one unit of your existing stock on hand
    2. If your product has multiple variants (i.e. sold in multiple sizes, colors or flavors), mark This product has multiple variants checkbox.
    3. If your product has different pack sizes, mark This product is bought in and/or sold in packs checkbox.
  4. Select Continue to Summary.
  5. On 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 new purchased product

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

  1. Select the variant you want to modify.
  2. On the Products variant window, go to Details, then edit your product’s info.
  3. After editing your product info, go to Images to attach one or more images to each product.
  4. Next, go to Stock Locations. Here you can:
    • 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 and your staff locate your products and feed information into QuickBooks Commerce Intelligence for accurate reporting and forecasting.
  5. To set the location where each product and variant will publish, list, or link,  go to Sales Channels.
  6. To review time stamped activity of products or variants, select Activity.
    Note: You can get more details on activities:
    1. From the Stock Movements ▼dropdown menu, choose:
      • Stock Movement
      • Open Sales Orders
      • Incoming Purchase Orders
      • Production Orders Committed (Manufacturing)
    2.  From the All Stock locations ▼dropdown menu, select location.

Import your new purchased products and variants in bulk

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

Step 1: Download your product sheet

  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 in your CSV file. 
    1. Add Price List and Sales Channel options if needed. Learn more about each attribute’s description.
      Note: There are a few required attributes that are grayed out and cannot be removed from the template.
  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. To 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. After completing the upload and confirming data for import, select Import Data.

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

If all is good, your product list will upload and you can view the products and variants within QuickBooks Commerce's Inventory section.

Create manufactured product and variants

To create a manufactured product:

  1. In QuickBooks Commerce, go to Inventory, then select Products.
  2. From the Create New ▼  dropdown menu, select New Manufactured Product.
  3. Fill in details of the product.
  4. Set up initial values of the product. Note: To track inventory levels of the finished product, enable Manage Stock Levels.
    1. Enter your initial stock. If you do not have initial stock, enter “0” in the Initial Stock field.
    2. Select the Initial Stock Location.
    3. Enter the Wholesale and Retail Price.
  5. To set up product variant attributes, mark This product has multiple variants checkbox.
  6. Select Proceed to Summary.
  7. On the Product Summary window, add the info in the fields under the following columns:
    • SKU
    • Initial Stock
    • Initial Cost
    • Retail Price
    • Wholesale Price
    • Sellable
    • Unit weight
  8. Review the details, then select Create product.

Edit variants under new manufactured product

 To view all the variants under the Manufactured Product,  go  to the variants tab. You will also have other options such as editing, cloning, arranging the position of your variants or publishing them to your sales channels.Variants tab_QB Commerce.png

To learn more on manufactured products, check out Setting up your manufacturing

If you need help adding a new product, reach out to us. We’re here to help.

Was this helpful?

You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us