B2BSuite

What?
B2BSuite is an OsCommerce contribution for Business to Business.
It make efficient shop solution for wholesale sell’s or fidelity your customers with a optimal-price reduction.

Features:

Complete Business to business solution,
Can work as a discount OR markup mode,
Customers can be associated to group,
Assign a percentage of group,
Assign a percentage of categories into every group,
Manual prices for group for every product, possible,
Automatic markup (+) / discount (-),
% or manually pricing stored to db,
Assign a specific price per group for single product,
re-generation price for every product / group customers,
Assign a special price (percentage or specific price) as normal osc,
Can work with product values,
Price can be hidden from non registered users,
Price update for fast change and manage price of all groups,
Payments allowed for every group, can be assigned from admin,
Member of b2b can be approved or not by admin,
For every group can be assigned specif color for highlit in orders screen,
New layout of categories.php,
Price can be show with or without tax for every group

Layout Process Schema:

Installation Scenario’s:

B2BSuite is a contribution of OsCommerce, so you must have a Osc cart installed and running.
There are some “scenarios” for installation;
First, BACKUP BACKUP AND BACKUP your data!!

scenario one:
clean install into e cart system. Simply copy the inside
folder “catalog” in your “catalog” cart and replace all files.
run b2bsuite.sql with your favorite db manager (as phpmyadmin)
Now you have installed b2bsuite.

scenario 2:
Manual installation, code to code. After package usually we made a diff package with differences between original OsCommerce installation and B2Bsuite installation.
The Manual apply can be performed automatically with software like WinMerge.
run b2bsuite.sql with your favorite db manager (as phpmyadmin)

scenario 3:
upgrade from previous package of B2BSuite.
As the manual installation i’ve added a upgrade_fromxx.htm, similar to manual, you find only the modified in diff format.
run b2bsuite.sql with your favorite db manager (as phpmyadmin)
“but i’m not a guru of php”…
No problem, for every release we update a full oscommerce package, with B2BSuite already installed. You have only to run install scripts, after that you have a running b2b/b2c website. Get it on file repository of this website.

Notice: I see some users make change with Word processor or similar software. Attention, the code is born with indentation and wrap lines, this software’s destroy this hidden information, please use only a qualified php editor as HtmlKit of Chami or phpedit for free!

DISCOUNT OR MARKUP?

Discount system

How works?
The system work on 2 ways, a markuyp system OR discount system, you can setup OR switch them simply under the:
ADMIN -> CONFIGURATION -> B2B

discount = false
markup = true

pratical example:
price – %discount = group_price

This price is apply only when customers (of related group) is logged-in.
You can apply specials, option values to this price.

Markup System

How works?
Similar to Discount system, the markup is based on your basic price that is your buyed price. On groups will be charged with specific percentage you have choice per group.  If the product is inside a category with a percentage declared on category under groups, this override the main group % assigned.
There is a way to switch for specific product into manually mode and force the price.  Every price will be stored on DB.  See picture below.

The main goal is the write process on database under admin session (usually not obsessive), and show a price to customer via DB call and not to calculate on the fly, like other systems.

Customer Groups

B2BSuite is based on creation and managment of specific customers groups.
Each Group have Global Discount or Markup, plus a percentage for Categories, a rapresentative color and the exclusion of specific type of shipping role.

After installation you have a new menu under your
ADMIN -> CUSTOMERS -> Groups

In the main screen you can see all your exiting groups and the main percentage of markup or discount

On the right side, you have 4 buttons, edit, delete, new group and apply price.
In edit and new group you will be in new screen, for manage the group.

CREATE / Modify
in the editing screen you can change the rapresentative name of your customer group, assign a main percentage and assign a specific percentage for one or many exiting shop’s categories.

MAIN PERCENTAGE
The main percentage of markup / discount works for all products in your catalog, except if you have declared a specifid percentage of one or more categories. eg:
basic price: € 100,00
main discount percentage for wholesale: 10%
wholesale price: € 90,00

CATEGORIES PERCENTAGE
How works shop category? Basically override the main percentage markup / discount, eg:
Basic price: € 100,00
Wholesale discount percentage for category x 20%
Wholesale price in category x: € 80,00

