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.
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
<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>
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
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 formula
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 product SKU
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
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.
Last modified 7mo ago