Jump to content
scendent

Seperate Pricing Per Customer v3.5

Recommended Posts

Any updates on a final fix for the products new page? If so, a fresh contibution would be great. Separate pricing for retail/wholesale is huge and should be a working part of oscommerce...plus its 99% complete!

Share this post


Link to post
Share on other sites

I will get this fixed and repackaged. I have been extremely busy lately and haven't been able to get to it.

 

What Sergio was saying should work. The tables need to be named 'products_groups' and not 'table_products_groups' - the same thing in admin and catalog.

 

Also, you need to remove the primary key in the table called 'products_groups'

 

As soon as I do this, I will repackaged and upload to the contrib section. It will be a few days because I'm still very busy, but I will get to it. :D

Share this post


Link to post
Share on other sites

Sethman,

 

Thank you very much for your efforts on this. Im looking forward to integrating this mod. I have just one question - Will the updated contribution include all the fixes, like adding the '}' in the specials.php file, etc. Basically, will the install instructions be completely rewritten? Thanks!

Share this post


Link to post
Share on other sites

Yes. I will make sure that the contrib will work perfectly before posting it here. I will update the instructions to make it an easy process.

 

Hopefully I can get to it soon, as I am using it on a live shop as we speak. But there are other issues that I am dealing with on this same store that are taking priority at the moment. I will get to it as soon as I can. :D

Share this post


Link to post
Share on other sites

I am getting this error in admin when I try to add a wholesale price to a product

 

1062 - Duplicate entry '27' for key 1

 

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('27', '499.9900', '2', 'r')

 

[TEP STOP]

 

I also have to wholesale fields at the bottom of the product screen in admin. Ca n someone tell me how I can fix this?

Share this post


Link to post
Share on other sites

Khalliq just read the forum for a few pages back, you should find the answer

Share this post


Link to post
Share on other sites

Did anyone ever find the answer to the products_new.php issue? I think it was the only issue left?


Best & Thanks;
Marvin
----------------------
osCommerce 2.3.3.4 

Share this post


Link to post
Share on other sites

hey marvin, I will be getting to it soon... I was looking at it before when we were chatting and I think I have narrowed it down, I just haven't had the time to finish... but I am determined to. I will make sure that I post on here when I repackage it.

Share this post


Link to post
Share on other sites
Khalliq just read the forum for a few pages back, you should find the answer

Hey Sethman,

 

If you were referring to this post

Fixing error "1062 - Duplicate entry '1' for key 1".

I changed the column 'customers_group_id' from PRIMARY to INDEX in the table 'product_groups' and it seems to work now. I don't know if this is the correct way or if it causes any other problem though...

I tried this and it did not work. Could it be because my errors are different? My error is below.

1062 - Duplicate entry '27' for key 1

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('27', '499.9900', '2', 'r')

[TEP STOP]

Share this post


Link to post
Share on other sites

I want to use different HTML disclaimers during checkout for different customers. For example, I have 2 different customer pricing - dealer and retail.

 

I want to have special html comments for dealers, and then special html comments for retail. I am guessing this is a simple in/then PHP query, however I know nothing about php. How would I go about doing this.

 

For example on my checkout_payment page I have the following notice, but I only want retail to see it

 

"Retail Customers Notice - We can only ship to the credit card billing address "

Edited by surfking

Share this post


Link to post
Share on other sites
Hey Sethman,

 

If you were referring to this post

 

I tried this and it did not work. Could it be because my errors are different? My error is below.

if you go back to the contributions page where you got the separate pricing per customer, it has directions on what you should do to fix that error.

it works.


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites

I need to add 10 pricing groups, How do I add this. please don't tell me I have to configure the entire install for this.

 

 

I have done a key word search on this question, found one person asking this, but there has not been a reply.

 

boogie boogie boo

:P ( o )( o )


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites
if you go back to the contributions page where you got the separate pricing per customer, it has directions on what you should do to fix that error.

it works.

Babysweet,

I did this too.

If you are getting a duplicate key entry, go into your database and open the "products_groups" table and make the "products_id" the primary key.

 

That will fix your problem.

No file attached.

 

Emmanuel

Maybe I am not doing this correctly.

This is what I did. In phpmyadmin I clicked on the "properties" link in the "products_groups" table. I then clicked on the "primary" link in the "products_id" field. After that I went to admin and added the wholesale price to a product and I got this error;

1062 - Duplicate entry '21' for key 1

 

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('21', '79.9900', '2', 'r')

 

[TEP STOP]

Did I do this right?

Share this post


Link to post
Share on other sites

it must not be making the products_groups the primary key. That is the only thing that has been causing that error.

 

Try to do it again, and if it doesn't work, contact your host and ask them about it.

 

What version of phpmyadmin are you using?

Share this post


Link to post
Share on other sites
Babysweet,

I did this too.

 

Maybe I am not doing this correctly.

This is what I did. In phpmyadmin I clicked on the "properties" link in the "products_groups" table. I then clicked on the "primary" link in the "products_id" field. After that I went to admin and added the wholesale price to a product and I got this error;

 

Did I do this right?

 

Khaaliq,

 

Take a look in my post in a few pages before.

I talk about a duplicate table and about admin and frontend uses a diferent tables, the admin use a table call table_product_groups and the catalog uses a table call product_group.

 

You need seach and replace (on admin) where is writed table_products_groups for products_groups. Then remove the primary key from products_groups

Share this post


