2096 replies to this topic

[Ozzy666]

coffman, on Oct 9 2003, 04:57 AM, said:

OK.  One more small issue.  After entering the stock.php page to update stock, there are 2 links at the bottom of the page. 

The one on the right is titled "Back to Low Stock Report for Attributes".  The link for this is defined as FILENAME_STATS_LOW_STOCK_ATTRIB. 

Where is this supposed to be defined and what should it be pointing to?  I find no other reference to it in the code 

Thanks

Same problem!!

Can anyone help?

[hardcharger]

Does anyone know if you need to have version 2.0 loaded before installing 2.1?
I installed 2.1, but I am getting an error that says it can't find order_details.php which is located in includes/modules in version 2.0????

[hardcharger]

Radders, when you QTpro notes, where do I get those?

[hardcharger]

So, basically this version works just fine when you implement the code changes as opposed to loading the replacement files?

[uslackeru]

Keep getting a fatal error when trying to use this contribution for MS2

Fatal error: Call to undefined function: tep_get_categories_name() in /.../catalog/index.php on line 232

Any help?

Has anyone been using this successfully with MS2.  I have a pretty new install very few modifications. And this was my first trial on any of the contributions.

Having inventory for the attributes is a big plus, if I can get this sucker to work.

Did I need to install an earlier version before this one?

[coffman]

uslackeru, on Oct 28 2003, 11:02 PM, said:

Keep getting a fatal error when trying to use this contribution for MS2

Fatal error: Call to undefined function: tep_get_categories_name() in /.../catalog/index.php on line 232

Any help?

Has anyone been using this successfully with MS2.  I have a pretty new install very few modifications. And this was my first trial on any of the contributions.

Having inventory for the attributes is a big plus, if I can get this sucker to work.

Did I need to install an earlier version before this one?

I don't know why you are getting the error, but I do know it is possible to get it working.  I have it working.   It took a bit of time to get it into my customized site, but it was well worth it..

As for your error, I can't find the function tep_get_categories_name anywhere in my tree and I have QTPro up and running.   Do you have other modules installed? Could you have introduced a syntax error when installing QTPro?

[uslackeru]

coffman, on Oct 29 2003, 05:15 AM, said:

As for your error, I can't find the function tep_get_categories_name anywhere in my tree and I have QTPro up and running.   Do you have other modules installed? Could you have introduced a syntax error when installing QTPro?

I have no other  modules running and have made only minor changes to the CSS and column sizing etc. nothing to any real coding.

[Jeremy]

Can someone PLEASE get this working with the latest oscommerce release?  I literally can not open my site to the public until this feature is working....

[coffman]

Jeremy:

I am not an expert, but have gotten this working fine on my store which is running  MS2.2.  What is not working?

[Jeremy]

Everything.  I installed the most recent contribution released on 09/06/2003, called QTPRO 2.1 update for MS2 and made by freezehell.  Is this what you are using?  I downloaded that, ran the .sql querry in phpMyAdmin, then just ported the files over from the zip to my directory and nadda.  Nothing happens.

[Jeremy]

And just to add, I am a VERY experienced modification installer for Invision board and other software, I am not a clumsy newbie.  

[samhaddow]

I've integrated the QTpro contrinb into my system with help from coffman, but i've got what i think is a bug.

I can't reproduce this all the time for some reason.

I have a product  Black, Size: 16, quantity of 1.

I'm trying to change the sizes from 16 to Large, and to do that i wan't to delete the stock. Usually I change the stock to zero - sometimes it disapears from the list, and sometimes it set the quantity on the list to 0.

When i do this today, i get the following error.

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where products_id=53' at line 1

update products set products_quantity= where products_id=53

[TEP STOP]

As a temporary measure, where can i make the changes in the database to delete this stock entry?

Any ideas would be very much appreciated, i'd really like to sort this out.

Sam

[samhaddow]

Additional, it's seems it didn't like deleting the only entry in that list.

I added a Black - Small - 1 and then set it to zero (deleting it) no worries.

Curious stuff.

[coffman]

Jeremy:

My  Installation.html says

Quote

QTPRO 2.1 Update for osCommerce 2.2 MS2 ONLY

I did not copy the files into place, but hand edited my files as I have made quite a few mods I wanted to keep.    

So you installed all the admin and catalog files?

