Multiple Stores

[Ian-San]

This is from the archive forum:

 

From: Linda McGrath [mailto:[email protected]]  

Sent: 17 August 2002 17:05  

To: General Mailing List  

Subject: [OSC-GENERAL] Re: Multiple Stores  

 

 

This message was sent from: General Mailing List.  

>  

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

 

I have a multiple store layout I am working on that shows for both the  

customer and the admin the store that the products were purchased from.  

 

This can be adapted to show/not show the customer things from other stores.  

 

It utilizes 1 MySQL database for everything.  

 

I think this is a great idea and I hope you dont lose sight of it Linda. :wink:

 

Currently, I use two databases to manage my dual-language shop as I do not want to simply convert the prices between currencies nor do I want to have the same products available in all countries. However, it is a right pain having to update everything twice, add products twice that I do want duplicated etc. etc.

 

I realsie that this must be on the now extremely long wish list but I thought I would just bring it back into focus for a short while.

[Ajeh]

I haven't forgotten it.

 

I am working on making it either site defined store code or customer defined store code.

 

I have to think about the countries issue and see how that would fit into this.

[jgriesba]

I have same need for this feature? What's the status? ANy suggestions on how to pull it off?

 

Thanks

Joseph

[jyt]

Me too! I have a similar need, two prices per items, one of which is in CDN and the other in USD, so customer from Canada get the Canadian pricing and all the other country get the USD pricing. is this possible?

and also I need it incorporate in the admin section as well.

 

That's me wish

[SirDodson]

Ajeh, I have been somewhat following posts concerning multiple stores. I find yours the most interesting and compatible with what I seek. I am, however confused on the option between "site defined" or "customer defined". What do the two mean?

 

Thanks.

[Guest]

Me too! I have a similar need, two prices per items, one of which is in CDN and the other in USD, so customer from Canada get the Canadian pricing and all the other country get the USD pricing. is this possible?  

and also I need it incorporate in the admin section as well.  

 

That's me wish

 

You can do this now by going to admin and adding currency for CDN or USD (whichever you currently lack)

[jyt]

Me too! I have a similar need, two prices per items, one of which is in CDN and the other in USD, so customer from Canada get the Canadian pricing and all the other country get the USD pricing. is this possible?  

and also I need it incorporate in the admin section as well.  

 

That's me wish

 

You can do this now by going to admin and adding currency for CDN or USD (whichever you currently lack)

 

not sure if you understand the problem here, yes i know how to had more then one currency, the problem is the price is control by a % rate and can not be enter in each products itself, like having two price one in CDN and the other in USD, I don't want to used the currencies exchange at all, but also I need to pick which country will see the CDN or the USD, actually USD should be to everyone else other then Canada.

 

That is the problem here that I'm trying to figure out.

[mdfst13]

Have you tried the Separate pricing per customer contribution? It would allow you to put all your Canadian customers in a separate group for pricing.

 

Good luck,

Matt

[jyt]

Have you tried the Separate pricing per customer contribution?  It would allow you to put all your Canadian customers in a separate group for pricing.

 

Good luck,

Matt

 

that sound promissing, but this also mean that you have to put customer in the proper group before they order, which is not totally what I wanted, perhaps there is a way to assign group to country before people join the store. how could i assign country to group?

[mdfst13]

It's not set up to do this through the configuration, but you could do it relatively easily by changing

if ($error == false) {

     $sql_data_array = array('customers_firstname' => $firstname,

                             'customers_lastname' => $lastname,

                             'customers_email_address' => $email_address,

                             'customers_telephone' => $telephone,

                             'customers_fax' => $fax,

                             'customers_newsletter' => $newsletter,

                             'customers_password' => tep_encrypt_password($password));



     if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;

     if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);



     tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

to read

if ($error == false) {

     $customers_group_id = 0;

     if ($country == '38') {  // 38 is the code for Canada

       $customers_group_id = 1;  // I made this up; set it appropriately

     }

     $sql_data_array = array('customers_firstname' => $firstname,

                             'customers_lastname' => $lastname,

                             'customers_email_address' => $email_address,

                             'customers_telephone' => $telephone,

                             'customers_fax' => $fax,

                             'customers_newsletter' => $newsletter,

                             'customers_password' => tep_encrypt_password($password)

                             'customers_group_id' => $customers_group_id);



     if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;

     if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);



     tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

The added lines are 2-5. Note: you would also have to manually change the group for any Canadian customers when you installed the module. This just makes sure that new customers are assigned to the appropriate group.

 

Depending on how you feel about PHP coding, you could also modify the separate price contribution to use country and/or currency to determine which pricing group to use.

 

Hth,

Matt