2096 replies to this topic

[Sammin]

After installing this add-on, having numerous problems, then fixing them, I now have a new question.

When in the admin of my shop, and I go to Reports -> Stock Report, I see that the products are sorted in alphabetical order, however, I would like to see them sorted in numerical order using my product numbers.

Does anyone know how to do this? It would really help and I'm pretty sure that I am not the only person who would like this.

Thanks in advance to anyone who can help me out.

Edited by Sammin, 05 August 2012 - 06:16 PM.

[greimm]

Still having this error deleting a product option with QTPro:

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_options_id = '2'' at line 1

delete fromproducts_options where products_options_id = '2'

[TEP STOP]

All the rest is working ok, but I have to delete it in the DDBB

osCommerce Online Merchant v2.2 RC2a

PHP Version: 5.3.8

Any solution??

[epwork]

epwork, on 29 July 2012 - 11:32 PM, said:

I've installed QTPro on OScommerce 2.3.2 and made the corrections as suggested:

1. deleted loose bracket } from product_info.php mine was on line 223, before first QT Pro: End (my product pages were not displaying until this was fixed)
2. added back codes after all echo ' in admin/products_attributes file (my Prod Attributes in Admin was blank until fixing this)
3. Found Track Stock check box in Admin >Catalog > Prod Attributes, turned on for my Sizes
4. made my choices in Admin > Config > Prod Info (QTPro), displaying fine as desired on site
5. Started adding stock values to products with attributes, working like a charm, QTPro doctor is quite handy

PROBLEM: All was looking fine except products with a stock attribute are not being added to the Shopping Cart.  Anything without an attribute is adding to cart and checking-out fine. I have set to display cart after adding product. Nothing is there on these items.
No errors are displayed.

Here's a product link to try.

Any suggestions on where to start troubleshooting would be greatly appreciated.

Thanks in advance,
Tiffany

bueller buellerr? No suggestions - bummer. Well, I need to ensure customers can purchase so will have to turn off stock tracking for now. Please forward any suggestions that may would cause this to happen. I have check each file like 4 times. I'm not aware of any other add-ons i have that would conflict either.

Edited by epwork, 07 August 2012 - 05:18 AM.

[devoidofodors]

greimm, on 06 August 2012 - 11:44 AM, said:

Still having this error deleting a product option with QTPro:

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_options_id = '2'' at line 1

delete fromproducts_options where products_options_id = '2'

[TEP STOP]

All the rest is working ok, but I have to delete it in the DDBB

osCommerce Online Merchant v2.2 RC2a

PHP Version: 5.3.8

Any solution??

make this:
delete fromproducts_options where products_options_id = '2'

look like this:
delete from products_options where products_options_id = '2'

try that out.

[devoidofodors]

Running:
osc 2.3.2,
qtpro 4.6.1_1 (NOTE: This contribution needs A LOT of improvements before I would recommend using it.)

Something I noticed in  admin/products_attributes.php:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1062 - Duplicate entry '1-1' for key 'PRIMARY'

insert into products_options (products_options_id, products_options_name, language_id, products_options_track_stock) values ('1', 'Color', '1', '0')

[TEP STOP]

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

When updating an existing Product Option (to track stock), I get that SQL error.
The database query is inserting a row when it should be updating a row.

I should come up with a fix soon and post it for anyone else who has run into a similar issue.

[madgasman]

Hi All
I have just installed PayPal Website Payments Pro Hosted Solution, and each time someone places an order I have sick products.

Can anyone help?

Oscommerce 2.3

[McKyavelik]

Hello World

I'm trying to install QT Pro contribution to an existing shop with an installed full template I'd buy from a provider. I've asked them, but they don't give support for third-party addons, so I'm stuck on that because I don't know much PHP and I'm new on osCommerce system.

I'd follow the installation guide step by step, but I found some differences between the "find this" code and my code. I think I can understand that those differences were made on template installation and they are needed to it to work, but I don't know how to merge QTP code to both work fine together.

Do somebody think can help me in any way.

I'm running an 2.3.1 oscommerce with some features brought by the template installed.

Thanks in advance.
Regards.

[Sumisu]

Hi

Im having problems with the radio option on the product page... with no changes to the class files and product_info page, everything else works great, but the radio option doesnt add anything at all to the cart.

Is there any reason why this might occur?
looking at the html source of the form it should work, I cant understand why it's not being sent to cart.

Desperately need the help on this one as I CANT use the dropdowns in this design.

I dont believe it to be a contrib conflict as all other form dropdown elements from QTPro work perfectly fine.

This is the input generated for one of the radio buttons:

<input type="radio" checked="checked" value="2-14" name="attrcomb">
Any reason why the value wouldnt be sent to cart on post?

If you have no idea... please could somebody advise on which files are being utilised to add item to cart please... I'm searching through and I'm sure there's something I've missed.

Thanks

Edited by Sumisu, 21 October 2012 - 11:25 PM.

[Sumisu]

Actually.. update!  it doesnt work with single_dropdown either.. so both single display plugins... that narrow it down?

[altoid]

html validation issue with qt pro - tip on where to find the source

