# Overview Export properties of products, categories, manufactures, create pictures, localized values, etc. to external spreadsheet files ## Description Export Manager is a powerful plugin that allows users to export data to CSV, XLSX, TXT, and XML files from your store. It is fully compatible with existing products, categories and manufacturers. The plugin comes with full documentation to help users get started. Export Manager enables users to export all properties of products, categories, manufacturers, and any other nopCommerce items, including localized values. It also allows users to export specification attributes and product attributes. Export Manager offers an unlimited number of custom export templates, and allows users to configure templates quickly and easily. It provides detailed reports about export results, and allows users to export to FTP, SFTP, server folders, or directly download files. ## Features * Fully compatible with existing products and other items * Exports to CSV, XLSX, TXT, or XML files * Full documentation * All properties of products, categories, manufacturers, and any other nopCommerce items * Localized values for products, categories, etc. * Export of related products, cross-sell patterns, tier prices * Export of specification attributes, options, product attributes * Unlimited number of custom export templates * Simple and fast configuration of a template * Detailed reports about export results * Exports to FTP, SFTP, server folders, or direct file downloads * Automatic exports by schedule * ACL mapping, Store mapping {% hint style="info" %} In case you encounter an issue, you can contact us via {% endhint %} # Installation process ## Supported versions Currently Export Manager supports following versions of nopCommerce: 4.80, 4.70, 4.60, 4.50. With new releases of nopCommerce we will try to update our plugin as soon as possible. ## Installation After downloading plugin, head to **Configuration** section of your nopCommerce **Admin Pannel**. Select **Local Plugins** page and click on **Upload plugin on theme**. Locate Export Manager ZIP file and upload it to your website. Reload your nopCommerce website and go to the same **Local Plugins** page. Scroll to locate **Export Manager** and click **Install** next to it. After successful installation a **FoxNetSoft** section would appear in your **Admin Panel**. Click on it to reveal **Export Manager** and its settings. ## Configuration Head to **Configuration** page of Import Manager under FoxNetSoft section in Admin Panel. * Input **Serial Number** that you received after your purchase {% hint style="danger" %} Unregistered version would limit your imports to **20 items** with a trial period of **15 days** {% endhint %} {% hint style="info" %} In case you encounter an issue, you can contact us via {% endhint %} # Updating plugin ## Why updating? Although any version of the plugin that was released on our website is fully operational, we constantly add new features and fix existing issues. It is worth to update your plugin in the following scenarios: 1. When you update nopCommerce 2. When you encounter any issues with the plugin 3. A month after a new release of a nopCommerce, even if you are not updating nopCommerce This would ensure that you are using the best version of the plugin. {% hint style="info" %} Updating will not erase any data that you created for your exports {% endhint %} ## Where to download the latest version? You can find the latest version on our plugin page, by clicking Download Trial. Note, if you have bought the plugin, a full version will be downloaded. ## How to update the plugin Process of updating the plugin is exactly the same as the first plugin installation. You can navigate to [this section of documentation](/installation-process#installation). # Templates In order to export any entities using Export Manager you would need to create an Export Template. Head to Templates page under Export Manager section to see your exsisting templates and create new one ## Initializing a template 1. Click on **Add New** in the top right corner to create new template 2. In the **Entity** field select entity that you would like to export with this template. Export Manager offers a variety of entities, including Products, Categories, Attributes, Manufacturers, etc. 3. Input a **Name** for your template. Name serves only informational purpose for you and other administrators of the website. 4. Click on **Save and Continue Edit** to initialize your template. 5. Select file **Format** that will be used for this template. Import Manager supports a variety of file formats: CSV (Comma Separated Value Files), XML, XLSX (Excel Spreadsheets), TXT 6. Input an **export file name**. Exported data will be saved to the file with this name. You do not need to input file extension, only the name. \ You can use the following tokens in the file name for current date and time: %yyyy% - year, %mm% - month, %dd% - day, %hh% - hour, %mi% - minute. 7. If you want the file to be compressed into an archive, check **Compress File** option. 8. In the **Save the feed file** option select appropriate saving method.\ None - file will be downloaded in your browser when you click Export Now.\ Folder - file will be saved to a folder on the server. Input folder path after you select this option.\ FTP/FTPS/SFTP - file will be saved to an FTP/FTPS/SFTP server. Input server details and credentials after you select this option. 9. **Admin Coment** serves only informational purpose to other website administrators about this template and can be left emply. {% hint style="info" %} You can't change entity after initialization of a template {% endhint %}

