Cert++
Close

Schema-conformant XML import files and validation

Key Takeaway

B2C Commerce accepts only XML import files that conform to the object's XSD schema, so convert any CSV data to schema-conformant XML before you import it.

B2C Commerce loads data such as catalogs, price books, coupons and new orders from XML import files. Each file must follow an object-specific XSD schema that defines its structure. To build files that load cleanly, you need to know what schema validation checks and what it skips.

Schema files and XML import files

B2C Commerce only accepts XML import files that conform to its schema files. Key examples are catalog.xsd, pricebook.xsd, customer.xsd, coupon.xsd and order.xsd.

The schema holds the rules. The XML file holds your data in the format the schema requires. For example, catalog.xsd defines category and product elements. A category element has a category-id and contains values such as display-name, online-flag and parent. When online-flag is true, the category is visible on the storefront.

B2C Commerce always exports files in XML format, except coupon codes, which export as CSV.

Schema rules also apply to data entered by hand in Business Manager. If a merchandiser adds product details that don't follow the schema, the data is invalid. The export, and possibly nightly backups, then fail until someone fixes the data.

Schemas can change over time. Know which external jobs produce your import files, so you can update those jobs when a schema change affects your imports.

B2C Commerce Developer Study Guide

Checklist progress

0/237Learned

Given a sandbox instance and data import files, import files using the Business Manager Import/Export modules

0/6

Prepare for the Exam

Play Today's Certle

Study Community

Ask questions and get the latest info from other B2C Commerce Developer studiers. 796 members and growing.