Instead of editing listings one by one, fill in an Excel file and upload it.
Steps
Go to Listings and open the Inventory Settings tab.
Click Import.
In Bulk Update, click Sample Template to download the file.
Fill in 1 row per listing (see the columns below).
Drag your file into the box, or click choose file. Then click Import.
The columns
ConnectBooks reads the columns by their header name, so keep the headers as they are.
Column | What to enter |
Asin and/or Sku | Which listing to update. Fill in at least 1. It must match the marketplace exactly. |
Buyers | The buyer's ConnectBooks login email. For more than 1, separate them with commas. |
Seasons | The season, like Summer. For more than 1, separate them with commas. |
Lead Time | How many days it takes to restock. Whole number. |
Safety Stock | How many extra units to keep on hand. Whole number. |
Reorder | How many days of stock you want on hand, like 30. Whole number. |
Class Name | Optional. The product's category. |
Frequently asked questions
My buyers didn't update.
Only account admins can assign buyers. If someone else uploads the file, the Buyers column is skipped.
What if I leave a cell blank?
A blank Buyers or Seasons cell removes what's there now. Fill in every row the way you want it to end up.
I got "missing headers".
A header was changed or deleted. Download the Sample Template again and keep its headers.
I got "invalid value".
Lead Time, Safety Stock and Reorder must be whole numbers.