Product and page data you can import

Your ImportWizard can import most product and page information. Below you will find a list all all supported data types.

There are sample database files included with the Import Wizard. These will be found in the 'ShopFactory/ImpwizSamples' folder. Download samples file.

!

The fields that can be imported

With the help of the database wizard you can quickly import the following product information:

Field Name Syntax Sample
Product Name Text Product 1
Item Number Numerical-alphabet 2001 or item_2001
Department Name    
Product Description Text Description — product 1
Product Image Full path file name C:\program files\SF V5\image1.bmp
Price Floating point value 1000.00
Special Text Summer Sales
Weight Floating point value 12.0
Tax Text GST, VTS, or My Local Tax 1
Link Full path file name C:\images\link_img.bmp
Link Type Integer value 1 = a local file, 2=a URL file
 Link Caption Text  Caption text
Headline Text <b>This is a headline</b>
Product Visible Integer value 0= invisible, 1= visible
Longer description Text <font size=5>Long Description</font>
Highlights Text A highlight text
Discount Type Integer value apply (1)discount price or (2) quantity discount
Discount Price Floating point value 998.00
Quantity Discount (from|To|Percentage) (0|10|2.5)(10|500|5.0){500|5000|7.0)
Product code Numerical-alphabet Sf_001
Manufacturer code Numerical-alphabet Nec101
Price code Numerical-alphabet 2K100
Available Quantity Integer Value 1000
Min Order Quantity Integer Value 1
Max Order Quantity Integer Value 12
Out of Stock Message Text Prod A is out of stock, try again later!
Quantity Unit Text Carton, kg, lt
Allow decimal quantities such as 1.5 Integer value 0=NO, 1=Yes
Show Add to Basket Integer value 0=NO, 1=Yes
EAN13 EAN13 number 590123123457
Economy Floating Point value 7.2
Air Floating Point value 15.4
Express Floating Point value 26.5

The import wizard can automatically create departments for products which have categories associated with them.

You will need to create a field in your file for each field that you wish to import to ShopFactory.

Departments & Subdepartments

Department and Subdepartments can be specified in the database.

For a product to be imported into the sales sub-department in the test department;
'test/sales' should be the department field.

Option and Choices

An example file to see how to set up a database with option & choices is "exop.xls". This has 2 options and 3 choices for each option.

Choose the maximum number of different options available for the products and the maximum number of choices to be offered for any of these options.

For example: 1 Option & 2 Choices You will need a column for each of the following:

Option name 01 The name of first Option (eg: Size).
Option checked 01

Checked status of first Option in the final shop:

0 = unchecked (not visible in shop)
1 = Ticked (required option)

Choice name 01  The name of first choice (eg: Small).
Choice price 01 The extra amount to be added to the product price for the first choice in the first option.
Choice order no 01 The order number for the first choice in the first option.
Choice weight 01 The added weight for the first choice in the first option.
Choice Available Quantity 01 The available stock quantity for the first choice in the first option.
Choice Minimum Quantity 01 The minimum order quantity for the first choice in the first option.
Choice Maximum Quantity 01 The maximum order quantity for the first choice in the first option.
Choice name 02 The name of second choice (eg: Small).
Choice price 02 The extra amount to be added to the product price for the second choice in the first option.
Choice order no 02 The order number for the second choice in the first option.
Choice weight 02 The added weight for the second choice in the first option.
Choice Available Quantity 02 The available stock quantity for the second choice in the first option.
Choice Minimum Quantity 02 The minimum order quantity for the second choice in the first option.
Choice Maximum Quantity 02 The maximum order quantity for the second choice in the first option.