when running the w3c markup validation service i was getting validation errors that had to do with the available options drop down box for product listings.   in my case the source of the errors was coming from two files, pad_base and pad_multiple_dropdowns,  both located in catalog/includes/classes.

if you are having an html validation issue as per above, take a look there for the source.   the issues is how single and double quotes are situated in the code itself.

modified files attached

 pad_multiple_dropdowns.php   7.12K   4 downloads
 pad_base.php   15.47K   1 downloads

disclaimer...read my signature

[NaturesPond]

I just installed QT PRo and instead of one drop down box I am getting two.  I do have it configured for a single dropdown.  The difference between to the 2 dropdowns is one has the "out of stock" message next to the attributes (which it should) and the other does not.  I deleted all of my attributes and started over and as soon as I add an attribute to an item the two drop downs show up.  One drop down is correct with out of stock message the other is not.  Does anyone know why I am getting 2 drop downs?

[NaturesPond]

Also, if I try to add an item that has attributes to the shopping cart it just says "Your Shopping Cart is Empty" and is not adding the item to the shopping cart.  If I try to add an item that does not have attributes it works just fine.  What could be the problem?

[Spiralx]

Sumisu, on 21 October 2012 - 11:11 PM, said:

Hi

Im having problems with the radio option on the product page... with no changes to the class files and product_info page, everything else works great, but the radio option doesnt add anything at all to the cart.

Is there any reason why this might occur?
looking at the html source of the form it should work, I cant understand why it's not being sent to cart.

Desperately need the help on this one as I CANT use the dropdowns in this design.

I dont believe it to be a contrib conflict as all other form dropdown elements from QTPro work perfectly fine.

This is the input generated for one of the radio buttons:

<input type="radio" checked="checked" value="2-14" name="attrcomb">
Any reason why the value wouldnt be sent to cart on post?

If you have no idea... please could somebody advise on which files are being utilised to add item to cart please... I'm searching through and I'm sure there's something I've missed.

Thanks

I also have the same issue where Radio Set option does not add product to cart.

[Spiralx]

Spiralx, on 22 November 2012 - 02:31 AM, said:

I also have the same issue where Radio Set option does not add product to cart.

Looks like the problem is in the application_top.php file. It stems from a another mod altering the 'add_product' case. Eliminating the mod solves the issue.

[NaturesPond]

NaturesPond, on 21 November 2012 - 07:20 PM, said:

Also, if I try to add an item that has attributes to the shopping cart it just says "Your Shopping Cart is Empty" and is not adding the item to the shopping cart.  If I try to add an item that does not have attributes it works just fine.  What could be the problem?

Figured out this problem.  In case anyone else has a similar problem I did the following:

in product_info.php file I removed a } before       require(DIR_WS_INCLUDES . 'template_bottom.php');

added a } between php above <div style="clear: both;"></div>

and removed a } above if (is_string($HTTP_GET_VARS['products_id']) && isset($cart->contents[$HTTP_GET_VARS['products_id']]

[NaturesPond]

Sammin, on 12 July 2012 - 05:35 PM, said:

Hey there, I don't know if this has already been answered, but I don't fancy looking through 103 pages to find out.

My problem is that I downloaded the add-on for 2.3 from http://www.oscommerce.com/community/contributions,7786/category,3/search,qt and after installing the add-on, each of my product pages displays the 'Available options' twice. Does anyone know how to get rid of the original one that was there before the add on?

Hi Sammin - I am experiencing the same problem did you ever figure out how to remove the extra available options?

[NaturesPond]

NaturesPond, on 21 November 2012 - 05:52 PM, said:

I just installed QT PRo and instead of one drop down box I am getting two.  I do have it configured for a single dropdown.  The difference between to the 2 dropdowns is one has the "out of stock" message next to the attributes (which it should) and the other does not.  I deleted all of my attributes and started over and as soon as I add an attribute to an item the two drop downs show up.  One drop down is correct with out of stock message the other is not.  Does anyone know why I am getting 2 drop downs?

After much trial and error I figured out how to remove the extra available options dropdown (that is the original oscommerce available options dropdown). I am posting this incase anyone else runs into the same problem after installing QT Pro (which I wish the 5+ people who posted the same issue in this forum had done when they discovered the fix!  DUH!)

So  In the catalog/product_info.php file remove the following lines of code:

?>
  <strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?><br />
<?php

and

<p><?php echo TEXT_PRODUCT_OPTIONS; ?></p>

[rbrookstx]

everything is working except that I need to add an additional line of text next to the option values and I havent' been able to find it.  basically I want to display a color swatch next to the label (ie color: purple the option will say purple and have an image of the purple swatch).  I have created my swatches and they match the attribute id (ie purple is attribute id 131 and my swatch is named 131.png).  any idea on how to make this work?

[dunklow]

With the automatic solution provided from qtpro, I can re-set the summary stock to options stock, one product at a time. However, I have thousands of products, is there a one click solution to this, so I don't need to go through each sick product? Thank you!

[Sunmanuk]

Qtpro 4.6.1 and OSC 2.3.3

Has any one tried this combination successfully ?

If so any pointers to gotchas would be appreciated

im looking at upgrading from OSC2.3.2

many thx in advance