Products can be exported into a CSV (comma separated values) file so that you can manually report or import into a third-party system. You can also export product lists to make changes and then import back into Maropost Commerce. There’s 2 ways to export your product details.
In this Article
Simple Export
The simple export is best used for reporting, as fields can’t be customised as much and filters are limited. Third party applications will likely have a specific format required in which case the complex export is better suited.
To use the simple export:
-
In your Maropost Commerce control panel navigate to Products > View products.
-
Click the Export button at the top of the page.
Please Note: Filters applied to the product list will not be carried over to the export results.
-
Choose either CSV with popular fields or CSV with all fields and click the Preview button.
-
Clear any checkboxes for fields you don’t want exported, and click the Export button.
-
The CSV file of your product will be created. Click the Download button when it appears, to save the file to your computer.
Complex Export
The complex export wizard gives you a lot more control over the fields that are exported, filters, and allows you to set up schedules to export on a regular basis. To use the complex export wizard:
-
In your Maropost Commerce control panel, navigate to Settings & tools > Export data.
-
Select the Products radio button.
-
Click the Perform complex export button and choose the Start Data Export Wizard option.
-
Enter a name for your file and click the Continue to Next Step button.
-
You now need to choose which product fields you want to export. Click the Add New Field To File button, and choose the fields from the drop down menus.
You need to select a field type first (e.g. Product Data*) and then choose the field name (e.g. SKU)
Tip: Be sure to include the Product Data > SKU field as this is used as the unique identifier for your products.
-
Repeat the previous step and add all the fields you need in your file. When complete, click Continue to Next Step.
Tip: You can change the column header for each field on the right hand side of the page. This is useful if you export to a third party system that has specific field name requirements.
-
On step 3 of the import process, you can now implement filters to determine which products are included in export file.
Tip: To filter by multiple values separate them with a space (e.g SKU1 SKU2 SKU3).
When you’ve finished selecting your filters click the Continue to Next Step button.
-
In the Send Export File To field, select how you want to receive your product export file.
Tip: Choose Local URL to save the file in your site assets, so it can be downloaded when ready. You’ll be shown a URL where it can be downloaded from.
| Export Method | Description | Steps |
|---|
| Email | Send the file as an attachment on an email. | Enter your Email Address. |
| FTP | Save the file on another server. | Enter the server FTP Location, FTP Username and FTP Password. |
| External URL | Post the file to another server (advanced option). | Enter the External URL, FTP Username, FTP Password and any other required fields. |
| Local URL | Save the file to a folder on your site. | Enter a Folder Name (or leave blank for the default location). |
Make sure you add any required details (e.g. email address, FTP username/password) depending on your selection.
-
Select the checkbox if you want to save the export settings (name, fields, filters etc) so that you can run the export again later. If you do, enter a template name and optionally select an automated export schedule.
-
Click the Export Now button.
The export process will be queued to run, create the file, and deliver it to your chosen location.
Tip: Click on the export process ID to view a page with the status of your export. Click the Run Now button on this page to start the process immediately.
Troubleshooting
Scientific Notation Issues
Spreadsheet programs have different cell data types like General / Standard, Text, Number, Currency and Dates. Since the program does not know what type of data is in each cell, it tries to guess. In most cases it assigns the general or standard cell type to each cell.
This cell type makes changes to numbers that are being imported. For example:
-
028263 will be imported as 28263 – dropping the leading zero. This is an issue when 028263 is the SKU for a product.
-
111222333444 will be imported as 1.11E+11 – converting the number into scientific notation. Scientific notation is used by scientists to display very small or large numbers.
To avoid the program converting the numbers, the CSV file will need to be imported rather than opened.