OllaCart Point of Sale for osCommerce - ocPOS

♥Dan Cole · September 15, 2016

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

Enzo_UK · November 12, 2016

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.

Enzo_UK · November 12, 2016

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.

Enzo_UK · November 13, 2016

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.

Mikepo · November 27, 2016

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

♥frankl · November 28, 2016

@@Mikepo

I'm using this version with PHP 5.6.22 without problem.

Mikepo · November 28, 2016

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

Mikepo · November 28, 2016

@@frankl, ok up and running, MySQL extensions wasn't installed. oops!

so, now what is the default password for admin?

Mikepo · November 28, 2016

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

♥frankl · November 28, 2016

I'd like to rewrite Ollacart some time in the future. It's a bit of a beast :)

Mikepo · November 29, 2016

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

♥frankl · November 30, 2016

@@Mikepo

I think rather than being a standalone program it would be better as a kind of admin addon for osC, using native functions and calling other osC addons as needed. It's on the backburner for now :)

?jObE? · December 11, 2016

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?

♥frankl · December 20, 2016

@�jObE�

You need to write/get written that part of Ollapos yourself, it is incomplete for now.

Omar_one · March 26, 2017

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

♥frankl · March 27, 2017

@@Omar_one

No idea Omar, that's what we've been using for years and never had an issue. Do any php errors get logged?

Omar_one · March 27, 2017

@@frankl fixed .. i will share the fixing when I will by beside the pc ..

Edited March 27, 2017 by Omar_one

Omar_one · March 27, 2017

@@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 March 27, 2017 by Omar_one

Omar_one · March 27, 2017

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

♥frankl · March 27, 2017

@@Omar_one

Nice work!

LeeFoster · April 28, 2017

I just installed this and am getting the below error, any ideas what I'm missing?

php_network_getaddresses: getaddrinfo failed: No such host is known.

♥frankl · April 29, 2017

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

♥Dan Cole · April 29, 2017

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

LeeFoster · April 29, 2017

Jared suggested this a couple of posts later on.

Dan

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.

♥Dan Cole · April 29, 2017

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

OllaCart Point of Sale for osCommerce - ocPOS

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Guest

BrockleyJohn

mooseracing

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation