How can I create a hyper link from my order line items to the correct product in the Shopify admin?

When importing an order you can create a link from the order's line item to the product in the Shopify admin by providing the products id and variant id or by the product SKU. We recommend you link by Product SKU if possible. So let's start there...

To link your product by SKU, you'll need to "turn" the feature on in your Imports data mapping. You can find the configuration option in the Custom Configurations section.

Link your product by sku

Once you've clicked the Link product by SKU checkbox, click the Save/Update button at the bottom of the Data Mapping page. Ensure you have also selected the product sku field in your data mapping. Once you've done this you can add the product sku on each line item and EZ Importer will look the line items by SKU.

Select SKU

When using the SKU field to match your products, you must make sure the SKU in your CSV file matches the SKU of a product in your Shopify Product admin. To find a products SKU go to the Products page in your Shopify admin and click one of the products in your store. Scroll down to the Inventory section of the page and make sure the SKU in your CSV file is found in the SKU (stock keeping unit) field of the product.

Your Shopify Product SKU field

If the CSV column you have mapped to the line_item.sku Shopify field is not found in the SKU (stock keeping unit) field of one of your products, your import will not have a link to the product.

Note that you will need to ensure your product SKU numbers are unique. This is not enforced by Shopify and if you have multiple products with the same SKU EZ Importer could link the incorrect product. To read more about this you can look at our documentation.

In order to map your product by the product id and variant id you need to enable the field mapping on the "Line Items" tab in your Data Mapping.

Don't forget to update the "Header Name" values to match the column name in your input file. Once you've made these changes save your "Data Mapping".

When importing orders and using the line_items.product_id and line_items.variant_id fields to link your products you'll also want to disable the Link product by SKU option. When you have this configuration option enabled EZ Importer will ignore the fields mapped to the line_items.product_id and line_items.variant_id as it will use the product_id and variant_id of the SKU you provided. To ensure things go as smooth as possible we recommend you keep the Link product by SKU option disabled when linking by product id and variant id.

Shopify expects their product id and variant id values to be provided when you map the line_items.product_id and line_items.variant_id fields. You can not provide your own product id or the product id from another platform for these values. You must provide both the line_items.product_id and the line_items.variant_id in order to successfully link your order to it's product.

Finding you products id and variant_id is tricky and if you have the SKU we recommend using the SKU as it's easier to manage. If you have no other choice and must use the product_id and variant_id you can find them two ways:

1. Go to your products page in your Shopify admin. From here click the variant you want to link. This will bring you to the variant's edit page. In the URL you can get both the product_id and the variant_id.

Find Product Id and Variant Id

2. Go to your products page in your Shopify admin. If you do not have any variants, the only way to find the variant id for your product is by appending .json to the end of the product URL. For more details on how this works click here. From here search for variants on the json page. You'll see the product id and variant id for you product. You should find a variants array with an id field and a product_id field. The id field is your products variant id and the product_id field is your products id.

As you can see finding your products id and variant id is a little tricky and it could be time consuming if you have a lot of products in your store. This is why we recommend you link your products by the SKU.

Successful Product Link On Order

After you've successfully uploaded your orders you should see a link in the Shopify admin to the product on your imported order. As you can see below the line item has a link to the product. Since we provided a SKU with our example below the SKU is also displayed on the order.

App: EZ Importer

Tags: ez importer, line items, getting started, product, sku