Want to start from a blank template instead? See How to Map Listings in Bulk Using Excel.

Go to the Listings page, pick the store you want to map, and open the QuickBooks Mappings tab. Click Export to download a sheet with your products already filled in.

If your store is linked to ConnectStock, you see a "ConnectStock Mappings" tab instead. That tab maps your SKUs to ConnectStock items and uses a different sheet, so these steps don't apply.

Column D (QuickBooks sku): Type the QuickBooks item name. This is the item ConnectBooks uses to import sales and refunds in QuickBooks for that marketplace SKU.

Column E (Class Name): If you want ConnectBooks to give this item a category, or to export the sales for this item to a specific class in QuickBooks, fill in the category or class here.

Column F (Create New item): Type "Yes" or "No". This tells ConnectBooks whether to create a new item in QuickBooks if the item in Column D doesn't exist there yet. With "Yes", a new item is created in QuickBooks with the name in Column D. With "No", the SKU is only mapped if the item in Column D already exists in QuickBooks. Otherwise, it stays unmapped. If you leave this column blank, ConnectBooks won't create a new QuickBooks item.

Column G (Bundle QTY): The number of units of the QuickBooks item that go into this SKU. For a multipack, if you buy a product from the vendor as a 1 pack and sell it on Amazon as a 2 pack, enter the number of items in the pack. For a group item, enter the quantity of each item on its own row.

Important: If you buy and sell the item in the same quantity, ignore this field. For example, you buy an item in QuickBooks as a 3 pack and sell it on Amazon as a 3 pack.

If you sell 2 or more different items as 1 SKU, map it using multiple rows on the sheet, 1 row for each item. See the screenshot:

Column H (Percent): Only used for group items. Enter each item's share of the group's total cost. For example, you sell a camera and a camera case together. The camera costs $90 and the case costs $10. Enter 90 on the camera row and 10 on the case row.

Type the number with no % sign. If you type 90% in Excel, it saves as 0.9. The numbers in a group must add up to 100.

To work out the Percent for each item:

Percent = (item cost × quantity) × 100 ÷ total cost of the group

Repeat this for each item in the group.

Column I (Item as Sub Class): If you export with QuickBooks classes and want ConnectBooks to create a subclass for each QuickBooks item, type "Yes". If not, ignore this field.

Do I need to fill in Columns A to C?

No. They're already filled in from your store.

My group item percents came out wrong. Why?

If you typed 90% in Excel, it saved as 0.9. Type 90 and 10 with no % sign, and make sure the numbers in the group add up to 100.

Why don't I see the QuickBooks Mappings tab?

If your store is linked to ConnectStock, you see a "ConnectStock Mappings" tab instead. That tab maps your SKUs to ConnectStock items and uses a different sheet, so these steps don't apply.