Manually added customers with addreses - what did I wrong

shamble · October 2, 2009

Hello there,

I've been asked to add manually customers to the DB and send them and email that they just have access to online shop.

After DB check I realized I need insert data int customers and address_book tables.

at the end is my code...

Script do its work and I'm able to log in with manually inserted e-mail address and

my pre-generated password.

problem is that when I logged in as an admin I can not see these customers on first page.

And once I try to make an order with such a manually added customer, I will receive an email about order but again I don't see it within admin console.

Any ideas what can cause this problem ?

Or do you know any contribution with functionality I need ? (import customers for csv file)

thanks for any replies

Shamble

--------------------------------------------------------------------------------------------------------------------------------

<HTML>

<HEAD>

<TITLE>manualne pridanie zakaznikov</TITLE>

</HEAD>

<BODY>

<?

/*

Manualne pridanie zakaznikov do DB customers a address_book

*/

$doplnit = 'doplnit';

$pohlavie = 'm';

$text_null = 'NULL';

$dob = '0000-00-00 00:00:00';

$nazov_csv_suboru = "pneusystem_zakaznici_upload_2_28_9_2009.csv";

$id_zakaznika = 100;

$psswd = 'd9131964bd7ee19833152e2fb0efa215:8b';

$newsletter = 1;

$krajina = 189;

$zona = 0;

require('includes/application_top.php');

