Student registration form in html with javascript validation

student registration form in html with javascript validation is the exercise that many people have experienced. Most students studying html can do this. However, many people still ask me about this so I decide to share my own way.

student registration form often includes basic information fields. They are easily created by html. However, you should use css to build the layout for a more attractive form. You also can check the input by using javascript, which is to guarantee that the input is imported correctly to avoid the system imprecisely processing. For instance, a human name cannot be a number. Email address must include @ and the corresponding domain is @gmail.com, etc. That we do this step well will facilitate the next data processing stage.

Preparation

You should prepare editor software. You could use phpdesigner or notepad++ or other editors that have similar functions. However, I get used to applying phpdesigner. You should have a default browser or install more browsers such as Google Chrome, Firefox.

Implementation

In order to complete the article student registration form in html with javascript validation, we use the editor and create an index.html file as below

<!DOCTYPE html>
<html lang="en"><head>
<meta charset="utf-8">
<title>JavaScript Form Validation using a sample registration form</title>
<meta name="keywords" content="example, JavaScript Form Validation, Sample registration form" />
<meta name="description" content="This document is an example of JavaScript Form Validation using a sample registration form. " />
<link rel='stylesheet' href='style.css' type='text/css' />
<script src="js.js"></script>
</head>
<body onload="document.registration.userid.focus();">
<h1>Registration Form</h1>
<form name='registration' onSubmit="return formValidation();">
<ul>
<li><label for="userid">User id:</label></li>
<li><input type="text" name="userid" size="12" /></li>
<li><label for="passid">Password:</label></li>
<li><input type="password" name="passid" size="12" /></li>
<li><label for="username">Name:</label></li>
<li><input type="text" name="username" size="50" /></li>
<li><label for="address">Address:</label></li>
<li><input type="text" name="address" size="50" /></li>
<li><label for="email">Email:</label></li>
<li><input type="text" name="email" size="50" /></li>
<li><label id="gender">Sex:</label></li>
<li><input type="radio" name="msex" value="Male" /><span>Male</span></li>
<li><input type="radio" name="fsex" value="Female" /><span>Female</span></li>
<li><label for="code">student identification number:</label></li>
<li><input type="text" name="code" size="50" /></li>
<li><label for="code">Class:</label></li>
<li><input type="text" name="class" size="50" /></li>
<li><input type="submit" name="submit" value="Submit" /></li>
</ul>
</form>
</body>
</html>

Create file style.css in the same folder with file index.html with the following content.

h1 {
margin-left: 70px;
}
form li {
list-style: none;
margin-bottom: 5px;
}
 
formul li label{
float: left;
clear: left;
width: 250px;
text-align: right;
margin-right: 10px;
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:14px;
}
 
formul li input, select, span {
float: left;
margin-bottom: 10px;
}
 
formtextarea {
float: left;
width: 350px;
height: 150px;
}
 
[type="submit"] {
clear: left;
margin: 20px 0 0 230px;
font-size:18px
}
 
p {
margin-left: 70px;
font-weight: bold;
}

Next, create file js,js as the content shown hereunder


functionformValidation()
{
varuid = document.registration.userid;
varpassid = document.registration.passid;
varuname = document.registration.username;
varuadd = document.registration.address;
varucountry = document.registration.country;
varuzip = document.registration.zip;
varuemail = document.registration.email;
varumsex = document.registration.msex;
varufsex = document.registration.fsex; if(userid_validation(uid,5,16))
{
if(passid_validation(passid,7,16))
{
if(allLetter(uname))
{
if(alphanumeric(uadd))
{
if(countryselect(ucountry))
{
if(allnumeric(uzip))
{
if(ValidateEmail(uemail))
{
if(validsex(umsex,ufsex))
{
}
}
}
}
}
}
}
}
return false;
}
 
functionuserid_validation(uid,mx,my)
{
varuid_len = uid.value.length;
if (uid_len == 0 || uid_len>= my || uid_len< mx)
{
alert("User Id should not be empty / length be between "+mx+" to "+my);
uid.focus();
return false;
}
return true;
}
 
