Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Well wouldn't you know!


Recommended Posts

Are there people who install contributions professionally for others? I have reset my site (deleted and re-added my domain) about 6 times. I have reset my mySQL server (deleted and re-added a database) about 3 times. All I want is to be able to list sizes IN ORDER and keep track of the quantity of sizes of each item. I have installed QTYPro and it works fine but when I tried to add a contribution that would sort the attributes in order it told me to add a small change in my catalog/product_info.php. The line that you are supposed to add the change to DOES NOT exist in the product_info.php that came with QTYPro, so I replaced it with my original product_info.php which DID contain the line I am supposed to add the change under. Now nothing works. I am seriously ready to cancel my subscription and be done with this mess. Why doesn't osc2.2 come with attributes already sorted and able to track the stock of each item attribute???? I really need some help installed these two attributes to track stock and sort the order if anyone can help. IT'S BEEN 4 DAYS NON-STOP OF THIS CRAP!

Link to comment
Share on other sites

please, you posted this same thing yesterday. continue in the same thread, not a new one. and if you are having problems, rather than knocking everythinig, state what the exact problem is and seek help. do not post tons of things, rambling on but specif things.

Link to comment
Share on other sites

cancel your subscription to what?

 

To the host that is supplying me with a site equiped with osc2.2. I am at a fresh start now, I do not have any attributes added. Now I can get the attributes of the sizes to sort in the order of my choice by adding "order by pa.options_values_id");" in my products_info.php file. When I install QTYPro to keep track of the quantity of each attribute, another product_info.php file comes with it that does NOT include the text that you add "order by pa.options_values_id");" to. How would I make the attributes sort if I have QTYPro installed is the question? After figuring this out.. I am going to leave it alone.

Link to comment
Share on other sites

To the host that is supplying me with a site equiped with osc2.2. I am at a fresh start now, I do not have any attributes added. Now I can get the attributes of the sizes to sort in the order of my choice by adding "order by pa.options_values_id");" in my products_info.php file. When I install QTYPro to keep track of the quantity of each attribute, another product_info.php file comes with it that does NOT include the text that you add "order by pa.options_values_id");" to. How would I make the attributes sort if I have QTYPro installed is the question? After figuring this out.. I am going to leave it alone.

 

 

To get these 2 contributions to work together, you need to edit the attributes code for qtpro to sort the attributes according to your set order.

 

This willl not just be a text replace, or a search after instruction from the sort order contrib instructions.

 

You will need to first find out where and how the sort order is added in the compare to the original query statements, then you will have to go into the qtpro code and modify the query statements there to include the sort order.

Link to comment
Share on other sites

I have installed a new domain, set up a brand new database, and downloaded the newest QTpro4.2a version. I installed the two .sql tables first, and then procceeded to copy the files from the QTpro4.2a folder to my OSC folders. The stock button appears correctly, but I am recieving this error upon clicking "Stock" to add the quantity of each attribute:

 

1054 - Unknown column 'products_options.products_options_track_stock' in 'where clause'

 

select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from products_description, products_attributes,products_options,products_options_values where products_attributes.products_id=products_description.products_id and products_attributes.products_id=1 and products_attributes.options_id=products_options.products_options_id and products_attributes.options_values_id=products_options_values.products_options_v

alues_id and products_description.language_id=1 and products_options_values.language_id=1 and products_options.products_options_track_stock=1 and products_options.language_id=1 order by products_attributes.options_id, products_attributes.options_values_id

 

[TEP STOP]

 

These two tables created in mySQL database and the files copied from the QTpro4.2a folder are the ONLY files that have been touched. I should NOT be getting a missing column error should I?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...