Jump to content
Latest News: (loading..)
jcall

OllaCart Point of Sale for osCommerce - ocPOS

Recommended Posts

@@jcall

 

 
I Have a question ...

I enabled QTP is all working well ... but ...

If I Have such Product name: Shoe ($ 10) with Attribute: Red (+ $ 2) and yellow (+ $ 5) and add the product first:

Shoe + Red ($ 10 + $ 2) = $ 12

If you then add:

Shoe + Yellow ($ 10 + $ 5) I do not Have new product with new price ($ 15) but the system   add 1 unit on Previous product.

Be installation error? or The system does not take into consideration the equal products but with different attributes ???
 
excellent Contributions
Thanks for sharing and for the possible answer.
Edited by rainton

Share this post


Link to post
Share on other sites

That appears to be a bug in 2.5. I do not believe that 2.1 has that bug. I just haven't had the time to squash it in 2.5 yet.

 

I had thought that issue only appeared in OSC mode (as documented in README.txt). Apparently not. <sigh>

Edited by jcall

Share this post


Link to post
Share on other sites

@@jcall

 

Yes, I confirm the bug ... is for all conditions attribute.

I'll try to fix it ... if successful post the solution.

I think that in AddItem function, missing all part of recognizing whether the product with the same code and id have different attributes.

If you have suggestions please tell me

I hope to solve
I will update

Share this post


Link to post
Share on other sites

@@jcall

 

half-tested solution

In: includes / functions.php

Search:

                $this->Items[$ this->NextItemIndex]['ProductID'] = $R_Product['products_id'];

Replace with:

                //$this->Items[$this->NextItemIndex]['ProductID'] = $R_Product['products_id'];
                if ($attribute_str){
                $this->Items[$this->NextItemIndex]['ProductID'] = $R_Product['products_id'].'_'. $attribute_str; // rainton
                } else {
                $this->Items[$this->NextItemIndex]['ProductID'] = $R_Product['products_id'];
                }

(Have add $attribute_str for have different id for different attrib)

but this solution has several questions to answer:

1) Changing Product ID, you have to check area Returns
2) Even if the product does not have attributes equal amount but add new product (although seeing many receipts you all have separate products)
3) It should be tested for airport stock

I still check is try to give answers.

Edited by rainton

Share this post


Link to post
Share on other sites

...continue...

 

In: includes/attributes.php

 

Search:

      $Q_stock = mysql_query("SELECT * from ".PRODUCTS_STOCK." where products_id=".$this->products_id );

 

Add before:

      $explodeID = explode("_",$this->products_id); //rainton
      $this->products_id = $explodeID[0];

Otherwise the system does not update quantity in products_stock

Share this post


Link to post
Share on other sites

Try setting OSC_ATTRIBUTES_MODE to NONE.

 

-jared

that is what it's set to standard...

 

and since it complains about QT Pro i set it to OSC also


Quo plus habent, eo plus cupiunt

Share this post


Link to post
Share on other sites

can anyone tell me how i can add a parameter to the Orders In-Progress list

 

What I mean is the Orders In-Progress stores the customer date time firstname lastname and total I would also like to store another field from the customers table along with the above so when selected from the list this variable is included.

 

(I am in the progress of getting SPPC with QTY price breaks working) and have it mostly working (in a hacked way)

 

thanks in advance

Share this post


Link to post
Share on other sites

Dear Community,

 

Has anyone got any experience with Ollacart ??

 

I've installed it on to our oSC platform but it doesn't include VAT on any of the products or on the invoice ??

 

All the best.

 

 

Kind Regards,

 

Harvey

Share this post


Link to post
Share on other sites

Dear Community,

 

Has anyone got any experience with Ollacart ??

 

I've installed it on to our oSC platform but it doesn't include VAT on any of the products or on the invoice ??

 

All the best.

 

 

Kind Regards,

 

Harvey

Share this post


Link to post
Share on other sites

Harvey,

 

This is a feature not (yet?) included in ocPOS. I realize that it's a pain, but I just never got time to update the pricing functions to have an option to include VAT in pricing versus list VAT separately.

 

-jared

Share this post


Link to post
Share on other sites