functionpassid_validation(passid,mx,my)
{
varpassid_len = passid.value.length;
if (passid_len == 0 ||passid_len>= my || passid_len< mx)
{
alert("Password should not be empty / length be between "+mx+" to "+my);
passid.focus();
return false;
}
return true;
}
functionallLetter(uname)
{
var letters = /^[A-Za-z]+$/;
if(uname.value.match(letters))
{
return true;
}
else
{
alert('Username must have alphabet characters only');
uname.focus();
return false;
}
}
function alphanumeric(uadd)
{
var letters = /^[0-9a-zA-Z]+$/;
if(uadd.value.match(letters))
{
return true;
}
else
{
alert('User address must have alphanumeric characters only');
uadd.focus();
return false;
}
}
functionValidateEmail(uemail)
{
varmailformat = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/;
if(uemail.value.match(mailformat))
{
return true;
}
else
{
alert("You have entered an invalid email address!");
uemail.focus();
return false;
}
}
functionvalidsex(umsex,ufsex)
{
x=0;
 
if(umsex.checked)
{
x++;
} if(ufsex.checked)
{
x++;
}
if(x==0)
{
alert('Select Male/Female');
umsex.focus();
return false;
}
else
{
alert('Form Successfully Submitted');
window.location.reload()
return true;}
}

Above is student registration form in html with javascript validation code.  You could download it to edit, add, or remove fields appropriately.

Sell email adress and maketing online

Many people often search for the key words “ sell email adress ” but the right ones should be “sell email address”. I guess that it is due to the language used in their computer. Or it may result from too quickly typing. However, I can understand your purpose is to buy a list of email to use in marketing. I will share my perspective in this article. I hope that there will be suggestions for you.

sell email adress

Lots of well-known companies steal users’ information, collect their hobbies, check their location, and follow their behaviors. Then they sell the information to advertisers. The information is so important. You can buy the information unless you have a strong financial ability or good relation. If you just search on Google with “ sell email adress ” hay “sell email address”, the quality of these lists is not guaranteed. Normally, the fact is that a tool scans to retrieve emails in some websites. The information may not cover the potential customers you want to target. For example, you do not want to advertise diapers for people in the age from 15 to 18.

If you are working in marketing, you do not need to buy these emails because you can buy other beneficial things. For instance, I find Abandoned Cart Reminder module quite interesting. When customers add products to cart but forget to checkout, they will receive notifications that they forget their favorite products. If your customers are on the website, they will receive notification through Popup, Sticky Bar, Browser Notification or Browser Tab Notification. If your customers are offline, they will receive a reminder email with a voucher code from the system to persuade them to buy. In this case, they certainly are your target customers who pay interests to your products. Therefore, the conversion rate is very high and you do not lose potential customers. You could get access to this link to read more about the tool https://addons.prestashop.com/en/remarketing-shopping-cart-abandonment/26740-abandoned-cart-reminder-5-in-1.html .

Through the article “ sell email adress ”, I believe that you should consider spending money to invest in your websites. There are things you buy once but you use them for many years. Thanks for following this article. Please share it if you feel it helpful.

woocommerce pending payment

In the stage of processing orders, there are many order statuses such as woocommerce pending payment,processing, on hold, completed, canceled,returned,failed.In the scope of this article, we will focus on the pending status of the orders, how it works as well as the method to process it.

Woocommerce is one of the plugins after combining with WordPress becoming the source code which has the biggest market share. Till now, there are 49,226,906 download times which account for 28% of download times of all the online stores.

Come back to the order management issue, woocommerce pending payment often occurs when you incorrectly configure the payment or in case of using manual payment method such as COD, bank transfer. Because these payment methods do not include notifications as well as return any information to the web, the system cannot automatically change the order status.

With these manual payment methods, it requires manual management operations. After receiving payments from the banks or COD staff, the shop owners will change the order status manually. Then you will deliver goods to your customers if they are physical goods such as clothes, books, equipment, toys, etc. Or the system will send files to the customers or allow them to download files if they are digital products.

You follow the guidance on how to change the order status. You click on Status item and select the orders in Pending payment method to switch to another status.

woocommerce pending payment

