How do I authorize SellerZen as a developer on Amazon?

Learn how to authorize SellerZen as a developer on Amazon.

You’ll have to authorize SellerZen as a developer before we can begin syncing your data. To do this, simply go to Settings > User Permissions. 

Scroll down to Third party developer and apps and click on the “Visit Manage Your Apps” button.

Enter the following information for the required field:

Developer’s Name: SellerZen
Amazon US Developer ID: 4966-7670-9125
Amazon EU Developer ID: 644415748153

Click on Next. Verify that you want to allow developer access. Click on Next.

The next screen will display your Seller ID and MWS Auth Token. You’ll need both when you connect your Amazon marketplace to SellerZen.

If you close this page, you can access the MWS Auth Token under Settings > User Permissions. Click on the “Visit Manage Your Apps” button under Third party developer and apps.

Click on View to see your MWS Auth Token for SellerZen. This is also where you renew access for SellerZen.

If you’re re-adding SellerZen and you can’t find your Seller ID, then click on Settings > Account Info > Your Merchant Token to get your Seller ID.

Where can I find my Amazon Seller ID and Amazon MWS token?

Learn where to find your Seller ID and Amazon MWS token to renew or authorize SellerZen as a developer.

You can find your Amazon Seller ID under Settings > User Permissions. If you’ve already added SellerZen and need to find your Seller ID and MWS Auth Token, scroll down to see where you can find the information.

You can also find out how to renew your SellerZen token at the end of this article.

Under Third party developer and apps, you’ll be able to add SellerZen as a developer. You’ll see both your Seller ID and your MWS Auth Token after you complete the fields.

Copy and paste the information from our platform into the fields, or type it in:

Developer’s Name: SellerZen
Developer ID: 4966-7670-9125

Click on Next. Check the box to allow developer access and click on Next.

On this screen, copy and paste your Seller ID and MWS Auth Tokens into the proper fields.

Finding your Seller ID or Merchant Token if you’ve already authorized SellerZen

Click on Settings > Account Info > Your Merchant Token to see your Seller ID.

Copy and paste your Merchant Token / Seller ID in the proper field on SellerZen.

Finding your MWS Auth Token if you’ve already authorized SellerZen

Simply click on View to see your MWS Token on the Manage your apps page. Go to Settings > User Permissions > Manage your apps.

Find SellerZen and click on View.

Renew your MWS Auth Token

Go to Settings > User Permissions > Visit Manage Your Apps. See the image above.

Most sellers can just click on Renew to refresh SellerZen’s developer access. Then simply resume the integration to have our system automatically start where we stopped.

However, Amazon will sometimes issue a different token instead of renewing the old one. If that’s the case, follow the image below and update the MWS Auth Token on SellerZen.

If you need to enter a new MWS Auth Token, then click on the Renew button and copy and paste the new MWS Auth Token into the SellerZen field under Integration > (Select Amazon Marketplace) > API.

How long do I have to wait for SellerZen to import all of my orders?

The time it takes to sync depends on the number of orders.

The amount of time it takes for us to sync your data between Amazon and QuickBooks Online depends on how far back you want the data to be synced and how many orders you have.

If the settings were all configured with no issues, then you should start seeing transactions being imported into SellerZen within minutes. You should see transactions imported into QuickBooks Online within 30 minutes, but some integrations may take longer before transactions start to be imported into QuickBooks Online.

For enterprise customers, import times will depend on Amazon API limits. If you have any questions at all, please email us at info@sellerzen.com or start a chat and ask us. We’re happy to answer any questions you may have.

For many sellers, the syncing will be complete within 24 hours unless problems arise.

Once started, our service works automatically in the background. You do not need to be present, and you can still use QuickBooks Online or handle your Amazon business.

What does “Use the following customer account for orders in this marketplace” mean?

Create a new customer for each order or use a default account for all orders for this marketplace.

SellerZen can store individual customer information in QuickBooks Online, or we can group all customers from one marketplace under a default account that you name. 