Same problem here. This module would be perfect, however if there is no way to include VAT in the price then I will need to find another solution. I would be happy to pay if someone can fix this.

Share this post


Link to post
Share on other sites

I already have ollacart installed and have been using it for a few years, does anyone know where I can remove the need for the server key instead of installing it afresh. I want to keep it it as I have it. I cant see in the download where the changes need to be. any help would be fab but I need to do it before 21 Nov as that when the server is offline (I missed the email) Thanks Emma

Share this post


Link to post
Share on other sites

Emma, I just emailed you on this. Please let me know via email if you need any further assistance, and I'll be happy to help.

 

-jared

Share this post


Link to post
Share on other sites

Hello everybody,

 

I am using the OllaCart Point of Sale system on one of my websites, and I am trying to set up PayPal PRO with it. 

 

I am wondering if anybody has done this before, and might be able to show/send the code that you have used to make this work? 

 

Thanks in advance,

Justin

Share this post


Link to post
Share on other sites

I was pointed this way for support, I am trying to get this setup on Zencart to use which would seem fairly easy...

 

I can't get past Required database tables not found. Please verify the database settings in includes/db.php. If the database tables have prefixes, set the prefix in includes/db_tables.php

 

I have modified db.php with the same user name, db name, password, and server name as my ZenCart settings.  I can login to MyPHP Admin with the same settings.  I have also configured the database prefix since all of mine are zen_ .

 

I also went into db_tables and added the prefix but that didn't help either.

 

Something obvious I'm missing?

Share this post


Link to post
Share on other sites

Lol, I'm sometimes to impatient for my own good.   So I started digging in and stepping through the different files, after I did more work than needed I started over and started reading through the install.php.  Checked to make sure files were all there that it was looking for, then came across the test table statement.  I modded the statement to include the zen_ prefix, saved and the installer worked, except everything doubled to zen_zen_ since I added the prefix to db.php and db_tables in my fiddling around.  So I cleaned that up and started clean.

 

So for those trying to get this working on Zen it still works.

Share this post


Link to post
Share on other sites

I'm glad you figured out the problem! I was just going to post something similar to what you already figured out.

 

-jared

Share this post


Link to post
Share on other sites

And I'm back.....

 

Has anyone had experience with EPN and getting Autorize.net setup?  EPN somehow emulates the Authorize.net transaction for Zencart.  I've gone through and configured my ID, trans key, and am using EPN's link provided here - https://www.eprocessingnetwork.com/developers.html

 

When I submit a card, I get This site says - Processing Error.  I can't seem to get by that right now.

Share this post


Link to post
Share on other sites

Harvey,

 

This is a feature not (yet?) included in ocPOS. I realize that it's a pain, but I just never got time to update the pricing functions to have an option to include VAT in pricing versus list VAT separately.

 

-jared

 

I have rewritten the function to get tax rates. I have tested it on my installation and it works. If someone else could test it and report back that would be great.

 

 

 

First of all BACKUP!! BACKUP!! BACKUP!!

 

Then open /includes/db_tables.php in your POS folder and add the following line before the closing ?>

define('GEO_ZONES', $table_prefix . 'geo_zones');

Then open includes/functions.php in your POS folder and find the GetTax function (around line 284 in version 2.5)

 

Delete or comment out these lines