Link to post
Share on other sites
Khaaliq,

 

Take a look in my post in a few pages before.

I talk about a duplicate table and about admin and frontend uses a diferent tables, the admin use a table call table_product_groups and the catalog uses a table call product_group.

 

You need seach and replace (on admin) where is writed table_products_groups for products_groups. Then remove the primary key from products_groups

 

Sergio,

 

I replaced in admin/categories table_products_groups with products_groups. I removed the primary key from products_groups and I get this error;

1146 - Table 'khaaliq_puresoap.PRODUCTS_GROUPS' doesn't exist

 

select customers_group_id, customers_group_price from PRODUCTS_GROUPS where products_id = '26' and customers_group_id = '1' order by customers_group_id

 

[TEP STOP]

When I put categories back the way that I had it I get not errors but the prices that I added the wholesale prices to are all 0.00.

Share this post


Link to post
Share on other sites

Grasshopper,

one thing, you do the primary key change in MySql, you must remove the old primary key, then make the new primary key.

wow what I just typed is vague.

 

it just sounds like to me that you are not doing this in the right place. the MySql is the database, its separate from PHP aspect.

 

let me see if I can be clearer.

 

you go into your mysql database administration, get into the structure of your database, find the correct table. then you want to edit that table, the primary key is indicated by an underline of the name of the field. Below the fields is where you can edit the primary key, what you want to do is drop the primary key, then go back up to the fields and assign the proper field as primary.

 

Do this and you will be allowed to attempt to snatch the rock from my hand.

 

Boogie boo boo

:-" ( y )


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites

So, may I take from the absence of any reply that there is no way to add more groups.

 

I really don't wish to rewrite the code.

 

hmmmmmm poopy

 

assistance requested.

 

you might ask, why would I need 10 groups. well honestly I don't know, I am doing this for a "friend" and that is what they want.

Friends suck

 

Boogie boo boo

( o )( o )

 

( y )


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites

why can't you just add 10 price groups? I think the bad thing right now is that you need at least one customer at each price level to keep the price level. So I think you might have to add 10 "fake" customers at each level.

 

Does it just not let you add that many?

Share this post


Link to post
Share on other sites
why can't you just add 10 price groups?  I think the bad thing right now is that you need at least one customer at each price level to keep the price level.  So I think you might have to add 10 "fake" customers at each level.

 

  Does it just not let you add that many?

There is the question, how do I add the price groups in the first place


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites

ah... I see.

 

You must add the price group to an existing customer by using the Admin>>Customers>>Edit

 

The bad thing about this contrib at this time, is that you have to have at least one customer at each price level for the price level to even exist. So if you want 10 different price levels, you must have 10 different customers, each at one price level.

 

The way I do it, is name one customer "Retail", one "Wholesale", one "VIP", etc. etc. and give them the same price level as their name. So if you want 10, you could name them, One with price level 1, Two with price level 2, and so on.

 

In other words, if you want to create a new price level, you either have to assign it to an existing customer, which will create the new price level, or you have to create an entirely new customer and assign them the new price level. Make sense?

 

Hope this helps

Edited by Sethman

Share this post


Link to post
Share on other sites
ah... I see.

 

You must add the price group to an existing customer by using the Admin>>Customers>>Edit

 

The bad thing about this contrib at this time, is that you have to have at least one customer at each price level for the price level to even exist.  So if you want 10 different price levels, you must have 10 different customers, each at one price level.

 

The way I do it, is name one customer "Retail", one "Wholesale", one "VIP", etc. etc. and give them the same price level as their name.  So if you want 10, you could name them, One with price level 1, Two with price level 2, and so on.

 

In other words, if you want to create a new price level, you either have to assign it to an existing customer, which will create the new price level, or you have to create an entirely new customer and assign them the new price level.  Make sense? 

 

 

Hope this helps

 

 

Ah Ha, I will do it, Thanks for explaining it.


Sincerely,

Joseph Seabert

Share this post


Link to post
Share on other sites

Hi,

 

I'm using the seperate price per customer contribution, and I would like the customer_group_name to appear next to the customer name in the admin/orders.php so when I view my orders, I can see if it is an order made by public, distributor or other. I understand a little php but I haven't been able to get it to work. Does anybody have the solution to the problem? Thanx in advance.

 

I'm adding the column name here (for people interested) :

 

   <tr class="dataTableHeadingRow">
     <td class="dataTableHeadingContent" width='30'><?php echo 'ID #'; ?></td>
     <td class="dataTableHeadingContent">Group</td>
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
   <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
             </tr>

I haven't bothered with language, Group will do fine (ID # is so I can show the ID number of the order).

 

And for the content :

 

<td class="<?php echo $current_row; ?>"><?php echo '<font face=verdana size=1>' . $orders['orders_id']; ?></font></td>
   <td class="<?php echo $current_row; ?>"><?php echo '' . $customers['customers_group_id']; ?></font></td>
   <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
   <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
               <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
               <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
               <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

 

So the bit of code that I have got wrong is

<?php echo '' . $customers['customers_group_id']; ?>

Anyone know what I should put here ?

 

Thanx a lot.

Share this post


Link to post
Share on other sites

when you are typing

<?php echo '' . $customers['customers_group_id']; ?>

 

you are calling the group_id from the TABLE_ORDERS, which does not contain a group_id. You need to call it from the TABLE_CUSTOMERS.

 

How to do that... I do not know. But at least I can point you in the right direction... :thumbsup:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×