If you create the customer, make sure the currency matches the marketplace location, so if you’re creating an Amazon US customer, the currency must be USD. Read more here about enabling multicurrency and creating customers.

When we create a new invoice, we’ll try to find an existing customer account. If the account doesn’t exist, we will do one of the following depending on the option that is selected:

A.  Create a new customer account for the order

When a customer account cannot be found, we will make a new customer account with the customer information provided on the order.

B.  Use a pre-selected customer account for all orders in the marketplace

We’ll use this customer account for all orders on this marketplace. We highly recommend that you select this option since QuickBooks Online will slow down as you add more and more customers. 

You can still search by Order ID in QuickBooks Online under the Advanced Search mode filtered by Invoices and Memo field.

Alternatively, you can search customer name or Order ID on SellerZen under Orders. From there, you can view the QuickBooks Online document directly by clicking on the View button.

Here’s how your customer list will look like with grouping:

Your QuickBooks Online invoices will all have the default name you chose for the Billing address field. The shipping address field will contain the shipping information for your customer.

You should have one default customer account per marketplace since QuickBooks Online’s performance will gradually slow down as your customer list grows. Search functions and other reports may take longer to load.

When should I start the sync?

You should start the sync at a date and time that is after the last order you’ve manually entered.

To prevent duplicate documents from being created in QuickBooks Online, you should start the data import at the time of the last order you’ve manually entered into QuickBooks.

For instance, if you’ve already entered all of Monday’s orders into QuickBooks Online (up to midnight), then you’ll want to start the syncing at 12:01AM on Tuesday. This way, our service will begin syncing right where you left off, allowing for seamless integration.

Similarly, you can enter all orders up to 5PM on Monday and set our service to sync all orders after 5PM.

If you’ve never entered individual transactions into QuickBooks Online, then select a sync start date that begins on the first date of the settlement period that you want to import.

For example, if your settlement period looks like this: Feb 2, 2019 – Feb 15, 2019, then you’ll want to set the start date to Feb. 2, 2019. This is so that you don’t import transactions from a previous settlement.

Once you choose the date and time to start syncing, you no longer have to be present or do anything else. We’ll take it from there.

You won’t be able to change the start date and time once you choose it. This is to prevent duplicate documents. 

If you change your mind about the date and time, please contact us so that we can help you.

Connecting SellerZen to your QuickBooks Online company

This guide will walk you through connecting SellerZen to your QuickBooks Online company.

If you’re already logged into your SellerZen account, then follow the instructions below to connect your QuickBooks Online account.

If you’ve signed in using the Intuit Sign in button, then scroll down to Intuit Sign In section to resume.

Start by clicking on the “Integration” link on the left menu bar. You should see the following screen. Click on Connect to QuickBooks.

Sign in using your QuickBooks Online login information.

Select the company you want to connect.

Verify that you’ve chosen the correct company and then click on Connect.

Read and agree to the terms of service if you want to continue.

Intuit Sign In Button

If you logged into our website with the Intuit Sign In button, you’ll skip the steps above and arrive at the following screen. Fill out the requested fields to allow SellerZen to continue.

You’ll be able to choose which QuickBooks Online company you want to sync with your Amazon account on the next screen.

Choose the company you wish to sync with Amazon and then click on the “Connect” button on the next screen.

Establishing a connection should take less than a minute. You’ll be returned back to the Integration page once the connection is complete. Read and agree to the terms of service if you want to continue.

Congratulations! You’ve synced your QuickBooks Online company with our service.

You can verify by clicking on the QuickBooks Online tile and seeing the connected company.

If you’ve connected SellerZen to the wrong company, then simply click on the “Disconnect” button to disconnect our service from your QuickBooks Online company. You can then repeat the process to connect to the correct company. 

What is the difference between item name and SKU in QuickBooks Online?

Learn about QuickBooks Online Inventory SKU and Name.

Amazon uses a SKU as a unique label to identify products. That means every single product has its own unique SKU.

QuickBooks Online works a little differently. When you create a new inventory item in QuickBooks Online, the Name is unique. However, inventory in QuickBooks Online can share the same SKU.

