Find answers to common questions about Cin7 Core's Amazon integration. If you still can't find the answer you're looking for, don't hesitate to get in touch with our support team.
Table of contents
Getting started and settings
Q: What Amazon Marketplaces does Core support?
A: Cin7 Core supports the following Marketplaces: USA, Canada, Mexico, UK, Germany, Spain, France, Italy, UAE, Netherlands, Sweden, Australia, Belgium, Poland, Japan, India. Our developers are constantly working to improve the integration level.
Q: I do not have an Amazon Pro account, and it's not as easy as just asking them for an upgrade – I've already asked, and they still don't have the ability. I would have to recreate all my listings, and that would be a crazy amount of work. Can I not use DEAR if I just have a regular Amazon account?
A: Unfortunately, the API interface is only available for Amazon Pro accounts. We cannot communicate with individual accounts and pull sales if the API is not available.
Q: We sell on both Amazon US and Amazon EU. Can we use DEAR with both accounts at the same time? Or do we have to purchase separate licenses for each marketplace?
A: DEAR allows multiple Amazon stores to be set up from the Settings>Integration>Amazon page, as long as you have the necessary licenses for them. You may need to add additional external integrations to your subscription if you do not have enough available.
Q: We are currently looking into a new order/inventory management system. We have three (3) Amazon stores and two (2) eBay stores. Can DEAR handle this channel mix?
A: Yes, we support an unlimited number of Amazon and eBay stores, so long as you have the necessary licenses for them. You may need to purchase additional licenses to add to your subscription.
Q: Do you integrate Amazon, eBay, and Magento sales invoices?
A: Yes, DEAR is capable of integrating with different sales channels, including Amazon, eBay and Magento. For eCommerce operators, DEAR offers order aggregation, catalogue management, bulk publishing and a lot more.
Q: Can Amazon FBA integration be set up in such a way that FBA stores all our stock and takes and fulfils orders, while DEAR only tracks what we've sold, what we're owed, and what stock is remaining?
A: DEAR is compatible with this basic requirement. To set this up, create a special warehouse in DEAR that will hold the stock that you send to Amazon FBA. Then, under the Amazon Integration page, set Location for Amazon fulfilled orders to Do not process Amazon fulfilled orders, allowing the 3PL integration to ignore sales in this location. In addition, when sending the additional stock to the FBA location, you can perform a stock transfer to that location, allowing DEAR to properly track inventory.
Q: I am setting up both Xero and DEAR from scratch from the beginning of the NZ financial year (April 1). I have loaded into Xero the opening Trial balances (note we had zero inventory). In regard to inventory in DEAR, I have set up all our supplier contact details and stock items. In DEAR, is it best to bring the accounts up to the current date, enter all the inventory purchases, and ignore any sales from inventory? Then, once all inventory is entered to link up to Amazon starting from April 1, all sales will then be reported from that date and stock will be deducted accordingly in DEAR?
A: Generally, you need to load initial balance effective as of a given date, and all purchases and sales after this date must be imported/entered as purchase orders and sales invoices in DEAR. You will also be able to load historical sales from Amazon. Stock will be deducted accordingly. For more information, check the DEAR - Amazon Integration video.
Products and catalog
Q: Does DEAR sync new Amazon product names and SKUs that it hasn't yet downloaded previously?
A: During product download, DEAR automatically creates product categories and product brands for all product types in Amazon. When a sale is captured and synced to DEAR, DEAR will create new products (if not yet available in DEAR) and update existing products. In case Amazon has two products with the same SKU, DEAR will update one and ignore the second. Thus, it is recommended to have unique SKUs for your products.
Q: I cannot figure out how to load products onto Amazon using the new Amazon integration. How do I do that?
A: Product listing from DEAR is not available. Products can be loaded from Amazon, but cannot be published to Amazon. We are looking into options to create a separate module which will allow product publishing to Amazon.
Q: My Amazon product descriptions are not getting pulled into my Shopify store. When I checked, it seems that the product descriptions from Amazon are also not getting synced to DEAR. Would you know what's causing this problem?
A: To resolve this issue, go to the Amazon integration page on DEAR, then set the Use Amazon as master source for DEAR products option to Yes. This will pull product descriptions from Amazon to DEAR and consequently update your Shopify product descriptions as well.
Q: We have an existing Amazon store integrated with DEAR. We've recently opened a Shopify store as well. When we try bulk listing products sold in our Amazon store via DEAR, the quality of the images uploaded to Shopify is not as good as the images in our Amazon store. Can this be because DEAR lowered the quality of the images when it downloaded our products from Amazon?
A: The Amazon API doesn't allow extraction of the original images, only thumbnail-sized images. Amazon imposes this limitation to protect your content. Unfortunately, there is no way around this except to manually upload the same images used in your Amazon store to Shopify.
Q: I tried linking Fulfilment by Amazon (FBA) products with actual DEAR products on the FBA integration page. Unfortunately, the product mapping does not seem to be working – it is only mapping to randomly created Amazon products containing FBA suffixes, not the actual DEAR products. What's wrong?
A: You should make sure to link the FBA Product to a DEAR product on the Amazon integration page, not only the FBA integration page.
Q: How do we link Amazon SKUs to DEAR? If the SKU code in Amazon is different from the SKU code in DEAR for the same item, how do we map the item?
A: SKU is the unique identifier in DEAR, which attempts to map products using this parameter. This means that it is not possible to map various SKUs to the same product in DEAR.
Q: How do I combine products, so inventory is kept in sync? I sell on Etsy, Amazon, eBay, Magento and Shopify. On some of these channels, the SKU is different. For example, Etsy always creates its own SKU, and I can't change it through Etsy. How do I combine this item with the same item with a different SKU in Magento?
A: DEAR treats the SKU as a unique identifier. Ideally, SKUs should be the same across all of your sales channels and the system automatically attempts to match products based on the SKU and description. However, you can match products manually for Amazon in the Catalogue tab.
Q: We have our stock in the DEAR main warehouse. For example, SKU1 = 12 x PWR+ Drinks. On Amazon, we sell the stock in packs of 5 (SKU5) and 12 (SKU12). I've set up Amazon as a warehouse in DEAR so that Amazon sales are picked only from the Amazon warehouse. How do I map my SKU1 stored in our main warehouse to SKU5 and SKU12 in the Amazon warehouse? I guess I can do a stock transfer from the main warehouse to the Amazon warehouse, but SKU1 does not match SKU5 and SKU12, which I need to have in the Amazon warehouse to match the Amazon sales. What should I do in this regard?
A: You need to transfer SKU1 from the main warehouse to the Amazon warehouse. If SKU5 is a pack of 5 SKU1, then you can set SKU5 as an auto-assembled product with 5 units of SKU1 in the bill of materials. Then, once the sale order for SKU5 is authorised, SKU5 will be assembled automatically. Another way to do this is to set up SKU5 as an additional unit of measure for SKU1, with 5 SKU1.
Q: If a single product is called SKU1 in DEAR, but in Amazon, the same product is set up as SkuA, how can I match the sale of skuA in Amazon to the stock in DEAR warehouse called sku1?
A: Core will attempt to map Amazon products to Core products automatically using SKU and name, however you can manually map products from the Catalog tab in Cin7 Core. There is a column for manually linking and unlinking Cin7 Core and Amazon products.
Orders and sales
Q: I am trying to load consolidated orders from Amazon, which will eventually sync with Xero, but it's not consolidating orders the way it does in the Amazon settlement report. Why is this happening?
A: You will never be able to load all your Amazon sales on the same day because sales can stay as pending (not ready for fulfilment and with unconfirmed payment) in Amazon for up to two weeks before they become available for loading into DEAR. Since DEAR gets the original sale date in Amazon, not the payment authorisation date, it effectively loads sales with payments captured today but with the actual sales order date falling any time during the last two weeks. To resolve your problem, instead of consolidating individual sales on a daily basis, set your Amazon integration to No Consolidation to let DEAR capture individual sales as they happen.
Q: We have Amazon FBA and FBM, but many of our orders cannot sync with DEAR. What is wrong?
A: To ensure that your orders are properly synchronising with DEAR, ensure that you have turned on the Order Settings under Settings>Reference Books>Order Routing. For more information, see Order Routing for eCommerce Platform Integration.
Q: I have orders on Amazon FBA that are showing their status as Failed. A check of the logs shows the following error: "Processing fulfilment request finished with status: Failed. Message: The request must contain the parameter CountryCode."
A: This is probably due to an issue with the shipping address. Make sure that the name of the country in the shipping address is in English since DEAR cannot translate non-English country names into the required ISO country code in FBA.
Q: It seems I could not see an Amazon order. I tried to re-download the order, and it does not seem to work.
A: Make sure that you have selected a Customer on the Integration>Amazon>Setup page. This customer is used in case you need to consolidate orders for the day. This might require creating a generic customer first.
Q: If the channel does not send down the currency code with an order, would it be auto-registered as the base currency? I am selling on Amazon.com and Amazon.ca, and I do not believe they send down a currency code. This means that an Amazon.com order might come in as a CAD order even though it is paid for in USD.
A: Amazon sends the currency code together with the order. In the event that Amazon does not send the currency code, DEAR uses the base currency for the order.
Q: How do the Default Line Tax, Default Additional Charges Tax, and Shipping Tax affect an order? If the channel is already set up with tax, how would the tax be mapped to XERO? I am in Canada, and we have GST (federal tax) and PST (provincial tax), so an order might have two (2) different tax components from WooCommerce. I have set up WooCommerce to calculate the proper tax for each component, but I do not see the tax codes in DEAR for mapping to Xero. Moreover, as far as I can see, DEAR only has three (3) tax types.
A: The Default Lines tax is used for order lines while the Additional Charges Tax is used for Shipping and other charges. DEAR uses these tax rules when there are no other tax rules from the mapping that matches the received order. However, regardless of the selected tax rule, the tax value of the order will be preserved, just like in WooCommerce.
Q: How do I record samples of stock in the Sales Order process other than as a zero amount sale, as my client does not want this to skew the gross margin on those items?
A: The only way to provide samples is to create a 100% discount for the item. Margin is calculated based on the Average Cost in DEAR and should not be affected by the discount.
Q: How do we allocate Orders set up in DEAR so that their SKUs are reflected in Xero? Is this even possible?
A: As long as the product has been synced from DEAR to Xero, it will be itemised in the invoice that goes from DEAR to Xero.
Q: I have three unshipped orders on Amazon, and they aren't processing on DEAR for some reason. I tried to manually process each order, but nothing happens. I also tried loading products and orders from the correct dates, but these are not showing up. The orders remain sitting in Unshipped status on Amazon, although they are ready for processing. What is wrong?
A: Manually delete the pending entries from the Amazon integration log and try manually loading the orders. The most likely cause of this error is that there is a product mapping issue preventing DEAR from properly capturing these orders. You can see what exactly the issue with these orders is when you download them manually.
Q: Do you have any videos or articles on how to process sales orders in bulk that come in from eBay and Amazon?
A: The DEAR - Amazon Integration video tutorial describes how to process orders in bulk from DEAR. The video shows how you can either consolidate orders that are captured for the day or automate the fulfilment process of pick, pack, and ship.
Q: When integrating with Amazon, in regard to the sales information brought back into DEAR, do the numerous Amazon charges incurred get split up and reported individually daily, or are they consolidated daily?
A: We load all sales individually and, depending on your Amazon integration setup, either create individual orders or one consolidated order for the day in DEAR.