define('EMAIL_TEXT_PRI_REGISTRACII', '

Vazeny zakaznik,

Vítame Vás v obchode Pneusystem - online objednavka pneumatik www.pneusystem.sk.

Mozete sa prihlásit pomocou Vasej e-mailovej adresy a inicializacným heslom: heslo123

Toto heslo si mozete kedykolvek zmenit v nastaveniach Vaseho úctu.

Nie sme klasicky internetovy obchod.

Hlavne vyhody nasho systemu :

1. Objednajte si pneumatiky, z pohodlia Vasej kancelarie do pneuservisu vo Vasom meste a zaplatite za ne spolu so sluzbami za servis v pneuservise.

2. Koniec prenasaniu pneumatik, cakajú Vas vo Vasom pneuservise.

3. Profesionalna starostlivost a prijatelna¡ cena za servis.

4. Pozadovany rozmer, kvalitu a rok vyroby pneumatik si skontrolujete na mieste pred montazou.

5. Presne viete, na koho sa mate pri reklamacii obratit.

6. Manazment vsetkych Vasich objednavok.

Pre pomoc s akymikolvek nasimi sluzbami nam napiste na adresu [email protected]');

//meno suboru z ktoreho sa nacitaju data na upload do databazy

$fp = fopen ($nazov_csv_suboru,"r");

//vynulovanie poctu riadkov v nacitanom subore

$r=0;

//nacitavanie dat z .csv suboru poriadkov

//data sa nacitaju do pola $poleDat[riadok][stlpec]

while ($data = fgetcsv ($fp, 1000, ";"))

{

// otvorenie DB connection

$db_con = mysql_connect("mysql5.nic.sk","commercial","hgp92");

// vybratie DB commercial

mysql_select_db("commercial", $db_con);

if (!$db_con)

{

die('Chyba pripojenia ku databaze: ' . mysql_error());

}

$prikaz_sql_insert_customers = ""; // vynulovanie sql prikazu pre tabulku customers

$prikaz_sql_insert_adresa = ""; // vynulovanie sql prikazu pre tabulku adress_book

$num = count ($data); //pocet riadkov suboru

for ($c=0; $c<$num; $c++)

{

$poleDat[$c][$r] = $data[$c];

if ($c == 0) //len prvy stlpec kde je nazov firmy

{

$firma = $poleDat[$c][$r];

echo "Nazov firmy: ", $firma;

echo " ";

}

// koniec zistenia nazvu firmy

if ($c ==1) //len druhyy stlpec kde je mesto

{

$mesto = $poleDat[$c][$r];

echo "Mesto: ", $mesto;

echo " ";

}

// koniec zistenia Mesto

//zistenie e-mailu

if ($c == 2) //zistuje sa len treti stlpec kde je rozmer kolesa v poslednych dvoch znakoch

{

$e_mail = trim ($poleDat[$c][$r]); //ocistenie o prazdne znaky

echo "E-mail: ", $e_mail;

echo " ";

}

//poskladanie sql prikazu na vlozenie noveho zakaznika do databazy

$prikaz_sql_insert_customers = "INSERT INTO customers (customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter) VALUES ";

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "(";

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . $id_zakaznika . ","; //ID

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $pohlavie . "'" . ","; //GENDER

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $doplnit . "'" . ","; //FIRST NAME

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $firma . "'" . ",";//LAST NAME

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $dob . "'" . ",";//DOB

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $e_mail . "'" . ",";//EMAIL

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . $id_zakaznika . ",";//DEFAULT_ADDRESS

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "''" . ",";//PHONE

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "''" . ",";//FAX

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . "'" . $psswd . "'" . ",";//PSSWD

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . $newsletter;//NEWSLETTER

$prikaz_sql_insert_customers = $prikaz_sql_insert_customers . ")";

//echo $prikaz_sql_insert_customers;

//echo " ";

mysql_query($prikaz_sql_insert_customers);

//poskladanie sql prikazu na vlozenie adresy noveho zakaznika do databazy

$prikaz_sql_insert_adresa = "INSERT INTO address_book (address_book_id, customers_id, entry_gender, entry_company, entry_company_ico, entry_company_dic, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id) VALUES ";

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "(";

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . $id_zakaznika . ",";//ADRESS BOOK ID

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . $id_zakaznika . ",";//CUSTOMER ID

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $pohlavie . "'" . ",";//GENDER

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $firma . "'" . ",";//COMPANY

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "''" . ",";//ICO

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "''" . ",";//DIC

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $doplnit . "'" . ",";//FIRST NAME

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $doplnit . "'" . ",";//LAST NAME

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $doplnit . "'" . ",";//STREET

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $text_null . "'" . ",";//SUBURB

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "''" . ",";//PSC

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $mesto . "'" . ",";//MESTO

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . "'" . $text_null . "'" . ",";//STAT

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . $krajina . ",";//KRAJINA

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . $zona;//ZONA

$prikaz_sql_insert_adresa = $prikaz_sql_insert_adresa . ")";

//echo $prikaz_sql_insert_adresa;

//echo " ";

mysql_query($prikaz_sql_insert_adresa);

//******************************************************************

// bol nacitany jeden cely riadok

//******************************************************************

echo " ";

// odoslanie mailu novovytvorenemu zakaznikovy

$komu_poslat = $e_mail;

$from = '[email protected]';

$subject = 'Vitajte v obchode Pneusystem - online objednavka pneumatak www.pneusystem.sk';

$message = EMAIL_TEXT_PRI_REGISTRACII;

//Let's build a message object using the email class

$mimemessage = new email(array('X-Mailer: osCommerce'));

// add the message to the object

$mimemessage->add_text($message);

$mimemessage->build_message();

$mimemessage->send($firma, $komu_poslat, '', $from, $subject);

$id_zakaznika++;//dalsie ID zakaznika

$text_potvrdenie = 'Uvitací email bol odoslaný na adresu:' . $komu_poslat;

echo $text_potvrdenie;

echo " ";

}

//uzavretie .csv suboru

fclose ($fp);

//uzavretie DB connection

mysql_close($db_con);

?>

</BODY>

</HTML>

--------------------------------------------------------------------------------------------------------------------------------

♥ecartz · October 3, 2009

Looking through your code, I don't see an equivalent of

	  $address_id = tep_db_insert_id();

  tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");

from create_account.php

shamble · October 5, 2009

thanks for your hint

sounds like this can be my problem

I'll do some tests with it

Shamble

shamble · October 5, 2009

Hello Matt

it was not in customer default address

but I didn't feed data into customers_info table

i don't know why I just missed this table :-)

now it works fine with my script to import customers from csv file

regards

Mario

Manually added customers with addreses - what did I wrong

Recommended Posts

shamble

♥ecartz

shamble

shamble

Archived

Browse

Activity