♥Dan Cole Posted September 15, 2016 Share Posted 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 Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
Enzo_UK Posted November 12, 2016 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Enzo_UK Posted November 12, 2016 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Enzo_UK Posted November 13, 2016 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
Mikepo Posted November 27, 2016 Share Posted 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 Quote osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
♥frankl Posted November 28, 2016 Share Posted November 28, 2016 @@Mikepo I'm using this version with PHP 5.6.22 without problem. Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Mikepo Posted November 28, 2016 Share Posted 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 Quote osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
Mikepo Posted November 28, 2016 Share Posted November 28, 2016 @@frankl, ok up and running, MySQL extensions wasn't installed. oops! so, now what is the default password for admin? Quote osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
Mikepo Posted November 28, 2016 Share Posted 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 Quote osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
♥frankl Posted November 28, 2016 Share Posted November 28, 2016 I'd like to rewrite Ollacart some time in the future. It's a bit of a beast :) Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Mikepo Posted November 29, 2016 Share Posted 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 Quote osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
♥frankl Posted November 30, 2016 Share Posted 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 :) Mikepo 1 Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
?jObE? Posted December 11, 2016 Share Posted 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? Quote Link to comment Share on other sites More sharing options...
♥frankl Posted December 20, 2016 Share Posted December 20, 2016 @�jObE� You need to write/get written that part of Ollapos yourself, it is incomplete for now. Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Omar_one Posted March 26, 2017 Share Posted 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 Quote Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
♥frankl Posted March 27, 2017 Share Posted 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? Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Omar_one Posted March 27, 2017 Share Posted March 27, 2017 (edited) @@frankl fixed .. i will share the fixing when I will by beside the pc .. Edited March 27, 2017 by Omar_one Quote Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
Omar_one Posted March 27, 2017 Share Posted March 27, 2017 (edited) @@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 Quote Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
Omar_one Posted March 27, 2017 Share Posted 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 Quote Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
♥frankl Posted March 27, 2017 Share Posted March 27, 2017 @@Omar_one Nice work! Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
LeeFoster Posted April 28, 2017 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
♥frankl Posted April 29, 2017 Share Posted 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. Quote osCommerce user since 2003! Link to comment Share on other sites More sharing options...
♥Dan Cole Posted April 29, 2017 Share Posted 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 Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
LeeFoster Posted April 29, 2017 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
♥Dan Cole Posted April 29, 2017 Share Posted 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 Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.