Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

[contribution] Total B2B


  • You cannot reply to this topic
397 replies to this topic

#41 Maj

  • Community Member
  • 11 posts
  • Real Name:Maj

Posted 08 July 2004, 15:10

hozone, on Jul 8 2004, 08:27 AM, said:

Maj, on Jul 8 2004, 03:42 AM, said:

I think the problem is, at the bottom of the list it is not displaying the page count (page 1 of ?) etc. It will only display the maximum value of "Search Result" set in admin. No option for next page etc. Where can this be fixed?
where did you get this problem?
I get this problem in product listing; I applied Total B2B on a fresh MS2.2 It stopped displaying "Result Pages": Thanks to Wolfram Palmer, replacing group by clause with lower case DID THE TRICK but I do not understand why. I saw his posting in forum but I thought it would not apply in my case: apperently it did; Thanks Wolfram ;)

#42 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 09 July 2004, 10:55

jogoto, on Jul 8 2004, 06:43 AM, said:

@ Maj

see my posting:

Quote

Ok, problem solved:

There are four changes in catalog/index.php

GROUP BY p.products_id

added.

After changing to

group by p.products_id

(just small characters) it works.
next version will have thi s fix.

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

#43 mattwho

  • Community Member
  • 202 posts
  • Real Name:Matt Davis
  • Location:California

Posted 09 July 2004, 13:47

Anyone know how to get the column listings instead of rows?

#44 sandeep919

  • Community Member
  • 10 posts
  • Real Name:sandeep saini

Posted 10 July 2004, 00:58

Okay now I am done installing Total B2b. It looks great to me, but didn't work for me yet.
My first is question if I update the discount price for one of the customer when will the customer will see that price. I mean when he logins the price of each product will change to discount price or when he add the products to the cart. just wondering when customer will see that.

Secondly I did try to give discount by adding a new group called "special price" and put discount in that group as 8%. I also add the customer to that Special price group. Now the customer should see the price, when he logins or when he add the items to the cart, But it doesn't happen.
Can anyone let me know where I am doing wrong.
Do I have to change the option in Mystore i.e"Number of prices ..... .

Please let me know.
thanks
Sandeep

#45 AXM

  • Community Member
  • 138 posts
  • Real Name:Sean
  • Gender:Male

Posted 11 July 2004, 04:16

Hozone,
I'm still using your Customer Group contrib and its working out perfectly with those fixes we hammered out a month or two ago.

About this one, did you notice any significant parse time increases upon installation? When I added CG I didn't notice any delays at all, but when I installed this one somehow on a new install it was showing a 3X increase in parse times...maybe I added it wrong and it was doing some unnecessary loops.

Just curious. I'd love to add it to a future wholesale-only website I'm thinking about partaking in.

P.S. Thanks for these wonderful contribs, keep up the great work.
I ♥ PHP/MYSQL/CSS

#46 ThatRonGuy

  • Community Member
  • 2 posts
  • Real Name:Ron

Posted 14 July 2004, 05:21

After it is installed I get this:
Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /hsphere/local/home/fitnes1/xxx.com/shop/includes/functions/database.php on line 19
Unable to connect to database server!


#47 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 14 July 2004, 08:27

AXM, on Jul 11 2004, 05:16 AM, said:

Hozone,
I'm still using your Customer Group contrib and its working out perfectly with those fixes we hammered out a month or two ago.

About this one, did you notice any significant parse time increases upon installation? When I added CG I didn't notice any delays at all, but when I installed this one somehow on a new install it was showing a 3X increase in parse times...maybe I added it wrong and it was doing some unnecessary loops.

Just curious. I'd love to add it to a future wholesale-only website I'm thinking about partaking in.

P.S. Thanks for these wonderful contribs, keep up the great work.
what do you mean when you said "parse time"?
osCommerce Italia support: http://www.oscommerceitalia.com

#48 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 14 July 2004, 08:30

ThatRonGuy, on Jul 14 2004, 06:21 AM, said:

After it is installed I get this:
Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /hsphere/local/home/fitnes1/xxx.com/shop/includes/functions/database.php on line 19
Unable to connect to database server!
you have to select right username and password for your database!
osCommerce Italia support: http://www.oscommerceitalia.com

