How to Integrate eBay with QuickBooks?

You have been using the QuickBooks version for years and eBay is where you go to shop, sell, and give. Many times, it is quite frustrating or difficult to handle two software at the same time for different purposes. Integrating QuickBooks and eBay gives everything they need to seamlessly manage inventory, orders, and more to streamline operations and focus on growth.

Moreover, you can connect your eBay Store to your QuickBooks company profile and save hours of manual data entry. This article guides you on setting up with eBay, built natively by QuickBooks. Let’s delve into the complete process for QuickBooks eBay integration in this particular guide. 

Benefits of integrating QuickBooks with eBay

• Automatic data sharing between eBay and QuickBooks saves time and money.
• Connect numerous sales channels to QuickBooks to keep track of stock levels.
• Remove manual data entry and shortcuts, which frequently lead to human error.
• The integration will automatically update stock levels between QuickBooks and eBay.
• From eBay, automatically send any updated or newly produced products to QuickBooks.
• When an order is placed on eBay, automatically share it with QuickBooks, which will build or update the sales invoice or receipt.

Things to do before you get started 

Make sure that you do the spadework within your eBay Store before you begin the integration process with QuickBooks. It is also important that you review the Product SKUs on eBay first. 

The reason for this is that SKUs are used by QuickBooks to identify and match inventory across eBay and QuickBooks, allowing for smooth inventory updates and order management operations. Log in to your eBay account and double-check that each product and its variants have unique SKUs before moving on.

Supported Triggers and Actions

Triggers

New Order Triggers when a new order is made.
New Account Triggered when you add a new account.	New Bill Triggers when a new bill is added.
New Customer Triggered when you add a new customer.	New Estimate Triggered when you add a new estimate.
New Expense Triggers when a new expense is added.	New Invoice Triggered when you add a new invoice.
New Invoice Triggered when you add a new invoice (with line item support).	New Sales Receipt Triggered when a new sales receipt is added (with line item support).
New Payment Triggered when a payment is received (with line item support).	New Purchase Order Triggers when a new purchase order is added.
New Sales Receipt Triggered when a new sales receipt is added.	Updated Customer Triggered when an existing customer is updated.
New Vendor Triggered when a new vendor is added.

Actions

Create a Shipping Fulfillment Add a shipping fulfillment to a line item.	Find an Order Search for an order.
Create Bill (Item Based) Create a new bill, optionally tied to a customer.	Create Bill (Account Based) Create a new bill, optionally tied to a customer (with line item support).
Create Bill (Item Based) Create a new bill, optionally tied to a customer (with line item support).	Create Credit Memo Creates a new credit memo.
Create Customer Adds a new customer.	Create Estimate Create a new estimate (with line item support).
Create Time Activity Creates a new single-time activity.	Create Product/Service Creates a new product or service.
Create Journal Entry Creates a new journal entry.	Create Invoice Adds a new invoice (with line item support).
Create Sales Receipt Adds a new sales receipt (with line item support).	Create Payment Creates a new payment, optionally linked to an invoice.
Create Purchase Order Creates a new purchase order.	Create Refund Receipt Creates a new refund receipt.
Send Invoice Send an existing invoice.	Send Sales Receipt Send an existing sales receipt.
Create Time Activity Creates a new single-time activity.	Update Customer Updates an existing customer.
Update Invoice Updates an existing invoice (with line item support).	Create Vendor Adds a new vendor.
Find Account Find an account by name.	Find Customer Find a customer by name or email address.
Find Invoice Find an invoice by number.	Find Product(s) Find a product by name (with line item support)
Find Vendor Find a vendor by name.	Find or Create a Customer Finds or creates a specific customer v2.
Find or Create a Vendor Finds or creates a specific vendor.

Steps involved in integrating eBay with QuickBooks

There are mainly three steps involved in this integration:

1. Installation Process 

A. Install the eBay App

• Click on the Browse Apps from the main navigation bar 
• Next, click on eCommerce and then select “eBay built by QuickBooks”
• Now, click on the “Install App” button, and then you’ll asked to “Connect your eBay store” 
• From the drop-down menu, select the eBay site Country and then hit “Continue” 
• After that, you’ll be directed to the eBay homepage where you need to Sign in 
• In the next screen, you’ll asked for confirmation to allow the eBay store to integrate with QuickBooks 
• And then click the tab “I agree”
• With this, you’ll be redirected back to QuickBooks to complete the installation using the on-screen setup wizard.

B. Price List and Location Sync

From within the QuickBooks installation wizard, you have to 

• Either select the pre-existing price list and stock location for your channel
• Or create a new price list and stock location

The chosen or newly created price list will be used to populate the pricing of imported eBay products and to sync up-to-date prices in the future. If no price list is selected, QuickBooks will utilize the default retail pricing list regularly.

