Magento 1.x Specific Notes

This page lists some special notes and potentially unexpected behavior that occurs in the extract or convert steps for Magento.

Orders

Finding Magento Order Ids to Extract

There are two different attributes that Magento uses to identify orders - increment_id and order_id. increment_id is what is displayed in the admin, like "Order # 1000053", while order_id is used internally to specify an order. Shopify Transporter uses order_id, not increment_id. Make sure to use order_id when passing arguments to Shopify Transporter. You can find the order_id for orders using:

• The url for a specific order (For example, in the url: https://example.com/admin/sales_order/view/order_id/197/key/.../, 197 is the id for this order.)
• The Magento database (The entity_id column in the sales_flat_order table)

Combining line items for simple and configurable products

Based on how Magento 1.9.x exports orders, the default conversions for orders assume that if a simple and configurable product exist with the same sku in the list of line items, these were intended to be the same line item.

Here is an example of such an extracted order:

{
    "increment_id": "100000052",
    "store_id": "1",
    "@xsi:type": "ns1:salesOrderListEntity",
    "items": {
      "result": {
        "increment_id": "100000052",
        "store_id": "1",
        "created_at": "2013-03-28 19:58:37",
        "updated_at": "2013-04-04 00:34:50",
        "shipping_address": {
        },
        "billing_address": {
        },
        "items": {
          "item": [
          {
              "item_id": "113",
              "order_id": "43",
              "quote_item_id": "630",
              "created_at": "2013-03-28 19:58:37",
              "updated_at": "2013-04-04 00:34:49",
              "product_id": "374",
              "product_type": "simple",
              "product_options": "",
              "weight": "1.0000",
              "is_virtual": "0",
              "sku": "abl004",
              "name": "Houston Travel Wallet",
              "free_shipping": "0",
              "is_qty_decimal": "0",
              "no_discount": "0",
              "qty_canceled": "4.0000",
              "qty_invoiced": "0.0000",
              "qty_ordered": "4.0000",
              "qty_refunded": "0.0000",
              "qty_shipped": "0.0000",
              "price": "210.0000",
              "base_price": "210.0000",
              "original_price": "210.0000",
              "base_original_price": "210.0000",
            },
          {
              "item_id": "114",
              "order_id": "43",
              "quote_item_id": "631",
              "created_at": "2013-03-28 19:58:37",
              "updated_at": "2013-04-04 00:34:49",
              "product_id": "417",
              "product_type": "configurable",
              "product_options": "",
              "weight": "1.0000",
              "is_virtual": "0",
              "sku": "wbk002",
              "name": "NoLIta Cami",
              "price": "120.0000",
              "base_price": "120.0000",
            },
          {
              "item_id": "115",
              "order_id": "43",
              "quote_item_id": "632",
              "created_at": "2013-03-28 19:58:37",
              "updated_at": "2013-04-04 00:34:49",
              "product_id": "284",
              "product_type": "simple",
              "product_options": "",
              "weight": "1.0000",
              "is_virtual": "0",
              "sku": "wbk002",
              "name": "NoLIta Cami",
              "free_shipping": "0",
              "is_qty_decimal": "0",
              "no_discount": "0",
              "qty_canceled": "0.0000",
              "qty_invoiced": "0.0000",
              "qty_ordered": "1.0000",
              "qty_refunded": "0.0000",
              "qty_shipped": "0.0000",
              "price": "0.0000",
              "base_price": "0.0000",
            }
        ],
          "@soap_enc:array_type": "ns1:salesOrderItemEntity[3]",
          "@xsi:type": "ns1:salesOrderItemEntityArray"
        },
        "payment": {
        },
        "status_history": {
        },
        "@xsi:type": "ns1:salesOrderEntity"
      }
    }
  }

In the case of this order, the customer purchased the simple product with sku "wbk002", but the line items also contain information about the configurable product for this item, and the information for these two line items is merged in the conversion step to provide an accurate representation of the line items when imported into Shopify.

---

Products

Product Weight Units

The product weight extracted from Magento does not have a weight unit linked to it when extracted. When these products are imported into Shopify, they will be imported using the default weight unit of your store.

For an accurate import of product weight, set the weight unit on your Shopify store to the default weight unit in the Magento store you are extracting data from. You can set the default weight unit for your Shopify store from the General Settings section of your store under Standards and formats. This is highlighted in the screenshot below. You can change this back to the desired default weight unit after importing the products, and the imported weights will not be affected.