When you use SellerZen, you have the option of mapping your Amazon SKU to either the QuickBooks Online Inventory Name or SKU.

We recommend you map Amazon’s unique SKU field to QuickBooks Online’s unique Name field to reduce any inventory confusion.

If you use our Setup Wizard, we’ll map your unique Amazon SKU to QuickBooks Online’s unique Item Name field. For the QuickBooks SKU field, we’ll use the ASIN.

If you map your Amazon SKU to the QuickBooks SKU field, then we’ll use the Amazon SKU for both the QuickBooks SKU field and the Name field.

You can change how SellerZen maps Amazon’s SKU to QuickBooks Online in the Integration > SKU Mapping tab.

What does the Undeposited Funds Account field mean?

This is the holding account for your Amazon seller transactions.

Undeposited Funds are payments that you’ve received on Amazon but haven’t been disbursed. For Amazon, this includes all of your current sales income. This type of account is also known as a clearing account or a holding account. 

You’ll have to create a new Bank account with Detail Type Cash on hand or Checking in QuickBooks Online. Name it Amazon US Undeposited Funds or something similarly descriptive. Then click on the refresh button and select it on SellerZen.

This option allows you to choose the account to deposit sales income from your current settlement period.  

Once Amazon disburses your current settlement, the amount from this account will be transferred to your selected disbursement account under the Settlement tab, less any reserve amount.

The balances between the account you choose for this field and your current Amazon settlement will be approximately the same. This is because of pending transactions.

What are the Default Other Income and Default Other Fee accounts?

Default Other Income and Default Other Fee accounts are used for transactions that are not mapped.

Under Settlement, you’ll find three fields: your Bank account for Amazon deposits and the default income and expense accounts for non-order income and expenses that occur on the settlement.

Some of these non-order income and expenses include Amazon reimbursements for warehouse damaged inventory and FBA storage fees.

All miscellaneous settlement income from Amazon that isn’t already mapped will go into the Default Other Income Account. This may include transactions from reimbursements. 

All miscellaneous settlement expenses from Amazon that are not already mapped will go into the Default Other Fee Account. These expenses can include your subscription fees.

Your Current Reserve Amount and Previous Reserve Amount are mapped to your Undeposited Funds account by default so that your Undeposited Funds account will reflect your current seller balance on Amazon. 

We recommend that you map your current reserve and previous reserve to the account you’ve chosen for your Undeposited Funds.

If you didn’t map the Inbound Transportation Fee or Storage Fee, you’ll find these automatically mapped to your Default Expense Account.

Using the SellerZen Setup Wizard

Learn how to use the SellerZen Setup Wizard.

Using our setup wizard, you can be set up and ready to begin data import in mere minutes if you have a new QuickBooks Online company!

If you have an existing company, you can still use our Setup Wizard to generate the accounts and then rename them if you want.

Once you’ve added your QuickBooks Online account and Amazon Marketplace, you’ll be presented with the following page:

If you have a brand new QuickBooks Online account without any transactions and want to use our Setup Wizard, click on “I do not have transactions in QuickBooks Online.”

If you have transactions, click on “I have transactions in QuickBooks Online” to manually configure SellerZen. Click on Continue.

Click on Proceed. If you don’t have inventory tracking, then we’ll create a non-inventory item to map all of your Amazon inventory.

Once the Wizard is complete, click on Finish Wizard. 

Review the default settings on each tab.

You’ll want to configure sales tax if you’re required to collect sales tax. If you’re using FBA, you’ll want to set up the Marketplace Sales Tax as well. Click below to read more. Review the settings and make any changes.

Under the SKU Mapping tab, we have the “Skip order and notify me” option selected by default. If you want us to create the item, select that option.

Review the settings on the Tabs. You can go to QuickBooks Online and change any of the default account, service item, or bank account names you want. 

We recommend you change the default Amazon Bank Account we created. You can find this through the “Accounting” link on the left menu in QuickBooks Online. 

Afterward, click on the “API Status” tab and click on “Start” to complete your SellerZen setup and begin data import.