Through the article woocommerce pending payment, we see that no matter how modern your stores are, you should be flexible to serve different customers by manually operating as the case above. Therefore, you should prepare professional order edit tool to reduce the time and labor cost. If you use Prestashop, I recommend that you should use Order edit module. You can get access to this link ( https://addons.prestashop.com/en/order-management/23748-order-edit.html ) to try the demo before applying it to your project.

 

registration successful message in php

Today we will talk about registration successful message in php. Displaying a notification after a successful registration is extremely important because it lets us know whether our program works well or not. I also provide source code after this article. Therefore if you are not skillful in PHP or you want to edit this source code, you just need to download the code at the end of the article.

Registration successful message in php

PHP is a popular programming language that is loved by lots of people. It also is the language used to create many opening source codes such as Prestashop, Magento, WordPress, etc. PHP in general and source codes include the registration part. Registration successful message in php works depending on the process of the project. Today we give you a simple notification demo.

Preparation

  • Using hosting or server localhost, you could use xampp or similar software that you need.
  • Code editor software, you could use familiar software such as notepad++

Implementation

We start checking the data. During the registration process, if saving the information of the form to the database is successful, there will be a notification for customers to know they have completed registering. About the displaying content, it may be a thanking or others, you just need to edit texts.

Firstly, we create a database which I name “test”. We add table and fields to the database. If you hesitate to do this, you could copy the following code and paste it into sql.

CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test`;
 
CREATE TABLE IF NOT EXISTS `users`(
`id`int(11) NOT NULL AUTO_INCREMENT,
`username`varchar(30) NOT NULL,
`password`varchar(30) NOT NULL,
`name`varchar(255) NOT NULL,
`email`varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
<html>
<head>
</head>
<body>
<?php
$conn = mysqli_connect('localhost','root','','register') or die("cannot connect to database");
mysqli_query($conn,"SET NAMES 'UTF8'");
if (isset($_POST["btn_submit"])) {
$username = $_POST["username"];
$password = $_POST["pass"];
$name = $_POST["name"];
$email = $_POST["email"];
if ($username == "" || $password == "" || $name == "" || $email == "") {
echo "Please enter your infomation";
}else{
$sql="select * from users where username='$username'";
$kt=mysqli_query($conn, $sql);
 
if(mysqli_num_rows($kt)  > 0){
echo "Account is exits";
}else{
$sql = "INSERT INTO users(
username,
password,
name,
email
) VALUES (
'$username',
'$password',
'$name',
'$email'
)";
mysqli_query($conn,$sql);
echo "you have registered";
}
}
}
?>
<form action="#" method="post">
<table>
<tr>
<td colspan="2">Form register</td>
</tr>
<tr>
<td>Username :</td>
<td><input type="text" id="username" name="username"></td>
</tr>
<tr>
<td>Password :</td>
<td><input type="password" id="pass" name="pass"></td>
</tr>
<tr>
<td>Full name:</td>
<td><input type="text" id="name" name="name"></td>
</tr>
<tr>
<td>Email :</td>
<td><input type="text" id="email" name="email"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="btn_submit" value="register"></td>
</tr>
</table>
</form>
</body>
<style>
form{
width: 300px;
margin: auto;
margin-top: 112px;
border: 1px solid #cdcd;
padding: 10px;
}
</style>
</html>

You should input the right information so that the notification can be displayed. You could check in the database. Below is the written data. Because this is the demo, I do not encode the data. When you apply this to the practical project, you are provided with some functions to encode such as md5, sha, etc by PHP for the purpose of customers’ safety.

Registration successful message in php

We have finished the article which is about Registration successful message in php. The issues related to custom fields,create input, create recaptcha as well as form are interested by many people. PHP language and other programming languages newbies should pay attention to this issue.

contact form 7 download file on submit

contact form 7 download file on submit is applied when you share a file with the condition that who want to download this file need to submit form. Usually, admins want to get users’ information such as email and telephone number. When users send this form successfully, the wanted file will be automatically downloaded to the computer.

This is not a new method but its positive effects on marketing are quite big. When people search document of some fields such as cake recipe, you can use form builder tool to require users to input their email, name and telephone number. After users submit a form, they will receive the file they want and you get their information. It is good for both two sides. The information you get is so valuable when you use it to advertise your bakery store, materials and baking accessory store.

Implementation

Login to BackOffice of wordpres and install contact form 7 plugin. Create a form. You can do as the example below

contact form 7 download file on submit

Now, you should prepare the document file you want to share with people. You can upload it anywhere everyone can download such as Google drive or your media to get the url of the file.  Please getting access to this link to make sure everyone can get access and download file.

In the contact form, click on Additional Settings tab and add the following code. Remember to replace pdf-url-here with the file url you have got.

on_sent_ok:"force_download('pdf_url_here');"

This code means that after the form is submitted successfully, force_download(); function will be processed

contact form 7 download file on submit

In code of WordPress, you should add code js

functionforce_download( file ){pdf=window.open(file,'','left=100,screenX=100');pdf.document.execCommand('SaveAs','null','myfile.pdf');pdf.close();}

In addition to contact form 7 download file on submit, there is another way that after the email address is sent, we will configure an automatic email to send to the email that the customer has submitted. This way is to identify if this is real user email. You can refer to this previous article to be clear about this problem.

We have dealt with contact form 7 download file on submit. If you have any problem with Prestashop Form builder, Shopify Form builder, WordPress Form Builder, please leave a comment or contact us. We will give you a solution. Please share this article so that more people can find the solution to the problem they are facing.

date of birth in php form

How to use date of birth in php form is the issue that many people are confused when using this programming language. With the forms related to personal information, there are many cases that forms include date of birth information.

date of birth in php form

If we use textbox to input date of birth, data must be checked. If users enter text, special characters or a number bigger than 31, there must have a notification that the input is invalid. Commonly, we use javascript to process the data.

In order that users do not input text or special characters, you could use type=number limited from 1 to 31.

There are many systems using dropdown for the purpose of importing date. With dropdown, users do not have to enter information but choose one date in the list of dates displaying. It must be sure that data displays properly. For example, there is no 30th or 31th in February.

Using the types of input like the two above, you need to identify data and calculate properly as well. This will costs you a lot of time. There is one type that incurs less error but is more visible. It is date picker. Thanks to date picker, using date of birth in php form is not a big problem anymore.

You could use the following example to see if date picker can make your project simpler.

<!doctype html>
<html lang="en">
<head>
<metacharset="utf-8">
<metaname="viewport"content="width=device-width, initial-scale=1">
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet"href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<link rel="stylesheet"href="/resources/demos/style.css">
<scriptsrc="https://code.jquery.com/jquery-1.12.4.js"></script>
<scriptsrc="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script>
$( function() {
$( "#datepicker" ).datepicker();
} );
</script>
</head>
<body>
 
<p>Date: <input type="text"id="datepicker"></p>
 
 
</body>
</html>

We have run through the article date of birth in php form. If you have any feedback about the article, or you want to know more about form builder and how to save a form to the database, please read the next article, or contact us for support.

How to create recaptcha validation before submit in php

Welcome you to the article “ recaptcha validation before submit ”. The guidance of this article is on PHP source code. Besides, after reading this article, you could download the source code of this article. You can use it without minding.

recaptcha validation before submit

Introduction

We need to use recaptcha validation before submit because it helps make sure that there is a human wanting to submit information. And they are people to whom we need to reply. In addition, captcha can be used to avoid being spammed or DDOS attack.

Preparation

In this article, the first thing we need is an editor software such as notepad ++ or phpdesigner as I am using. You can use any tool that is suitable for you.

The second thing is a Google account. It is your Gmail and password.

Besides, you also need hosting. Previously, you can use localhost. But recently, Google API does not support localhost anymore. There will be a notification as below. You can try to see if your computer allows to use localhost.

recaptcha validation before submit

Implementation

Create php source code

To save time, I will provide you with the source code of the article. You just need to copy and edit according to your need,

Create index.php file to which you add the code

<html lang="en">
<head>
<title>recaptcha validation before submit</title>
<scriptsrc='https://www.google.com/recaptcha/api.js'></script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
</head>
<body>
 
<div class="container">
<div class="row">
<div class="col-xs-8">
<div class="panel panel-primary">
<div class="panel-heading"><strong>Precaptcha validation before submit</strong></div>
<div class="panel-body">
<form action="do_process.php" class="form-horizontal" method="POST">
 
<div class="form-group">
<label class="col-xs-4 control-label">Full Name:</label>
<div class="col-xs-6">
<input type="text" class="live-form" name="name" placeholder="Full Name" required="" />
</div>
</div>
 
<div class="form-group">
<label class="col-xs-4 control-label">Your valid Email:</label>
<div class="col-xs-6">
<input type="text" class="live-form" name="email" placeholder="Your Email" required="" />
</div>
</div>
<div class="form-group">
<label class="col-xs-4 control-label">comments:</label>
<div class="col-xs-6">
<textarea type="text" class="live-form" name="comments" placeholder="Your comments" required=""></textarea>
</div>
</div>
<div class="form-group">
<label class="col-xs-4 control-label">Simple Captcha:</label>
<div class="col-xs-6">
<div class="g-recaptcha" data-sitekey="6LflqWkUAAAAACBi3OmE825ELQ9ZkeINwRsEITpa"></div>
</div>
<div class="form-group">
<div class="col-xs-6 col-xs-offset-6" class="live-center">
<br/>
<input class="btnbtn-success" type="submit" name="submit" value="Submit">
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
You should pay attention to this code <div class="g-recaptcha" data-sitekey="6LflqWkUAAAAACBi3OmE825ELQ9ZkeINwRsEITpa"></div>
You should replace the sitekey with your code. To get this code, you should view the sitekey and secret key.
<?php
if($_SERVER["REQUEST_METHOD"] === "POST")
{ 
$google_recpachscrkey = "6LflqWkUAAAAAMEt_pgOdo9IucoBDTTq77K8Anlq";
$response = file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".$google_recpachscrkey."&response=".$_POST['g-recaptcha-response']);
$response = json_decode($response, true);
if($response["success"] === true){
echo "USER Form Submit Successfully.";
}else{
echo "You Simple are a robot";
}
}

Please pay attention to this code $google_recpachscrkey=””, please view steps on how to create site key and secret key to add information to.
Create site key and secret key
Firstly, you get access to this link https://www.google.com/recaptcha/admin#list, then you log in your Google account.
Label: here you enter the title of the website for more convenient administration if you have many projects.
Choose the type of reCAPTCHA: you choose reCAPTCHA v2
Domain: you input the domain. If you have lots of domains, you should write each domain in one line, please delete prefix http:// and www.

Then you click on Accept the recaptcha Terms of Service checkbox

recaptcha validation before submit

The next page will include lots of information as well as user guide. But in this article, you just need to pay your biggest attention to the site key and secret key. You should copy and add this information to the part above.

recaptcha validation before submit

You have read the article recaptcha validation before submit. Now you can know one more data validation before processing. You can add/delete fields in php form. I have used Custom field module and found it very interesting. You can add unlimited fields to the registration page or checkout page pretashop. Of course, the module supports all types of data including recaptcha. If you are interested in the module, you can refer to this link https://addons.prestashop.com/en/registration-ordering-process/27422-custom-fields-registration-form-and-checkout.html Thanks for following the article.

woocommerce get product type

Products in  woocommerce   are divided into many different types in order to distinguish among them. Depending on the using purpose, product types are applied to search or filter product. If you are importing lots of products in woocommerce, you should pay attention to product type field. This article helps you know which type of the product you are viewing is. It looks at how woocommerce get product type.

Common product types

  • Simple: This type includes popular products without options, for example, a pen or a book
  • Group: This includes products in a set which can be bought separately. It just includes simple products, for example, a set of six glasses.
  • Virtual: It is the product type that does not require delivery or download. For example, services.
  • Download: These products also do not require delivery. They are downloaded to computers or other devices. They often are copyright music videos, press publications, etc.
  • External or Affiliate: These products are described but not sold on the website. People who work in Affiliate often use this type.
  • Variable: The product type includes lots of options and variables. For example, an L-blue t-shirt is a variable while an M-red t-shirt is another variable.

Display products

If you want to display products in the product detail page, you use hook woocommerce_single_product_summary

Therefore we write the function get_product_type to display,

The function to display information for groups is performed as below. You can add this content to the line containing echo code;

 
functionget_product_type() {
global $post;
if(function_exists('get_product') ){
$product = get_product( $post->ID );
if( $product->is_type( 'variable' ) ){
echo 'Product type is variable'  ;                }
if( $product->is_type( 'group' ) ){
echo 'Product type is Group  ;                }
if( $product->is_type( 'Virtual' ) ){
echo 'Product type is Virtual  ;
}
if( $product->is_type( 'download' ) ){
echo 'Product type is Download  ;                }
}
}

In order that this function works in hook woocommerce_single_product_summary, we add the following syntax to the function file

add_action( 'woocommerce_single_product_summary', 'get_product_type',  5 );

Now we get to check the result. Here is the result.

Depending on the using purpose, we can display it in collection to filter product by type.

We have solved the issue related to woocommerce get product type. If you have any question, please contact us or leave a message in the comment. We are willing to support you for free.

Export ebay listings to csv file

To export ebay listings to csv file means to export products to csv files. The files can be used for different purposes. This article will show you the positive effects of csv files as well as the process of importing products.

You have sold products online on Ebay for several years. Your number of products is huge. You want to expand your market by developing new e-commerce pages to show and sell products online. But importing product information one by one is impossible because the number of products is too huge. Editing or adding new products may cause unworthy errors. It is the reason why importing product is interested by many people.

To export ebay listings to csv file, you get to the product list, choose all the products you want to export. In Action, you click on Export to file as below

export ebay listings to csv file

Then CSV file will automatically be downloaded to your computer. You can edit the CSV file by Office software or google office. You could edit the product name, image, and price before importing to your website.

Now, if your website use source codes such as Shopify, Magento, Prestashop, Woocommerce, you just need to take the csv file and import to the website. You should pay attention to the csv file structure comparing with the sample csv file structure. But if you use Prestashop source code, I suggest that you should use Import product module. When using this module, you do not have to pay attention to the csv file structure. You can use any csv, xml files. You can get to here to import the files that you export ebay listings to csv file with the demo back office. If your problem is solved, please let us know. If not, please leave a comment or contact us, we will support for free.

CSV import product

CSV import product is the module supporting to input product data in bulk in order to replace the traditional way. If you own a small number of products, you can import the product information manually. However, if the number comes up to hundreds of thousands of products, it will be impossible to do this. It will be a nightmare if you input this enormous information manually day by day.

Therefore, CSV import product is launched to provide solutions to this problem. If you have a number of stores using Prestashop, you do not need to import product for each store any more. You input information for one store only, and export it to CSV file. If there is any difference in prices and product quantities among stores, you edit the CSV file and import for the rest of stores.

To export existing products to CSV file, you do as below:

On the left side of the menu in the back office, youhover mouse cursor to Catalog and click on Products.

A list of products will appear

CSV import product

In the product list, you can choose all products by clicking on Select All or select each one. Then click on Export symbol as the figure below.

CSV import product

After importing, the system will download the CSV file to computer.

CSV import product

You can send this CSV file to other people or to the site for importing products. You also can edit CSV file to be suitable for new sites or to update information for this site.

CSV import product

Import products

In the product list interface, you click on Import button as below

CSV import product

A window shows up, you can install to import products.

In “Select a file to import”, you click on upload button to upload files from your computer. Or you can use files from history/FTP. After selecting and configuring, you click on Next step.

CSV import product

In this screen, you please select the exact fields of CSV system and data. For example, in ID column, you select Product ID and it is similar to Image, Name, Reference, etc. Finally, you click on Import button to finish the product import process.

CSV import product

The disadvantage of default CSV import product feature is that it can process the CSV files created by itself. You need to pay attention to syntax order when editing CSV files. This default Prestashop feature also does not support to import CSV and excel files exported from Shopify, Magento, and WordPress. In these cases, I suggest that you should use this Import product module because it supports CSV and excel files with all forms. You will be supported by developers if you get into trouble.

 

Enjoy this blog? Please spread the word :)