The selected or newly created stock location will be used to sync up-to-date stock levels in the future, as well as initialize stock levels of imported products from eBay. If no stock location is specified, QB will use your account's Default Primary Location, which is located under Defaults Settings. 

You simply go to the Settings from your main navigation bar and click on Configuration then click on the “Configurations” option. With this, your Default Settings will appear on your screen. 

Important Note to be considered 

• When you use a pre-existing pricing list that is shared with another channel, the prices in that list will be updated when you import products.
• If an existing price list or location with a similar name is found, then the 'Create a new Location/Pricing List' option in the drop-down will be disabled to prevent duplication of price lists or locations.
• If you're using the new stock location, make sure your QuickBooks product stock levels are right before activating the stock sync; otherwise, you can end up with nil stock on eBay.

C. Product SKU

The installation wizard will show you how to use SKU aliasing to manage distinct SKUs across several sales channels. Skip this step if you're setting up your QuickBooks Commerce account with a single eBay Channel or if you're managing the same SKUs across many channels. 

In the end, click the “Confirm” button and with this, the installation is completed then you'll be redirected to your Channel’s Dashboard tab. 

2. Dashboard 

This Dashboard presents both analytical and operational data of your eBay store’s connection health/configuration with QuickBooks. It also shows a series of health checks that will help you diagnose and resolve a variety of difficulties that may obstruct order imports or changes. You can re-run the diagnosis at any time by selecting the ‘Re-run Checks' button and refreshing your screen browser tab until the diagnostics are completed.

Note: QuickBooks Commerce executes diagnostics for your channel on a daily basis to ensure that you have the most up-to-date information on your channel dashboard.

3. Settings 

This tab mainly consists of two sections namely “Settings” and the “Sync Options”. It lets you specify configuration for your eBay store and also contains defaults that you can easily modify. 

The “Settings” section offers six main configurations:

1. Channel Name: For easy identification within the App, you can assign a custom name for your channel.
2. Default Tax Treatment: By default, this is set to ‘Exclusive.' The tax treatment for all new orders imported into QuickBooks will be set to the value selected.
3. Default Price List: Any changes to Variant prices or the selection of a different default price list would trigger price updates to linked eBay variations if price sync was not disabled. However, eBay will not be notified if the price under the default price list is 0 or nil. This also helps you to prevent any accidental zeroing out of price on eBay.
4. Default Stock Location: Any order from your eBay store that is imported into QuickBooks will be assigned to the location specified in this setting. During the product import, your eBay product's stock will be assigned to this location as well. If stock level sync is not turned off, any stock level changes on the location or the selection of a different default stock location will update stock levels on linked eBay variants.
5. Default Tax for Orders: The tax rates applicable to orders imported into QuickBooks will be calculated using the tax amounts provided by eBay. However, if a default tax rate is required, this can be done by selecting a tax from the drop-down menu.
6. Default Shipping Tax For Orders: In this, if you select a tax type then QuickBooks will automatically apply the selected tax rate to ship the line items of newly imported orders. 

The “Sync Options” section offers 5 options that regulate the disabling of syncs for various objects and are checked by default when the channel is installed for the first time. The data during an order import is affected by the last option.

1. Disable Price Sync: Changes to the default price list assigned to the channel will not be synced to eBay if this option is checked by default.
2. Disable Stock Level Sync: By default, this option is enabled, which implies that any stock level changes for a linked variant under the default stock location will not be synced.
3. Disable Order Import: Every 10 minutes, QuickBooks pulls fresh orders from eBay.  On the other hand, QB will not import any new orders if this option is checked (which it is by default).
4. Disable sync of eBay order changes back to QuickBooks: Every 10 minutes, QB checks eBay to see if any of the imported orders have been changed (e.g. if any orders get fulfilled, canceled, etc.). If this option is enabled (which it is by default), QB will not detect any eBay order modifications.
5. Use the domestic shipping address for international orders: When integrating an eBay order into QuickBooks, the customer address is used for both shipping and invoicing.

If this option is selected, the shipping address for the domestic leg will be utilized in the ‘Ship To' field when importing international orders. The billing address will be the customer's address and a note will be added to the imported order with the shipment Reference ID.

Conclusion!

This is all about QuickBooks eBay Integration and hopefully, it will help you in integrating your software. To learn more about the integration process of various other applications with QuickBooks, you can visit our website www.smbaccountants.com. Or, you can do Live Chat with Experts for queries related to QB integration. 

Need Professional Help?

Once all these steps have been completed you will be able to sync your information from eBay to QuickBooks and vice-versa. If you are facing any problem in integrating QuickBooks with eBay kindly get in touch with our QuickBooks professional technical team and they will be more than happy to assist you for the same. We have a pool of trained technical professionals who are a pro at dealing with all QuickBooks-related queries.