Jump to content

Retail to Wholesale


lns

Recommended Posts

Good day all and thanks for your input in advance.

My issue appears to be somewhat different then the others I have seen. I have a retail site, and wish to copy it to a wholesale site. This I have done with no issues except when I change the pricing on the wholesale side they also change the pricing on the retail side...hmmmm

Do I need to do a whole new wholesale side with prices etc, or what file(s) can I edit and to what to make it so? I assume by the reaction I am still for some reason going to my retail sql database.

Any help would be greatly appreciated.

:)

Link to comment
Share on other sites

There are mods to allow different prices, depending on the customer logged into the store, ie Retail customers see retail prices, and wholesalers see another.

Check out one of the 3rd party sites listed for details.

Jason

Link to comment
Share on other sites

How did you copy it?

If you are sharing 1 database for the 2 stores, yes, you would need a mod as vokf suggests. If you copied - backed up the database from your retail side and copied it into a new database for the wholesale side, this wouldn't happen and you could set what ever prices you want.

If you did set up a new database, odds are you didn't change the config file to reflect the new database information and are pulling everything from the old one.

Link to comment
Share on other sites

I feel I am using the same database.

I do have a seperate MYSQL database for the retail as well as the wholesale. It would appear that in the copying, I have kept the retail database which I do not want to use. What file(s) would I need to edit and approx where would I edit them? If I edit the config file, will I not loose all the info from the retail site? pricing description etc, as it will now point to a blank dbase?

Basically I just FTP'd my retail site to my system as backup and then uploaded it to the wholesale side.

There should be no need as of yet to backup the wholesale dbase as it has nothing in it as of yet. If what I here you mentioning, if I backup both the empty wholesale and full retail dbases', then copy and paste the retail to the wholesale, save the wholesale, then re-post the new wholesale with all the info? Is this what you are saying?...what the hell I will give that a shot...sounds like it may work

How did you copy it?

If you are sharing 1 database for the 2 stores, yes, you would need a mod as vokf suggests. If you copied - backed up the database from your retail side and copied it into a new database for the wholesale side, this wouldn't happen and you could set what ever prices you want.

If you did set up a new database, odds are you didn't change the config file to reflect the new database information and are pulling everything from the old one.

Link to comment
Share on other sites

Okay so you have 2 cubecart installations, right? 1 Retail, 1 Wholesale?

If that is so, all you need to do is change the database information in config.inc.php in the WHOLESALE one to point to the new database. Then just backup the retail database and restore it to the new wholesale one, then change your prices as normal.

You would then have 2 separate admin areas affecting 2 separate databases.

Link to comment
Share on other sites

[sorry to appear to be an aXX. I have been through all my config.inc.php files from my ftp'd backup and I see no reference anywhere with regards to changing the DBase. I really a[reciate the help and if easier please feel free to email me direct at [email protected]

quote name='Mysty' date='Jun 1 2007, 07:07 PM' post='128977']

Okay so you have 2 cubecart installations, right? 1 Retail, 1 Wholesale?

If that is so, all you need to do is change the database information in config.inc.php in the WHOLESALE one to point to the new database. Then just backup the retail database and restore it to the new wholesale one, then change your prices as normal.

You would then have 2 separate admin areas affecting 2 separate databases.

Link to comment
Share on other sites

config.inc.php includes things like database name, database path, and password. If these don't match the new database you did, your wholesale site will continue to use your retail database.

Don't know how I can make it clearer.

Link to comment
Share on other sites

I understand to the fullest what you are saying and that was the thought I had...I am probably not explaining myself correctly. When I do a search on my retail site for config.inc.php I get an entry in languages as well as modules\shipping\by price. I do not see the dbase stuff that I need to change...see below

language/en/config.inc.php

<?php

$langName = "English";

$charsetIso = "iso-8859-1";

$strftime = "%A %e, %B %Y";

?>

modules/shipping/By_Price

<?php

$module['amount'] = '4.95';

$module['level'] = '50';

$module['status'] = '1';

?>

I hope this clears it up a bit more...sorry for the confusion. Could it be another file?

Link to comment
Share on other sites

Okay that's because you are looking at the wrong file. You need to open and edit includes/global.inc.php - that is the main config file for the database information.

Link to comment
Share on other sites

Okay that's because you are looking at the wrong file. You need to open and edit includes/global.inc.php - that is the main config file for the database information.

Just quickly checked that file now...I think we has a winner...I will try shortly...thanks so much for the help and sorry for the little misunderstanding

Link to comment
Share on other sites

Ok I just did the editing of the file global.inc.php. I blanked my wholesale site out, uploaded a fresh retail to the wholesale so I have all products etc, copied over the new config.inc file, and now all I show is the original setup. 1 product us being default etc? I have been unable to find a mod that allows me to do wholesale or retail pricing...maybe this would be the way to go. I would prefer the first way though so people can not squeeze one bu me and purchase wholesale when they should be retail...hmmmmm...any thoughts?

Link to comment
Share on other sites

I have been unable to find a mod that allows me to do wholesale or retail pricing...maybe this would be the way to go. I would prefer the first way though so people can not squeeze one bu me and purchase wholesale when they should be retail...hmmmmm...any thoughts?

I guess you've not checked the 3rd party mods that I suggested a few days ago?

There is a commercial mod on cubecart.org to do exactly what you want.

http://www.cubecart.org/directory/index.ph...1-s&reset=1

Jason

Link to comment
Share on other sites

For those who have used the above link to get the gobber Product Pricing Levels mod, if you experience that you can not update your product after changing prices, I have found that if you toggle the "include in latest products in homepage?" from yes to no or from no to yes...this seems to have it working. You may need to do everytime you edit the product.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...