TRACK_PRODUCT_INVENTORY field doesn't work

[lesliekirk]

TRACK_PRODUCT_INVENTORY field in the Add/Update Product Variants CSV is not part of the import. The field is not there to map and it's not included in the CSV Template nor the XLS Template. It was included in an example that Brennan had provided. How does one go about activating Inventory Variants in the product Attributes for about 2500+ products?

[Brennan]

When you are using the Product Variant Import, it automatically will create the attributes with the track inventory column checked, generate variants and create the part products.

If the products/attributes are already created in Miva and you just want to turn on inventory tracking and generate variants in bulk you'll need to do it via XML:

 <ProductAttribute_Update product_code="&mvt:product:code;" attribute_code="&mvte:attribute:code;">  
<Inventory>Yes</Inventory>
</ProductAttribute_Update>

Generate Variants:

 <ProductVariant_Generate product_code="&mvt:product:code;" pricing_method="master" delimiter="_" />

You can use the sitemap item and assign it to a page and generate a script that will output this code for all products.

[lesliekirk]

I tried it 3 times, 3 different Product Variant Imports - it worked great for all 3 EXCEPT it never checked the track inventory. It looks like this is because these attributes already existed. At least I was able to create the variant products with the file. I'm not sure why the TRACK_PRODUCT_INVENTORY is part of the file that can be used to create everything, there is nothing to map it to, so I'm confused as to how it could assign it for the new ones created?

[lesliekirk]

When you are using the Product Variant Import, it automatically will create the attributes with the track inventory column checked, generate variants and create the part products.

If the products/attributes are already created in Miva and you just want to turn on inventory tracking and generate variants in bulk you'll need to do it via XML:

<ProductAttribute_Update product_code="&mvt:product:code;" attribute_code="&mvte:attribute:code;">
<Inventory>Yes</Inventory>
</ProductAttribute_Update>

Yes, it looks like I will need to turn the inventory tracking.

Generate Variants:

<ProductVariant_Generate product_code="&mvt:product:code;" pricing_method="master" delimiter="_" />

You can use the sitemap item and assign it to a page and generate a script that will output this code for all products.

Do you have a sample page for something like this? It would be greatly appreciated.

[lesliekirk]

So I think I'm getting close to what I need to turn the tracking on for existing products. This code by itself doesn't insert the attribute code

 <mvt:foreach iterator="product" array="products">
<ProductAttribute_Update product_code="&mvt:product:code;" attribute_code="&mvte:attribute:code;">  
<Inventory>Yes</Inventory>
</ProductAttribute_Update>
</mvt:foreach>

If I add <mvt:item name="product_attributes" param="product:id" /> to the loop, well, yeah, I get the attribute code, but I also get the attributes for the product.

I am soooo close but soooo far away.