#49 ThatRonGuy

  • Community Member
  • 2 posts
  • Real Name:Ron

Posted 14 July 2004, 16:13

it asks for a server location but when the IP is added it gives a different error.

#50 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 14 July 2004, 19:11

ThatRonGuy, on Jul 14 2004, 05:13 PM, said:

it asks for a server location but when the IP is added it gives a different error.
i suppose it is not a totalb2b problem.
maybe you have this problem even with a clean 2.2 ms2 ?
osCommerce Italia support: http://www.oscommerceitalia.com

#51 jonsimons

  • Community Member
  • 8 posts
  • Real Name:Jonathan Simons

Posted 15 July 2004, 13:37

Hi all..

I was just wandering if someone could help me...? :unsure:

I've already installed tons of oscommerce contributions for my store, so unfortunately I couldn't use the files provided.

Instead I had to go through the files one by one and alter changes etc... :D

Anyway, once I made all the changes and uploaded the files, i got this error when i went to my store:

Parse error: parse error, unexpected ';', expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homepages/21/d69142426/htdocs/site/catalog/includes/classes/shopping_cart.php on line 534

I've really got no idea how to solve that? Does anyone?

To check whether it was just the shopping_cart.php file that was wrong, I uploaded the original shopping_cart.php file.

I then got this error:

Parse error: parse error, unexpected ';', expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homepages/21/d69142426/htdocs/site/catalog/includes/classes/currencies.php on line 131

Its wierd cos its pretty much the same error, but now on the currencies.php file? Perhaps ive done something wrong all the way through the installation?


If someone could help then I would be very grateful!
I really want to get this great mod up and running! B)


Thanks,

Jon

#52 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 15 July 2004, 16:22

/homepages/21/d69142426/htdocs/site/catalog/includes/classes/currencies.php on line 131

not it is currencies.php (maybe :))

if you want to know only the canges made by this contib, use diff script to generate differeces between clean oscommerce and a totalb2b patched oscommerce
osCommerce Italia support: http://www.oscommerceitalia.com

#53 daz34

  • Community Member
  • 4 posts
  • Real Name:darren siepka

Posted 16 July 2004, 12:58

installed the packages and Everything appears to be ok but i don't get the "Configuration / My Store/ Number of prices per product" entry!

Any thoughts?

#54 kshop

  • Community Member
  • 29 posts
  • Real Name:A
  • Gender:Male

Posted 17 July 2004, 21:35

Please note my post in General question thread regarding:
customers may get a discount when they do not qualify for it, if you don't specify a product manufacturer (though I think it's an OC problem, not strictly this contribution, but that's my opinion):
http://forums.oscommerce.com/index.php?sho...533;entry408262

Edited by kshop, 17 July 2004, 21:36.


#55 kshop

  • Community Member
  • 29 posts
  • Real Name:A
  • Gender:Male

Posted 17 July 2004, 21:42

from Readme:

Quote

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).
I suggest to not reset the price to default price level, but set the new price to the next lower level. E.g., if we have 4 levels, then reduce to 3, all groups which had level 4 prices should have level 3 prices, but not the level 1 prices. Usually the higher the price level the price is lower in the wholesale world.

#56 daz34

  • Community Member
  • 4 posts
  • Real Name:darren siepka

Posted 19 July 2004, 07:56

sorry maybe i didnt explain properly.

i dont actually get the option in configuration/my store to create multiple levels to begin with......

#57 hozone

  • Community Member
  • 174 posts
  • Real Name:hOZONE
  • Gender:Male
  • Location:Italy

Posted 26 July 2004, 16:13

version 1.2a is OUT

Changelog
. Product prices of the products that have special prices set, can be hidden:
"Configuration / My Store/ Special price (products price hiding)".
. Administrator must activate customers after registrations.
osCommerce Italia support: http://www.oscommerceitalia.com

#58 alex_rus

  • Community Member
  • 39 posts
  • Real Name:Alexander

Posted 27 July 2004, 08:34

Hi
Don't you know if your contrib works with Price-Break contribution?

Alexander

#59 osjunkie

  • Community Member
  • 226 posts
  • Real Name:Brad Thompson
  • Location:Winnipeg, Canada

Posted 28 July 2004, 05:36

