The Listings page shows all your listings in 1 place, so you don't need to open each store. A listing is a product you sell in 1 of your stores, shown by its Store SKU.
The store list
If you have more than 1 store, point to Listings in the left menu. A Select Store list opens. Click All Stores to see listings from every store, or click a store name to see only that store.
The tabs
QuickBooks Mappings or ConnectStock Mappings: link each listing to an item in QuickBooks or ConnectStock.
Product Cost: the Prep Cost, Item Cost, Cost Period and Category of each listing.
Inventory Settings: Reorder Days, Safety Stock, Lead Time, Seasonal and Buyer, used for restocking.
Update the same SKU in all stores with 1 Excel import
Point to Listings in the left menu.
Click All Stores.
For QuickBooks or ConnectStock item mapping, choose the right QuickBooks or ConnectStock file from the dropdown at the top.
Open the tab for what you want to change: Product Cost for cost, Inventory Settings for Class Name, or QuickBooks Mappings or ConnectStock Mappings for mappings.
Click Export (top right).
Save a backup copy, then edit the file in Excel. Update the Cost column, enter the category in the Class Name column, or change the mapping fields.
Click Import, choose your saved file, and click Import.
ConnectBooks updates all listings that match.
Important: To apply changes to all stores selling the same SKU, clear the ASIN column so it matches by SKU only. If you leave ASIN filled, changes only apply when both SKU and ASIN match.
Frequently asked questions
How do I change a SKU in every store at once?
Clear the ASIN column in your file before you import. ConnectBooks then matches by SKU only.
Which tab do I export from?
Product Cost for cost, Inventory Settings for Class Name, and QuickBooks Mappings or ConnectStock Mappings for mappings.
Why didn't some listings change?
If ASIN was filled in, only listings where both SKU and ASIN match were updated.
