nopCommerce Source Data Export
Export nopCommerce catalog, manufacturer, category, Customer, and Order data in the XML and Excel formats required for the File Upload Source workflow.
nopCommerce Source Data Export
Section titled “nopCommerce Source Data Export”Export each required data type in the native format below. Products require both the XML and Excel exports.
Supported Files
Section titled “Supported Files”The Supported Files table in the selected Next-Cart Source setup identifies these upload files. This table does not replace the export procedures below.
| Data | Expected upload filename |
|---|---|
| Manufacturer | manufacturers.xml |
| Category | categories.xml |
| Product | products.xml |
| Product | products.xlsx |
| Customer | customers.xml |
| Order | orders.xlsx |
Export the source data
Section titled “Export the source data”-
Sign in to the nopCommerce admin. Open Catalog > Products and the Export menu. Select Export to XML (all found) and save the file. Also select Export to Excel (all found) and save that file. Keep both Product files.
-
Open Catalog > Manufacturers and export all Manufacturers to XML.
-
Open Catalog > Categories and export all Categories to XML.
-
Open Customers > Customers and export all Customers to XML.
-
Open Sales > Orders and export all Orders to Excel.
Excel files from older nopCommerce versions
Section titled “Excel files from older nopCommerce versions”If the Product or Order Excel export from an older nopCommerce version fails during upload, open the affected file in Excel, use Save As, and select Excel Workbook. Upload the newly saved .xlsx file. Keep the original file and do not change its data.
Next Steps
Section titled “Next Steps”Continue with Upload Source Data Files to prepare and validate the exported files for the Source connection.