Hi Everyone,
I was wondering if anyone could provide any insights as to why the the variation SKUs are not passing through the eBay Item Id to Netsuite Mass Update?
For non-variation SKUs, the mapping works as expected and the ItemID is populated correctly. Below is a sample payload for a standard (non-variation) item that maps fine:
<Item>
<ItemID>1234567890</ItemID>
<SellingStatus>
<CurrentPrice currencyID=\"USD\">20.99</CurrentPrice>
</SellingStatus>
<ShippingDetails/>
<SKU>SKU123</SKU>
</Item>
For the SKUs, that have variations this is what the format looks like.
<Item>
<ItemID>999999999999</ItemID>
<SellingStatus>
<CurrentPrice currencyID=\"USD\">25.95</CurrentPrice>
</SellingStatus>
<ShippingDetails/>
<Variations>
<Variation>
<SKU>SKU1</SKU>
<StartPrice currencyID=\"USD\">25.95</StartPrice>
<Quantity>1</Quantity>
<VariationSpecifics>
<NameValueList>
<Name>Size</Name>
<Value>M-L</Value>
</NameValueList>
</VariationSpecifics>
<SellingStatus>
<QuantitySold>0</QuantitySold>
</SellingStatus>
<VariationTitle>TITLE SKU1</VariationTitle>
</Variation>
<Variation>
<SKU>SKU2</SKU>
<StartPrice currencyID=\"USD\">25.95</StartPrice>
<Quantity>1</Quantity>
<VariationSpecifics>
<NameValueList>
<Name>Size</Name>
<Value>XS-S</Value>
</NameValueList>
</VariationSpecifics>
<SellingStatus>
<QuantitySold>0</QuantitySold>
</SellingStatus>
<VariationTitle>TITLE SKU2</VariationTitle>
</Variation>
<Variation>
<SKU>SKU3</SKU>
<StartPrice currencyID=\"USD\">25.95</StartPrice>
<Quantity>1</Quantity>
<VariationSpecifics>
<NameValueList>
<Name>Size</Name>
<Value>XL</Value>
</NameValueList>
</VariationSpecifics>
<SellingStatus>
<QuantitySold>0</QuantitySold>
</SellingStatus>
<VariationTitle>TITLE SKU3</VariationTitle>
</Variation>
</Variations>
</Item>
The variation SKUs on eBay definitely match our SKUs in NetSuite, so I don’t believe the import condition is the reason they’re not being mapped. My theory is that they might be getting stripped out downstream once exported from eBay, although I could be wrong.
I also checked the NetSuite debug connection logs, but I didn’t find any entries related to the variation SKUs.
Thank you in advance for the help.