Template setup

# Filters Filters tab allows you to select only specific categories, manufacturers, vendors, and/or warehouses that will be exported

Filters tab

# Settings Settings tab has following parameters: * Encoding. You can select encoding of your file if you notice that some symbols are exported incorrectly. Unless needed, it's reccomended to have it set to Auto. * Skip first line in the csv/txt/xlsx file.\ If checked, plugin will not add header with column names to the saved file. * Column delimiter. Character that will be used to separate columns in CSV file. * Field enclosure. Character that will be used to enclose every field during export. * DateTime format. For example `yyyy-dd-MM hh:mm tt` or `dd.MM.yyyy hh:mm:ss.` * Decimal delimiter. Character that will be used in decimal numbers. For example, if you select Dot, one and a half will be saved as 1.5\ But if you select Comma, it will be saved as 1,5 # What is ID? ## What is ID ID is a unique identifier of any entity (product, category, attribute, option, etc.) in nopCommerce. IDs are usually hidden from users and admins, as they are used only in databases and code. Import Manager allows users to use these IDs to import different entities. Having control over IDs would give you a more scalable and structurized approach to managing your products. ## Where do I find my ID Let's look at an example of finding an ID for existing product.

List of products in nopCommerce

Here we have list of products in our Admin Panel. Let's find an ID of the first item. **Click on Edit**
You would find ID in the address of the website, as shown on the screenshot. # Column mappings Column mapping serves essential purpose of Export Manager defining the structure of exported file ## Create a column mapping You need to create a column mapping for every column in your spreadsheet that you would like to be exported. Column mappings can be created by column names. Navigate to **Column Mappings** page of your template settings and scroll to **Add new record** section.
**Mapping Entity** is the entity that value belongs to. {% hint style="info" %} Sometimes you might find Mapping Entity have an option for Extra entities. Then you would find Column source to have Custom value parameter. Selecting this column mapping would put a constant value for all exported entries in this column. {% endhint %} **Column source** is the parameter of the entity that will be in this column. **Column destination** is the name of the column in exported file. **Display order** arranges columns in exported file. # ACL Mapping ACL Mapping is used to control permissions for your website ## Column Destinations
Column destinationExplanation
Customer role '<Role Name>'TRUE or FALSE value, whether to allow or remove access for this group of customers.
## Example table This is an example table for ACL Mapping of Product
SKUCustomer role 'Guests'Customer role 'Administrators'
001TRUETRUE
002FALSETRUE
003FALSEFALSE
# Category Category is used to export Categories ## Column Destinations {% hint style="info" %} Altohugh category has many different column destinations, we would describe only ones that have special functionality. {% endhint %}
Column destinationExplanation
Category nameIt will be saved as a full path. For example, Laptops>>Macbook.
PictureURL to a picture on your website.
Discount Name or IDIf your category has multiple discounts they will be saved using | (vertical bar) symbol. Example, 20% off|30% off if category has 20% off and 30% off discounts.
## Example Table
Category NamePictureShow on home page
Laptopshttps://example.com/laptops.pngTRUE
Laptops>>Macbookhttps://example.com/macbook.pngFALSE
Laptops>>Gaminghttps://example.com/gaming_laptops.pngTRUE
# Cross-sell product Cross-sell product is used to export Cross-sell products ## Column Destinations
Column destinationExplanation
Product SKU, ID, or name of the product that cross-sell is applied to.
Product2SKU, ID, or name of the product that is displayed with the product above.
# Localized Values Localized Values templates are used to export different languages from your store There is no special information about this entity. # Manufacturer Manufacturer template is used to export Manufacturers ## Column Destinations {% hint style="info" %} Altohugh manufacturer has many different column destinations, we would describe only ones that have special functionality. {% endhint %}
Column destinationExplanation
PictureURL to a picture on your website.
Discount Name of IDIf your manufacturer has multiple discounts they will be saved using | (vertical bar) symbol. Example, 20% off|30% off if manufacturer has 20% off and 30% off discounts.
## Example Table
Key (Name)PictureDiscount
Dellhttps://example.com/dell.png20% off
Applehttps://example.com/apple.png30$ off
Samsunghttps://example.com/samsung.png10$ off|10% off
# Product Product is used to export Products ## Column Destinations {% hint style="info" %} Altohugh product has many different column destinations, we would describe only ones that have special functionality. {% endhint %}
Column destinationExplanation
PictureURL to a picture on your website. Only one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.
Picture Alt attributeOnly one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.
Picture Title attributeOnly one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.
Picture Display OrderOnly one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.
Category Name or ID

