Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Very weird dilema


mcritz

Recommended Posts

im taking over a current oscommerce site and i am finding products to have different prices on the website when you are logged in compared to when your not.

 

 

for instance. logged out the price will be 1200 dollars, but logged in it will show as 400.

 

the question is where can i edit this at? and to determine the markup?

Link to comment
Share on other sites

John,

 

 

I would check to see if SPPC (separate price per customer) or Group Pricing is installed. Those to contribution that COULD alter the displayed price depending on which group customers are placed in.

 

 

 

 

 

Chris

Link to comment
Share on other sites

i do not see either of these, i have personally looked through every panel in the admin as well as searched majority of all the files for the field or the number "300" since thats what the markup is.

 

this isnt a built in feature with ossc is it? and if those contributions arent there how could i track it down?

 

like what could i search for that would alter the product price depending on if you are logged in?

 

thank you.

Link to comment
Share on other sites

John,

 

 

The best way to check for Customer Groups or SPPC is to look in admin>>customers area. Edit one of the customers and check to see if that customer form has an extra field called Group.

 

 

 

 

 

Chris

Link to comment
Share on other sites

there are no extra boxes in the customer section. i have looked through everything within the control panel and don't see anything resembling a reason to a different logged in price.

 

this is actually something the site owner wants, however i need to figure out where its pulling the value of 300 percent.

Link to comment
Share on other sites

John,

 

 

More than likely, the code is very custom and MAY not have an admin configuration area for the price change. For a complete change, several files would have to be edited including product_info.php, specials.php, new_products.php, checkout_payment.php, checkout_process,php, checkout_shipping.php and others.

 

 

 

Chris

Link to comment
Share on other sites

[...] i need to figure out where its pulling the value of 300 percent.

 

Did you check the taxes? It looks like a tax rate is getting applied after login, maybe just for the particular zone your address as a customer belongs too. Check the tax rates

Link to comment
Share on other sites

Did you check the taxes? It looks like a tax rate is getting applied after login, maybe just for the particular zone your address as a customer belongs too. Check the tax rates

 

i thought that as well, but it doesn't have any tax rates set except europe at 17.5%.

 

if it was taxes would that explain why "logged in" users see the lower price? this all takes place as your viewing the catalog.

Link to comment
Share on other sites

John,

 

No, the tax rates have nothing to do with the price display after log in.

 

Unfortunately, I believe you are going to have to check the code to determine how the price is displayed.

 

 

 

 

 

Chris

Link to comment
Share on other sites

there is a file named hideprice.php that includes

 

<?php
if (tep_session_is_registered('customer_id')){
?>
<p class="details-price">Price: <b>$regularpricestrike</b></p><br />
<?php 
}else{
echo '<p class="details-price">Price: <i>Only logged users</i></p><br />';
}
?>

Link to comment
Share on other sites

as well in product_info.phphtml, (this is an sts template)

 

	<div class="product-details">
		    	            <p class="details-name">$productname</p><br />
		  	                <p class="details-price">Price: <b>$regularpricestrike</b></p><br />
		                </div>

Link to comment
Share on other sites

ok, so lets check

1) Are all prices getting divided by 3 when logged in (eg item1: not logged 1200, logged 300, item 2 not logged 900 logged 300) or is it like when not logged all prices are 1200 and when logged various prices?

2) Check the DB, table products, to see what price is there (1 price, more prices ?)

3) Check DB if you have a table called "products_price_break"

4) Does the price issue appear on all pages or just index or just product_info

5) Disable sts and then check prices again. If problem persist post the query named "$product_info_query"of file product_info.php here. If not then say so

6) add an item to the cart, how is the price?

 

Just some thoughts

 

I don't know, what to do depends always from what was the result of the previous checking, in any case, it makes no sense to search for "300" in any files

Link to comment
Share on other sites

ok, so lets check

1) Are all prices getting divided by 3 when logged in (eg item1: not logged 1200, logged 300, item 2 not logged 900 logged 300) or is it like when not logged all prices are 1200 and when logged various prices?