Hello, I have managed to get this working on a very heavily moded site. Probably 55 - 60 mods. Took me an hour to integrate all the changes.

Anyways I have come to a roadblock and my newbie programming skills are not to the task of winning this battle.

I have featured products on the front page and the prices are at zero because the file hasn't been moded in the release. I've tried using code from other files but it's just not working. catalog/includes/featured_products.php

If someone could make the prices show you would rule the world for one day. Also the prices work when you aren't logged in by saying "You must be logged in"

Fixing this would be good for the community because many people have featured products on their site.

BEGIN CODE:
---------------------
<?php
/*
$Id: featured_products.php,v 2.5 2003/10/28 21:00:00 cieto Exp $

cieto Featured Products 2.5 MS2 listing module
cieto@msn.com

Made for:
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright © 2002 osCommerce
Released under the GNU General Public License

*/

?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<?php
if (sizeof($featured_products_array) <> '0') {
$col = 0;
for($i=0; $i<sizeof($featured_products_array); $i++) {
if ($featured_products_array[$i]['specials_price']) {
$products_price = '<s>' . $currencies->display_price($featured_products_array[$i]['price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</s>&nbsp;&nbsp;<span class="productSpecialPrice">' . $currencies->display_price($featured_products_array[$i]['specials_price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</span>';
} else {
$products_price = $currencies->display_price($product_info['products_id'], $product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
}
$col++;

?>
<td width="50%" valign="top" align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" rowspan="4" align="right" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $featured_products_array[$i]['image'], $featured_products_array[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td>
<td width="80%" valign="top" class="main"><div align="left"><?php echo '<b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '"><u>' . $featured_products_array[$i]['name'] . '</u></a></b>'; ?>
</div></td>
</tr>
<tr>
<td valign="top" class="main">
<?php
if ($featured_products_array[$i]['shortdescription'] != '') {
echo $featured_products_array[$i]['shortdescription'];
} else {
$bah = explode(" ", $featured_products_array[$i]['description']);
for($desc=0 ; $desc<MAX_FEATURED_WORD_DESCRIPTION ; $desc++)
{
echo "$bah[$desc] ";
}
echo '...';
}
?>
</td>
</tr>
<tr>
<td valign="top" class="main"></td>
</tr>
<tr>
<td align="left" valign="top" class="main"><?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '5') . '<br>' . TABLE_HEADING_PRICE . ': ' . $products_price; ?><br><?php echo '<form method="post" action="/dealers/product_info.php/products_id/' . $featured_products_array[$i]['id'] . '/action/add_product"><input type="hidden" name="products_id" value="' . $featured_products_array[$i]['id'] . '"><input type="submit" value="Buy Now"></form>'; ?>&nbsp;&nbsp;
<?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '">'; ?><?php echo TEXT_MORE_INFO;?></a>&nbsp;</td>
</tr>
</table>
</td>
<?php
if ((($col / FEATURED_PRODUCTS_COLUMNS) == floor($col / FEATURED_PRODUCTS_COLUMNS))) {
?>
</tr>
<tr>
<td colspan="<?php echo FEATURED_PRODUCTS_COLUMNS; ?>" align="right" valign="top" class="main"><hr width="100%" size="1" noshade></td>
</tr>
<tr>
<?php
}
if (($i+1) != sizeof($featured_products_array)) {
?>
<?php
}
}
}
?>
</table>

#60 alanm123

  • Community Member
  • 6 posts
  • Real Name:Alan

Posted 31 July 2004, 06:20

I had a problem following the first instruction in the readme, which says:

Quote

1) run the .sql file in the folder "Sql" of this file to apply SQL changes to your database.

I kept getting an error about not having access rights to do that. I did not see a solution here, but I finally found it. I thought I'd post the answer in case anyone else is looking.

My hosting site is ipowerweb.com. They allow both unix and windows hosting. We opted for windows. The ipowerweb admin tool is called vdeck. It includes an option to automatically install an osCommerce store/database. When it does, it automatically creates a database and user.

Problems:
It doesn't tell you what user was created.
It doesn't tell you what the password is for that user. (I finally found it, buried in the admin/includes/configure.php file.)
It sets the default rights for the user not to allow "alter".

Hope this helps anyone else who might be using ipowerweb.com hosting.