If product exists in multiple categories, they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, Laptops|Macbook if product is in Laptops and Macbook category at the same time.

If you are exporting category name, it will be full category path. For example Laptops>>Macbooks.

Manufacturer Name or IDIf product exists in multiple manufacturers, they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, Apple|Dell if product is in Dell and Apple manufacturers at the same time.
Discount Name or IDIf your product has multiple discounts they will be saved using | (vertical bar) symbol. Example, 20% off|30% off if product has 20% off and 30% off discounts.
Specification Attribute '<Attribute Name>'If your product has multiple options of the same attribute they will be saved using | (vertical bar) symbol.
{% hint style="warning" %} Below you would find some constants that represent different values for some Column Mappings. These values will be used in cells during exports. {% endhint %}
Column DestinationConstants
Product typeFor Simple Product use value 5
For Grouped Product use value 10
BackordersFor No Backorders use value 0
For Allow Qty Below 0 use value 1
For Allow Qty Below 0 And Notify Customer use value 2
Download activation typeFor When Order Is Paid use value 0
For Manualy use value 10
Gift card typeFor Virtual use value 0
For Physical use value 1
Low stock activityFor Nothing use value 0
For Disable Buy Button use value 1
For Unpublish use value 2
Inventory methodFor Dont Manage Stock use value 0
For Manage Stock use value 1
For Manage Stock By Attributes use value 2
Cycle PeriodFor Days use value 0
For Weeks use value 10
For Months use value 20
For Years use value 30
Rental period lengthFor Days use value 0
For Weeks use value 10
For Months use value 20
For Years use value 30
## Example Table
Key (SKU)NamePictureCategory
001_AIPhone 12https://example.com/iphone12.pngPhone>>IPhone
002_AIPhone 13https://example.com/iphone13.pngPhone>>IPhone
003_AIPhone 14https://example.com/iphone14.pngPhone>>IPhone|New Products
004_MMacbook Airhttps://example.com/macbookair.pngLaptops>>Apple
005_MMacbook Prohttps://example.com/macbookpro.pngLaptops>>Apple | Laptops>>High end
# Product Attribute Product Attribute template is used to import Product Attributes There is no special information about this entity. # Product Attribute Combinations Product Attribute Combinations allows to import pictures, prices, etc. for different Product Attribute Combinations There is no special information about this entity. # Product Attribute Mapping Product Attribute Mapping is used to assign Product Attributes to Products ## Column Destinations {% hint style="warning" %} Below you would find some constants that represent different values for some Column Mappings. These values will be used in cells during exports. {% endhint %}
Column DestinationConstants
Control TypeFor Dropdown List use value 1
For Radio List use value 2
For Checkboxes use value 3
For Textbox use value 4
For Multiline Textbox use value 10
For Datepicker use value 20
For File Upload use value 30
For Color Squares use value 40
For Image Squares use value 45
For Readonly Checkboxes use value 50
# Product Attribute Value Product Attribute Value allows to import Values for Product Attributes for a Product There is no special information about this entity. # Product Category mapping Product Category mapping allows to add Categories to existing Products. There is no special information about this entity. # Product Manufacturer mapping Product Manufacturer mapping allows to add Manufacturers to existing Products. There is no special information about this entity. # Product Picture Product Picture allows you to add multiple pictures to your products. A new row will be created for every picture that product has. # Product Specification Attribute Product Specification Attribute is used to assign Specification Attributes to Products ## Column Destinations {% hint style="warning" %} Below you would find some constants that represent different values for some Column Mappings. These values will be used during exports. {% endhint %}
Column DestinationConstants
Attribute TypeFor Option use value 0
For Custom Text use value 10
For Custom HTML Text use value 20
For Hyperlink use value 30
# Product Tag Product Tag allows to add Tags to existing Products. There is no special information about this entity. # Related Product Related product is used to add Related products to your Products ## Column Destinations
Column destinationExplanation
Product SKU, ID, or name of the product that the Product2 is applied to.
Product2SKU, ID, or name of the product that is displayed with the product above.
# Specification Attribute Specification Attribute is used to import or update specification attributes There is no special information about this entity. # Specification Attribute Option Specification Attribute Option is used to add options to specification attributes There is no special information about this entity. # Store Mapping Store Mappnig is used to control permissions for your website ## Column Destinations
Column destinationExplanation
Store '<Store Name>'TRUE or FALSE value, wether to show this product in this store.
# Tier Price Tier Price allows you to set up tier prices for your products There is no special information about this entity. # File Save Options Import Manager support different file sources: uploading a file, direct URLs, server paths or FTP. In this section we would show on how to set up a file source {% hint style="danger" %} **Before specifying File Sources you need to set up** [**Column Mappings**](/column-mappings) **and fully configure your template** {% endhint %} {% hint style="info" %} Usually you would use only one file (we call it feed file) for your imports, the main spreadsheet, CVS, or XML file. But if you need to import pictures, you need to use ZIP files or folders. {% endhint %} {% content-ref url="/pages/nl7RHgiqfPPKtCTQTadh" %} [Direct file download](/file-save-options/direct-file-download) {% endcontent-ref %} {% content-ref url="/pages/6wjGtSlAe3cQMf0oK1EB" %} [Broken mention](broken://pages/6wjGtSlAe3cQMf0oK1EB) {% endcontent-ref %} {% content-ref url="/pages/86m1DKEtUIUKKzLoXIdM" %} [Broken mention](broken://pages/86m1DKEtUIUKKzLoXIdM) {% endcontent-ref %} {% content-ref url="/pages/FcsUDbqGeHNI2HjSccgb" %} [Server folder or file](/file-save-options/server-folder-or-file) {% endcontent-ref %} {% content-ref url="/pages/S855b3DJWI6rWqiBPFto" %} [FTP, SFTP, FTPS](/file-save-options/ftp-sftp-ftps) {% endcontent-ref %} # Direct file download This is the most easiest way to export entities using Export Manager. After you set up your template, just click **Export Now** in top buttons section, and a file will be downloaded. # Server folder or file

File sources section

You can export file(s) from folder on your server. Select **Folder** as File Source and input full path to your folder. * To export to a folder use `C:\SomeFolder\AnotherFolder` {% hint style="warning" %} If you use IIS, make sure that IIS has permission to access this folder on your server {% endhint %} # FTP, SFTP, FTPS

FTP settings

Select **FTP** in Save the feed file, you would see fields to input your FTP credentials and to input path to folder on FTP server. You can use paths similar to [importing folder from server](#server-folder-or-file). After you input your credentials, click on **Check FTP connection** to validate your credentials, and then you can **Save** your template. # Scheduling exports Export Manager allows users to schedule exports. If you schedule export of a given template, it would execute at this time. {% hint style="danger" %} You can schedule exports if you save the feed file to server folder or FTP/FTPS/SFTP. {% endhint %} ## When is this useful You can set up automatic imports into other software solutions that you use for e-commerce and enable scheduled exports in Export Manager. So, if you add a product in your store place, it would automatically import to other platform. This tool provides endless spectrum of automation that you can perform. ## How to schedule an export In order to schedule an export you should go to **Scedule Settings** tab of your export template.

Schedule Settings tab

Enable Scheduler Select times and weekdays that you would like your export to run, and click Save Now your export will run automatically at the given time and day