Create a Copy of an existing shop

Steve Knutson

Posted on 30/03/2022 06:41:31

Hi DW Team,

We have multiple shops in our product catalogue and we need help with creating a copy of the SeedsNZ shop including all the groups and products associated with the SeedsNZ shop.

We tried using the answer posted in this thread here: https://doc.dynamicweb.com/forum/ecommerce-standard-features/ecommerce-standard-features/re-copy-existing-shop, however, we are not sure how to implement the solution mentioned in that thread.

Is there any documentation available on how to export a Shop and how to import it back?

This is what we have tried so far:

1. Create a new activity with E-conomic provider.

2. Select the source as CSV Provider

3. Then we get an error:

Replies

Oleg Rodionov

Posted on 31/03/2022 02:52:42

Hi,

I don't have the exception with the setup on last DW9.13.4. Besides, now you can try to use 'Copy group structure' feature on a new created PIM's warehouse (see its context menu if PIM is avaialble on your solution) and change its type to 'Shop' in settings to use it in ecom tree if needs.

BR, Oleg QA

Steve Knutson

Posted on 31/03/2022 05:19:01

Hi Oleg,

Thank you so much for getting back to us.

We are currently using DynamicWeb version 9.10.10, however, we are not using the PIM's module.

We are using the Ecommerce module to manage products in different shops as shown in the image below:

We still getting an exception when we try to export the shop using E-conomic and CSV providers as mentioned in our initial request.

Can we set up a meeting with someone from the DyamicWeb team, who can help us with this issue?

Kind Regards.

Dmitriy Benyuk

Posted on 31/03/2022 12:18:16

This post has been marked as an answer

Hi Steve,
it seems you are using wrong Data integration providers. If you want to make an export of the data then you need to make a Dynamicweb Provider as a source
and Xml provider (or any other you want) as destination.
Once the data is exported to the xml file you can edit it and replace the Ids or other needed data, then you can make the opposite Data integration job with
XmlProvider as a source and Dynamicweb Provider as destination.
Maybe this post can help: https://doc.dynamicweb.com/forum/integration/integration/change-the-product-id
If you want to keep the existing products and groups and only change the group relations, i.e associate the same groups with products to the different shop
then you only need to export the data from the table EcomShopGroupRelation with setting the filter settings in the job mappings to column ShopGroupShopId = 'Shop123'
(where Shop123 is your shop id : run Sql firehouse: select * from EcomShops)
then once the groups from those shop are exported to the xml file you can replace the "Shop123" id with your new "ShopId" and import this xml file back, so your
EcomShopGroupRelation table will have the relations from the old groups to the new shop. Also restart the site once the export is done to clear the Ecom cache.

If you want to make a full copy of the groups and products from some shop then it will be more complex scenario where you need to export much more tables:
EcomProducts, EcomGroups, EcomGroupProductRelation, EcomGroupRelations, EcomGroups, EcomShopGroupRelation
and manage to change the Ids for products and groups, fx you can append/prepend the prefixes to the Id columns at the DW->Xml provider job or
manually in the exported Xml file and then import the data from xml file to the same tables in the second import data job.

BR, Dmitrij

Votes for this answer: 1

You must be logged in to post in the forum

Developer forum

Create a Copy of an existing shop

Replies