Amazon integration FAQs
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.
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 Cin7 Core 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 Cin7 Core with both accounts at the same time? Or do we have to purchase separate licenses for each marketplace?
A: Cin7 Core 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 Cin7 Core 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, Cin7 Core is capable of integrating with different sales channels, including Amazon, eBay and Magento. For eCommerce operators, Cin7 Core 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 Cin7 Core only tracks what we've sold, what we're owed, and what stock is remaining?
A: Cin7 Core is compatible with this basic requirement. To set this up, create a special warehouse in Cin7 Core 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 Cin7 Core to properly track inventory.
Q: I am setting up both Xero and Cin7 Core 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 Cin7 Core, I have set up all our supplier contact details and stock items. In Cin7 Core, 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 Cin7 Core?
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 Cin7 Core. You will also be able to load historical sales from Amazon. Stock will be deducted accordingly. For more information, check the Cin7 Core - Amazon Integration video.
Products and catalog
Q: Does Cin7 Core sync new Amazon product names and SKUs that it hasn't yet downloaded previously?
A: During product download, Cin7 Core automatically creates product categories and product brands for all product types in Amazon. When a sale is captured and synced to Cin7 Core, Cin7 Core will create new products (if not yet available in Cin7 Core) and update existing products. In case Amazon has two products with the same SKU, Cin7 Core 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 Cin7 Core 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 Cin7 Core. Would you know what's causing this problem?
A: To resolve this issue, go to the Amazon integration page on Cin7 Core, then set the Use Amazon as master source for Cin7 Core products option to Yes. This will pull product descriptions from Amazon to Cin7 Core and consequently update your Shopify product descriptions as well.
Q: We have an existing Amazon store integrated with Cin7 Core. We've recently opened a Shopify store as well. When we try bulk listing products sold in our Amazon store via Cin7 Core, the quality of the images uploaded to Shopify is not as good as the images in our Amazon store. Can this be because Cin7 Core 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 Cin7 Core 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 Cin7 Core products. What's wrong?
A: You should make sure to link the FBA Product to a Cin7 Core product on the Amazon integration page, not only the FBA integration page.
Q: How do we link Amazon SKUs to Cin7 Core? If the SKU code in Amazon is different from the SKU code in Cin7 Core for the same item, how do we map the item?
A: SKU is the unique identifier in Cin7 Core, which attempts to map products using this parameter. This means that it is not possible to map various SKUs to the same product in Cin7 Core.
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: Cin7 Core 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 Cin7 Core 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 Cin7 Core 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 authorized, 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 Cin7 Core, 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 Cin7 Core 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 Cin7 Core. Since Cin7 Core gets the original sale date in Amazon, not the payment authorization 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 Cin7 Core capture individual sales as they happen.
Q: We have Amazon FBA and FBM, but many of our orders cannot sync with Cin7 Core. What is wrong?
A: To ensure that your orders are properly synchronising with Cin7 Core, 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 Cin7 Core 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, Cin7 Core 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 Cin7 Core for mapping to Xero. Moreover, as far as I can see, Cin7 Core 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. Cin7 Core 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 Cin7 Core and should not be affected by the discount.
Q: How do we allocate Orders set up in Cin7 Core so that their SKUs are reflected in Xero? Is this even possible?
A: As long as the product has been synced from Cin7 Core to Xero, it will be itemised in the invoice that goes from Cin7 Core to Xero.
Q: I have three unshipped orders on Amazon, and they aren't processing on Cin7 Core 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 Cin7 Core 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 Cin7 Core - Amazon Integration video tutorial describes how to process orders in bulk from Cin7 Core. 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 Cin7 Core, 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 Cin7 Core.
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB