Mapping tells ConnectBooks which ConnectStock item each marketplace SKU is. That item is used to track the SKU's sales and refunds. To map many SKUs at once, use an Excel file.
Your store must be connected to an inventory file to do this.
Steps
Go to Listings and pick the store.
Open the ConnectStock Mappings tab.
Click Import.
In Import Mappings, click Sample Template to download the file.
Fill it in (see the columns below).
Upload the file and click Import.
The columns
Column | What to enter |
Asin | The marketplace ASIN. |
Sku | The marketplace SKU. You need the Asin or the Sku, not both. |
Title | The listing title. You don't need to fill this in. |
ConnectStock Item | The ConnectStock item this SKU is. Required. |
Category | You can leave this blank. This import doesn't use it. |
Create New item | Yes: create the ConnectStock item if it doesn't exist yet. No: only map to items you already have. Blank: same as No. |
Bundle QTY | For multi packs: how many items are in the pack. For group items: how many of this item are in the group. Blank means 1. |
Percent | For group items only. See below. |
Multi packs
If you sell a pack, like a 2 pack or 6 pack, enter the number of items in Bundle QTY.
If you buy and sell it the same way (you buy a 3 pack and sell it as a 3 pack), leave Bundle QTY blank.
Group items
A group item is a SKU made of different items, like a camera and a case sold together. Put each item on its own row with the same SKU.
In Percent, enter each item's share of the group's cost. You can:
Type calculate on every row of the group. ConnectBooks works out the shares from each item's default cost times its Bundle QTY. If any item has no cost, it splits by quantity instead.
Type the numbers yourself. For example, the camera costs $90 and the case costs $10. Enter 90 for the camera and 10 for the case.
To work out a share yourself: (item cost × 100) ÷ total group cost. For the camera: ($90 × 100) ÷ $100 = 90.
The numbers in a group must add up to 100, and each number must be more than 0. Don't mix "calculate" and numbers in the same group.
Frequently asked questions
Do I need both Asin and Sku?
No. 1 of them is enough.
What happens if the ConnectStock Item doesn't exist?
Set Create New item to Yes, and ConnectBooks creates it. Otherwise that row fails with "Cannot Find Inventory Item". In a group, the whole group fails.
Some rows didn't import. How do I see why?
ConnectBooks downloads an error file that lists each failed row and the reason.
My group upload failed.
Check that the numbers add up to 100 and each number is more than 0. Or use "calculate" on every row. Don't mix them.