TradeGecko’s Knowledge Center is getting a makeover! Please use the search function to find a support article.

Status:
Contact supportus

Articles in this section

Articles in this section

Magento- Integration Sync Guide

Neeta Nelson
  • Updated
Note
TradeGecko currently only supports Magento version 1.9.x.

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:

  1. An order with line item will be created.
  2. You will have the option to create a Shipment.
  3. Tax treatment for order is ALWAYS “inclusive”.
  4. A new company is created using the contact details from that order.
  5. Billing and Shipping addresses are created under the company.
Note
If the Billing and Shipping addresses are the same, only 1 address will be created.
  1. 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.

Note
If you select all locations, the account’s Primary Location will be assigned as the order location.

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.

Note
TradeGecko first checks the product ID from Magento against those variants that were published to Magento from TradeGecko. If no matches are found TradeGecko then tries to match the item’s SKU to a variant in your inventory. If no match is found once again, the Order will not be imported.

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.

Note
The Magento integration does not create fulfilments on TradeGecko.

Order

Magento Order

syncs as

TradeGecko Order

customer_email

    ⇒

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

email

    ⇒

email

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

email

     ⇒

email

Magento Inventory Sync

  1. New products created in Magento are not imported into TradeGecko after the initial integration.
  2. 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.

Related articles