Thread: Bulk Importing Variants for Existing Products

We currently have about 65 products that are lecture series products with a CD and DVD variant currently existing. We would like to add variants to each of these products for MP3's (will be around 1200 variants to be added).

The way I understand it, if I use the Excel import then I have to have all the parent product information entered exactly as it currently exists or it will overwrite what is currently in the store. For 1200 new variants on 65 products, this is too much.

Is there an easier way? Has anyone tried a dump straight into the ProductVariant table via SQL? Would there be any other tables that would miss out?

We are using ML v8.0.1.2.

Thanks!

Your best bet would be WSI, it's designed for bulk updates/inserts.

See anything wrong with the following? It's goes through the WSI successfully with no errors, but the variant isn't there.

Code:

<AspDotNetStorefrontImport>
	<Variants>
		<Variant Action="Add">
			<IsDefault>0</IsDefault>
			<Name>MP3-Lesson 1</Name>
			<SE>
				<SEAltText>MP3-Lesson 1</SEAltText>
			</SE>
			<ProductID>287</ProductID>
			<SKUSuffix>MP3</SKUSuffix>
			<ManufacturerPartNumber>12554mp3</ManufacturerPartNumber>
			<Price>1.99</Price>
			<Weight>0.0</Weight>
			<Inventory>1000000</Inventory>
			<DisplayOrder>1</DisplayOrder>
			<IsTaxable>1</IsTaxable>
			<IsShipSeparately>0</IsShipSeparately>
			<IsDownload>1</IsDownload>
			<DownloadLocation>12554.mp3</DownloadLocation>
			<FreeShipping>0</FreeShipping>
			<Published>1</Published>
		</Variant>
	</Variants>
</AspDotNetStorefrontImport>

look here: http://www.simrun.com/AspDotNetStore...Commander.aspx
you can get a free key by going here: http://forums.aspdotnetstorefront.co...1232#post91232