Here’s what you need to know about how the integration between TradeGecko and Magento works.
Magento Order Sync
TradeGecko checks Magento for new Orders every 10 minutes.
When a Magento order is imported into TradeGecko:
- An order with line item will be created.
- You will have the option to create a Shipment.
- Tax treatment for order is ALWAYS “inclusive”.
- A new company is created using the contact details from that order.
- Billing and Shipping addresses are created under the company.
- A location is assigned to the order. This location is where your stock levels will be subtracted from when the order is fulfilled.
Apps> Magento> Settings
This location is determined by what you’ve have 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 changes made on Magento. The changes that will be updated are as follow:
1. Invoices are imported and payment will be created on TradeGecko. However this will only be updated if the Magento Order is fully invoiced.
2.Fulfillments will be created on TradeGecko if the Magento Order is fully shipped.
3.If an order was canceled on Magento, it will be made void on TradeGecko.
When will an order fail to sync from Magento to TradeGecko?
1. Currency: If the currency used in the order created in Magento 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 (“USD”, “SGD”).
Example
You receive an order on Magento in Japanese Yen (¥).
You have not set up Japanese Yen as a currency in TradeGecko.
Therefore, the Order in Yen from Magento will NOT be created on TradeGecko.
2. Product or Variant does not exist on TradeGecko: If the Order created on Magento contains products or variants that are not in your inventory on TradeGecko your order will not be imported.
Example
You receive an order for 5 frisbees.
Frisbees do not exist in your inventory on TradeGecko
Your Order will NOT be imported from Magento into TradeGecko.
When the Status of an order on Magento reflects as “Canceled” it will be created in TradeGecko as either “Deleted” or “Void” order.
If the Order on Magento has an invoice attached to it, an invoice and a payment will automatically be created in TradeGecko. Shipping line items will also be included on both invoice and payment.
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 “Simple Product” type.
- Products created by TradeGecko in Magento will always be set to status “1” which means the 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.
