Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OllaCart Point of Sale for osCommerce - ocPOS


Guest

Recommended Posts

Did you transfer the data from an old osC version, and that includes the password(s)? I seem to recall seeing something about password hashing methods being changed somewhere along the line, so a password hash stored from an old version would not work with the same password entered into a newer store. You might search around for discussion on that.

 

@@MrPhil  ...as I understand it passwords are upwards compatible but not downwards....I believe what happens is that the newer versions of osC can read in the old passwords but once read in they are then hashed again using a different method and restored.  The older site will not be able to use it again.  At least that is the way it seems to work.

 

Dan

Link to comment
Share on other sites

  • 1 month later...

I have been trying to get ollacart working, but still having no luck with the Tax even though I have made the changes.

 

I think the problem is that my site doesn't use 'Zones' so when it tries to do that table join to look up the rates it doesn't return anything.

 

All my products have a 'products_tax_class_id' of either 1 or 2, 1 for goods with no Tax, 2 for goods with Tax.

 

And my tax rates are set up both with a 'tax_zone_id' of 1

 

How can I tweak the tax functions in Ollacart so it doesn't need to do the 'store_zone' look up bit from the configuration table, but somehow ends up at the right tax_zone_id to suit my tax classes.

Link to comment
Share on other sites

If I manually set my store country in functions the Tax works fine for me now..

 

I changed:

$country_id = $country_id_result['zone_country_id'];

to:

$country_id = "222";

So looks like because I don't use zones it wasn't able to work it out the store country.




			
		
Link to comment
Share on other sites

I am having one other odd problem, dont know if there is a simple fix for this one...

 

If I start a 'New Order' and dont select a customer, and put an POS order through it shows up fine is osc admin, linked to the 'In Store Customer' account which was set up by Ollacart.

 

If I create a new customer, that customers details shows up fine in osc admin, but the order comes through showing blank customer details.

 

If I look in the db the order has the right customer id attached to it, but all the other details are blank.

 

Same thing happens if I select an existing customer, their details fill all the boxes in Ollacart, but when the order come through the only thing that shows up in the db is the customer_id.

 

I haven't changed the names of any of the tables or fields, the table is still called 'orders' and fields are 'customers_name' 'customers_street_address' same as a standard install, and that bit must work fine as Ollacart manages to send orders through okay when its on the 'In Store Customer' account.

 

Hopefully someone has an idea, as want to start using it properly this week.  Thanks in advance for any help.

Link to comment
Share on other sites

  • 2 weeks later...

Hi, does anyone have this addon, point of sale, up and running using php 5.6, as it seems that all MySQL statements are deprecated and not available in 5.6.11.

 

thanks

osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!)

Link to comment
Share on other sites

@@frankl,

I'm using XAMPP, as a test server, and the mysql statements are coming up deprecated, and the code stops, perhaps there is setting for override this, and so continues with using the depricated functions, I'll have to check.

 

Mike

osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!)

Link to comment
Share on other sites

@@frankl,

Ok found the password, but it appeared to not work, until I realised that you can only enter into the functionality of the code until you rename/delete install.php

So up and running now, thanks

osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!)

Link to comment
Share on other sites

it seems to work well, and covers most things for every day pos.  One thing that could be added is the reporting of cost of sales.  I use margin report addon for this, but something could be added to make it complete in one app.

Thanks

osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!)

Link to comment
Share on other sites

  • 2 weeks later...

Good day,

 

I am looking at setting up a website nad using ollacart for the store front but I have a problem with a basic install

 

OSC 2.3.4 with default products.

OCPOS2.5 with OSC attrib enabled.

 

When you select an Atrribute ( such as the matrox memory upgrade ) it is not adding to the price.

 

price is $299.99 when adding the memory which add $70 to the price its just adds a space ( shows $ 299.99 )

 

Anyone have any ideas?

 

 

Link to comment
Share on other sites

  • 2 weeks later...
  • 3 months later...

Hello @@frankl  I  installed the  Responsive version https://github.com/f...OS25-Responsive..

