Export & Import URL Rewrites for Magento 2
Introduction
The extension allows to export and import URL Rewrites. Save time on transferring url rewrites between Magento 2 installations.
Installation
The extension has 2 separate ways of installation, via Composer or by copying the code.
Please follow this Installation Guide to install the extension.
Export and Import URL Rewrites
Configuration Settings
To access the configuration settings for this extension, log into the Magento Admin panel and go to STORES ⟶ Configuration ⟶ ULMOD EXTENSIONS ⟶ Export/Import URL Rewrites.
In the General -> Export section:
Max rewrite URL per file: enter the max number of URL rewrite a file should contain. Eg. if 100 is entered and if the total URLs rewrites to export are 300, the export will split into three separate rewrites file with 100 URLs per file.
In the General -> Import section:
Skip missing target path error: if yes, the extension will skip all error on entries with no target path
In the History section:
Log all URL Rewrites Export History - set to "Yes", to log all URL Rewrites export history in the admin panel, all history will appear under SYSTEM → Export/Import URL Rewrites by Ulmod → Export URL Rewrites History. Set to "No" if you do not want to log all URL Rewrites export history
Auto-Clear URL Rewrites Export History After X Days - enter the number of days to automatically clear URL Rewrites export history. Eg. 30. If you do not want to clear the URL Rewrites export history automatically, set this to 0.
Export URL Rewrites
The extension allows store administrators to export cms in the admin panel. To export cms, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ Export/Import URL Rewrites by Ulmod ⟶ Export URL Rewrites.
In the Entity Type select the "URL Rewrites" entity.
In the Export Type field, select the type to export:
- If "All" is selected, all rewrites items will be exported;
- If "Entity" is selected, in the "Entity Type" field, choose the entity type to export: CMS, Category and Product;
- If "Redirect" is selected, in the "Entity Type" field, choose the redirect type to export: 301 or 302;
- If "Store View" is selected, in the "Entity Type" field, choose the store view to export
Click the Export URL Rewrites button to export. The URL rewrites will be exported to a CSV file(s). If the Max rewrite URL per file configured is reached, the extension will split the exported URL rewrites into separate files, each file contains the max rewrites configured.
Import URL Rewrites
To import cms, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ Export/Import URL Rewrites by Ulmod ⟶ Import URL Rewrites.
Under "Import Settings" section:
set Entity Type to "URL Rewrites"
Click Download Sample File to download the sample URL Rewrites import file. Check the structure of the sample URL Rewrites import file and use it to prepare your CSV import file.
- Please edit the CSV file to import on google docs or similar tools. If you edit on google docs, make sure to download as CSV (File ⟶ Download as ⟶ Comma-separated values(.csv, current sheet))
- The export file has 2 columns (url_rewrite_id,is_autogenerated) more than the import file. To import back your exported CSV file into Magento admin panel, please make sure to delete these 2 columns: "url_rewrite_id ,is_autogenerated" (eg. http://prntscr.com/stoqzn) before re-importing back. You can also download our Sample Import file to check the structure of the URL Rewrites import file and use it to prepare your CSV import file.
Under "Import Behavior" section:
Import Behavior selects the import behavior:
- Add/Update: this setting adds new URL Rewrites from the import file to the database. If the URL rewrite already exists in the database and has the same request_path as the one from the import file, the URL rewrite will be updated
- Replace: this setting delete existing URL rewrites (per request_path) from the database, and add the new URL rewrites from the import file. If the request_path does not exist in the database, the extension will add a new URL rewrite
- Delete: this setting delete in the database any URL rewrite (per request_path) from the import file
Validation Strategy choose to "Stop on Error" or "Skip error entries" when an error is encountered when importing data
Allowed Errors Count enters the number of errors that can occur before the URL rewrite import is stopped.
Specify the Field separator and Multiple value separator. A comma is the default separator in a CSV file. If you want to use a different character, make sure that the data in the CSV file matches the character that you specify.
select the Fields Enclosure checkbox, if you want to enclose any special characters that might be found in the data as an escape sequence.
Under "File to Import" section :
Click Choose File to select the URL Rewrites file to import. Make sure the file is saved in UTF-8 encoding for proper import
click Check Data in the upper-right corner to validate the CSV file. Wait a few moments for the validation process to complete. If the CSV file is valid, the following message appears:
If the CSV file is valid, click Import to import the file. Otherwise, correct each error is listed in the validation result, and try to import the CSV file again.
When the import is complete, a message appears. Example of a successful import
Import URL Rewrites Note:
- Please edit the CSV file to import on google docs or similar tools. If you edit on google docs, make sure to download as CSV (File ⟶ Download as ⟶ Comma-separated values(.csv, current sheet))
- The export file has 2 columns (url_rewrite_id,is_autogenerated) more than the import file. To import back your exported CSV file into Magento admin panel, please make sure to delete these 2 columns: "url_rewrite_id ,is_autogenerated" (eg. http://prntscr.com/stoqzn) before re-importing back. You can also download our Sample Import file to check the structure of the URL Rewrites import file and use it to prepare your CSV import file.
Export URL Rewrites History
To access the URL Rewrites export history, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ Export/Import URL Rewrites by Ulmod ⟶ Export URL Rewrites History.
You can choose the column to show or hide on the grid and filters log by export date, admin username, file name, attribute set, execution time, status, and message
To delete/clear all export history manually, click the "Delete All Export Logs" button, all history is deleted
Extension Support
Need Help?
Ulmod Support team is always ready to assist you, no matter which part of the world you are in. If something does happen and you think you might be experiencing an issue or bug, please contact us via [email protected] or submit a ticket from our Helpdesk Ticket and we will help you out.
Got Questions?
Should you have any questions or feature suggestions, please Contact Us. Your feedback is welcome!