Import/Export Checklist

This topic provides a checklist for the tasks that must be performed to create and maintain import and export feeds for your sites.

Design

The following are tasks that must be completed in the design phase of the project.

Task

1. Determine the number of import feeds you want to create. Consider:

a. How often each type of object needs to be updated. For example, price books might need to be updated more frequently than catalog data.

b. Whether the objects are dependent upon other objects. For example, campaigns and promotions must be updated together, because campaigns are collections of promotions and can't be created without them.

2. Determine the number of export feeds you want to create.

3. For each import feed, determine:

a. The systems to export the file to be imported.

b. The instances it needs to be imported into.

c. How frequently you want to import the file.

d. The names of the files to import and their location.

e. The Salesforce B2C Commerce or custom schema used for the import file.

f. The required import mode.

g. The security requirements. For example, whether you intend to use HTTPS or encryption in transferring the file.

h. The persons with permissions move files for the import onto the cartridge or run the job.

i. Who to contact if the feed doesn't complete successfully.

4. For each export feed, determine:

a. The instances it needs to be exported from

b. The schedule for export

c. The names of the files to export and their location

d. The schema or file structure used for the export file

e. The security requirements. For example, you do intend to use HTTPS or encryption in transferring the file.

5. Use the information you have gathered to create a master feed diagram for your import feeds.

Development

The following are tasks that must be completed in the site development phase of the project. Before starting development, check the B2C Commerce code repository for code that might help you advance your project.

Sandbox Instances

Task
1. Create a feed mapping file that maps fields in your existing systems to the fields in the B2C Commerce import schema.
2. Configure your backend system to produce the XML files required by the feed schema. You might want to create a job on your backend system that automatically produces the import file.
3. Apply any transformations needed to enrich the data or reorganize the file. It's recommended that this be done outside of B2C Commerce. For more information, see File Formats Data Transformations.
4. Create users with permissions to import objects.
5. Manually import files as needed using Business Manager.
6. Create a template sandbox, configure it, and perform Site Import/Export to populate your other sandbox instances.
7. Manually import files as needed using Business Manager.
8. Create a new cartridge for your import export code and add the cartridge to the site or organization path.
9. Create pipelines for automated import feeds.
10. Create jobs to run the import pipelines. Associate each job with a single pipeline. Configure jobs to alert an administrator if they don't complete in a specified amount of time.
11. Create users with the privileges to execute the jobs.
12. Record the average length it takes to run each job and make a job schedule.

Staging Instance

Task
1. Use Site Import/Export to transfer job schedules from a sandbox instance or create new jobs for the instance.
2. Create users with appropriate privileges to import objects and execute jobs.
3. Use UX Studio to upload custom file transfer and import/export pipelines to the staging instance.
4. Create a pipeline and job that cleans up import/export log files on a regular basis.
5. Create a pipeline and job that cleans up archived site exports on a regular basis.
6. If you are using SSL, create the public key infrastructure for your production instance.
7. Configure any third-parties that have to place files in the cartridge that can't use WebDAV, to use HTTP Post.

Production Instance

Task
1. Use Site Import/Export to transfer job schedules from a sandbox instance or create new jobs.
2. Create users with appropriate privileges to import objects and execute jobs.
3. Use code replication to move custom file transfer and import/export pipelines from the staging instance to the production instance.
4. Create a scheduled job that exports your site on a regular basis.
5. Create a scheduled job that archives your site export files on a regular basis.
6. Create a pipeline and job that cleans up import/export log files on a regular basis. If created for staging, use code replication to add this to the instance.
7. Create a pipeline and job that cleans up archived site exports on a regular basis. If created for staging, use code replication to add this to the instance.
8. If you are using SSL, create the public key infrastructure for your production instance.

Development Instance

Task
1. Use Site Import/Export or code replication to transfer job schedules from the production instance to the development instance.
2. Create users with appropriate privileges to import objects and execute jobs.
3. Use code replication to move custom file transfer and import/export pipelines from the production instance to the development instance.

Import/Export Deployment and Maintenance

Deployment of import/export is similar to ordinary code deployment. You also need to make sure that archiving and archive clean up is done, if you are choosing not to manage it programmatically. If you run import from Business Manager, when you delete the record of the import, the log file is removed automatically. If you run the import programmatically, the log file is never cleaned up, so you need to clean up the log files as well.

If you need to troubleshoot a problem with your production site, you might want to export the site meta data and import it into your sandbox.

Related Links

Import and Export

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.