function GetTax($product_id) {

# This function needs to return a product's tax rate(s) and description(s).
# For tax totaling reasons (think HST/GST/PST), we need to return an array
#   with each tax_rates.tax_rate and tax_rates.tax_description that apply to this product
#   sort taxes by priority

    $store_zone_id = GetStoreZoneID();

    if ($product_id > 1000000000) {
        $tax_lookup_sql = "SELECT tr.tax_rate, tr.tax_description, tax_priority
                 FROM " . TAX_RATES . " tr
                 JOIN " . ZONES_TO_GEO_ZONES . " z2g on z2g.geo_zone_id=tr.tax_zone_id
                 JOIN " . ZONES . " z on z.zone_id=z2g.zone_id
                 WHERE z.zone_id = '" . $store_zone_id . "'
                 ORDER BY tax_priority ASC";
    } else {
        $tax_lookup_sql = "SELECT tr.tax_rate, tr.tax_description, tax_priority
                 FROM " . PRODUCTS . " p
                 JOIN " . TAX_RATES . " tr on p.products_tax_class_id=tr.tax_class_id
                 JOIN " . ZONES_TO_GEO_ZONES . " z2g on z2g.geo_zone_id=tr.tax_zone_id
                 JOIN " . ZONES . " z on z.zone_id=z2g.zone_id
                 WHERE z.zone_id = '" . $store_zone_id . "' and p.products_id = '" . $product_id . "'
                 ORDER BY tax_priority ASC";
    }

    $tax_lookup_query = oc_query($tax_lookup_sql, 'SQL Error. Tax detail lookup failure.');

    $i = 0;
    $tax_array = array();

    while ($tax_lookup_result = mysql_fetch_array($tax_lookup_query)) {
        $tax_array[$i]['tax_description'] = $tax_lookup_result['tax_description'];
        $tax_array[$i]['tax_rate'] = $tax_lookup_result['tax_rate'];
        $tax_array[$i]['tax_priority'] = $tax_lookup_result['tax_priority'];
        // $tax_array[$i]['tax_total'] = 0;
        $i++;
    }

    return $tax_array;
}

// end function GetTax

and replace with these lines:

//Function GetTax
function GetTax($product_id) {

# This function needs to return a product's tax rate(s) and description(s).
# For tax totaling reasons (think HST/GST/PST), we need to return an array
#   with each tax_rates.tax_rate and tax_rates.tax_description that apply to this product
#

	$store_zone_id = GetStoreZoneID();
	$country_query_sql = "select zone_country_id from " . ZONES . " where zone_id = '" . $store_zone_id . "'";
	$country_id_query = mysql_query($country_query_sql);
	$country_id_result = mysql_fetch_array($country_id_query);
	$country_id = $country_id_result['zone_country_id'];

    if ($product_id > 1000000000) {
		$tax_lookup_sql = "select SUM(tax_rate) as tax_rate, tr.tax_priority, tr.tax_description from " . TAX_RATES . " tr left join " . ZONES_TO_GEO_ZONES . " za ON tr.tax_zone_id = za.geo_zone_id left join " . GEO_ZONES . " z ON z.geo_zone_id = tr.tax_zone_id WHERE (za.zone_country_id IS NULL OR za.zone_country_id = '0' OR za.zone_country_id = '" . (int)$country_id . "') AND (za.zone_id IS NULL OR za.zone_id = '0' OR za.zone_id = '" . (int)$store_id . "') GROUP BY tr.tax_priority";
    } else {
		$tax_lookup_sql = "select SUM(tax_rate) as tax_rate, tr.tax_priority, tr.tax_description from " . TAX_RATES . " tr left join " . PRODUCTS . " p on p.products_tax_class_id = tr.tax_class_id left join " . ZONES_TO_GEO_ZONES . " za ON tr.tax_zone_id = za.geo_zone_id left join " . GEO_ZONES . " z ON z.geo_zone_id = tr.tax_zone_id WHERE (za.zone_country_id IS NULL OR za.zone_country_id = '0' OR za.zone_country_id = '" . (int)$country_id . "') AND (za.zone_id IS NULL OR za.zone_id = '0' OR za.zone_id = '" . (int)$store_id . "') and p.products_id = '" . $product_id . "' GROUP BY tr.tax_priority";
  
		
    }
    
	$tax_lookup_query = mysql_query($tax_lookup_sql) or die ("SQL Error. Tax detail lookup failure.  <br><br>SQL = $tax_lookup_sql");
    
    $i = 0;
    $tax_array = array();
    while ($tax_lookup_result = mysql_fetch_array($tax_lookup_query)) {
        $tax_array[$i]['tax_description'] = $tax_lookup_result['tax_description'];
        $tax_array[$i]['tax_rate'] = $tax_lookup_result['tax_rate'];
		$i++;
    }
	
	
    
    return $tax_array;

}

//end Function GetTax 

Should work with version 2.1 as well.


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

Hi, I can't log in to OllaCart I get the error message: php_network_getaddresses: getaddrinfo failed: No such host is known.

 

Any help is welcome.

 

Thanks.

Share this post


Link to post
Share on other sites

Is this for a version you downloaded here from oscommerce.com, or an earlier version?

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

×