Difference between revisions of "X-Cart:Importing and Exporting Data"

From X-Cart 4 Classic
Jump to: navigation, search
(Import/Export procedures in X-Cart)
m (Import procedure)
 
(19 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
== Import/Export procedures in X-Cart ==
 
== Import/Export procedures in X-Cart ==
  
X-Cart 4.3.x features export and import of almost all X-Cart data types. Export and import procedures facilitate the updating of your store data and allow you to consistently transfer data when upgrading your store or moving it to a new location.
+
X-Cart 4.4.x features exporting and importing literally all types of data used in X-Cart. The export and import procedures facilitate the updates of your store data and ensure the consistent transfer of the data when upgrading the store or moving it to a new location.
  
Basic information on export procedures is available in the section [[#Exporting Data | Exporting Data]], import procedures - in the section [[#Importing Data | Importing Data]].
+
The basics of the export procedures are available in the [[#Exporting Data | Exporting Data]] section; for the import procedures - in the [[#Importing Data | Importing Data]] section.
  
Detailed information on X-Cart import and export can be found in the [[X-Cart:Import-Export_Guide | Import/Export Guide]]
+
The detailed information on X-Cart's import and export features can be found in the [[X-Cart:Import-Export_Guide | Import/Export Guide]]
  
 
== Roles in Import/Export management ==
 
== Roles in Import/Export management ==
  
If you are an X-Cart GOLD administrator/provider, you can import and export:
+
If you are an X-Cart GOLD or GOLD PLUS administrator/provider, you can import and export:
  
* config data,
+
* Config data
* states,
+
* States
* users,
+
* Users
* categories (including international category descriptions),
+
* Categories (including international category descriptions)
* products (including international product descriptions, featured products and product links),
+
* Products (including international product descriptions, featured products and product links)
* destination zones,
+
* Destination zones
* taxes (including tax rates),
+
* Taxes (including tax rates)
* shipping rates,
+
* Shipping rates
* orders (export only, including order items),
+
* Orders (export only, including order items)
* other types of data (depending on the set of enabled modules and add-ons).
+
* Other types of data (depending on the set of enabled modules and add-ons).
  
If you are an X-Cart PRO administrator, you can import and export all types of X-Cart data:
+
If you are an X-Cart PLATINUM or PRO administrator, you can import or export all types of data used in X-Cart:
  
* config data,
+
* Config data
* states,
+
* States
* users,
+
* Users
* categories (including international category descriptions),
+
* Categories (including international category descriptions)
* products (including international product descriptions, featured products and product links),
+
* Products (including international product descriptions, featured products and product links)
* destination zones,
+
* Destination zones
* taxes (including tax rates),
+
* Taxes (including tax rates)
* shipping rates,
+
* Shipping rates
* orders (export only, including order items),
+
* Orders (export only, including order items)
* other types of data (depending on the set of enabled modules and add-ons).
+
* Other types of data (depending on the set of enabled modules and add-ons).
  
{{Note|when exporting products, destination zones, tax rates, shipping rates and orders, it is possible to export all data or just the data of a specific provider. Also note that these types of data can only be imported specifically for different providers (which means that before importing you will be supposed to specify the name of the provider for whom you are importing the data).}}
+
{{Note|When exporting products, destination zones, tax rates, shipping rates or orders, you can export all data or just the data of a specific provider. Also, please note that these types of data can be imported for different providers only (i.e. you will be expected to specify the name of the provider you are importing the data for before starting the import).}}
  
If you are an X-Cart PRO provider, you can import and export:
+
If you are an X-Cart PLATINUM or PRO provider, you can import or export:
  
* your products (including international product descriptions and product links),
+
* Your products (including international product descriptions and product links)
* your destination zones,
+
* Your destination zones
* your tax rates,
+
* Your tax rates
* your shipping rates,
+
* Your shipping rates
* your orders (export only, including order items),
+
* Your orders (export only, including order items)
* other types of data according to your access privileges (depending on the set of enabled modules and add-ons).
+
* Other types of data according to your access privileges (depending on the set of enabled modules and add-ons).
  
 
==Exporting Data==
 
==Exporting Data==
  
Export of X-Cart data can be performed using the 'Export data' section of your store's back end.
+
{{XC 4.4}}
 +
 
 +
You can export the data from your X-Cart store in the 'Export data' section of your store's admin area.
  
 
'''To access this section:'''
 
'''To access this section:'''
  
# Go to the '<u>Import/export data</u>' section of your store's back end: click the link <u>Import/Export</u> in the <u>Management menu</u>.
+
# Go to the '<u>Import/export data</u>' section of your store's Admin area. In X-Cart versions 4.4.0 and later, this section can be found at Tools menu -> Import/Export; in X-Cart 4.3.x, this section can be found at Management menu -> Import/Export; in earlier versions, this section can be found at Administration menu -> Import/Export.
# In the '<u>Import/export data</u>' section menu, click the link <u>Export data</u>.<br><br>The '<u>Export data</u>' section looks something like this (with the reservation that the section [+] Select provider is available only to X-Cart PRO administrators, and the set of data types available for exporting varies on the type of user account being used):<br><br>[[Image:export.gif|530px]]<br><br>
+
# On the menu at the right side of the '<u>Import/export data</u>' section, click the <u>Export data</u> link.
 +
 
 +
The '<u>Export data</u>' section looks like this:<br><br>[[Image:export.gif]]<br>However, the section [+] Select provider is available only to X-Cart PLATINUM/PRO administrators, and the set of data types available for exporting varies depending on the type of user account being used.<br>
  
 
'''To export data to a CSV file:'''
 
'''To export data to a CSV file:'''
  
# Use the settings of the '<u>Export data</u>' dialog box to specify, what data you wish to be exported and how you wish that to be done:
+
# Use the settings of the '<u>Export data</u>' form to specify, what data you wish to be exported, and how you wish that to be done:
#* (If you are an X-Cart PRO administrator) If you wish to export not all the data, but just the data of a specific provider, specify the username of the provider whose data you wish to export: expand the '<u>Select provider</u>' subsection of the <u>'Export</u> <u>data</u>' dialog box by clicking the [+] Select provider link, enter the username of the provider into the appropriate field and click the '''Go''' button.
+
#* (If you are an X-Cart PLATINUM or PRO administrator) If you wish to export not all the data, but just the data of a specific provider, specify the username of the provider, whose data you wish to export: expand the '<u>Select provider</u>' subsection of the <u>'Export</u> <u>data</u>' form by clicking on the [+] Select provider link, enter the username of the provider in the corresponding field and then click the '''Go''' button.
#* Use the '<u>CSV delimiter</u>' drop-down box to select a delimiter that you wish to be used in the resulting CSV file (Semicolon, Comma, Tab).
+
#* Use the '<u>CSV delimiter</u>' drop-down box to select the delimiter you wish to be used in the resulting CSV file (Semicolon, Comma, Tab).
#* If you wish the export spreadsheet to be split into several portions (each in a separate file), use the '<u>Data rows per file</u>' field to specify the maximum number of data rows which may be contained in one file. Leave the field empty or enter 0 (zero) if you do not want to split the export file.
+
#* If you wish the export spreadsheet to be split into several parts (each in a separate file), use the '<u>Data rows per file</u>' field to specify the maximum number of data rows that can be contained in one file. Leave the field empty or enter 0 (zero) if you do not want to split the export file.
#* Specify, whether you wish to export images (Yes/No).
+
#* Specify whether you wish to export images (Yes/No).
#* Use the field <u>'Category path separator for "category" field</u>' to type in a character or a sequence of characters that you wish to be used as the '<u>category</u>' field separator in the export CSV file. You can use any character or sequence of characters that does not occur in the category names.
+
#* Use the field <u>'Category path separator for "category" field</u>' to type in the character or sequence of characters that you wish to be used as the '<u>category</u>' field separator in the export CSV file. You can use any character or sequence of characters that does not occur in the category names.
 
#* Select the data that needs to be exported:
 
#* Select the data that needs to be exported:
 
#** If you are going to export USERS, PRODUCTS or ORDERS, adjust the respective data ranges (use the links in the RANGE column).
 
#** If you are going to export USERS, PRODUCTS or ORDERS, adjust the respective data ranges (use the links in the RANGE column).
 
#** Select the types of data that need to be exported (select the check boxes next to the names of these types).
 
#** Select the types of data that need to be exported (select the check boxes next to the names of these types).
# Click the '''Export''' button at the bottom of the '<u>Export data</u>' dialog box. X-Cart should start exporting the data. Export packs will be saved to the directory <u>/</u>xcart<u>/var/tmp</u>.<br>As soon as the export process is completed, you should see an Information box with a confirmation message and a link to the export packs.
+
# Click the '''Export''' button at the bottom of the '<u>Export data</u>' form. X-Cart should now start exporting the data. The export packs will be saved to the <u>/xcart/var/tmp</u> directory.<br>When the export process is over, you will see an information box with a confirmation message and the link to the export packs.
# Click the Export packs link in the Information box or scroll down to the bottom of the '<u>Export data</u>' section. You should see a new subsection in the '<u>Export data</u>' dialog box - '<u>Export packs</u>' - listing the CSV files created as a result of exporting procedure.
+
# Click on the Export packs link in the Information box or scroll down to the bottom of the '<u>Export data</u>' section. On the '<u>Export data</u>' form, you will see a new subsection '<u>Export packs</u>', which lists the CSV files you have just created with the exporting procedure.
# Download the export pack files onto your local machine by clicking the filename links.
+
# Download the export pack files to your local computer by clicking on the filename links.
  
If you wish to remove export packs from the directory to which they are saved by X-Cart (<u>/</u>xcart<u>/var/tmp</u>), you can delete them using X-Cart interface.
+
If you wish to remove the export packs from the directory where they were saved by X-Cart, (<u>/</u>xcart<u>/var/tmp</u>), you can delete them through the X-Cart interface.
  
 
'''To delete export packs:'''
 
'''To delete export packs:'''
  
# Expand the '<u>Export packs</u>' subsection of the '<u>Export data</u>' dialog box.
+
# Expand the '<u>Export packs</u>' subsection of the '<u>Export data</u>' form.
# Select the check boxes next to the export packs that need to be removed.
+
# Select the check boxes next to the export packs that need to be deleted.
# Click the '''Delete selected''' button. The selected export packs should be removed. You should see an Information box with a confirmation message.
+
# Click the '''Delete selected''' button. The selected export packs should be deleted. You will see an information box with the confirmation message.
 +
 
 +
'''See also''':
 +
* [[X-Cart:FAQs#How_do_I_export_users_with_passwords_decrypted.3F | X-Cart FAQ: How do I export users with passwords decrypted?]]
  
 
==Importing Data==
 
==Importing Data==
  
Import of X-Cart data can be performed using the '<u>Import data</u>' section of your store's back end.
+
{{XC 4.4}}
 +
 
 +
You can import the data from your X-Cart store in the '<u>Import data</u>' section of your store's admin area.
 +
 
 +
'''To access this section:'''
 +
 
 +
1. Go to the '<u>Import/export data</u>' section of your store's admin Area. In X-Cart versions 4.4.0 and later, this section can be found at Tools menu -> Import/Export; in X-Cart 4.3.x, this section can be found at Management menu -> Import/Export; in earlier versions, this section can be found at Administration menu -> Import/Export.
 +
 
 +
2. On the menu to the right of the '<u>Import/export data</u>' section, click on the <u>Import data</u> link.
 +
 
 +
=== Import procedure ===
 +
 
 +
The <u>'Import data</u>' section looks like this:<br>[[Image:import.gif]]<br>However, the section [+] Select provider is available only to X-Cart PLATINUM and PRO administrators, and the set of data types available for importing varies depending on the type of user account being used).<br>
 +
 
 +
'''To import data to X-Cart''':
 +
 
 +
1. Prepare the CSV file to be imported.
 +
 
 +
Make sure of the following:
 +
* The charset of the file to be imported matches the [[X-Cart:Import-Export_Troubleshooting#.22During_CSV_import.2C_data_gets_truncated_after_special_characters_or_is_not_imported_at_all._.2F_Language_file_import_does_not_work_correctly..22|system locale]].
 +
* The file contains all the required fields (see the table in the '<u>Import options</u>' section of the <u>'Import data</u>' form — click on the plus sign).
 +
* The types of the data to be imported are listed in the table (if not, check whether the respective modules/add-ons that use the data types are enabled).
 +
 
 +
2. Use the options of the '<u>Import data</u>' section to specify the data to be imported and the import method:
 +
 
 +
{{Note|<b>X-Cart PLATINUM/PRO administrators!</b> Certain types of X-Cart data (like PRODUCTS, SHIPPING RATES, TAX RATES, etc.) do not appear in the table and cannot be imported without specifying the provider the data belongs to. When importing provider specific data, be sure to enter the data owner's username in the corresponding fields of the '<u>Select provider</u>' section.}}
 +
 
 +
3. Use the '<u>CSV delimiter</u>' drop-down box to select the delimiter used in the CSV file you are going to import (Semicolon, Comma or Tab.
 +
 
 +
4. Specify the source of the import file, i.e. where the file is located physically. That can be the server running your X-Cart store, your local computer or some web-accessible location (Server, Home computer, URL). Depending on the selected source, provide the file path or URL.
 +
 
 +
5. Expand the '<u>Import options</u>' section by clicking on the <u>[+] Import options</u> link and adjust the settings in this section as described below.
 +
 
 +
6. Click the '''Import''' button at the bottom of the ''''Import data'''' form.
 +
 
 +
X-Cart should now start importing the data.
 +
 
 +
When the import process is over, you will see the respective confirmation message.
 +
 
 +
=== Import options ===
 +
 
 +
You can make additional settings by expanding the <u>[+]Import options</u> link and adjusting the required parameters:
  
To access this section:
+
* If you are importing products, set the <u>Default category</u> (a category where your products will go if you have not specified a category in the 'Category' column.  Just skip this field if you have specified the category in your CSV file).
  
# Go to the '<u>Import/export data</u>' section of your store's back end: click the link <u>Import/Export</u> in the <u>Management menu</u>.
+
* If you are importing users, specify, whether customer passwords are encrypted (Yes/No).
# In the '<u>Import/export data</u>' section menu, click the link <u>Import data</u>.<br><br>The <u>'Import data</u>' section looks like this (with the reservation that the section [+] Select provider is available only to X-Cart PRO administrators, and the set of data types available for importing varies depending on the type of user account being used):<br><br>[[Image:import.gif|520px]]
 
  
To import data into X-Cart:
+
* If your CSV file mentions subcategories (e.g., if some of the products being imported go into subcategories), make sure that the <u>Category path separator for "category" field</u> in the '<u>Import options</u>' section matches the separator in your CSV file.
  
# Prepare a CSV file for import. Make sure it contains all the necessary required fields (For a list of fields that are required for a specific data type, refer to the table in the '<u>Import options</u>' section of the <u>'Import data</u>' dialog box (accessible by clicking the link [+]Import options). Make sure the types of data you are going to import are listed in the table (If not, ensure that the modules/add-ons that use these types of data are enabled).
+
* If you are importing images (thumbnail images, product images, category icons, etc.) and wish to import them from a single directory, specify that directory in <u>Directory where images are located</u>.
# Use the settings of the '<u>Import data</u>' dialog box to specify, what data you wish to be imported and how you wish that to be done:
 
#* (If you are an X-Cart PRO administrator) Certain types of X-Cart data (like PRODUCTS, SHIPPING RATES, TAX RATES, etc) are not displayed and cannot be imported without an indication of which provider they belong to. If you are importing provider-specific data, be sure to specify the username of their owner: expand the '<u>Select provider</u>' subsection of the '<u>Import data</u>' dialog box by clicking the [+] Select provider link, enter the username of the provider into the appropriate field and click the '''Go''' button.
 
#* Use the '<u>CSV delimiter</u>' drop-down box to select a delimiter that is used in the CSV file which you are going to import (Semicolon, Comma, Tab).
 
#* Specify the source of the import file:
 
#** Select the appropriate radio button to specify, whether the CSV file is located on the server where your X-Cart is installed, on your local machine or some web-accessible location (Server, Home computer, URL).
 
#** Depending on the location selected, provide a file path or a URL.
 
#* Expand the section '<u>Import options</u>' by clicking the [+] Import options link and adjust the settings in this section:
 
#** If you are importing users, specify, whether customer passwords are encrypted (Yes/No).
 
#** If you are importing products, set the <u>Default category</u> (a category where your products will go if you did not specify a category in the 'Category' column.  Just leave this field alone if you have specified a category in your CSV file).
 
#** If your CSV file contains mention of subcategories (for example, if some of the products being imported will go to subcategories), make sure the <u>Category path separator for "category" field</u> specified in the '<u>Import options</u>' section is exactly the same as the separator used in your CSV file.
 
#** If you are importing images (thumbnail images, product images, category icons, etc) and wish to import them from a single directory, specify this directory as <u>Directory where images are located</u>.
 
#** If your store database already contains data of the types that you are going to import, and you wish to drop this data before importing data from your spreadsheet, select the DROP check boxes next to the names of data types that need to be dropped. (If you do not select any check boxes, the data from your spreadsheet will simply be added to the database).
 
# Click the '''Import''' button at the bottom of the ''''Import data'''' dialog box. X-Cart should start importing the data.
 
  
As soon as the import process is completed, you should see an Information box with a confirmation message.
+
* If your store's database already contains data of the types that you are going to import, and you wish to drop that data before importing data from your spreadsheet, select the DROP check boxes next to the data types that need to be dropped. (If you do not select any of the check boxes, the data from your spreadsheet will simply be added to the database).
  
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart user manual]]

Latest revision as of 14:40, 6 August 2013

Import/Export procedures in X-Cart

X-Cart 4.4.x features exporting and importing literally all types of data used in X-Cart. The export and import procedures facilitate the updates of your store data and ensure the consistent transfer of the data when upgrading the store or moving it to a new location.

The basics of the export procedures are available in the Exporting Data section; for the import procedures - in the Importing Data section.

The detailed information on X-Cart's import and export features can be found in the Import/Export Guide

Roles in Import/Export management

If you are an X-Cart GOLD or GOLD PLUS administrator/provider, you can import and export:

  • Config data
  • States
  • Users
  • Categories (including international category descriptions)
  • Products (including international product descriptions, featured products and product links)
  • Destination zones
  • Taxes (including tax rates)
  • Shipping rates
  • Orders (export only, including order items)
  • Other types of data (depending on the set of enabled modules and add-ons).

If you are an X-Cart PLATINUM or PRO administrator, you can import or export all types of data used in X-Cart:

  • Config data
  • States
  • Users
  • Categories (including international category descriptions)
  • Products (including international product descriptions, featured products and product links)
  • Destination zones
  • Taxes (including tax rates)
  • Shipping rates
  • Orders (export only, including order items)
  • Other types of data (depending on the set of enabled modules and add-ons).
Note: When exporting products, destination zones, tax rates, shipping rates or orders, you can export all data or just the data of a specific provider. Also, please note that these types of data can be imported for different providers only (i.e. you will be expected to specify the name of the provider you are importing the data for before starting the import).

If you are an X-Cart PLATINUM or PRO provider, you can import or export:

  • Your products (including international product descriptions and product links)
  • Your destination zones
  • Your tax rates
  • Your shipping rates
  • Your orders (export only, including order items)
  • Other types of data according to your access privileges (depending on the set of enabled modules and add-ons).

Exporting Data

X-Cart 4.4or above

You can export the data from your X-Cart store in the 'Export data' section of your store's admin area.

To access this section:

  1. Go to the 'Import/export data' section of your store's Admin area. In X-Cart versions 4.4.0 and later, this section can be found at Tools menu -> Import/Export; in X-Cart 4.3.x, this section can be found at Management menu -> Import/Export; in earlier versions, this section can be found at Administration menu -> Import/Export.
  2. On the menu at the right side of the 'Import/export data' section, click the Export data link.

The 'Export data' section looks like this:

Export.gif
However, the section [+] Select provider is available only to X-Cart PLATINUM/PRO administrators, and the set of data types available for exporting varies depending on the type of user account being used.

To export data to a CSV file:

  1. Use the settings of the 'Export data' form to specify, what data you wish to be exported, and how you wish that to be done:
    • (If you are an X-Cart PLATINUM or PRO administrator) If you wish to export not all the data, but just the data of a specific provider, specify the username of the provider, whose data you wish to export: expand the 'Select provider' subsection of the 'Export data' form by clicking on the [+] Select provider link, enter the username of the provider in the corresponding field and then click the Go button.
    • Use the 'CSV delimiter' drop-down box to select the delimiter you wish to be used in the resulting CSV file (Semicolon, Comma, Tab).
    • If you wish the export spreadsheet to be split into several parts (each in a separate file), use the 'Data rows per file' field to specify the maximum number of data rows that can be contained in one file. Leave the field empty or enter 0 (zero) if you do not want to split the export file.
    • Specify whether you wish to export images (Yes/No).
    • Use the field 'Category path separator for "category" field' to type in the character or sequence of characters that you wish to be used as the 'category' field separator in the export CSV file. You can use any character or sequence of characters that does not occur in the category names.
    • Select the data that needs to be exported:
      • If you are going to export USERS, PRODUCTS or ORDERS, adjust the respective data ranges (use the links in the RANGE column).
      • Select the types of data that need to be exported (select the check boxes next to the names of these types).
  2. Click the Export button at the bottom of the 'Export data' form. X-Cart should now start exporting the data. The export packs will be saved to the /xcart/var/tmp directory.
    When the export process is over, you will see an information box with a confirmation message and the link to the export packs.
  3. Click on the Export packs link in the Information box or scroll down to the bottom of the 'Export data' section. On the 'Export data' form, you will see a new subsection 'Export packs', which lists the CSV files you have just created with the exporting procedure.
  4. Download the export pack files to your local computer by clicking on the filename links.

If you wish to remove the export packs from the directory where they were saved by X-Cart, (/xcart/var/tmp), you can delete them through the X-Cart interface.

To delete export packs:

  1. Expand the 'Export packs' subsection of the 'Export data' form.
  2. Select the check boxes next to the export packs that need to be deleted.
  3. Click the Delete selected button. The selected export packs should be deleted. You will see an information box with the confirmation message.

See also:

Importing Data

X-Cart 4.4or above

You can import the data from your X-Cart store in the 'Import data' section of your store's admin area.

To access this section:

1. Go to the 'Import/export data' section of your store's admin Area. In X-Cart versions 4.4.0 and later, this section can be found at Tools menu -> Import/Export; in X-Cart 4.3.x, this section can be found at Management menu -> Import/Export; in earlier versions, this section can be found at Administration menu -> Import/Export.

2. On the menu to the right of the 'Import/export data' section, click on the Import data link.

Import procedure

The 'Import data' section looks like this:
Import.gif
However, the section [+] Select provider is available only to X-Cart PLATINUM and PRO administrators, and the set of data types available for importing varies depending on the type of user account being used).

To import data to X-Cart:

1. Prepare the CSV file to be imported.

Make sure of the following:

  • The charset of the file to be imported matches the system locale.
  • The file contains all the required fields (see the table in the 'Import options' section of the 'Import data' form — click on the plus sign).
  • The types of the data to be imported are listed in the table (if not, check whether the respective modules/add-ons that use the data types are enabled).

2. Use the options of the 'Import data' section to specify the data to be imported and the import method:

Note: X-Cart PLATINUM/PRO administrators! Certain types of X-Cart data (like PRODUCTS, SHIPPING RATES, TAX RATES, etc.) do not appear in the table and cannot be imported without specifying the provider the data belongs to. When importing provider specific data, be sure to enter the data owner's username in the corresponding fields of the 'Select provider' section.

3. Use the 'CSV delimiter' drop-down box to select the delimiter used in the CSV file you are going to import (Semicolon, Comma or Tab.

4. Specify the source of the import file, i.e. where the file is located physically. That can be the server running your X-Cart store, your local computer or some web-accessible location (Server, Home computer, URL). Depending on the selected source, provide the file path or URL.

5. Expand the 'Import options' section by clicking on the [+] Import options link and adjust the settings in this section as described below.

6. Click the Import button at the bottom of the 'Import data' form.

X-Cart should now start importing the data.

When the import process is over, you will see the respective confirmation message.

Import options

You can make additional settings by expanding the [+]Import options link and adjusting the required parameters:

  • If you are importing products, set the Default category (a category where your products will go if you have not specified a category in the 'Category' column. Just skip this field if you have specified the category in your CSV file).
  • If you are importing users, specify, whether customer passwords are encrypted (Yes/No).
  • If your CSV file mentions subcategories (e.g., if some of the products being imported go into subcategories), make sure that the Category path separator for "category" field in the 'Import options' section matches the separator in your CSV file.
  • If you are importing images (thumbnail images, product images, category icons, etc.) and wish to import them from a single directory, specify that directory in Directory where images are located.
  • If your store's database already contains data of the types that you are going to import, and you wish to drop that data before importing data from your spreadsheet, select the DROP check boxes next to the data types that need to be dropped. (If you do not select any of the check boxes, the data from your spreadsheet will simply be added to the database).