You have added attributes, like color, and left them designated as "Special = NO".  Then given the att's values like red, green, blue.  Then attached the att's to a product?  And the tracking does not work?

Do you not get the stock button in the admin/categories.php page?

What happens when you call stock.php directly as in:

  http://your.store.com/admin/stock.php?product_id=24

  24 being a number to a valid item in your catalog?

In other words.  What exactly is not working, and what are you expecting?

Don't give up as this contrib is definatly worth it.  I won't be able to respond again until tonight, MST that is, as I am off to my real job now

[Ozzy666]

I have installed the qtpro 2.1 update in my osc 2.2 ms2 shop - and it works - almost!

but -- there are two main problems:

1. The products are not filtered in the products_info.php!

Why should I track my products and the customer isn't able to see if the product is in stock? Without customer information about availability of a product the qtpro addon makes no sense.

2. The ordered products are not subtracted from the products_stock table in the database. So multiple orders of products are possible even if only 1 piece is in stock!

I'm using the following contrib to inform my customers if product is in stock (added the following lines into product_info.php). But this considers only the stock which is in the products table!

<?php
  $prod_quantity = tep_get_products_stock($products_id);
  switch ($prod_quantity) {
      case 0:
      print '<img src="images/stock_soldout.gif" border="0">';
      break;
      case 1:
      print '<img src="images/stock_limitedstock.gif" border="0">;
      break;
      case 2:
      print '<img src="images/stock_limitedstock.gif" border="0">';
      break;
      case 3:
      print '<img src="images/stock_instock.gif" border="0">';
      break;
      case 4:
      print '<img src="images/stock_instock.gif" border="0">';
      break;
      default:
      print '<img src="images/stock_instock.gif" border="0">';
  }
  ?>

Any ideas how to get the real stock from products with options added with qtpro?

I would be happy if someone could help with a piece of php code!

[Jeremy]

I just used Beyond Compare to compare my files to the ones in the zip, and copy and pasted the the differences.  Everythings works now, after some major testing, it all seems to be in order.  Thank you for being so eager to help Michael, people like you can turn a regular online community into something great.

[Jeremy]

Ok, another thing...does anyone know how to actually omit an attribute from the selection on the product info page if the quantity is zero?  I know a contribution for QTpro was released to do this, but it is now compatible with the latest release.  It is very important that when I run out of a certain size, that it is no longer even selectible.  I know I can remove the attribute from the product, but this is to be for an EXTREMELY busy store, products will be running out all the time and will not be reordered.  I need the store to sort of "take-care-of-itself".  Any ideas?

[redg8r]

Man I must be missing something....

First, for those successful at implementing....... Did you use the 2.1 contrib for MS2 update alone, or did you upgrade from a previous contrib version?

I have tried & tried on a fresh MS2 install, but this contrib doesnt exist as far as I can see.

I even used Beyond Compare as Jeremy described.
My Attributes section of the admin looks no different than before.

I did try & load admin/stock.php in the browser & was given a syntax error:
====================
near 'and products_attributes.options_id=products_options.products_op
====================

by the response in the forum, Its obvious that this is a much needed feature, however the lack of documentation or any real explanation of how this contrib works has me very confused.

If anyone has successfully implemented qtpro 2.1 on a fresh MS2 install, I would love some basic insight.
Looks like most of the documentation was on the authors site & is now gone.

Thanks

[radders]

Maybe Master Products is the way to go if you are running an MS2 store. It seems to address many of the same things as QTPro in a very straightforward way. I was quite excited to find the new contribution.

[Jos Medinger]

Hi there guys

I have installed the QTPro 2.1 update into my MS2 V2.2 store and I seem to have got all the pages working apart from the point at which I actually want to add stock to the attributes

I am getting the following error messages all relating to the stock.php file in admin

Warning: Variable passed to each() is not an array or object in /home/.sites/33/site5/web/catalog/admin/stock.php on line 26

Warning: Wrong datatype in sort() call in /home/.sites/33/site5/web/catalog/admin/stock.php on line 33

Warning: Bad arguments to join() in /home/.sites/33/site5/web/catalog/admin/stock.php on line 34
1064 - You have an error in your SQL syntax near ''',)' at line 1

insert into products_stock values (0,,'',)

[TEP STOP]

Can anyone shed any light on why these are occurring and if so offer any advice

I'd be most grateful

Regards

Jos Medinger