Option 1: Custom

Best Practice for sellers - In Custom, you need to point each active item in the Product Settings Page to a correct item name to be sold as.

Why Custom is the best, if not always fastest, way to map your sold items:

As the recommended practice is first to buy items (adjustment for existing quantities is explained later), it is expected that you already have an item in QBs for each active SKU that you sell on Amazon.

First time setup and naming your inventory items:

We recommend that when you set up your items in QuickBooks for the first time, you should give each of their inventory items a name that most reflects the item, such as the SKU name, ASIN#, or a simple descriptive name. Choose a name that is easily identifiable to you, as the user, to identify the item by name for use in purchasing and sales.

After you have existing inventory items in QBs:

It is necessary to set up ConnectBooks to locate the correct item to pull from the inventory for each SKU sold. If you are a seller that has SKUs packed in different quantities or other variations, then you must use the Custom option.

Sellers oftentimes list the same item under different SKU names, or the same item is listed as a FBA and FBM item. When the Custom option is selected, users can point (map) those duplicate items to be sold in QBs as the original item it was purchased as, with the correct quantities, and use multi-packs.

When you set up ConnectBooks for the first time:

It is necessary to map each SKU. From this point, ConnectBooks saves your custom mapping, and only flags a Settlement as un-mapped (and therefore unable to export) when a new SKU is sold in the said Settlement.

Note - If you choose to use Custom mapping, you still have the option, later, to map each item to the same ASIN or SKU number.

Depending on the use case, you may want to use a combination of ASIN and SKU, or only one or the other. When you select ASIN or SKU, ConnectBooks automatically maps each of your items to its exact ASIN or SKU. This means that each SKU you sell on Amazon is sold in QBs with that ASIN or SKU item name.

For example:

If you sell an item with the SKU name “Abcxyz-123”, then ConnectBooks finds an existing name in Quickbooks with these exact same characters and sells it as “Abcxyz-123”. If the SKU does not exist, it creates a new item with that exact SKU name. ConnectBooks does the same automatic mapping with ASIN, but it uses the ASIN #’s as the item names in QBs instead of the SKU’s name.

ASIN and SKU, when used correctly, save a seller from the need to go through each product individually and map it. It is also useful for users who have not set up items in QBs, and do not want to add them manually on their own.

ConnectBooks seamlessly creates a new QBs item for each of your active listed items using the SKU or ASIN name as Quickbooks item name. The reason we do not recommend it as a best practice is because this can only be efficient if each listing you sell is sold in one form only. This means you never sell the same item under more than one SKU name, sell the same item as FBA and FBM, sell multi-packs of a SKU that also exists in single packs, or if you also never sell combo pack items (1 SKU that packs a few different items purchase separately), as each SKU is created automatically in QBs as its own product, with the item name being its unique SKU name, and will be pulled from inventory as such. In the case of all these various forms of the same product, since each of these variations will have a different sku name, it will create duplicate items in QBs, thereby disrupting inventory numbers.

With this selection, each time there is a new SKU listed on your account, new items are mapped automatically to the SKU or ASIN depending on your selection, unless you switched the setting to Custom.