Showing results for 
Search instead for 
Did you mean: 

Create relationships in QuickBooks Commerce

Find out how you can create relationships in QuickBooks Commerce.

Through QuickBooks Commerce’s relationship, you can manage your vendor and customer relationship. You can either manually create these relationships or upload a CSV file. Here’s how.

Create relationships

These are the categories of relationships:

  • Vendor relationships. These are the companies you buy from that will appear on your purchase order
  • Business Customer relationships. These are the businesses you sell to and will appear on your sales order.
  • Consumer relationships. These are the individuals you sell that will appear on your sales order.

Here are two ways you can create relationships in QuickBooks Commerce.

Add relationships manually

If you need to create a relationship one at a time, follow these steps.

Note: If you imported your inventory through a sales channel, your consumer relationship imports into QuickBooks Commerce from any unfulfilled sales orders. You just have to create Vendor or Business Customer relationships.

Step 1: Create a vendor

  1. From the Relationships section, select the Create New ▼ dropdown menu.
  2. Select New Vendor.
  3. Fill out the vendor’s company info, then assign the default settings.
  4. Enter the company’s detailed address info for the sales and purchase orders.
  5. Select Create Vendor.

Step 2: Add a contact for your vendor

  1. From the vendor’s page you just created, select + Add a contact.
  2. Enter the contact info, then select Add Contact.

Add relationships in bulk

In QuickBooks Commerce, you have an option to add relationships in bulk. You just have to import your data from a CSV file. Here’s how.

Step 1: Download your data

  1. From the Relationships section, select the Bulk Manage ▼ dropdown menu.
  2. Select Import Relationships.
  3. Download the .csv template and fill in the fields using excel or google sheets, then save as .csv.

Step 2: Import your data

  1. Once you’re done with your CSV file, select Choose File.
  2. Select the CSV file you just created.
  3. Review your data, then select Import Companies.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up