Hi eveybody,
I am working on my new site www,simplementenergia.es selling Solar equip I am primarily an wholesaler but i would like to sell to the public as well. I am trying to make all products have a trade price that is controlled by the sign in.
I need to have control of the sign in to make sure the applicants are bona fide tradersand i would like to send the password personally by email.
The products have obviously got to be duplicated with a trade price or is it easier to offer a percentage discount on the volume of turnover.
Can the more experienced people tell me what they think and how would i go about it.
I hope I have posted this right.
Cheers
Catalunian
Latest News: (loading..)
0
Your help needed in OSC 2.3, I want trade prices
Started by catalunian, Jul 21 2012 08:17 PM
osc 2.3 trade pricing password controlled solar panels solar pv
5 replies to this topic
#2
DunWeb
-
- Members
- 12,819 posts
The Censored One
- Real Name:Chris
- Gender:Male
- Location:Ontario, Canada
Posted 21 July 2012 - 08:32 PM
:|: Was this post helpful ? Click the LIKE THIS button :|:
See my Profile to learn more about add ons, templates, support plans and custom coding (click here)
See my Profile to learn more about add ons, templates, support plans and custom coding (click here)
#3 ONLINE
burt
-
- Community Team
- 7,871 posts
Code Monkey
- Real Name:G Burton
- Gender:Male
- Location:UK/DEV/on
Posted 22 July 2012 - 01:01 PM
If you do not want to go down the route of installing a addon, then;
If the prices on all the products are to be reduced by a fixed %, then you could make something a lot easier by;
1. adding some type of flag to customers to show if they are to be a "trade" or "retail" customer
2. when a customer logs in, start a "type_of_customer" session, and if it is trade
3. show the % lower (or higher, whatever) prices. Done by amending a couple of lines of code in shopping_cart class
That's a lot easier, but still fairly complicated. In any case, you need to decide whether to use an already made addon,
or to make code that fits your needs exactly.
If the prices on all the products are to be reduced by a fixed %, then you could make something a lot easier by;
1. adding some type of flag to customers to show if they are to be a "trade" or "retail" customer
2. when a customer logs in, start a "type_of_customer" session, and if it is trade
3. show the % lower (or higher, whatever) prices. Done by amending a couple of lines of code in shopping_cart class
That's a lot easier, but still fairly complicated. In any case, you need to decide whether to use an already made addon,
or to make code that fits your needs exactly.
Dummies guide to designing osCommerce 2.3 Click Me
Or maybe a ready made theme for your shop ??
Warning: My posts may contain Horsemeat.
Or maybe a ready made theme for your shop ??
Warning: My posts may contain Horsemeat.
#4
Posted 22 July 2012 - 02:21 PM
Hello and thanks for your replies,
I went down the add on (Separate price for each customer) road as I am not very good with code.but i have a fault when I try my web it now shows this message
1054 - Unknown column 'customers_group_id' in 'where clause'
select specials_new_products_price from specials where products_id = '46' and status and customers_group_id = '0'
(TEP ST0P)
so where is the problem.or what does it mean I haven't got a clue
I started the topic here so I will carry on.
Rod
I went down the add on (Separate price for each customer) road as I am not very good with code.but i have a fault when I try my web it now shows this message
1054 - Unknown column 'customers_group_id' in 'where clause'
select specials_new_products_price from specials where products_id = '46' and status and customers_group_id = '0'
(TEP ST0P)
so where is the problem.or what does it mean I haven't got a clue
I started the topic here so I will carry on.
Rod
I live for today I might die tomorrow
#5 ONLINE
14steve14
-
- Members
- 3,113 posts
STORE OWNER NOT CODER
- Real Name:Steve
- Gender:Male
- Location:Dorset UK
Posted 22 July 2012 - 03:13 PM
Have a look here http://forums.oscommerce.com/topic/280288-1054-unknown-column-ccustomers-group-id-in-on-clause/
REMEMBER BACKUP, BACKUP AND BACKUP
I am not a coder, so dont bother sending PMs asking for help as you wont get any.
OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
I am not a coder, so dont bother sending PMs asking for help as you wont get any.
OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
#6
DunWeb
-
- Members
- 12,819 posts
The Censored One
- Real Name:Chris
- Gender:Male
- Location:Ontario, Canada
Posted 22 July 2012 - 03:38 PM
:|: Was this post helpful ? Click the LIKE THIS button :|:
See my Profile to learn more about add ons, templates, support plans and custom coding (click here)
See my Profile to learn more about add ons, templates, support plans and custom coding (click here)
