Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

Learn more about...

AspDotNetStorefront
DotFeed

How to map Product variant with SKU number ?

Hello ALL,

I am currently working on product variant mapping.

I have following question  :

  • How can I map size and color with SKU no?
  • Can i  use sizeSKUmodifier and colorSKUmodifier of ProductVariant table?

If YES,

  • How the inserted data looks like ? Is it right for sizeSKUmodifier : 2x[SKUno],3x[SKUno],LA[SKUno] ?

Thanks in advance,

Bikash

asked Mar 21, 2014 in MultiStore by bikashm (760 points)

1 Answer

0 votes
Hello Bikash,

There are 3 types of SKU. Product level (SKU), Variant Level (SKUSuffix) and Size Color Level (SizeSKUModifiers,ColorSKUModifiers).

Yes you can use SizeSKUModifiers and ColorSKUModifiers

Suppose you have a Product Cap (SKU: C1245) with 3 color variant like Red (SKU: RC1) Blue (SKU: BC1) and Green (SKU: GC1)

Now In variant table you can insert all the sku's like following

ProductTable

SKU=C1234

ProductVariant Table

Color: Red,Blue,Green

ColorSKUModifiers : RC1,BC1,GC1

Thanks

Anirban
answered Mar 21, 2014 by anirban (1,350 points)
Hello Anirban,

Thanks a lot . you r ginious.

Thanks again,

Bikash
Hello Anirban,

I am using WSI nodes for inserting product and variant. There are two attibute inside sizes and : SKUModifier and PriceDelta .  Can u please let me know how can i work handle the SKUModifier and PriceDelta ?
 <Variants AutoCleanup="false">
 <Variant Action="Add">
<Sizes>
<Size SKUModifier="string" PriceDelta="decimal">red</Size>
<Size SKUModifier="string" PriceDelta="decimal">green</Size>
<Size SKUModifier="string" PriceDelta="decimal">blue</Size>
</Sizes>
<Colors>
<Color SKUModifier="string" PriceDelta="decimal">s</Color>
<Color SKUModifier="string" PriceDelta="decimal">m</Color>
<Color SKUModifier="string" PriceDelta="decimal">l</Color>
</Colors>

</Variant>

</Variants>
 

 

Thanks in advance.

Bikash

Suppose You have a product Shirt with 3 sizes. 

Small,Large,ExtraLarge[3.00].  This 3.00 is the price delta which means size extra large cost $3 extra than normal product price.

<Sizes>
<Size SKUModifier="s" PriceDelta="">Small</Size>
<Size SKUModifier="l" PriceDelta="">Large</Size>
<Size SKUModifier="xl" PriceDelta="3.00">ExtraLarge</Size>
</Sizes>

Thanks

Anirban

 

Hello Anirban,

Thanks a lot for your valuable time and suggestion.

Actually, my database only contains the different price depends on the size. It doesn’t follow the PriceDelta(extra than normal product price) logic. So how can I implement the priceDelta logic?

Thanks again,

Bikash
Then you have to create all sizes are diffarent variants.
Hello Anirban,

Thanks for your replay.

I can make it but it will show the same  picture and properties  only the size and price r different.

Can I subtract the base price with the current variant price and put it on priceDelta?

Thnaks,

Bikash
Yes you can if and only if you sure that variant price not depends any other parameters.
Hello Anirban,

Thanks a lot for your valuable suggestion.

Thanks,

Bikash
Hello Anirban,

I have cretaed following xml for handle color,size,skuColorModifier and skuSizeModifier :

<Sizes>
          <Size SKUModifier="SKU1,SKU2,SKU3" PriceDelta="" >2X,3X,4X</Size>

</Sizes>
  <Colors>
          <Color SKUModifier="" PriceDelta="" >Red,Black,Green</Color>

</Colors>

Please let me know it is right or not?

Thanks,

Bikash

Hello Anirban.

I am inserting the product using WSI nodes. There is no product and variant relationship in Our ERP database. The table contains individual products with their unique id.

I would like to map product and their variants. I have checked that only the size, color and manufacturer are different otherwise everything is same for individual product group.

I have created the product and variant relationship with size and color. For product we can map it  with Manufacturer  , using EntityType="Manufacturer “. Here I have multiple manufacturers for the individual product.

Q.How could I map variant with manufacturer?

Thanks in advance.

Bikash

 

...