Import Shipping Classes Data

fmShippingClassesfmImportExpressionEditor

1. Launch the Import Wizard tool to be able to update or add new shipping classes data to the existing list. You can find this option in the "Shipping Classes" section of Store Manager.

Import data options

2. Choose the file you want to import by using the one of the following sources:

Specify file to import
  • "Local file" - choose the file in your drive system by using the browse button.
  • From external source - use the full URL path to the file. Make sure the path is acceptable and workable in your browser.
HTTP URL to a file
  • From a FTP server - specify the FTP access details and path to the file on FTP.
FTP URL to a file

Before proceeding, verify your FTP credentials in "Preferences" of Store Manager by choosing the necessary tab:

FTP correctness

"Load configuration" allows to upload the necessary configuration from the list, or from a file, and use it during the current import procedure.

Open configuration area

If you need to clear the list from unused or outdated configurations, choose the one of the following option from the drop-down (see an illustration above).

3. Delimiter step allows to check the main formats of field values separators that are used to delineate data between one another.

File to import may comprise the values as well as field names in the first row.

  • Values in the first row:
Values in the first row
  • Field names in the first row:
Field names in first row

According to this, you can select/unselect the field, as shown below:

First row checkbox

4. Move to the next step of importing and assign the necessary columns from a file with the corresponding fields of your store database.

Linking step

Use an arrow options in the "Source" field columns to assign the necessary position from the left pane with the corresoinding field from the right.

The expression column allows to modify imported data by using the special SQL statement.

Launch Expression Editor form

Press [SQL Help] to get the integrated online help on main expression components and their implementation.

SQL Help button

"Skip Rules" - the area, where you can specify conditions, under which the data set forth in this rule will not be processed (will be skipped during import).

Skip Rules area

On the top toolbar you can choose the button to facilitate the linking process - [Auto Link All], or cancel previously assigns at once - [Unlink All].

Auto Link/ Unlink All options

You can also perform the automatic selection for the highlighted field(s) with the option from the top toolbar.

Auto Link selected positions

As well as, unlink only selected position(s):

Unlink selected positions

The "Custom SQL" area. The special SQL formula affects the data within your store database directly, but requires some skills in SQL language queries and commands operations.

For example, the formula leads to the increasing quantities for items of a specific manufacturer or delete discounts that were previously applied to the products specified in the file to import etc.

Custom SQL area

Use the [SQL Help] button from the top toolbar, or look through the Custom SQL chapter, to get more information about the technique of creating such formula.

5. Move to the next step of import procedure and choose the one of the following method:

  • "Add and Modify" will add new records, if they are not already in the database, and modify existing data that was found.
  • "Add Only" will only add NEW positions.
  • "Modify Only" will only update Existing shipping classes data, but not add new entries, even if the shipping classes do not currently exist in the database.
  • "Just Add" - Please note, this option may produce duplicate data entries, since Store Manager will not try to find, or validate existing information, but will add all records, as if they are new!
Import Method step

[Show Advanced Options] opens additional fields with the main formats of date and numbers values. In most cases, it is recommended to leave these settings unchanged.

Start / End row of importing

To check what data will be transferred before start importing, use the button for preview:

Preview step of importing

6. Note, the [Import] button starts transferring.

Summary results are available on the last step of the wizard.

Summary results of importing
data were inserted

< - Means that any new record was not entered into the database.

data were updated

< - Means that 2 entries that already exist in the store database were successfully updated after import.

data were skipped

< - Means that no rule was applied in the current process.

file rows were not skipped

< - Means that all lines (rows) of the import file are imported.

Take into account the [Save configuration] button. You can save current configuration to be able to upload it during the next usage of the Shipping Classes Import wizard.

Save Configuration to a File

The [Finish (Page down)] button closes the wizard and allows to return back to work in Store Manager.