I have issue with it .. That after create orders via OllaCart  they are not shown on the admin side .. just the Return / Exchange ones ..

Do you know why?

 Thank you in advance

Omar

Get the latest Responsive osCommerce CE (community edition) here .

Link to comment
Share on other sites

@@frankl

when OllaCart installed  it will create  two orders status in the database for just one language (English),

So I insert same orders status id with the 2nd  language_id(my language)  with different orders_status_name to fit my language.

here is any example

shop have two language lets say English (language_id = 1) and finnish (language_id =2) and when you install the OllaCart it will insert 

INSERT INTO `orders_status` (`orders_status_id`, `language_id`, `orders_status_name`, `public_flag`, `downloads_flag`) VALUES
(12, 1, 'Completed In Store', 1, 0),
(13, 1, 'Voided In Store', 1, 0);

So we have to insert the 2nd  language manually  with same orders_status_id

INSERT INTO `orders_status` (`orders_status_id`, `language_id`, `orders_status_name`, `public_flag`, `downloads_flag`) VALUES
(12, 2, 'valmistunut Myymälässä', 1, 0),
(13, 2, 'Mitätöity Myymälässä', 1, 0);

after that the created orders via OllaCart  they will show on the admin side(orders)

 

English is not my mother tongue; please excuse any errors on my part.

 

Omar

Edited by Omar_one

Get the latest Responsive osCommerce CE (community edition) here .

Link to comment
Share on other sites

@@frankl  I made some editing and now it will show products image on the products list  when you search for product.

 

product.php

<?php
// product.php


include("includes/db.php");
include("includes/functions.php");
include("includes/session.php");

LoadLangFiles($lang);

// check if valid login session, else require login
$session->logged_in = $session->checkLogin();

if(!$session->logged_in) {
    header('Location: login.php');
}


$Q_Product = mysql_query("SELECT p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, " .
		"pd.products_name, pd.products_description, s.specials_new_products_price, s.expires_date, s.status, " .
		"if ((s.specials_new_products_price is not NULL), s.specials_new_products_price, p.products_price) as sales_price " .
		"FROM " . PRODUCTS . " p left join ". SPECIALS ." s on (p.products_id=s.products_id), " . PRODUCTS_DESCRIPTION . " pd " .
		"WHERE (p.products_id = '" . $_REQUEST['ProductID'] . "' AND " .
		"pd.products_id = p.products_id ) " .
        "AND pd.language_id = $language_id " .
		"LIMIT 1");

if(mysql_num_rows($Q_Product)){
	$R_Product = mysql_fetch_assoc($Q_Product);
}else{
	header("Location: index.php?error=no_product_found");
}

// -- Load all options
// -- Load available options for this product
if (use_attribs()) {
  $R_product_attribs = new attributes($_REQUEST['ProductID'],$language_id);
}

//get the total number of product options, so we know how many possible options can be on a product page
$option_count_query = mysql_query("SELECT count(*) as total from " . PRODUCTS_OPTIONS);
$option_count_results = mysql_fetch_assoc($option_count_query);

$option_count = $option_count_results['total'];

?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <link rel="icon" href="favicon.ico">

    <title><?php echo($POSName) . ': ' . TITLE; ?></title>

    <!-- Bootstrap core CSS -->
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
	<link href="user.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="jumbotron-narrow.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
<?php

// -- Load product page javascript
if (use_attribs()) {
  $R_product_attribs->product_page_js();
}

