Import/Export
There are fundamentally two ways to import products to and export products from a DynamicWeb 10 solution:
- Using the built-in simple import/export tool
- Using the data integration framework
The first option is typically used by editors on a case-by-case basis when looking to solve simple tasks, whereas option 2 is typically set up as a part of the solution architecture in order to synchronize with an external system.
In this article we will only describe option 1 - in order to learn more about the data integration framework, please consult the documentation linked above.
Note
In order to import and export data you must install the following providers from the AppStore:
- Ecom Provider
- Excel Provider
Currently we only support excel-files, but we're working on also supporting XML and .csv formats.
Importing data
Before importing data, please upload the source file to the Assets-area.
To import product data to a product group:
Navigate to the product group where you want to import products and use the action menu to select import
Select the source file, optionally select a configuration, then click Next
Select the import key and optionally one ore more data models to add the imported products to, then use the action-menu to select Next
On the mappings screen, create or edit the column mappings - where you want the data from the imported file to be placed. Some mappings may be auto-created, if we can determine from the name where they belong, but others have to be created manually.
Use the action-menu to select Run or Save configuration
Exporting data
To export product data from a product group:
- Navigate to the product group and select the products you want to export, then use the action menu to select Export - then:
- Select an export collection to use
- Select the languages you want to export
- If necessary edit which products to include
- Click Export