Jump to content
jcall

OllaCart Point of Sale for osCommerce - ocPOS

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.




			
		

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

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!)

Share this post


Link to post
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!)

Share this post


Link to post
Share on other sites

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

so, now what is the default password for admin?


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

Share this post


Link to post
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!)

Share this post


Link to post
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!)

Share this post


Link to post
Share on other sites

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


Let's make things easier for new osCommerce users http://forums.oscommerce.com/topic/402638-discussion-about-hard-coded-database-tables/?p=1718900  Getting there with osCommerce 2.4! :thumbsup:

Share this post


Link to post
Share on other sites

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?

 

 

Share this post


Link to post
Share on other sites

@�jObE�

 

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


Let's make things easier for new osCommerce users http://forums.oscommerce.com/topic/402638-discussion-about-hard-coded-database-tables/?p=1718900  Getting there with osCommerce 2.4! :thumbsup:

Share this post


Link to post
Share on other sites

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 .

Share this post


Link to post
Share on other sites

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


Let's make things easier for new osCommerce users http://forums.oscommerce.com/topic/402638-discussion-about-hard-coded-database-tables/?p=1718900  Getting there with osCommerce 2.4! :thumbsup:

Share this post


Link to post
Share on other sites

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

Edited by Omar_one

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

Share this post


Link to post
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 .

Share this post


Link to post
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 .

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@@LeeFoster

 

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

 

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


Let's make things easier for new osCommerce users http://forums.oscommerce.com/topic/402638-discussion-about-hard-coded-database-tables/?p=1718900  Getting there with osCommerce 2.4! :thumbsup:

Share this post


Link to post
Share on other sites

@@LeeFoster

 

http://forums.oscommerce.com/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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×