When ConnectBooks imports sales data for each SKU, it lowers the inventory quantity for the item. This change in QuickBooks is made for the product mapped to that SKU, which keeps your inventory accurate. Follow the steps below to map your listings to QuickBooks items with an Excel upload.

Go to the Listings page, pick the store you want to map, and open the QuickBooks Mappings tab. Here you can see all your marketplace items.

Click Import. In the Bulk Update window, click the "Sample Template" link to download the blank sheet.

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.

Want a sheet that already lists all your items? See How to Map Listings in Bulk Using Excel: Prefilled Sheet.

Here's what goes in each column:

You can map using either the ASIN or the SKU. Only 1 is required.

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

Column F (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 or more, 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 from the supplier, enter it 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 G (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 H (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 both the ASIN and the SKU?

No. You can map using either one. Only 1 is required.

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.

I get "Invalid File" when I upload. What do I do?

The file must be an Excel workbook. Save it as .xlsx (Excel Workbook) and upload it again. A .csv file won't work.