30 Jan‘23
This article will provide a detailed guide on how to efficiently import orders from popular online marketplaces such as Amazon, Ebay, and Etsy to Shopify e-commerce platform Shopify using Salestio — a Multichannel management platform. Why it’s important? This helps merchants streamline eCommerce operations and save time and effort. Whether you’re running a small online store or a large eCommerce business, this guide will show you how to automate the process of importing orders, making your business more efficient and profitable.
Introduction
Running an eCommerce business can be challenging, especially when it comes to managing orders from multiple online marketplaces. With the rise of eCommerce platforms like Amazon, Ebay, and Etsy, more and more merchants are selling their products on multiple channels. However, this can lead to a significant increase in administrative tasks, such as tracking and managing orders from different marketplaces.
One of the biggest challenges that merchants face is having to log into multiple different platforms to check for new orders. This can be time-consuming and can lead to errors, such as missing an order or shipping to the wrong address. Additionally, merchants may also struggle to keep track of inventory levels across different marketplaces, which can lead to overselling or stockouts.
To solve these problems, many merchants are turning to eCommerce platforms that allow them to import orders from multiple marketplaces into a single platform. This feature allows merchants to easily manage and track all of their orders in one place, eliminating the need to log into multiple different platforms.
When it comes to importing orders, there are several features that merchants should look for in an eCommerce platform. For example, it should be easy to connect to different marketplaces, such as Amazon, Ebay, and Etsy. Additionally, the platform should allow merchants to import not only orders but also customer information, shipping addresses, and product details. Another important point is taxed, not only correctly collecting it but also showing it in reporting.
Another important feature is the ability to automatically update marketplace order details with fulfillment details. Using a standard flow of fulfillment orders from marketplace platforms, to make sure that marketplace orders are also included in the loop and buyers receive up-to-date information about the order state. Merchants should also look for a platform that allows them to automate the fulfillment process, such as automatically sending shipping information to the carrier.
What other benefits you can receive by importing all orders into an online store? Having all orders in a single place opens the power of custom sales reporting. Using witch merchants should be able to have a better understanding of the sales from different marketplaces, and be able to plan accordingly.
Importing orders from multiple online marketplaces into a single platform can greatly simplify the process of managing an eCommerce business. In this article, we will take a look into different e-commerce platforms supported by Salestio and the marketplaces integrated into them. We will take a look at the list of features supported for every e-commerce website and gives you detailed instruction on using it.
In this article, we will explore how to simplify the process of managing an eCommerce business by importing orders from multiple online marketplaces into a single platform. We will focus on the e-commerce platforms supported by Salestio, a SaaS that allows merchants to automate their eCommerce operations by integrating with multiple marketplaces. We will provide a comprehensive overview of the marketplaces that can be integrated with each e-commerce platform, as well as a list of the features that are supported. Additionally, we will provide detailed instructions on how to use Salestio’s platform to import orders from online marketplaces to your e-commerce store.
- Shopify and Importing orders from Amazon, Ebay, Etsy
- PrestaShop and orders from Amazon and Ebay (Coming soon)
- Bigcommerce and orders from Amazon (Coming soon)
- Shopware and importing orders from Amazon Channel (Coming soon)
- WooCommerce integration and importing Amazon orders (Coming soon)
Shopify and Importing orders from Amazon, Ebay, Etsy
Shopify is a leading e-commerce platform that allows individuals and businesses to create and manage an online store. It provides a user-friendly interface and a wide range of features and tools that make it easy for users to create and customize their own websites, manage products and orders, process payments, and more. Shopify is a cloud-based platform, which means that all data is stored on remote servers and can be accessed from anywhere with an internet connection. It also offers a variety of third-party apps and plugins, which can be easily integrated to enhance the functionality of the store. With millions of active users, Shopify is a popular choice among entrepreneurs and small businesses looking to establish an online presence.
Across all other competitors, it has a very fast tracking from registration to starting a store. It is incredibly simple and functional at the same time.
Salestio Installation and supported marketplace
For Shopify integration, Salestio is supporting the following marketplaces — Amazon, Ebay, and Etsy.
For all of the supported marketplaces, Salestio allows to download of marketplace orders and import them to the Shopify store. For the Amazon marketplace, Salestio imports only orders that should be fulfilled by merchants. Orders with Fulfilled by Amazon channel are visible in Salestio but not imported to the Shopify store.
Installation of Salestio — Shopify eBay, Amazon, and Etsy integration is possible from the Shopify app store. For every merchant that would like to try the Salestio application offered full functional 30 days trial.
Configuration for Order Importing functionality
As soon as you add your marketplace account to Salestio Shopify integration, order importing starts automatically.
Most of the settings related to order import, you can find inside the Settings page that is connected to an added account.
As an example for Amazon accounts, you have the possibility to disable order importing into the Shopify store.
The same applies also to Ebay Accounts. After you add your account, you can check your settings by choosing a corresponding account from the Settings page.
Regardless of the settings, all marketplace orders will be downloaded and shown inside Salestio > Orders page. So if you need to look into all Ebay orders, you can find it on page Salestio > Ebay > Orders.
In case importing to the Shopify option is enabled, then Salestio will try to create also Order in Shopify.
For orders that are eligible for import, but do not have a created order in Shopify, possible manually export to Shopify by clicking the button “Export to Shopify” from the order detailed view inside Salestio.
Important: Amazon AFN orders are not imported to Shopify. If such is needed please reach us at support@salest.io for activation.
After the order gets imported to the Shopify store, it includes product and price information fetched from online marketplaces. Additionally, it’s possible to see in Notes relevant information for amazon orders.
Matching Order Products to Shopify Products
In order to effectively import orders from online marketplaces into a Shopify store using Salestio, it is important to establish a clear connection between the marketplace items and the corresponding products in Shopify. This connection is made through the use of the Product Stock Keeping Unit (SKU) for each product.
When the SKU for a marketplace order is exactly matched to the product SKU in Shopify, Salestio can accurately determine the connection and create the corresponding order in the Shopify store. However, it is worth noting that not all marketplace items will have the same SKU as their corresponding Shopify products. Particularly in cases where ebay items are created by other applications, or directly by sellers on Ebay or Amazon marketplace.
If a connection between a marketplace item and a Shopify product cannot be established through the use of SKUs, an error message may appear in the order log.
In the absence of a clear correlation between marketplace products and Shopify products, it is not feasible to create a new order.
To cater to a wider range of merchants and their specific requirements, Salestio offers additional options for automatic product matching.
- Automatic matching of order products to Shopify products based on product title and selected variation
- Custom SKU mapping between Store SKUs and Marketplace SKUs (Expert)
Matching products by Title
Even though the SKU between online marketplaces (Amazon, Ebay, Etsy) is different from the product SKU inside the Shopify store, it is still possible to match order items to Shopify products if the title for products is similar in all channels.
For example, if you selling a T-Shirt with the name “Cool T-Shirt with Big Ben” on ebay with SKU: cool-big-ben, but on Shopify, this product has an SKU like “CTBB-1211” but with the exact same title. Then Salestio for orders that come for these items will do an automatic matching.
What happens if these items also have various options? Like Colour and Size?
In this case, Salestio could also correctly import order products when the names of options match exactly for names shown on the marketplace.
Please notice, for products that do not match exactly with Title or Variation options, Salestio is not possible to create a matching.
Custom SKU mapping between Store SKUs and Marketplace SKUs (Expert)
Another option offered by Salestio for expert sellers, it’s to provide a customized mapping between SKUs for store products and marketplace products.
To create a such mapping, please open the following template — View Template
Create a copy of this template, so it’s become editable for you.
Then set data from your store details.
If your store product has SKU with SKU “store-sku-1”, enter it into the first column. And marketplace SKU (for example “marketplace-sku-1”) to the second column
In case multiple amazon items are matched to a single Shopify product, you can duplicate SKUs on column “B” to match multiple marketplace SKUs to a single Shopify product.
After you finish setting a mapping, please download the result in a CSV file and send it to Salestio support at support@salest.io to apply it to your installation.
Important: This mapping will also be used for exporting products to online marketplaces and for revising qty and prices.
Tax handling for Orders imported from online marketplaces to Shopify
Another important topic for merchants is how taxes for marketplace orders are transferred to online stores with imported orders. This is a big enough topic that we will discuss further in a separate article. But let’s try to look for a general position related to taxes.
Taxes for imported orders vary depending on the marketplace and region where the order happens. In all cases, Salestio is using tax details provided by the online marketplace to correctly transfer this data to the online store.
Amazon Marketplace
Amazon Marketplace depending on the region could have taxes for orders included in the total order price or added on top of the product and shipping price.
Inside the Amazon Seller Central (for US) order view, you can see details of orders that look like the following:
- Item Subtotal — the total price of items without tax
- Shipping Total — total shipping without tax
- Tax — total tax for both items and shipping
- Order Total — that calculated as Item Subtotal + Shipping Total + Tax
When this order is imported to Salestio and Shopify, it’s shown as:
- Subtotal — total price for items including tax
- Shipping — total shipping price with taxes
- Taxes — total taxes included in subtotal and shipping
- Order Total — calculated as Subtotal + Shipping
When this order imported to Shopify it’s shown the following information
With details split by taxes between Items and Shipping
Ebay Marketplace
With Ebay marketplace taxes, Salestio works very similarly to data provided from the Amazon marketplace. The main difference here is mostly related to VAT taxes in the EU region.
Compared to Taxes in the US, VAT is always part of the final item price on the ebay marketplace. But to correctly set a VAT rate on an ebay item, Ebay required the seller to provide
- The VAT rate for items that will be included in the price
- Correctly register as VAT payment during registration on the ebay marketplace
To specify the VAT rate for an ebay item, the seller is required to provide a corresponding percentage inside Ebay Profile.
We would like to highlight one more time, that VAT percentage is always included in the final product price transferred to Ebay. So if your product does not include VAT, please consider increasing the final price by setting a proper price template.
Additional options for Shopify Order Import
Salestio — Shopify integration for ebay, Amazon, and Etsy have also few extra options that allow you to control order importing flow to stores.
Email Notification
While automatic order importation is a convenient feature of Salestio, there may be instances where the process encounters difficulties. Some common reasons for this include non-existent products in-store, unavailability of stock, and malfunction of external systems.
To ensure that no order goes unfulfilled, Salestio offers the option to send automatic email notifications in the event of a failed import. This applies to both importations of orders from marketplaces to the store and the transfer of fulfillment details from the store to the marketplace.
List of not imported orders
Also, it’s possible to see a list of orders that were not imported to the Shopify store, so it’s possible to re-import it or process it manually.
To view a list of not imported orders, please navigate to page Salestio > Ebay | Amazon > Orders and then select filter “Import Status: Not in Shopify”
Custom order number
If you need better visual separation or orders that come from an online marketplace, it’s possible to activate the option “Export order id to Shopify” which will replace the standard Shopify order ID with an order id from the marketplace together with the prefix – “A” for amazon and “E” for ebay.
Force currency for imported orders
If you are selling on multiple marketplaces, you can see orders improved to Shopify in a different currency. This is not always handy, as it broke internal store statistics and gives problems with reporting.
Salestio has the possibility to automatically convert all orders from the marketplace into a single currency. The corresponding settings are located below the “Export Order Id” setting.
Conclusion
Today we take a look at Salestio Integration for Shopify and what options it provides for importing orders from Amazon, Ebay, and Etsy marketplace.
It’s an efficient solution for e-commerce businesses looking to import orders from multiple online marketplaces into a single platform. A number of features give a wide range of support functions that allow businesses to streamline their order management process and save time, effort, and resources. Salestio is the ultimate tool for anyone looking to take their e-commerce business to the next level.
Salestio – Ebay, Amazon, and Etsy integration for Shopify could be installed directly from the Shopify app store.
Do you have any additional ideas or suggestions for options that could improve order import behavior? Please share it with us at our public roadmap – Submit your idea
In the next parts of the article, we will take a look at other e-commerce platform – Shopware, Bigcommece, PrestaShop, and WooCommerce and how Salestio import marketplace order into them.
