Thread: Help with XML import

I can't get the following fields to pass information on an initial Product import. I have the fields below as they appear in my XML import file.


<Images>
<ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
</Images>

(Nothing in the variants gets passed)
<Variants>
<Variant>
<PriceRef>9.9900</PriceRef>
<Price>9.9900</Price>
<SalePriceRef>8.7900</SalePriceRef>
<SalePrice>8.7900</SalePrice>
<WeightRef>0.125</WeightRef>
<Weight>0.125</Weight>
<CostRef>3.2500</CostRef>
<Cost>3.2500</Cost>
<Variant>
<Variants>

That isn't enough to go by.

What version are you running?
Attach an entire usable sample of what you are attempting to import in a file.

Thanks

Sorry about that, the store front version is 7.0.2.3/ML. Below is the xml file Im using for import.
Sample:

Code:

<?xml version="1.0" encoding="utf-8"?>
<AspDotNetStorefrontImport Version="7.1" SetImportFlag="" AutoLazyAdd="" AutoCleanup="" Verbose="" TransactionsEnabled="">
<Product Action="" EnsureDefaultVariant="" GUID="" ID="">
<Name>LED Retractable Keylight with Belt Clip - As Seen on TV</Name>
<Summary />
<Description>&lt;p&gt;This LED retractable keylight will always be ready to light up your keys and lock to help you get in. With the just a push of a button the super bright LED will allow you to find the right key and see all obstacles in your way. The keylight also has a 9 inch retractable cord with keyring and a handy belt clip. The keylight requires 2 CR2016 lithium batteries that are included. The keylight measures in at 4 inches x 1.375 inches x .875 inches. The LED bulb will never need replacing.&lt;p&gt;Features Include:&lt;ul&gt;&lt;li&gt;Retractable keylight&lt;li&gt;Super bright LED&lt;li&gt;Handy belt clip&lt;li&gt;2 CR2016 lithium batteries that are included&lt;li&gt;Keylight measures 4 x 1.375 x .875 inches&lt;/li&gt;&lt;/li&gt;</Description>
<SpecTitle />
<MiscText />
<Notes />
<IsFeaturedTeaser />
<FroogleDescription />
<SKU>72-0188</SKU>
<ManufacturerPartNumber />
<SwatchImageMap />
<SE>
<SEName />
<SETitle />
<SEKeywords />
<SEDescription />
<SENoScript />
<SEAltText />
</SE>
<SizeOptionPrompt />
<ColorOptionPrompt />
<ProductType Name="Generic Product" ID="" GUID="">
<Name>Generic Product</Name>
</ProductType>
<ProductTypeRef>Generic Product</ProductTypeRef>
<ManufacturerRef>test mfg</ManufacturerRef>
<DistributorRef>Trademark Commerce</DistributorRef>
<CategoryRef>/As Seen on TV</CategoryRef>
<TaxClass Name="Goods" ID="" GUID="" />
<SalesPrompt Name="On Sale For" ID="1" GUID="" />
<SpecCall />
<SpecsInline />
<Display>
<XmlPackage>product.variantsinrightbar.xml.config</XmlPackage>
<ColWidth>3</ColWidth>
<PageSize>20</PageSize>
<SkinID />
<TemplateName />
</Display>
<Images>
<Icon Extension="" Delete="" />
<Medium Extension="" Delete="" />
<Large Extension="" Delete="" />
<ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
<MultiImage>
<Icon>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Icon>
<Medium>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Medium>
<Large>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Large>
</MultiImage>
</Images>
<QuantityDiscount Name="" ID="" GUID="" />
<RelatedProducts>
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</RelatedProducts>
<UpsellProducts DiscountPercentage="">
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</UpsellProducts>
<RequiresProducts>
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</RequiresProducts>
<InventoryType>
<TrackInventoryBySizeAndColor>0</TrackInventoryBySizeAndColor>
<WarehouseLocation />
</InventoryType>
<IsFeatured />
<IsAKit>0</IsAKit>
<IsSystem />
<IsAPack>0</IsAPack>
<PackSize>0</PackSize>
<ShowInProductBrowser />
<ShowBuyButton />
<Published>1</Published>
<Wholesale />
<RequiresRegistration>0</RequiresRegistration>
<HidePriceUntilCart />
<IsCalltoOrder />
<ExcludeFromPriceFeeds />
<GoogleCheckoutAllowed />
<RequiresTextOption />
<TextOptionMaxLength />
<TextOptionPrompt />
<AvailableStartDate />
<AvailableStopDate />
<Mappings AutoCleanup="" PreserveExistingRecords="">
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
</Mappings>
<ExtensionData />
<ExtensionData2 />
<ExtensionData3 />
<ExtensionData4 />
<ExtensionData5 />
<Kit AutoCleanup="">
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
</KitGroup>
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
</KitGroup>
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
</KitGroup>
</Kit>
<Variants AutoCleanup="">
<Variant Action="Add" SKUSuffix="" GUID="" ID="" Name="LED Retractable Keylight with Belt Clip - As Seen on TV">
<IsDefault />
<Name />
<Description>&lt;p&gt;This LED retractable keylight will always be ready to light up your keys and lock to help you get in. With the just a push of a button the super bright LED will allow you to find the right key and see all obstacles in your way. The keylight also has a 9 inch retractable cord with keyring and a handy belt clip. The keylight requires 2 CR2016 lithium batteries that are included. The keylight measures in at 4 inches x 1.375 inches x .875 inches. The LED bulb will never need replacing.&lt;p&gt;Features Include:&lt;ul&gt;&lt;li&gt;Retractable keylight&lt;li&gt;Super bright LED&lt;li&gt;Handy belt clip&lt;li&gt;2 CR2016 lithium batteries that are included&lt;li&gt;Keylight measures 4 x 1.375 x .875 inches&lt;/li&gt;&lt;/li&gt;</Description>
<SE>
<SEName />
<SEKeywords />
<SEDescription />
<SENoScript />
<SEAltText />
</SE>
<FroogleDescription />
<ProductID />
<SKUSuffix />
<ManufacturerPartNumber />
<Price>9.9900</Price>
<ExtendedPrices AutoCleanup="" PullFromVariantID="" PullFromVariantGUID="">
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
</ExtendedPrices>
<SalePrice>8.7900</SalePrice>
<Weight>0.125</Weight>
<MSRP />
<Cost>3.2500</Cost>
<Points />
<Dimensions>
<UOM>IN</UOM>
<Length>4</Length>
<Width>1.375</Width>
<Height>0.875</Height>
</Dimensions>
<Inventory />
<InventoryBySizeAndColor MatchKey="">
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
</InventoryBySizeAndColor>
<DisplayOrder />
<Notes />
<IsTaxable />
<IsShipSeparately />
<IsDownload />
<DownloadLocation />
<FreeShipping />
<Published>1</Published>
<Wholesale />
<IsRecurring />
<RecurringInterval />
<RecurringIntervalType />
<SubscriptionInterval />
<SubscriptionIntervalType />
<RestrictedQuantities />
<MinimumQuantity />
<Images ClearBeforeImport="">
<Icon Extension="" />
<Medium Extension="" />
<Large Extension="" />
<ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
</Images>
<CustomerEntersPrice />
<CustomerEntersPricePrompt />
<ExtensionData />
<ExtensionData2 />
<ExtensionData3 />
<ExtensionData4 />
<ExtensionData5 />
<Sizes>
<Size SKUModifier="" PriceDelta="" />
<Size SKUModifier="" PriceDelta="" />
<Size SKUModifier="" PriceDelta="" />
</Sizes>
<Colors>
<Color SKUModifier="" PriceDelta="" />
<Color SKUModifier="" PriceDelta="" />
<Color SKUModifier="" PriceDelta="" />
</Colors>
<ShippingCosts AutoCleanup="" PullFromVariantID="" PullFromVariantGUID="">
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
</ShippingCosts>
</Variant>
</Variants>
</Product>
</AspDotNetStorefrontImport>

Product variants should be defined as

Code:

<Product>
   <ProductVariant>
   .
   .
   .
   </ProductVariant>
</Product>

Works like a charm! Thank you sir. I see now how it works, although I still can't get the <ImageFilenameOverride> to pass anything. I know now it has to be something I'm just overlooking.

Try ImageFileNameOverride (with a capital 'N')

Russ,
Did you construct the XML file you listed on here yourself or was this an XML conversion from another file? I am currently trying to import an xml file from AutoQuotes which contains everything from dimensions, weight, price, and photos. I don't have any experience working with XML as of yet.

That is self constructed following the instructions for XML Importing located in the WSI manual.