Developer forum

Forum » Development » Transfer products and group From old SHOP module to Ecommerce shop module in dynamicweb

Transfer products and group From old SHOP module to Ecommerce shop module in dynamicweb

Vilius Janulis
Reply
It really needs to be done, i have tried to map tables in integration module, and import like that, but it seems i is having some problems, it imports into database all values (and it seems they are correct (equivalent to manually created group)), but it is still not showing in the back end of dynamicweb.

Tried like this :
  ShopGroupID GroupID dbo.[EcomGroups]
ShopGroupName GroupName dbo.[EcomGroups]
ShopGroupID GroupRelationsGroupID dbo.[EcomGroupRelations]
ShopGroupParentID GroupRelationsParentID dbo.[EcomGroupRelations]
ShopGroupNumber GroupNumber dbo.[EcomGroups]
ShopGroupSort GroupRelationsSorting dbo.[EcomGroupRelations]
ShopGroupSort ShopGroupRelationsSorting dbo.[EcomShopGroupRelation]
ShopGroupID ShopGroupGroupID dbo.[EcomShopGroupRelation]
false GroupAssortment dbo.[EcomGroups]
LANG1 GroupLanguageID dbo.[EcomGroups]
SHOP1 ShopGroupShopID dbo.[EcomShopGroupRelation]
0 GroupPageIDRel dbo.[EcomGroups]   

And since all values equivalent to manually created group values, maybe it is because there was already groups created in dynamicweb ecom module.

Question is, is there is other way to do it simply ? If not what could be wrong with this try ? How to delete default standard auto-incremented Group id value ? For example even if there is no groups in ecom, and i create one, its id will be Group35, how to reset that to Group1 or etc ? Is this could cause import problem ?


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
>> For example even if there is no groups in ecom, and i create one, its id will be Group35, how to reset that to Group1 or etc ?

Take a look in the EcomNumbers table You can reset the NumberCounter colum for the record with "GROUP" as the NumberType.

Hope this helps,

Imar
 
Vilius Janulis
Reply
 Yes, thanks this was what i was looking for. 
 
Vilius Janulis
Reply
 Now having similar problem but with Product import :

How to import Products related products, and Products Variants ?

Starting to be little confusing with variants :) Does anyone now how it should be ? I mean what values are necessary from old module in the new module, and witch and where they should be imported ?

THANK YOU :)
 
Vilius Janulis
Reply
 Is it even possible to do ? even if not with integration module, but by custom module, with ability to modify values and etc. ?
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Yes, it can be done using the API. I am working on a book on Dynamicweb eCommerce and one of the chapters deals with importing products through the API. You can contact me at i.spaanjaars at dynamicweb dot nl if you're interested in a sneak preview of this chapter in return for feedback on that chapter....

Cheers,

Imar

 

You must be logged in to post in the forum