Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Question?


mtechama

Recommended Posts

Can I have 2 osCommerce on one website one is for retail and one for wholesalers?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Yes. There are various means to accomplish this. A quick (but non-comprehensive) of methods summary is below:

1) 2 databases, 2 sets of files, 2 domains

2) 2 databases, 2 sets of files, 1 domain, using subdirectories for the shops

3) 1 database, but using table prefixes (IOW it's functionally much like 2 databases, but only actually takes up 1 MySQL database), 2 set of files, 2 domains (or 1 domain using method #2 above)

4) 1 database, 1 set of files, 1 domain, install the Separate Price per Customer (SPPC) contribution

 

If you choose #4, you may also want to add the Quantity Discount for SPPC contrib.

 

-jared

Link to comment
Share on other sites

Yes. There are various means to accomplish this. A quick (but non-comprehensive) of methods summary is below:

1) 2 databases, 2 sets of files, 2 domains

2) 2 databases, 2 sets of files, 1 domain, using subdirectories for the shops

3) 1 database, but using table prefixes (IOW it's functionally much like 2 databases, but only actually takes up 1 MySQL database), 2 set of files, 2 domains (or 1 domain using method #2 above)

4) 1 database, 1 set of files, 1 domain, install the Separate Price per Customer (SPPC) contribution

 

If you choose #4, you may also want to add the Quantity Discount for SPPC contrib.

 

-jared

 

Thanks for the info. I'm saving this thread. I'm sure it'll come in handy some day soon.

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

One other question I am planning to setup each wholesaler Sub account number like for an example http://wholesalers.yourdamain.com/account# and have there own osCommerce for that wholesaler if I have 10 wholesalers and I want to tie that osCommerce to 1 MySQL and I want to know if that is possible.

For An Example:

 

Wholesaler No.1 there account number is 10001

have their own shop with name only

 

Wholesaler No.5 account number is 50005

Have their own shop with name only

 

Wholesaler No.10 Account number is 101010

Have Their own Shop with name only

 

Like Welcome,Their Name

 

http://wholesalers.yourdamain.com/#account each folder within the wholesale subdomain will have customers account number? If I enter the wholesalers account I won't have re-enter the products for each wholesaler. What I am trying to say is when I am entering the 1st Wholesaler shop for that customer everything is setup for that first shop. Now when setup the 2nd Wholesaler shop is it possible that can pull all pruducts pics and all from that database instead of having a 3rd database? so I won't have to re-enter everything in the 2nd wholesalers accounts shop and so on?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

From what I was reading here before, there is a contrib that will allow you to create "affilliate" shops. That may be easier and simpler to do. Just a thought.

 

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

The "affiliate" is what you mean is when I got 15 wholesalers shops and can pull all the database from 1 MySQL?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Ok If I am the Admin for all shop. if there updates and all is that mean that I have to go in each shop and do all the updates instead of using 1 shop to do all the updates. ok lets say that I have shop is the main shop(admin) and I enter all the products,prices and all. ok that is the main shop(admin) then I have a 1st Wholesaler came in I set their shop in one folder within a subdomain. doesn't that mean I have to re-enter all the products, prices and updates for each site instead of each shop pulling all the information from the database that I have entered from the main shop(admin) site?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

so the "Multi Shops or Store" if I had the main Shop for the Adminstrators I enter all the Products, Prices and Updates will the main shop(admin) controls all the store(Multi Shops or stores) on one database?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

If I have a multi stores and I have one store controls all other stores for products, description, and prices in 1 database is that possible?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Sometimes it takes more than a day for someone who knows something about a particular contrib to respond. Patience, Grasshopper! (I'd help but I'm not familiar with that contrib).

 

-jared

Link to comment
Share on other sites

Ok I am going to say this once..... Will osCommerce will do 10 or 20 muli stores with 1 MySQL for an example:

 

Store 1 (Admin) Main Store Enters all Products,Descriptions,Prices and Updates

 

Stores 2 to 20 regular stores

 

Will Store 1 controls all stores 2 to 20

 

Will all Stores 2 to 20 can pull all the Products,Descriptions,Prices and all Updates from Store 1 So I won't have re-enter the data for each store?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Sounds like you're getting frustrated. I'm sorry for that.

 

I *believe* that Multi Store will do exactly what you're describing. Personally, I'm never satisfied with what a contribution will do until I install it and see for myself (which also highlights the usefulness of having a test server).

 

-jared

Link to comment
Share on other sites

so are you saying to try it out on a test server and see if it works?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

I have done a test pages here is my direct link http://storestest.mtechama-test.com and my main store(master) is working fine and I looked on another computer looked on the Store 1 got no images and others are working just fine why is that?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

Store #1 isn't pulling image from Database that I have enter from the (Master)Admin Store its trying to fine image in Store#1 Image file its not in there. But its in the Master Admin Store's Image File.

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

On multi-store mod - is central checkout at the main install domain, different, or can you select? The reason I ask is I need to order a secure certificate for checkout. Would like to do all this with a fresh install.

Link to comment
Share on other sites

I'm asking anyone who has the answer. What I would like to do is have a wildcard SSL certificate and have all shops do central checkout at one domain. Otherwise I think I need to have an SSL certificate for each individual site.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...