If you sell on a marketplace through SellerCloud, you can bring that store into ConnectBooks as its own store. You then see its sales, fees and refunds in your ConnectBooks reports.
How it works
Each SellerCloud company can come in as 1 store for each marketplace it sells on. ConnectBooks pulls the store's orders, fees and refunds from SellerCloud and shows them in your reports. Nothing from these stores goes to QuickBooks Online, QuickBooks Desktop or Xero.
ConnectBooks can only show what SellerCloud has. If a fee or an order detail isn't in SellerCloud, it can't come into ConnectBooks either.
For example, say a Kohl's order has 2 chairs at $80 each, and Kohl's keeps a $24 commission. Later you refund 1 chair. Your Kohl's store in ConnectBooks shows $160 in sales, a $24 commission and an $80 refund. If Kohl's gives back part of its commission, your Kohl's store shows that too.
Before you start
Connect SellerCloud first. Follow How to integrate SellerCloud with ConnectBooks.
Import your stores
To import a store:
Go to Stores & Files.
Click "Add Store" (or "Add Stores" if you have no stores yet). You can also go straight to the Add Stores page.
Find the tile with the SellerCloud logo. It shows your SellerCloud connection name.
Click "Import" on that tile.
Check each store you want. Each row shows the SellerCloud company and its marketplace.
If you like, change the store name.
Click "Import" at the bottom.
Your new store shows on Stores & Files with a "SellerCloud" tag under its name. ConnectBooks starts pulling its orders right away.
Bring in cost of goods and shipping cost
To bring in your cost of goods and shipping cost from SellerCloud:
Go to Sellercloud Settings.
Next to your connection, click "Edit Stores".
Find your imported store.
Check "Cost of Goods", "Shipping Cost" or both.
Click "Save".
These costs are added to orders that come in while the boxes are checked. Orders that came in before you checked the boxes get these costs only if a later sync reads those orders again. Most older orders won't get them.
Things to know
What comes in: item sales, tax, shipping the buyer paid, discounts, the marketplace commission and refunds.
Cost of goods and shipping cost come in only if you turn them on.
Settlements don't come in. SellerCloud has no payout data, so these stores have nothing on the Accounting Export page and nothing to export.
You see these stores in your reports, like the Profit & Loss report.
If you use ConnectStock, sales from these stores go to ConnectStock too.
ConnectBooks syncs your SellerCloud stores every 2 hours. The first import brings in the last 45 days of orders. After that, every sync checks the last 7 days again for changes.
An order is posted on the day it ships. Until it ships, it shows on its order date.
A refund is posted on the day the money was paid back.
Sometimes a product is not in SellerCloud's catalog when its order comes in. ConnectBooks then adds it with only the details on the order, like its SKU and name. It keeps checking SellerCloud and fills in the rest later, like the UPC, brand and image.
Amazon Vendor Central orders come in as an Amazon store.
Some SellerCloud companies have no marketplace channel. For those, ConnectBooks looks at the company name. If the name includes 1 marketplace, the store comes in as that marketplace. For example, "Acme Macy's" comes in as Macy's. If the name includes no marketplace, or more than 1, the store comes in as "Website".
In the import list, a row marked "Unsupported" is a marketplace ConnectBooks can't import yet.
In the import list, a row marked "Imported" is already in ConnectBooks.
Each imported store counts as a store on your plan.
For an imported store, the cost of goods is saved on each order, not on your listings.
Frequently asked questions
Can I send these stores to QuickBooks Online, QuickBooks Desktop or Xero?
No. Imported stores have no settlements, so they show only in your ConnectBooks reports and ConnectStock.
Some fees are missing. How do I add them?
If a fee isn't in SellerCloud, ConnectBooks can't get it. Add it yourself on the Additional Fees page. You can add a fee to 1 order, or upload many at once with the Excel template. See How to Upload Additional Fees in ConnectBooks.
Why does a product show only a few details, like its SKU and name?
It was not in SellerCloud's catalog when the order came in, so ConnectBooks used only the details on the order. This can happen when another SellerCloud company owns the product. ConnectBooks fills in the rest once it finds the product in SellerCloud.
I already use SellerCloud for cost on my Amazon store. Does that change?
No. A store you connected straight to its marketplace works like before. It gets its sales from the marketplace, and its cost and shipping from SellerCloud.
How often does ConnectBooks sync my SellerCloud stores?
Every 2 hours. Each sync checks the last 7 days again, so recent changes in SellerCloud show up after the next sync.
Can I bring in orders older than 45 days?
Ask us in the chat and we'll help.
Need help? Use the chat icon in ConnectBooks.