Importing Data

SmithCart > Integration > Import

Importing and exporting allows you to quickly add/update data in your store. From updating new products to integrating with third-party services, these features allow you harness the power of SmithCart.

Click Here for a CSV Import file examples

Contents



Introduction

From the SmithCart Import Menu, SmithCart provides the ability to import data for the following entities:

To access the SmithCart Import menu, click the Import option from the Store Admin Menu.

The following image is a screenshot of the SmithCart Import Menu:

Each entitiy is avaiable to be imported from this screen.

[up to contents]



Import Checklist

Before importing the data, please go through the following checklist:

  1. Permission
    Make sure you have the access and permissons to Import data. If you do not have the permissions, the Import link will be hidden in your User interface.
  2. File Format
    The files to be imported must be in a CSV (comma separated values) file format with the exception of the Endicia XML Import. It must be an ASCII file with a .csv extension in the Windows environment where each line of text represents a single record. All file attachments should be separated from the data.
    Unexpected errors may occur if the files contain any special controls such as combo filters or images embedded in it.
  3. Forbidden Characters
    If the data is coming from a database other than sql server like a unix platform, mainframe or vsam/isam files the data is most likely stored in a different data format and when exported could include characters that may not be visible in ascii so make sure your data is clean of any special characters before importing. Categories
  4. Required Fields
    The required fields must contain a value. Make sure you do not leave the mandatory fields blank, in the import file. For instance, when you are importing Customer information, each Customer record must include an FirstName, LastName, Address1, City, Country, State, Zip, Email, and DNNLogin. The File Field Specification in each Import KB shows the required fields. Do not proceed to the next step without the mandatory fields.
  5. Check box Data
    Make sure that the data you plan to import from Boolean or check box fields contain values that will properly convert during the import process.
    Imported data from Boolean and check box fields are converted as follows:
    • If check box is selected - True or 1
    • If check box is not selected - False or 0
  6. Drop-down List
    All data values displayed in the drop-down lists must exist in the corresponding SmithCart fields.
    For instance, if you plan to import Variants that contains a value for the "Price Type" dropdown list, before you import, make sure all the Price Type values in the source file already appear in the drop-down list. If the values do not exist, you must either change the values in the source file to match the existing values in SmithCart.
  7. Field Names
    Make sure the first row of data (records) in the source file contains the column headings or field names rather than the actual data values. These heading field name values help identify the data.
  8. File Size
    Make sure the file size (Import data) does not exceed the DNN maximum file upload size limit.

[up to contents]



Running the Import

To import data take the following steps:

Step 1: Choose Import type

Click the Import [Type] tab at the top of the page..
Type refers to the tabs like Product, Customer, Order, etc.

Step 2: Choose a File

From the Import [Type] screen click the Browse button.

Step 3: Select a File Name

Navigate to the file you want to import, and click Open.

Step 4: Select Import Options

Check the checkbox titled First Row Includes Column Headers if the first row of you data includes column headers.

Next, select the delimiter you used to separate fields in your input file. Pipe and Comma are supported delimiters. It is recommended that you use the “Pipe” delimiter as the pipe delimiter has a lower chance of showing up in the actual data fields you are importing, thus increasing the likelihood that your input file will be successfully imported.

Step 5: Import Now

To import the selected spreadsheet, click the Import Now button to upload the file

When the import is complete, a message stating that the import was successful is displayed.

Note that this process may take several minutes, depending on the number of records to be imported. You should also allow time for the data to be processed.

After you have imported, the data will be displayed in the designated Manage [Type] section of the Store Admin Menu.

[up to contents]