2) Check the DB, table products, to see what price is there (1 price, more prices ?)

3) Check DB if you have a table called "products_price_break"

4) Does the price issue appear on all pages or just index or just product_info

5) Disable sts and then check prices again. If problem persist post the query named "$product_info_query"of file product_info.php here. If not then say so

6) add an item to the cart, how is the price?

 

Just some thoughts

 

I don't know, what to do depends always from what was the result of the previous checking, in any case, it makes no sense to search for "300" in any files

 

 

1. Prices in DB and OSC Control Panel are high. ie. Price for item x is 2874.42 in database/osc control panel, when not logged in the item shows at 8623.26, they are all 3 times more not logged in.

2. can not find more than one price listened within the database or osc control pael

3. i see no tables in the database with that name.

4. its across the board, all pages, all searches, index etc. (If your logged ou you see a price 3* more then when you are)

5. when all sts is disabled it does the same thing.

6. when entering a new item at 100 it shows 100 when logged in, and 300 when logged out.

 

i thank you for the help thus far and if you or anyone have any more ideas please let me know.

Link to comment
Share on other sites

And how is the query in product_info.php?

 

I don't know, guessing like this without seeing anything ....

 

Maybe it's something obvious you are just overlooking and we are hunting here for ghosts ....

Link to comment
Share on other sites

product_info.php

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<?php include('includings/header_productinfo.php'); ?>

<div id="wrapper">

   <?php include('includings/top.php'); ?>

   <div id="main">
	<?php include('includings/leftcol.php'); ?>
       <div class="mainRight">

           <div class="mainBucket">
			<?php include('includings/topboxes.php'); ?>
           </div>
           <br clear="all" />

           <div class="mainContent">

                   <div id="mainimageHolder" class="mainimageHolder">
                       $content
                   </div>
				<!-- BOF Product Description -->
                   <div id="productDesc">						
					<!-- BOF CONTAINER -->
                       <div class="container">
						$startform
						<div class="product-details">
		    	            <p class="details-name">$productname</p><br />
		  	                <p class="details-price">Price: <b>$regularpricestrike</b></p><br />
		                </div>
					    <ul class="tabs">
					        <li><a href="#tab1">Product info</a></li>
					        <!--<li><a href="#tab2">Returns Policy</a></li>-->


					    </ul>
					    <div class="tab_container">
					        <div id="tab1" class="tab_content">
					            <p>$productdesc</p>
					        </div>
					        <div id="tab2" class="tab_content">
					            	$returns	
								</div>


					   	</div>
					</div>
					<!-- EOF CONTAINER -->

					<br clear="all"/><br />
                          		$options 


                       <p>$stock</p>
					<div style="visibility: hidden;height:3px;">$qty</div>

					<!--Buttons-->
                       <div id="addtocart">
                           <div id="wishlistBuy">
                              <!-- WISHLIST-->
							$wishlist
							<!-- WISHLIST-->
                           </div>
						<br clear="all" /><br/>
						<div id="wishlistBuy">
                               $qty
                           </div>
						<br clear="all" /><br/>
                           <div id="productBuy">
                             <A HREF="javascript:history.go(-1)">
							<IMG SRC="includes/languages/english/images/buttons/button_back.gif" BORDER="0">
						  </A>
						   $addtocartbutton
                           </div>
						<br clear="all" /><br/>
                       </div>
                       <!--Buttons-->
					<br clear="all" /><br/>
					$endform
					<br clear="all" /><br/>
                   </div>
				<!-- EOF Product Description -->
                   <br clear="all" /><br/>

       	</div>
           <br clear="all" />
       </div>

   </div>

   <?php include('includings/footer.php'); ?>

</div>

</body>

</html>

Link to comment
Share on other sites

searching for 300 in the database it returned.

 

 

SELECT *

FROM `sbtdb`.`products_to_categories`

WHERE (

CONVERT( `products_id`

USING utf8 ) LIKE '%300%'

OR CONVERT( `categories_id`

USING utf8 ) LIKE '%300%'

)

 

would that set the 300 percent?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...