Product URL rewrites

Pacemaker Import Community provides the command import:products:url command for the product URL rewrite import.

The individual parts of the file name must match the pattern as followed:
<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>
<IMPORT-DIRECTORY>:

is by default the loation of your working directory <ROOT-DIRECTORY>/var/pacemaker/import/

PREFIX:

The <PREFIX> of the import filename represents the url-rewrite area.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the import filename between <PREFIX> and <FILENAME> is a underscore ( _ ).

FILENAME:

The filename is a autogenerated combination of date and time.

  • As a result, the filename look like url-rewrite_20190608-114344_01.csv.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the structured filename between <FILENAME> and <COUNTER> is underscore ( _ ).

COUNTER:

is a incremental number with two digits starting with 01.

SUFFIX (filename extension):

The Pacemaker Import Community uses the <SUFFIX> .csv as default for the import files.

.OK file:
Bunch import:
  • The Bunch import requires the same predefined filename structure as described.

Your CSV file var/pacemaker/import/url-rewrite_20190608-114344_01.csv is now ready for import.

Columns

The CSV file with the attributes for Magento 2 CE/EE consists of the following columns
Column Name Type Example Description

sku

varchar

24-MB01

Product SKU to import the tier price

store_view_code

varchar

default

Store(s) view-specific attribute translations

  • If blank, the row contains the data for the admin store view

categories

varchar

Default Category/Gear,Default Category/Gear/Bags

Comma ( , ) separated list of categories for URL rewrites to get created

product_websites

varchar

base

Comma ( , ) separated list of website codes for URL rewrites to get created

Example:

visibility

varchar

Catalog, Search

Product Visibility

  • URL rewrites are not created for the Not Visible Individually value

url_key

varchar

joust-duffle-bag

URL key used to create the URL rewrite

Product URL rewrites get imported with the entire product import as default.

see the documentation for products.