SDN Store Guided Tour - Importing Products

NOTE: we understand this article is a bit difficult to read and to implement, this is simply because it has to fit everybody's needs. For a little extra, we can build a custom importing tool which would be much easier for you to import your products. For more info send an email to Ask for a Quote explaining in what way your products have to be imported.

You need to create a zip file containing some text files called: (make sure is saved in Unicode type)

ImportPricings.txt (it contains the pricing list to import);

ImportDiscounts.txt (it contains the discount list to import);

ImportTaxes.txt (it contains the VAT list to imports);

ImportCategories.txt (it contains the categories to import; do not include it if you don't have sub-categories. The defined categories in the ImportProducts.txt file will be created at the same level);

ImportProducts.txt (it contains the products to import);

The image files whose name are defined in the ImportsProducts.txt file.

The txt files must be in the form:

1) One record per line;

2) Row delimiter: {CR}{LF} and Column delimiter: Tab

ImportPricings.txt file

The sequence of the fields must be in the following order: Pricing Name (max 50 characters), Pricing Decription (must be different from blank), Variation in Percentage, Variation in Amount (only one Variation must be different from zero). Do not include it in the zip file if there aren't any Pricing to import. The process will create new pricing or update existing one based on the Pricing Name.

ImportDiscounts.txt file

The sequence of the fields must be in the following order: Discount Name (max 50 characters), Discount Decription (must be different from blank), Variation in Percentage, Variation in Amount (only one Variation must be different from zero). Do not include it in the zip file if there aren't any Discounts to import. The process will create new discounts or update existing ones based on the Discount Name.

ImportTaxes.txt file

The sequence of the fields must be in the following order: Tax Name (max 50 characters), Percentage. Do not include it in the zip file if there aren't any Taxes to import. The process will create new Taxes or update existing ones based on the Tax Name.

ImportCategories.txt file

The sequence of the fields must be in the following order: Category Name (max 50 characters), Category Father Name (max 50 characters) (blank if it is on the top), Pricing Name (max 50 characters) (blank if not used), Discount Name (max 50 characters) (blank if not used), Tax Name (max 50 characters) (blank if not used), Order (zero if not used). Do not include it in the zip file if there aren't any Sub Categories and you don't need to set up an order in the list of the categories and to associate categories with Pricings, Discounts, Taxes. When importing the ImportProducts.txt file, if the category name on it does not exist then the process creates it at the top level in the tree view.

ImportProducts.txt file

The sequence of the fields must be in the following order (this file must exist):

Category Name: is the name of the category (max 50 characters). If it does not exist, the import creates it first (setting it at the top level in the tree)

Model Number: Number of the Model (max 50 characters). This is used as the unique code to identify the product, if the Model Number does not exist then it creates a new product otherwise it updates it.

Image File Name: file name of the product image (blank if not used)

Image1 File Name: file name of the product image1 (blank if not used)

Image2 File Name: file name of the product image2 (blank if not used)

Image3 File Name: file name of the product image3 (blank if not used)

Small Image File Name: file name of the product small image (blank if not used)

Unit Cost: unit cost of the product

Special Price: special price of the product (zero if not used)

weight: weight of the product (zero if not used)

Name of the First Attribute (max 50 characters): blank if not used;

First Attribute, Variation on Amount: zero if not used;

First Attribute, Variation on Percentage: zero if not used; either Variation on amount or Variation on Percentage must be different from zero;

Name of the Second Attribute (max 50 characters): blank if not used;

Second Attribute, Variation on Amount: zero if not used;

Second Attribute, Variation on Percentage: zero if not used; either Variation on amount or Variation on Percentage must be different from zero;

Name of the Third Attribute (max 50 characters): blank if not used;

Third Attribute, Variation on Amount: zero if not used;

Third Attribute, Variation on Percentage: zero if not used; either Variation on amount or Variation on Percentage must be different from zero;

In The Front Window Module: 0/1, 1 if in the front window otherwise 0

Visible: 0/1, 1 if visible only to an Admin otherwise 0

Brand Name: the name of the brand (max 50 characters), blank if not used. If used, if the brand does not exist then it creates it first.

ModelName: model name of the product (max 50 characters)

Decription: of the product (max 3800 characters)

Text Front Window: text appearing when it is in the front window (max 1000 characters), blank if not used.

Order: order when appearing in the list, 0 if not used

LongDesc: Long Desc of the Product, blank if not used

LongDescFileID: FileID of the files table (DNN table), 0 if not used

LongDescURL: url address, blank if not used

RoleID: RoleID in the Roles table (DNN table), -1 if not used

RoleExpireValue: integer. Zero if not used. Zero also means it does not expire but it counts only when the RoleID is <> -1

RoleExpireType: 'd' for days, 'w' for weeks, 'm' for months, 'y' for years. Blank if not used

Pricing Name (max 50 characters): the applied Pricing. The PricingName are defined in the ImportPricingNames.txt file, blank if not used.

Discount Name (max 50 characters): the applied Discount. The DiscountName are defined in the ImportDiscountNames.txt file, blank if not used.

Tax Name (max 50 characters): the applied VAT. The TaxName are defined in the ImportTaxNames.txt, blank if not used.

Name of the Fourth Attribute (max 50 characters): blank if not used;

Fourth Attribute, Variation on Amount: zero if not used;

Fourth Attribute, Variation on Percentage: zero if not used; either Variation on amount or Variation on Percentage must be different from zero;

Name of the Fifth Attribute (max 50 characters): blank if not used;

Fifth Attribute, Variation on Amount: zero if not used;

Fifth Attribute, Variation on Percentage: zero if not used; either Variation on amount or Variation on Percentage must be different from zero;

Stock Qty: zero if not used.

To download an example of a zip file to upload click here

The file name of the pictures you input in the zip file must be the same as the ones you specified in the ImportProducts.txt as Image File Name, Image1 File Name, so on.

Please NOTE: the products will be added in the current language.