Stockeo Help
Ask or search…
K
Comment on page

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
Supplier feed
SKU settings in Stockeo for Shopify
SKU settings in Stockeo
<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 annotated
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
Supplier feed
Copy SKU settings
Sku settings with a Liquid formula in Stockeo
<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>
{{ 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 fomula in the Shopify store
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
Supplier feed
Shopify example product SKU
Shopify product SKU
Custom SKU stored as the variant metafield annotated
Custom SKU stored as the variant metafield
<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 in Stockeo automation animated
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 in the Stockeo automation
Select metafield with the custom SKU
Enter the name of the feed node where the SKU is stored.
Mapping SKU from the feed in the Stockeo automation
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 in the Stockeo automation annotated
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 in the Stockeo automation animated
Delete the SKU field
Otherwise, the SKUs of your items will be updated according to the value from the feed.