Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[contribution] XPricesPerProduct


hozone

Recommended Posts

About (ENG)

The products don't have only 1 price, but it is possible to set multiple rices

for products.

The administrator can create groups of users. Every users' group is associated to one product price.

Every user has its own group associated.

The number of product prices can be set from: "Configuration / My Store/ Number of prices per product".

Note: trying to reduce this value causes the automatic set of default price

(price 1) of all those groups for which the reduction has caused an inconsistency with the prices. For ex.: if a group has price 3 and "Number of prices per product" is set to 2, this group will have as a new price the default price (price 1).

Pricing policies:

_product price =

__IF the customer is in a group with price X

___IF price X for selected product exist

____= product price X

___ELSE

____= product price 1 (default price)

__ELSE

___= product price 1 (default price)

 

 

ChangeLog

v1.0 - by hOZONE

. first version

. thanks to Roberto Farnese for helping me writing Readme files in english.

osCommerce Italia support: http://www.oscommerceitalia.com

Link to comment
Share on other sites

  • 2 weeks later...

Has anyone got the XPricesPerProduct working I installed it on a fresh load of ocCommerce to test it out and I get this error when I load the main shop page.

 

 

1146 - Table 'uwdtest_osc.TABLE_CUSTOMERS_GROUPS' doesn't exist

 

select g.customers_groups_price from TABLE_CUSTOMERS_GROUPS g inner join customers c on g.customers_groups_id = c.customers_groups_id and c.customers_id = ''

 

 

 

Yet the admin works fine for adding a second price and a group as well. I am not an expert but I have trailed it back to the general.php file that was added with the XPricesPerProduct any help would be great.

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

Really like the module, I've been using it to put in a retail, franchise and wholesale price.

 

Has anyone developed an addition to the products_attributes module to enable attributes to be added for not just one price but multiple prices?

 

for example:

 

Pricing:

Wooden-Giraffe 10.00$ retail 2.00$ wholesale

 

attributes:

Wooden-Giraffe Size 20cm 0.00$ +

Wooden-Giraffe Size 40cm 2.00$ +

 

Now anyone who buys the wooden giraffe from the store will be able to purchase the 40cm model at 12.00$ which is correct. But if you belong to the wholesale group, the price for the 40cm Giraffe would now be 4.00$ which is incorrect. I would want the ability to add attributes like:

 

attributes:

Wooden-Giraffe Size 20cm 0.00$ + retail & wholesale

Wooden-Giraffe Size 40cm 2.00$ + retail

Wooden-Giraffe Size 40cm 0.18$ + wholesale

 

Does anyone know of a feature enhancement to do this?

 

-will

Link to comment
Share on other sites

  • 3 weeks later...

Hi hozone :

 

I installed XPricesPerProduct, but it doesn't work, I found it says "

 

Changed Files

---------------------------------

catalog/admin/categories.php

catalog/admin/customers.php

catalog/admin/includes/boxes/customers.php

catalog/admin/includes/database_tables.php

catalog/admin/includes/functions/general.php

catalog/includes/boxes/specials.php

catalog/includes/boxes/whats_new.php

catalog/includes/classes/shopping_cart.php

catalog/includes/database_tables.php

catalog/includes/functions/general.php

catalog/includes/modules/product_listing.php

catalog/product_info.php

catalog/product_reviews.php

catalog/product_reviews_info.php

catalog/product_reviews_write.php

catalog/products_new.php

catalog/shopping_cart.php

catalog/specials.php

 

in readme, but catalog/shopping_cart.php is missed in the folder "MS2 patched files/catalog"

 

just wonder if it is the problem?

 

thanks

 

Bill S.

Link to comment
Share on other sites

Thanks for the anwser,

 

But I install a new oscommerce-2.2ms2, and install xpricesperproduct, the problem is the same, in admin, everything is cool, but in storefront, after login, the wholesale price doesn't show up, and can not check out, it shows the page not found error,

 

any idea, what is wrong?

 

thanks again.

 

Bill S.

Link to comment
Share on other sites

I figured it out, the problem is that the domain name of my SSL server is different, so the sessionID seems not match well, after I reset HTTPS_COOKIE_DOMAIN in configure.php, then everything works cool,

but still wondering why it works well before I install xprice,

 

thank you Hozone, great contribution.

 

Bill S.

Link to comment
Share on other sites

Really like the module, I've been using it to put in a retail, franchise and wholesale price.

 

Has anyone developed an addition to the products_attributes module to enable attributes to be added for not just one price but multiple prices?

 

for example:

 

Pricing:

Wooden-Giraffe  10.00$ retail    2.00$ wholesale

 

attributes:

Wooden-Giraffe Size 20cm 0.00$ +

Wooden-Giraffe Size 40cm 2.00$ +

 

Now anyone who buys the wooden giraffe from the store will be able to purchase the 40cm model at 12.00$ which is correct.  But if you belong to the wholesale group, the price for the 40cm Giraffe would now be 4.00$ which is incorrect.  I would want the ability to add attributes like:

 

attributes:

Wooden-Giraffe Size 20cm 0.00$ + retail & wholesale

Wooden-Giraffe Size 40cm 2.00$ + retail

Wooden-Giraffe Size 40cm 0.18$ + wholesale

 

Does anyone know of a feature enhancement to do this? 

 

-will

http://www.oscommerce.com/community/contributions,1936

 

I've posted this patch which somewhat solves the problem I've quoted.

-will

Link to comment
Share on other sites

  • 1 month later...

When I install this contrib, creating a new group gives me a drop down with only product price 1 as selectable, no other options are avialable.

 

Ignore me I'm an idiot. The config is in the main Configuration section. "Number of product prices"

 

Pais.

Edited by mocara
Link to comment
Share on other sites

  • 3 weeks later...

I don't understand where to create these "groups of users" that he documentation mentions, can anyone give me a menu reference, or is this a system function ?

Link to comment
Share on other sites

  • 3 weeks later...

When I try to create a new Group under Customers | Groups I get a message

 

"Access Denied No Write Permission Access" and tells me to please contact the web administrator.

 

The problem is that I am logged in as the Admin? Is there somthing I missed?

 

Thanks

Link to comment
Share on other sites

When I try to create a new Group under Customers | Groups I get a message

 

"Access Denied No Write Permission Access" and tells me to please contact the web administrator.

 

The problem is that I am logged in as the Admin? Is there somthing I missed?

 

Thanks

Sounds like M$ Share Permissions

 

Matti

Link to comment
Share on other sites

Hello every one,

 

I've installed the contribution to, but:

 

If I create 2 differend customers, one of them can checkout and the other can't: the payment and shippings are not available.

 

Now someone what and how it works!

 

They are 2 differend customers whitin 2 differend groups

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
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
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...