?>       
</head>
<!-- javascript function to recalculate price and quantity on page load -->
<body>
  <div class="container">
    <?php include("includes/header.php"); ?>
      <div class="row marketing">


  
 
 <div class="alert alert-info text-center">
  <h3><?php echo PRODUCT_INFO; ?><?php echo($R_Product['products_name']); ?></h3>
 </div>
 <table class="table table-condensed table-striped table-hover">
 <tr>
 <td width="20%" class="tdBlue"><b><?php echo PRODUCT_MODEL; ?></b></td>
 <td width="80%"><?php echo($R_Product['products_model']); ?></td>
 </tr>
 <tr>
 <td width="20%"><b><?PHP echo PRICE; ?></b></td>
 <td width="80%" id="product_price_display">
  <?php  
  // Store base product price for automated adjustments 
  // ----------------------------
  $product_final_price = $R_Product['products_price'];  
  	if (($R_Product['specials_new_products_price'] != NULL) && ($R_Product['status'] == '1') && ($R_Product['expires_date'] >= date("Y-m-d") || (substr($R_Product['expires_date'],0,10) == '0000-00-00') || (is_null($R_Product['expires_date']) ) ) ) {
		if (IN_STORE_PRICING == 1) {
		$R_Product['specials_new_products_price'] += ($R_Product['specials_new_products_price'] * IN_STORE_SURCHARGE);
			}
	  	echo $default_currency_symbol . "<s>".(number_format($R_Product['products_price'], 2, '.', ''))."</s> <span class='productSpecialPrice'>".(number_format($R_Product['specials_new_products_price'], 2, '.', ''))."</span>"; 
  $product_final_price =  $R_Product['specials_new_products_price'];  
		} else {
			if (IN_STORE_PRICING == 1) {
				$R_Product['products_price'] += ($R_Product['products_price'] * IN_STORE_SURCHARGE);
			}
	  	echo $default_currency_symbol . (number_format($R_Product['products_price'], 2, '.', '')); 
	  }
  ?>
 </td>
 </tr>
 <tr>
 <td width="20%"><b><?php echo QTY_IN_STOCK; ?></b></td>
 <td width="80%" id="product_quantity_display">
 <?php
 echo($R_Product['products_quantity']);
 if($R_Product['products_quantity'] == 0 && ALLOW_SOLDOUT_PRODUCTS == 0){
 	//echo(" ( $R_Product['products_reorder_quantity'] reordered )");
 	echo('   <font color="red">' . OUT_OF_STOCK . '</font>');
 }
 ?></td>
 </tr>
 <tr>
 <td width="20%"><b><?php echo PRODUCT_WEIGHT; ?></b></td>
 <td width="80%"><?php echo($R_Product['products_weight']); ?> lbs.</td>
 </tr>
<?php
  //  Display attributes form elements
	if (use_attribs() && (count($R_product_attribs->options)>0)) {
?> <tr>
 <td width="100%" colspan="2" align="center">
  <b><?php echo PRODUCT_OPTIONS; ?></b>
 </td>
 </tr>
 <tr>
 <td width="100%" colspan="2">
<?php
    echo $R_product_attribs->product_form($product_final_price);
?>
 </td>
 </tr>
<?php	  
	} 
