Amazon integration
Amazon is the world’s best-known online marketplace, reaching millions of customers worldwide. Amazon eCommerce integration can be used in a variety of ways. Orders can be captured and fulfilled by Amazon while using the integration with Cin7 Core to track your inventory levels, or orders captured by Amazon can be fulfilled by you, the merchant. It is not currently possible to list items from your catalog in Core to Amazon.
If you primarily work with Fulfillment by Amazon, you can add the Fulfillment by Amazon integration. Cin7 Core FBA integration allows your external warehouse/fulfillment center to be created as a separate location in Cin7 Core as well as allow sales order details to be communicated to your external fulfillment center. It also has the ability to synchronize inventory quantities once orders are fulfilled and receive shipping/tracking information from the fulfillment service. You will still require the Amazon integration if you purchase the Fulfillment by Amazon integration.
Prerequisites
An Amazon Seller Pro account (required)
Familiarity with sales (required)
Users will need the Integration: eCommerce - Amazon permission in order to use this feature.
Important information
Cin7 Core supports the following Marketplaces: USA, Canada, Mexico, UK, Germany, Spain, France, Italy, UAE, Netherlands, Sweden, Australia, Belgium, Poland, Japan, India, Singapore, and South Africa.
Benefits of the integration
Stock levels automatically update from Cin7 Core to Amazon.
Inventory costs and movements are synced to your accounting application.
Centralized inventory management for all channels.
Sales orders, product details, customer contacts and payments are downloaded from Amazon to Cin7 Core. Item quantities are uploaded to Amazon, keeping track of inventory.
Once the integration has been established, Cin7 Core will download products from Amazon, each sales order from Amazon will be captured and sent to Pending Sales in Cin7 Core and have stock allocated. They will then be processed into actual sales orders, either individually or once a day, depending on your sales order consolidation settings. Stock level changes are then pushed from Cin7 Core to Amazon (or other connected sales channels) if this optional setting has been enabled. Payments are automatically applied to orders captured from Amazon.
Not supported
Initial import of products from Amazon does not import stock quantities.
Amazon integration setup
First, you must connect Cin7 Core to your Amazon eCommerce store which requires a Seller Pro account. You will need to purchase this integration from the My Subscription page (if not already part of your subscription).
You can link several Amazon stores to a single Cin7 Core account. Each linked store has an independent catalog, logs and settings.
Connect Amazon to Cin7 Core:
Navigate to Integration → Amazon.
Click + to connect a new store.
Follow the Before you start instructions and then fill in the fields shown. The Shop Representative Name will be filled in with a default value but can be edited here if required.
Click Connect to Amazon.
-
Repeat these steps to connect further Amazon stores.
Amazon stores are counted as external integrations for your Cin7 Core account. If you would like to add more external integrations to your Cin7 Core account, you can do so from the My Subscription page.
IMPORTANT! Cin7 Core will make an inventory report request to Amazon every hour. The default setting is to send an email notification whenever an inventory report is requested. If you get an Amazon Inventory report is not found or outdated error while downloading the report, retrying the operation after a minute usually eliminates the error and leads to the successful generation of the report.
To avoid getting spammed with Amazon notifications, you may go to Seller Central → Settings → Notification Preferences and disable Open Listings Report.
Integration settings
Under the Setup tab, several integration settings can be customized.
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
This is the option to choose automatic mapping by SKU or manual mapping by the user. When automatic mapping is selected, an existing product will be searched for automatically by SKU, and if a product is found with a matching SKU, then the mapping is done automatically. When manual mapping is selected, the user will have to manually select which Cin7 Core products to link to via the Catalog tab. Manual mapping can still be performed even if automatic mapping is enabled.
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.
Tax rule mapping
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.
IMPORTANT! Orders will be skipped on download if tax mapping is not finished.
Payment account mapping
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/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 accounts in Cin7 Core to Amazon transaction fees
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.
Disconnect from the Amazon store
When you disconnect from the Amazon store, Cin7 Core removes all associations between Cin7 Core objects and Amazon, including Log and Product Catalog.
Carrier mappings
Amazon requires the carrier name upon shipment confirmation via bulk feeds, APIs, or integrators for seller-fulfilled orders. Some of the commonly used carrier names are USPS, UPS, and FedEx. From May 3, 2021, Amazon will validate tracking details (including carrier name and tracking ID) for ALL seller-fulfilled orders, and show warnings for invalid tracking details.
Cin7 Core will automatically send the sale order carrier to Amazon after fulfillment is authorized in Cin7 Core. Tracking numbers are also passed to Amazon when they are available.
Carrier names in Cin7 Core must be mapped to available carriers in Amazon so shipment tracking information can be correctly exported and meet these requirements. The list of carriers is loaded automatically from Amazon.
Go to Integrations → Amazon → [select store] → Carrier Mapping.
If multiple Amazon channels have been integrated with Cin7 Core, the user can select Copy mappings from... and select their marketplace to load carrier mappings from another configured Amazon channel. The copied mappings can be edited before saving.
Map carriers in Cin7 Core to carriers in Amazon. If a carrier exists in Cin7 Core that does not exist in Amazon, select Other. The Cin7 Core carrier name will be passed to Amazon.
Catalog
Downloading products
Products can be loaded from Amazon to Cin7 Core in the Catalog tab by clicking Load Products.
There are two types of products in Amazon: a simple product and a complex product (a product with options/variations such as, for example, the same product in different colors and sizes).
Each complex product can have many options in Amazon, but Cin7 Core can only support up to 3. Due to this constraint, Cin7 Core uses only the first 3 options from the Amazon product. These complex and simple Amazon products map perfectly to Cin7 Core Product Families and Cin7 Core Products. When downloading products from Amazon, Cin7 Core checks if the Amazon product is simple (without options) or complex (with options).
If a product has options in Amazon, Cin7 Core creates a product family with all the variants of that product created as separate products in Cin7 Core belonging to that family. If a product family and its products are already created/linked with Amazon, then Cin7 Core updates the existing family/products instead of creating new versions.
When a product is created or updated in Cin7 Core during the download process, a link is established between the product and variant unique Amazon ID and Cin7 Core unique product ID. This link is used when products are matched against sales order lines in Amazon and when subsequent product downloads occur.
Amazon maintains a hierarchical structure of categories while Cin7 Core categories are all treated at the same level. Only the first (top-level) category of an Amazon product is linked to Cin7 Core.
When downloading products, Cin7 Core first tries to match existing products to avoid creating duplicates. This search is done in several steps:
First, Cin7 Core attempts to search for a product family by name using the Amazon product title.
Then, for each variant, Cin7 Core searches for a Cin7 Core product using the Amazon variant ID.
If not found, Cin7 Core then searches for a Cin7 Core product by Amazon product (or variant) SKU.
Cin7 Core products must have unique names, while all Amazon variation names also differ. Variation name consists of family name + “(Option1Value, Option2Value, ...)".
During product download, Cin7 Core automatically creates product categories and product brands for all product types in Amazon.
If a product price in the Catalog is important for the user, they MUST use a different Price tier for each Amazon marketplace; otherwise, the price will be overwritten with the last price in the marketplace currency.
Data mapping for products between Cin7 Core and Amazon is as follows:
Cin7 Core |
Amazon |
SKU |
SellerSKU if defined, otherwise ASIN or ISBN (for books) is used instead |
Name |
Product Title |
Category |
First category from a hierarchy |
Description |
Product Description |
Weight |
Weight (converted to KG) |
Width |
Width |
Height |
Height |
Length |
Length |
Barcode |
UPC / EAN |
Price Tier (default is Price Tier 1) |
Price |
Images |
Small product image |
Quantity |
Quantity |
Sale tax rule |
'Default Tax Lines' tax mapping for products (use the specified tax rule; if no tax rule specified, use the 'Tax Free' tax mapping rule). 'Default Additional ChargesTax Lines' tax mapping for additional services (like shipping, wrapping, etc.). |
Option 1 Name |
Title of the required option (required for product category) |
Option 2 Name |
Title of the required option (required for product category) |
Option 3 Name |
Title of the required option (required for product category) |
Option 1 Value (for variation) |
Value for Option 1 |
Option 2 Value (for variation) |
Value for Option 2 |
Option 3 Value (for variation) |
Value for Option 3 |
Managing the catalog
There are three possible statuses for products in the Catalog: Not Listed, Listed and Cancelled. The Canceled status appears for products that were removed from Amazon. By default, they are not visible in the catalog unless the Show only active checkbox is disabled.
There is also an option that allows you to switch the appearance of the catalog to Show variations separately. If checked off, all products without variations are displayed, and each product variation is shown as a separate product line. If this function is not enabled, products without variations are displayed as usual, and product families are displayed as a single product line.
In addition to downloading products from Amazon and performing automatic product mapping, you can choose to manage your Amazon catalog from Cin7 Core. There is a column for manually linking and unlinking Cin7 Core and Amazon products. This is useful when the correct product has not been found, or when a link between the Cin7 Core and Amazon product has been broken due to Amazon ASIN merge operations.
Cin7 Core supports Amazon’s 'global SKU' feature: when a product listed in several marketplaces within a region (All marketplaces in Europe, for example) is linked to one Cin7 Core product, the total quantity of the Cin7 Core product will be used for all marketplace listings. This shared product can have a different name (alias) in each marketplace while still being linked to a single Cin7 Core product. If an alias name is used, the Catalog Tab will show the alias name instead of the actual product name.
There are three linking options:
Leave blank (do not tie to a product in Cin7 Core)
Link to an existing product
Create a new product in Cin7 Core (available if the product with the required SKU does not exist).
Product mapping must be completed in order for sales to be successfully downloaded from your sales channels to Cin7 Core. When sales are loaded from a sales channel, and a sale contains a product that is not mapped to any product in Cin7 Core, then this sale will not be downloaded.
The user will be notified if a sale is skipped through internal messages such as notifications, recordings in the operations log, or a text message on the screen (depending on the situation).
Catalog modifications in Amazon
Consider a catalog that contains 3 products: A, B, C. Product C has been modified in the sales channel. Next time the catalog download is triggered, the products A, B, D will be visible with the following statuses:
Products A and B (the unchanged products) will remain in the catalog with a Listed status. Product D will now appear in the catalog with a Listed status, but product C’s status will change to Canceled.
Orders and sales
Processing pending orders
Whenever a sale is created in Amazon, it is first placed in Pending Orders, and stock is allocated immediately. Cin7 Core checks every hour if there are any new orders and imports them immediately as individual sales orders or once a day as a consolidated sales order (Daily Consolidationenabled).
By default, each Amazon sale is converted into an identical sale in Cin7 Core, keeping the same customer, shipping and billing information.
If you enable daily consolidation, the consolidated order will use the customer selected in the integration settings. Cin7 Core will ignore any customer, billing and shipping information from Amazon.
When processing orders, the logic is identical to that of the Cin7 Core UI. Dropshipping, Kitting and other important scenarios are implemented in the same way as the Cin7 Core UI.
Pending Orders can be processed manually by clicking Process. They can then be viewed in the Log tab.
Order field mapping
No Consolidation - Online Sale
Cin7 Core Sale Order header fields |
Will have Amazon value: |
Customer and Customer Details (Contact, Phone, Email) |
If Use Company as a Customer is disabled:
If Company name (optional) as a Customer is enabled:
|
Reference |
Amazon Sale Order #. |
Billing Address |
|
Price Tier |
Sale Price Tier specified in Amazon Integration Settings. |
Terms |
Default payment terms (Settings → Reference Books → Payment Terms). |
Sales Rep |
|
Account |
|
Tax Rule |
Will be set according to Tax Rule Mapping in Amazon settings. |
Invoice # |
Generated automatically by Cin7 Core. |
Invoice Date |
Sale order capture date. |
Due Date |
Calculated from Invoice Date + Payment Term |
Location |
|
Date |
Sale order capture date. |
Shipping Address |
|
Ship to Company |
Company name from Amazon if provided. |
Ship to Contact |
Customer contact name from Amazon if provided. |
Shipping Notes |
Amazon notes. |
Comments |
Amazon notes. |
Required By |
Same as sale order capture date. |
Carrier/Service |
|
Daily Consolidation - Online Sale
Cin7 Core Sale Order header fields |
Will have value: |
Customer and Customer Details (Contact, Phone, Email) |
Default customer in Amazon Settings will be used. |
Reference |
Reference added with the date on which the sales were consolidated. Ex: Amazon Sales for 28/05/2020 |
Billing Address |
Billing address for the default customer will be used. |
Price Tier |
Sale Price Tier specified in Amazon Settings |
Terms |
Default payment terms (Settings → Reference Books → Payment Terms) |
Sales Rep |
|
Account |
|
Tax Rule |
Will be set according to Tax Rule Mapping in Amazon settings. |
Invoice # |
Generated automatically by Cin7 Core. |
Invoice Date |
Sale order capture date. |
Due Date |
Calculated from Invoice Date + Payment Term |
Location |
|
Date |
Sale order capture date. |
Shipping Address |
Shipping address for the default customer will be used. |
Ship to Company |
Default customer in Amazon Settings will be used. |
Ship to Contact |
Default customer in Amazon Settings will be used. |
Shipping Notes |
Amazon notes |
Comments |
Amazon notes |
Required By |
Same as sale order capture date. |
Carrier/Service |
Amazon carrier information will be used. If no Amazon carrier information is provided, Free Shipping will be used. |
Downloading Orders and Payments
Orders are automatically downloaded every hour when an order is paid, modified or changed in Amazon.
Pending or Pending Available order statuses won’t be processed. Generally, you do not need to trigger manual order download. However, if an order was not captured by Cin7 Core or to load historical sales, you can use the manual Load Order option. Cin7 Core allows loading historical sales data a maximum of one year old.
Any imported order is saved to the Pending Orders section. It is a temporary storage of all sales and payments in Cin7 Core. Only orders matching the selected capture option are accepted: with status paid/unshipped/shipped. You can change the capture option in the Load from Amazon setting.
If an order already has an entry in the Log, i.e. it has been imported previously, it will be skipped. This guarantees that no duplicate sales will be created by Cin7 Core.
While saving orders, Cin7 Core captures customer information such as the shipping address. Unfortunately, upon order download, it is impossible to obtain the billing address details, except for the billing name (the person who paid for the order). All line items are captured together with quantities, prices and totals. Total order discounts are applied as additional charges to the whole order, without distribution by lines to reduce any chances of discrepancy.
Shipping, gift wrapping and discounts are also saved as additional charges in the sales invoice. Amazon has special Tax Rules for these additional charges, and you can map these tax rules to those in Cin7 Core under the Setup tab.
For each line in a sales order, Cin7 Core will try to locate the corresponding product by SKU. If no product is found, Cin7 Core tries to download the product information from Amazon using the same logic as in the Download Products function described above. If the product information is not found (if removed from the Amazon store, for example), Cin7 Core marks this line as a Service (Non-product). Next, the sale line is saved to pending orders with all the data imported from Amazon: Tax, Quantity and Total.
If a Payment Account has been specified in the Integration Settings, Cin7 Core will always assign associated payments to the captured orders (whether the order has already been processed or is still pending) when the Amazon Order is paid.
When an Amazon order is canceled, Cin7 Core automatically finds and voids the corresponding sales task if already created as a sales order or just removes the associated pending order if not yet processed.
The final step in the order download is to trigger an update of stock levels in the other Amazon stores and the other connected eCommerce channels.
Updating Fulfillment in Amazon
When Shipment is authorized in Cin7 Core and the carrier specified, Cin7 Core will try to create order shipment information in Amazon. This will only work in the No Consolidation processing mode.
Logs
Each captured Amazon order once saved to Pending Orders creates a Log entry to track the link between the Sale in Cin7 Core and in Amazon. This eliminates the possibility of creating duplicate orders when capturing the same order several times during manual order load.
Each Log entry has a link to the sales task in Cin7 Core. Depending on the settings selected by the user in the Setup tab, this sales task could be draft or authorized, one or more of the Pick, Pack and Ship tabs could be authorized, and payment could have been applied to the invoice.
Log entries allow you to see which sales task reflects a particular Amazon sale. You also have the option to delete a Log entry manually. This will allow Cin7 Core to reprocess an order if required. Deleting a log entry will not void or delete its associated sales task.
Reloading Orders from Amazon
If for any reason you need to reload an order from Amazon, this can be managed from Cin7 Core.
To reload an order from Amazon:
Void the sales task. A record of this will be kept in Cin7 Core for reconciliation purposes, but the transactional data will be deleted.
Return to the Amazon integration Log tab and delete the Log entry. This will allow the order to be recaptured from Amazon.
Navigate to the Pending Orders tab and click Load Orders, making sure to set the date before the order to reload was made. Cin7 Core allows loading historical sales data a maximum of one year old.
Refunds and Returns
Cin7 Core Amazon integration supports refunds and returns. When returning an item, customers can choose their preferred refund method in Amazon. Cin7 Core will capture and process a refund regardless of the refund method.
Cin7 Core will process the captured refunds automatically every hour, but users can manually load and process refunds and credit notes via the Pending Orders tab. Only refunds that are Completed from Amazon will be captured and loaded to Cin7 Core. Pending or Declined refunds will not be loaded or processed to Cin7 Core.
Note: Cin7 Core will process returns and refunds when the Invoice status is authorized and order is processed. Returns and refunds for unfulfilled sales will be stored in the Pending Orders tab until the sale has been fulfilled. Cin7 Core supports processing both Amazon fulfilled and Merchant fulfilled sale refunds.
When a refund or a return is captured from Amazon, Cin7 Core will create and authorize a credit note and refund equivalent to credit note total for the relevant sale order in Cin7 Core. Amazon has different fees applied on refunds depending on product and location (for more information, go to Amazon - About Our Returns Policies). Any of these fees will be captured by Cin7 Core as an additional charge. There will be no restocking done for Amazon returns during processing the returns and refunds to Cin7 Core.
When processing refunds for historical sale orders on Amazon integration, Cin7 Core would load the sale order together with the refund and credit note from Amazon. If the sale pre-dates the date when Cin7 Core was integrated with your Amazon store, a stand-alone credit note will be processed, while the original order will not be altered or synced.
We do not recommend using the Cin7 Core RMA and Returns feature for Amazon sales, for capturing all of the relevant charges and fees it is more user-friendly to process returns via Amazon for Amazon sales.
Amazon Settlement Fees and Charges
Amazon generates sales invoices as the customer would see them, without fees. The fees (Commission Fee, FBA Fee, etc.) are then subtracted. Approximately every two weeks, Amazon will deposit the sales money, minus charges for Amazon fees, in the seller’s Amazon account directly into the seller’s bank account.
Amazon generates a report (Amazon Settlements Report) detailing these fees at approximately two-week intervals. The fees can then be processed manually by the user or automatically by Cin7 Core. You will need to enable the Process Amazon Settlements Report setting for Cin7 Core to automatically capture and process data from the settlement report.
You can review transactions from the settlements report from the Amazon Settlement Files tab.
See Handling Amazon Settlement Fees and Charges for detailed instructions.
Operations Log
Each time the user or Cin7 Core downloads sales, the appropriate record is added to the operations log, which also contains information about results of downloading, including the count of processed, skipped or canceled orders.