Thread: Import variants inventory level by Size and Color

I use 8x and was wondering how you import variants invetnory level by Size and/or Color. I have TrackInventoryBySizeAndColor app config value set but when importing the product list in the first place and I need to break down the inventory by size at least (and maybe by color).
If I have a list of items like this

DESICRIPTION COLOR XS SM M L QTY
Summer Coat BLACK 1 2 2 1 6
Winter Coat BLACK 1 2 2 1 6

How do I import the quantity per size. For pricing you can put the additional cost of an item beside it's size in square brackets, can you do something similar for inventory?

Thanks,
Pablo.

The excel import file does not support uploading inventory by size and color. However, this can be accomplished via import using our Web Services Automation Interface (WSI). The syntax for doing so would be

Code:

<AspDotNetStorefrontImport>
	<Product Action="Update" ID="integer">
		<Variants>
			<Variant Action="Update" Name="Summer Coat">
				<InventoryBySizeAndColor MatchKey="SizeColor">
					<Inv Size="XS" Color="BLACK" Quantity="1" />
					<Inv Size="SM" Color="BLACK" Quantity="2" />
					<Inv Size="M" Color="BLACK" Quantity="2" />
					<Inv Size="L" Color="BLACK" Quantity="1" />
				</InventoryBySizeAndColor>
			</Variant>
			<Variant Action="Update" Name="Winter Coat">
				<InventoryBySizeAndColor MatchKey="SizeColor">
					<Inv Size="XS" Color="BLACK" Quantity="1" />
					<Inv Size="SM" Color="BLACK" Quantity="2" />
					<Inv Size="M" Color="BLACK" Quantity="2" />
					<Inv Size="L" Color="BLACK" Quantity="1" />
				</InventoryBySizeAndColor>
			</Variant>
		</Variants>
	</Product>
</AspDotNetStorefrontImport>

Thanks George, will give that a go.