Amazon settings
Customize your Amazon integration settings from the Setup section. These settings let you control how Cin7 Core and Amazon interact, including:
Load from Amazon
Decide when orders download from Amazon (when fully paid or fully shipped).Use Amazon as master source for Cin7 Core products
Decide if Amazon or Cin7 Core is the main source of information.Consolidate orders
Choose if you want to download individual orders, or one combined daily order.
And so much more! Each of these settings are broken into different tabs to help you easily find the right section. We recommend connecting your Amazon integration and following the instructions to make sure you get the best experience.
There are also different settings that control the Amazon FBA integration.
Prerequisites
An Amazon Seller Pro account (required)
Users will need the Integration: eCommerce - Amazon permission to update the settings.
General settings
Load from Amazon
Select when sales are loaded from Amazon. The user has the option between loading paid sales or fully shipped sales.
Price tier
Map Amazon listings’ (products) price to Cin7 Core price tiers. If the user lists the same Cin7 Core product in multiple Amazon marketplaces and has chosen to use static pricing, they MUST use a different price tier for each Amazon Marketplace; otherwise, the price in Cin7 Core may be overwritten by the price in Amazon Marketplace currency during catalog download. Markup pricing and customer pricing are not affected.
Customer
For pending order processing to be successful, an existing customer must be selected. When you consolidate orders, this creates a new sales task under this customer. A customer can be created just for this purpose. If you don't consolidate orders, Cin7 Core will use the customer company name as the customer name (unless the company name was not specified). In this case, the customer contact name is used instead.
Sales representative name
This option allows the shop name to be used as a Sales Representative. It is useful if you have several shops in the same region (marketplace) so as not to cause confusion. If you leave this field blank, a marketplace abbreviation will be used instead (like Amazon_US, Amazon_UK, etc.).
Location for merchant fulfilled orders
Fulfillment by Merchant (FBM) means that products are stored somewhere at the merchant (seller) location. You can specify a location just for Amazon eCommerce. Amazon will display that location's stock quantity and sales orders will be picked from that location. Selecting All locations will display the total stock quantity across all of your locations.
Location for Amazon fulfilled orders
Fulfillment by Amazon (FBA) means that all fulfillment and inventory management processes are fully automated and handled by Amazon. You can select a location for Amazon fulfilled orders to track quantities or choose not to process FBA orders.
Pick, pack and ship processing mode
When pending orders are processed by Cin7 Core, new sales tasks are created. This setting tells Cin7 Core if it should try to Auto Pick, Auto Pack and Auto Ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then Pick will remain in Draft state, and Pack and Ship won’t be completed.
Cin7 Core does not pick up shipment information from Amazon if Auto Ship is selected and will not create Fulfillment in Amazon in this scenario (if Auto Ship is enabled).
Process Auto-Assembly
This dropdown field has two options:
For ordered quantity: Does not check stock quantity. An assembly order is created for the quantity specified in the sale order, regardless of stock availability.
-
For minimum quantity required for picking: Assemble stock required to meet the quantity of specific sale order.
If stock availability is negative, auto-assembly will produce a finished goods quantity which is more than the quantity ordered through sale order.
If there is already stock available in inventory but not enough to fulfill the sale order quantity, auto-assembly will assemble the difference in quantity needed to meet the sale order requirement.
If stock availability exceeds sale order quantity, auto-assembly is not triggered.
Stock availability is validated against the sale order location and does not take On Order quantity into account.
Use Amazon as master source for Cin7 Core products
If this option is enabled, if a product has been changed or updated in Amazon, the linked product in Cin7 Core will be changed to match upon catalog download. Product changes in Cin7 Core can include a changed price, name, weight, length, pictures and other data (except for SKU) based on the product data downloaded from Amazon.
Match product manually
When disabled, Cin7 Core will automatically match your Cin7 Core products to your Amazon products by their SKU. You can still manually map products even is you have this setting disabled.
Enable Match product manually to prevent Cin7 Core from automatically mapping existing products. Instead, you can select the matching Cin7 Core product in the Catalog tab. Newly created products will automatically map.
Create a new product if not found by SKU
This option is only available when Match product by SKU is enabled. With this option enabled, if there is a product (SKU) in the sales channel that does not yet exist in Cin7 Core, then this product can be automatically built in Cin7 Core based on the data received about the product from a sales channel. The possibility of a manual build is still always available through the Cin7 Core UI.
Update stock levels in Amazon
You may choose to disable automatic stock level update in Amazon performed by Cin7 Core at the time available product quantity changes in Cin7 Core. This may be useful if you are managing stock levels in Amazon manually and do not want Cin7 Core to change it. Please ensure you have the correct stock quantities entered in Cin7 Core before you turn on this option as these values will override the stock quantities in Amazon.
Export shipping information to Amazon
You may enable the export of shipping information from Cin7 Core to Amazon.
Consolidation settings
Consolidate orders
You can choose to import your Amazon orders as they come in, or import a single sales order that contains all of the Amazon orders for the day.
No Consolidation will capture sales from Amazon as they occur.
-
Daily Consolidation will consolidate all orders from that day into a single order.
You can then select the:Type: Choose which Amazon order types are consolidated. All consolidates every Amazon order, FBM consolidates only orders Fulfilled By Merchant (FBM), and FBA consolidates only orders Fulfilled by Amazon (FBA).
Consolidation Time: Choose your local time when all pending orders should be consolidated.
See the Pending Order Processing section below for more details.
Account and cash settings
Invoice status
You can control the Invoice Status for sales tasks created as a result of pending order processing. By default, the invoice will not be authorized and will be in Draft state, adjustable and waiting for authorization. However, if this setting is changed to AUTHORIZED, the invoice will be automatically authorized, and pending sync will be created for it to sync with an accounting application of your choice.
Optional revenue account
This is the revenue account to be used for all Amazon sales. This will override settings at the Product/Customer level and any other Account mapping.
Ignore Amazon taxes
You may choose to ignore taxes from Amazon.
Process Amazon settlements report
Amazon generates Settlement Reports for its sellers, providing breakdowns of Item Price, Amazon commission fees, shipping fees, and total amount earned by the seller - detailed information of a seller’s account activity for the settlement period. You may set Cin7 Core to either automatically process settlements from Amazon as Manual Journals or perform this processing manually.
Money settlement bank account
Select the bank account that is used to receive settlements from Amazon.
Xero synchronization mode
Only applicable to accounts integrated with Xero. Cin7 Core allows consolidating all sales from the same channel and store when exporting sale details to Xero. Sales can be synced individually, but also can be consolidated per settlement period.
Note: If Xero sync mode on Amazon setup is Sync individual sales, sales from Amazon can still be consolidated from Xero integration following instructions of Xero Integration - Consolidating Sales on Export. If Xero sync mode on Amazon setup is Consolidate as settlement report, this will take priority over consolidation settings of Xero integration.
Group transactions by
Only applicable to accounts integrated with Xero where sales are consolidated by Amazon Settlement. This grouping options will allow users to further filter and group their principle sale amount either by All sales (default), by product or by product category where the principle sale amount will be displayed by the product/ product category for items sold within this settlement period.
Currency of the Amazon settlement will not be captured while processing the settlement file. Bank account currency and Amazon settlement currency must be the same to avoid discrepancies.
Link Amazon and Cin7 Core tax rules
You will need to link Amazon and Cin7 Core tax rules before you use your Amazon integration. Orders will be skipped on download if tax mapping is not finished.
When a pending order is processed by Cin7 Core, a sales task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines.
Cin7 Core does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the Amazon order. This means that if certain products are not Taxable or with varying tax in Amazon, all data and totals in Cin7 Core will look identical to Amazon, but with Cin7 Core tax rule name selected in this setting.
The Tax Free tax rule mapping specified in this setting is used to create these lines for non-taxable products. This tax mapping could be useful for accounting. It is not used for Amazon Europe marketplaces.
An Amazon Europe Marketplace doesn’t provide Tax information within the sales order data. Due to this, Cin7 Core treats all orders from Amazon Europe as tax inclusive. If the shipping destination is also in Europe, Cin7 Core will prioritize the tax rule defined for the product. If the shipping destination is not in Europe or the product tax rule is not defined, Cin7 Core will attempt to apply the tax Rule mapping for the destination country found in the setup.
In the case of tax recalculation, the Tax amount will be overwritten with a value calculated by the Cin7 Core tax rule.
Link Amazon payment methods to payment accounts
Cin7 Core can capture payments made against orders in Amazon and is able to automatically add payments to a created sales invoice. To do this, complete Payment Account Mapping on this integration settings screen. You must choose an account that is able to receive payments from the chart of accounts. We recommend not to use a bank account; instead, use a dedicated accrual account. This will make it more convenient to handle or view Amazon fees and charges.
This setting is not mandatory – if payment mapping is not completed, orders are still captured and downloaded from Amazon, but payments must be manually added to invoices in Cin7 Core. Some customers prefer to keep invoices open and then reconcile them with the biweekly payouts from Amazon.
Link chart of accounts and tax rules with Amazon transaction types
Map Amazon transaction fees to the appropriate accounts from your Cin7 Core Chart of Accounts. This is required in order to process fees from Amazon automatically when the Process Amazon Settlements Report setting is enabled. The Default Lines Tax will be auto-filled for the Tax Rule field, but this can be edited here.
Cin7 Core uses this mapping to add charges/fees/payments against sale orders and to generate manual journals, ensuring financial data between Cin7 Core, Amazon, and QuickBooks Online/Xero if applicable reconcile.
Not every transaction listed in the Amazon settlement report needs to be mapped against Cin7 Core accounting. For example, other-transaction type "Current reserve amount" is not a fee/charge that requires to be mapped against Cin7 Core accounting as it is not a charge or a fee but rather its the merchant's reserve money that gets accumulated periodically. These transaction types can be skipped by checking the Skip mapping next to that transaction type - these transaction types will be ignored by Cin7 Core.
The Master User is notified in the event of unmapped transactions, e.g. Amazon introduces a new fee.