When ConnectBooks imports sales data for each SKU, it adjusts the inventory for the matching item in QuickBooks. But your marketplace SKU may not match how the item is set up in QuickBooks. That's why ConnectBooks has a mapping page where you link each marketplace SKU to the right QuickBooks item.
Step 1: Open the QuickBooks Mappings tab
Go to the Listings page, select the store you want to map, and open the QuickBooks Mappings tab.
In the first column, you see the SKU as listed in your store.
In the second column, you see the product type.
In the third column, you enter the item's name from QuickBooks.
This tells ConnectBooks which QuickBooks item each SKU links to, so sales data exports correctly.
Step 2: Select a product type
There are 3 types of products.
Standard
1 marketplace SKU links to 1 QuickBooks item.
Group Item
You sell 2 or more items from QuickBooks together as 1 SKU on your store.
For example, you sell a camera and a camera case together as 1 SKU on Amazon. When you select Group Item, ConnectBooks lets you map this SKU to both items in QuickBooks.
The number in the "% of Cost" column tells ConnectBooks how to split the sale between the items when exporting to QuickBooks. For example, 90% of the sale for the camera and 10% for the case.
Keep in mind: You can't map to a QuickBooks bundle item.
Multi-Pack Item
1 marketplace SKU is a larger quantity of 1 QuickBooks item.
For example, you buy batteries 1 at a time but sell them in packs of 2, 6 or 8 on the marketplace. Each pack has its own SKU, but they all link to the same QuickBooks item, just with different quantities.
When you select Multi-Pack Item, type the number of items in the pack in the Qty box.
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.
Step 3: Select the item name to map to
There are 3 options for item mapping.
QuickBooks (Recommended): Select QuickBooks, click the dropdown, find the item name in QuickBooks and select it. Then click Save.
New: If the item name doesn't exist yet, select "new" from the dropdown and type the item name. ConnectBooks then creates a new item in QuickBooks for this product. This isn't recommended, because it can lead to duplicates in your inventory.
SKU or ASIN: Select the item's ASIN or SKU from the dropdown. ConnectBooks either finds the existing QuickBooks item with that SKU or ASIN as its name, or creates a new item in QuickBooks using the ASIN or SKU. This isn't recommended, because it may lead to duplicates in your inventory.
To learn how to map items in bulk, see How to Map Listings in Bulk Using Excel.
Frequently asked questions
Can I map a SKU to a QuickBooks bundle item?
No. You can't map to a QuickBooks bundle item. Use Group Item instead and map each part.
When should I use Multi-Pack Item?
When 1 SKU is a pack of several units of the same QuickBooks item, like a 6 pack of batteries.
Which mapping option should I pick?
QuickBooks is recommended. The other 2 options can create new items and lead to duplicates.