Create an account to edit articles | See Formatting Syntax for Wiki syntax | We look forward to your contribution!

Differences

This shows you the differences between two versions of the page.

productcart:products_import [2010/03/09 01:03]
earlyimpact 		productcart:products_import [2010/08/27 05:00] (current)
Line 38: Line 38:
Regardless of which file type you plan to use during the import, it is very important that you make sure your file is formatted properly prior to importing into ProductCart. Regardless of which file type you plan to use during the import, it is very important that you make sure your file is formatted properly prior to importing into ProductCart.
- 
==== Preparing an Excel file for import ==== ==== Preparing an Excel file for import ====
-If you are importing an Excel file, the following steps MUST be taken in order for the import to be successful.+If you are importing an Excel file, the following steps MUST be taken in order for the import to be successful.  
 + 
 +=== 3000 records limitation === 
 + 
 +By default, ProductCart limits the import to 3,000 records when using an Excel spreadsheet. This is done to avoid performance issues when importing MS Excel files. You can either setup your MS Excel file to have 3,000 rows or less (therefore splitting larger files into smaller spreadsheets), or you can remove the limitation in ProductCart. 
 + 
 +If you decide to try to import more than 3,000 records at the same time, do the following to edit the source code: 
 + 
 +  * Download the file //step4-xls.asp// from your Control Panel folder 
 +  * Open it in Notepad or your favorite HTML editor 
 +  * Locate the line that reads <code><% iPageSize=3000</code> 
 +  * Replace //3000// with a higher number 
 +  * Save the file, and upload it back to the Control Panel folder. 
 + 
 +If you are running into performance issues (e.g. the script times out), reduce the amount of records that you are trying to import. 
 + 
 +=== "Clean up" the spreadsheet === 
 + 
 +  - Remove all other worksheets 
 +  - Remove all cell formatting 
 +  - Remove all empty columns 
 +  - Remove all columns that you do not intend to import 
 +  - Remove all empty rows 
 + 
 +=== Convert all SKU values in the .XLS file to Text === 
 + 
 +  - Open your .XLS file in Excel.  
 +  - Select the SKU column by left clicking on the Column header.  
 +  - Select the menu item: Data > Text to Columns. The Convert Text to Columns Wizard will be displayed.  
 +  - In Step 1 of the wizard, click on the Next button.  
 +  - In Step 2 of the wizard, click on the Next button.  
 +  - In Step 3 of the wizard, select TEXT in Column data format, then click on the Finish button.  
 + 
 +=== Create a name for the data range === 
 + 
 +The Excel import feature requires a named range and the range must be named "IMPORT. To do this, select (highlight) the entire data range (columns and rows) that you want to import (including the top row, which should contain the field names), and then... 
 +  - Office 1997 to 2003: 
 +    - Select //Insert > Name > Define//  
 +    - Enter the name "IMPORT" without the quotes and click on the Add button. 
 +  - Office 2007: 
 +    - Select //Formulas > Define Name// 
 +    - Enter the name "IMPORT" without the quotes and click on the OK button. 
 +    - You can review existing "Names" used on the spreadsheet by selecting //Formulas > Name Manager//  
 +    - Save the spreadsheet as an .XLS file
-  - "Clean up" the spreadsheet: +=== An example ===
-    - Remove all other worksheets +
-    - Remove all cell formatting +
-    - Remove all empty columns +
-    - Remove all columns that you do not intend to import +
-    - Remove all empty rows +
-  - Convert all SKU values in the .XLS file to Text: +
-    - Open your .XLS file in Excel.  +
-    - Select the SKU column by left clicking on the Column header.  +
-    - Select the menu item: Data > Text to Columns. The Convert Text to Columns Wizard will be displayed.  +
-    - In Step 1 of the wizard, click on the Next button.  +
-    - In Step 2 of the wizard, click on the Next button.  +
-    - In Step 3 of the wizard, select TEXT in Column data format, then click on the Finish button.  +
-  - Create a name for the data range: \\ The Excel import feature requires a named range and the range must be named "IMPORT. To do this, select (highlight) the entire data range (columns and rows) that you want to import (including the top row, which should contain the field names), and then... +
-    - Office 1997 to 2003: +
-      - Select //Insert > Name > Define//  +
-      - Enter the name "IMPORT" without the quotes and click on the Add button. +
-    - Office 2007: +
-      - Select //Formulas > Define Name// +
-      - Enter the name "IMPORT" without the quotes and click on the OK button. +
-      - You can review existing "Names" used on the spreadsheet by selecting //Formulas > Name Manager//  +
-  - Save the .XLS file.+
Here is an example of what the IMPORT range should look like (it must contain all cells that are part of the IMPORT, including the header or top row – such as the shaded area in the example below). Here is an example of what the IMPORT range should look like (it must contain all cells that are part of the IMPORT, including the header or top row – such as the shaded area in the example below).
Line 150: Line 171:
| Display no shipping text | True/Yes = -1 \\ False/No = 0 | | Whether the text indicating that this is a non-shipping product should be displayed. If blank, it defaults to “False”. | | Display no shipping text | True/Yes = -1 \\ False/No = 0 | | Whether the text indicating that this is a non-shipping product should be displayed. If blank, it defaults to “False”. |
| Minimum Quantity | Number (Integer) | | Minimum quantity customers have to purchase when they purchase this product. It can be used in conjunction with the “Enforce Multiple of Minimum” field. See later in this chapter for more details on this feature | | Minimum Quantity | Number (Integer) | | Minimum quantity customers have to purchase when they purchase this product. It can be used in conjunction with the “Enforce Multiple of Minimum” field. See later in this chapter for more details on this feature |
-| Enforce Multiple of Minimum | True/Yes = -1 \\ False/No = 0 | | Whether or not the quantity purchased should be a multiple of the minimum. Enter “1” to require a quantity that is a multiple of the minimum. The minimum quantity must be > 0 |+| Enforce Multiple of Minimum | True/Yes = 1 \\ False/No = 0 | | Whether or not the quantity purchased should be a multiple of the minimum. Enter "1" to require a quantity that is a multiple of the minimum. The minimum quantity must be > 0 |
| Not for sale | True/Yes = -1 \\ False/No = 0 | | Whether the product is not available for sale. If blank, it defaults to “False”. | | Not for sale | True/Yes = -1 \\ False/No = 0 | | Whether the product is not available for sale. If blank, it defaults to “False”. |
| Not for sale copy | Text | | Text description (e.g. Coming Soon). Only used if “Not for sale” option is set to True. | | Not for sale copy | Text | | Text description (e.g. Coming Soon). Only used if “Not for sale” option is set to True. |