SKU

To recognize products in your store and take appropriate properties for them from the supplier feed, Stockeo needs a unique key for each item. The SKU is most commonly used for this.

Basic SKU settings

When your supplier provides the SKU in the feed, you can use this value directly. In the following example, the SKU is in the Code node.

Stockeo SKU settings

SKU settings in Stockeo

Supplier feed

<Product>
<Code>192330</Code>
<Title>
Pack Of 3 Energy Saving Candle Bulbs 7W (35W Equiv)
</Title>
<Price>2.25</Price>
<RRP>2.95</RRP>
<AvailableStock>29</AvailableStock>
<Barcode>5050140001004</Barcode>
<Categories>Lighting > Bulbs and Accessories</Categories>
<Colour>WHITE</Colour>
<Material>GLASS</Material>
<Description>
Pack of 3 energy saving candle bulbs wth a power of 7 watts, saving energy. These are 40 watt equivalent bulbs
</Description>
</Product>

Add a prefix to the SKU

Use this option if you would like to add a prefix to your SKU easily in the Create mode or in the Update mode when SKUs in your store contain a prefix which does not appear in the feed SKUs.

Add a prefix to products SKU in Stockeo

Generate SKU with the Liquid formula

It may also happen that no field in the feed can be used as the SKU. In this case, use a combination of several fields to create a unique id for each product. To do this enter the Liquid formula directly in the SKU field:

Stockeo SKU settings

Sku settings with a Liquid formula in Stockeo

Supplier feed

<item>
    <id>187</id>
    <model>PF112</model>
    <name>Ernesto leather wallet</name>
    <option>Colour Dark Blue</option>
    <quantity>34</quantity>
</item>
<item>
    <id>187</id>
    <model>PF112</model>
    <name>Ernesto leather wallet</name>
    <option>Colour Brown</option>
    <quantity>34</quantity>
</item>

Copy SKU settings

{{ model }}-{{ option | replace: "Colour ", "" | replace: " ", "-" | upcase }}

The Liquid formula above for items in this example feed gives the following results:

Example SKUs generated with SKU Liquid formula

Use variant metafield to recognize a product from the feed

In case you do not have in your store the same SKUs of products as in the feed, but you store those SKUs in the metafields for individual products, you can use variant metafields as the key to enable Stockeo to associate product from your store with the product from the feed.

SKU and variant metafield

Shopify product SKU

Custom SKU stored as the variant metafield

Supplier feed

<Item>
    <ID>
        <![CDATA[ARC-18126-2-29]]>
    </ID>
    <Brand>
        <![CDATA[ARCEO]]>
    </Brand>
    <Price>695.00</Price>
    <Stok>32.00</Stok>
</Item>

Use the following settings in the Data Mapping section of your automation:

Add a new Metafield field:

Add new Metafield field

Select the variant metafield with the product SKU that matches the SKU in the feed.

Select metafield with the custom SKU

Enter the name of the feed node where the SKU is stored.

Mapping SKU from the feed

Hit the gear icon. This button will be active if you select your variant metafield. Check the option Use a variant ID.

Use metafield as variant ID

Delete the default SKU field in your automation. This is possible only if you checked the option above.

Delete the SKU field

Otherwise, the SKUs of your items will be updated according to the value from the feed.