Here’s what you need to know about how the integration works between TradeGecko and Magento.
Magento Order Sync
TradeGecko checks Magento for new Orders every 10 minutes. When a Magento order is imported into TradeGecko,
1An order with line item(s) will be created.
2You will have the option to create a Shipment.
3Tax treatment for an order is ALWAYS indicated as 'inclusive'.
4A new company is created using the contact details from that order.
5Billing and Shipping addresses are created under the company.
- Please note historical orders (created prior to integration) can not be imported into TradeGecko.
- If the Billing and Shipping addresses are the same, only 1 address will be created.
- The location you assign to the order will be where your stock levels will be subtracted from when the order is fulfilled.
Go to Apps> Magento> 'Settings'.
This location is determined by what you’ve set up in your TradeGecko main app settings. It could either be a specific location or All Locations.
Existing orders are also updated every 10 minutes based on the changes made in Magento.
Which changes will be updated during the order sync❓
IInvoices are imported and payment will be created on TradeGecko. However, this will only be updated if the Magento Order is fully invoiced.
IIFulfillments will be created on TradeGecko if the Magento Order is fully shipped.
IIIIf an order was canceled on Magento, it will be made void on TradeGecko.
When will an order fail to sync from Magento to TradeGecko❓
IOrders, where the Variants are not marked as 'Sellable', will not be imported.
IIIf the currency used in Magento when creating the order is not set up on your TradeGecko account, the order will not be imported into TradeGecko. We check if the currency exists by matching the ISO ( i.e., 'USD', 'SGD').
For example 👇🏽
Let's say you receive an order on Magento in Japanese Yen (¥). However, you have not set up Japanese Yen (¥) as a currency in TradeGecko.
Therefore, the Order you received in ¥ from Magento will NOT be created on TradeGecko.
IIIIf the Order created on Magento contains products or variants that are not in your inventory on TradeGecko, your order will NOT be imported.
For example 👇🏽
Let's say you received an order for five frisbees. However, frisbees do not exist as products/variants in your inventory on TradeGecko.
In this case, your Order for five frisbees will NOT be imported from Magento into TradeGecko.
TradeGecko always checks the Product ID from Magento against those variants that were published to Magento from TradeGecko first. If no matches are found, TradeGecko then tries to match the item’s SKU to a variant in your inventory. If a match is still not found, the Order will NOT be imported.
When the Status of order on Magento reflects as 'Canceled', it will be created in TradeGecko as either a 'Deleted' or 'Void' order.
If the Order on Magento has an invoice attached to it, an invoice and payment will automatically be created in TradeGecko. Shipping line items will also be included on both invoices and payments.
Order
|
Magento Order |
syncs as |
TradeGecko Order |
|
customer_email |
⇒ |
|
|
created_at |
⇒ |
issued_at |
|
customer_note |
⇒ |
notes |
|
increment_id |
⇒ |
order_number |
Company
|
In Magento |
syncs as |
In TradeGecko |
|
first_name + last_name |
⇒ |
name |
|
note |
⇒ |
description |
|
|
⇒ |
|
|
phone_number |
⇒ |
phone_number |
|
fax |
⇒ |
fax |
|
company_type (default: 'consumer') |
Shipping/Billing Address
|
In Magento |
syncs as |
TradeGecko Order |
|
company |
⇒ |
company name |
|
first_name & last_name |
⇒ |
address1 |
|
street |
⇒ |
address2 |
|
city |
⇒ |
city |
|
region |
⇒ |
state |
|
country id |
⇒ |
country |
|
postcode |
⇒ |
zip code |
|
telephone |
⇒ |
phone number |
|
|
⇒ |
|
Magento Inventory Sync
New products created in Magento are not imported into TradeGecko after the initial integration.
What happens when I publish a TradeGecko variant to a Magento channel❓
- A new product will be created in Magento.
- All Magento products created by TradeGecko will always be set as a “Simple Product” type.
- Products created by TradeGecko in Magento will always be set to status “1” which means it is “enabled in-store”.
- Products created by TradeGecko in Magento will always be set to visibility “3” which means they are searchable but are not in the catalog.
- Products will not be created in Magento if the TradeGecko product does not have any SKU OR if the SKU already exists in Magento.
- A Product will not be created in Magento if no price is assigned to the TradeGecko variant.
Depending on the Price List selected in your main app settings, TradeGecko variants will not be published to Magento if 'Retail (USD)' price on the variant does not have any value.
This means that the Price fields that you see in the screenshot below need to be filled in, in order for the variant to be published on Magento.