ASSIGN GROUP TO CUSTOMERS
After creation of group, you can assign to existing customer a specific group.
Go to ADMIN -> CUSTOMERS -> CUSTOMERS
choose a customers, now at the end of form, you have a dropdown list with all groups plus a “non” group, or retail group.

Every new customers is registered, have no group access. You have to choose manually where group will be assigned.

Color system
From 0.90 you can assign a specific color of group. This help you to fast identify the orders from a specific group.

below and example of new order screen

PRICE WITH OR WITHOUT TAX
from 0.91 you can choose if specific group show prices taxed or not. In Germany this is required by law, but i think can be cool also for other people. The price can be viewed also with a little tag that explain if is it taxed or not, expecially for not create confusion to users and admin’s.

Hide Prices

Often, into specific B2B project are needed to hide prices from guest or unathorized guests.
We have integrated, into b2bsuite a great contrib, “Prices for Logged-In Users Only” by Gunnar Hellekson and Bjarke Bundgaard.

This feature can easily hide prices to guest, and show price only to registerd users with your own group-price.

You can turn on/off this application into your ADMIN -> CONFIGURATION -> HIDE PRICES
where true = hide price
and false = show price

When price is hided, instead of it appear a request for log-in (the link point to login page).

Disclaimer for Markup system!
If you have choose a markup system, pay attention a little mistake. When a new user is register, his have a customer_group=0, this means is show a basic OsC price.
YOU MUST, through PhpMyAdmin set in the main table of customers_groups, at row customers_group_id default 1.
So when a new register, is automatically provided a first group of your customers. If you want choose another group, change the value 1 with your correspondet id of group.

Specials

B2BSuite integrate also special price from original OsCommerce project feature.
The layout as the same original except for new dropdown list called “Customer Group”, where you can choose your group to assign a special price. In the Product dropdown list, you see the name of product and within parenthesis the group price, included basic price)

As the original specials.php you can insert a particular price or percentage of discount (eg: 10%) and the expiry date, if you want.

In the main screen of specials, you see product selected, original price and in red new price. Within price if group is selected, you see the customer group interested of special price. So if you want apply special to more group, you must repeat the operation (see in the screenshot product Blade Runner)

Customer Approvation

New from version Beta 0.85 of B2BSUITE we have make a customer approvation.
This is an approval customers account and customer group assignment, useful for B2B Carts. From configuration you can choose from normal account (customers choose directly their password and can logged-id directly to shop) or approval system (no password fields are show, and you must approve by admin area).
You can setup approval system (TRUE) or normal mode (FALSE) by trigger in configuration -> myStore menu.

How works?
In create account you can show password fields or not (see pictures below)

In approval system, when user sign-up you receive Email notification (also customer receive an explain mail notification, you can easily change text modifying in languages file create_account_success.php).
Once your receive notify, you must approve or reject approval request by new menu under Customers.

This screen show only customers waiting approvation. When you approve, or delete it, the customers list will be update.
Ok now see approval system, check the customer (like Osc layout) by click on their name, then press “Activate”, now the box on top-right will be update, and now show the Customers groups dropdown list, choose your group and press “Activate” again (see pictures below)

On 2nd press of activate, the scripts send to customer two mails. Once notify that his account is being approved, and second sends account data. The script generate a random password and store-it into db in md5 encrypt. The password is print in clear into second mail.

You can change email text by editing file:
/catalog/admin/includes/languages/YOURLANG/members.php

attention!
Some user reported to me, that some php class incompatibilities if you have already installed password_forgotten.php (probably installed from another contribution) into /admin directory.
If you have this, rename the existent file, and upload from my package.

Download

You can download latest version of B2BSUITE from here:

B2BSuite Beta Download

Download courtesy of

Disclaimer:
Caneblu.com is not a commercial website. We deploy some scripting solutions into spirit of GNU/GPL license.
Development is made on our free-time, so commercial applications of software provided by caneblu.com is without any warranty of security, upgrade and development of projects.
Is intended you are using software provided by caneblu.com at your risk.