?>
 <tr height="45px">
 <td width="100%" colspan="2" align="center">
  
  <?php if($_SESSION['CurrentOrderIndex'] == -1) { ?>
      <a href="#" title="<?php echo ADD_TO_ORDER_BUTTON_TITLE; ?>" onclick="this.blur();" class="btn btn-success btn-default disabled" role="button"><?php echo ADD_TO_ORDER; ?></a>
      
  <?php } elseif (use_attribs() && (count($R_product_attribs->options)>0)) {
  //  Use form submit feature, with additional hidden fields, when adding product.
  //    This forces the POSTing of any option values.
  //  Use the old-format page redirection if attributes not used or not present
    ?>    
	<a href="#" title="<?php echo ADD_TO_ORDER_BUTTON_TITLE; ?>" onclick="check_attrform(document.product_options_form,<?php echo $option_count; ?>,'<?php echo MAKE_SELECTION; ?>')" class="btn btn-success btn-default" role="button"><?php echo ADD_TO_ORDER; ?></a>
    <?php 
    } else {
    ?>   
	  
	  <a href="#" title="<?php echo ADD_TO_ORDER_BUTTON_TITLE; ?>" onclick="this.blur(); window.location.href='action.php?Action=AddItem&ProductID=<?php echo($R_Product['products_id']); ?><?php  
            if ($_SESSION['Orders'][$_SESSION['CurrentOrderIndex']]->ReturnOrder == 1) {
                  echo ("&Quantity=-1");
               } else {
                  echo ("&Quantity=1");
               }
      ?>'" class="btn btn-success btn-default" role="button"><?php echo ADD_TO_ORDER; ?><input type="hidden" name="CreateAssign" value="<?php echo ADD_TO_ORDER; ?>"></a>
<?php 
    }
    
    if (use_attribs() && (count($R_product_attribs->options)>0)) {
?>
  		<input type=hidden name=Action value='AddItem'>
  		<input type=hidden name=ProductID value=<?php echo $R_Product['products_id'] ?> >
      <?php  
            if ($_SESSION['Orders'][$_SESSION['CurrentOrderIndex']]->ReturnOrder == 1) {
                  $qty = -1;
               } else {
                  $qty = 1;
               }
      ?>
  		<input type=hidden name=Quantity value=<?php echo $qty;?> >
  		<input type=hidden name=Price value=<?php echo $product_final_price ?> >
  		<?php if (is_attrib_mode("QTP")) { ?>
  		<input type=hidden name=StockQuantity value=<?php echo $R_Product['products_quantity'] ?> >
  <?php } ?>
   	</form> 
  <?php 
  } 
  ?>
  
  <?php if (IN_STORE_PRICING == 0) { // Disallow price editing if in-store pricing is in effect.  It is too easy to confuse this and enter incorrect prices
  ?>     
	 <a href="#" title="<?php echo EDIT_PRODUCT_BUTTON_TITLE; ?>" onclick="this.blur(); window.location.href='product_edit.php?ProductID=<?php echo($R_Product['products_id']); ?>'" class="btn btn-primary btn-default" role="button"><?php echo EDIT_PRODUCT; ?></a>

     <a href="#" title="<?php echo EDIT_SPECIAL_PRICE_BUTTON_TITLE; ?>" onclick="this.blur(); window.location.href='product_edit_sale.php?ProductID=<?php echo($R_Product['products_id']); ?>'" class="btn btn-default" role="button"><?php echo EDIT_SPECIAL_PRICE; ?></a>
     
  <?php } ?>
  <a href="#" title="<?php echo BACK_BUTTON_TITLE; ?>" onclick="this.blur(); window.location.href='index.php';" class="btn btn-danger btn-default" role="button"><?php echo BACK; ?></a>
  <br>
 </td>
 </tr>
<?php if(SHOW_PRODUCT_DESCRIPTION) { ?>
 <tr>
 <td width="100%" colspan="2" align="center">
  <b><?php echo PRODUCT_DESCRIPTION; ?></b>
 </td>
 </tr>
 <tr>
 <td width="100%" colspan="2">
  <?php echo($R_Product['products_description']); ?>
 </td>
 </tr>
<?php } ?>

<?php if(SHOW_PRODUCT_IMAGE) { ?>
 <tr>
 <td width="100%" colspan="2" align="center">
  <b><?php echo PRODUCT_IMAGE; ?></b>
 </td>
 </tr>
 <tr>
 <td width="100%" colspan="2" align="center">
  <img src="<?php echo IMAGE_PATH; ?><?php echo($R_Product['products_image']); ?>">
 </td>
 </tr>
<?php } ?>
 

 </table>



      </div>

      <footer class="footer">
        <?php include("includes/footer.php"); ?>
      </footer>

    </div> <!-- /container -->
</body>
</html>

Omar

Get the latest Responsive osCommerce CE (community edition) here .

Link to comment
Share on other sites

  • 1 month later...

@@LeeFoster

 

http://www.oscommerce.com/forums/topic/407813-ollacart-point-of-sale-for-oscommerce-ocpos/?p=1737190

 

This error came up before for someone. Not sure how they resolved it.

 

Jared suggested this a couple of posts later on.

 

Dan

Link to comment
Share on other sites

I saw and tried Jared's suggestion but it is not a fix it is just a way to test if the issue is with Ollacart or something else I believe.

 

I know....so is it related to Ollacart or something else?....I assume it is something else or everyone would be seeing that issue.

 

Dan

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...