I'm using TDF version 5.0840.
I'm creating a export file of product variant inventory. I also maintain the UPC value in the SKU field in Miva. The product export tokens are as follows:
%item_group_id%%^%%product:code%%^%%product:sku%%^ %%product:quantity%
The issue is that when a product variant.sku value is empty/null in Miva, then previous record that has a value in the product.sku field is reported, thus that product.sku value is reported twice when it should be blank. Here is example output data:
Product product_variant product_sku qty
100074 100074_472_SML_REG 035481973321 0
100074 100074_472_4XL_TLL 035481973444 0
100074 100074_472_4XL_REG 035481973383 4
100074 100074_472_MED_TLL 035481973383 0
100074 100074_472_MED_REG 035481973338 0
The record 100074_472_MED_TLL has no value in Miva for the product.sku field, so TDF is reporting it twice from previous record. Why is this? .. is there a command in TDF to not report NULL items?...
confused, any ideas would be appreciated!
Rick
I'm creating a export file of product variant inventory. I also maintain the UPC value in the SKU field in Miva. The product export tokens are as follows:
%item_group_id%%^%%product:code%%^%%product:sku%%^ %%product:quantity%
The issue is that when a product variant.sku value is empty/null in Miva, then previous record that has a value in the product.sku field is reported, thus that product.sku value is reported twice when it should be blank. Here is example output data:
Product product_variant product_sku qty
100074 100074_472_SML_REG 035481973321 0
100074 100074_472_4XL_TLL 035481973444 0
100074 100074_472_4XL_REG 035481973383 4
100074 100074_472_MED_TLL 035481973383 0
100074 100074_472_MED_REG 035481973338 0
The record 100074_472_MED_TLL has no value in Miva for the product.sku field, so TDF is reporting it twice from previous record. Why is this? .. is there a command in TDF to not report NULL items?...
confused, any ideas would be appreciated!
Rick
Comment