Step 1: Navigate to the Listings Page
Go to the Listings page in the menu, select the store you want to configure, and open the Inventory and Configuration tab. Here, you'll see all your marketplace items.
Step 2: Click on Import
Here you’ll have have the option to download a sample template, or import the excel sheet.
Step 3: Fill Out the Excel Template
Here’s a breakdown of the template columns:
Column A: Enter your marketplace ASIN.
Column B: Enter your marketplace SKU.
Note: You can map using either ASIN or SKU—only one is required.
Column D: Enter the ConnectBooks item name. This is the item that will be used to track sales and refunds for the SKU.
Optional Fields:
Column E (Category/Class): Enter a category or class if you want to group the sales of this item in ConnectBooks.
Column F (Create New Item): Enter “Yes” if ConnectBooks should create a new item for the items in column D if it doesn’t already exist; enter “No” to only map existing items. Leave blank to skip creating new items.
Multi-Pack Items
For multi-packs (e.g., selling a 2-pack or 6-pack of an item):
Column G: Enter the number of items in the pack.
Note: If you buy and sell the item in the same quantity (e.g., 3-pack purchased and sold as a 3-pack), leave this blank.
Group Items
For SKUs that bundle multiple items (e.g., a camera and case sold together), you can map it by using multiple lines on the mapping sheet. See Screenshot:
Column H (Group Percentage): Enter the percentage of the total cost for each item in the group.
Example: If a camera costs $90 and the case costs $10, enter 90% for the camera and 10% for the case.
Group Percent - To calculate the Group percentage:
Obtain the total cost of the group.
Take each individual cost and multiply it by 100.
Divide it by the group’s total cost.
Repeat these steps for each item.